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
Patuakhali District 1464685 22.33 90.33
Sydney 4394576 -33.87 151.21
Amritsar 1092450 31.63 74.87
Departement du Haut-Rhin 742408 48.0 7.33
Middlesex County 809858 40.43 -74.4
Region Sjaelland 820564 55.42 11.83
La Plata 694167 -34.92 -57.95
Estado de Jalisco 6653364 20.33 -103.67
Brahmanbaria District 2141745 23.98 91.17
Dorset 701100 50.75 -2.33
Natal 803811 -5.81 -35.23
Muhafazat Hawalli 510436 29.28 48.0
Campo Grande 729151 -20.44 -54.65
Amman 1275857 31.96 35.95
Arrondissement de Nimes 510948 43.92 4.42
Departement du Nord 2564950 50.33 3.67
Comunidad Autonoma de Canarias 2103992 28.0 -15.5
Hudson County 634266 40.72 -74.07
Khartoum 1974647 15.55 32.53
Joinville 515250 -26.27 -49.0

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query