Geodata International - Detailed Locality Database
Towns, town quarters, postal codes, coordinates and more

•  Detailed Description of the current Version
•  Data Sheet
•  Database Examples
•  Prices of Geodata International
•  Download  Place order

Geodata International - Worldwide database of the countries with towns, municipalities, town quarters, postal codes, administrative units and more with WGS84 and UTM coordinates and elevations for geocoding, data processing, proximity search, navigation, distance calculation as Text, CSV, SDF, dBase or SQL files with ANSI, UTF8 or Unicode character set.

Geodata International - Version 12.03 - Last update on 25 January 2020
The latest important changes  History of Changes and Supplements

1. 272 country files renewed.
2. Database "Germany" updated on status 1/1/2020.
3. Google Plus code coordinates added to all data tables.
4. Beginning and end of the Daylight Saving Time added.
5. World time UTC_DIF is determined very precisely from a shape file.
6. New country group "Middle East".

International geodata as reference data for your business

xBase example with geodata of Great Britain

xBase example Great Britain

CSV example with geodata of Germany

CSV example Germany

CSV example with geodata of USA

CSV example USA

The locality database tables of nearly all countries of the world contain towns and municipalities, urban districts and localities as well as postal zip codes with geo references for unique local allocations and distance calculations. Each data record is georeferenced using Lon/Lat, UTM coordinates and Google Plus Codes with WGS84 datum, so the data can easily be displayed on maps and imported into any GIS using standard geographic formats. Additional contents are administrative divisions and statistical units, altitude and Time Zones and presentation of the coordinates in various forms. The data are available across countries with a unitary structure as CSV, SDF and xBase files in UTF8 format so they can easily be used in any standard software and custom applications. Geodata International data files are provided in country-specific accuracy and high topicality and they are subject to continuous quality control.

Geodata International - Detailed Data Description
International Geodata for geocoding, data enrichment, proximity search, navigation and distance calculation

You can connect your own company data with the "Geodata International". This is useful if your company data need to be enriched with georeferences, local or postal features. Thus, for example, addresses can be completed or adjusted even during data collection. Or you want to establish a location relationship for an address characteristic - still a georeference. The georeference can be used e.g. to show a customer the nearest chain store by doing a proximity search. On the basis of the georeferences business zones, statistics or general maps can be made. Towns, municipalities and postal codes can be assigned to the superordinated administrative units.

Topic selection

•  More examples for the usage of the database tables
•  Available country groups and single countries
•  Data fields of the country data tables
•  Quality of the Geodata of the respective countries
•  Use of the coordinates contained in the country data tables
•  Conversion to the necessary data format
•  Acquisition of a license and right of use of the database tables
•  Pricing and ordering
•  Note to the download of the test data and the data converter

More examples for the usage of the database tables

Distances between localities or postal areas can be determined with the coordinates contained in the database tables. For that the georeferences are available in all country database tables as UTM coordinates on the natural and an uniformly meridian strip and as geographical coordinates in degree and deg/min/sec notation. With the elevation data from a Digital Elevation Model the ground level height of each place can be determined.

Geographical coordinates in degree notation are particularly well suitable for map views and researches with Google Earth, Google Maps and OpenStreetMap. As an example here an  Internet URL is presented using the free Google API with the coordinate of the Statue of Liberty National Monoment in New York for displaying a map on Google Maps. The first value behind the identifier ";query" is the geographical latitude, then the geographical longitude follows. The shown source below can be inserted directly into an anchor tag to present the map.

https://www.google.com/maps/search/
?api=1
&query=51.36430,06.41962

All these possibilities are offered by the country database tables, which are briefly described in the following text. An exact data description and information for the use of the database tables and a lot of test data you can find in the  download file.

 To the topic selection

Available country groups and single countries

Country groups
 Country group Germany/Austria/Switzerl. (5 files)
 Country group Germany + Neighbors (13 files)
 Country group West Europe (42 files)
 Country group East Europe (25 files)
 Country group Pan Europe (67 files)
 Country group North America (9 files)
 Country group Central America + Caribbean (32 files)
 Country group South America (16 files)
 Country group Austral-Asia + Pacific (24 files)
 Country group Asia (54 files)
 Country group Middle East (26 files)
 Country group Africa (60 files)
 Country group World-wide (288 files)
Geodata North America
 Bermuda (en 110)           Canada-ZIP6 (en 870,000) Mexico (es 190,000)
 Canada-ZIP3 (en 8,400)     Canada-ZIP6 (fr 870,000) Saint Pierre (fr 3)
 Canada-ZIP3 (fr 8,400)     Greenland (en 32)        USA (en 60,000)
