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
Provincia de Zaragoza 970313 41.58 -1.0
Provincie Friesland 649777 53.17 5.83
West Bank 2771681 31.67 35.25
Judetul Arges 644458 45.0 24.83
Departement de Tillaberi 2017214 14.5 1.33
Al Hudaydah 617871 14.8 42.95
Philadelphia 1526006 39.95 -75.16
Provincie Noord-Holland 2498931 52.58 4.92
Hadiya Zone 1231196 7.5 37.75
Dakar Department 1030594 14.71 -17.46
Estado de Tlaxcala 1044369 19.42 -98.17
Jieyang 1001985 23.53 116.36
Horad Brest 1456779 52.1 23.7
Bahawalpur 552607 29.4 71.68
Kirkuk 601433 35.47 44.39
Departement d'Indre-et-Loire 583086 47.25 0.75
Changwat Phayao 512957 19.25 100.25
Dayan 1137600 26.87 100.22
Plateau State 3553440 9.17 9.75
Sinnar State 1502047 13.0 34.0

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query