pur
Killet GeoSoftware 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 Geoinformatics" and "German Geodata". The focal trades of the companies supplied by KilletSoft are consulting engineers, GIS developers, Internet marketing, public utilities, logistics, telecommunications, security and public services.
 •  Print page content  •  link_in Company •  link_in Contact •  link_in Imprint
Deutsch English

Geodata Germany - Databases with current georeferenced urban spatial data

Administrative Map

Geodata Germany is an actual database with the center coordinates of all German towns and municipalities and of districts, postal codes, phone area codes and administrative units. It contains tables with natural areas, landscapes, travel areas, snow and wind loads, solar irradiations, precipitation amounts and more. All data can be assigned to the towns and municipalities using the municipality key. The geodata are georeferenced with elevations and coordinates in the systems UTM/ETRS89, GK/DHDN and Geo/WGS84 and are suitable for geocoding, data enrichment and radius search. The geodata can be provided as Text, CSV, SDF, dBase, SQL files with ASCII, ANSI, UTF8, Unicode character set.

Geodata Germany - Version 28.01 - Last update on 22 January 2024
The latest larger changes link_pdf History of Modifications and Supplements

  1. All tables updated to the data status of 1 January 2024.
  2. New data fields "Sunshine Duration" and "Precipitation Amount" inserted.
  3. Solar irradiances in w/m2 and in kWh/m2a.
  4. Snow load zones ">3" and ">3a" supplemented.
  5. DHDN coordinates in degree notation and Google Plus codes added.
  6. Formerly municipial free areas added and landscapes completed.

German geodata as reference data for your business

xBase table Town Quarters
xBase table with Towns and Town Quarters

xBase table Town Quarters
xBase table Postal Codes
xBase table with Postal Codes

xBase table Postal Codes
CSV table Town Quarters
CSV table with Towns and Town Quarters

CSV table Town Quarters

Already since 1991 KilletSoft provides geodata of the Federal Republic of Germany with georeferenced towns, municipalities, urban districts and other administrative units, postal codes and dialling codes. Each data record is georeferenced using Lon/Lat, UTM and Gauss-Krueger coordinates with ETRS89 and DHDN datum, so the data can easily be displayed on a map or imported into any GIS using provided KML, GPX and Shape files standard geographic formats. Starting in 2005, the database were supplemented by natural areas, landscapes, climatic and touristic information, which can be linked by index to the database tables mentioned above. The data are provided with a consistent structure in established CSV and GIS formats that are easy to import into any software and database management system. Geodata Germany are provided in highest accuracy and topicality and they are subject to continuous quality control.

Geodata Germany - Detailed Data Description
Geodata of the Federal Republic of Germany for geocoding, data enrichment, proximity search, navigation and distance calculation

The locality database contains geodata of Germany with tables of georeferenced towns, municipalities, urban districts and other administrative units, postal codes, dialling codes and nature areas, landscapes and climatic information and also registers of the official topographical cartographies. The database tables contain coordinates and elevation data for navigation and geocoding, perimeter searches and distance calculations, and are suitable for the spatial allocation of ecological and economical information. The information is stored in several database tables that can be linked together by the official municipality key.

Topic selection

  1. link_in More examples for the usage of the database tables
  2. link_in The Town and Municipality Database ORTREF with georeferences and elevations
  3. link_in The Town and Municipality Database ORTGEM without georeferences and elevations
  4. link_in The Town Quarter Database ORTTLREF with georeference and elevationss
  5. link_in The Town Quarter Database ORTTLGEM without georeferences and elevations
  6. link_in The Postal Code Database PLZREF with georeferences and elevations
  7. link_in The Postal Code Database PLZGEM without georeferences and elevations
  8. link_in The dialling code Database VORWREF with georeferences and elevations
  9. link_in The dialling code Database VORWGEM without georeferences and elevations
  10. link_in The Administrative County Database KREIS
  11. link_in The Administrative District Database REGBEZ
  12. link_in The Federal States of Germany Database LAND
  13. link_in The Landscapes Database LANDSCH
  14. link_in The Database with Nature Area Classification NATRAUM
  15. link_in The Database with Snow and Wind Load Zones LASTEN
  16. link_in he database with solar irradiations and weather data SOLAR
  17. link_in The Database with Travel Areas and Urban Specificities REISEGEB
  18. link_in The Database with Map Data in 1:25000 scale (TK25)
  19. link_in The Database with Map Data in 1:50000 scale (TK50)
  20. link_in The Database with Map Data in 1:100000 scale (TK100)
  21. link_in The Database with Map Data in 1:200000 scale (TKÜ200)
  22. link_in Quality of the Geodata
  23. link_in Use of the coordinates contained in the Geodata tables
  24. link_in Uniqueness by record ID - Simplified update
  25. link_in Conversion to the necessary data format
  26. link_in Combination of the towns and urban districts to a common database
  27. link_in Acquisition of a license and right of use of the Geodata tables
  28. link_in Pricing and ordering
  29. link_in Note to the download of the test data and the data converter

