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
Guatemala City 994938 14.64 -90.51
Republic of Mali 13796354 17.0 -4.0
Lima 7737002 -12.04 -77.03
Hong Kong 7012738 22.29 114.16
Khett Siem Reab 843191 13.5 104.0
Cordillera Administrative Region 1520743 17.09 121.03
Tianjin 3766207 39.14 117.18
Alameda County 1510271 37.6 -121.88
Tanintharyi Division 1383287 13.0 99.0
Regione Autonoma della Sardegna 1672404 40.0 9.0
Beni-Mellal 946018 32.5 -6.33
Bhilai 625138 21.22 81.43
Xianyang 1034081 34.34 108.7
Northern Mindanao 3952437 8.56 124.61
Changwat Tak 540055 16.58 98.83
Chandigarh 914371 30.73 76.79
Dar es Salaam 2698652 -6.82 39.27
Provincia di Messina 653810 38.05 14.87
Ul'yanovsk 640680 54.33 48.4
Kingdom of Lesotho 1919552 -29.5 28.25

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query