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 -
![[TXT]](/icons/text.gif)
iso-languagecodes.txt 2019-03-24 03:38 129K
countryInfo.txt 2019-03-24 03:38 31K
readme.txt 2019-03-24 03:38 8.5K
featureCodes_nn.txt 2019-03-24 03:38 57K
featureCodes_no.txt 2019-03-24 03:38 57K
featureCodes_sv.txt 2019-03-24 03:38 57K
featureCodes_ru.txt 2019-03-24 03:38 113K
featureCodes_nb.txt 2019-03-24 03:38 57K
featureCodes_bg.txt 2019-03-24 03:38 66K
featureCodes_en.txt 2019-03-24 03:38 57K
![[ ]](/icons/compressed.gif)
AD.zip 2019-03-24 03:43 92K
AE.zip 2019-03-24 03:43 237K
AF.zip 2019-03-24 03:44 4.5M
AG.zip 2019-03-24 03:44 26K
AI.zip 2019-03-24 03:44 10K
AL.zip 2019-03-24 03:44 327K
AM.zip 2019-03-24 03:44 1.0M
AN.zip 2019-03-24 03:44 3.9K
AO.zip 2019-03-24 03:44 1.1M
AQ.zip 2019-03-24 03:44 523K
AR.zip 2019-03-24 03:44 1.4M
AS.zip 2019-03-24 03:44 32K
AT.zip 2019-03-24 03:44 1.4M
AU.zip 2019-03-24 03:44 5.2M
AW.zip 2019-03-24 03:44 17K
AX.zip 2019-03-24 03:44 76K
AZ.zip 2019-03-24 03:44 433K
BA.zip 2019-03-24 03:44 1.2M
BB.zip 2019-03-24 03:44 34K
BD.zip 2019-03-24 03:44 1.5M
BE.zip 2019-03-24 03:44 614K
BF.zip 2019-03-24 03:44 270K
BG.zip 2019-03-24 03:44 689K
BH.zip 2019-03-24 03:44 30K
BI.zip 2019-03-24 03:44 297K
BJ.zip 2019-03-24 03:44 150K
BL.zip 2019-03-24 03:44 9.3K
BM.zip 2019-03-24 03:44 23K
BN.zip 2019-03-24 03:44 25K
BO.zip 2019-03-24 03:44 738K
BQ.zip 2019-03-24 03:44 16K
BR.zip 2019-03-24 03:44 3.1M
BS.zip 2019-03-24 03:44 71K
BT.zip 2019-03-24 03:44 22K
BV.zip 2019-03-24 03:44 6.3K
BW.zip 2019-03-24 03:44 103K
BY.zip 2019-03-24 03:44 1.1M
BZ.zip 2019-03-24 03:44 67K
CA.zip 2019-03-24 03:44 7.4M
CC.zip 2019-03-24 03:44 7.2K
CD.zip 2019-03-24 03:44 1.4M
CF.zip 2019-03-24 03:44 336K
CG.zip 2019-03-24 03:44 245K
CH.zip 2019-03-24 03:44 2.5M
CI.zip 2019-03-24 03:44 460K
CK.zip 2019-03-24 03:44 25K
CL.zip 2019-03-24 03:45 1.3M
CM.zip 2019-03-24 03:45 515K
CN.zip 2019-03-24 03:45 24M
CO.zip 2019-03-24 03:45 2.0M
CR.zip 2019-03-24 03:45 190K
CS.zip 2019-03-24 03:45 4.8K
CU.zip 2019-03-24 03:45 1.0M
CV.zip 2019-03-24 03:45 41K
CW.zip 2019-03-24 03:45 16K
CX.zip 2019-03-24 03:45 7.7K
CY.zip 2019-03-24 03:45 258K
CZ.zip 2019-03-24 03:45 1.2M
DE.zip 2019-03-24 03:45 6.0M
DJ.zip 2019-03-24 03:45 160K
DK.zip 2019-03-24 03:45 438K
DM.zip 2019-03-24 03:45 16K
DO.zip 2019-03-24 03:45 1.0M
DZ.zip 2019-03-24 03:45 1.5M
EC.zip 2019-03-24 03:45 420K
EE.zip 2019-03-24 03:45 483K
EG.zip 2019-03-24 03:45 1.5M
EH.zip 2019-03-24 03:45 67K
ER.zip 2019-03-24 03:45 180K
ES.zip 2019-03-24 03:45 2.8M
ET.zip 2019-03-24 03:45 544K
FI.zip 2019-03-24 03:46 2.0M
FJ.zip 2019-03-24 03:46 445K
FK.zip 2019-03-24 03:46 37K
FM.zip 2019-03-24 03:46 99K
FO.zip 2019-03-24 03:46 63K
FR.zip 2019-03-24 03:46 5.8M
GA.zip 2019-03-24 03:46 158K
GB.zip 2019-03-24 03:46 2.0M
GD.zip 2019-03-24 03:46 25K
GE.zip 2019-03-24 03:46 329K
GF.zip 2019-03-24 03:46 114K
GG.zip 2019-03-24 03:46 27K
GH.zip 2019-03-24 03:46 462K
GI.zip 2019-03-24 03:46 12K
GL.zip 2019-03-24 03:46 210K
GM.zip 2019-03-24 03:46 58K
GN.zip 2019-03-24 03:46 238K
GP.zip 2019-03-24 03:46 112K
GQ.zip 2019-03-24 03:46 107K
GR.zip 2019-03-24 03:46 1.5M
GS.zip 2019-03-24 03:46 30K
GT.zip 2019-03-24 03:46 568K
GU.zip 2019-03-24 03:46 49K
GW.zip 2019-03-24 03:46 143K
GY.zip 2019-03-24 03:46 151K
HK.zip 2019-03-24 03:46 105K
HM.zip 2019-03-24 03:46 8.3K
HN.zip 2019-03-24 03:46 415K
HR.zip 2019-03-24 03:46 666K
HT.zip 2019-03-24 03:46 377K
HU.zip 2019-03-24 03:46 644K
ID.zip 2019-03-24 03:46 8.1M
IE.zip 2019-03-24 03:46 664K
IL.zip 2019-03-24 03:46 456K
IM.zip 2019-03-24 03:46 9.7K
IN.zip 2019-03-24 03:46 14M
IO.zip 2019-03-24 03:46 11K
IQ.zip 2019-03-24 03:47 2.4M
IR.zip 2019-03-24 03:47 12M
IS.zip 2019-03-24 03:47 439K
IT.zip 2019-03-24 03:47 3.9M
JE.zip 2019-03-24 03:47 18K
JM.zip 2019-03-24 03:47 138K
JO.zip 2019-03-24 03:47 526K
JP.zip 2019-03-24 03:47 4.4M
KE.zip 2019-03-24 03:47 792K
KG.zip 2019-03-24 03:47 323K
KH.zip 2019-03-24 03:47 643K
KI.zip 2019-03-24 03:47 37K
KM.zip 2019-03-24 03:47 34K
KN.zip 2019-03-24 03:47 21K
KP.zip 2019-03-24 03:47 1.3M
KR.zip 2019-03-24 03:47 4.3M
KW.zip 2019-03-24 03:47 48K
KY.zip 2019-03-24 03:47 14K
KZ.zip 2019-03-24 03:47 1.4M
LA.zip 2019-03-24 03:47 682K
LB.zip 2019-03-24 03:47 1.0M
LC.zip 2019-03-24 03:47 48K
LI.zip 2019-03-24 03:47 49K
LK.zip 2019-03-24 03:47 1.4M
LR.zip 2019-03-24 03:47 231K
LS.zip 2019-03-24 03:47 40K
LT.zip 2019-03-24 03:47 962K
LU.zip 2019-03-24 03:47 47K
LV.zip 2019-03-24 03:47 356K
LY.zip 2019-03-24 03:47 924K
MA.zip 2019-03-24 03:47 3.9M
MC.zip 2019-03-24 03:47 7.9K
MD.zip 2019-03-24 03:47 128K
ME.zip 2019-03-24 03:47 358K
MF.zip 2019-03-24 03:47 12K
MG.zip 2019-03-24 03:47 1.3M
MH.zip 2019-03-24 03:47 57K
MK.zip 2019-03-24 03:47 870K
ML.zip 2019-03-24 03:47 605K
MM.zip 2019-03-24 03:48 1.2M
MN.zip 2019-03-24 03:48 278K
MO.zip 2019-03-24 03:48 12K
MP.zip 2019-03-24 03:48 43K
MQ.zip 2019-03-24 03:48 94K
MR.zip 2019-03-24 03:48 306K
MS.zip 2019-03-24 03:48 12K
MT.zip 2019-03-24 03:48 92K
MU.zip 2019-03-24 03:48 53K
MV.zip 2019-03-24 03:48 35K
MW.zip 2019-03-24 03:48 212K
MX.zip 2019-03-24 03:48 12M
MY.zip 2019-03-24 03:48 1.5M
MZ.zip 2019-03-24 03:48 1.1M
NA.zip 2019-03-24 03:48 185K
NC.zip 2019-03-24 03:48 131K
NE.zip 2019-03-24 03:48 612K
NF.zip 2019-03-24 03:48 7.6K
NG.zip 2019-03-24 03:48 1.6M
NI.zip 2019-03-24 03:48 178K
NL.zip 2019-03-24 03:48 649K
NO.zip 2019-03-24 03:48 15M
NP.zip 2019-03-24 03:48 2.8M
NR.zip 2019-03-24 03:48 8.8K
NU.zip 2019-03-24 03:48 11K
NZ.zip 2019-03-24 03:48 1.3M
OM.zip 2019-03-24 03:48 541K
PA.zip 2019-03-24 03:48 427K
PE.zip 2019-03-24 03:48 2.7M
PF.zip 2019-03-24 03:48 75K
PG.zip 2019-03-24 03:48 567K
PH.zip 2019-03-24 03:49 2.3M
PK.zip 2019-03-24 03:49 5.7M
PL.zip 2019-03-24 03:49 1.8M
PM.zip 2019-03-24 03:49 19K
PN.zip 2019-03-24 03:49 6.2K
PR.zip 2019-03-24 03:49 258K
PS.zip 2019-03-24 03:49 289K
PT.zip 2019-03-24 03:49 1.0M
PW.zip 2019-03-24 03:49 39K
PY.zip 2019-03-24 03:49 479K
QA.zip 2019-03-24 03:49 173K
RE.zip 2019-03-24 03:49 65K
RO.zip 2019-03-24 03:49 901K
RS.zip 2019-03-24 03:49 659K
RU.zip 2019-03-24 03:49 12M
RW.zip 2019-03-24 03:49 457K
SA.zip 2019-03-24 03:49 1.0M
SB.zip 2019-03-24 03:49 224K
SC.zip 2019-03-24 03:49 21K
SD.zip 2019-03-24 03:49 727K
SE.zip 2019-03-24 03:49 2.4M
SG.zip 2019-03-24 03:49 58K
SH.zip 2019-03-24 03:49 22K
SI.zip 2019-03-24 03:49 267K
SJ.zip 2019-03-24 03:49 192K
SK.zip 2019-03-24 03:49 266K
SL.zip 2019-03-24 03:49 360K
SM.zip 2019-03-24 03:49 8.5K
SN.zip 2019-03-24 03:49 303K
SO.zip 2019-03-24 03:49 469K
SR.zip 2019-03-24 03:49 69K
SS.zip 2019-03-24 03:49 298K
ST.zip 2019-03-24 03:49 22K
SV.zip 2019-03-24 03:49 177K
SX.zip 2019-03-24 03:49 11K
SY.zip 2019-03-24 03:49 1.8M
SZ.zip 2019-03-24 03:49 17K
TC.zip 2019-03-24 03:49 22K
TD.zip 2019-03-24 03:49 553K
TF.zip 2019-03-24 03:49 57K
TG.zip 2019-03-24 03:49 126K
TH.zip 2019-03-24 03:50 8.6M
TJ.zip 2019-03-24 03:50 161K
TK.zip 2019-03-24 03:50 7.5K
TL.zip 2019-03-24 03:50 204K
TM.zip 2019-03-24 03:50 185K
TN.zip 2019-03-24 03:50 782K
TO.zip 2019-03-24 03:50 25K
TR.zip 2019-03-24 03:50 2.7M
TT.zip 2019-03-24 03:50 56K
TV.zip 2019-03-24 03:50 14K
TW.zip 2019-03-24 03:50 2.2M
TZ.zip 2019-03-24 03:50 484K
UA.zip 2019-03-24 03:50 1.7M
UG.zip 2019-03-24 03:50 673K
UM.zip 2019-03-24 03:50 17K
US.zip 2019-03-24 03:51 66M
UY.zip 2019-03-24 03:51 246K
UZ.zip 2019-03-24 03:51 301K
VA.zip 2019-03-24 03:51 6.3K
VC.zip 2019-03-24 03:51 23K
VE.zip 2019-03-24 03:51 1.6M
VG.zip 2019-03-24 03:51 26K
VI.zip 2019-03-24 03:51 67K
VN.zip 2019-03-24 03:51 1.7M
VU.zip 2019-03-24 03:51 104K
WF.zip 2019-03-24 03:51 20K
WS.zip 2019-03-24 03:51 30K
XK.zip 2019-03-24 03:51 196K
YE.zip 2019-03-24 03:51 3.0M
YT.zip 2019-03-24 03:51 22K
YU.zip 2019-03-24 03:51 3.7K
ZA.zip 2019-03-24 03:51 2.5M
ZM.zip 2019-03-24 03:51 633K
ZW.zip 2019-03-24 03:51 617K
allCountries.zip 2019-03-24 03:51 342M
no-country.zip 2019-03-24 03:51 196K
cities1000.zip 2019-03-24 03:51 7.4M
cities500.zip 2019-03-24 03:51 9.5M
cities5000.zip 2019-03-24 03:51 3.6M
admin1CodesASCII.txt 2019-03-24 03:51 134K
admin2Codes.txt 2019-03-24 03:51 2.1M
adminCode5.zip 2019-03-24 03:51 557K
cities15000.zip 2019-03-24 03:51 2.2M
modifications-2019-0..> 2019-03-24 03:51 5.2M
alternateNames.zip 2019-03-24 03:53 148M
alternateNamesModifi..> 2019-03-24 03:53 6.2K
![[DIR]](/icons/folder.gif)
alternatenames/ 2019-03-24 03:56 -
alternateNamesV2.zip 2019-03-24 03:56 150M
timeZones.txt 2019-03-24 03:56 14K
deletes-2019-03-23.txt 2019-03-24 03:56 46
alternateNamesDelete..> 2019-03-24 03:56 107
userTags.zip 2019-03-24 03:56 176K
hierarchy.zip 2019-03-24 03:57 1.9M
shapes_all_low.zip 2019-03-24 03:58 955K
shapes_simplified_lo..> 2019-03-24 03:58 924K
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 to PPLA4 (ca 185.000), see 'geoname' table for columns
cities1000.zip : all cities with a population > 1000 or seats of adm div 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