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
Kingdom of Lesotho 1919552 -29.5 28.25
Changwat Nakhon Pathom 790753 13.98 100.08
Louisiana 4515939 31.0 -92.0
Wilayat-e Jowzjan 747618 36.83 65.83
Port Elizabeth 967677 -33.92 25.57
Departamento de Narino 1541956 1.5 -78.0
Provincia di Bergamo 1087204 45.83 9.8
Ulhasnagar 516584 19.22 73.15
Kreisfreie Stadt Essen 576259 51.46 7.02
Belem 1392031 -1.34 -48.42
Republic of Zambia 13460305 -15.0 30.0
Provincia de Toledo 689635 39.83 -4.0
Cuiaba 521934 -15.6 -56.1
Belem 1407737 -1.46 -48.5
Northern District 1197985 32.83 35.33
Alameda County 1510271 37.6 -121.88
Funabashi 560743 35.69 139.98
East Riding of Yorkshire 587100 53.92 -0.5
Jinan 2069266 36.67 117.0
Melbourne 3730206 -37.81 144.96

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query