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
City of Memphis 646889 35.1 -89.98
Solapur 997281 17.68 75.92
Al Hudaydah 617871 14.8 42.95
Torino 865263 45.07 7.69
City of Philadelphia 1526006 39.95 -75.16
Estado de Michoacan de Ocampo 4090997 19.17 -101.83
Departement du Doubs 520133 47.17 6.42
Nairobi 2750547 -1.28 36.82
Provincia di Vicenza 866398 45.67 11.45
Dakar Department 1030594 14.71 -17.46
Curitiba 1746896 -25.5 -49.29
Wilayat-e Sar-e Pul 727277 35.83 66.17
Changwat Phichit 614516 16.25 100.42
Hajdu-Bihar megye 545641 47.42 21.5
Chandpur District 2032449 23.25 90.83
Ul'yanovskaya Oblast' 1350713 54.0 48.0
Tanintharyi Division 1383287 13.0 99.0
Ningxia Huizu Zizhiqu 6180000 37.0 106.0
Departement de Saone-et-Loire 551842 46.67 4.5
Buenos Aires 13076300 -34.61 -58.38

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query