For more information, check the ReadMe section below. The "last modified" timestamp is in Central European Time.
Name Last modified Size Description
![[DIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
AD.zip 02-Aug-2014 02:46 63K
AE.zip 02-Aug-2014 02:46 199K
AF.zip 02-Aug-2014 02:46 4.5M
AG.zip 02-Aug-2014 02:46 18K
AI.zip 02-Aug-2014 02:46 7.5K
AL.zip 02-Aug-2014 02:46 278K
AM.zip 02-Aug-2014 02:46 79K
AO.zip 02-Aug-2014 02:46 1.1M
AQ.zip 02-Aug-2014 02:46 514K
AR.zip 02-Aug-2014 02:46 1.2M
AS.zip 02-Aug-2014 02:46 29K
AT.zip 02-Aug-2014 02:46 1.1M
AU.zip 02-Aug-2014 02:47 4.7M
AW.zip 02-Aug-2014 02:47 10K
AX.zip 02-Aug-2014 02:47 69K
AZ.zip 02-Aug-2014 02:47 331K
BA.zip 02-Aug-2014 02:47 1.2M
BB.zip 02-Aug-2014 02:47 20K
BD.zip 02-Aug-2014 02:47 1.2M
BE.zip 02-Aug-2014 02:47 546K
BF.zip 02-Aug-2014 02:47 248K
BG.zip 02-Aug-2014 02:47 457K
BH.zip 02-Aug-2014 02:47 23K
BI.zip 02-Aug-2014 02:47 232K
BJ.zip 02-Aug-2014 02:47 131K
BL.zip 02-Aug-2014 02:47 7.2K
BM.zip 02-Aug-2014 02:47 20K
BN.zip 02-Aug-2014 02:47 21K
BO.zip 02-Aug-2014 02:47 644K
BQ.zip 02-Aug-2014 02:47 13K
BR.zip 02-Aug-2014 02:47 2.9M
BS.zip 02-Aug-2014 02:47 53K
BT.zip 02-Aug-2014 02:47 16K
BV.zip 02-Aug-2014 02:47 5.7K
BW.zip 02-Aug-2014 02:47 95K
BY.zip 02-Aug-2014 02:47 1.0M
BZ.zip 02-Aug-2014 02:47 60K
CA.zip 02-Aug-2014 02:47 7.1M
CC.zip 02-Aug-2014 02:47 6.2K
CD.zip 02-Aug-2014 02:47 1.2M
CF.zip 02-Aug-2014 02:47 323K
CG.zip 02-Aug-2014 02:47 240K
CH.zip 02-Aug-2014 02:47 743K
CI.zip 02-Aug-2014 02:47 447K
CK.zip 02-Aug-2014 02:47 18K
CL.zip 02-Aug-2014 02:47 1.0M
CM.zip 02-Aug-2014 02:47 497K
CN.zip 02-Aug-2014 02:48 12M
CO.zip 02-Aug-2014 02:48 1.8M
CR.zip 02-Aug-2014 02:48 119K
CU.zip 02-Aug-2014 02:48 800K
CV.zip 02-Aug-2014 02:48 26K
CW.zip 02-Aug-2014 02:48 13K
CX.zip 02-Aug-2014 02:48 6.1K
CY.zip 02-Aug-2014 02:48 171K
CZ.zip 02-Aug-2014 02:48 656K
DE.zip 02-Aug-2014 02:48 4.9M
DJ.zip 02-Aug-2014 02:48 156K
DK.zip 02-Aug-2014 02:48 407K
DM.zip 02-Aug-2014 02:48 13K
DO.zip 02-Aug-2014 02:48 554K
DZ.zip 02-Aug-2014 02:48 1.5M
EC.zip 02-Aug-2014 02:48 345K
EE.zip 02-Aug-2014 02:48 313K
EG.zip 02-Aug-2014 02:48 1.3M
EH.zip 02-Aug-2014 02:48 65K
ER.zip 02-Aug-2014 02:48 176K
ES.zip 02-Aug-2014 02:49 2.1M
ET.zip 02-Aug-2014 02:49 528K
FI.zip 02-Aug-2014 02:49 960K
FJ.zip 02-Aug-2014 02:49 214K
FK.zip 02-Aug-2014 02:49 36K
FM.zip 02-Aug-2014 02:49 96K
FO.zip 02-Aug-2014 02:49 54K
FR.zip 02-Aug-2014 02:49 4.6M
GA.zip 02-Aug-2014 02:49 154K
GB.zip 02-Aug-2014 02:49 1.6M
GD.zip 02-Aug-2014 02:49 18K
GE.zip 02-Aug-2014 02:49 303K
GF.zip 02-Aug-2014 02:49 76K
GG.zip 02-Aug-2014 02:49 24K
GH.zip 02-Aug-2014 02:49 309K
GI.zip 02-Aug-2014 02:49 10K
GL.zip 02-Aug-2014 02:49 198K
GM.zip 02-Aug-2014 02:49 55K
GN.zip 02-Aug-2014 02:49 227K
GP.zip 02-Aug-2014 02:49 44K
GQ.zip 02-Aug-2014 02:49 103K
GR.zip 02-Aug-2014 02:49 1.0M
GS.zip 02-Aug-2014 02:49 19K
GT.zip 02-Aug-2014 02:49 311K
GU.zip 02-Aug-2014 02:49 47K
GW.zip 02-Aug-2014 02:49 140K
GY.zip 02-Aug-2014 02:49 143K
HK.zip 02-Aug-2014 02:49 57K
HM.zip 02-Aug-2014 02:49 7.1K
HN.zip 02-Aug-2014 02:49 399K
HR.zip 02-Aug-2014 02:49 585K
HT.zip 02-Aug-2014 02:49 319K
HU.zip 02-Aug-2014 02:49 613K
ID.zip 02-Aug-2014 02:49 7.9M
IE.zip 02-Aug-2014 02:49 572K
IL.zip 02-Aug-2014 02:49 353K
IM.zip 02-Aug-2014 02:49 7.6K
IN.zip 02-Aug-2014 02:49 1.5M
IO.zip 02-Aug-2014 02:49 9.9K
IQ.zip 02-Aug-2014 02:50 2.1M
IR.zip 02-Aug-2014 02:50 8.9M
IS.zip 02-Aug-2014 02:50 405K
IT.zip 02-Aug-2014 02:50 2.9M
JE.zip 02-Aug-2014 02:50 14K
JM.zip 02-Aug-2014 02:50 97K
JO.zip 02-Aug-2014 02:50 256K
JP.zip 02-Aug-2014 02:50 2.3M
KE.zip 02-Aug-2014 02:50 577K
KG.zip 02-Aug-2014 02:50 302K
KH.zip 02-Aug-2014 02:50 387K
KI.zip 02-Aug-2014 02:50 35K
KM.zip 02-Aug-2014 02:50 32K
KN.zip 02-Aug-2014 02:50 17K
KP.zip 02-Aug-2014 02:50 1.2M
KR.zip 02-Aug-2014 02:50 2.8M
KW.zip 02-Aug-2014 02:50 44K
KY.zip 02-Aug-2014 02:50 12K
KZ.zip 02-Aug-2014 02:50 664K
LA.zip 02-Aug-2014 02:50 510K
LB.zip 02-Aug-2014 02:50 846K
LC.zip 02-Aug-2014 02:50 21K
LI.zip 02-Aug-2014 02:50 8.3K
LK.zip 02-Aug-2014 02:50 1.0M
LR.zip 02-Aug-2014 02:50 176K
LS.zip 02-Aug-2014 02:50 35K
LT.zip 02-Aug-2014 02:50 269K
LU.zip 02-Aug-2014 02:50 38K
LV.zip 02-Aug-2014 02:50 256K
LY.zip 02-Aug-2014 02:50 821K
MA.zip 02-Aug-2014 02:51 1.2M
MC.zip 02-Aug-2014 02:51 5.5K
MD.zip 02-Aug-2014 02:51 99K
ME.zip 02-Aug-2014 02:51 346K
MF.zip 02-Aug-2014 02:51 9.7K
MG.zip 02-Aug-2014 02:51 589K
MH.zip 02-Aug-2014 02:51 55K
MK.zip 02-Aug-2014 02:51 540K
ML.zip 02-Aug-2014 02:51 596K
MM.zip 02-Aug-2014 02:51 1.1M
MN.zip 02-Aug-2014 02:51 277K
MO.zip 02-Aug-2014 02:51 9.5K
MP.zip 02-Aug-2014 02:51 37K
MQ.zip 02-Aug-2014 02:51 42K
MR.zip 02-Aug-2014 02:51 299K
MS.zip 02-Aug-2014 02:51 9.6K
MT.zip 02-Aug-2014 02:51 81K
MU.zip 02-Aug-2014 02:51 45K
MV.zip 02-Aug-2014 02:51 24K
MW.zip 02-Aug-2014 02:51 202K
MX.zip 02-Aug-2014 02:51 8.1M
MY.zip 02-Aug-2014 02:51 1.5M
MZ.zip 02-Aug-2014 02:51 1.1M
NA.zip 02-Aug-2014 02:51 173K
NC.zip 02-Aug-2014 02:51 105K
NE.zip 02-Aug-2014 02:51 606K
NF.zip 02-Aug-2014 02:51 5.7K
NG.zip 02-Aug-2014 02:51 1.1M
NI.zip 02-Aug-2014 02:51 169K
NL.zip 02-Aug-2014 02:51 602K
NO.zip 02-Aug-2014 02:51 4.8M
NP.zip 02-Aug-2014 02:52 2.4M
NR.zip 02-Aug-2014 02:52 7.6K
NU.zip 02-Aug-2014 02:52 5.2K
NZ.zip 02-Aug-2014 02:52 1.3M
OM.zip 02-Aug-2014 02:52 233K
PA.zip 02-Aug-2014 02:52 342K
PE.zip 02-Aug-2014 02:52 2.4M
PF.zip 02-Aug-2014 02:52 65K
PG.zip 02-Aug-2014 02:52 543K
PH.zip 02-Aug-2014 02:52 1.8M
PK.zip 02-Aug-2014 02:52 3.8M
PL.zip 02-Aug-2014 02:52 1.6M
PM.zip 02-Aug-2014 02:52 18K
PN.zip 02-Aug-2014 02:52 5.4K
PR.zip 02-Aug-2014 02:52 228K
PS.zip 02-Aug-2014 02:52 279K
PT.zip 02-Aug-2014 02:52 781K
PW.zip 02-Aug-2014 02:52 36K
PY.zip 02-Aug-2014 02:52 92K
QA.zip 02-Aug-2014 02:52 42K
RE.zip 02-Aug-2014 02:52 36K
RO.zip 02-Aug-2014 02:52 832K
RS.zip 02-Aug-2014 02:52 628K
RU.zip 02-Aug-2014 02:53 12M
RW.zip 02-Aug-2014 02:53 359K
SA.zip 02-Aug-2014 02:53 821K
SB.zip 02-Aug-2014 02:53 220K
SC.zip 02-Aug-2014 02:53 15K
SD.zip 02-Aug-2014 02:53 718K
SE.zip 02-Aug-2014 02:53 2.2M
SG.zip 02-Aug-2014 02:53 44K
SH.zip 02-Aug-2014 02:53 18K
SI.zip 02-Aug-2014 02:53 248K
SJ.zip 02-Aug-2014 02:53 187K
SK.zip 02-Aug-2014 02:53 240K
SL.zip 02-Aug-2014 02:53 159K
SM.zip 02-Aug-2014 02:53 5.5K
SN.zip 02-Aug-2014 02:53 294K
SO.zip 02-Aug-2014 02:53 463K
SR.zip 02-Aug-2014 02:53 60K
SS.zip 02-Aug-2014 02:53 293K
ST.zip 02-Aug-2014 02:53 18K
SV.zip 02-Aug-2014 02:53 162K
SX.zip 02-Aug-2014 02:53 8.6K
SY.zip 02-Aug-2014 02:53 1.3M
SZ.zip 02-Aug-2014 02:53 13K
TC.zip 02-Aug-2014 02:53 9.8K
TD.zip 02-Aug-2014 02:53 528K
TF.zip 02-Aug-2014 02:53 54K
TG.zip 02-Aug-2014 02:53 123K
TH.zip 02-Aug-2014 02:53 7.7M
TJ.zip 02-Aug-2014 02:53 153K
TK.zip 02-Aug-2014 02:53 7.0K
TL.zip 02-Aug-2014 02:53 169K
TM.zip 02-Aug-2014 02:53 165K
TN.zip 02-Aug-2014 02:53 608K
TO.zip 02-Aug-2014 02:53 21K
TR.zip 02-Aug-2014 02:53 2.0M
TT.zip 02-Aug-2014 02:53 52K
TV.zip 02-Aug-2014 02:53 14K
TW.zip 02-Aug-2014 02:53 1.7M
TZ.zip 02-Aug-2014 02:53 330K
UA.zip 02-Aug-2014 02:54 1.3M
UG.zip 02-Aug-2014 02:54 340K
UM.zip 02-Aug-2014 02:54 15K
US.zip 02-Aug-2014 02:56 58M
UY.zip 02-Aug-2014 02:56 146K
UZ.zip 02-Aug-2014 02:56 234K
VA.zip 02-Aug-2014 02:56 5.5K
VC.zip 02-Aug-2014 02:56 14K
VE.zip 02-Aug-2014 02:56 1.6M
VG.zip 02-Aug-2014 02:56 18K
VI.zip 02-Aug-2014 02:56 51K
VN.zip 02-Aug-2014 02:56 1.4M
VU.zip 02-Aug-2014 02:56 93K
WF.zip 02-Aug-2014 02:56 8.9K
WS.zip 02-Aug-2014 02:56 28K
XK.zip 02-Aug-2014 02:56 189K
YE.zip 02-Aug-2014 02:56 1.7M
YT.zip 02-Aug-2014 02:56 18K
ZA.zip 02-Aug-2014 02:56 2.4M
ZM.zip 02-Aug-2014 02:56 620K
ZW.zip 02-Aug-2014 02:56 602K
![[TXT]](/icons/text.gif)
admin1CodesASCII.txt 02-Aug-2014 02:56 134K
admin2Codes.txt 02-Aug-2014 02:56 1.8M
allCountries.zip 02-Aug-2014 02:56 254M
alternateNames.zip 02-Aug-2014 02:59 89M
alternateNamesDeletes-2014-08-01.txt 02-Aug-2014 02:59 217
alternateNamesModifications-2014-08-01.txt 02-Aug-2014 02:59 13K
cities1000.zip 02-Aug-2014 02:56 6.6M
cities15000.zip 02-Aug-2014 02:56 1.8M
cities5000.zip 02-Aug-2014 02:56 3.0M
countryInfo.txt 02-Aug-2014 02:42 31K
deletes-2014-08-01.txt 02-Aug-2014 02:59 1.3K
featureCodes_bg.txt 02-Aug-2014 02:42 64K
featureCodes_en.txt 02-Aug-2014 02:42 56K
featureCodes_nb.txt 02-Aug-2014 02:42 56K
featureCodes_nn.txt 02-Aug-2014 02:42 56K
featureCodes_no.txt 02-Aug-2014 02:42 56K
featureCodes_ru.txt 02-Aug-2014 02:42 112K
featureCodes_sv.txt 02-Aug-2014 02:42 56K
hierarchy.zip 02-Aug-2014 03:00 1.2M
iso-languagecodes.txt 02-Aug-2014 02:42 124K
modifications-2014-08-01.txt 02-Aug-2014 02:56 69K
no-country.zip 02-Aug-2014 02:56 175K
readme.txt 02-Aug-2014 02:42 7.1K
timeZones.txt 02-Aug-2014 02:59 14K
userTags.zip 02-Aug-2014 02:59 165K
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(8000)
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