More examples for the usage of the database tables

Quite often it is necessary to reference an address field e.g. like town or municipality name, postal code or dialling code, to corresponding geographical data and coordinates - a georeference. The georeference can be used for example to direct a customer to the closest store locations of a retail store chain by doing a proximity search. Or on the basis of the determined georeferences statistics or general maps can be made. Another possibility it to determine distances between the different objects of the database tables with the georeferences contained therein. The georeferences are available as UTM coordinates, Gauss-Krueger-Coordinates, Geographical Coordinates and as Plus Codes 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. Often the knowledge is necessary about affiliations and relationships between data derived from different hierarchies. So it can be determined to which Federal State, governmental area or governmental county a town, a postal code or a dialling code is assigned. Or it can be determined on which topographic map a town or urban district is mapped or in which Federal State a certain town is to find.

It is possible to assign a variety of natural, scenic, climatic and touristic information to each town or municipality. Snow and wind load zones and solar irradiations are available as local climatic data. In conjunction with the ground level heights the snow and wind load zones can be used to calculate static loads for the planning of building constructions. The solar irradiation data can be used to schedule thermal and photovoltaic solar power systems.

The data base also contains registers of the official topographical cartographies TK25, TK50, TK100 and TKÜ200 of the Federal Republic of Germany. Map names and map numbers, corner coordinates and supplemental data of the official topographical maps are included in the registers.

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 link_in Internet URL is presented using the free Google API with the coordinate of KilletSoft's hometown Kempen 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

These possibilities are provided by the database tables which are maintained by KilletSoft. In the following text only a brief description of the data is provided. Detailed data descriptions of all database tables you find in the link_in Data Sheets. A selection of test data you find in the link_in download file.

link_in To the topic selection

The Town and Municipality Database ORTREF with georeferences and elevations

The Town and Municipality database ORTREF contains more then 11.000 data records with georeferenced local data of all autonomous towns, county dependent towns and municipalities of the Federal Republic of Germany. Detailed information, combination possibilities with other data base tables, hints to the use of the georeferences and the formulas for distance computation you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Unique record ID
  2. Town / municipality name
  3. Urban district name of the town / municipality center
  4. Official Town / Municipality Key
  5. Geographical longitude (ETRS89) in degree notation
  6. Geographical latitude (ETRS89) in degree notation
  7. Geographical longitude (ETRS89) in degree/minute/second notation
  8. Geographical latitude (ETRS89) in degree/minute/second notation
  9. Geographical longitude (DHDN) in degree/minute/second notation
  10. Geographical latitude (DHDN) in degree/minute/second notation
  11. Gauss Krueger easting (DHDN)
  12. Gauss Krueger northing (DHDN)
  13. UTM easting (ETRS89)
  14. UTM northing (ETRS89)
  15. Plus Code / Open Location Code
  16. Ground elevation over the sea level
  17. Postal code of the delivery area (significant digits)
  18. Postal code of the post box office (significant digits)
  19. Postal code of the town / municipality administration
  20. Old German postal code
  21. Category of the population
  22. Category of the largeness
  23. Number of the Nature Area Unit
  24. Number of the telephone directory
  25. Number of the topographic map on scale 1:25000
  26. International town / municipality UNLOCODE as ISO-3166
  27. Identifier for the status of the town / municipality
  28. Identifier for the importance of the town / municipality
  29. Month of the last data record update
  30. Flags for the updated data records

link_in To the topic selection

The Town and Municipality Database ORTGEM without georeferences and elevations

