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
Fushun 1400646 41.86 123.92
Yorkshire 3978484 54.0 -1.5
Tyundyu 634596 36.64 127.49
Berlin, Stadt 3442675 52.52 13.41
Reunion 794107 -21.1 55.6
Muhafazat al Qalyubiyah 3881462 30.3 31.25
Portuguese Republic 10676000 39.5 -8.0
Bagcilar 724270 41.04 28.86
Zhuhai 501199 22.28 113.57
Provinsi Jawa Timur 35838814 -7.74 112.51
Culiacan 582469 24.8 -107.39
Teni 1034724 10.0 77.48
Hainan Sheng 8540000 19.2 109.6
Poltavs'ka Oblast' 1569479 49.5 34.0
Makassar 1321717 -5.14 119.42
Region du Ouaddai 738647 13.5 21.25
iProvense ya Gitega 675016 -3.5 29.95
State of Queensland 4264590 -20.0 145.0
Kent 1634500 51.17 0.67
City of Baltimore 620961 39.29 -76.61

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query