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
Ampara District 614674 7.08 81.75
Vancouver 1837969 49.25 -123.12
Damascus 1569394 33.51 36.29
Republic of India 1173108018 20.0 77.0
Havana 2163824 23.13 -82.38
Zaria 975153 11.11 7.72
Limpopo Province 5494928 -24.0 29.5
Daerah Muar 510376 2.25 102.75
Jodhpur 921476 26.29 73.03
Regierungsbezirk Oberpfalz 1081417 49.5 12.0
Hungary 9930000 47.0 20.0
Departement de la Loire-Atlantique 1246798 47.25 -1.83
Changwat Surat Thani 991524 9.17 99.25
Estado de Goias 6004045 -15.58 -49.64
Veracruz 568313 19.2 -96.13
Maracaibo 2225000 10.63 -71.64
Medan 1750971 3.58 98.67
Departement de Maine-et-Loire 770777 47.5 -0.33
Wojewodztwo Podkarpackie 2101732 50.0 22.0
Kuala Lumpur 1453975 3.14 101.69

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query