URL: http://www.geonames.org Tab Seperated Files: =======[ countryInfo.txt ]======= #ISO ISO3 ISO-Numeric fips Country Capital Area(in sq km) Population Continent tld CurrencyCode CurrencyName Phone Postal Code Format Postal Code Regex Languages geonameid neighbours EquivalentFipsCode ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- GR GRC 300 GR Greece Athens 131940 11000000 EU .gr EUR Euro 30 ### ## ^(\d{5})$ el-GR,en,fr 390903 AL,MK,TR,BG .... =======[ admin1CodesASCII.txt: ]======= concatenated.codes name asciiname geonameId ----------------------------------------------------------------------------------------- GR.736572 Mount Athos Mount Athos 736572 GR.ESYE31 Attica Attica 6692632 GR.ESYE24 Central Greece Central Greece 6697800 GR.ESYE12 Central Macedonia Central Macedonia 6697801 GR.ESYE43 Crete Crete 6697802 GR.ESYE11 East Macedonia and Thrace East Macedonia and Thrace 6697803 GR.ESYE21 Epirus Epirus 6697804 GR.ESYE22 Ionian Islands Ionian Islands 6697805 GR.ESYE41 North Aegean North Aegean 6697806 GR.ESYE25 Peloponnese Peloponnese 6697807 GR.ESYE42 South Aegean South Aegean 6697808 GR.ESYE14 Thessaly Thessaly 6697809 GR.ESYE23 West Greece West Greece 6697810 GR.ESYE13 West Macedonia West Macedonia 6697811 =======[ admin2Codes.txt ]======= concatenated.codes name asciiname geonameId ----------------------------------------------------------------------------------------- GR.ESYE22.28 Nomós Zakýnthou Nomos Zakynthou 251276 GR.ESYE22.26 Lefkada Lefkada 258445 GR.ESYE22.27 Nomós Kefallinías Nomos Kefallinias 260310 GR.ESYE22.25 Nomós Kerkýras Nomos Kerkyras 2463676 =======[ allCountries.txt ]======= ------------+-------------------+-------------------+-------------------------------+-----------+-----------+---------------+---------------+---------------+-------+---------------+---------------+---------------+---------------+-----------+-----------+-------+---------------+----------------------- geonameid |name |asciiname |alternatenames |latitude |longitude |feature class |feature code |country code |cc2 |admin1 code |admin2 code |admin3 code |admin4 code |population |elevation |dem |timezone |modification date ------------+-------------------+-------------------+-------------------------------+-----------+-----------+---------------+---------------+---------------+-------+---------------+---------------+---------------+---------------+-----------+-----------+-------+---------------+----------------------- 390903 |Hellenic Republic |Hellenic Republic |Ellada,Ellas |39 |22 |A |PCLI |GR | |00 | | | |11000000 | |644 |Europe/Athens |2016-02-02 6697805 |Ionian Islands |Ionian Islands |Iles Ioniennes,Ionia Nisia |37.79299 |20.78305 |A |ADM1 |GR | |ESYE22 | | | |212984 | |-9999 |Europe/Athens |2016-12-27 2463676 |Nomós Kerkýras |Nomos Kerkyras |Corfu,Kerkira,Νομός Κερκύρας |39.66667 |19.75 |A |ADM2 |GR | |ESYE22 |25 | | |113658 | |150 |Europe/Athens |2013-12-19 8133855 |Dimos Corfu |Dimos Corfu |Kerkyras,Κέρκυρα,Κέρκυρας |39.64099 |19.83588 |A |ADM3 |GR | |ESYE22 |25 |9118 | |108652 | |65 |Europe/Athens |2012-02-28 258427 |Lefkímmi |Lefkimmi |Agioi Theodoroi,Λευκίμμη |39.42336 |20.07094 |P |PPL |GR | |ESYE22 |25 |9118 | |2935 | |21 |Europe/Athens |2014-10-01 feature code eg PCLI Hellenic Republic ADM1 Ionian Islands ADM2 Nomos Kerkyras ADM3 Dimos Corfu =======[ hierarchy.txt ]======= 9408658 390903 un m49 region (Rectangle?) - Greece ..... 390903 6697805 ADM Greece -> Ionian 390903 6697808 ADM Greece -> South Aigaion .... 6697805 251276 ADM Ionian -> Zakinthos 6697805 2463676 ADM Ionian -> Kerkyra .... 2463676 8133911 ADM Kerkyra -> Dimos Paxoi 2463676 8133855 ADM Kerkyra -> Dimos Corfu --------------------------------------------------- geo Table Schema: --------------------------------------------------- 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, ascii names automatically transliterated, convenience attribute from alternatename table, varchar(10000) 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, 200 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 (8 byte int) elevation : in meters, integer dem : digital elevation model, srtm3 or gtopo30, average elevation of 3''x3'' (ca 90mx90m) or 30''x30'' (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat. timezone : the iana timezone id (see file timeZone.txt) varchar(40) modification date : date of last modification in yyyy-MM-dd format