For more information, check the ReadMe section below. The "last modified" timestamp is in Central European Time.
Name Last modified Size Description
![[PARENTDIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
userTags.zip 2020-01-24 03:00 177K
![[TXT]](/icons/text.gif)
timeZones.txt 2020-01-24 03:00 14K
shapes_simplified_lo..> 2020-01-24 03:00 946K
shapes_all_low.zip 2020-01-24 03:00 1.0M
readme.txt 2020-01-24 02:44 8.5K
no-country.zip 2020-01-24 02:55 196K
modifications-2020-0..> 2020-01-24 02:55 30K
iso-languagecodes.txt 2020-01-24 02:44 127K
hierarchy.zip 2020-01-24 03:00 1.8M
featureCodes_sv.txt 2020-01-24 02:44 57K
featureCodes_ru.txt 2020-01-24 02:44 113K
featureCodes_no.txt 2020-01-24 02:44 57K
featureCodes_nn.txt 2020-01-24 02:44 57K
featureCodes_nb.txt 2020-01-24 02:44 57K
featureCodes_en.txt 2020-01-24 02:44 57K
featureCodes_bg.txt 2020-01-24 02:44 66K
deletes-2020-01-23.txt 2020-01-24 03:00 325
countryInfo.txt 2020-01-24 02:44 31K
cities5000.zip 2020-01-24 02:55 3.7M
cities500.zip 2020-01-24 02:55 9.7M
cities15000.zip 2020-01-24 02:55 2.2M
cities1000.zip 2020-01-24 02:55 7.5M
![[DIR]](/icons/folder.gif)
alternatenames/ 2020-01-24 03:00 -
alternateNamesV2.zip 2020-01-24 03:00 153M
alternateNamesModifi..> 2020-01-24 02:57 9.2K
alternateNamesDelete..> 2020-01-24 03:00 167
alternateNames.zip 2020-01-24 02:57 151M
allCountries.zip 2020-01-24 02:55 346M
adminCode5.zip 2020-01-24 02:55 335K
admin2Codes.txt 2020-01-24 02:55 2.1M
admin1CodesASCII.txt 2020-01-24 02:55 134K
ZW.zip 2020-01-24 02:55 618K
ZM.zip 2020-01-24 02:55 633K
ZA.zip 2020-01-24 02:55 2.5M
YU.zip 2020-01-24 02:55 3.7K
YT.zip 2020-01-24 02:55 22K
YE.zip 2020-01-24 02:55 3.5M
XK.zip 2020-01-24 02:55 196K
WS.zip 2020-01-24 02:55 30K
WF.zip 2020-01-24 02:55 21K
VU.zip 2020-01-24 02:55 104K
VN.zip 2020-01-24 02:55 1.7M
VI.zip 2020-01-24 02:55 68K
VG.zip 2020-01-24 02:55 26K
VE.zip 2020-01-24 02:55 1.6M
VC.zip 2020-01-24 02:55 23K
VA.zip 2020-01-24 02:55 6.3K
UZ.zip 2020-01-24 02:55 301K
UY.zip 2020-01-24 02:55 245K
US.zip 2020-01-24 02:55 66M
UM.zip 2020-01-24 02:54 17K
UG.zip 2020-01-24 02:54 673K
UA.zip 2020-01-24 02:54 1.7M
TZ.zip 2020-01-24 02:54 484K
TW.zip 2020-01-24 02:54 2.2M
TV.zip 2020-01-24 02:54 14K
TT.zip 2020-01-24 02:54 56K
TR.zip 2020-01-24 02:54 2.7M
TO.zip 2020-01-24 02:54 25K
TN.zip 2020-01-24 02:54 794K
TM.zip 2020-01-24 02:54 185K
TL.zip 2020-01-24 02:54 204K
TK.zip 2020-01-24 02:54 7.5K
TJ.zip 2020-01-24 02:54 161K
TH.zip 2020-01-24 02:54 8.6M
TG.zip 2020-01-24 02:53 126K
TF.zip 2020-01-24 02:53 57K
TD.zip 2020-01-24 02:53 554K
TC.zip 2020-01-24 02:53 22K
SZ.zip 2020-01-24 02:53 17K
SY.zip 2020-01-24 02:53 1.8M
SX.zip 2020-01-24 02:53 11K
SV.zip 2020-01-24 02:53 218K
ST.zip 2020-01-24 02:53 22K
SS.zip 2020-01-24 02:53 298K
SR.zip 2020-01-24 02:53 70K
SO.zip 2020-01-24 02:53 469K
SN.zip 2020-01-24 02:53 303K
SM.zip 2020-01-24 02:53 8.5K
SL.zip 2020-01-24 02:53 360K
SK.zip 2020-01-24 02:53 378K
SJ.zip 2020-01-24 02:53 192K
SI.zip 2020-01-24 02:53 267K
SH.zip 2020-01-24 02:53 22K
SG.zip 2020-01-24 02:53 58K
SE.zip 2020-01-24 02:53 2.4M
SD.zip 2020-01-24 02:53 727K
SC.zip 2020-01-24 02:53 21K
SB.zip 2020-01-24 02:53 229K
SA.zip 2020-01-24 02:53 1.0M
RW.zip 2020-01-24 02:53 457K
RU.zip 2020-01-24 02:53 12M
RS.zip 2020-01-24 02:53 659K
RO.zip 2020-01-24 02:53 902K
RE.zip 2020-01-24 02:53 65K
QA.zip 2020-01-24 02:53 173K
PY.zip 2020-01-24 02:53 479K
PW.zip 2020-01-24 02:53 39K
PT.zip 2020-01-24 02:53 1.0M
PS.zip 2020-01-24 02:53 289K
PR.zip 2020-01-24 02:53 260K
PN.zip 2020-01-24 02:53 6.2K
PM.zip 2020-01-24 02:53 19K
PL.zip 2020-01-24 02:53 1.9M
PK.zip 2020-01-24 02:53 5.8M
PH.zip 2020-01-24 02:53 2.3M
PG.zip 2020-01-24 02:52 567K
PF.zip 2020-01-24 02:52 116K
PE.zip 2020-01-24 02:52 2.7M
PA.zip 2020-01-24 02:52 427K
OM.zip 2020-01-24 02:52 553K
NZ.zip 2020-01-24 02:52 1.3M
NU.zip 2020-01-24 02:52 11K
NR.zip 2020-01-24 02:52 8.8K
NP.zip 2020-01-24 02:52 2.9M
NO.zip 2020-01-24 02:52 15M
NL.zip 2020-01-24 02:52 650K
NI.zip 2020-01-24 02:52 185K
NG.zip 2020-01-24 02:52 1.6M
NF.zip 2020-01-24 02:52 7.6K
NE.zip 2020-01-24 02:52 612K
NC.zip 2020-01-24 02:52 131K
NA.zip 2020-01-24 02:52 185K
MZ.zip 2020-01-24 02:52 1.1M
MY.zip 2020-01-24 02:52 1.5M
MX.zip 2020-01-24 02:52 12M
MW.zip 2020-01-24 02:52 212K
MV.zip 2020-01-24 02:52 35K
MU.zip 2020-01-24 02:52 53K
MT.zip 2020-01-24 02:52 92K
MS.zip 2020-01-24 02:52 12K
MR.zip 2020-01-24 02:52 306K
MQ.zip 2020-01-24 02:52 94K
MP.zip 2020-01-24 02:52 43K
MO.zip 2020-01-24 02:52 12K
MN.zip 2020-01-24 02:52 278K
MM.zip 2020-01-24 02:52 1.2M
ML.zip 2020-01-24 02:51 606K
MK.zip 2020-01-24 02:51 871K
MH.zip 2020-01-24 02:51 57K
MG.zip 2020-01-24 02:51 1.3M
MF.zip 2020-01-24 02:51 12K
ME.zip 2020-01-24 02:51 358K
MD.zip 2020-01-24 02:51 128K
MC.zip 2020-01-24 02:51 8.0K
MA.zip 2020-01-24 02:51 3.9M
LY.zip 2020-01-24 02:51 924K
LV.zip 2020-01-24 02:51 362K
LU.zip 2020-01-24 02:51 47K
LT.zip 2020-01-24 02:51 962K
LS.zip 2020-01-24 02:51 40K
LR.zip 2020-01-24 02:51 231K
LK.zip 2020-01-24 02:51 1.4M
LI.zip 2020-01-24 02:51 49K
LC.zip 2020-01-24 02:51 48K
LB.zip 2020-01-24 02:51 1.0M
LA.zip 2020-01-24 02:51 682K
KZ.zip 2020-01-24 02:51 1.4M
KY.zip 2020-01-24 02:51 14K
KW.zip 2020-01-24 02:51 48K
KR.zip 2020-01-24 02:51 4.4M
KP.zip 2020-01-24 02:51 1.4M
KN.zip 2020-01-24 02:51 21K
KM.zip 2020-01-24 02:51 34K
KI.zip 2020-01-24 02:51 37K
KH.zip 2020-01-24 02:51 643K
KG.zip 2020-01-24 02:51 323K
KE.zip 2020-01-24 02:51 792K
JP.zip 2020-01-24 02:51 4.4M
JO.zip 2020-01-24 02:51 526K
JM.zip 2020-01-24 02:51 138K
JE.zip 2020-01-24 02:51 18K
IT.zip 2020-01-24 02:51 3.9M
IS.zip 2020-01-24 02:51 440K
IR.zip 2020-01-24 02:51 12M
IQ.zip 2020-01-24 02:51 2.6M
IO.zip 2020-01-24 02:51 11K
IN.zip 2020-01-24 02:51 14M
IM.zip 2020-01-24 02:50 9.7K
IL.zip 2020-01-24 02:50 510K
IE.zip 2020-01-24 02:50 707K
ID.zip 2020-01-24 02:50 8.1M
HU.zip 2020-01-24 02:50 645K
HT.zip 2020-01-24 02:50 377K
HR.zip 2020-01-24 02:50 675K
HN.zip 2020-01-24 02:50 414K
HM.zip 2020-01-24 02:50 8.3K
HK.zip 2020-01-24 02:50 105K
GY.zip 2020-01-24 02:50 151K
GW.zip 2020-01-24 02:50 142K
GU.zip 2020-01-24 02:50 49K
GT.zip 2020-01-24 02:50 863K
GS.zip 2020-01-24 02:50 30K
GR.zip 2020-01-24 02:50 1.6M
GQ.zip 2020-01-24 02:50 107K
GP.zip 2020-01-24 02:50 111K
GN.zip 2020-01-24 02:50 238K
GM.zip 2020-01-24 02:50 58K
GL.zip 2020-01-24 02:50 211K
GI.zip 2020-01-24 02:50 12K
GH.zip 2020-01-24 02:50 535K
GG.zip 2020-01-24 02:50 27K
GF.zip 2020-01-24 02:50 114K
GE.zip 2020-01-24 02:50 369K
GD.zip 2020-01-24 02:50 25K
GB.zip 2020-01-24 02:50 2.1M
GA.zip 2020-01-24 02:50 158K
FR.zip 2020-01-24 02:50 5.9M
FO.zip 2020-01-24 02:50 64K
FM.zip 2020-01-24 02:50 100K
FK.zip 2020-01-24 02:50 37K
FJ.zip 2020-01-24 02:50 440K
FI.zip 2020-01-24 02:50 2.0M
ET.zip 2020-01-24 02:50 544K
ES.zip 2020-01-24 02:50 2.8M
ER.zip 2020-01-24 02:50 181K
EH.zip 2020-01-24 02:50 67K
EG.zip 2020-01-24 02:50 1.6M
EE.zip 2020-01-24 02:49 485K
EC.zip 2020-01-24 02:49 420K
DZ.zip 2020-01-24 02:49 1.5M
DO.zip 2020-01-24 02:49 1.0M
DM.zip 2020-01-24 02:49 16K
DK.zip 2020-01-24 02:49 440K
DJ.zip 2020-01-24 02:49 162K
DE.zip 2020-01-24 02:49 6.1M
CZ.zip 2020-01-24 02:49 1.3M
CY.zip 2020-01-24 02:49 262K
CX.zip 2020-01-24 02:49 7.7K
CW.zip 2020-01-24 02:49 16K
CV.zip 2020-01-24 02:49 41K
CU.zip 2020-01-24 02:49 1.0M
CS.zip 2020-01-24 02:49 4.8K
CR.zip 2020-01-24 02:49 193K
CO.zip 2020-01-24 02:49 2.0M
CN.zip 2020-01-24 02:49 24M
CM.zip 2020-01-24 02:49 515K
CL.zip 2020-01-24 02:49 1.3M
CK.zip 2020-01-24 02:49 25K
CI.zip 2020-01-24 02:49 460K
CH.zip 2020-01-24 02:49 2.5M
CG.zip 2020-01-24 02:49 245K
CF.zip 2020-01-24 02:49 336K
CD.zip 2020-01-24 02:49 1.4M
CC.zip 2020-01-24 02:48 7.2K
CA.zip 2020-01-24 02:48 7.5M
BZ.zip 2020-01-24 02:48 67K
BY.zip 2020-01-24 02:48 1.1M
BW.zip 2020-01-24 02:48 103K
BV.zip 2020-01-24 02:48 6.3K
BT.zip 2020-01-24 02:48 22K
BS.zip 2020-01-24 02:48 71K
BR.zip 2020-01-24 02:48 3.2M
BQ.zip 2020-01-24 02:48 16K
BO.zip 2020-01-24 02:48 738K
BN.zip 2020-01-24 02:48 25K
BM.zip 2020-01-24 02:48 23K
BL.zip 2020-01-24 02:48 9.3K
BJ.zip 2020-01-24 02:48 150K
BI.zip 2020-01-24 02:48 297K
BH.zip 2020-01-24 02:48 30K
BG.zip 2020-01-24 02:48 692K
BF.zip 2020-01-24 02:48 271K
BE.zip 2020-01-24 02:48 614K
BD.zip 2020-01-24 02:48 1.5M
BB.zip 2020-01-24 02:48 34K
BA.zip 2020-01-24 02:48 1.2M
AZ.zip 2020-01-24 02:48 445K
AX.zip 2020-01-24 02:48 76K
AW.zip 2020-01-24 02:48 17K
AU.zip 2020-01-24 02:48 5.3M
AT.zip 2020-01-24 02:48 1.4M
AS.zip 2020-01-24 02:48 32K
AR.zip 2020-01-24 02:48 1.4M
AQ.zip 2020-01-24 02:48 525K
AO.zip 2020-01-24 02:48 1.1M
AN.zip 2020-01-24 02:48 3.9K
AM.zip 2020-01-24 02:48 1.0M
AL.zip 2020-01-24 02:48 348K
AI.zip 2020-01-24 02:48 10K
AG.zip 2020-01-24 02:48 26K
AF.zip 2020-01-24 02:48 4.5M
AE.zip 2020-01-24 02:48 239K
AD.zip 2020-01-24 02:48 92K
Readme for GeoNames Gazetteer extract files
============================================================================================================
This work is licensed under a Creative Commons Attribution 4.0 License,
see https://creativecommons.org/licenses/by/4.0/
The Data is provided "as is" without warranty or any representation of accuracy, timeliness or completeness.
The data format is tab-delimited text in utf8 encoding.
Files :
-------
XX.zip : features for country with iso code XX, see 'geoname' table for columns. 'no-country' for features not belonging to a country.
allCountries.zip : all countries combined in one file, see 'geoname' table for columns
cities500.zip : all cities with a population > 500 or seats of adm div down to PPLA4 (ca 185.000), see 'geoname' table for columns
cities1000.zip : all cities with a population > 1000 or seats of adm div down to PPLA3 (ca 130.000), see 'geoname' table for columns
cities5000.zip : all cities with a population > 5000 or PPLA (ca 50.000), see 'geoname' table for columns
cities15000.zip : all cities with a population > 15000 or capitals (ca 25.000), see 'geoname' table for columns
alternateNamesV2.zip : alternate names with language codes and geonameId, file with iso language codes, with new columns from and to
alternateNames.zip : obsolete use V2, this file does not have the new columns to and from and will be removed in the future
admin1CodesASCII.txt : names in English for admin divisions. Columns: code, name, name ascii, geonameid
admin2Codes.txt : names for administrative subdivision 'admin2 code' (UTF8), Format : concatenated codes <tab>name <tab> asciiname <tab> geonameId
iso-languagecodes.txt : iso 639 language codes, as used for alternate names in file alternateNames.zip
featureCodes.txt : name and description for feature classes and feature codes
timeZones.txt : countryCode, timezoneId, gmt offset on 1st of January, dst offset to gmt on 1st of July (of the current year), rawOffset without DST
countryInfo.txt : country information : iso codes, fips codes, languages, capital ,...
see the geonames webservices for additional country information,
bounding box : http://api.geonames.org/countryInfo?
country names in different languages : http:/api.geonames.org/countryInfoCSV?lang=it
modifications-<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.
deletes-<date>.txt : all records deleted on the previous day, format : geonameId <tab> name <tab> comment.
alternateNamesModifications-<date>.txt : all alternate names modified on the previous day,
alternateNamesDeletes-<date>.txt : all alternate names deleted on the previous day, format : alternateNameId <tab> geonameId <tab> name <tab> comment.
userTags.zip : user tags , format : geonameId <tab> tag.
hierarchy.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.
adminCode5.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.
columns: geonameId,adm5code
The main 'geoname' table has the following fields :
---------------------------------------------------
geonameid : integer id of record in geonames database
name : name of geographical point (utf8) varchar(200)
asciiname : name of geographical point in plain ascii characters, varchar(200)
alternatenames : alternatenames, comma separated, ascii names automatically transliterated, convenience attribute from alternatename table, varchar(10000)
latitude : latitude in decimal degrees (wgs84)
longitude : longitude in decimal degrees (wgs84)
feature class : see http://www.geonames.org/export/codes.html, char(1)
feature code : see http://www.geonames.org/export/codes.html, varchar(10)
country code : ISO-3166 2-letter country code, 2 characters
cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 200 characters
admin1 code : fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20)
admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
admin3 code : code for third level administrative division, varchar(20)
admin4 code : code for fourth level administrative division, varchar(20)
population : bigint (8 byte int)
elevation : in meters, integer
dem : 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.
timezone : the iana timezone id (see file timeZone.txt) varchar(40)
modification date : date of last modification in yyyy-MM-dd format
AdminCodes:
Most 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.
The corresponding admin feature is found with the same countrycode and adminX codes and the respective feature code ADMx.
The table 'alternate names' :
-----------------------------
alternateNameId : the id of this alternate name, int
geonameid : geonameId referring to id in table 'geoname', int
isolanguage : 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)
alternate name : alternate name or name variant, varchar(400)
isPreferredName : '1', if this alternate name is an official/preferred name
isShortName : '1', if this is a short name like 'California' for 'State of California'
isColloquial : '1', if this alternate name is a colloquial or slang term. Example: 'Big Apple' for 'New York'.
isHistoric : '1', if this alternate name is historic and was used in the past. Example 'Bombay' for 'Mumbai'.
from : from period when the name was used
to : to period when the name was used
Remark : 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.
If 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
of a name variant, then you will need to load the table 'alternatenames' and you can drop the column in the geoname table.
Boundaries:
Simplified country boundaries are available in two slightly different formats:
shapes_simplified_low:
geonameId: The geonameId of the feature
geoJson: The boundary in geoJson format
shapes_simplified_low.json:
similar to the abovementioned file, but fully in geojson format. The geonameId is a feature property in the geojson string.
Statistics on the number of features per country and the feature class and code distributions : http://www.geonames.org/statistics/
Continent codes :
AF : Africa geonameId=6255146
AS : Asia geonameId=6255147
EU : Europe geonameId=6255148
NA : North America geonameId=6255149
OC : Oceania geonameId=6255151
SA : South America geonameId=6255150
AN : Antarctica geonameId=6255152
feature classes:
A: country, state, region,...
H: stream, lake, ...
L: parks,area, ...
P: city, village,...
R: road, railroad
S: spot, building, farm
T: mountain,hill,rock,...
U: undersea
V: forest,heath,...
If you find errors or miss important places, please do use the wiki-style edit interface on our website
http://www.geonames.org to correct inaccuracies and to add new records.
Thanks in the name of the geonames community for your valuable contribution.
Data Sources:
http://www.geonames.org/data-sources.html
More Information is also available in the geonames faq :
http://forum.geonames.org/gforum/forums/show/6.page
The forum : http://forum.geonames.org
or the google group : http://groups.google.com/group/geonames