Name Last modified Size Description
![[DIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
.zip 09-Feb-2010 01:16 4.7K
AD.zip 09-Feb-2010 01:16 60K
AE.zip 09-Feb-2010 01:16 101K
AF.zip 09-Feb-2010 01:16 3.0M
AG.zip 09-Feb-2010 01:16 15K
AI.zip 09-Feb-2010 01:16 6.2K
AL.zip 09-Feb-2010 01:16 249K
AM.zip 09-Feb-2010 01:16 67K
AN.zip 09-Feb-2010 01:16 26K
AO.zip 09-Feb-2010 01:16 364K
AQ.zip 09-Feb-2010 01:16 418K
AR.zip 09-Feb-2010 01:16 1.0M
AS.zip 09-Feb-2010 01:16 25K
AT.zip 09-Feb-2010 01:16 888K
AU.zip 09-Feb-2010 01:17 1.3M
AW.zip 09-Feb-2010 01:17 8.5K
AZ.zip 09-Feb-2010 01:17 212K
BA.zip 09-Feb-2010 01:17 1.1M
BB.zip 09-Feb-2010 01:17 18K
BD.zip 09-Feb-2010 01:17 572K
BE.zip 09-Feb-2010 01:17 471K
BF.zip 09-Feb-2010 01:17 238K
BG.zip 09-Feb-2010 01:17 449K
BH.zip 09-Feb-2010 01:17 20K
BI.zip 09-Feb-2010 01:17 218K
BJ.zip 09-Feb-2010 01:17 107K
BL.zip 09-Feb-2010 01:17 5.1K
BM.zip 09-Feb-2010 01:17 17K
BN.zip 09-Feb-2010 01:17 19K
BO.zip 09-Feb-2010 01:17 572K
BR.zip 09-Feb-2010 01:17 1.9M
BS.zip 09-Feb-2010 01:17 45K
BT.zip 09-Feb-2010 01:17 11K
BV.zip 09-Feb-2010 01:17 4.9K
BW.zip 09-Feb-2010 01:17 28K
BY.zip 09-Feb-2010 01:17 318K
BZ.zip 09-Feb-2010 01:17 47K
CA.zip 09-Feb-2010 01:17 8.2M
CC.zip 09-Feb-2010 01:17 4.8K
CD.zip 09-Feb-2010 01:17 486K
CF.zip 09-Feb-2010 01:17 255K
CG.zip 09-Feb-2010 01:17 231K
CH.zip 09-Feb-2010 01:17 573K
CI.zip 09-Feb-2010 01:17 328K
CK.zip 09-Feb-2010 01:17 15K
CL.zip 09-Feb-2010 01:17 770K
CM.zip 09-Feb-2010 01:17 405K
CN.zip 09-Feb-2010 01:18 4.4M
CO.zip 09-Feb-2010 01:18 1.4M
CR.zip 09-Feb-2010 01:18 93K
CU.zip 09-Feb-2010 01:18 765K
CV.zip 09-Feb-2010 01:18 20K
CX.zip 09-Feb-2010 01:18 5.2K
CY.zip 09-Feb-2010 01:18 137K
CZ.zip 09-Feb-2010 01:18 598K
DE.zip 09-Feb-2010 01:18 3.8M
DJ.zip 09-Feb-2010 01:18 137K
DK.zip 09-Feb-2010 01:18 307K
DM.zip 09-Feb-2010 01:18 11K
DO.zip 09-Feb-2010 01:18 442K
DZ.zip 09-Feb-2010 01:18 1.1M
EC.zip 09-Feb-2010 01:18 270K
EE.zip 09-Feb-2010 01:18 200K
EG.zip 09-Feb-2010 01:18 773K
EH.zip 09-Feb-2010 01:18 55K
ER.zip 09-Feb-2010 01:18 110K
ES.zip 09-Feb-2010 01:18 1.8M
ET.zip 09-Feb-2010 01:18 461K
FI.zip 09-Feb-2010 01:18 888K
FJ.zip 09-Feb-2010 01:18 204K
FK.zip 09-Feb-2010 01:18 28K
FM.zip 09-Feb-2010 01:18 127K
FO.zip 09-Feb-2010 01:18 43K
FR.zip 09-Feb-2010 01:19 3.2M
GA.zip 09-Feb-2010 01:19 131K
GB.zip 09-Feb-2010 01:19 1.0M
GD.zip 09-Feb-2010 01:19 16K
GE.zip 09-Feb-2010 01:19 239K
GF.zip 09-Feb-2010 01:19 62K
GG.zip 09-Feb-2010 01:19 20K
GH.zip 09-Feb-2010 01:19 243K
GI.zip 09-Feb-2010 01:19 8.1K
GL.zip 09-Feb-2010 01:19 182K
GM.zip 09-Feb-2010 01:19 50K
GN.zip 09-Feb-2010 01:19 224K
GP.zip 09-Feb-2010 01:19 33K
GQ.zip 09-Feb-2010 01:19 81K
GR.zip 09-Feb-2010 01:19 712K
GS.zip 09-Feb-2010 01:19 16K
GT.zip 09-Feb-2010 01:19 291K
GU.zip 09-Feb-2010 01:19 31K
GW.zip 09-Feb-2010 01:19 133K
GY.zip 09-Feb-2010 01:19 116K
HK.zip 09-Feb-2010 01:19 47K
HM.zip 09-Feb-2010 01:19 5.8K
HN.zip 09-Feb-2010 01:19 377K
HR.zip 09-Feb-2010 01:19 537K
HT.zip 09-Feb-2010 01:19 305K
HU.zip 09-Feb-2010 01:19 535K
ID.zip 09-Feb-2010 01:19 4.9M
IE.zip 09-Feb-2010 01:19 520K
IL.zip 09-Feb-2010 01:19 118K
IM.zip 09-Feb-2010 01:19 6.5K
IN.zip 09-Feb-2010 01:19 1.1M
IO.zip 09-Feb-2010 01:19 7.2K
IQ.zip 09-Feb-2010 01:19 1.6M
IR.zip 09-Feb-2010 01:20 5.6M
IS.zip 09-Feb-2010 01:20 321K
IT.zip 09-Feb-2010 01:20 1.3M
JE.zip 09-Feb-2010 01:20 12K
JM.zip 09-Feb-2010 01:20 80K
JO.zip 09-Feb-2010 01:20 202K
JP.zip 09-Feb-2010 01:20 682K
KE.zip 09-Feb-2010 01:20 478K
KG.zip 09-Feb-2010 01:20 60K
KH.zip 09-Feb-2010 01:20 292K
KI.zip 09-Feb-2010 01:20 12K
KM.zip 09-Feb-2010 01:20 33K
KN.zip 09-Feb-2010 01:20 14K
KP.zip 09-Feb-2010 01:20 1.1M
KR.zip 09-Feb-2010 01:20 2.3M
KW.zip 09-Feb-2010 01:20 37K
KY.zip 09-Feb-2010 01:20 9.2K
KZ.zip 09-Feb-2010 01:20 595K
LA.zip 09-Feb-2010 01:20 434K
LB.zip 09-Feb-2010 01:20 724K
LC.zip 09-Feb-2010 01:20 16K
LI.zip 09-Feb-2010 01:20 6.7K
LK.zip 09-Feb-2010 01:20 552K
LR.zip 09-Feb-2010 01:20 171K
LS.zip 09-Feb-2010 01:20 25K
LT.zip 09-Feb-2010 01:20 244K
LU.zip 09-Feb-2010 01:20 32K
LV.zip 09-Feb-2010 01:20 222K
LY.zip 09-Feb-2010 01:20 679K
MA.zip 09-Feb-2010 01:20 1.0M
MC.zip 09-Feb-2010 01:20 4.1K
MD.zip 09-Feb-2010 01:20 84K
ME.zip 09-Feb-2010 01:20 326K
MF.zip 09-Feb-2010 01:20 5.6K
MG.zip 09-Feb-2010 01:20 566K
MH.zip 09-Feb-2010 01:20 74K
MK.zip 09-Feb-2010 01:20 145K
ML.zip 09-Feb-2010 01:21 585K
MM.zip 09-Feb-2010 01:21 927K
MN.zip 09-Feb-2010 01:21 252K
MO.zip 09-Feb-2010 01:21 8.1K
MP.zip 09-Feb-2010 01:21 18K
MQ.zip 09-Feb-2010 01:21 34K
MR.zip 09-Feb-2010 01:21 262K
MS.zip 09-Feb-2010 01:21 8.7K
MT.zip 09-Feb-2010 01:21 67K
MU.zip 09-Feb-2010 01:21 39K
MV.zip 09-Feb-2010 01:21 17K
MW.zip 09-Feb-2010 01:21 165K
MX.zip 09-Feb-2010 01:21 2.0M
MY.zip 09-Feb-2010 01:21 1.0M
MZ.zip 09-Feb-2010 01:21 1.1M
NA.zip 09-Feb-2010 01:21 165K
NC.zip 09-Feb-2010 01:21 100K
NE.zip 09-Feb-2010 01:21 602K
NF.zip 09-Feb-2010 01:21 3.5K
NG.zip 09-Feb-2010 01:21 1.1M
NI.zip 09-Feb-2010 01:21 131K
NL.zip 09-Feb-2010 01:21 564K
NO.zip 09-Feb-2010 01:21 1.2M
NP.zip 09-Feb-2010 01:21 37K
NR.zip 09-Feb-2010 01:21 4.0K
NU.zip 09-Feb-2010 01:21 4.3K
NZ.zip 09-Feb-2010 01:21 1.5M
OM.zip 09-Feb-2010 01:21 146K
PA.zip 09-Feb-2010 01:21 319K
PE.zip 09-Feb-2010 01:21 2.0M
PF.zip 09-Feb-2010 01:21 57K
PG.zip 09-Feb-2010 01:21 436K
PH.zip 09-Feb-2010 01:21 1.3M
PK.zip 09-Feb-2010 01:22 3.0M
PL.zip 09-Feb-2010 01:22 1.1M
PM.zip 09-Feb-2010 01:22 15K
PN.zip 09-Feb-2010 01:22 4.4K
PR.zip 09-Feb-2010 01:22 229K
PS.zip 09-Feb-2010 01:22 132K
PT.zip 09-Feb-2010 01:22 485K
PW.zip 09-Feb-2010 01:22 41K
PY.zip 09-Feb-2010 01:22 86K
QA.zip 09-Feb-2010 01:22 36K
RE.zip 09-Feb-2010 01:22 26K
RO.zip 09-Feb-2010 01:22 576K
RS.zip 09-Feb-2010 01:22 549K
RU.zip 09-Feb-2010 01:22 7.4M
RW.zip 09-Feb-2010 01:22 165K
SA.zip 09-Feb-2010 01:22 672K
SB.zip 09-Feb-2010 01:22 172K
SC.zip 09-Feb-2010 01:22 12K
SD.zip 09-Feb-2010 01:22 743K
SE.zip 09-Feb-2010 01:22 1.8M
SG.zip 09-Feb-2010 01:22 36K
SH.zip 09-Feb-2010 01:22 16K
SI.zip 09-Feb-2010 01:22 139K
SJ.zip 09-Feb-2010 01:22 149K
SK.zip 09-Feb-2010 01:22 193K
SL.zip 09-Feb-2010 01:22 151K
SM.zip 09-Feb-2010 01:22 4.1K
SN.zip 09-Feb-2010 01:22 281K
SO.zip 09-Feb-2010 01:22 412K
SR.zip 09-Feb-2010 01:22 54K
ST.zip 09-Feb-2010 01:22 16K
SV.zip 09-Feb-2010 01:22 153K
SY.zip 09-Feb-2010 01:23 500K
SZ.zip 09-Feb-2010 01:23 11K
TC.zip 09-Feb-2010 01:23 7.4K
TD.zip 09-Feb-2010 01:23 522K
TF.zip 09-Feb-2010 01:23 45K
TG.zip 09-Feb-2010 01:23 114K
TH.zip 09-Feb-2010 01:23 1.4M
TJ.zip 09-Feb-2010 01:23 104K
TK.zip 09-Feb-2010 01:23 3.9K
TL.zip 09-Feb-2010 01:23 144K
TM.zip 09-Feb-2010 01:23 113K
TN.zip 09-Feb-2010 01:23 547K
TO.zip 09-Feb-2010 01:23 15K
TR.zip 09-Feb-2010 01:23 1.5M
TT.zip 09-Feb-2010 01:23 37K
TV.zip 09-Feb-2010 01:23 5.6K
TW.zip 09-Feb-2010 01:23 1.5M
TZ.zip 09-Feb-2010 01:23 280K
UA.zip 09-Feb-2010 01:23 846K
UG.zip 09-Feb-2010 01:23 193K
UM.zip 09-Feb-2010 01:23 8.2K
US.zip 09-Feb-2010 01:25 56M
UY.zip 09-Feb-2010 01:25 127K
UZ.zip 09-Feb-2010 01:26 152K
VA.zip 09-Feb-2010 01:26 4.4K
VC.zip 09-Feb-2010 01:26 10K
VE.zip 09-Feb-2010 01:26 1.4M
VG.zip 09-Feb-2010 01:26 14K
VI.zip 09-Feb-2010 01:26 50K
VN.zip 09-Feb-2010 01:26 779K
VU.zip 09-Feb-2010 01:26 85K
WF.zip 09-Feb-2010 01:26 7.0K
WS.zip 09-Feb-2010 01:26 24K
XK.zip 09-Feb-2010 01:26 162K
YE.zip 09-Feb-2010 01:26 447K
YT.zip 09-Feb-2010 01:26 12K
ZA.zip 09-Feb-2010 01:26 1.9M
ZM.zip 09-Feb-2010 01:26 545K
ZW.zip 09-Feb-2010 01:26 368K
![[TXT]](/icons/text.gif)
admin1Codes.txt 09-Feb-2010 01:27 78K
admin1CodesASCII.txt 09-Feb-2010 01:26 150K
admin2Codes.txt 09-Feb-2010 01:26 1.1M
allCountries.zip 09-Feb-2010 01:26 182M
alternateNames.zip 09-Feb-2010 01:27 40M
alternateNamesDeletes-2010-02-08.txt 09-Feb-2010 01:28 0
alternateNamesModifications-2010-02-08.txt 09-Feb-2010 01:27 74
cities1000.zip 09-Feb-2010 01:26 3.4M
cities15000.zip 09-Feb-2010 01:26 1.1M
cities5000.zip 09-Feb-2010 01:26 1.9M
countryInfo.txt 09-Feb-2010 01:10 29K
deletes-2010-02-08.txt 09-Feb-2010 01:28 163
featureCodes_bg.txt 09-Feb-2010 01:10 64K
featureCodes_en.txt 09-Feb-2010 01:10 55K
featureCodes_nb.txt 09-Feb-2010 01:10 55K
featureCodes_nn.txt 09-Feb-2010 01:10 55K
featureCodes_no.txt 09-Feb-2010 01:10 55K
featureCodes_ru.txt 09-Feb-2010 01:10 101K
featureCodes_sv.txt 09-Feb-2010 01:10 56K
iso-languagecodes.txt 09-Feb-2010 01:10 121K
modifications-2010-02-08.txt 09-Feb-2010 01:26 13K
no-country.zip 09-Feb-2010 01:26 165K
readme.txt 09-Feb-2010 01:10 6.3K
timeZones.txt 09-Feb-2010 01:28 10K
userTags.zip 09-Feb-2010 01:28 153K
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
admin1Codes.txt : names for administrative subdivision 'admin1 code' (UTF8), the code '00' stands for 'unkown code', includes obsolete 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)
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.
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 (4 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 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. 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