NOTE: This page is experimental. Bug reports to carter.barry@gmail.com. Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT asciiname, population, ROUND(latitude/93206.744,2) AS truelat, ROUND(longitude/46603.37,2) AS truelon FROM geonames WHERE population > 500000 ORDER BY RANDOM() LIMIT 20

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

asciiname population truelat truelon
Regierungsbezirk Kassel 1224741 51.17 9.33
Wojewodztwo Lodzkie 2541832 51.5 19.5
Tunisian Republic 10589025 34.0 9.0
Departamento del Cesar 903279 9.33 -73.5
Dombivli 1193000 19.22 73.08
Regione Autonoma Trentino-Alto Adige 1028260 46.5 11.33
Wuxi 1108647 31.57 120.29
Teresina 814439 -5.3 -42.85
Teni 1034724 10.0 77.48
Judetul Prahova 814506 45.17 26.0
Zhenjiang 632552 32.21 119.43
Sendai-shi 1037562 38.27 140.87
Ohio 11467123 40.25 -83.0
Devon 1122100 50.75 -3.75
Provincia di Monza e della Brianza 840711 45.6 9.22
Andijan 1899000 40.75 72.33
Departement de la Loire 740668 45.47 4.43
Illinois 12772888 40.0 -89.25
Sacramento County 1418788 38.47 -121.32
Brisbane 958504 -27.47 153.03

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query