The Town and Municipality database ORTGEM contains the same data as the database table ORTREF, but without georeferences. The lower-priced table is suitable for all applications, which do not need georeferences. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Unique record ID
  2. Town / municipality name
  3. Urban district name of the town / municipality center
  4. Official Town / Municipality Key
  5. Postal code of the delivery area (significant digits)
  6. Postal code of the post box office (significant digits)
  7. Postal code of the town / municipality administration
  8. Old German postal code
  9. Category of the population
  10. Category of the largeness
  11. Number of the Nature Area Unit
  12. Number of the telephone directory
  13. Number of the topographic map on scale 1:25000
  14. International town / municipality UNLOCODE as ISO-3166
  15. Identifier for the status of the town / municipality
  16. Identifier for the importance of the town / municipality
  17. Month of the last data record update
  18. Flags for the updated data records

link_in To the topic selection

The Town Quarter Database ORTTLREF with georeferences and elevations

The Town Quarters database ORTTLREF contains approx. 116.000 data records with georeferenced local data of urban districts and town parts, which belong to the towns and municipalities contained in the database ORTREF. Detailed information, combination possibilities with other database tables, hints to the use of the georeferences and the formulas for distance computation you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Unique record ID
  2. Main town name and urban district name
  3. Urban district name
  4. Official Town / Municipality Key
  5. Geographical longitude (ETRS89) in degree notation
  6. Geographical latitude (ETRS89) in degree notation
  7. Geographical longitude (ETRS89) in degree/minute/second notation
  8. Geographical latitude (ETRS89) in degree/minute/second notation
  9. Geographical longitude (DHDN) in degree/minute/second notation
  10. Geographical latitude (DHDN) in degree/minute/second notation
  11. Gauss Krueger easting (DHDN)
  12. Gauss Krueger northing (DHDN)
  13. UTM easting (ETRS89)
  14. UTM northing (ETRS89)
  15. Plus Code / Open Location Code
  16. Ground elevation over the sea level
  17. Most probable postal delivery area zip code of the urban district
  18. Identifier for the status of the urban district
  19. Identifier for the importance of the urban district
  20. Month of the last data record update
  21. Flags for the updated data records

link_in To the topic selection

The Town Quarter Database ORTTLGEM without georeferences and elevations

The Town Quarter database ORTTLGEM contains the same data as the database table ORTTLREF, but without georeferences. The lower-priced table is suitable for all applications, which do not need georeferences. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Unique record ID
  2. Main town name and urban district name
  3. Urban district name
  4. Official Town / Municipality Key
  5. Most probable postal delivery area zip code of the urban district
  6. Identifier for the status of the urban district
  7. Identifier for the importance of the urban district
  8. Month of the last data record update
  9. Flags for the updated data records

link_in To the topic selection

The Postal Code Database PLZREF with georeferences and elevations

The Postal Code database PLZREF contains more then 30.000 data records with georeferenced postal codes of the delivery areas and the post box offices as well as the municipality keys of the suitable towns. Detailed information, combination possibilities with other database tables, hints to the use of the georeferences, hints for the geocoding of postal addresses and the formulas for distance computation you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Postal Code
  2. Logistic designation of the postal code
  3. Official Town / Municipality Key
  4. Geographical longitude (ETRS89) in degree notation
  5. Geographical latitude (ETRS89) in degree notation
  6. Geographical longitude (ETRS89) in degree/minute/second notation
  7. Geographical latitude (ETRS89) in degree/minute/second notation
  8. Geographical longitude (DHDN) in degree/minute/second notation
  9. Geographical latitude (DHDN) in degree/minute/second notation
  10. Gauss Krueger easting (DHDN)
  11. Gauss Krueger northing (DHDN)
  12. UTM easting (ETRS89)
  13. UTM northing (ETRS89)
  14. Plus Code / Open Location Code
  15. Ground elevation over the sea level
  16. Postal code type
  17. Flag "Several postal delivery areas in one town"
  18. Flag "Several towns in one postal delivery area"
  19. Identifier for the importance of the postal code
  20. Month of the last data record update
  21. Flags for the updated data records

link_in To the topic selection

The Postal Code Database PLZREF without georeferences and elevations

The Postal Code database PLZGEM contains the same data as the database table PLZREF, but without georeferences. The lower-priced table is suitable for all applications, which do not need georeferences. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Postal Code
  2. Logistic designation of the postal code
  3. Official Town / Municipality Key
  4. Postal code type
  5. Flag "Several postal delivery areas in one town"
  6. Flag "Several towns in one postal delivery area"
  7. Identifier for the importance of the postal code
  8. Month of the last data record update
  9. Flags for the updated data records

