Killet Software Ing.-GbR - short: KilletSoft - is a software company, which was established in the year 1991. The society is divided into the ranges "Geodetic Standard Software", "Development Tools for Geo Informatics" and "International Geo Data". The industrial sectors of emphasis of the companies supplied by KilletSoft are consulting engineers, GIS developers, Internet marketing, public utilities, logistics, telecommunications, security and public services.
Print page body  •    Contact  •    Imprint
Deutsch English

Geo Data International Admin - Geo referenced localities and postal zip codes with coordinates - Data Specification 

Database tables "Geo Data International Admin"
==============================================

Description
-----------

The database tables contain postal zip codes, places and local parts of the
European and International countries with geo references, which make possible
an unique local allocation.


Available countries
-------------------

Geo Data Australasia
Australia (10,000)       New-Zealand (1,900)

Geo Data Europe
Albania (390)            Georgia (19)             Norway (3,400)
Andorra (37)             Germany (114,000)        Poland (11,000)
Austria (19,000)         Gibraltar (5)            Portugal-ZIP4 (4,100)
Belarus (74)             Greece (820)             Portugal-ZIP7 (248,000)
Belgium (4,300)          Hungary (3,400)          Romania (13,000)
Bosnia/Herc. (870)       Ireland (2,800)          Russia (1,100)
Bulgaria (180)           Italy (28,000)           San Marino (11)
Croatia (4,000)          Latvia (850)             Serbia (1,500)
Cyprus (210)             Liechtenstein (13)       Slovakia (3,900)
Czech Rep. (15,000)      Lithuania (980)          Slovenia (380)
Denmark (6,300)          Luxembourg (4,000)       Spain (32,000)
Estonia (670)            Macedonia (300)          Sweden (10,000)
Ex-Yugoslavia (1,700)    Malta (70)               Switzerland (7,100)
Finland (6,000)          Moldova (78)             Turkey (1,100)
France (54,000)          Monaco (3)               Ukraine (490)
GB-ZIP5 (34,000)         Netherl.-ZIP4 (5,800)    Vatican (1)
GB-ZIP7 (6,450,000)      Netherl.-ZIP6 (641,000)

Geo Data North America
Canada-ZIP3 (8,100)      Greenland (23)           USA (79,000)
Canada-ZIP6 (797,000)    Mexico (72,000)

Geo Data South America
(in treatment)

In parentheses the numbers of data records for each country are listed. Point
data of more countries we offer on request.


Quality of the Geo Data
-----------------------

The geo data offered here are subject to a continuing quality control. The 
raw data of the individual countries as basis for the geo data 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. Geo data of the industrial nations exhibit 
therefore normally a higher quality than those of the developing countries. 
The geo data are prepared, computed and standardized from these raw data with
best knowledge by a German company specialized in it. We have to emphasize 
expressly that from the raw data resulting deviations or error can not 
excluded in any case and cannot be criticized. 


Conversion to the necessary data format
---------------------------------------

First the database tables are present in a standard file format (dBase, 
ASCII / OEM character set). They can be imported directly into MS-EXCEL, 
MS-ACCESS and in Borlands dBase. 
  
The freeware program CONVERT, downloadable from the site 
http://www.killetsoft.de/p_cona_e.htm, converts dBase formatted database 
tables into other data formats with the necessary characteristics and 
selections. With the program for example dBase data can be converted into 
the SDF format (Simple Document Format) or into the CSV format (Comma 
Separated Value). For the use of the data on different platforms it is 
possible to select between the character sets ASCII / OEM  and 
ANSI / WINDOWS. 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.

Please contact us, if you need the data in another format, sort sequence or 
in another coordinate system.


Coordinate systems and Reference systems
----------------------------------------

The geo references of all objects are contained in the tables as geographic 
coordinates in degree and degree/minute/second notation and as UTM 
coordinates. The UTM coordinates with the suffix "_NAT" are present with 
the strip number of their natural meridian strip.

The geographical and UTM coordinates are globally present in 60 meridian 
strips with a width of 6 degree each. In order to be able to accomplish 
country-wide and even countries spreading distance calculations between the 
coordinates, the UTM coordinates with the suffix "_CENT" are converted 
country-wide to a uniform, national central meridian strip. The UTM 
coordinates with the suffix "_NAT" are present with the strip number of 
their natural meridian strip.

