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
Harare 1542813 -17.83 31.05
Estado de Sonora 2351427 29.33 -110.67
West Yorkshire 2161200 53.7 -1.58
Province of Albay 1190823 13.22 123.55
Region Aquitaine 3150890 44.58 1.0
Municipio Barinas 771756 8.61 -70.2
Changzhou 949018 31.78 119.97
Wojewodztwo Podlaskie 1196101 53.0 23.25
Westchester County 949113 41.12 -73.8
Sao Luis 1011943 -2.65 -44.3
Muhafazat ash Sharqiyah 5109642 30.7 31.8
Arkansas 2757631 34.75 -92.5
Worcestershire 552900 52.17 -2.17
Compostela 637366 7.68 126.12
Provincia di Foggia 640891 41.45 15.53
Mashhad 2307177 36.3 59.61
El Paso 649121 31.76 -106.49
Ganzhou Shi 8900000 25.7 115.35
Zhejiang Sheng 51200000 29.0 120.0
Qinghai Sheng 5540000 36.0 96.0

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query