1 2Readme for GeoNames Gazetteer extract files 3 4============================================================================================================ 5 6This work is licensed under a Creative Commons Attribution 4.0 License, 7see https://creativecommons.org/licenses/by/4.0/ 8The Data is provided "as is" without warranty or any representation of accuracy, timeliness or completeness. 9 10The data format is tab-delimited text in utf8 encoding. 11 12 13Files : 14------- 15XX.zip : features for country with iso code XX, see 'geoname' table for columns. 'no-country' for features not belonging to a country. 16allCountries.zip : all countries combined in one file, see 'geoname' table for columns 17cities500.zip : all cities with a population > 500 or seats of adm div down to PPLA4 (ca 185.000), see 'geoname' table for columns 18cities1000.zip : all cities with a population > 1000 or seats of adm div down to PPLA3 (ca 130.000), see 'geoname' table for columns 19cities5000.zip : all cities with a population > 5000 or PPLA (ca 50.000), see 'geoname' table for columns 20cities15000.zip : all cities with a population > 15000 or capitals (ca 25.000), see 'geoname' table for columns 21alternateNamesV2.zip : alternate names with language codes and geonameId, file with iso language codes, with new columns from and to 22alternateNames.zip : obsolete use V2, this file does not have the new columns to and from and will be removed in the future 23admin1CodesASCII.txt : names in English for admin divisions. Columns: code, name, name ascii, geonameid 24admin2Codes.txt : names for administrative subdivision 'admin2 code' (UTF8), Format : concatenated codes <tab>name <tab> asciiname <tab> geonameId 25iso-languagecodes.txt : iso 639 language codes, as used for alternate names in file alternateNames.zip 26featureCodes.txt : name and description for feature classes and feature codes 27timeZones.txt : countryCode, timezoneId, gmt offset on 1st of January, dst offset to gmt on 1st of July (of the current year), rawOffset without DST 28countryInfo.txt : country information : iso codes, fips codes, languages, capital ,... 29 see the geonames webservices for additional country information, 30 bounding box : http://api.geonames.org/countryInfo? 31 country names in different languages : http:/api.geonames.org/countryInfoCSV?lang=it 32modifications-<date>.txt : all records modified on the previous day, the date is in yyyy-MM-dd format. You can use this file to daily synchronize your own geonames database. 33deletes-<date>.txt : all records deleted on the previous day, format : geonameId <tab> name <tab> comment. 34 35alternateNamesModifications-<date>.txt : all alternate names modified on the previous day, 36alternateNamesDeletes-<date>.txt : all alternate names deleted on the previous day, format : alternateNameId <tab> geonameId <tab> name <tab> comment. 37userTags.zip : user tags , format : geonameId <tab> tag. 38hierarchy.zip : parentId, childId, type. The type 'ADM' stands for the admin hierarchy modeled by the admin1-4 codes. The other entries are entered with the user interface. The relation toponym-adm hierarchy is not included in the file, it can instead be built from the admincodes of the toponym. 39adminCode5.zip : the new adm5 column is not yet exported in the other files (in order to not break import scripts). Instead it is availabe as separate file. 40 columns: geonameId,adm5code 41 42The main 'geoname' table has the following fields : 43--------------------------------------------------- 44geonameid : integer id of record in geonames database 45name : name of geographical point (utf8) varchar(200) 46asciiname : name of geographical point in plain ascii characters, varchar(200) 47alternatenames : alternatenames, comma separated, ascii names automatically transliterated, convenience attribute from alternatename table, varchar(10000) 48latitude : latitude in decimal degrees (wgs84) 49longitude : longitude in decimal degrees (wgs84) 50feature class : see http://www.geonames.org/export/codes.html, char(1) 51feature code : see http://www.geonames.org/export/codes.html, varchar(10) 52country code : ISO-3166 2-letter country code, 2 characters 53cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 200 characters 54admin1 code : fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20) 55admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80) 56admin3 code : code for third level administrative division, varchar(20) 57admin4 code : code for fourth level administrative division, varchar(20) 58population : bigint (8 byte int) 59elevation : in meters, integer 60dem : digital elevation model, srtm3 or gtopo30, average elevation of 3''x3'' (ca 90mx90m) or 30''x30'' (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat. 61timezone : the iana timezone id (see file timeZone.txt) varchar(40) 62modification date : date of last modification in yyyy-MM-dd format 63 64 65AdminCodes: 66Most adm1 are FIPS codes. ISO codes are used for US, CH, BE and ME. UK and Greece are using an additional level between country and fips code. The code '00' stands for general features where no specific adm1 code is defined. 67The corresponding admin feature is found with the same countrycode and adminX codes and the respective feature code ADMx. 68 69 70 71The table 'alternate names' : 72----------------------------- 73alternateNameId : the id of this alternate name, int 74geonameid : geonameId referring to id in table 'geoname', int 75isolanguage : iso 639 language code 2- or 3-characters; 4-characters 'post' for postal codes and 'iata','icao' and faac for airport codes, fr_1793 for French Revolution names, abbr for abbreviation, link to a website (mostly to wikipedia), wkdt for the wikidataid, varchar(7) 76alternate name : alternate name or name variant, varchar(400) 77isPreferredName : '1', if this alternate name is an official/preferred name 78isShortName : '1', if this is a short name like 'California' for 'State of California' 79isColloquial : '1', if this alternate name is a colloquial or slang term. Example: 'Big Apple' for 'New York'. 80isHistoric : '1', if this alternate name is historic and was used in the past. Example 'Bombay' for 'Mumbai'. 81from : from period when the name was used 82to : to period when the name was used 83 84Remark : the field 'alternatenames' in the table 'geoname' is a short version of the 'alternatenames' table without links and postal codes but with ascii transliterations. You probably don't need both. 85If you don't need to know the language of a name variant, the field 'alternatenames' will be sufficient. If you need to know the language 86of a name variant, then you will need to load the table 'alternatenames' and you can drop the column in the geoname table. 87 88 89 90 91Boundaries: 92Simplified country boundaries are available in two slightly different formats: 93shapes_simplified_low: 94geonameId: The geonameId of the feature 95geoJson: The boundary in geoJson format 96 97shapes_simplified_low.json: 98similar to the abovementioned file, but fully in geojson format. The geonameId is a feature property in the geojson string. 99 100 101Statistics on the number of features per country and the feature class and code distributions : http://www.geonames.org/statistics/ 102 103 104Continent codes : 105AF : Africa geonameId=6255146 106AS : Asia geonameId=6255147 107EU : Europe geonameId=6255148 108NA : North America geonameId=6255149 109OC : Oceania geonameId=6255151 110SA : South America geonameId=6255150 111AN : Antarctica geonameId=6255152 112 113 114feature classes: 115A: country, state, region,... 116H: stream, lake, ... 117L: parks,area, ... 118P: city, village,... 119R: road, railroad 120S: spot, building, farm 121T: mountain,hill,rock,... 122U: undersea 123V: forest,heath,... 124 125 126If you find errors or miss important places, please do use the wiki-style edit interface on our website 127http://www.geonames.org to correct inaccuracies and to add new records. 128Thanks in the name of the geonames community for your valuable contribution. 129 130Data Sources: 131http://www.geonames.org/data-sources.html 132 133 134More Information is also available in the geonames faq : 135 136http://forum.geonames.org/gforum/forums/show/6.page 137 138The forum : http://forum.geonames.org 139 140or the google group : http://groups.google.com/group/geonames 141 142