The coordinates of the countries not belonging to Europe are present as the 
reference system "WGS84 (worldwide, GPS), geocentric, WGS84". The reference 
system WGS84 is standardized the in the year 1984 world-wide as "World 
Geodetic System" on the also named WGS84 ellipsoid. It is used for 
navigation tasks with the American satellite navigation system GPS (Global 
Positioning System). 

The coordinates of the European countries are present as the reference 
system "ETRS89 (Europe), geocentric, GRS80". ETRS89 is the reference system 
uniform for all European countries. GRS80 is the ellipsoid used for the 
mapping of the coordinates. ETRS89 is a geocentric (on the earth center 
referred) reference system, which is almost identical to the reference 
system WGS84.

Since WGS84 deviates only very slightly within millimeter range from the 
ETRS89, the direct unification of the here used coordinates with GPS data 
and modern maps is possible.


Distance calculation with right-angled and metric coordinates
-------------------------------------------------------------

Distances between two points in UTM coordinates can be computed by the simple
execution of the Pythagoras theorem, since this coordinate system is 
right-angled and metric. 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.

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


Distance calculation with geographic coordinates
------------------------------------------------

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 a longitude has a minus sign, 
the point is situated west of the Greenwich meridian, otherwise east of it.

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 (not necessary if the data fields LON_DEC and LAT_DEC are used).
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

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


Field widths and data types
---------------------------

Field       Width Typ Description
RECORD_ID   8    C   Unique ID of the town inside the country
CONT_CODE   2    C   Unique ID of the continent
ISO3_CODE   3    C   Unique ID of the country (ISO 3166 ALPHA-3)
ISO2_CODE   2    C   Unique ID of the country (ISO 3166 ALPHA-2)
POST_CODE   8    C   Postal code / Zip code
TOWN       40    C   Town name / municipality name / local name
QUARTER    40    C   Town quarter / local part name
MUNIC_CODE  8    C   Administrative identification (e.g. municipality key)
LON_DEC    10    C   Geographical longitude in degree notation
LAT_DEC     9    C   Geographical latitude in degree notation
LON_GEO    10    C   Geographical longitude in degree/minute/second notation
LAT_GEO     9    C   Geographical latitude in degree/minute/second notation
UTM_E_NAT   8    C   UTM easting on the natural meridian strip
UTM_N_NAT   8    C   UTM northing on the natural meridian strip
UTM_E_CENT  8    C   UTM easting on an uniform meridian strip
UTM_N_CENT  8    C   UTM northing on an uniform meridian strip
UTM_STRIP   2    C   UTM strip number of the uniform meridian strip
ELEVATION   4    C   Ground elevation over the sea level 
ADM_1_CODE  6    C   ID for the 1st administr. unit (e.g. country / state)
ADM_1_NAME 40    C   Name of the 1st administr. unit (e.g. country / state)
ADM_2_CODE  6    C   ID for the 2nd adm. unit (e.g. federal state, province)
ADM_2_NAME 40    C   Name for the 2nd adm. unit (e.g. fed. state, province)
ADM_3_CODE  6    C   ID for the 3rd admin. unit (e.g. county / district)
ADM_3_NAME 40    C   Name of the 3rd admin. unit (e.g. county / district)
ADM_4_CODE  6    C   ID for the 4th admin. unit (e.g. town / municipality)
ADM_4_NAME 40    C   Name of the 4th admin. unit (e.g. town / municipality)
ACT_DATE    4    C   Date of the last data record update


Data field RECORD_ID
--------------------

Unique ID for a place (town / municipality) within the country table. In 
tables, which cover several countries, the town (RECORD_ID) and the country 
(ISO?_CODE) must be combined to a unique identifier.


Data field CONT_CODE
--------------------

Unique ID for the continent of the country. In tables, which cover several 
countries of different continents, the town (RECORD_ID), the country 
(ISO?_CODE) and the continent (CONT_CODE) must be combined to a unique 
identifier.


Data field ISO3_CODE
--------------------