link_in To the topic selection

The Telephone dialling code Database VORWREF with georeferences and elevations

The Telephone dialling code database VORWREF contains more then 19.000 data records with georeferenced dialling codes as well as the municipality keys of the suitable towns. Detailed information, combination possibilities with other database tables, hints to the use of the georeferences, hints for the geocoding of telephone numbers and the formulas for distance computation you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Telephone dialling code
  2. Logistic designation of the telephone dialling code
  3. Official Town / Municipality Key
  4. Geographical longitude (ETRS89) in degree notation
  5. Geographical latitude (ETRS89) in degree notation
  6. Geographical longitude (ETRS89) in degree/minute/second notation
  7. Geographical latitude (ETRS89) in degree/minute/second notation
  8. Geographical longitude (DHDN) in degree/minute/second notation
  9. Geographical latitude (DHDN) in degree/minute/second notation
  10. Gauss Krueger easting (DHDN)
  11. Gauss Krueger northing (DHDN)
  12. UTM easting (ETRS89)
  13. UTM northing (ETRS89)
  14. Plus Code / Open Location Code
  15. Ground elevation over the sea level
  16. Priority of the dialling code
  17. Flag "Several dialling code areas in one town"
  18. Flag "Several towns in one dialling code area"
  19. Month of the last data record update
  20. Flags for the updated data records

link_in To the topic selection

The Telephone dialling code Database VORWGEM without georeferences and elevations

The Telephone dialling code database VORWGEM contains the same data as the database table VORWREF, but without georeferences. The lower-priced table is suitable for all applications, which do not need georeferences. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Telephone dialling code
  2. Logistic designation of the telephone dialling code
  3. Official Town / Municipality Key
  4. Priority of the telephone dialling code
  5. Flag "Several dialling code areas in one town"
  6. Flag "Several towns in one dialling code area"
  7. Month of the last data record update
  8. Flags for the updated data records

link_in To the topic selection

The Administrative County Database KREIS

The Administrative County database KREIS contains the names and Administrative County Keys of approx. 400 counties of the Federal Republic of Germany and county-referred data. The data can be linked by the Administrative County Key with the contents of the other database tables by using their Municipality Keys. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Name of the Administrative County
  2. Administrative County Key
  3. Car license plate code
  4. Month of the last data record update

link_in To the topic selection

The Administrative District Database REGBEZ

The Administrative District database REGBEZ contains the names and Administrative District Keys of all districts of the Federal Republic of Germany. The data can be linked by the Administrative District Key with the contents of the other database tables by using their Municipality Keys. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Name of the Administrative District
  2. Administrative District Key
  3. Month of the last data record update

link_in To the topic selection

The Federal States of Germany Database LAND

The Federal States of Germany database LAND contains the names and Federal State Keys of all states of the Federal Republic of Germany. The data can be linked by the Federal State Key with the contents of the other database tables by using their Municipality Keys. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Name of the Federal State
  2. Federal State Key
  3. Abbreviation for the Federal State
  4. International Federal State UNLOCODE as ISO-3166
  5. Name of the State Surveying Office in short form
  6. Name of the State Surveying Office in long form
  7. Address of the State Surveying Office
  8. Place of the State Surveying Office
  9. Telephone number of the State Surveying Office
  10. Fax number of the State Surveying Office
  11. Month of the last data record update

link_in To the topic selection

The Landscapes Database LANDSCH

The database table contains the landscapes with the different landscape types of the Federal Republic of Germany. With the landscape-key the data can be connected to the contents of other database tables. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Name of the Landscape
  2. Key of the Landscape
  3. Type of the Landscape
  4. Geographical longitude of the center or the Landscape
  5. Geographical latitude of the center or the Landscape
  6. Month of the last data record update

link_in To the topic selection

The Database with the Nature Area Classification NATRAUM

The database table contains the natural area classification of the Federal Republic of Germany in the form of hierarchically structured natural area units. With the nature-area-unit-key the data can be connected to the contents of other database tables. Detailed information and combination possibilities with other data base tables you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Name of the Nature Area Main Unit
  2. Key of the Nature Area Main Unit
  3. Geographical longitude of the Main Unit center
  4. Geographical latitude of the Main Unit center
  5. Name of the Nature Area Superior Unit
  6. Key of the Nature Area Superior Unit
  7. Name of the Nature Area Unit by definition of BfN
  8. Key of the Nature Area Unit by definition of BfN
  9. Name of the Nature Broad Expanse Area
  10. Name of the Nature Biographical Region
  11. Month of the last data record update

