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 2016-09-30 01:45 89K
AE.zip 2016-09-30 01:45 227K
AF.zip 2016-09-30 01:45 4.5M
AG.zip 2016-09-30 01:45 20K
AI.zip 2016-09-30 01:45 8.8K
AL.zip 2016-09-30 01:45 295K
AM.zip 2016-09-30 01:45 477K
AN.zip 2016-09-30 01:45 3.5K
AO.zip 2016-09-30 01:45 1.1M
AQ.zip 2016-09-30 01:45 523K
AR.zip 2016-09-30 01:45 1.4M
AS.zip 2016-09-30 01:45 30K
AT.zip 2016-09-30 01:45 1.2M
AU.zip 2016-09-30 01:45 5.0M
AW.zip 2016-09-30 01:45 13K
AX.zip 2016-09-30 01:45 74K
AZ.zip 2016-09-30 01:45 365K
BA.zip 2016-09-30 01:45 1.2M
BB.zip 2016-09-30 01:45 24K
BD.zip 2016-09-30 01:45 1.2M
BE.zip 2016-09-30 01:45 597K
BF.zip 2016-09-30 01:45 253K
BG.zip 2016-09-30 01:45 495K
BH.zip 2016-09-30 01:45 29K
BI.zip 2016-09-30 01:45 235K
BJ.zip 2016-09-30 01:45 133K
BL.zip 2016-09-30 01:45 7.8K
BM.zip 2016-09-30 01:45 21K
BN.zip 2016-09-30 01:45 23K
BO.zip 2016-09-30 01:45 663K
BQ.zip 2016-09-30 01:45 15K
BR.zip 2016-09-30 01:45 3.0M
BS.zip 2016-09-30 01:45 66K
BT.zip 2016-09-30 01:45 19K
BV.zip 2016-09-30 01:45 6.1K
BW.zip 2016-09-30 01:45 99K
BY.zip 2016-09-30 01:45 1.0M
BZ.zip 2016-09-30 01:46 65K
CA.zip 2016-09-30 01:46 7.3M
CC.zip 2016-09-30 01:46 6.9K
CD.zip 2016-09-30 01:46 1.4M
CF.zip 2016-09-30 01:46 335K
CG.zip 2016-09-30 01:46 242K
CH.zip 2016-09-30 01:46 1.8M
CI.zip 2016-09-30 01:46 455K
CK.zip 2016-09-30 01:46 20K
CL.zip 2016-09-30 01:46 1.1M
CM.zip 2016-09-30 01:46 509K
CN.zip 2016-09-30 01:46 20M
CO.zip 2016-09-30 01:46 1.9M
CR.zip 2016-09-30 01:46 168K
CS.zip 2016-09-30 01:46 4.6K
CU.zip 2016-09-30 01:46 934K
CV.zip 2016-09-30 01:46 31K
CW.zip 2016-09-30 01:46 15K
CX.zip 2016-09-30 01:46 7.0K
CY.zip 2016-09-30 01:46 250K
CZ.zip 2016-09-30 01:46 796K
DE.zip 2016-09-30 01:47 5.6M
DJ.zip 2016-09-30 01:47 157K
DK.zip 2016-09-30 01:47 425K
DM.zip 2016-09-30 01:47 14K
DO.zip 2016-09-30 01:47 1.0M
DZ.zip 2016-09-30 01:47 1.5M
EC.zip 2016-09-30 01:47 386K
EE.zip 2016-09-30 01:47 486K
EG.zip 2016-09-30 01:47 1.4M
EH.zip 2016-09-30 01:47 66K
ER.zip 2016-09-30 01:47 178K
ES.zip 2016-09-30 01:47 2.6M
ET.zip 2016-09-30 01:47 538K
FI.zip 2016-09-30 01:47 1.9M
FJ.zip 2016-09-30 01:47 312K
FK.zip 2016-09-30 01:47 36K
FM.zip 2016-09-30 01:47 97K
FO.zip 2016-09-30 01:47 58K
FR.zip 2016-09-30 01:47 5.7M
GA.zip 2016-09-30 01:47 156K
GB.zip 2016-09-30 01:47 1.9M
GD.zip 2016-09-30 01:47 19K
GE.zip 2016-09-30 01:47 322K
GF.zip 2016-09-30 01:47 106K
GG.zip 2016-09-30 01:47 27K
GH.zip 2016-09-30 01:47 314K
GI.zip 2016-09-30 01:47 12K
GL.zip 2016-09-30 01:47 201K
GM.zip 2016-09-30 01:47 57K
GN.zip 2016-09-30 01:47 236K
GP.zip 2016-09-30 01:47 48K
GQ.zip 2016-09-30 01:47 106K
GR.zip 2016-09-30 01:47 1.4M
GS.zip 2016-09-30 01:47 29K
GT.zip 2016-09-30 01:47 361K
GU.zip 2016-09-30 01:47 48K
GW.zip 2016-09-30 01:47 141K
GY.zip 2016-09-30 01:47 147K
HK.zip 2016-09-30 01:47 102K
HM.zip 2016-09-30 01:47 7.9K
HN.zip 2016-09-30 01:47 407K
HR.zip 2016-09-30 01:47 637K
HT.zip 2016-09-30 01:47 333K
HU.zip 2016-09-30 01:47 639K
ID.zip 2016-09-30 01:47 8.1M
IE.zip 2016-09-30 01:47 644K
IL.zip 2016-09-30 01:47 407K
IM.zip 2016-09-30 01:47 9.0K
IN.zip 2016-09-30 01:48 12M
IO.zip 2016-09-30 01:48 10K
IQ.zip 2016-09-30 01:48 2.2M
IR.zip 2016-09-30 01:48 11M
IS.zip 2016-09-30 01:48 421K
IT.zip 2016-09-30 01:48 3.7M
JE.zip 2016-09-30 01:48 17K
JM.zip 2016-09-30 01:48 108K
JO.zip 2016-09-30 01:48 357K
JP.zip 2016-09-30 01:48 3.6M
KE.zip 2016-09-30 01:48 602K
KG.zip 2016-09-30 01:48 320K
KH.zip 2016-09-30 01:48 406K
KI.zip 2016-09-30 01:48 37K
KM.zip 2016-09-30 01:48 33K
KN.zip 2016-09-30 01:48 18K
KP.zip 2016-09-30 01:48 1.2M
KR.zip 2016-09-30 01:48 3.6M
KW.zip 2016-09-30 01:48 47K
KY.zip 2016-09-30 01:48 14K
KZ.zip 2016-09-30 01:48 1.0M
LA.zip 2016-09-30 01:48 675K
LB.zip 2016-09-30 01:48 853K
LC.zip 2016-09-30 01:48 23K
LI.zip 2016-09-30 01:48 48K
LK.zip 2016-09-30 01:49 1.0M
LR.zip 2016-09-30 01:49 229K
LS.zip 2016-09-30 01:49 37K
LT.zip 2016-09-30 01:49 302K
LU.zip 2016-09-30 01:49 43K
LV.zip 2016-09-30 01:49 286K
LY.zip 2016-09-30 01:49 827K
MA.zip 2016-09-30 01:49 3.2M
MC.zip 2016-09-30 01:49 7.3K
MD.zip 2016-09-30 01:49 127K
ME.zip 2016-09-30 01:49 348K
MF.zip 2016-09-30 01:49 10K
MG.zip 2016-09-30 01:49 596K
MH.zip 2016-09-30 01:49 55K
MK.zip 2016-09-30 01:49 860K
ML.zip 2016-09-30 01:49 601K
MM.zip 2016-09-30 01:49 1.2M
MN.zip 2016-09-30 01:49 274K
MO.zip 2016-09-30 01:49 11K
MP.zip 2016-09-30 01:49 37K
MQ.zip 2016-09-30 01:49 47K
MR.zip 2016-09-30 01:49 302K
MS.zip 2016-09-30 01:49 11K
MT.zip 2016-09-30 01:49 90K
MU.zip 2016-09-30 01:49 52K
MV.zip 2016-09-30 01:49 34K
MW.zip 2016-09-30 01:49 204K
MX.zip 2016-09-30 01:49 11M
MY.zip 2016-09-30 01:49 1.5M
MZ.zip 2016-09-30 01:49 1.1M
NA.zip 2016-09-30 01:49 180K
NC.zip 2016-09-30 01:49 110K
NE.zip 2016-09-30 01:49 607K
NF.zip 2016-09-30 01:49 7.1K
NG.zip 2016-09-30 01:49 1.5M
NI.zip 2016-09-30 01:49 174K
NL.zip 2016-09-30 01:49 632K
NO.zip 2016-09-30 01:50 15M
NP.zip 2016-09-30 01:50 2.5M
NR.zip 2016-09-30 01:50 8.5K
NU.zip 2016-09-30 01:50 6.3K
NZ.zip 2016-09-30 01:50 1.3M
OM.zip 2016-09-30 01:50 238K
PA.zip 2016-09-30 01:50 402K
PE.zip 2016-09-30 01:50 2.6M
PF.zip 2016-09-30 01:50 74K
PG.zip 2016-09-30 01:50 558K
PH.zip 2016-09-30 01:50 1.8M
PK.zip 2016-09-30 01:50 4.8M
PL.zip 2016-09-30 01:50 1.8M
PM.zip 2016-09-30 01:50 18K
PN.zip 2016-09-30 01:50 5.9K
PR.zip 2016-09-30 01:50 246K
PS.zip 2016-09-30 01:50 282K
PT.zip 2016-09-30 01:50 894K
PW.zip 2016-09-30 01:50 37K
PY.zip 2016-09-30 01:50 98K
QA.zip 2016-09-30 01:50 171K
RE.zip 2016-09-30 01:50 39K
RO.zip 2016-09-30 01:50 891K
RS.zip 2016-09-30 01:50 640K
RU.zip 2016-09-30 01:50 12M
RW.zip 2016-09-30 01:50 455K
SA.zip 2016-09-30 01:50 860K
SB.zip 2016-09-30 01:50 222K
SC.zip 2016-09-30 01:50 18K
SD.zip 2016-09-30 01:50 723K
SE.zip 2016-09-30 01:51 2.3M
SG.zip 2016-09-30 01:51 55K
SH.zip 2016-09-30 01:51 19K
SI.zip 2016-09-30 01:51 265K
SJ.zip 2016-09-30 01:51 190K
SK.zip 2016-09-30 01:51 259K
SL.zip 2016-09-30 01:51 359K
SM.zip 2016-09-30 01:51 8.2K
SN.zip 2016-09-30 01:51 301K
SO.zip 2016-09-30 01:51 467K
SR.zip 2016-09-30 01:51 67K
SS.zip 2016-09-30 01:51 296K
ST.zip 2016-09-30 01:51 20K
SV.zip 2016-09-30 01:51 166K
SX.zip 2016-09-30 01:51 10K
SY.zip 2016-09-30 01:51 1.4M
SZ.zip 2016-09-30 01:51 16K
TC.zip 2016-09-30 01:51 21K
TD.zip 2016-09-30 01:51 532K
TF.zip 2016-09-30 01:51 55K
TG.zip 2016-09-30 01:51 125K
TH.zip 2016-09-30 01:51 8.6M
TJ.zip 2016-09-30 01:51 156K
TK.zip 2016-09-30 01:51 7.3K
TL.zip 2016-09-30 01:51 173K
TM.zip 2016-09-30 01:51 184K
TN.zip 2016-09-30 01:51 636K
TO.zip 2016-09-30 01:51 23K
TR.zip 2016-09-30 01:51 2.7M
TT.zip 2016-09-30 01:51 54K
TV.zip 2016-09-30 01:51 14K
TW.zip 2016-09-30 01:51 1.8M
TZ.zip 2016-09-30 01:51 479K
UA.zip 2016-09-30 01:51 1.6M
UG.zip 2016-09-30 01:51 454K
UM.zip 2016-09-30 01:51 16K
US.zip 2016-09-30 01:52 60M
UY.zip 2016-09-30 01:52 231K
UZ.zip 2016-09-30 01:52 295K
VA.zip 2016-09-30 01:52 5.8K
VC.zip 2016-09-30 01:52 15K
VE.zip 2016-09-30 01:52 1.6M
VG.zip 2016-09-30 01:52 20K
VI.zip 2016-09-30 01:52 54K
VN.zip 2016-09-30 01:53 1.7M
VU.zip 2016-09-30 01:53 97K
WF.zip 2016-09-30 01:53 15K
WS.zip 2016-09-30 01:53 29K
XK.zip 2016-09-30 01:53 195K
YE.zip 2016-09-30 01:53 2.0M
YT.zip 2016-09-30 01:53 22K
YU.zip 2016-09-30 01:53 3.5K
ZA.zip 2016-09-30 01:53 2.5M
ZM.zip 2016-09-30 01:53 629K
ZW.zip 2016-09-30 01:53 607K
![[TXT]](/icons/text.gif)
admin1CodesASCII.txt 2016-09-30 01:53 135K
admin2Codes.txt 2016-09-30 01:53 2.0M
allCountries.zip 2016-09-30 01:53 312M
alternateNames.zip 2016-09-30 01:54 114M
alternateNamesDeletes-2016-09-29.txt 2016-09-30 01:54 28
alternateNamesModifications-2016-09-29.txt 2016-09-30 01:54 9.4K
cities1000.zip 2016-09-30 01:53 7.7M
cities15000.zip 2016-09-30 01:53 2.1M
cities5000.zip 2016-09-30 01:53 3.5M
countryInfo.txt 2016-09-30 01:41 31K
deletes-2016-09-29.txt 2016-09-30 01:54 30
featureCodes_bg.txt 2016-09-30 01:41 64K
featureCodes_en.txt 2016-09-30 01:41 56K
featureCodes_nb.txt 2016-09-30 01:41 56K
featureCodes_nn.txt 2016-09-30 01:41 56K
featureCodes_no.txt 2016-09-30 01:41 56K
featureCodes_ru.txt 2016-09-30 01:41 112K
featureCodes_sv.txt 2016-09-30 01:41 56K
hierarchy.zip 2016-09-30 01:54 1.4M
iso-languagecodes.txt 2016-09-30 01:41 124K
modifications-2016-09-29.txt 2016-09-30 01:53 32K
no-country.zip 2016-09-30 01:53 189K
readme.txt 2016-09-30 01:41 7.8K
shapes_simplified_low.json.zip 2016-09-30 01:54 823K
shapes_simplified_low.zip 2016-09-30 01:54 822K
timeZones.txt 2016-09-30 01:54 14K
userTags.zip 2016-09-30 01:54 171K
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 150.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
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, 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 for a website, 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
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.
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