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
Cross River State 3104446 5.75 8.5
Zhu Cheng City 1000000 36.0 119.4
Puerto Rico 3916632 18.25 -66.5
Provincia de Vizcaya 1152658 43.25 -2.92
Golden Horseshoe 8102163 44.49 -79.71
Nasik 1289497 19.98 73.8
Parish of Saint Andrew 555995 18.07 -76.75
Guangxi Zhuangzu Zizhiqu 48160000 24.0 109.0
Northern Region 1389000 -11.0 34.0
Tembisa 511655 -26.0 28.23
Malaysia 28274729 2.5 112.5
Provincia di Varese 876705 45.8 8.8
Cartagena 952024 10.4 -75.51
North Dakota 630529 47.5 -100.0
Province of Bulacan 2826926 15.0 121.08
Changwat Chiang Rai 1494052 19.92 99.92
Xi'an 3225812 34.26 108.93
Vatovavy-Fitovinany 1097700 -21.3 47.9
Sale 814871 34.07 -6.8
Departement des Yvelines 1403957 48.78 1.87

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query