link_in To the topic selection

The Database with Snow and Wind Load Zones LASTEN

The database table contains the snow load and wind load zones and the solar irradiation for the areas of the cities and municipalities of the Federal Republic of Germany. In conjunction with the ground level heights contained in the database table the load zones can be used to calculate static loads for building constructions. These data fields are contained in the database table:

  1. Official Town / Municipality Key
  2. Name of the Town / Municipality
  3. Averaged Ground Elevation of the Town / Municipality
  4. Wind Load Zone of a Town / Municipality
  5. Number of a footnote to the Wind Load Zone
  6. Snow Load Zone of a Town / Municipality
  7. Number of a footnote to the Snow Load Zone
  8. Note about a wind load zone or snow load zone
  9. Month of the last data record update
  10. Flags for the updated data records

link_in To the topic selection

The Database with Solar Irradiations and weather data SOLAR

The database table contains the solar irradiations and some weather data for the areas of the cities and municipalities of the Federal Republic of Germany. The solar irradiation data can be used to schedule thermal and photovoltaic solar power systems. These data fields are contained in the database table:

  1. Official Town / Municipality Key
  2. Name of the Town / Municipality
  3. Averaged Ground Elevation of the Town / Municipality
  4. Horizontal Solar Irradiation in a Town / Municipality in kWh/m2a
  5. Angle optimized Solar Irradiation in a Town / Municipality in kWh/m2a
  6. Horizontal Solar Irradiation in a Town / Municipality in W/m2
  7. Angle optimized Solar Irradiation in a Town / Municipality in W/m2
  8. Optimal angle for solar installations in a Town / Municipality
  9. Annual Sunshine Duration in a Town / Municipality
  10. Annual Precipitation Amount in a Town / Municipality
  11. Month of the last data record update
  12. Flags for the updated data records

link_in To the topic selection

The Database with Travel Areas and Urban Specificities REISEGEB

The database table contains the travel areas of the Federal Republic of Germany. As travel areas not administrative spatial units are designated, which are based mainly on the responsibility areas of the regional tourism organizations and on natural spatial conditions. These data fields are contained in the database table:

  1. Key for the Travel Area
  2. Designation of the Travel Area
  3. Geographical longitude of the Travel Area center
  4. Geographical latitude of the Travel Area center
  5. Designation of the urban specificity of the Travel Area
  6. Month of the last data record update

link_in To the topic selection

The Database with Map Data in 1:25000 scale (TK25)

The map register TK25 contains map numbers, map names, corner coordinates and additional information of the official topographic cartography TK25 (ordnance) with a scale 1:25000 of the Federal Republic of Germany. Detailed information, combination possibilities with other database tables and hints to the use of the georeferences you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Map name
  2. Map number
  3. Key of the Federal State which the map belongs to
  4. Official Town / Municipality Key of the most important town on the map
  5. Longitude of the corner coordinate
  6. Latitude of the corner coordinate
  7. UTM Easting of the corner coordinate
  8. UTM Northing of the corner coordinate
  9. Number of the belonging TK50 map
  10. Number of the belonging TK100 map
  11. Number of the belonging TKÜ200 map

link_in To the topic selection

The Database with Map Data in 1:50000 scale (TK50)

The map register TK25 contains map numbers, map names and additional information of the official topographic cartography TK50 with a scale 1:50000 of the Federal Republic of Germany. Detailed information, combination possibilities with other database tables and hints to the use of the georeferences you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Map name
  2. Map number
  3. Key of the Federal State which the map belongs to
  4. Number of the belonging TK100 map
  5. Number of the belonging TKÜ200 map

link_in To the topic selection

The Database with Map Data in 1:100000 scale (TK100)

The map register TK100 contains map numbers, map names and additional information of the official topographic cartography TK100 with a scale 1:100000 of the Federal Republic of Germany. Detailed information, combination possibilities with other database tables and hints to the use of the georeferences you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Map name
  2. Map number
  3. Key of the Federal State which the map belongs to
  4. Number of the belonging TKÜ200 map

link_in To the topic selection

The Database with Map Data in 1:200000 scale (TKÜ200)

