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)
.zip 20-Jun-2013 02:55 2.9K
AD.zip 20-Jun-2013 02:55 63K
AE.zip 20-Jun-2013 02:55 197K
AF.zip 20-Jun-2013 02:56 4.4M
AG.zip 20-Jun-2013 02:56 17K
AI.zip 20-Jun-2013 02:56 7.3K
AL.zip 20-Jun-2013 02:56 274K
AM.zip 20-Jun-2013 02:56 77K
AO.zip 20-Jun-2013 02:56 1.1M
AQ.zip 20-Jun-2013 02:56 504K
AR.zip 20-Jun-2013 02:56 1.2M
AS.zip 20-Jun-2013 02:56 29K
AT.zip 20-Jun-2013 02:56 1.0M
AU.zip 20-Jun-2013 02:56 2.6M
AW.zip 20-Jun-2013 02:56 9.1K
AX.zip 20-Jun-2013 02:56 68K
AZ.zip 20-Jun-2013 02:56 273K
BA.zip 20-Jun-2013 02:56 1.2M
BB.zip 20-Jun-2013 02:56 19K
BD.zip 20-Jun-2013 02:56 1.2M
BE.zip 20-Jun-2013 02:56 523K
BF.zip 20-Jun-2013 02:56 246K
BG.zip 20-Jun-2013 02:56 449K
BH.zip 20-Jun-2013 02:56 22K
BI.zip 20-Jun-2013 02:56 229K
BJ.zip 20-Jun-2013 02:56 129K
BL.zip 20-Jun-2013 02:56 6.8K
BM.zip 20-Jun-2013 02:56 19K
BN.zip 20-Jun-2013 02:56 21K
BO.zip 20-Jun-2013 02:56 637K
BQ.zip 20-Jun-2013 02:56 12K
BR.zip 20-Jun-2013 02:56 2.7M
BS.zip 20-Jun-2013 02:56 51K
BT.zip 20-Jun-2013 02:56 15K
BV.zip 20-Jun-2013 02:56 5.6K
BW.zip 20-Jun-2013 02:56 94K
BY.zip 20-Jun-2013 02:56 1.0M
BZ.zip 20-Jun-2013 02:56 50K
CA.zip 20-Jun-2013 02:57 6.8M
CC.zip 20-Jun-2013 02:57 6.1K
CD.zip 20-Jun-2013 02:57 1.2M
CF.zip 20-Jun-2013 02:57 319K
CG.zip 20-Jun-2013 02:57 239K
CH.zip 20-Jun-2013 02:57 692K
CI.zip 20-Jun-2013 02:57 444K
CK.zip 20-Jun-2013 02:57 18K
CL.zip 20-Jun-2013 02:57 1.0M
CM.zip 20-Jun-2013 02:57 414K
CN.zip 20-Jun-2013 02:57 10M
CO.zip 20-Jun-2013 02:57 1.6M
CR.zip 20-Jun-2013 02:57 114K
CU.zip 20-Jun-2013 02:57 793K
CV.zip 20-Jun-2013 02:57 25K
CW.zip 20-Jun-2013 02:57 13K
CX.zip 20-Jun-2013 02:57 6.0K
CY.zip 20-Jun-2013 02:57 139K
CZ.zip 20-Jun-2013 02:57 591K
DE.zip 20-Jun-2013 02:57 4.7M
DJ.zip 20-Jun-2013 02:57 154K
DK.zip 20-Jun-2013 02:57 396K
DM.zip 20-Jun-2013 02:57 13K
DO.zip 20-Jun-2013 02:58 550K
DZ.zip 20-Jun-2013 02:58 1.4M
EC.zip 20-Jun-2013 02:58 341K
EE.zip 20-Jun-2013 02:58 227K
EG.zip 20-Jun-2013 02:58 1.1M
EH.zip 20-Jun-2013 02:58 64K
ER.zip 20-Jun-2013 02:58 174K
ES.zip 20-Jun-2013 02:58 1.9M
ET.zip 20-Jun-2013 02:58 502K
FI.zip 20-Jun-2013 02:58 947K
FJ.zip 20-Jun-2013 02:58 211K
FK.zip 20-Jun-2013 02:58 35K
FM.zip 20-Jun-2013 02:58 94K
FO.zip 20-Jun-2013 02:58 53K
FR.zip 20-Jun-2013 02:58 4.2M
GA.zip 20-Jun-2013 02:58 151K
GB.zip 20-Jun-2013 02:58 1.5M
GD.zip 20-Jun-2013 02:58 18K
GE.zip 20-Jun-2013 02:58 284K
GF.zip 20-Jun-2013 02:58 76K
GG.zip 20-Jun-2013 02:58 23K
GH.zip 20-Jun-2013 02:58 307K
GI.zip 20-Jun-2013 02:58 10K
GL.zip 20-Jun-2013 02:58 195K
GM.zip 20-Jun-2013 02:58 54K
GN.zip 20-Jun-2013 02:58 225K
GP.zip 20-Jun-2013 02:58 42K
GQ.zip 20-Jun-2013 02:58 103K
GR.zip 20-Jun-2013 02:58 910K
GS.zip 20-Jun-2013 02:58 19K
GT.zip 20-Jun-2013 02:58 305K
GU.zip 20-Jun-2013 02:58 46K
GW.zip 20-Jun-2013 02:58 139K
GY.zip 20-Jun-2013 02:58 142K
HK.zip 20-Jun-2013 02:58 55K
HM.zip 20-Jun-2013 02:58 7.0K
HN.zip 20-Jun-2013 02:58 394K
HR.zip 20-Jun-2013 02:58 560K
HT.zip 20-Jun-2013 02:58 315K
HU.zip 20-Jun-2013 02:58 604K
ID.zip 20-Jun-2013 02:59 7.5M
IE.zip 20-Jun-2013 02:59 538K
IL.zip 20-Jun-2013 02:59 298K
IM.zip 20-Jun-2013 02:59 7.4K
IN.zip 20-Jun-2013 02:59 1.4M
IO.zip 20-Jun-2013 02:59 9.1K
IQ.zip 20-Jun-2013 02:59 2.0M
IR.zip 20-Jun-2013 02:59 8.2M
IS.zip 20-Jun-2013 02:59 393K
IT.zip 20-Jun-2013 02:59 1.6M
JE.zip 20-Jun-2013 02:59 14K
JM.zip 20-Jun-2013 02:59 96K
JO.zip 20-Jun-2013 02:59 240K
JP.zip 20-Jun-2013 02:59 1.8M
KE.zip 20-Jun-2013 02:59 577K
KG.zip 20-Jun-2013 02:59 300K
KH.zip 20-Jun-2013 02:59 378K
KI.zip 20-Jun-2013 02:59 35K
KM.zip 20-Jun-2013 02:59 32K
KN.zip 20-Jun-2013 02:59 17K
KP.zip 20-Jun-2013 02:59 1.2M
KR.zip 20-Jun-2013 02:59 2.6M
KW.zip 20-Jun-2013 02:59 44K
KY.zip 20-Jun-2013 02:59 10K
KZ.zip 20-Jun-2013 02:59 661K
LA.zip 20-Jun-2013 02:59 508K
LB.zip 20-Jun-2013 02:59 820K
LC.zip 20-Jun-2013 02:59 18K
LI.zip 20-Jun-2013 02:59 8.0K
LK.zip 20-Jun-2013 02:59 1.0M
LR.zip 20-Jun-2013 02:59 176K
LS.zip 20-Jun-2013 02:59 34K
LT.zip 20-Jun-2013 02:59 267K
LU.zip 20-Jun-2013 02:59 35K
LV.zip 20-Jun-2013 02:59 253K
LY.zip 20-Jun-2013 03:00 808K
MA.zip 20-Jun-2013 03:00 1.2M
MC.zip 20-Jun-2013 03:00 5.4K
MD.zip 20-Jun-2013 03:00 97K
ME.zip 20-Jun-2013 03:00 335K
MF.zip 20-Jun-2013 03:00 9.4K
MG.zip 20-Jun-2013 03:00 587K
MH.zip 20-Jun-2013 03:00 55K
MK.zip 20-Jun-2013 03:00 261K
ML.zip 20-Jun-2013 03:00 595K
MM.zip 20-Jun-2013 03:00 1.1M
MN.zip 20-Jun-2013 03:00 273K
MO.zip 20-Jun-2013 03:00 9.3K
MP.zip 20-Jun-2013 03:00 37K
MQ.zip 20-Jun-2013 03:00 41K
MR.zip 20-Jun-2013 03:00 294K
MS.zip 20-Jun-2013 03:00 9.3K
MT.zip 20-Jun-2013 03:00 79K
MU.zip 20-Jun-2013 03:00 43K
MV.zip 20-Jun-2013 03:00 23K
MW.zip 20-Jun-2013 03:00 201K
MX.zip 20-Jun-2013 03:00 2.5M
MY.zip 20-Jun-2013 03:00 1.5M
MZ.zip 20-Jun-2013 03:00 1.1M
NA.zip 20-Jun-2013 03:00 170K
NC.zip 20-Jun-2013 03:00 105K
NE.zip 20-Jun-2013 03:00 604K
NF.zip 20-Jun-2013 03:00 5.4K
NG.zip 20-Jun-2013 03:00 1.0M
NI.zip 20-Jun-2013 03:00 167K
NL.zip 20-Jun-2013 03:00 583K
NO.zip 20-Jun-2013 03:00 1.4M
NP.zip 20-Jun-2013 03:00 2.4M
NR.zip 20-Jun-2013 03:00 7.5K
NU.zip 20-Jun-2013 03:00 4.9K
NZ.zip 20-Jun-2013 03:00 1.3M
OM.zip 20-Jun-2013 03:00 220K
PA.zip 20-Jun-2013 03:00 336K
PE.zip 20-Jun-2013 03:00 2.3M
PF.zip 20-Jun-2013 03:00 63K
PG.zip 20-Jun-2013 03:00 537K
PH.zip 20-Jun-2013 03:00 1.7M
PK.zip 20-Jun-2013 03:01 3.8M
PL.zip 20-Jun-2013 03:01 1.5M
PM.zip 20-Jun-2013 03:01 17K
PN.zip 20-Jun-2013 03:01 5.1K
PR.zip 20-Jun-2013 03:01 224K
PS.zip 20-Jun-2013 03:01 277K
PT.zip 20-Jun-2013 03:01 763K
PW.zip 20-Jun-2013 03:01 36K
PY.zip 20-Jun-2013 03:01 91K
QA.zip 20-Jun-2013 03:01 41K
RE.zip 20-Jun-2013 03:01 35K
RO.zip 20-Jun-2013 03:01 812K
RS.zip 20-Jun-2013 03:01 623K
RU.zip 20-Jun-2013 03:02 12M
RW.zip 20-Jun-2013 03:02 358K
SA.zip 20-Jun-2013 03:02 779K
SB.zip 20-Jun-2013 03:02 219K
SC.zip 20-Jun-2013 03:02 14K
SD.zip 20-Jun-2013 03:02 714K
SE.zip 20-Jun-2013 03:02 2.2M
SG.zip 20-Jun-2013 03:02 42K
SH.zip 20-Jun-2013 03:02 17K
SI.zip 20-Jun-2013 03:02 146K
SJ.zip 20-Jun-2013 03:02 186K
SK.zip 20-Jun-2013 03:02 231K
SL.zip 20-Jun-2013 03:02 155K
SM.zip 20-Jun-2013 03:02 5.0K
SN.zip 20-Jun-2013 03:02 291K
SO.zip 20-Jun-2013 03:02 458K
SR.zip 20-Jun-2013 03:02 59K
SS.zip 20-Jun-2013 03:02 284K
ST.zip 20-Jun-2013 03:02 18K
SV.zip 20-Jun-2013 03:02 161K
SX.zip 20-Jun-2013 03:02 7.7K
SY.zip 20-Jun-2013 03:02 1.2M
SZ.zip 20-Jun-2013 03:02 12K
TC.zip 20-Jun-2013 03:02 8.9K
TD.zip 20-Jun-2013 03:02 526K
TF.zip 20-Jun-2013 03:02 53K
TG.zip 20-Jun-2013 03:02 121K
TH.zip 20-Jun-2013 03:02 5.9M
TJ.zip 20-Jun-2013 03:02 148K
TK.zip 20-Jun-2013 03:02 6.9K
TL.zip 20-Jun-2013 03:02 154K
TM.zip 20-Jun-2013 03:02 126K
TN.zip 20-Jun-2013 03:03 604K
TO.zip 20-Jun-2013 03:03 20K
TR.zip 20-Jun-2013 03:03 1.9M
TT.zip 20-Jun-2013 03:03 46K
TV.zip 20-Jun-2013 03:03 14K
TW.zip 20-Jun-2013 03:03 1.7M
TZ.zip 20-Jun-2013 03:03 325K
UA.zip 20-Jun-2013 03:03 1.1M
UG.zip 20-Jun-2013 03:03 270K
UM.zip 20-Jun-2013 03:03 15K
US.zip 20-Jun-2013 03:05 57M
UY.zip 20-Jun-2013 03:05 143K
UZ.zip 20-Jun-2013 03:05 232K
VA.zip 20-Jun-2013 03:05 5.4K
VC.zip 20-Jun-2013 03:05 13K
VE.zip 20-Jun-2013 03:05 1.6M
VG.zip 20-Jun-2013 03:05 16K
VI.zip 20-Jun-2013 03:05 50K
VN.zip 20-Jun-2013 03:06 1.1M
VU.zip 20-Jun-2013 03:06 92K
WF.zip 20-Jun-2013 03:06 8.3K
WS.zip 20-Jun-2013 03:06 27K
XK.zip 20-Jun-2013 03:06 188K
YE.zip 20-Jun-2013 03:06 1.6M
YT.zip 20-Jun-2013 03:06 17K
ZA.zip 20-Jun-2013 03:06 2.4M
ZM.zip 20-Jun-2013 03:06 618K
ZW.zip 20-Jun-2013 03:06 601K
![[TXT]](/icons/text.gif)
admin1CodesASCII.txt 20-Jun-2013 03:06 140K
admin2Codes.txt 20-Jun-2013 03:06 1.6M
allCountries.zip 20-Jun-2013 03:06 230M
alternateNames.zip 20-Jun-2013 03:08 76M
alternateNamesDeletes-2013-06-19.txt 20-Jun-2013 03:08 188
alternateNamesModifications-2013-06-19.txt 20-Jun-2013 03:08 2.9K
cities1000.zip 20-Jun-2013 03:06 5.8M
cities15000.zip 20-Jun-2013 03:06 1.6M
cities5000.zip 20-Jun-2013 03:06 2.6M
countryInfo.txt 20-Jun-2013 02:50 31K
deletes-2013-06-19.txt 20-Jun-2013 03:08 605
featureCodes_bg.txt 20-Jun-2013 02:50 64K
featureCodes_en.txt 20-Jun-2013 02:50 56K
featureCodes_nb.txt 20-Jun-2013 02:50 56K
featureCodes_nn.txt 20-Jun-2013 02:50 56K
featureCodes_no.txt 20-Jun-2013 02:50 56K
featureCodes_ru.txt 20-Jun-2013 02:50 112K
featureCodes_sv.txt 20-Jun-2013 02:50 56K
hierarchy.zip 20-Jun-2013 03:09 1.1M
iso-languagecodes.txt 20-Jun-2013 02:50 124K
modifications-2013-06-19.txt 20-Jun-2013 03:06 21K
no-country.zip 20-Jun-2013 03:06 164K
readme.txt 20-Jun-2013 02:50 6.8K
timeZones.txt 20-Jun-2013 03:08 14K
userTags.zip 20-Jun-2013 03:08 163K
Readme for Geonames.org :
=========================
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 varchar(5000)
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 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