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 Huelva 513403 37.67 -7.0
Sherpur District 1340379 25.08 90.08
Departement de la Marne 566491 48.92 4.17
Nawalparasi 621622 27.67 83.92
Region de Sikasso 1773516 10.92 -7.0
Tokat 875651 40.42 36.58
Galicia 2796089 42.76 -7.87
Chuadanga District 1103147 23.63 88.85
Changwat Tak 540055 16.58 98.83
Zaria 975153 11.11 7.72
Provincia di Taranto 580525 40.62 17.25
Changwat Ubon Ratchathani 1691441 15.17 105.17
Donets'k 1024700 48.02 37.8
Federal Democratic Republic of Ethiopia 88013491 8.0 38.0
Region de Kayes 1805959 14.0 -11.0
Essen, Stadt 576259 51.45 7.01
Republic of Bulgaria 7148785 43.0 25.0
Essen 593085 51.45 7.02
Trujillo 747450 -8.12 -79.03
Departement d'Indre-et-Loire 583086 47.25 0.75

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query