Name Last modified Size Description
![[DIR]](/icons/back.gif)
Parent Directory -
![[ ]](/icons/compressed.gif)
.zip 07-Nov-2009 01:19 4.0K
AD.zip 07-Nov-2009 01:19 60K
AE.zip 07-Nov-2009 01:19 101K
AF.zip 07-Nov-2009 01:19 2.7M
AG.zip 07-Nov-2009 01:19 15K
AI.zip 07-Nov-2009 01:19 6.1K
AL.zip 07-Nov-2009 01:19 248K
AM.zip 07-Nov-2009 01:19 66K
AN.zip 07-Nov-2009 01:19 23K
AO.zip 07-Nov-2009 01:19 361K
AQ.zip 07-Nov-2009 01:19 416K
AR.zip 07-Nov-2009 01:19 1.0M
AS.zip 07-Nov-2009 01:19 23K
AT.zip 07-Nov-2009 01:19 876K
AU.zip 07-Nov-2009 01:19 1.3M
AW.zip 07-Nov-2009 01:19 8.3K
AZ.zip 07-Nov-2009 01:19 211K
BA.zip 07-Nov-2009 01:19 1.1M
BB.zip 07-Nov-2009 01:19 17K
BD.zip 07-Nov-2009 01:19 536K
BE.zip 07-Nov-2009 01:19 473K
BF.zip 07-Nov-2009 01:19 226K
BG.zip 07-Nov-2009 01:19 446K
BH.zip 07-Nov-2009 01:19 19K
BI.zip 07-Nov-2009 01:19 217K
BJ.zip 07-Nov-2009 01:19 100K
BL.zip 07-Nov-2009 01:19 5.0K
BM.zip 07-Nov-2009 01:19 16K
BN.zip 07-Nov-2009 01:19 19K
BO.zip 07-Nov-2009 01:19 570K
BR.zip 07-Nov-2009 01:19 1.8M
BS.zip 07-Nov-2009 01:19 44K
BT.zip 07-Nov-2009 01:19 11K
BV.zip 07-Nov-2009 01:19 4.8K
BW.zip 07-Nov-2009 01:19 27K
BY.zip 07-Nov-2009 01:19 296K
BZ.zip 07-Nov-2009 01:19 46K
CA.zip 07-Nov-2009 01:20 8.2M
CC.zip 07-Nov-2009 01:20 4.6K
CD.zip 07-Nov-2009 01:20 480K
CF.zip 07-Nov-2009 01:20 254K
CG.zip 07-Nov-2009 01:20 230K
CH.zip 07-Nov-2009 01:20 569K
CI.zip 07-Nov-2009 01:20 333K
CK.zip 07-Nov-2009 01:20 15K
CL.zip 07-Nov-2009 01:20 767K
CM.zip 07-Nov-2009 01:20 389K
CN.zip 07-Nov-2009 01:20 3.4M
CO.zip 07-Nov-2009 01:20 1.3M
CR.zip 07-Nov-2009 01:20 92K
CU.zip 07-Nov-2009 01:20 763K
CV.zip 07-Nov-2009 01:20 20K
CX.zip 07-Nov-2009 01:20 5.0K
CY.zip 07-Nov-2009 01:20 136K
CZ.zip 07-Nov-2009 01:20 595K
DE.zip 07-Nov-2009 01:21 3.8M
DJ.zip 07-Nov-2009 01:21 137K
DK.zip 07-Nov-2009 01:21 304K
DM.zip 07-Nov-2009 01:21 11K
DO.zip 07-Nov-2009 01:21 441K
DZ.zip 07-Nov-2009 01:21 1.1M
EC.zip 07-Nov-2009 01:21 269K
EE.zip 07-Nov-2009 01:21 200K
EG.zip 07-Nov-2009 01:21 771K
EH.zip 07-Nov-2009 01:21 55K
ER.zip 07-Nov-2009 01:21 109K
ES.zip 07-Nov-2009 01:21 1.8M
ET.zip 07-Nov-2009 01:21 460K
FI.zip 07-Nov-2009 01:21 885K
FJ.zip 07-Nov-2009 01:21 204K
FK.zip 07-Nov-2009 01:21 28K
FM.zip 07-Nov-2009 01:21 127K
FO.zip 07-Nov-2009 01:21 42K
FR.zip 07-Nov-2009 01:21 3.2M
GA.zip 07-Nov-2009 01:21 131K
GB.zip 07-Nov-2009 01:21 1.0M
GD.zip 07-Nov-2009 01:21 16K
GE.zip 07-Nov-2009 01:21 231K
GF.zip 07-Nov-2009 01:21 62K
GG.zip 07-Nov-2009 01:21 20K
GH.zip 07-Nov-2009 01:21 242K
GI.zip 07-Nov-2009 01:21 8.0K
GL.zip 07-Nov-2009 01:21 182K
GM.zip 07-Nov-2009 01:21 50K
GN.zip 07-Nov-2009 01:21 220K
GP.zip 07-Nov-2009 01:21 33K
GQ.zip 07-Nov-2009 01:21 81K
GR.zip 07-Nov-2009 01:21 705K
GS.zip 07-Nov-2009 01:21 16K
GT.zip 07-Nov-2009 01:21 290K
GU.zip 07-Nov-2009 01:21 30K
GW.zip 07-Nov-2009 01:21 132K
GY.zip 07-Nov-2009 01:21 116K
HK.zip 07-Nov-2009 01:21 44K
HM.zip 07-Nov-2009 01:21 5.6K
HN.zip 07-Nov-2009 01:21 377K
HR.zip 07-Nov-2009 01:21 533K
HT.zip 07-Nov-2009 01:21 304K
HU.zip 07-Nov-2009 01:22 533K
ID.zip 07-Nov-2009 01:22 4.4M
IE.zip 07-Nov-2009 01:22 520K
IL.zip 07-Nov-2009 01:22 116K
IM.zip 07-Nov-2009 01:22 6.2K
IN.zip 07-Nov-2009 01:22 915K
IO.zip 07-Nov-2009 01:22 6.9K
IQ.zip 07-Nov-2009 01:22 1.3M
IR.zip 07-Nov-2009 01:22 4.5M
IS.zip 07-Nov-2009 01:22 317K
IT.zip 07-Nov-2009 01:22 1.3M
JE.zip 07-Nov-2009 01:22 12K
JM.zip 07-Nov-2009 01:22 79K
JO.zip 07-Nov-2009 01:22 191K
JP.zip 07-Nov-2009 01:22 671K
KE.zip 07-Nov-2009 01:22 477K
KG.zip 07-Nov-2009 01:22 59K
KH.zip 07-Nov-2009 01:22 287K
KI.zip 07-Nov-2009 01:22 12K
KM.zip 07-Nov-2009 01:22 33K
KN.zip 07-Nov-2009 01:22 14K
KP.zip 07-Nov-2009 01:23 1.0M
KR.zip 07-Nov-2009 01:23 2.1M
KW.zip 07-Nov-2009 01:23 34K
KY.zip 07-Nov-2009 01:23 9.0K
KZ.zip 07-Nov-2009 01:23 594K
LA.zip 07-Nov-2009 01:23 433K
LB.zip 07-Nov-2009 01:23 724K
LC.zip 07-Nov-2009 01:23 15K
LI.zip 07-Nov-2009 01:23 6.4K
LK.zip 07-Nov-2009 01:23 551K
LR.zip 07-Nov-2009 01:23 170K
LS.zip 07-Nov-2009 01:23 25K
LT.zip 07-Nov-2009 01:23 244K
LU.zip 07-Nov-2009 01:23 32K
LV.zip 07-Nov-2009 01:23 222K
LY.zip 07-Nov-2009 01:23 678K
MA.zip 07-Nov-2009 01:23 1.0M
MC.zip 07-Nov-2009 01:23 4.0K
MD.zip 07-Nov-2009 01:23 84K
ME.zip 07-Nov-2009 01:23 326K
MF.zip 07-Nov-2009 01:23 5.5K
MG.zip 07-Nov-2009 01:23 565K
MH.zip 07-Nov-2009 01:23 73K
MK.zip 07-Nov-2009 01:23 144K
ML.zip 07-Nov-2009 01:23 574K
MM.zip 07-Nov-2009 01:23 917K
MN.zip 07-Nov-2009 01:23 240K
MO.zip 07-Nov-2009 01:23 7.4K
MP.zip 07-Nov-2009 01:23 17K
MQ.zip 07-Nov-2009 01:23 34K
MR.zip 07-Nov-2009 01:23 259K
MS.zip 07-Nov-2009 01:23 7.9K
MT.zip 07-Nov-2009 01:23 67K
MU.zip 07-Nov-2009 01:23 39K
MV.zip 07-Nov-2009 01:23 17K
MW.zip 07-Nov-2009 01:23 164K
MX.zip 07-Nov-2009 01:23 2.0M
MY.zip 07-Nov-2009 01:23 1.0M
MZ.zip 07-Nov-2009 01:23 1.1M
NA.zip 07-Nov-2009 01:23 164K
NC.zip 07-Nov-2009 01:23 100K
NE.zip 07-Nov-2009 01:24 581K
NF.zip 07-Nov-2009 01:24 3.3K
NG.zip 07-Nov-2009 01:24 783K
NI.zip 07-Nov-2009 01:24 127K
NL.zip 07-Nov-2009 01:24 535K
NO.zip 07-Nov-2009 01:24 1.2M
NP.zip 07-Nov-2009 01:24 37K
NR.zip 07-Nov-2009 01:24 3.8K
NU.zip 07-Nov-2009 01:24 4.1K
NZ.zip 07-Nov-2009 01:24 1.5M
OM.zip 07-Nov-2009 01:24 146K
PA.zip 07-Nov-2009 01:24 318K
PE.zip 07-Nov-2009 01:24 2.0M
PF.zip 07-Nov-2009 01:24 56K
PG.zip 07-Nov-2009 01:24 436K
PH.zip 07-Nov-2009 01:24 1.3M
PK.zip 07-Nov-2009 01:24 2.6M
PL.zip 07-Nov-2009 01:24 1.0M
PM.zip 07-Nov-2009 01:24 15K
PN.zip 07-Nov-2009 01:24 4.0K
PR.zip 07-Nov-2009 01:24 194K
PS.zip 07-Nov-2009 01:24 130K
PT.zip 07-Nov-2009 01:24 477K
PW.zip 07-Nov-2009 01:24 41K
PY.zip 07-Nov-2009 01:24 85K
QA.zip 07-Nov-2009 01:24 33K
RE.zip 07-Nov-2009 01:24 26K
RO.zip 07-Nov-2009 01:24 572K
RS.zip 07-Nov-2009 01:24 687K
RU.zip 07-Nov-2009 01:25 7.1M
RW.zip 07-Nov-2009 01:25 63K
SA.zip 07-Nov-2009 01:25 649K
SB.zip 07-Nov-2009 01:25 172K
SC.zip 07-Nov-2009 01:25 12K
SD.zip 07-Nov-2009 01:25 483K
SE.zip 07-Nov-2009 01:25 1.8M
SG.zip 07-Nov-2009 01:25 36K
SH.zip 07-Nov-2009 01:25 16K
SI.zip 07-Nov-2009 01:25 137K
SJ.zip 07-Nov-2009 01:25 149K
SK.zip 07-Nov-2009 01:25 192K
SL.zip 07-Nov-2009 01:25 150K
SM.zip 07-Nov-2009 01:25 3.9K
SN.zip 07-Nov-2009 01:25 280K
SO.zip 07-Nov-2009 01:25 410K
SR.zip 07-Nov-2009 01:25 54K
ST.zip 07-Nov-2009 01:25 16K
SV.zip 07-Nov-2009 01:25 153K
SY.zip 07-Nov-2009 01:25 499K
SZ.zip 07-Nov-2009 01:25 10K
TC.zip 07-Nov-2009 01:25 7.2K
TD.zip 07-Nov-2009 01:25 497K
TF.zip 07-Nov-2009 01:25 45K
TG.zip 07-Nov-2009 01:25 115K
TH.zip 07-Nov-2009 01:25 1.0M
TJ.zip 07-Nov-2009 01:25 103K
TK.zip 07-Nov-2009 01:25 3.7K
TL.zip 07-Nov-2009 01:25 144K
TM.zip 07-Nov-2009 01:25 98K
TN.zip 07-Nov-2009 01:25 545K
TO.zip 07-Nov-2009 01:25 15K
TR.zip 07-Nov-2009 01:25 1.4M
TT.zip 07-Nov-2009 01:25 36K
TV.zip 07-Nov-2009 01:25 5.5K
TW.zip 07-Nov-2009 01:26 1.3M
TZ.zip 07-Nov-2009 01:26 279K
UA.zip 07-Nov-2009 01:26 783K
UG.zip 07-Nov-2009 01:26 192K
UM.zip 07-Nov-2009 01:26 7.7K
US.zip 07-Nov-2009 01:28 52M
UY.zip 07-Nov-2009 01:28 126K
UZ.zip 07-Nov-2009 01:28 150K
VA.zip 07-Nov-2009 01:28 4.2K
VC.zip 07-Nov-2009 01:28 10K
VE.zip 07-Nov-2009 01:29 1.4M
VG.zip 07-Nov-2009 01:29 13K
VI.zip 07-Nov-2009 01:29 50K
VN.zip 07-Nov-2009 01:29 778K
VU.zip 07-Nov-2009 01:29 85K
WF.zip 07-Nov-2009 01:29 6.8K
WS.zip 07-Nov-2009 01:29 13K
YE.zip 07-Nov-2009 01:29 446K
YT.zip 07-Nov-2009 01:29 12K
ZA.zip 07-Nov-2009 01:29 1.9M
ZM.zip 07-Nov-2009 01:29 544K
ZW.zip 07-Nov-2009 01:29 368K
![[TXT]](/icons/text.gif)
admin1Codes.txt 07-Nov-2009 01:31 77K
admin1CodesASCII.txt 07-Nov-2009 01:29 149K
admin2Codes.txt 07-Nov-2009 01:29 1.1M
allCountries.zip 07-Nov-2009 01:29 171M
alternateNames.zip 07-Nov-2009 01:31 35M
alternateNamesDeletes-2009-11-06.txt 07-Nov-2009 01:31 0
alternateNamesModifications-2009-11-06.txt 07-Nov-2009 01:31 323
cities1000.zip 07-Nov-2009 01:29 3.2M
cities15000.zip 07-Nov-2009 01:29 1.0M
cities5000.zip 07-Nov-2009 01:29 1.8M
countryInfo.txt 07-Nov-2009 01:14 29K
deletes-2009-11-06.txt 07-Nov-2009 01:31 213
featureCodes.txt 07-Nov-2009 01:14 54K
iso-languagecodes.txt 07-Nov-2009 01:14 121K
modifications-2009-11-06.txt 07-Nov-2009 01:29 5.9K
no-country.zip 07-Nov-2009 01:29 160K
readme.txt 07-Nov-2009 01:14 6.1K
timeZones.txt 07-Nov-2009 01:31 10K
userTags.zip 07-Nov-2009 01:31 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(4000) (varchar(5000) for SQL Server)
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