/locations

Rails search wrapper around Geonames cities, for use with Mechanical Turk location standardization

Primary LanguageRuby

== Location name browser app

ruby script/generate scaffold Location geonameid:integer name:string latitude:float longitude:float country_code:string cc2:string fipscode:string county:string population:integer 

grep PPL cities15000.txt | cut -d '     ' -f 1,2,5,6,8,9,10,11,12,15 

grep PPL cities15000.txt | ./parse_geonames.py > sample_cities.txt

The main 'geoname' table has the following fields :
---------------------------------------------------
1 geonameid         : integer id of record in geonames database
2 name              : name of geographical point (utf8) varchar(200)
5 latitude          : latitude in decimal degrees (wgs84)
6 longitude         : longitude in decimal degrees (wgs84)

9 country code      : ISO-3166 2-letter country code, 2 characters
10 cc2               : alternate country codes, comma separated, ISO-3166 2-letter country code, 60 characters
11 admin1 code       : fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for 
12 admin2 code       : code for the second administrative division, a county in the US, see file admin2Codes.txt; 
15 population        : bigint (4 byte int) 

cd lib/sql
mysql -u root location_development < locations.sql