Query Builder
Analyze data using ad-hoc queries.
Center Zoom In Zoom Out Zoom To Fit
Tool
8°9.890' E:49°31.675' N 1:41000000
Clause: Table:
Spatial: Column:
Top 10 cities by population
SELECT TOP 10 [ID], [NAME], [COUNTRY], [POPULATION], [CAPITAL]
FROM [Cities over 5M Table]
ORDER BY [POPULATION] DESC;
Top 10 countries by area
SELECT TOP 10 [ID], [NAME], [SQMI_CNTRY]
FROM [Countries Table]
ORDER BY [SQMI_CNTRY] DESC;
All cities in Italy
SELECT CI.[ID], CI.[NAME], CI.[POPULATION]
FROM (TABLE [Cities over 2M Table] UNION TABLE [Cities over 5M Table]) CI
WHERE CI.[COUNTRY] = "Italy"
ORDER BY CI.[POPULATION] DESC;
All cities in the US within 200 miles of the border
SELECT DISTINCT CI.[ID], CI.[NAME], CI.[POPULATION]
FROM (TABLE [Cities over 2M Table] UNION TABLE [Cities over 5M Table]) CI, [Countries Table] CO
WHERE CI.[COUNTRY] = "US" AND CO.[NAME] <> "United States" AND Distance(CO.[ID], CI.[ID], "mi") < 200
ORDER BY CI.[POPULATION] DESC;
All rivers crossing Brazil
SELECT DISTINCT RI.[ID], RI.[NAME], RI.[SYSTEM]
FROM [Rivers Table] RI, [Countries Table] CO
WHERE CO.[NAME] = "Brazil" AND Touches(CO.[ID], RI.[ID]);
All countries whose currency contains the word "Dollar"
SELECT DISTINCT [ID], [NAME], [CURR_TYPE]
FROM [Countries Table]
WHERE [CURR_TYPE] LIKE "%Dollar%";