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
Shivaji Nagar 1000000 18.53 73.85
Anyang 634367 37.39 126.93
Wojewodztwo Pomorskie 2199043 54.25 18.25
Buckinghamshire 712100 51.75 -0.75
Oresund Region 3583842 55.7 12.8
Stadtkreis Stuttgart 601646 48.78 9.18
Cook County 5194675 41.83 -87.85
Democratic Republic of Timor-Leste 1154625 -8.83 125.75
Changwat Yala 524191 6.33 101.25
Kreisfreie Stadt Frankfurt am Main 671927 50.13 8.66
Departement de Meurthe-et-Moselle 726592 48.58 6.17
Arrondissement de Rouen 615662 49.5 1.0
Mosul 1739800 36.33 43.12
Mississippi 2901371 32.75 -89.75
Departement du Rhone 1677073 46.0 4.5
Provincia di Foggia 640891 41.45 15.53
Maceio 932608 -9.57 -35.69
Sorocaba 558862 -23.5 -47.46
Krasnoyarskiy Kray 2845899 58.0 93.0
Changwat Lampang 823111 18.33 99.5

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query