The map register TK200 contains map numbers, map names and additional information of the official topographic cartography TKÜ200 with a scale 1:200000 of the Federal Republic of Germany. Detailed information, combination possibilities with other database tables and hints to the use of the georeferences you will find in the download file or in the link_pdf Data Sheet. These data fields are contained in the database table:

  1. Map name
  2. Map number

link_in To the topic selection

Quality of the Geodata

The geodata offered here are in high-precision quality and are present in different Coordinate and Reference Systems. They are constantly updated and they are subject of a constant quality control. Nevertheless, it is possible that with such large amounts of data deviations of the data contents from reality can occur to a small extent. We have to emphasize expressly that deviations or errors of less than one percent of the data volume of a database cannot be faulted. Should you even notice such deviations, we will endeavor to correct them promptly.

link_in To the topic selection

Use of the coordinates contained in the Geodata tables

The coordinates are present as geographic coordinates, as Gauss-Krueger coordinates of the 3rd meridian strip and as UTM coordinates on the 32th meridian strip. Because UTM coordinates and Gauss-Krueger coordinates are converted 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.

Formula for the distance calculation with Gauss-Krueger coordinates:
difEast   = abs(GKRECHTS1 - GKRECHTS2)
difNorth  = abs(GKHOCH1 - GKHOCH2)
l         = sqrt(difEast * difEast + difNorth * difNorth)
with
GKRECHTS1:  Easting of the first coordinate
GKHOCH1:    Northing of the first coordinate
GKRECHTS2:  Easting of the second coordinate
GKHOCH2:    Northing of the second coordinate
abs():      Absolute value function
sqrt():     Square root function
l:          Distance in meters as result.

Formula for the distance calculation with UTM coordinates:
difEast   = abs(UTMRECHTS1 - UTMRECHTS2)
difNorth  = abs(UTMHOCH1 - UTMHOCH2)
l         = sqrt(difEast * difEast + difNorth * difNorth)
with
UTMRECHTS1: Easting of the first coordinate
UTMHOCH1:   Northing of the first coordinate
UTMRECHTS2: Easting of the second coordinate
UTMHOCH2:   Northing of the second coordinate
abs():      Absolute value function
sqrt():     Square root function
l:          Distance in meters as result.

Geographic coordinates are indicated in longitude and latitude. Usually longitude and latitude are represented in the degree notation, which is also called decimal notation. Geographical coordinates in the degree notation are for the distance computation better suitable than geographical coordinates in the degrees/minutes/second notation. For a distance computation the longitude and latitude of the first point (LAENGE_D1, BREITE_D1) and the longitude and latitude of the second point (LAENGE_D2, BREITE_D2) 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. In the Federal Republic of Germany no minus signs occur, because all coordinates are on the northern earth hemisphere and east of Greenwich.

As preparation for the distance computation the longitude and latitude are
converted into radians. The unit of the radian is [rad].
Lon1r     = LAENGE_D1 * PI / 180
Lat1r     = BREITE_D1 * PI / 180
Lon1r     = LAENGE_D2 * PI / 180
Lat1r     = BREITE_D2 * PI / 180
  with
LAENGE_D1:  Longitude of the first point in degree notation
BREITE_D1:  Latitude of the first point in degree notation
LAENGE_D2:  Longitude of the second point in degree notation
BREITE_D2:  Latitude of the second point in degree notation
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.
l        =  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
l:          Distance in meters as result

The conversion of the geographic, Gauss-Krueger and UTM coordinates into another coordinate and/or Reference System, can be accomplished with the Coordinate Transformation program link_in TRANSDATpro or as purchase order. Like that it is possible to convert e.g. into the Lambert Coordinate System or to Soldner coordinates and into the usual Reference Systems.

link_in To the topic selection

Uniqueness by record ID - Simplified update

Wir haben für jeden Datensatz in den Orts-Datenbanken ORTGEM / ORTREF und in den Ortsteil-Datenbanken ORTTLGEM / ORTTLREF eindeutige Datensatz-IDs generiert. Das hat den Vorteil, dass aktualisierte Daten bei einem Update ohne großen Aufwand in den eigenen Datenbestand eingepflegt werden können. Eine Datensatz-ID ist eindeutig (unique) und bleibt auch bei Änderung der Ortsbezeichnung oder Ortsteilbezeichnung oder nach Änderung sonstiger Datenfelder während der ganzen Lebensdauer des Datensatzes erhalten.

