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
Region de Saint-Louis 732667 16.33 -15.0
Regione Autonoma Trentino-Alto Adige 1028260 46.5 11.33
Reunion 776948 -21.1 55.6
Cucuta 721398 7.88 -72.51
Xinjiang Uygur Zizhiqu 21310000 42.57 85.46
Municipio Barinas 771756 8.61 -70.2
Union Territory of Chandigarh 1013325 30.75 76.8
Broward County 1748066 26.15 -80.48
Muenchen, Landeshauptstadt 1330440 48.13 11.57
Tampa-St. Petersburg-Clearwater 2733761 27.87 -82.51
Nova Iguacu 795212 -22.69 -43.51
City of Chicago 2695598 41.84 -87.68
Estado de Morelos 1680239 18.75 -99.0
Wilayat-e Samangan 599331 36.0 67.67
Okayama-shi 639652 34.66 133.94
Bucaramanga 571820 7.13 -73.12
Faryab Province 913866 36.25 64.83
Koutiala Cercle 575253 12.35 -5.58
Oresund Region 3583842 55.7 12.8
Cagayan Valley 3051487 17.66 121.73

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query