Unique ID for the country / the state, on whose territory the data in the 
file are contained.  The ID corresponds to the international country code 
in ISO 3166 ALPHA-3 standard.


Data field ISO2_CODE
--------------------

Unique ID for the country / the state, on whose territory the data in the 
file are contained.  The ID corresponds to the international country code 
in ISO 3166 ALPHA-2 standard.


Data field POST_CODE
--------------------

Postal code / Zip code in the notation of the respective country.


Data field TOWN
---------------

Designation of the place. The place name is the name of a town / city or a 
municipality.


Data field QUARTER
------------------

Designation of a local part. An inside the place located town quarter, 
local part, local area, a community or a living place is designated.


Data field MUNIC_CODE
---------------------

Administrative ID, which permits a unique allocation of the place in the 
hierarchical administrative structure in the respective country. In Germany 
is e.g. the eight-digit municipality key. Not for each country an 
administrative ID is present.


Data field LON_DEC
------------------

Geographic longitude in degree notation. The geographical coordinates with 
the suffix "_DEC" are represented in the decimal notation. The integer 
degrees of the coordinate are placed before the comma. The minute and 
second portion of the coordinate are converted into a decimal fraction of a 
degree and are placed behind the comma. Please read the section "Coordinate 
and Reference Systems" for resuming information.
  Digits 1 to 4: Degree of the geographic longitude inclusive sign
  Digits 5 to 10: Decimal fraction of a degree


Data field LAT_DEC
------------------

Geographic latitude in degree notation. The notation is described at the 
data field LON_DEC. Please read the section "Coordinate and Reference 
Systems" for resuming information.
  Digits 1 to 3: Degree of the geographic latitude inclusive sign
  Digits 4 to 9: Decimal fraction of a degree


Data field LON_GEO
------------------

Geographic longitude in degree/minute/second notation. The geographical 
coordinates with the suffix "_GEO" are represented in the DMS notation. 
Four digits are available before the comma for the degrees inclusive signs, 
two digits for the minutes and two digits for the seconds. The decimal part 
of one second is placed behind the comma. Please read the section 
"Coordinate and Reference Systems" for resuming information.
  Digits 1 to 4: Degree portion of the geographic longitude inclusive sign.
  Digits 5 and 6: Minute portion of the geographic longitude
  Digits 7 and 8: Second portion of the geographic longitude
  Digits 9 and 10: Decimal fraction of a second


Data field LAT_GEO
------------------

Geographic latitude in degree/minute/second notation. The notation is 
described at the data field LON_GEO. Please read the section "Coordinate 
and Reference Systems" for resuming information.
  Digits 1 to 3: Degree portion of the geographic latitude inclusive sign.
  Digits 4 and 5: Minute portion of the geographic latitude
  Digits 6 and 7: Second portion of the geographic latitude
  Digits 8 and 9: Decimal fraction of a second


Data field UTM_E_NAT
--------------------

UTM easting of the natural meridian strip. Please read the section 
"Coordinate and Reference Systems" for resuming information.
  Digits 1 and 2: UTM meridian strip number of the natural meridian 
  Digits 3 to 8:  UTM easting in meters on the meridian strip


Data field UTM_N_NAT
--------------------

UTM northing of the natural meridian strip. Please read the section 
"Coordinate and Reference Systems" for resuming information.
  Digit 1:        Sign for coordinates of the southern hemisphere
  Digits 2 to 8:  UTM northing in meters


Data field UTM_E_CENT
---------------------

UTM easting of an uniform meridian strip. Please read the section 
"Coordinate and Reference Systems" for resuming information.
  Digits 1 and 2: UTM meridian strip number of the uniform meridian
  Digits 3 to 8:  UTM easting in meters on the meridian strip


Data field UTM_E_CENT
---------------------

UTM northing of an uniform meridian strip. Please read the section 
"Coordinate and Reference Systems" for resuming information.
  Digit 1:        Sign for coordinates of the southern hemisphere
  Digits 2 to 8:  UTM northing in meters


Data field UTM_STRIP
--------------------

Strip number of the uniform UTM coordinates of the data fields UTM_E_CENT 
and UTM_N_CENT.
  Digits 1 to 2:  UTM strip number of the uniform meridian


Data field ELEVATION
--------------------

