Skip to content
Queria Docs
Esc
↑↓navigate↵open⌘Jpreview
On this page

Area analysis

How to count the area around a location and overlay your own address list on the map in Area analysis

In Area analysis, click the map and press “Analyze around here” in the popup, or search for a station or address in the search box at the top left of the map, to choose a location. The population, households and land prices around it are shown with a map. The summary appears in “Map info” on the left. When you choose another location, a new tab such as “Area 2” or “Area 3” is added and the earlier summary is kept. Click a tab to switch to that location’s summary; locations that are not selected are shown on the map as dashed circles. Click × on a tab to remove that location. Radius and travel mode changes apply to the location in the open tab. Click “Layers” at the top of the screen and pick a layer from the list to overlay population, land prices, stations, shops and more on the map. For a point layer, use the filter button on the layer to show or hide each type. Use the “Hover” button on the layer to choose the title column and the other columns shown when you hover over a point. “Rename columns” in the same menu changes the column names shown on hover and in the legend. Click a point on an overlaid layer to write a note for it. Notes are saved with the map and shown first on hover; the dataset is not changed. If you publish a map that has notes, the notes are published too. Click an area colored by an overlaid layer to see its name and value in a popup.

Overlay an address list on the map

Load a CSV file that lists the addresses of shops or customers, and the addresses are geocoded and shown as points on the map.

  1. Click “Layers” at the top of the screen, then click “Load address list”
  2. Select a CSV file (UTF-8 or Shift_JIS) with column names in the first row. Up to 1,000 rows can be loaded at a time
  3. Choose the “Address column” and, if needed, the “Name column”. With a name column, the name appears when you hover over a point
  4. Click “Load” to add a layer named after the file. Rows that could not be geocoded are not shown on the map

The loaded file stays in the open tab until you click “Save to Queria”. Only the address column is sent to the Queria geocoder to get latitude and longitude.

SQL can read the loaded table as my.<name>. The name comes from the letters and digits in the file name. When it does not start with a letter, addresses_ is prepended, and a file name with no letters or digits becomes addresses. In “AI chat” on the right, ask to join it with open data and overlay the result.

SELECT * FROM my.addresses WHERE lng IS NOT NULL

Loaded tables are cleared when the tab is reopened. When you open a saved map again, the layer shows “Select file again”; select the same file again.

Save an address list to Queria

You can save a loaded address list as a private dataset. A saved list is shown when the tab is reopened, without selecting the file again.

  1. Click “Save to Queria” under the address list layer
  2. Check the “Dataset name”. It must start with a lowercase letter and contain only lowercase letters, digits and _
  3. Click “Save”. A private dataset is created in your account, and the layer switches to SQL that reads the dataset

The saved dataset has one table, main.places. Its columns are the columns of the original CSV, the geocoder columns (lat, lng, lg_code, estat_small_area_code, match_level and others) and verified (always true). Saving again with the same name creates a new version of the same dataset. A list cannot be saved under the name of an existing public dataset.

SELECT * FROM shops.main.places WHERE lng IS NOT NULL

Address lists cannot be loaded on maps made by other people, and address list layers loaded by the author are not shown.

Was this page helpful?