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 di Lecce 813556 40.22 18.17
Wayne County 1820584 42.25 -83.28
Province of Zamboanga Sibugay 546186 7.76 122.54
Afyonkarahisar 840448 38.75 30.67
Departamento de Antioquia 5682276 7.0 -75.5
San Bernardino County 2035210 34.67 -116.17
Nebraska 1757399 41.5 -99.75
State of Qatar 840926 25.5 51.25
Respublika Buryatiya 963335 53.0 109.0
East Macedonia and Thrace 611067 40.95 25.33
Clark County 1951269 36.0 -114.88
Acapulco de Juarez 652136 16.86 -99.89
Charlotte 731424 35.23 -80.84
Hohhot 774477 40.81 111.65
British Columbia 4413973 54.0 -125.0
South Island 1027500 -43.0 171.0
Quetta District 850000 30.17 66.76
Wojewodztwo Dolnoslaskie 2876627 51.0 16.5
Zhenjiang 632552 32.21 119.43
Northern Ireland 1700000 54.5 -6.5

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query