Name Last modified Size Description
![[DIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
.zip 20-Nov-2009 01:12 4.1K
AD.zip 20-Nov-2009 01:13 60K
AE.zip 20-Nov-2009 01:13 101K
AF.zip 20-Nov-2009 01:13 2.8M
AG.zip 20-Nov-2009 01:13 15K
AI.zip 20-Nov-2009 01:13 6.1K
AL.zip 20-Nov-2009 01:13 248K
AM.zip 20-Nov-2009 01:13 66K
AN.zip 20-Nov-2009 01:13 23K
AO.zip 20-Nov-2009 01:13 361K
AQ.zip 20-Nov-2009 01:13 416K
AR.zip 20-Nov-2009 01:13 1.0M
AS.zip 20-Nov-2009 01:13 23K
AT.zip 20-Nov-2009 01:13 877K
AU.zip 20-Nov-2009 01:13 1.3M
AW.zip 20-Nov-2009 01:13 8.4K
AZ.zip 20-Nov-2009 01:13 211K
BA.zip 20-Nov-2009 01:13 1.1M
BB.zip 20-Nov-2009 01:13 17K
BD.zip 20-Nov-2009 01:13 537K
BE.zip 20-Nov-2009 01:13 473K
BF.zip 20-Nov-2009 01:13 226K
BG.zip 20-Nov-2009 01:13 449K
BH.zip 20-Nov-2009 01:13 20K
BI.zip 20-Nov-2009 01:13 217K
BJ.zip 20-Nov-2009 01:13 100K
BL.zip 20-Nov-2009 01:13 5.0K
BM.zip 20-Nov-2009 01:13 16K
BN.zip 20-Nov-2009 01:13 19K
BO.zip 20-Nov-2009 01:13 570K
BR.zip 20-Nov-2009 01:13 1.8M
BS.zip 20-Nov-2009 01:13 44K
BT.zip 20-Nov-2009 01:13 11K
BV.zip 20-Nov-2009 01:13 4.8K
BW.zip 20-Nov-2009 01:13 28K
BY.zip 20-Nov-2009 01:13 296K
BZ.zip 20-Nov-2009 01:13 46K
CA.zip 20-Nov-2009 01:14 8.2M
CC.zip 20-Nov-2009 01:14 4.7K
CD.zip 20-Nov-2009 01:14 481K
CF.zip 20-Nov-2009 01:14 254K
CG.zip 20-Nov-2009 01:14 230K
CH.zip 20-Nov-2009 01:14 570K
CI.zip 20-Nov-2009 01:14 333K
CK.zip 20-Nov-2009 01:14 15K
CL.zip 20-Nov-2009 01:14 768K
CM.zip 20-Nov-2009 01:14 389K
CN.zip 20-Nov-2009 01:14 3.5M
CO.zip 20-Nov-2009 01:14 1.3M
CR.zip 20-Nov-2009 01:14 92K
CU.zip 20-Nov-2009 01:14 764K
CV.zip 20-Nov-2009 01:14 20K
CX.zip 20-Nov-2009 01:14 5.1K
CY.zip 20-Nov-2009 01:14 137K
CZ.zip 20-Nov-2009 01:14 596K
DE.zip 20-Nov-2009 01:15 3.8M
DJ.zip 20-Nov-2009 01:15 137K
DK.zip 20-Nov-2009 01:15 304K
DM.zip 20-Nov-2009 01:15 11K
DO.zip 20-Nov-2009 01:15 441K
DZ.zip 20-Nov-2009 01:15 1.1M
EC.zip 20-Nov-2009 01:15 269K
EE.zip 20-Nov-2009 01:15 200K
EG.zip 20-Nov-2009 01:15 772K
EH.zip 20-Nov-2009 01:15 55K
ER.zip 20-Nov-2009 01:15 110K
ES.zip 20-Nov-2009 01:15 1.8M
ET.zip 20-Nov-2009 01:15 461K
FI.zip 20-Nov-2009 01:15 886K
FJ.zip 20-Nov-2009 01:15 204K
FK.zip 20-Nov-2009 01:15 28K
FM.zip 20-Nov-2009 01:15 127K
FO.zip 20-Nov-2009 01:15 43K
FR.zip 20-Nov-2009 01:15 3.2M
GA.zip 20-Nov-2009 01:15 131K
GB.zip 20-Nov-2009 01:15 1.0M
GD.zip 20-Nov-2009 01:15 16K
GE.zip 20-Nov-2009 01:15 232K
GF.zip 20-Nov-2009 01:15 62K
GG.zip 20-Nov-2009 01:15 20K
GH.zip 20-Nov-2009 01:15 242K
GI.zip 20-Nov-2009 01:15 8.0K
GL.zip 20-Nov-2009 01:15 182K
GM.zip 20-Nov-2009 01:15 50K
GN.zip 20-Nov-2009 01:15 220K
GP.zip 20-Nov-2009 01:15 33K
GQ.zip 20-Nov-2009 01:15 81K
GR.zip 20-Nov-2009 01:16 710K
GS.zip 20-Nov-2009 01:16 16K
GT.zip 20-Nov-2009 01:16 290K
GU.zip 20-Nov-2009 01:16 30K
GW.zip 20-Nov-2009 01:16 133K
GY.zip 20-Nov-2009 01:16 116K
HK.zip 20-Nov-2009 01:16 44K
HM.zip 20-Nov-2009 01:16 5.7K
HN.zip 20-Nov-2009 01:16 377K
HR.zip 20-Nov-2009 01:16 534K
HT.zip 20-Nov-2009 01:16 305K
HU.zip 20-Nov-2009 01:16 534K
ID.zip 20-Nov-2009 01:16 4.4M
IE.zip 20-Nov-2009 01:16 520K
IL.zip 20-Nov-2009 01:16 118K
IM.zip 20-Nov-2009 01:16 6.2K
IN.zip 20-Nov-2009 01:16 917K
IO.zip 20-Nov-2009 01:16 7.1K
IQ.zip 20-Nov-2009 01:16 1.4M
IR.zip 20-Nov-2009 01:17 5.0M
IS.zip 20-Nov-2009 01:17 317K
IT.zip 20-Nov-2009 01:17 1.3M
JE.zip 20-Nov-2009 01:17 12K
JM.zip 20-Nov-2009 01:17 80K
JO.zip 20-Nov-2009 01:17 191K
JP.zip 20-Nov-2009 01:17 676K
KE.zip 20-Nov-2009 01:17 478K
KG.zip 20-Nov-2009 01:17 59K
KH.zip 20-Nov-2009 01:17 287K
KI.zip 20-Nov-2009 01:17 12K
KM.zip 20-Nov-2009 01:17 33K
KN.zip 20-Nov-2009 01:17 14K
KP.zip 20-Nov-2009 01:17 1.1M
KR.zip 20-Nov-2009 01:17 2.3M
KW.zip 20-Nov-2009 01:17 37K
KY.zip 20-Nov-2009 01:17 9.1K
KZ.zip 20-Nov-2009 01:17 595K
LA.zip 20-Nov-2009 01:17 434K
LB.zip 20-Nov-2009 01:17 724K
LC.zip 20-Nov-2009 01:17 15K
LI.zip 20-Nov-2009 01:17 6.5K
LK.zip 20-Nov-2009 01:17 551K
LR.zip 20-Nov-2009 01:17 170K
LS.zip 20-Nov-2009 01:17 25K
LT.zip 20-Nov-2009 01:17 244K
LU.zip 20-Nov-2009 01:17 32K
LV.zip 20-Nov-2009 01:17 222K
LY.zip 20-Nov-2009 01:17 679K
MA.zip 20-Nov-2009 01:18 1.0M
MC.zip 20-Nov-2009 01:18 4.1K
MD.zip 20-Nov-2009 01:18 84K
ME.zip 20-Nov-2009 01:18 326K
MF.zip 20-Nov-2009 01:18 5.5K
MG.zip 20-Nov-2009 01:18 565K
MH.zip 20-Nov-2009 01:18 74K
MK.zip 20-Nov-2009 01:18 144K
ML.zip 20-Nov-2009 01:18 574K
MM.zip 20-Nov-2009 01:18 918K
MN.zip 20-Nov-2009 01:18 240K
MO.zip 20-Nov-2009 01:18 8.0K
MP.zip 20-Nov-2009 01:18 18K
MQ.zip 20-Nov-2009 01:18 34K
MR.zip 20-Nov-2009 01:18 260K
MS.zip 20-Nov-2009 01:18 8.0K
MT.zip 20-Nov-2009 01:18 67K
MU.zip 20-Nov-2009 01:18 39K
MV.zip 20-Nov-2009 01:18 17K
MW.zip 20-Nov-2009 01:18 164K
MX.zip 20-Nov-2009 01:18 2.0M
MY.zip 20-Nov-2009 01:18 1.0M
MZ.zip 20-Nov-2009 01:18 1.1M
NA.zip 20-Nov-2009 01:18 164K
NC.zip 20-Nov-2009 01:18 100K
NE.zip 20-Nov-2009 01:18 581K
NF.zip 20-Nov-2009 01:18 3.4K
NG.zip 20-Nov-2009 01:18 783K
NI.zip 20-Nov-2009 01:18 128K
NL.zip 20-Nov-2009 01:18 538K
NO.zip 20-Nov-2009 01:18 1.2M
NP.zip 20-Nov-2009 01:18 37K
NR.zip 20-Nov-2009 01:18 3.9K
NU.zip 20-Nov-2009 01:18 4.2K
NZ.zip 20-Nov-2009 01:18 1.5M
OM.zip 20-Nov-2009 01:18 146K
PA.zip 20-Nov-2009 01:18 318K
PE.zip 20-Nov-2009 01:18 2.0M
PF.zip 20-Nov-2009 01:18 56K
PG.zip 20-Nov-2009 01:18 436K
PH.zip 20-Nov-2009 01:19 1.3M
PK.zip 20-Nov-2009 01:19 2.6M
PL.zip 20-Nov-2009 01:19 1.0M
PM.zip 20-Nov-2009 01:19 15K
PN.zip 20-Nov-2009 01:19 4.1K
PR.zip 20-Nov-2009 01:19 194K
PS.zip 20-Nov-2009 01:19 130K
PT.zip 20-Nov-2009 01:19 478K
PW.zip 20-Nov-2009 01:19 41K
PY.zip 20-Nov-2009 01:19 86K
QA.zip 20-Nov-2009 01:19 36K
RE.zip 20-Nov-2009 01:19 26K
RO.zip 20-Nov-2009 01:19 574K
RS.zip 20-Nov-2009 01:19 688K
RU.zip 20-Nov-2009 01:19 7.1M
RW.zip 20-Nov-2009 01:19 63K
SA.zip 20-Nov-2009 01:19 649K
SB.zip 20-Nov-2009 01:19 172K
SC.zip 20-Nov-2009 01:19 12K
SD.zip 20-Nov-2009 01:19 483K
SE.zip 20-Nov-2009 01:20 1.8M
SG.zip 20-Nov-2009 01:20 36K
SH.zip 20-Nov-2009 01:20 16K
SI.zip 20-Nov-2009 01:20 138K
SJ.zip 20-Nov-2009 01:20 149K
SK.zip 20-Nov-2009 01:20 192K
SL.zip 20-Nov-2009 01:20 150K
SM.zip 20-Nov-2009 01:20 4.0K
SN.zip 20-Nov-2009 01:20 280K
SO.zip 20-Nov-2009 01:20 410K
SR.zip 20-Nov-2009 01:20 54K
ST.zip 20-Nov-2009 01:20 16K
SV.zip 20-Nov-2009 01:20 153K
SY.zip 20-Nov-2009 01:20 499K
SZ.zip 20-Nov-2009 01:20 11K
TC.zip 20-Nov-2009 01:20 7.3K
TD.zip 20-Nov-2009 01:20 497K
TF.zip 20-Nov-2009 01:20 45K
TG.zip 20-Nov-2009 01:20 115K
TH.zip 20-Nov-2009 01:20 1.1M
TJ.zip 20-Nov-2009 01:20 103K
TK.zip 20-Nov-2009 01:20 3.8K
TL.zip 20-Nov-2009 01:20 144K
TM.zip 20-Nov-2009 01:20 98K
TN.zip 20-Nov-2009 01:20 545K
TO.zip 20-Nov-2009 01:20 15K
TR.zip 20-Nov-2009 01:20 1.4M
TT.zip 20-Nov-2009 01:20 36K
TV.zip 20-Nov-2009 01:20 5.5K
TW.zip 20-Nov-2009 01:20 1.5M
TZ.zip 20-Nov-2009 01:20 279K
UA.zip 20-Nov-2009 01:20 785K
UG.zip 20-Nov-2009 01:20 192K
UM.zip 20-Nov-2009 01:20 8.1K
US.zip 20-Nov-2009 01:23 52M
UY.zip 20-Nov-2009 01:23 126K
UZ.zip 20-Nov-2009 01:23 151K
VA.zip 20-Nov-2009 01:23 4.3K
VC.zip 20-Nov-2009 01:23 10K
VE.zip 20-Nov-2009 01:23 1.4M
VG.zip 20-Nov-2009 01:23 14K
VI.zip 20-Nov-2009 01:23 50K
VN.zip 20-Nov-2009 01:23 778K
VU.zip 20-Nov-2009 01:23 86K
WF.zip 20-Nov-2009 01:23 6.9K
WS.zip 20-Nov-2009 01:23 13K
YE.zip 20-Nov-2009 01:23 446K
YT.zip 20-Nov-2009 01:23 12K
ZA.zip 20-Nov-2009 01:23 1.9M
ZM.zip 20-Nov-2009 01:23 544K
ZW.zip 20-Nov-2009 01:23 368K
![[TXT]](/icons/text.gif)
admin1Codes.txt 20-Nov-2009 01:26 77K
admin1CodesASCII.txt 20-Nov-2009 01:23 149K
admin2Codes.txt 20-Nov-2009 01:23 1.1M
allCountries.zip 20-Nov-2009 01:23 173M
alternateNames.zip 20-Nov-2009 01:26 35M
alternateNamesDeletes-2009-11-19.txt 20-Nov-2009 01:26 23
alternateNamesModifications-2009-11-19.txt 20-Nov-2009 01:26 2.8K
cities1000.zip 20-Nov-2009 01:23 3.2M
cities15000.zip 20-Nov-2009 01:23 1.0M
cities5000.zip 20-Nov-2009 01:23 1.8M
countryInfo.txt 20-Nov-2009 01:07 29K
deletes-2009-11-19.txt 20-Nov-2009 01:26 35
featureCodes.txt 20-Nov-2009 01:07 54K
iso-languagecodes.txt 20-Nov-2009 01:07 121K
modifications-2009-11-19.txt 20-Nov-2009 01:23 23K
no-country.zip 20-Nov-2009 01:23 162K
readme.txt 20-Nov-2009 01:07 6.1K
timeZones.txt 20-Nov-2009 01:26 10K
userTags.zip 20-Nov-2009 01:26 152K
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), isocode for the us and ch, 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
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' or 'icao' for airport codes, fr-1793 for French Revolution names, 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