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