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 2017-06-25 02:33 173K
![[TXT]](/icons/text.gif)
timeZones.txt 2017-06-25 02:33 14K
shapes_simplified_low.json.zip 2017-06-25 02:34 900K
shapes_all_low.zip 2017-06-25 02:34 898K
readme.txt 2017-06-25 02:19 8.0K
no-country.zip 2017-06-25 02:32 191K
modifications-2017-06-24.txt 2017-06-25 02:32 25K
iso-languagecodes.txt 2017-06-25 02:19 129K
hierarchy.zip 2017-06-25 02:34 1.5M
featureCodes_sv.txt 2017-06-25 02:19 57K
featureCodes_ru.txt 2017-06-25 02:19 112K
featureCodes_no.txt 2017-06-25 02:19 56K
featureCodes_nn.txt 2017-06-25 02:19 56K
featureCodes_nb.txt 2017-06-25 02:19 56K
featureCodes_en.txt 2017-06-25 02:19 56K
featureCodes_bg.txt 2017-06-25 02:19 65K
deletes-2017-06-24.txt 2017-06-25 02:33 1.8K
countryInfo.txt 2017-06-25 02:19 31K
cities5000.zip 2017-06-25 02:32 3.6M
cities15000.zip 2017-06-25 02:32 2.2M
cities1000.zip 2017-06-25 02:32 7.9M
alternateNamesModifications-2017-06-24.txt 2017-06-25 02:33 7.2K
alternateNamesDeletes-2017-06-24.txt 2017-06-25 02:33 178
alternateNames.zip 2017-06-25 02:33 128M
allCountries.zip 2017-06-25 02:32 327M
adminCode5.zip 2017-06-25 02:32 544K
admin2Codes.txt 2017-06-25 02:32 2.1M
admin1CodesASCII.txt 2017-06-25 02:32 133K
ZW.zip 2017-06-25 02:32 609K
ZM.zip 2017-06-25 02:32 630K
ZA.zip 2017-06-25 02:32 2.5M
YU.zip 2017-06-25 02:32 3.6K
YT.zip 2017-06-25 02:32 22K
YE.zip 2017-06-25 02:32 2.1M
XK.zip 2017-06-25 02:32 195K
WS.zip 2017-06-25 02:32 30K
WF.zip 2017-06-25 02:32 15K
VU.zip 2017-06-25 02:32 97K
VN.zip 2017-06-25 02:32 1.7M
VI.zip 2017-06-25 02:32 67K
VG.zip 2017-06-25 02:32 20K
VE.zip 2017-06-25 02:32 1.6M
VC.zip 2017-06-25 02:32 22K
VA.zip 2017-06-25 02:32 6.1K
UZ.zip 2017-06-25 02:32 299K
UY.zip 2017-06-25 02:32 232K
US.zip 2017-06-25 02:32 65M
UM.zip 2017-06-25 02:30 17K
UG.zip 2017-06-25 02:30 633K
UA.zip 2017-06-25 02:30 1.6M
TZ.zip 2017-06-25 02:30 481K
TW.zip 2017-06-25 02:30 1.8M
TV.zip 2017-06-25 02:30 14K
TT.zip 2017-06-25 02:30 55K
TR.zip 2017-06-25 02:30 2.7M
TO.zip 2017-06-25 02:30 24K
TN.zip 2017-06-25 02:30 640K
TM.zip 2017-06-25 02:30 185K
TL.zip 2017-06-25 02:30 193K
TK.zip 2017-06-25 02:30 7.4K
TJ.zip 2017-06-25 02:30 161K
TH.zip 2017-06-25 02:30 8.6M
TG.zip 2017-06-25 02:30 126K
TF.zip 2017-06-25 02:30 56K
TD.zip 2017-06-25 02:30 549K
TC.zip 2017-06-25 02:30 21K
SZ.zip 2017-06-25 02:30 16K
SY.zip 2017-06-25 02:30 1.7M
SX.zip 2017-06-25 02:29 11K
SV.zip 2017-06-25 02:29 167K
ST.zip 2017-06-25 02:29 20K
SS.zip 2017-06-25 02:29 298K
SR.zip 2017-06-25 02:29 68K
SO.zip 2017-06-25 02:29 468K
SN.zip 2017-06-25 02:29 302K
SM.zip 2017-06-25 02:29 8.3K
SL.zip 2017-06-25 02:29 359K
SK.zip 2017-06-25 02:29 260K
SJ.zip 2017-06-25 02:29 190K
SI.zip 2017-06-25 02:29 265K
SH.zip 2017-06-25 02:29 21K
SG.zip 2017-06-25 02:29 55K
SE.zip 2017-06-25 02:29 2.4M
SD.zip 2017-06-25 02:29 723K
SC.zip 2017-06-25 02:29 18K
SB.zip 2017-06-25 02:29 222K
SA.zip 2017-06-25 02:29 866K
RW.zip 2017-06-25 02:29 455K
RU.zip 2017-06-25 02:29 12M
RS.zip 2017-06-25 02:29 642K
RO.zip 2017-06-25 02:29 893K
RE.zip 2017-06-25 02:29 39K
QA.zip 2017-06-25 02:29 171K
PY.zip 2017-06-25 02:29 98K
PW.zip 2017-06-25 02:29 38K
PT.zip 2017-06-25 02:29 899K
PS.zip 2017-06-25 02:29 283K
PR.zip 2017-06-25 02:29 257K
PN.zip 2017-06-25 02:29 6.0K
PM.zip 2017-06-25 02:29 18K
PL.zip 2017-06-25 02:29 1.8M
PK.zip 2017-06-25 02:29 5.5M
PH.zip 2017-06-25 02:29 1.9M
PG.zip 2017-06-25 02:29 558K
PF.zip 2017-06-25 02:29 74K
PE.zip 2017-06-25 02:29 2.6M
PA.zip 2017-06-25 02:29 407K
OM.zip 2017-06-25 02:29 252K
NZ.zip 2017-06-25 02:29 1.3M
NU.zip 2017-06-25 02:28 6.4K
NR.zip 2017-06-25 02:28 8.6K
NP.zip 2017-06-25 02:28 2.5M
NO.zip 2017-06-25 02:28 15M
NL.zip 2017-06-25 02:28 640K
NI.zip 2017-06-25 02:28 174K
NG.zip 2017-06-25 02:28 1.5M
NF.zip 2017-06-25 02:28 7.4K
NE.zip 2017-06-25 02:28 607K
NC.zip 2017-06-25 02:28 111K
NA.zip 2017-06-25 02:28 182K
MZ.zip 2017-06-25 02:28 1.1M
MY.zip 2017-06-25 02:28 1.5M
MX.zip 2017-06-25 02:28 12M
MW.zip 2017-06-25 02:28 205K
MV.zip 2017-06-25 02:28 34K
MU.zip 2017-06-25 02:28 52K
MT.zip 2017-06-25 02:28 91K
MS.zip 2017-06-25 02:28 11K
MR.zip 2017-06-25 02:28 303K
MQ.zip 2017-06-25 02:28 55K
MP.zip 2017-06-25 02:28 42K
MO.zip 2017-06-25 02:28 12K
MN.zip 2017-06-25 02:28 276K
MM.zip 2017-06-25 02:28 1.2M
ML.zip 2017-06-25 02:28 602K
MK.zip 2017-06-25 02:27 869K
MH.zip 2017-06-25 02:27 56K
MG.zip 2017-06-25 02:27 598K
MF.zip 2017-06-25 02:27 11K
ME.zip 2017-06-25 02:27 348K
MD.zip 2017-06-25 02:27 127K
MC.zip 2017-06-25 02:27 7.4K
MA.zip 2017-06-25 02:27 3.5M
LY.zip 2017-06-25 02:27 828K
LV.zip 2017-06-25 02:27 323K
LU.zip 2017-06-25 02:27 44K
LT.zip 2017-06-25 02:27 957K
LS.zip 2017-06-25 02:27 40K
LR.zip 2017-06-25 02:27 230K
LK.zip 2017-06-25 02:27 1.0M
LI.zip 2017-06-25 02:27 48K
LC.zip 2017-06-25 02:27 39K
LB.zip 2017-06-25 02:27 856K
LA.zip 2017-06-25 02:27 681K
KZ.zip 2017-06-25 02:27 1.4M
KY.zip 2017-06-25 02:27 14K
KW.zip 2017-06-25 02:27 48K
KR.zip 2017-06-25 02:27 3.7M
KP.zip 2017-06-25 02:27 1.3M
KN.zip 2017-06-25 02:27 18K
KM.zip 2017-06-25 02:27 34K
KI.zip 2017-06-25 02:27 37K
KH.zip 2017-06-25 02:27 613K
KG.zip 2017-06-25 02:27 322K
KE.zip 2017-06-25 02:27 620K
JP.zip 2017-06-25 02:27 3.9M
JO.zip 2017-06-25 02:27 414K
JM.zip 2017-06-25 02:27 135K
JE.zip 2017-06-25 02:27 18K
IT.zip 2017-06-25 02:27 3.7M
IS.zip 2017-06-25 02:27 433K
IR.zip 2017-06-25 02:27 11M
IQ.zip 2017-06-25 02:27 2.2M
IO.zip 2017-06-25 02:26 11K
IN.zip 2017-06-25 02:26 13M
IM.zip 2017-06-25 02:26 9.4K
IL.zip 2017-06-25 02:26 438K
IE.zip 2017-06-25 02:26 644K
ID.zip 2017-06-25 02:26 8.1M
HU.zip 2017-06-25 02:26 641K
HT.zip 2017-06-25 02:26 375K
HR.zip 2017-06-25 02:26 659K
HN.zip 2017-06-25 02:26 408K
HM.zip 2017-06-25 02:26 8.0K
HK.zip 2017-06-25 02:26 103K
GY.zip 2017-06-25 02:26 148K
GW.zip 2017-06-25 02:26 141K
GU.zip 2017-06-25 02:26 49K
GT.zip 2017-06-25 02:26 469K
GS.zip 2017-06-25 02:26 29K
GR.zip 2017-06-25 02:26 1.5M
GQ.zip 2017-06-25 02:26 106K
GP.zip 2017-06-25 02:26 109K
GN.zip 2017-06-25 02:26 236K
GM.zip 2017-06-25 02:26 57K
GL.zip 2017-06-25 02:26 201K
GI.zip 2017-06-25 02:26 12K
GH.zip 2017-06-25 02:26 316K
GG.zip 2017-06-25 02:26 27K
GF.zip 2017-06-25 02:26 107K
GE.zip 2017-06-25 02:26 325K
GD.zip 2017-06-25 02:26 22K
GB.zip 2017-06-25 02:26 1.9M
GA.zip 2017-06-25 02:26 156K
FR.zip 2017-06-25 02:26 5.7M
FO.zip 2017-06-25 02:26 61K
FM.zip 2017-06-25 02:26 99K
FK.zip 2017-06-25 02:26 36K
FJ.zip 2017-06-25 02:26 368K
FI.zip 2017-06-25 02:26 1.9M
ET.zip 2017-06-25 02:25 540K
ES.zip 2017-06-25 02:25 2.6M
ER.zip 2017-06-25 02:25 178K
EH.zip 2017-06-25 02:25 66K
EG.zip 2017-06-25 02:25 1.4M
EE.zip 2017-06-25 02:25 492K
EC.zip 2017-06-25 02:25 407K
DZ.zip 2017-06-25 02:25 1.5M
DO.zip 2017-06-25 02:25 1.0M
DM.zip 2017-06-25 02:25 14K
DK.zip 2017-06-25 02:25 427K
DJ.zip 2017-06-25 02:25 157K
DE.zip 2017-06-25 02:25 5.7M
CZ.zip 2017-06-25 02:25 849K
CY.zip 2017-06-25 02:25 251K
CX.zip 2017-06-25 02:25 7.1K
CW.zip 2017-06-25 02:25 16K
CV.zip 2017-06-25 02:25 33K
CU.zip 2017-06-25 02:25 936K
CS.zip 2017-06-25 02:25 4.7K
CR.zip 2017-06-25 02:25 185K
CO.zip 2017-06-25 02:25 1.9M
CN.zip 2017-06-25 02:25 22M
CM.zip 2017-06-25 02:24 511K
CL.zip 2017-06-25 02:24 1.1M
CK.zip 2017-06-25 02:24 21K
CI.zip 2017-06-25 02:24 458K
CH.zip 2017-06-25 02:24 2.1M
CG.zip 2017-06-25 02:24 243K
CF.zip 2017-06-25 02:24 335K
CD.zip 2017-06-25 02:24 1.4M
CC.zip 2017-06-25 02:24 7.0K
CA.zip 2017-06-25 02:24 7.4M
BZ.zip 2017-06-25 02:24 65K
BY.zip 2017-06-25 02:24 1.0M
BW.zip 2017-06-25 02:24 101K
BV.zip 2017-06-25 02:24 6.2K
BT.zip 2017-06-25 02:24 20K
BS.zip 2017-06-25 02:24 69K
BR.zip 2017-06-25 02:24 3.0M
BQ.zip 2017-06-25 02:24 15K
BO.zip 2017-06-25 02:24 698K
BN.zip 2017-06-25 02:24 23K
BM.zip 2017-06-25 02:24 22K
BL.zip 2017-06-25 02:24 8.0K
BJ.zip 2017-06-25 02:24 136K
BI.zip 2017-06-25 02:24 294K
BH.zip 2017-06-25 02:24 29K
BG.zip 2017-06-25 02:24 636K
BF.zip 2017-06-25 02:24 253K
BE.zip 2017-06-25 02:24 608K
BD.zip 2017-06-25 02:24 1.5M
BB.zip 2017-06-25 02:24 27K
BA.zip 2017-06-25 02:24 1.2M
AZ.zip 2017-06-25 02:24 371K
AX.zip 2017-06-25 02:24 75K
AW.zip 2017-06-25 02:24 13K
AU.zip 2017-06-25 02:24 5.1M
AT.zip 2017-06-25 02:24 1.3M
AS.zip 2017-06-25 02:24 31K
AR.zip 2017-06-25 02:24 1.4M
AQ.zip 2017-06-25 02:24 523K
AO.zip 2017-06-25 02:24 1.1M
AN.zip 2017-06-25 02:24 3.6K
AM.zip 2017-06-25 02:24 1.0M
AL.zip 2017-06-25 02:24 297K
AI.zip 2017-06-25 02:24 9.0K
AG.zip 2017-06-25 02:24 20K
AF.zip 2017-06-25 02:24 4.5M
AE.zip 2017-06-25 02:23 228K
AD.zip 2017-06-25 02:23 89K
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. 'no-country' for features not belonging to a country.
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.
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 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