Ground elevation over the sea level

The ground elevations were interpolated from the digital elevation model 
"3 Seconds Digital Elevation Data" of the "Shuttle Radar Topography Mission" 
(SRTM) provided by the NASA. The elevation model is present in a raster of 
3 arc seconds. That corresponds to a resolution of maximal 90 meters in 
equator proximity. In direction to the poles the resolution is increasing. 
The accuracy is still increased by interpolation of the neighbouring 
elevation points. 

The elevation data are not measured NN altitudes, but rather "ground 
elevation over the sea level", which was determined by satellite 
observation. On results of newer studies the elevation deviate depending on 
building development and afforestation up to maximally 6 meters from the 
real measured NN altitudes.

  Digits 1 bis 4:  Ground elevation in meter
                   0000: Zero meters or water coverage 
                   9999: unknown


Data field ADM_1_CODE
---------------------

ID for the administrative unit standing most highly in the hierarchical 
structure of the country (e.g. country / state)


Data field ADM_1_NAME
---------------------

Name of the administrative unit standing most highly in the hierarchical 
structure of the country (e.g. country / state)


Data field ADM_2_CODE
---------------------

ID for the administrative unit standing at 2nd place in the hierarchical 
structure of the country (e.g federal state, province)


Data field ADM_2_NAME
---------------------

Name of the administrative unit standing at 2nd place in the hierarchical 
structure of the country (e.g federal state, province)


Data field ADM_3_CODE
---------------------

ID for the administrative unit standing at 3rd place in the hierarchical 
structure of the country (e.g. county / district)


Data field ADM_3_NAME
---------------------

Name of the administrative unit standing at 3rd place in the hierarchical 
structure of the country (e.g. county / district)


Data field ADM_4_CODE
---------------------

ID for the administrative unit standing at 4th place in the hierarchical 
structure of the country (e.g. town / municipality)


Data field ADM_4_NAME
---------------------

Name of the administrative unit standing at 4th place in the hierarchical 
structure of the country (e.g. town / municipality)


Data field ACT_DATE
-------------------

Date of the last data record update.

  Digits 1 and 2: Year of the last data record update
  Digits 3 and 4: Month of the last data record update

KilletSoft News In order that you always are well informed about our company, we write actual news, current information and special offers here into this column.

KilletSoft Logo Order processing while annual closing
 
 In the time between January 5. and January 13. we are unreachable for our customers, because we have holiday season. All incoming orders during this time will be delivered on Wednesday, January 14.

KilletSoft Logo Free update by purchasing Geo Data German Admin
 
 Geo Data German Admin are updated every year in March / April. That you do not have a disadvantage, when you acquire the data still before the annual actualization in the year 2009, you get a free update.

KilletSoft Logo GK --> UTM with BeTA2007
 
 The convertion of your geodata from Gauss-Kruger to UTM with BeTA2007 - Its so easy!
Read the Worksheet and the Press Release ....

KilletSoft Logo Spatial data updates
 
 The contract between a data distributor and GeoKontor was terminated in June 2008. With immediate effect, KilletSoft has been commissioned to organize an update service for the spatial data ("geodata") acquired by them in the years 2006 to 2008 at the level of Zip code (post code), streets and individual buildings. Please contact us if you require an update of such data.

KilletSoft Logo Administrative Reform in Saxonia
 
 The administrative data bases of the Federal Republic of Germany "Geo Data German Admin" were updated to the reference date of August 1st, 2008! Thus the changes due to the administrative reform in Saxonia are included in all data bases.
 
 Read our Press Release ...

KilletSoft Logo Snow and Wind Load Zones of the towns and cities in a newly-created data base
 
 Read our Press Release ...

KilletSoft Logo Nature Area Classification
 
 The product "GeoData German Admin" has been enhanced with two new data tables containing the "Nature Area Classification" and the Landscapes. This will allow associating nature area and landscape information to all localities.
 
 Read our Press Release ...

KilletSoft Logo GeoDLL supports 3D coordinate- transformations
 
 After our Dynamic Link Library has become super fast by recoding to C++, GeoDLL now is able to calculate 3D coordinate transformations considering the ellipsoidical heights. As well calculations with cartesian coordinates are possible now.