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)
AD.zip 2015-02-27 01:30 79K
AE.zip 2015-02-27 01:30 213K
AF.zip 2015-02-27 01:30 4.5M
AG.zip 2015-02-27 01:30 19K
AI.zip 2015-02-27 01:30 7.6K
AL.zip 2015-02-27 01:30 283K
AM.zip 2015-02-27 01:30 81K
AO.zip 2015-02-27 01:30 1.1M
AQ.zip 2015-02-27 01:30 513K
AR.zip 2015-02-27 01:30 1.2M
AS.zip 2015-02-27 01:30 29K
AT.zip 2015-02-27 01:30 1.2M
AU.zip 2015-02-27 01:30 4.8M
AW.zip 2015-02-27 01:30 11K
AX.zip 2015-02-27 01:30 73K
AZ.zip 2015-02-27 01:30 348K
BA.zip 2015-02-27 01:30 1.2M
BB.zip 2015-02-27 01:30 21K
BD.zip 2015-02-27 01:30 1.2M
BE.zip 2015-02-27 01:30 551K
BF.zip 2015-02-27 01:30 248K
BG.zip 2015-02-27 01:30 465K
BH.zip 2015-02-27 01:30 26K
BI.zip 2015-02-27 01:30 233K
BJ.zip 2015-02-27 01:30 131K
BL.zip 2015-02-27 01:30 7.3K
BM.zip 2015-02-27 01:30 20K
BN.zip 2015-02-27 01:30 22K
BO.zip 2015-02-27 01:30 644K
BQ.zip 2015-02-27 01:30 14K
BR.zip 2015-02-27 01:31 2.9M
BS.zip 2015-02-27 01:31 55K
BT.zip 2015-02-27 01:31 16K
BV.zip 2015-02-27 01:31 5.7K
BW.zip 2015-02-27 01:31 95K
BY.zip 2015-02-27 01:31 1.0M
BZ.zip 2015-02-27 01:31 61K
CA.zip 2015-02-27 01:31 7.2M
CC.zip 2015-02-27 01:31 6.2K
CD.zip 2015-02-27 01:31 1.3M
CF.zip 2015-02-27 01:31 323K
CG.zip 2015-02-27 01:31 240K
CH.zip 2015-02-27 01:31 756K
CI.zip 2015-02-27 01:31 448K
CK.zip 2015-02-27 01:31 19K
CL.zip 2015-02-27 01:31 1.0M
CM.zip 2015-02-27 01:31 504K
CN.zip 2015-02-27 01:31 15M
CO.zip 2015-02-27 01:31 1.8M
CR.zip 2015-02-27 01:31 127K
CS.zip 2015-02-27 01:31 4.1K
CU.zip 2015-02-27 01:31 805K
CV.zip 2015-02-27 01:31 28K
CW.zip 2015-02-27 01:31 14K
CX.zip 2015-02-27 01:31 6.1K
CY.zip 2015-02-27 01:31 200K
CZ.zip 2015-02-27 01:31 692K
DE.zip 2015-02-27 01:32 4.9M
DJ.zip 2015-02-27 01:32 156K
DK.zip 2015-02-27 01:32 410K
DM.zip 2015-02-27 01:32 13K
DO.zip 2015-02-27 01:32 560K
DZ.zip 2015-02-27 01:32 1.5M
EC.zip 2015-02-27 01:32 347K
EE.zip 2015-02-27 01:32 315K
EG.zip 2015-02-27 01:32 1.3M
EH.zip 2015-02-27 01:32 66K
ER.zip 2015-02-27 01:32 176K
ES.zip 2015-02-27 01:32 2.2M
ET.zip 2015-02-27 01:32 531K
FI.zip 2015-02-27 01:32 1.9M
FJ.zip 2015-02-27 01:32 218K
FK.zip 2015-02-27 01:32 36K
FM.zip 2015-02-27 01:32 96K
FO.zip 2015-02-27 01:32 56K
FR.zip 2015-02-27 01:32 4.6M
GA.zip 2015-02-27 01:32 154K
GB.zip 2015-02-27 01:32 1.7M
GD.zip 2015-02-27 01:32 19K
GE.zip 2015-02-27 01:32 318K
GF.zip 2015-02-27 01:32 77K
GG.zip 2015-02-27 01:32 24K
GH.zip 2015-02-27 01:32 311K
GI.zip 2015-02-27 01:32 11K
GL.zip 2015-02-27 01:32 198K
GM.zip 2015-02-27 01:32 55K
GN.zip 2015-02-27 01:32 228K
GP.zip 2015-02-27 01:32 44K
GQ.zip 2015-02-27 01:32 104K
GR.zip 2015-02-27 01:32 1.2M
GS.zip 2015-02-27 01:32 19K
GT.zip 2015-02-27 01:32 351K
GU.zip 2015-02-27 01:32 47K
GW.zip 2015-02-27 01:32 140K
GY.zip 2015-02-27 01:32 143K
HK.zip 2015-02-27 01:32 96K
HM.zip 2015-02-27 01:32 7.1K
HN.zip 2015-02-27 01:32 404K
HR.zip 2015-02-27 01:32 590K
HT.zip 2015-02-27 01:32 320K
HU.zip 2015-02-27 01:32 626K
ID.zip 2015-02-27 01:32 8.0M
IE.zip 2015-02-27 01:32 605K
IL.zip 2015-02-27 01:32 380K
IM.zip 2015-02-27 01:32 8.4K
IN.zip 2015-02-27 01:32 1.8M
IO.zip 2015-02-27 01:32 9.9K
IQ.zip 2015-02-27 01:33 2.1M
IR.zip 2015-02-27 01:33 9.4M
IS.zip 2015-02-27 01:33 407K
IT.zip 2015-02-27 01:33 3.0M
JE.zip 2015-02-27 01:33 16K
JM.zip 2015-02-27 01:33 103K
JO.zip 2015-02-27 01:33 267K
JP.zip 2015-02-27 01:33 2.6M
KE.zip 2015-02-27 01:33 583K
KG.zip 2015-02-27 01:33 303K
KH.zip 2015-02-27 01:33 393K
KI.zip 2015-02-27 01:33 35K
KM.zip 2015-02-27 01:33 32K
KN.zip 2015-02-27 01:33 17K
KP.zip 2015-02-27 01:33 1.2M
KR.zip 2015-02-27 01:33 2.9M
KW.zip 2015-02-27 01:33 46K
KY.zip 2015-02-27 01:33 13K
KZ.zip 2015-02-27 01:33 666K
LA.zip 2015-02-27 01:33 511K
LB.zip 2015-02-27 01:33 849K
LC.zip 2015-02-27 01:33 22K
LI.zip 2015-02-27 01:33 8.4K
LK.zip 2015-02-27 01:33 1.0M
LR.zip 2015-02-27 01:33 227K
LS.zip 2015-02-27 01:33 36K
LT.zip 2015-02-27 01:33 275K
LU.zip 2015-02-27 01:33 39K
LV.zip 2015-02-27 01:33 259K
LY.zip 2015-02-27 01:33 823K
MA.zip 2015-02-27 01:33 1.2M
MC.zip 2015-02-27 01:33 5.9K
MD.zip 2015-02-27 01:33 100K
ME.zip 2015-02-27 01:33 345K
MF.zip 2015-02-27 01:33 10K
MG.zip 2015-02-27 01:33 591K
MH.zip 2015-02-27 01:33 55K
MK.zip 2015-02-27 01:33 634K
ML.zip 2015-02-27 01:33 597K
MM.zip 2015-02-27 01:33 1.1M
MN.zip 2015-02-27 01:33 273K
MO.zip 2015-02-27 01:33 11K
MP.zip 2015-02-27 01:33 37K
MQ.zip 2015-02-27 01:33 43K
MR.zip 2015-02-27 01:33 300K
MS.zip 2015-02-27 01:33 10K
MT.zip 2015-02-27 01:33 84K
MU.zip 2015-02-27 01:33 48K
MV.zip 2015-02-27 01:33 27K
MW.zip 2015-02-27 01:33 202K
MX.zip 2015-02-27 01:34 9.9M
MY.zip 2015-02-27 01:34 1.5M
MZ.zip 2015-02-27 01:34 1.1M
NA.zip 2015-02-27 01:34 175K
NC.zip 2015-02-27 01:34 106K
NE.zip 2015-02-27 01:34 602K
NF.zip 2015-02-27 01:34 6.3K
NG.zip 2015-02-27 01:34 1.3M
NI.zip 2015-02-27 01:34 170K
NL.zip 2015-02-27 01:34 608K
NO.zip 2015-02-27 01:34 15M
NP.zip 2015-02-27 01:34 2.4M
NR.zip 2015-02-27 01:34 7.6K
NU.zip 2015-02-27 01:34 5.2K
NZ.zip 2015-02-27 01:34 1.3M
OM.zip 2015-02-27 01:34 235K
PA.zip 2015-02-27 01:34 348K
PE.zip 2015-02-27 01:34 2.4M
PF.zip 2015-02-27 01:34 66K
PG.zip 2015-02-27 01:34 548K
PH.zip 2015-02-27 01:34 1.8M
PK.zip 2015-02-27 01:35 3.9M
PL.zip 2015-02-27 01:35 1.6M
PM.zip 2015-02-27 01:35 18K
PN.zip 2015-02-27 01:35 5.4K
PR.zip 2015-02-27 01:35 229K
PS.zip 2015-02-27 01:35 280K
PT.zip 2015-02-27 01:35 829K
PW.zip 2015-02-27 01:35 36K
PY.zip 2015-02-27 01:35 94K
QA.zip 2015-02-27 01:35 44K
RE.zip 2015-02-27 01:35 36K
RO.zip 2015-02-27 01:35 840K
RS.zip 2015-02-27 01:35 631K
RU.zip 2015-02-27 01:35 12M
RW.zip 2015-02-27 01:35 359K
SA.zip 2015-02-27 01:35 843K
SB.zip 2015-02-27 01:35 221K
SC.zip 2015-02-27 01:35 16K
SD.zip 2015-02-27 01:35 719K
SE.zip 2015-02-27 01:35 2.2M
SG.zip 2015-02-27 01:35 50K
SH.zip 2015-02-27 01:35 18K
SI.zip 2015-02-27 01:35 249K
SJ.zip 2015-02-27 01:35 187K
SK.zip 2015-02-27 01:35 245K
SL.zip 2015-02-27 01:35 331K
SM.zip 2015-02-27 01:35 5.8K
SN.zip 2015-02-27 01:35 296K
SO.zip 2015-02-27 01:35 465K
SR.zip 2015-02-27 01:35 60K
SS.zip 2015-02-27 01:35 294K
ST.zip 2015-02-27 01:35 19K
SV.zip 2015-02-27 01:35 163K
SX.zip 2015-02-27 01:35 8.9K
SY.zip 2015-02-27 01:35 1.3M
SZ.zip 2015-02-27 01:35 13K
TC.zip 2015-02-27 01:35 11K
TD.zip 2015-02-27 01:35 529K
TF.zip 2015-02-27 01:35 55K
TG.zip 2015-02-27 01:35 124K
TH.zip 2015-02-27 01:36 8.3M
TJ.zip 2015-02-27 01:36 152K
TK.zip 2015-02-27 01:36 7.0K
TL.zip 2015-02-27 01:36 169K
TM.zip 2015-02-27 01:36 179K
TN.zip 2015-02-27 01:36 615K
TO.zip 2015-02-27 01:36 21K
TR.zip 2015-02-27 01:36 2.2M
TT.zip 2015-02-27 01:36 53K
TV.zip 2015-02-27 01:36 14K
TW.zip 2015-02-27 01:36 1.8M
TZ.zip 2015-02-27 01:36 340K
UA.zip 2015-02-27 01:36 1.3M
UG.zip 2015-02-27 01:36 341K
UM.zip 2015-02-27 01:36 15K
US.zip 2015-02-27 01:37 59M
UY.zip 2015-02-27 01:37 151K
UZ.zip 2015-02-27 01:37 235K
VA.zip 2015-02-27 01:37 5.5K
VC.zip 2015-02-27 01:37 14K
VE.zip 2015-02-27 01:37 1.6M
VG.zip 2015-02-27 01:37 18K
VI.zip 2015-02-27 01:37 51K
VN.zip 2015-02-27 01:37 1.6M
VU.zip 2015-02-27 01:37 94K
WF.zip 2015-02-27 01:37 8.9K
WS.zip 2015-02-27 01:37 28K
XK.zip 2015-02-27 01:37 193K
YE.zip 2015-02-27 01:37 1.8M
YT.zip 2015-02-27 01:37 18K
YU.zip 2015-02-27 01:37 3.1K
ZA.zip 2015-02-27 01:37 2.5M
ZM.zip 2015-02-27 01:37 621K
ZW.zip 2015-02-27 01:37 603K
![[TXT]](/icons/text.gif)
admin1CodesASCII.txt 2015-02-27 01:37 134K
admin2Codes.txt 2015-02-27 01:37 1.9M
allCountries.zip 2015-02-27 01:37 276M
alternateNames.zip 2015-02-27 01:39 98M
alternateNamesDeletes-2015-02-26.txt 2015-02-27 01:39 0
alternateNamesModifications-2015-02-26.txt 2015-02-27 01:39 1.4K
cities1000.zip 2015-02-27 01:37 6.7M
cities15000.zip 2015-02-27 01:37 1.9M
cities5000.zip 2015-02-27 01:37 3.0M
countryInfo.txt 2015-02-27 01:25 31K
deletes-2015-02-26.txt 2015-02-27 01:39 0
featureCodes_bg.txt 2015-02-27 01:25 64K
featureCodes_en.txt 2015-02-27 01:25 56K
featureCodes_nb.txt 2015-02-27 01:25 56K
featureCodes_nn.txt 2015-02-27 01:25 56K
featureCodes_no.txt 2015-02-27 01:25 56K
featureCodes_ru.txt 2015-02-27 01:25 112K
featureCodes_sv.txt 2015-02-27 01:25 56K
hierarchy.zip 2015-02-27 01:39 1.3M
iso-languagecodes.txt 2015-02-27 01:25 124K
modifications-2015-02-26.txt 2015-02-27 01:37 339K
no-country.zip 2015-02-27 01:37 180K
readme.txt 2015-02-27 01:25 7.1K
shapes_simplified_low.json.zip 2015-02-27 01:39 825K
shapes_simplified_low.zip 2015-02-27 01:39 824K
timeZones.txt 2015-02-27 01:39 14K
userTags.zip 2015-02-27 01:39 166K
Readme for GeoNames Gazetteer extract files
============================================================================================================
This work is licensed under a Creative Commons Attribution 3.0 License,
see http://creativecommons.org/licenses/by/3.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
allCountries.zip : all countries combined in one file, see 'geoname' table for columns
cities1000.zip : all cities with a population > 1000 or seats of adm div (ca 80.000), see 'geoname' table for columns
cities5000.zip : all cities with a population > 5000 or PPLA (ca 40.000), see 'geoname' table for columns
cities15000.zip : all cities with a population > 15000 or capitals (ca 20.000), see 'geoname' table for columns
alternateNames.zip : two files, alternate names with language codes and geonameId, file with iso language codes
admin1CodesASCII.txt : ascii names of admin divisions. (beta > http://forum.geonames.org/gforum/posts/list/208.page#1143)
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://ws.geonames.org/countryInfo?
country names in different languages : http://ws.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.
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, 60 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 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 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 for a website, varchar(7)
alternate name : alternate name or name variant, varchar(200)
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
isHistoric : '1', if this alternate name is historic and was used in the past
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.
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
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