Führen Sie beim erstmaligen Einpflegen von KilletSoft-Daten die eindeutigen Datensatz-IDs in Ihren eigenen Datenbeständen mit. Beim späteren Einpflegen eines Updates überführen Sie die aktualisierten KilletSoft-Datenfelder ganz einfach anhand der eindeutigen Datensatz-IDs und des im Datensatz enthaltenen Änderungdatums in Ihren eigenen Datenbestand. Überlegen Sie sich eine Strategie für neu hinzugekommene oder ungültig gewordene Datensätze, die Sie durch fehlende oder neue Datensatz-IDs im Update lokalisieren können.

link_in To the topic selection

Conversion to the necessary data format

As a standard the database tables are present in the file format CSV (Comma Separated Values). The used character set is ANSI. This format is used often and in most cases you can import the data directly into your own system. For example, you can process the data directly in MS-ACCESS or MS-EXCEL without further editing.

The link_in downloadable freeware program CONVERT converts the available database tables into other data formats and character sets with the necessary sortings and selections. With the program for example CSV data can be converted into the SDF format (Simple Document Format) or into 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 link_in screenshots of the converter program.

link_in To the topic selection

Combination of the towns and urban districts to a common database

If both database tables ORTREF and ORTTLREF or ORTGEM and ORTTLGEM were acquired, they can be joined to a common database table and sorted again by assistance of the freeware program CONVERT (download see below). In the database table then all towns / municipalities and urban districts are arranged among each other and sorted on the municipality key.

link_in To the topic selection

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

The link_in 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 data of the presented database tables can be used by computer programs and Internet sites (applications) and made available to customers within the scope of the application. The database tables are licensed for different types of use:

  1. A Single License for a database table entitles the licensee to use the database in a single application of the licensee. The licensee's application may be distributed to any number of customers or operated as one single Internet application. The database table must be accessed from a computer or server of the licensee or his internet provider.
  2. A General License for a database table entitles the licensee to use the database in any number of applications of the licensee. The licensee's applications may be distributed to any number of customers or operated as several Internet applications. The database table must be accessed from one or more computers or servers of the licensee or his internet provider.
  3. For both license types applies: Only programmatically requested excerpts from the database table may be made available to the customers of the licensee. The delivery of the database table directly to customers of the licensee is prohibited.

link_in 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 link_in Price list. Order the "Geodata Germany" with the electronic link_in Order Form.

link_in To the topic selection

Note to the download of the test data and the data converter

A selection of link_in test data of all database tables presented here 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 link_in CONVERT, developed by KilletSoft, for converting and adaptation of the data is ready for download if necessary.

link_in To the topic selection

KilletSoft News In order that you are always well informed about our company, we write actual news, current information and special offers here into this column.
pur
KilletSoft Logo Geodata Germany
All georeferenced databases has been updated to the data conditions of January 1st, 2024. The database tables of "GeoData Germany" contain all German towns, municipalities and urban districts, coordinates, postal codes, dialling codes, administrative units, nature areas, landscapes, travel areas, wind and snow loads, solar irradiation, cartographies info etc.
link_in Read more...
KilletSoft Logo New work sheet
Modeling an NTv2 file under the aspect of economic efficiency.
link_in Read the work sheet...
KilletSoft Logo New work sheet
Display Formats of UTM Coordinates.
Display formats, calculation methods and the historical background of the UTM coordinate system.
Third revised edition of the popular technical article.
link_in Read the work sheet...
KilletSoft Logo New work sheet
What actually is a Coordinate Reference System?
Explanation of the Coordinate Reference System with the components Coordinate System, Reference System, Reference Definition and Reference Frame.
Second revised edition.
link_in Read the work sheet...
KilletSoft Logo Illegal software versions
The illegal use of our software got out of control!
link_in Read our Info...
KilletSoft Logo NTv2 collection
KilletSoft has brought together NTv2 files as a worldwide collection on a central website and linked for the direct download.
link_in Read the Press Release...
link_in To the NTv2 collection...
KilletSoft Logo is member of
VDV Logo
KilletSoft Logo Translators wanted!
The programs TRANSDAT, SEVENPAR, NTv2Creator, NTv2Poly and NTv2Tools support language files for the programs interface. Since the language dependent texts are managed in external files, link_in new languages can be added at any time by creating new language files. Everybody who is interested can translate a new language file into his native language for himself and all users.
Author: Dipl.-Ing. Fred Killet
Page name: p_dgda_e.htm
Page views: 2075
Period: since Januar 1, 2024