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
South Boston 571281 42.33 -71.05
Republic of Ghana 24339838 8.0 -2.0
Free State 2740946 -29.0 26.0
Tembisa 511655 -26.0 28.23
Tulsa County 603403 36.1 -95.9
Wojewodztwo Opolskie 1031097 50.5 18.0
Monmouth County 630380 40.3 -74.17
Coimbatore 959823 11.0 76.97
Zhuzhou 709358 27.83 113.15
Mecca 1323624 21.43 39.83
Anshan 1199275 41.12 122.99
Mombasa 799668 -4.05 39.66
Vancouver 1837969 49.25 -123.12
Changwat Maha Sarakham 936779 16.33 103.67
Contra Costa County 1049025 37.93 -121.93
Riverside County 2189641 33.73 -116.05
Departement de la Seine-Maritime 1244611 49.75 1.0
Shiraz 1249942 29.6 52.54
Long Island 7559372 40.82 -73.07
Thane 1261517 19.2 72.97

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query