Geodata Central America + Caribbean
 Anguilla (en 14)           Dominic. Rep. (es 2,000) Nicaragua (es 7,500)
 Antigua (en 49)            Dominica (en 130)        Panama (es 11,000)
 Aruba (en 62)              El Salvador (es 3,400)   Puerto Rico (en 2,800)
 Bahamas (en 260)           Grenada (en 82)          Sa.KittsNevis (en 99)
 Barbados (en 2,600)        Guadeloupe (fr 37)       Saint Lucia (en 260)
 Belize (en 400)            Guatemala (es 520)       Saint Vincent (en 94)
 Br.Virg.Isls. (en 35)      Haiti (fr 8,300)         Sint Maarten (nl 8)
 Cayman Isl. (en 14)        Honduras (es 3,700)      TrinidadTobag (en 180)
 Costa Rica (es 7,600)      Jamaica (en 880)         TurksCaicos (en 30)
 Cuba (es 3,300)            Martinique (fr 37)       US Virgin Isl (en 8)
 Curacao (en 66)            Montserrat (en 30)
Geodata South America
 Argentin_ZIP5 (es 21,000)  Colombia (es 22,000)     Peru (es 96,000)
 Argentin_ZIP8 (es 2,1 Mio) Ecuador (es 1,300)       Suriname (nl 540)
 Bolivia (es 13,000)        Falkland-Isl. (en 2)     Uruguay (es 1,900)
 Brazil-ZIP5 (pt 24,000)    French Guiana (fr 34)    Venezuela (es 35,000)
 Brazil-ZIP8 (pt 1,0 Mio)   Guyiana (en 500)
 Chile (es 270,000)         Paraguay (es 8,600)
Geodata West Europe
 Aland (Finl.) (fi 32)      Gibraltar (en 1)         Malta (mt 26,000)
 Aland (Finl.) (sv 32)      GrBrit-ZIP4 (en 41,000)  Monaco (fr 9)
 Andorra (ca 48)            GrBrit-ZIP7 (en 1,7 Mio) Netherl-ZIP4 (nl 4,100)
 Austria (de 19,000)        Greece (en 18,000)       Netherl-ZIP6 (nl 460,000)
 Belgium (fr 3,000)         Greece (el 18,000)       Norway (no 3,300)
 Belgium (nl 3,000)         Guernsey (en 2,500)      Portug-ZIP4 (pt 35,000)
 Cyprus (en 1,100)          Iceland (is 140)         Portug-ZIP7 (pt 200,000)
 Cyprus (el 1,100)          Ireland (en 51,000)      San Marino (it 12)
 Denmark (da 14,000)        Ireland (ga 51,000)      Spain (es 100,000)
 Faroe (da 110)             Isle OF Man (en 4,400)   Sweden (sv 16,000)
 Finland (sv 3,000)         Italy (it 37,000)        Switzerland (fr 5,600)
 Finland (fi 3,100)         Jersey (en 2,200)        Switzerland (de 5,600)
 France (fr 38,000)         Liechtenstein (de 15)    Switzerland (it 5,600)
 Germany (de 110,000)       Luxembourg (fr 4,400)    Vatican (it 1)
Geodata East Europe
 Albania (sq 3,200)         Hungary (hu 3,500)       Russia (ru 130,000)
 Belarus (en 35,000)        Latvia (lv 7,600)        Serbia (sr 5,300)
 Belarus (be 35,000)        Lithuania (lt 33,000)    Slovakia (sk 4,300)
 Bosnia/Herc. (bs 740)      Macedonia (mk 1,800)     Slovenia (sl 6,600)
 Bulgaria (en 6,300)        Macedonia (en 1,800)     Turkey (tr 74,000)
 Bulgaria (bg 6,300)        Moldova (ro 1,800)       Ukraine (uk 32,000)
 Croatia (hr 6,700)         Montenegro (sr 1,200)    Ukraine (en 32,000)
 Czech Rep. (cs 15,000)     Poland (pl 72,000)
 Estonia (et 5,800)         Russia (en 130,000)
