geonames

geonames.sql

/*
 * geonames.db dump 
 * taken from http://geonames.db.94y.info/
 * 
 * SEE:
 * https://github.com/mjradwin/geonames-sqlite
 * https://github.com/robotamer/geonames-to-sqlite
 */

SELECT geo.geonameid AS id,
geo.asciiname AS name, names.name AS alt_names,
geo.latitude, geo.longitude,
-- fea.abbrev, 
TZ.name AS timezone
FROM geonames AS geo
JOIN altnames AS names ON (names.geonameid=geo.geonameid)
JOIN featurecodes AS fea ON (fea.featurecodeid = geo.feature_code)
JOIN tzones AS TZ ON (TZ.timezoneid = geo.timezone)
-- LIMIT 100
-- OFFSET 50000