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 -
![[DIR]](/icons/folder.gif)
alternatenames/ 2024-11-21 03:33 -
![[TXT]](/icons/text.gif)
alternateNamesDelete..> 2024-11-21 03:33 35
deletes-2024-11-20.txt 2024-11-21 03:33 314
![[ ]](/icons/compressed.gif)
YU.zip 2024-11-21 03:29 3.8K
alternateNamesModifi..> 2024-11-21 03:33 4.0K
AN.zip 2024-11-21 03:22 4.1K
CS.zip 2024-11-21 03:24 5.1K
BV.zip 2024-11-21 03:23 7.1K
PN.zip 2024-11-21 03:27 7.4K
TK.zip 2024-11-21 03:27 7.8K
MC.zip 2024-11-21 03:26 8.2K
CC.zip 2024-11-21 03:23 8.4K
NF.zip 2024-11-21 03:26 8.5K
readme.txt 2024-11-21 03:20 8.6K
CX.zip 2024-11-21 03:24 8.8K
HM.zip 2024-11-21 03:24 9.8K
BL.zip 2024-11-21 03:23 11K
SM.zip 2024-11-21 03:27 11K
AI.zip 2024-11-21 03:22 11K
NU.zip 2024-11-21 03:26 12K
modifications-2024-1..> 2024-11-21 03:29 12K
VA.zip 2024-11-21 03:29 12K
IO.zip 2024-11-21 03:25 12K
SX.zip 2024-11-21 03:27 12K
IM.zip 2024-11-21 03:25 12K
NR.zip 2024-11-21 03:26 13K
MF.zip 2024-11-21 03:26 13K
timeZones.txt 2024-11-21 03:33 14K
MS.zip 2024-11-21 03:26 14K
MO.zip 2024-11-21 03:26 14K
GI.zip 2024-11-21 03:24 15K
TV.zip 2024-11-21 03:28 17K
KY.zip 2024-11-21 03:25 17K
CW.zip 2024-11-21 03:24 17K
AW.zip 2024-11-21 03:22 18K
JE.zip 2024-11-21 03:25 19K
UM.zip 2024-11-21 03:28 19K
PM.zip 2024-11-21 03:27 20K
WF.zip 2024-11-21 03:29 23K
BQ.zip 2024-11-21 03:23 23K
SH.zip 2024-11-21 03:27 23K
DM.zip 2024-11-21 03:24 23K
KN.zip 2024-11-21 03:25 23K
YT.zip 2024-11-21 03:29 24K
TC.zip 2024-11-21 03:27 24K
BM.zip 2024-11-21 03:23 24K
BT.zip 2024-11-21 03:23 25K
GG.zip 2024-11-21 03:24 27K
CK.zip 2024-11-21 03:23 27K
TO.zip 2024-11-21 03:27 28K
VG.zip 2024-11-21 03:29 28K
BN.zip 2024-11-21 03:23 28K
VC.zip 2024-11-21 03:29 29K
SC.zip 2024-11-21 03:27 30K
ST.zip 2024-11-21 03:27 30K
GD.zip 2024-11-21 03:24 30K
AG.zip 2024-11-21 03:22 31K
countryInfo.txt 2024-11-21 03:34 31K
AS.zip 2024-11-21 03:22 34K
BH.zip 2024-11-21 03:23 34K
WS.zip 2024-11-21 03:29 36K
GS.zip 2024-11-21 03:24 36K
KM.zip 2024-11-21 03:25 37K
BB.zip 2024-11-21 03:22 37K
FK.zip 2024-11-21 03:24 39K
KI.zip 2024-11-21 03:25 39K
PW.zip 2024-11-21 03:27 44K
MP.zip 2024-11-21 03:26 44K
CV.zip 2024-11-21 03:24 44K
LS.zip 2024-11-21 03:26 48K
LI.zip 2024-11-21 03:26 50K
GU.zip 2024-11-21 03:24 50K
LC.zip 2024-11-21 03:26 51K
LU.zip 2024-11-21 03:26 51K
SZ.zip 2024-11-21 03:27 53K
KW.zip 2024-11-21 03:25 55K
featureCodes_nn.txt 2024-11-21 03:20 57K
featureCodes_en.txt 2024-11-21 03:20 57K
featureCodes_nb.txt 2024-11-21 03:20 57K
featureCodes_no.txt 2024-11-21 03:20 57K
MH.zip 2024-11-21 03:26 58K
MU.zip 2024-11-21 03:26 58K
featureCodes_sv.txt 2024-11-21 03:20 58K
TF.zip 2024-11-21 03:27 59K
TT.zip 2024-11-21 03:28 63K
GM.zip 2024-11-21 03:24 64K
MV.zip 2024-11-21 03:26 64K
RE.zip 2024-11-21 03:27 66K
featureCodes_bg.txt 2024-11-21 03:20 66K
SG.zip 2024-11-21 03:27 67K
EH.zip 2024-11-21 03:24 67K
FO.zip 2024-11-21 03:24 68K
VI.zip 2024-11-21 03:29 70K
BZ.zip 2024-11-21 03:23 72K
SR.zip 2024-11-21 03:27 78K
BS.zip 2024-11-21 03:23 84K
AX.zip 2024-11-21 03:22 90K
MQ.zip 2024-11-21 03:26 94K
AD.zip 2024-11-21 03:22 95K
MT.zip 2024-11-21 03:26 95K
FM.zip 2024-11-21 03:24 102K
GQ.zip 2024-11-21 03:24 109K
BW.zip 2024-11-21 03:23 111K
GP.zip 2024-11-21 03:24 112K
featureCodes_ru.txt 2024-11-21 03:20 113K
GF.zip 2024-11-21 03:24 115K
HK.zip 2024-11-21 03:24 115K
PF.zip 2024-11-21 03:27 124K
TG.zip 2024-11-21 03:27 131K
VU.zip 2024-11-21 03:29 132K
iso-languagecodes.txt 2024-11-21 03:20 135K
NC.zip 2024-11-21 03:26 136K
MD.zip 2024-11-21 03:26 142K
GW.zip 2024-11-21 03:24 143K
admin1CodesASCII.txt 2024-11-21 03:29 144K
BJ.zip 2024-11-21 03:23 160K
GA.zip 2024-11-21 03:24 165K
TJ.zip 2024-11-21 03:27 166K
DJ.zip 2024-11-21 03:24 167K
GY.zip 2024-11-21 03:24 168K
QA.zip 2024-11-21 03:27 182K
userTags.zip 2024-11-21 03:34 183K
ER.zip 2024-11-21 03:24 191K
SJ.zip 2024-11-21 03:27 192K
TM.zip 2024-11-21 03:27 194K
NI.zip 2024-11-21 03:26 199K
TL.zip 2024-11-21 03:27 209K
XK.zip 2024-11-21 03:29 215K
GL.zip 2024-11-21 03:24 217K
SV.zip 2024-11-21 03:27 219K
JM.zip 2024-11-21 03:25 230K
no-country.zip 2024-11-21 03:29 232K
LR.zip 2024-11-21 03:26 239K
SB.zip 2024-11-21 03:27 244K
CG.zip 2024-11-21 03:23 250K
GN.zip 2024-11-21 03:24 252K
PR.zip 2024-11-21 03:27 263K
UY.zip 2024-11-21 03:29 265K
CY.zip 2024-11-21 03:24 284K
MN.zip 2024-11-21 03:26 290K
PS.zip 2024-11-21 03:27 297K
BF.zip 2024-11-21 03:23 302K
SS.zip 2024-11-21 03:27 311K
SN.zip 2024-11-21 03:27 312K
MR.zip 2024-11-21 03:26 315K
BI.zip 2024-11-21 03:23 320K
AE.zip 2024-11-21 03:22 330K
KG.zip 2024-11-21 03:25 332K
MW.zip 2024-11-21 03:26 332K
NA.zip 2024-11-21 03:26 345K
adminCode5.zip 2024-11-21 03:29 349K
UZ.zip 2024-11-21 03:29 352K
CF.zip 2024-11-21 03:23 354K
ME.zip 2024-11-21 03:26 365K
AL.zip 2024-11-21 03:22 368K
SL.zip 2024-11-21 03:27 369K
SI.zip 2024-11-21 03:27 373K
GE.zip 2024-11-21 03:24 383K
HT.zip 2024-11-21 03:24 414K
SK.zip 2024-11-21 03:27 430K
FJ.zip 2024-11-21 03:24 446K
DK.zip 2024-11-21 03:24 453K
IS.zip 2024-11-21 03:25 456K
RW.zip 2024-11-21 03:27 464K
HN.zip 2024-11-21 03:24 468K
SO.zip 2024-11-21 03:27 472K
EE.zip 2024-11-21 03:24 496K
TZ.zip 2024-11-21 03:28 510K
CI.zip 2024-11-21 03:23 527K
PY.zip 2024-11-21 03:27 531K
IL.zip 2024-11-21 03:25 555K
AQ.zip 2024-11-21 03:22 556K
CM.zip 2024-11-21 03:23 556K
EC.zip 2024-11-21 03:24 561K
AZ.zip 2024-11-21 03:22 561K
CR.zip 2024-11-21 03:24 565K
ET.zip 2024-11-21 03:24 565K
OM.zip 2024-11-21 03:26 568K
LV.zip 2024-11-21 03:26 573K
GH.zip 2024-11-21 03:24 579K
TD.zip 2024-11-21 03:27 587K
PG.zip 2024-11-21 03:27 593K
NE.zip 2024-11-21 03:26 623K
ZW.zip 2024-11-21 03:29 626K
ZM.zip 2024-11-21 03:29 643K
ML.zip 2024-11-21 03:26 648K
BE.zip 2024-11-21 03:22 659K
HU.zip 2024-11-21 03:24 672K
JO.zip 2024-11-21 03:25 674K
LA.zip 2024-11-21 03:26 691K
NL.zip 2024-11-21 03:26 702K
UG.zip 2024-11-21 03:28 711K
BG.zip 2024-11-21 03:23 725K
RS.zip 2024-11-21 03:27 737K
KH.zip 2024-11-21 03:25 752K
HR.zip 2024-11-21 03:24 773K
SD.zip 2024-11-21 03:27 776K
IE.zip 2024-11-21 03:25 797K
KE.zip 2024-11-21 03:25 822K
TN.zip 2024-11-21 03:27 874K
MK.zip 2024-11-21 03:26 885K
PA.zip 2024-11-21 03:27 887K
LY.zip 2024-11-21 03:26 936K
RO.zip 2024-11-21 03:27 1.0M
GT.zip 2024-11-21 03:24 1.0M
AM.zip 2024-11-21 03:22 1.0M
BO.zip 2024-11-21 03:23 1.0M
DO.zip 2024-11-21 03:24 1.0M
CU.zip 2024-11-21 03:24 1.0M
LT.zip 2024-11-21 03:26 1.0M
LB.zip 2024-11-21 03:26 1.1M
PT.zip 2024-11-21 03:27 1.1M
MZ.zip 2024-11-21 03:26 1.2M
BY.zip 2024-11-21 03:23 1.2M
SA.zip 2024-11-21 03:27 1.2M
shapes_simplified_lo..> 2024-11-21 03:34 1.2M
BA.zip 2024-11-21 03:22 1.3M
shapes_all_low.zip 2024-11-21 03:34 1.3M
MG.zip 2024-11-21 03:26 1.3M
CL.zip 2024-11-21 03:23 1.3M
NZ.zip 2024-11-21 03:26 1.4M
LK.zip 2024-11-21 03:26 1.4M
AT.zip 2024-11-21 03:22 1.5M
CD.zip 2024-11-21 03:23 1.5M
CZ.zip 2024-11-21 03:24 1.5M
BD.zip 2024-11-21 03:22 1.6M
MM.zip 2024-11-21 03:26 1.6M
AO.zip 2024-11-21 03:22 1.6M
GR.zip 2024-11-21 03:24 1.6M
MY.zip 2024-11-21 03:26 1.7M
KP.zip 2024-11-21 03:25 1.7M
VE.zip 2024-11-21 03:29 1.7M
DZ.zip 2024-11-21 03:24 1.7M
AR.zip 2024-11-21 03:22 1.7M
EG.zip 2024-11-21 03:24 1.8M
VN.zip 2024-11-21 03:29 1.8M
NG.zip 2024-11-21 03:26 1.8M
SY.zip 2024-11-21 03:27 1.9M
PL.zip 2024-11-21 03:27 1.9M
UA.zip 2024-11-21 03:28 1.9M
hierarchy.zip 2024-11-21 03:34 2.0M
CO.zip 2024-11-21 03:24 2.1M
TW.zip 2024-11-21 03:28 2.2M
admin2Codes.txt 2024-11-21 03:29 2.2M
PH.zip 2024-11-21 03:27 2.4M
SE.zip 2024-11-21 03:27 2.5M
ZA.zip 2024-11-21 03:29 2.6M
KZ.zip 2024-11-21 03:26 2.6M
CH.zip 2024-11-21 03:23 2.6M
IQ.zip 2024-11-21 03:25 2.7M
cities15000.zip 2024-11-21 03:29 2.7M
PE.zip 2024-11-21 03:27 2.8M
GB.zip 2024-11-21 03:24 2.9M
TR.zip 2024-11-21 03:28 3.1M
ES.zip 2024-11-21 03:24 3.1M
NP.zip 2024-11-21 03:26 3.2M
YE.zip 2024-11-21 03:29 3.5M
MA.zip 2024-11-21 03:26 4.0M
IT.zip 2024-11-21 03:25 4.1M
cities5000.zip 2024-11-21 03:29 4.5M
AF.zip 2024-11-21 03:22 4.6M
JP.zip 2024-11-21 03:25 4.7M
KR.zip 2024-11-21 03:25 5.0M
AU.zip 2024-11-21 03:22 5.4M
PK.zip 2024-11-21 03:27 5.9M
DE.zip 2024-11-21 03:24 6.5M
BR.zip 2024-11-21 03:23 6.8M
FR.zip 2024-11-21 03:24 6.9M
CA.zip 2024-11-21 03:23 7.7M
cities1000.zip 2024-11-21 03:29 8.9M
TH.zip 2024-11-21 03:27 9.3M
FI.zip 2024-11-21 03:24 9.3M
ID.zip 2024-11-21 03:25 9.8M
cities500.zip 2024-11-21 03:29 11M
MX.zip 2024-11-21 03:26 12M
IR.zip 2024-11-21 03:25 13M
RU.zip 2024-11-21 03:27 14M
IN.zip 2024-11-21 03:25 15M
NO.zip 2024-11-21 03:26 15M
CN.zip 2024-11-21 03:24 29M
US.zip 2024-11-21 03:29 68M
alternateNames.zip 2024-11-21 03:31 182M
alternateNamesV2.zip 2024-11-21 03:33 184M
allCountries.zip 2024-11-21 03:29 385M
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 down to PPLA4 (ca 185.000), see 'geoname' table for columns
cities1000.zip : all cities with a population > 1000 or seats of adm div down 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, optionally followed by a hyphen and a countrycode for country specific variants (ex:zh-CN) or by a variant name (ex: zh-Hant); 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
https://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:
https://www.geonames.org/datasources/
More Information is also available in the geonames faq :
https://forum.geonames.org/gforum/forums/show/6.page
The forum : https://forum.geonames.org
or the google group : https://groups.google.com/group/geonames