Quite often it is necessary to reference an address field e.g. like town or municipality name, postal code or telephone preselection, to corresponding geographical data and coordinates - a Geo Reference. 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 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. 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 telephone preselection is associated. Or it can be determined on which topographic map a town or town quarter is mapped or in which Federal State a certain town is to find.
It is possible to assign a variety of natural and scenic information to each town or municipality. The snow and wind load zones are available as local climatic data. In conjunction with the ground level heights they can be used to calculate static loads for the planning of building constuctions.
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 suitable well for searches with Google Earth.
Here is an Internet URL as an example with coordinates, which can represent a map or an aerial view of KilletSoft's hometown Kempen:
http://maps.google.com/maps?ll=51.36330,06.41862.
The first value behind the identifier "ll" (lat / lon) is the geographical latitude, then the geographical longitude follows.
The shown URL can be inserted directly into the address field of the browser to represent a map cutout on the screen.
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 Data Specifications.
A selection of test data you find in the download file.
The Town and Municipality Database ORTREF with georeferences The Town and Municipality Database ORTGEM without georeferences The Town Quarter Database ORTTLREF with georeferences The Town Quarter Database ORTTLGEM without georeferences The Postal Code Database PLZREF with georeferences The Postal Code Database PLZGEM without georeferences The Telephone Preselection Database VORWREF with georeferences The Telephone Preselection Database VORWGEM without georeferences The Administrative County Database KREIS The Administrative District Database REGBEZ The Federal States of Germany Database LAND The Landscapes Database LANDSCH The Database with the Nature Area Classification NATRAUM The Database with the Snow and Wind Load Zones LASTEN The Database with Map Data in 1:25000 scale (TK25) The Database with Map Data in 1:50000 scale (TK50) The Database with Map Data in 1:100000 scale (TK100) The Database with Map Data in 1:200000 scale (TKÜ200) Quality of the Geodata Use of the coordinates contained in the Geodata tables Conversion to the necessary data format Combination of the towns and town quarters to a common database Acquisition of a license and right of use of the Geodata tables Pricing and ordering Note to the download of the test data and the data converter
The Town and Municipality database ORTREF contains approx. 12.500 data records with georeferenced local data of all autonomous towns, county dependend 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 
Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
The Town Quarters database ORTTLREF contains approx. 108.000 data records with georeferenced local data of town quarters 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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
The Postal Code database PLZREF contains approx. 32.500 data records with georeferenced postal codes of the 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 geo coding of postal addresses and the formulas for distance computation you will find in the download file or in the Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
The Telephone Preselection database VORWREF contains approx. 20.500 data records with georeferenced telephone preselection 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 geo coding of telephone numbers and the formulas for distance computation you will find in the download file or in the Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
The Telephone Preselection 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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
The Administrative County database KREIS contains the names and Administrative County Keys of the approx. 450 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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
The database table contains the snow load and wind load zones 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 constuctions. These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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 Data Specification.
These data fields are contained in the database table:
To the table of contents of this site
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. Detailed information and hints to the use of the georeferences can be found in the files of the download or in the detailed Data Specifications of the data tables.
To the table of contents of this site
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.
Print page body
Data Description
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 TRANSDAT 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.
To the table of contents of this site
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 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 screenshots of the converter program.
To the table of contents of this site
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 town quarters are arranged among each other and sorted on the municipality key.
To the table of contents of this site
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:
To the table of contents of this site
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 Germany" with the electronic Order Form.
To the table of contents of this site
A selection of test data of all database tables presented here with the detailed data description and with informations 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.
For unpacking the download files you need an unzip program, which you can download from this side.
In order that you always are well informed about our company, we write actual news, current information and special offers here into this column.
NTv2 calculations
KilletSoft provides for their produkts GEoDLL and TRANSDAT encrypted NTv2 files of the Federal States Hesse, Saxony and Thuringia for highly accurate calculations.
Read more ...
Administrative Reform in Mecklenburg-Western Pomerania
The administrative data bases of the Federal Republic of Germany "Geodata Germany" have been updated to the reference date of September 15th, 2011!
The reason therfor are the essential modifications due to the Administrative Reform in the Federal State Mecklenburg-Western Pomerania.
Read the Press Release ...
Win32 and X64
The Dynamic Linc Libraies GeoDLL and BetaDLL supports 32bit and 64bit architecture now.
The DLLs are written in C++ and were developed with Microsoft Visual Studio 2010.
Are the reference systems WGS84 and ETRS89 really identical?
Inclusion of the continental drift for the transforming of GPS coordinates with the software products TRANSDAT and GeoDLL.
Read the Press Release ...
Translators wanted!
The latest versions of the programs TRANSDAT and SEVENPAR support language files for the programs interface.
Since the language dependent texts are managed in external files, new languages can be added at any time by creating new language files.
Every user of the program now can compile language files by himself.
WINDOWS© 7 compatible
Our software has received the certificate "WINDOWS© 7 compatible".
So it complies with the compatibility standards of the Microsoft operating systems WINDOWS© 7.
INSPIRE©
GeoDLL and TRANSDAT supports Europe-wide the ETRS89 coordinate systems proposed by INSPIRE©.