Geodata Africa
 Algeria (fr 15,000)        Gabon (en 4,100)         Niger (fr 29,000)
 Angola (pt 14,000)         Gambia (en 1,900)        Nigeria (en 54,000)
 Benin (fr 540)             Ghana (en 9,400)         Reunion (fr 96)
 Botswana (en 490)          Guinea (en 28,000)       Rwanda (en 9,600)
 Bukina Faso (fr 1,900)     Guinea Bissau (en 5,200) Sao Tome (en 18)
 Burundi (fr 8,600)         Ivory Coast (fr 6,500)   Senegal (fr 14,000)
 Cameroon (fr 10,000)       Kenya (en 6,700)         Seychelles (en 79)
 Cape Verde (pt 490)        Lesotho (en 9,000)       Sierra Leone (en 7,700)
 CentAfr. Rep. (fr 6,500)   Liberia (en 13,000)      Somalia (en 9,400)
 Chad (fr 10,000)           Libya (en 770)           South Africa (en 8,000)
 Comoros (en 470)           Madagascar (fr 17,000)   South Africa (af 8,000)
 Congo Brazza. (en 5,300)   Malawi (en 620)          South Sudan (en 4,900)
 Congo DemRep (en 25,000)   Mali (fr 17,000)         Sudan (en 7,200)
 Djibouti (en 300)          Mauritania (en 8,200)    Swaziland (en 79)
 Egypt (ar 5,600)           Mauritius (en 2,000)     Tanzania (en 15,000)
 Egypt (en 5,600)           Mayotte (fr 73)          Togo (en 5,100)
 Equat. Guinea (en 2,300)   Morocco (ar 1,500)       Tunisia (fr 4,800)
 Eritrea (en 3,800)         Morocco (fr 1,500)       Uganda (en 7,400)
 Ethiopia (en 16,000)       Mozambique (pt 10,000)   Zambia (en 11,000)
 Frenc South. (fr 14)       Namibia (en 1,900)       Zimbabwe (en 840)
Geodata Asia
 Afghanistan (en 36,000)    Indonesia (id 86,000)    North Korea (en 720)
 Armenia (hy 900)           Japan (en 120,000)       Pakistan (en 2,400)
 Armenia (en 910)           Japan (kt 120,000)       Philippines (en 41,000)
 Azerbaijan (az 1,600)      Japan (ja 120,000)       Singapore (en 130,000)
 Azerbaijan (en 1,600)      Kazakhstan (kk 640)      South Korea (ko 43,000)
 Bangladesch (en 1,300)     Kazakhstan (en 9,500)    South Korea (en 43,000)
 Bhutan (en 260)            Kazakhstan (ru 9,500)    Sri Lanka (en 13,000)
 Brunei (en 540)            Kyrgyzstan (en 920)      Taiwan (en 18,000)
 Cambodia (km 13,000)       Kyrgyzstan (ru 920)      Taiwan (zh 18,000)
 Cambodia (en 14,000)       Laos (en 10,000)         Tajikistan (tg 330)
 China-ZIP4 (zh 4,100)      Macau (en 7)             Tajikistan (ru 490)
 China-ZIP4 (en 4,100)      Macau (zh 7)             Tajikistan (en 2,700)
 China-ZIP6 (zh 540,000)    Malaysia (en 1,800)      Thailand (en 7,300)
 China-ZIP6 (en 590,000)    Maldives (en 7,000)      Thailand (th 7,300)
 Georgia (en 6,100)         Mongolia (mn 1,700)      Turkmenistan (en 94)
 HongKong (zh 94)           Mongolia (en 1,700)      Uzbekistan (en 2,900)
 HongKong (en 94)           Myanmar (en 31,000)      Uzbekistan (ru 2,900)
 India (en 150,000)         Nepal (en 910)           Vietnam (vi 160,000)
Geodata Austral-Asia + Pacific
 Am. Samoa (en 79)          Marshall Isl. (en 34)    Palau Republ. (en 16)
 Australia (en 16,000)      Micronesia (en 74)       Papua N.Guin. (en 310)
 Cook Islands (en 15)       Min.Outl.Isl. (en 11)    Samoa (en 400)
 East Timor (en 2,200)      Nauru (en 150)           Solomon Isl. (en 170)
 Fiji (en 1,500)            New Caledonia (fr 43)    Tonga (en 160)
 French Polyn. (fr 200)     New Zealand (en 6,500)   Tuvalu (en 19)
 Guam (en 39)               Nieu (NewZl.) (en 13)    Vanuatu (en 66)
 Kiribati (en 180)          North Mariana (en 15)    WallisFutuna (fr 36)
Geodata Middle East
 Bahrain (en 480)           Jordan (en 930)          Qatar (en 780)
 Iran (ar 390)              Kuwait (en 1,600)        Saudi Arabia (en 17,000)
 Iran (en 390)              Kuwait (ar 1,600)        Saudi Arabia (ar 17,000)
 Iraq (en 10,000)           Lebanon (en 2,700)       Syria (en 5,500)
 Israel-ZIP4 (he 4,300)     Lebanon (ar 2,700)       Syria (ar 5,500)
 Israel-ZIP4 (en 4,300)     Oman (ar 3,900)          UnitArabEmi (en 1,000)
 Israel-ZIP7 (en 650,000)   Oman (en 3,900)          Yemen (en 30,000)
 Israel-ZIP7 (he 640,000)   Palestine (en 860)       Yemen (ar 30,000)
 Jordan (ar 930)            Qatar (ar 780)

