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
Osaka-shi 2592413 34.69 135.5
South Island 1027500 -43.0 171.0
Abia State 4222476 5.42 7.5
Kingdom of Denmark 5484000 56.0 10.0
Judetul Bacau 698735 46.42 26.83
Szabolcs-Szatmar-Bereg megye 576054 48.0 22.17
Estado de Nayarit 941442 22.0 -105.0
Departamento de Montevideo 1324115 -34.87 -56.18
Luoyang 1390581 34.68 112.45
Bosnia and Herzegovina 4590000 44.25 17.83
Imereti 703485 42.17 42.98
Ta`izz 615222 13.58 44.02
Khulna 1342339 22.81 89.57
Boston-Cambridge-Quincy 4522858 42.35 -71.06
Departamento de Boyaca 1255311 5.5 -72.5
Provincie Noord-Holland 2498931 52.58 4.92
Datong 1052678 40.09 113.29
Wojewodztwo Malopolskie 3298270 49.75 20.5
Futian Qu 1000000 22.54 114.11
Arrondissement de Toulouse 935689 43.58 1.5

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query