== 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
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4