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
Province du Kasai-Occidental 4545940 -4.5 22.0
Hokkaido 5647230 43.06 141.35
Tsche-mul-p-ho 2628000 37.45 126.73
Milan 1306661 45.46 9.19
Estado do Rio Grande do Norte 3168133 -5.75 -36.0
Atsimo-Andrefana 1018500 -23.2 44.4
Province of Zamboanga del Norte 907238 8.0 122.67
Province of Northern Cape 819380 -29.5 22.0
Rheinland-Pfalz 4012675 49.67 7.5
Provincia de Maputo 997945 -25.5 32.33
Littoral Region 2192267 4.0 10.0
Montgomery County 971777 39.15 -77.2
Province of Palawan 682152 10.0 118.75
Meherpur District 639739 23.75 88.7
Province of Lanao del Sur 1138544 7.92 124.33
Province of La Union 720972 16.5 120.42
Pristina 550000 42.67 21.17
West Harerghe Zone 1871706 8.67 40.85
Masjid Jamie Baitul Muttaqien 1000000 -6.37 107.96
Taraba State 2688944 8.0 10.5

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query