Name Last modified Size Description
![[DIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
.zip 24-Jul-2008 03:59 2.5K
AD.zip 24-Jul-2008 03:59 58K
AE.zip 24-Jul-2008 03:59 96K
AF.zip 24-Jul-2008 03:59 2.7M
AG.zip 24-Jul-2008 03:59 14K
AI.zip 24-Jul-2008 03:59 6.0K
AL.zip 24-Jul-2008 03:59 246K
AM.zip 24-Jul-2008 03:59 66K
AN.zip 24-Jul-2008 03:59 23K
AO.zip 24-Jul-2008 03:59 360K
AQ.zip 24-Jul-2008 04:00 416K
AR.zip 24-Jul-2008 04:00 1.0M
AS.zip 24-Jul-2008 04:00 23K
AT.zip 24-Jul-2008 04:00 817K
AU.zip 24-Jul-2008 04:00 1.3M
AW.zip 24-Jul-2008 04:00 7.8K
AZ.zip 24-Jul-2008 04:00 211K
BA.zip 24-Jul-2008 04:00 1.1M
BB.zip 24-Jul-2008 04:00 17K
BD.zip 24-Jul-2008 04:00 536K
BE.zip 24-Jul-2008 04:00 414K
BF.zip 24-Jul-2008 04:00 197K
BG.zip 24-Jul-2008 04:00 445K
BH.zip 24-Jul-2008 04:00 18K
BI.zip 24-Jul-2008 04:00 217K
BJ.zip 24-Jul-2008 04:00 101K
BL.zip 24-Jul-2008 04:00 5.0K
BM.zip 24-Jul-2008 04:00 16K
BN.zip 24-Jul-2008 04:00 20K
BO.zip 24-Jul-2008 04:00 570K
BR.zip 24-Jul-2008 04:00 1.8M
BS.zip 24-Jul-2008 04:00 44K
BT.zip 24-Jul-2008 04:00 11K
BV.zip 24-Jul-2008 04:00 4.8K
BW.zip 24-Jul-2008 04:00 27K
BY.zip 24-Jul-2008 04:00 295K
BZ.zip 24-Jul-2008 04:00 46K
CA.zip 24-Jul-2008 04:00 8.2M
CC.zip 24-Jul-2008 04:00 4.6K
CD.zip 24-Jul-2008 04:01 480K
CF.zip 24-Jul-2008 04:01 239K
CG.zip 24-Jul-2008 04:01 230K
CH.zip 24-Jul-2008 04:01 383K
CI.zip 24-Jul-2008 04:01 332K
CK.zip 24-Jul-2008 04:01 15K
CL.zip 24-Jul-2008 04:01 766K
CM.zip 24-Jul-2008 04:01 311K
CN.zip 24-Jul-2008 04:01 2.8M
CO.zip 24-Jul-2008 04:01 1.3M
CR.zip 24-Jul-2008 04:01 90K
CU.zip 24-Jul-2008 04:01 763K
CV.zip 24-Jul-2008 04:01 20K
CX.zip 24-Jul-2008 04:01 5.0K
CY.zip 24-Jul-2008 04:01 136K
CZ.zip 24-Jul-2008 04:01 589K
DE.zip 24-Jul-2008 04:01 3.6M
DJ.zip 24-Jul-2008 04:01 137K
DK.zip 24-Jul-2008 04:01 296K
DM.zip 24-Jul-2008 04:01 11K
DO.zip 24-Jul-2008 04:01 440K
DZ.zip 24-Jul-2008 04:01 1.1M
EC.zip 24-Jul-2008 04:01 268K
EE.zip 24-Jul-2008 04:01 196K
EG.zip 24-Jul-2008 04:01 771K
EH.zip 24-Jul-2008 04:01 55K
ER.zip 24-Jul-2008 04:01 105K
ES.zip 24-Jul-2008 04:02 1.7M
ET.zip 24-Jul-2008 04:02 451K
FI.zip 24-Jul-2008 04:02 880K
FJ.zip 24-Jul-2008 04:02 204K
FK.zip 24-Jul-2008 04:02 28K
FM.zip 24-Jul-2008 04:02 132K
FO.zip 24-Jul-2008 04:02 41K
FR.zip 24-Jul-2008 04:02 3.2M
GA.zip 24-Jul-2008 04:02 131K
GB.zip 24-Jul-2008 04:02 850K
GD.zip 24-Jul-2008 04:02 16K
GE.zip 24-Jul-2008 04:02 231K
GF.zip 24-Jul-2008 04:02 62K
GG.zip 24-Jul-2008 04:02 20K
GH.zip 24-Jul-2008 04:02 243K
GI.zip 24-Jul-2008 04:02 8.0K
GL.zip 24-Jul-2008 04:02 181K
GM.zip 24-Jul-2008 04:02 50K
GN.zip 24-Jul-2008 04:02 220K
GP.zip 24-Jul-2008 04:02 33K
GQ.zip 24-Jul-2008 04:02 81K
GR.zip 24-Jul-2008 04:02 684K
GS.zip 24-Jul-2008 04:02 16K
GT.zip 24-Jul-2008 04:02 288K
GU.zip 24-Jul-2008 04:02 30K
GW.zip 24-Jul-2008 04:02 133K
GY.zip 24-Jul-2008 04:02 116K
HK.zip 24-Jul-2008 04:02 40K
HM.zip 24-Jul-2008 04:02 5.6K
HN.zip 24-Jul-2008 04:02 376K
HR.zip 24-Jul-2008 04:02 531K
HT.zip 24-Jul-2008 04:02 304K
HU.zip 24-Jul-2008 04:02 531K
ID.zip 24-Jul-2008 04:03 2.9M
IE.zip 24-Jul-2008 04:03 517K
IL.zip 24-Jul-2008 04:03 117K
IM.zip 24-Jul-2008 04:03 5.2K
IN.zip 24-Jul-2008 04:03 905K
IO.zip 24-Jul-2008 04:03 6.0K
IQ.zip 24-Jul-2008 04:03 579K
IR.zip 24-Jul-2008 04:03 3.8M
IS.zip 24-Jul-2008 04:03 321K
IT.zip 24-Jul-2008 04:03 1.2M
JE.zip 24-Jul-2008 04:03 11K
JM.zip 24-Jul-2008 04:03 79K
JO.zip 24-Jul-2008 04:03 186K
JP.zip 24-Jul-2008 04:03 644K
KE.zip 24-Jul-2008 04:03 475K
KG.zip 24-Jul-2008 04:03 59K
KH.zip 24-Jul-2008 04:03 287K
KI.zip 24-Jul-2008 04:03 12K
KM.zip 24-Jul-2008 04:03 33K
KN.zip 24-Jul-2008 04:03 14K
KP.zip 24-Jul-2008 04:04 1.0M
KR.zip 24-Jul-2008 04:04 954K
KW.zip 24-Jul-2008 04:04 35K
KY.zip 24-Jul-2008 04:04 9.0K
KZ.zip 24-Jul-2008 04:04 594K
LA.zip 24-Jul-2008 04:04 433K
LB.zip 24-Jul-2008 04:04 724K
LC.zip 24-Jul-2008 04:04 15K
LI.zip 24-Jul-2008 04:04 5.2K
LK.zip 24-Jul-2008 04:04 550K
LR.zip 24-Jul-2008 04:04 169K
LS.zip 24-Jul-2008 04:04 25K
LT.zip 24-Jul-2008 04:04 243K
LU.zip 24-Jul-2008 04:04 32K
LV.zip 24-Jul-2008 04:04 222K
LY.zip 24-Jul-2008 04:04 679K
MA.zip 24-Jul-2008 04:04 1.0M
MC.zip 24-Jul-2008 04:04 3.9K
MD.zip 24-Jul-2008 04:04 84K
ME.zip 24-Jul-2008 04:04 325K
MF.zip 24-Jul-2008 04:04 5.4K
MG.zip 24-Jul-2008 04:04 564K
MH.zip 24-Jul-2008 04:04 77K
MK.zip 24-Jul-2008 04:04 144K
ML.zip 24-Jul-2008 04:04 388K
MM.zip 24-Jul-2008 04:04 917K
MN.zip 24-Jul-2008 04:04 239K
MO.zip 24-Jul-2008 04:04 7.5K
MP.zip 24-Jul-2008 04:04 17K
MQ.zip 24-Jul-2008 04:04 33K
MR.zip 24-Jul-2008 04:04 196K
MS.zip 24-Jul-2008 04:04 7.9K
MT.zip 24-Jul-2008 04:04 66K
MU.zip 24-Jul-2008 04:04 39K
MV.zip 24-Jul-2008 04:04 17K
MW.zip 24-Jul-2008 04:04 164K
MX.zip 24-Jul-2008 04:04 2.0M
MY.zip 24-Jul-2008 04:04 951K
MZ.zip 24-Jul-2008 04:05 1.1M
NA.zip 24-Jul-2008 04:05 164K
NC.zip 24-Jul-2008 04:05 100K
NE.zip 24-Jul-2008 04:05 313K
NF.zip 24-Jul-2008 04:05 3.2K
NG.zip 24-Jul-2008 04:05 655K
NI.zip 24-Jul-2008 04:05 127K
NL.zip 24-Jul-2008 04:05 415K
NO.zip 24-Jul-2008 04:05 1.2M
NP.zip 24-Jul-2008 04:05 34K
NR.zip 24-Jul-2008 04:05 3.8K
NU.zip 24-Jul-2008 04:05 4.1K
NZ.zip 24-Jul-2008 04:05 1.5M
OM.zip 24-Jul-2008 04:05 146K
PA.zip 24-Jul-2008 04:05 316K
PE.zip 24-Jul-2008 04:05 2.0M
PF.zip 24-Jul-2008 04:05 56K
PG.zip 24-Jul-2008 04:05 436K
PH.zip 24-Jul-2008 04:05 1.2M
PK.zip 24-Jul-2008 04:05 2.6M
PL.zip 24-Jul-2008 04:06 1.0M
PM.zip 24-Jul-2008 04:06 15K
PN.zip 24-Jul-2008 04:06 4.0K
PR.zip 24-Jul-2008 04:06 195K
PS.zip 24-Jul-2008 04:06 130K
PT.zip 24-Jul-2008 04:06 461K
PW.zip 24-Jul-2008 04:06 41K
PY.zip 24-Jul-2008 04:06 85K
QA.zip 24-Jul-2008 04:06 33K
RE.zip 24-Jul-2008 04:06 26K
RO.zip 24-Jul-2008 04:06 562K
RS.zip 24-Jul-2008 04:06 684K
RU.zip 24-Jul-2008 04:06 6.6M
RW.zip 24-Jul-2008 04:06 63K
SA.zip 24-Jul-2008 04:06 649K
SB.zip 24-Jul-2008 04:06 172K
SC.zip 24-Jul-2008 04:06 12K
SD.zip 24-Jul-2008 04:06 477K
SE.zip 24-Jul-2008 04:07 1.8M
SG.zip 24-Jul-2008 04:07 36K
SH.zip 24-Jul-2008 04:07 15K
SI.zip 24-Jul-2008 04:07 120K
SJ.zip 24-Jul-2008 04:07 149K
SK.zip 24-Jul-2008 04:07 189K
SL.zip 24-Jul-2008 04:07 150K
SM.zip 24-Jul-2008 04:07 3.8K
SN.zip 24-Jul-2008 04:07 266K
SO.zip 24-Jul-2008 04:07 396K
SR.zip 24-Jul-2008 04:07 54K
ST.zip 24-Jul-2008 04:07 16K
SV.zip 24-Jul-2008 04:07 152K
SY.zip 24-Jul-2008 04:07 499K
SZ.zip 24-Jul-2008 04:07 10K
TC.zip 24-Jul-2008 04:07 7.1K
TD.zip 24-Jul-2008 04:07 363K
TF.zip 24-Jul-2008 04:07 45K
TG.zip 24-Jul-2008 04:07 116K
TH.zip 24-Jul-2008 04:07 926K
TJ.zip 24-Jul-2008 04:07 103K
TK.zip 24-Jul-2008 04:07 3.7K
TL.zip 24-Jul-2008 04:07 144K
TM.zip 24-Jul-2008 04:07 97K
TN.zip 24-Jul-2008 04:07 545K
TO.zip 24-Jul-2008 04:07 15K
TR.zip 24-Jul-2008 04:07 1.4M
TT.zip 24-Jul-2008 04:07 36K
TV.zip 24-Jul-2008 04:07 5.5K
TW.zip 24-Jul-2008 04:07 1.1M
TZ.zip 24-Jul-2008 04:07 278K
UA.zip 24-Jul-2008 04:07 776K
UG.zip 24-Jul-2008 04:07 192K
UM.zip 24-Jul-2008 04:07 7.7K
US.zip 24-Jul-2008 04:10 52M
UY.zip 24-Jul-2008 04:10 115K
UZ.zip 24-Jul-2008 04:10 149K
VA.zip 24-Jul-2008 04:10 4.0K
VC.zip 24-Jul-2008 04:10 10K
VE.zip 24-Jul-2008 04:10 1.4M
VG.zip 24-Jul-2008 04:10 13K
VI.zip 24-Jul-2008 04:10 50K
VN.zip 24-Jul-2008 04:10 771K
VU.zip 24-Jul-2008 04:10 85K
WF.zip 24-Jul-2008 04:10 6.7K
WS.zip 24-Jul-2008 04:10 13K
YE.zip 24-Jul-2008 04:10 415K
YT.zip 24-Jul-2008 04:10 12K
ZA.zip 24-Jul-2008 04:11 1.9M
ZM.zip 24-Jul-2008 04:11 545K
ZW.zip 24-Jul-2008 04:11 367K
![[TXT]](/icons/text.gif)
admin1Codes.txt 24-Jul-2008 04:23 79K
admin1CodesASCII.txt 24-Jul-2008 04:11 151K
admin2Codes.txt 24-Jul-2008 04:11 547K
allCountries.zip 24-Jul-2008 04:11 164M
alternateNames.zip 24-Jul-2008 04:23 23M
alternateNamesDeletes-2008-07-23.txt 24-Jul-2008 04:23 56
alternateNamesModifications-2008-07-23.txt 24-Jul-2008 04:23 99
cities1000.zip 24-Jul-2008 04:11 3.1M
cities15000.zip 24-Jul-2008 04:11 1.0M
cities5000.zip 24-Jul-2008 04:11 1.7M
countryInfo.txt 24-Jul-2008 03:12 28K
deletes-2008-07-23.txt 24-Jul-2008 04:23 51
featureCodes.txt 24-Jul-2008 03:12 54K
iso-languagecodes.txt 24-Jul-2008 03:12 121K
modifications-2008-07-23.txt 24-Jul-2008 04:11 13K
no-country.zip 24-Jul-2008 04:11 177K
readme.txt 24-Jul-2008 03:12 6.0K
timeZones.txt 24-Jul-2008 04:23 9.9K
userTags.zip 24-Jul-2008 04:23 145K
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.
Contact GeoNames (license@geonames.org) if you want to license the data without the 'attributions by' restriction.
The data format is tab-delimited text in utf8 encoding.
Files :
-------
XX.zip : features for country with iso code XX
allCountries.zip : all countries combined in one file.
cities1000.zip : all cities with a population > 1000 (ca 80.000)
cities5000.zip : all cities with a population > 5000 (ca 40.000)
cities15000.zip : all cities with a population > 15000 (ca 20.000)
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(4000)
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 : integer
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.
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