Name Last modified Size Description
![[DIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
AD.zip 29-Jan-2012 01:41 62K
AE.zip 29-Jan-2012 01:41 152K
AF.zip 29-Jan-2012 01:42 4.2M
AG.zip 29-Jan-2012 01:42 16K
AI.zip 29-Jan-2012 01:42 6.9K
AL.zip 29-Jan-2012 01:42 268K
AM.zip 29-Jan-2012 01:42 76K
AO.zip 29-Jan-2012 01:42 1.0M
AQ.zip 29-Jan-2012 01:42 466K
AR.zip 29-Jan-2012 01:42 1.2M
AS.zip 29-Jan-2012 01:42 27K
AT.zip 29-Jan-2012 01:42 1.0M
AU.zip 29-Jan-2012 01:42 2.0M
AW.zip 29-Jan-2012 01:42 8.9K
AX.zip 29-Jan-2012 01:42 67K
AZ.zip 29-Jan-2012 01:42 248K
BA.zip 29-Jan-2012 01:42 1.1M
BB.zip 29-Jan-2012 01:42 18K
BD.zip 29-Jan-2012 01:42 1.1M
BE.zip 29-Jan-2012 01:42 511K
BF.zip 29-Jan-2012 01:42 236K
BG.zip 29-Jan-2012 01:42 444K
BH.zip 29-Jan-2012 01:42 21K
BI.zip 29-Jan-2012 01:42 222K
BJ.zip 29-Jan-2012 01:42 127K
BL.zip 29-Jan-2012 01:42 6.4K
BM.zip 29-Jan-2012 01:42 18K
BN.zip 29-Jan-2012 01:42 20K
BO.zip 29-Jan-2012 01:42 590K
BQ.zip 29-Jan-2012 01:42 12K
BR.zip 29-Jan-2012 01:42 2.5M
BS.zip 29-Jan-2012 01:42 48K
BT.zip 29-Jan-2012 01:42 13K
BV.zip 29-Jan-2012 01:42 5.5K
BW.zip 29-Jan-2012 01:42 92K
BY.zip 29-Jan-2012 01:42 635K
BZ.zip 29-Jan-2012 01:42 49K
CA.zip 29-Jan-2012 01:43 6.7M
CC.zip 29-Jan-2012 01:43 5.7K
CD.zip 29-Jan-2012 01:43 625K
CF.zip 29-Jan-2012 01:43 314K
CG.zip 29-Jan-2012 01:43 237K
CH.zip 29-Jan-2012 01:43 634K
CI.zip 29-Jan-2012 01:43 418K
CK.zip 29-Jan-2012 01:43 17K
CL.zip 29-Jan-2012 01:43 805K
CM.zip 29-Jan-2012 01:43 412K
CN.zip 29-Jan-2012 01:43 8.0M
CO.zip 29-Jan-2012 01:43 1.6M
CR.zip 29-Jan-2012 01:43 112K
CU.zip 29-Jan-2012 01:43 789K
CV.zip 29-Jan-2012 01:43 23K
CW.zip 29-Jan-2012 01:43 12K
CX.zip 29-Jan-2012 01:43 5.7K
CY.zip 29-Jan-2012 01:43 136K
CZ.zip 29-Jan-2012 01:43 573K
DE.zip 29-Jan-2012 01:43 3.8M
DJ.zip 29-Jan-2012 01:43 144K
DK.zip 29-Jan-2012 01:43 393K
DM.zip 29-Jan-2012 01:43 12K
DO.zip 29-Jan-2012 01:43 538K
DZ.zip 29-Jan-2012 01:43 1.4M
EC.zip 29-Jan-2012 01:43 284K
EE.zip 29-Jan-2012 01:43 223K
EG.zip 29-Jan-2012 01:43 1.0M
EH.zip 29-Jan-2012 01:43 64K
ER.zip 29-Jan-2012 01:43 114K
ES.zip 29-Jan-2012 01:43 1.8M
ET.zip 29-Jan-2012 01:44 483K
FI.zip 29-Jan-2012 01:44 924K
FJ.zip 29-Jan-2012 01:44 207K
FK.zip 29-Jan-2012 01:44 34K
FM.zip 29-Jan-2012 01:44 91K
FO.zip 29-Jan-2012 01:44 52K
FR.zip 29-Jan-2012 01:44 3.5M
GA.zip 29-Jan-2012 01:44 149K
GB.zip 29-Jan-2012 01:44 1.4M
GD.zip 29-Jan-2012 01:44 17K
GE.zip 29-Jan-2012 01:44 278K
GF.zip 29-Jan-2012 01:44 73K
GG.zip 29-Jan-2012 01:44 22K
GH.zip 29-Jan-2012 01:44 300K
GI.zip 29-Jan-2012 01:44 9.5K
GL.zip 29-Jan-2012 01:44 192K
GM.zip 29-Jan-2012 01:44 53K
GN.zip 29-Jan-2012 01:44 228K
GP.zip 29-Jan-2012 01:44 40K
GQ.zip 29-Jan-2012 01:44 103K
GR.zip 29-Jan-2012 01:44 833K
GS.zip 29-Jan-2012 01:44 18K
GT.zip 29-Jan-2012 01:44 303K
GU.zip 29-Jan-2012 01:44 45K
GW.zip 29-Jan-2012 01:44 138K
GY.zip 29-Jan-2012 01:44 122K
HK.zip 29-Jan-2012 01:44 51K
HM.zip 29-Jan-2012 01:44 7.1K
HN.zip 29-Jan-2012 01:44 391K
HR.zip 29-Jan-2012 01:44 549K
HT.zip 29-Jan-2012 01:44 312K
HU.zip 29-Jan-2012 01:44 593K
ID.zip 29-Jan-2012 01:44 6.6M
IE.zip 29-Jan-2012 01:44 526K
IL.zip 29-Jan-2012 01:44 186K
IM.zip 29-Jan-2012 01:44 6.9K
IN.zip 29-Jan-2012 01:44 1.1M
IO.zip 29-Jan-2012 01:44 8.6K
IQ.zip 29-Jan-2012 01:44 2.0M
IR.zip 29-Jan-2012 01:45 7.5M
IS.zip 29-Jan-2012 01:45 382K
IT.zip 29-Jan-2012 01:45 1.4M
JE.zip 29-Jan-2012 01:45 13K
JM.zip 29-Jan-2012 01:45 94K
JO.zip 29-Jan-2012 01:45 239K
JP.zip 29-Jan-2012 01:45 1.3M
KE.zip 29-Jan-2012 01:45 551K
KG.zip 29-Jan-2012 01:45 146K
KH.zip 29-Jan-2012 01:45 372K
KI.zip 29-Jan-2012 01:45 34K
KM.zip 29-Jan-2012 01:45 31K
KN.zip 29-Jan-2012 01:45 16K
KP.zip 29-Jan-2012 01:45 1.2M
KR.zip 29-Jan-2012 01:45 2.5M
KW.zip 29-Jan-2012 01:45 43K
KY.zip 29-Jan-2012 01:45 10K
KZ.zip 29-Jan-2012 01:45 618K
LA.zip 29-Jan-2012 01:45 459K
LB.zip 29-Jan-2012 01:45 793K
LC.zip 29-Jan-2012 01:45 18K
LI.zip 29-Jan-2012 01:45 7.9K
LK.zip 29-Jan-2012 01:45 932K
LR.zip 29-Jan-2012 01:45 175K
LS.zip 29-Jan-2012 01:45 34K
LT.zip 29-Jan-2012 01:45 264K
LU.zip 29-Jan-2012 01:45 34K
LV.zip 29-Jan-2012 01:45 251K
LY.zip 29-Jan-2012 01:45 806K
MA.zip 29-Jan-2012 01:45 1.2M
MC.zip 29-Jan-2012 01:45 4.7K
MD.zip 29-Jan-2012 01:45 95K
ME.zip 29-Jan-2012 01:45 330K
MF.zip 29-Jan-2012 01:45 8.9K
MG.zip 29-Jan-2012 01:45 585K
MH.zip 29-Jan-2012 01:45 53K
MK.zip 29-Jan-2012 01:45 147K
ML.zip 29-Jan-2012 01:45 584K
MM.zip 29-Jan-2012 01:45 939K
MN.zip 29-Jan-2012 01:45 271K
MO.zip 29-Jan-2012 01:45 8.7K
MP.zip 29-Jan-2012 01:45 36K
MQ.zip 29-Jan-2012 01:45 40K
MR.zip 29-Jan-2012 01:45 293K
MS.zip 29-Jan-2012 01:45 9.0K
MT.zip 29-Jan-2012 01:45 72K
MU.zip 29-Jan-2012 01:45 42K
MV.zip 29-Jan-2012 01:45 21K
MW.zip 29-Jan-2012 01:45 200K
MX.zip 29-Jan-2012 01:45 2.0M
MY.zip 29-Jan-2012 01:45 1.4M
MZ.zip 29-Jan-2012 01:45 1.1M
NA.zip 29-Jan-2012 01:45 168K
NC.zip 29-Jan-2012 01:45 104K
NE.zip 29-Jan-2012 01:45 598K
NF.zip 29-Jan-2012 01:45 5.3K
NG.zip 29-Jan-2012 01:45 1.0M
NI.zip 29-Jan-2012 01:45 165K
NL.zip 29-Jan-2012 01:45 563K
NO.zip 29-Jan-2012 01:46 1.3M
NP.zip 29-Jan-2012 01:46 2.3M
NR.zip 29-Jan-2012 01:46 7.1K
NU.zip 29-Jan-2012 01:46 4.6K
NZ.zip 29-Jan-2012 01:46 1.2M
OM.zip 29-Jan-2012 01:46 208K
PA.zip 29-Jan-2012 01:46 334K
PE.zip 29-Jan-2012 01:46 2.0M
PF.zip 29-Jan-2012 01:46 60K
PG.zip 29-Jan-2012 01:46 512K
PH.zip 29-Jan-2012 01:46 1.5M
PK.zip 29-Jan-2012 01:46 3.8M
PL.zip 29-Jan-2012 01:46 1.5M
PM.zip 29-Jan-2012 01:46 16K
PN.zip 29-Jan-2012 01:46 5.0K
PR.zip 29-Jan-2012 01:46 218K
PS.zip 29-Jan-2012 01:46 272K
PT.zip 29-Jan-2012 01:46 748K
PW.zip 29-Jan-2012 01:46 35K
PY.zip 29-Jan-2012 01:46 89K
QA.zip 29-Jan-2012 01:46 40K
RE.zip 29-Jan-2012 01:46 32K
RO.zip 29-Jan-2012 01:46 628K
RS.zip 29-Jan-2012 01:46 575K
RU.zip 29-Jan-2012 01:47 11M
RW.zip 29-Jan-2012 01:47 348K
SA.zip 29-Jan-2012 01:47 774K
SB.zip 29-Jan-2012 01:47 213K
SC.zip 29-Jan-2012 01:47 13K
SD.zip 29-Jan-2012 01:47 689K
SE.zip 29-Jan-2012 01:47 2.1M
SG.zip 29-Jan-2012 01:47 38K
SH.zip 29-Jan-2012 01:47 17K
SI.zip 29-Jan-2012 01:47 142K
SJ.zip 29-Jan-2012 01:47 184K
SK.zip 29-Jan-2012 01:47 227K
SL.zip 29-Jan-2012 01:47 153K
SM.zip 29-Jan-2012 01:47 4.6K
SN.zip 29-Jan-2012 01:47 287K
SO.zip 29-Jan-2012 01:47 453K
SR.zip 29-Jan-2012 01:47 57K
SS.zip 29-Jan-2012 01:47 272K
ST.zip 29-Jan-2012 01:47 18K
SV.zip 29-Jan-2012 01:47 160K
SX.zip 29-Jan-2012 01:47 7.3K
SY.zip 29-Jan-2012 01:47 741K
SZ.zip 29-Jan-2012 01:47 12K
TC.zip 29-Jan-2012 01:47 8.6K
TD.zip 29-Jan-2012 01:47 526K
TF.zip 29-Jan-2012 01:47 53K
TG.zip 29-Jan-2012 01:47 119K
TH.zip 29-Jan-2012 01:47 3.8M
TJ.zip 29-Jan-2012 01:47 120K
TK.zip 29-Jan-2012 01:47 6.5K
TL.zip 29-Jan-2012 01:47 145K
TM.zip 29-Jan-2012 01:47 124K
TN.zip 29-Jan-2012 01:47 599K
TO.zip 29-Jan-2012 01:47 16K
TR.zip 29-Jan-2012 01:47 1.8M
TT.zip 29-Jan-2012 01:47 40K
TV.zip 29-Jan-2012 01:47 13K
TW.zip 29-Jan-2012 01:47 1.7M
TZ.zip 29-Jan-2012 01:47 314K
UA.zip 29-Jan-2012 01:47 1.0M
UG.zip 29-Jan-2012 01:47 249K
UM.zip 29-Jan-2012 01:47 15K
US.zip 29-Jan-2012 01:49 55M
UY.zip 29-Jan-2012 01:49 139K
UZ.zip 29-Jan-2012 01:49 229K
VA.zip 29-Jan-2012 01:49 5.3K
VC.zip 29-Jan-2012 01:49 12K
VE.zip 29-Jan-2012 01:49 1.5M
VG.zip 29-Jan-2012 01:49 15K
VI.zip 29-Jan-2012 01:49 48K
VN.zip 29-Jan-2012 01:49 815K
VU.zip 29-Jan-2012 01:49 88K
WF.zip 29-Jan-2012 01:49 7.8K
WS.zip 29-Jan-2012 01:49 26K
XK.zip 29-Jan-2012 01:49 170K
YE.zip 29-Jan-2012 01:49 1.6M
YT.zip 29-Jan-2012 01:49 17K
ZA.zip 29-Jan-2012 01:49 2.3M
ZM.zip 29-Jan-2012 01:49 617K
ZW.zip 29-Jan-2012 01:49 595K
![[TXT]](/icons/text.gif)
admin1CodesASCII.txt 29-Jan-2012 01:49 161K
admin2Codes.txt 29-Jan-2012 01:49 1.3M
allCountries.zip 29-Jan-2012 01:49 212M
alternateNames.zip 29-Jan-2012 01:51 109M
alternateNamesDeletes-2012-01-28.txt 29-Jan-2012 01:51 87
alternateNamesModifications-2012-01-28.txt 29-Jan-2012 01:51 2.5K
cities1000.zip 29-Jan-2012 01:49 4.4M
cities15000.zip 29-Jan-2012 01:49 1.2M
cities5000.zip 29-Jan-2012 01:49 2.0M
countryInfo.txt 29-Jan-2012 01:38 31K
deletes-2012-01-28.txt 29-Jan-2012 01:51 200
featureCodes_bg.txt 29-Jan-2012 01:38 63K
featureCodes_en.txt 29-Jan-2012 01:38 55K
featureCodes_nb.txt 29-Jan-2012 01:38 55K
featureCodes_nn.txt 29-Jan-2012 01:38 55K
featureCodes_no.txt 29-Jan-2012 01:38 55K
featureCodes_ru.txt 29-Jan-2012 01:38 111K
featureCodes_sv.txt 29-Jan-2012 01:38 55K
hierarchy.zip 29-Jan-2012 01:51 1.0M
iso-languagecodes.txt 29-Jan-2012 01:38 124K
modifications-2012-01-28.txt 29-Jan-2012 01:49 8.7K
no-country.zip 29-Jan-2012 01:49 161K
readme.txt 29-Jan-2012 01:38 6.5K
timeZones.txt 29-Jan-2012 01:51 12K
userTags.zip 29-Jan-2012 01:51 158K
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 (ca 80.000), see 'geoname' table for columns
cities5000.zip : all cities with a population > 5000 (ca 40.000), see 'geoname' table for columns
cities15000.zip : all cities with a population > 15000 (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 : 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
gtopo30 : average elevation of 30''x30'' (ca 900mx900m) area in meters, integer
timezone : the timezone id (see file timeZone.txt)
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'
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 inaccuacies 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