For each country the language variety in ISO 3166-1 ALPHA-2 format and the number of available records are written in parenthesis. Point data of other countries we offer on request.

 To the topic selection

Data fields of the country data tables

The available country data tables contain different counts of data records with georeferenced local data and postal data. Detailed information, linkage possibilities with other database tables, hints to the use of the georeferences and the formulas for distance calculation you find in the files of the download or in the detailed  Data Sheet. These data fields are contained in the country data tables:

1. Unique ID of the continent
2. Unique ID of the country (ISO 3166-1 ALPHA-2)
3. Unique ID of the language (ISO 639-1 ALPHA-2)
4. Postal code / Zip code
5. Town name / municipality name / local name
6. Urban district / local part name
7. Administrative identification (e.g. municipality key)
8. Name of the 1st administrative unit (e.g. federal state)
9. Name for the 2nd administrative unit (e.g. province)
10. Name of the 3rd administrative unit (e.g. county / district)
11. Geographical longitude in degree notation
12. Geographical latitude in degree notation
13. Geographical longitude in degree/minute/second notation
14. Geographical latitude in degree/minute/second notation
15. UTM easting on the natural meridian strip
16. UTM northing on the natural meridian strip
17. UTM easting on an uniformly meridian strip
18. UTM northing on an uniformly meridian strip
19. UTM strip number of the uniformly meridian and hemisphere
20. Plus Code / Open Location Code
21. Ground elevation over the sea level
22. Offset of the local time to the UTC world time
23. Offset of the local time to the Daylight Saving Time DST
24. Start of the Daylight Saving Time in the year
25. End of the Daylight Saving Time in the year
26. Month of the last data update

 To the topic selection

Quality of the Geodata of the respective countries

The geodata geodata of the product "Geodata International" are from official sources, they are not part of open-source data!

The geodata described here are subject to a continuing quality control. The raw data of the individual countries as basis for "Geodata International" are recorded from there residents authorities, institutions and suppliers. As result the quality of the raw data depends on the infrastructure and the possibilities inside the respective countries. Geodata of the industrial nations exhibit therefore normally a higher quality than those of the developing countries. The geodata are prepared, computed and standardized from these raw data with best knowledge by specialized experts. We have to emphasize expressly that from the raw data resulting deviations or errors of a small extent can not excluded in any case and cannot be faulted.

 To the topic selection

Use of the coordinates contained in the country data tables

The coordinates are present as geographic coordinates longitude/latitude and as UTM coordinates with UTM easting and UTM northing on the natural meridian strip and on a uniform meridian strip. Because UTM coordinates are converted country-wide to a uniform meridian strip, distances between two points can be calculated by the simple execution of the Pythagoras theorem. That has the advantage in relation to the computation with geographical coordinates (see below) that it is substantially simpler and much faster. The result is the distance between the points in meters. Detailed information and hints to the use of the georeferences can be found in the files of the download or in the detailed  Data Sheet.

Formula for the distance calculation with UTM coordinates:
difEast  := abs(UTM_E_CENT_1 - UTM_E_CENT_2)
difNorth := abs(UTM_N_CENT_1 - UTM_N_CENT_2)
distance  := sqrt(difEast * difEast + difNorth * difNorth)
with
UTM_E_CENT_1:    Easting of the first coordinate
UTM_N_CENT_1:    Northing of the first coordinate
UTM_E_CENT_2:    Easting of the second coordinate
UTM_N_CENT_2:    Northing of the second coordinate
abs():           Absolute value
sqrt():          Square root
distance:        The result is the distance in meters

Geographic coordinates are indicated in longitude and latitude. Usually longitude and latitude are represented in the degree/minute/second notation. For further calculations with the coordinates, the minute and second portions must be converted into parts of a degree. The representation of latitude and longitude in degrees is called the decimal notation. For a distance computation the longitude and latitude of the first point (Lon1, Lat1) and the longitude and latitude of the second point (Lon2, Lat2) are needed. If the latitude has a minus sign, the point is on the southern earth hemisphere, otherwise on the northern earth hemisphere. If the longitude has a minus sign, the point is situated west of the Greenwich meridian, otherwise east of it. If the latitude has a minus sign, the point is on the southern earth hemisphere, otherwise on the northern earth hemisphere.

