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
Omdurman 1200000 15.64 32.48
Muhafazat Diyala 1244425 34.0 45.0
Provincia di Torino 2297598 45.13 7.37
Cangzhou 527681 38.32 116.87
Shangyu 770000 30.02 120.87
Mohafazat Liban-Nord 899339 34.33 35.92
Izmir 2500603 38.41 27.14
Kigali 745261 -1.95 30.06
Sumatra 50365538 0.0 102.0
Republic of Angola 13068161 -12.5 18.5
Changwat Surat Thani 991524 9.17 99.25
Reunion 776948 -21.1 55.6
Sichuan Sheng 87250000 30.5 102.5
Lancaster County 519445 40.25 -76.25
Sokoto 563861 13.06 5.24
East Sussex 757600 50.92 0.33
Srinagar 975857 34.08 74.82
Morelia 592797 19.7 -101.18
Port Said 538378 31.26 32.28
State of Punjab 24289296 30.92 75.42

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query