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
Curitiba 1746896 -25.5 -49.29
Bucks County 625249 40.5 -75.37
Ilocos 4545906 16.98 120.52
Northern Region 1389000 -11.0 34.0
Bristol County 548285 41.83 -71.17
City of Detroit 713777 42.38 -83.1
Kwangju 1416938 35.15 126.92
King County 1931249 47.47 -121.82
Departement de la Vendee 607430 46.67 -1.33
Santo Domingo 2201941 18.5 -69.99
Monroe County 744344 43.15 -77.68
Oran 645984 35.69 -0.64
Compostela 637366 7.68 126.12
Kandy District 1277647 7.3 80.71
Hannover 515140 52.37 9.73
City of San Francisco 805235 37.77 -122.45
Somerset 895700 51.08 -3.0
Berlin, Stadt 3442675 52.52 13.41
Fengtai Qu 1753000 39.83 116.16
Icel 1877605 36.86 34.65

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query