Representation of the longitude and latitude of a coordinate in the
degree/minute/second notation (Data fields LON_GEO and LAT_GEO).
| Two to three digit degree portion of the coordinate (d)
|  | Two digit minute portion of the coordinate (m)
|  | | Two digit second portion of the coordinate (s)
|  | |  | Decimal portion of one second(s)
dddmmss.ss
with
d:        Degree portion of longitude or latitude
m:        Minute portion of longitude or latitude
s:        Second portion with decimals of longitude or latitude

Conversion of the lengths and widths of the two coordinates into the
decimal notation. This is not necessary if Geographic coordinates in
degree notation are used directly (data fields LON_DEC and LAT_DEC).
Lon1d = d + (m / 60) + (s / 3600)
Lat1d = d + (m / 60) + (s / 3600)
Lon2d = d + (m / 60) + (s / 3600)
Lat2d = d + (m / 60) + (s / 3600)
with
Lon1d:    Decimal longitude of the first point
Lat1d:    Decimal latitude of the first point
Lon1d:    Decimal longitude of the second point
Lat1d:    Decimal latitude of the second point

For further computation the longitude and latitude are converted into
radians. The unit of the radian is [rad].
Lon1r = Lon1d * PI / 180
Lat1r = Lat1d * PI / 180
Lon2r = Lon2d * PI / 180
Lat2r = Lat2d * PI / 180
with
Lon1r:    Radian of the longitude of the first point
Lat1r:    Radian of the latitude of the first point
Lon1r:    Radian of the longitude of the second point
Lat1r:    Radian of the latitude of the second point
PI:       Circle constant Pi (3,14...)

Now the longitudes and latitudes of the two coordinates are so far prepared
that they can be inserted into the formula for the distance computation.
distance = r * acos[sin(Lat1r) * sin(Lat2r)
           + cos(Lat1r) * cos(Lat2r) * cos(Lon2r - Lon1r)]
with
sin():    Sinus function
cos():    Cosinus function
acos():   Arcus Cosinus function
r:        Earth equatorial radius = 6378137 meter
distance: The result is the distance in meters

Coordinates of the Google Plus Code are mapped in the Reference System WGS84. Plus Code is a coding system to identify any area, place or address anywhere in the world. In many countries the Plus Code is also used as a postal code.

The conversion of geographical and UTM coordinates and Google Plus Codes into country-specific coordinates or in another Coordinate and/or Reference System, can be accomplished with the Coordinate Transformation Program  TRANSDATpro or as a contract work.

 To the topic selection

Conversion to the necessary data format

The database tables are present in the file format CSV (Comma Separated Values). The character set used is UTF8. This format is used often and in most cases you can import data directly into your own data system.

The  downloadable freeware program CONVERT converts the available database tables to other data formats and character sets with the necessary sortings and selections. With the program, for example, CSV data can be converted to the SDF format (Simple Document Format) or to the dBase format. For the use of the data on different platforms it is possible to select between the character sets ASCII, ANSI, UTF8 and UniCode. Thus the import of the data in any database management system or file system will be possible.

For the import in MySQL or SQL databases the necessary "CREATE TABLE" script can be generated. Further the selection of the data on data fields and data records is possible. In addition the data can be sorted on base of the data fields. Data from several files can be joined to a common file.

Here you can have a look to some  screenshots of the converter program.

 To the topic selection

Acquisition of a license and right of use of the database tables

The  license models described here require only a unique payment. No additional payments are raised as a function of the number of installations or on the service life of the license. The service life is unlimited.

The database tables presented here can be used as data volumes of computer programs and Internet sites (applications) and can be passed in the context of the application to customers. The database tables are licensed for different types of use:

1. A single license for a database table entitles the license holder to use the database table with a single software application licensed to the database tables license holder. The software application that comes with the database table can be passed to any number of customers or it can be installed as a single application on the Internet Server of the license holder or the server of the license holder's Internet service provider.
2. A general license for a database table entitles the license holder to use the database table with any number of software applications licensed to the database tables license holder. Software applications that come with the database table can be passed to any number of customers and can be installed on a single or multiple Internet servers of the license holder or license holder's Internet service provider.

 To the topic selection

Pricing and ordering

Pricing and ordering information for the database tables presented here and for other software products can be found in the  Price list. Order the "Geodata International" with the electronic  Order Form.

 To the topic selection

Download of the test data and the data converter

A selection of  test data of all countries with the detailed data description and with information about the use of the data can be downloaded as ZIP packed file by the Internet. The Freeware program  CONVERT, developed by KilletSoft, for converting and adaptation of the data is ready for download if necessary.

 To the topic selection