Brief Description and Current News
Data Description
Data Specification Screenshots Download Geo Data German Houses Download Data Converter CONVERT Prices Geo Data German Houses Order Geo Data German HousesHouse Coordinates or also called Geo Coded Building Addresses are meaning the connection between the postal addresses of buildings or building complexes and their positions in the coordinate system. The house coordinates are the basis for applications, which are developed to assign buildings or building complexes positions in the form of coordinates. By Geo Coding buildings or building complexes are cartographically representable.
The possible field of application is very various. E.g. own address lists can be enriched with geo references and visualized on suitable map material. The application scope reaches from information systems and navigation services, geo marketing, telecommunications and UTMS based services up to web applications and tasks of the public utilities, emergency services, security forces and delivery services. Another point of interest can be the establishing relationships between data derived from different hierarchies and levels. For example, it could be desirable to know to which federal state, administrative district and city a building belongs to.
The coordinates of the buildings are present as geographic coordinates, UTM coordinates and Gauss Kruger coordinates.
Geographical coordinates in degree notation are particularly suitable well for searches with Google Earth.
Here is as an example an Internet URL with coordinates from the "Geo Data German Houses", which can represent the location of Killet Software Ing.-GbR point-exactly:
http://maps.google.com/maps?ll=51.397363,6.450883.
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.
Geo data with house coordinates of the Federal States Data fields of a house coordinate table Linking with other database tables Quality of the house-exact Geo data Use of the coordinates contained in the Geo data tables Conversion to the necessary data format Acquisition of a license and right of use of the database tables Prices and source of supply Note to the download of the test data and the data converterFor the area of the Federal Republic of Germany house coordinates with a coverage of 100% are available. The house coordinates are delivered as a standard for the whole Federal Republic of Germany or divided in its Federal States.
HoSWH Schleswig-Holstein ap. 784,000 buildings HoHHA Hamburg ap. 239,000 buildings HoNDS Lower Saxony ap. 2,330,000 buildings HoHBR Bremen ap. 159,000 buildings HoNRW North-Rhine Westphalia ap. 4,260,000 buildings HoHES Hesse ap. 1,410,000 buildings HoRPL Rhineland Palatinate ap. 1,200,000 buildings HoBAW Baden-Wurttemberg ap. 2,760,000 buildings HoBAY Bavaria ap. 3,240,000 buildings HoSAL Saarland ap. 329,000 buildings HoBER Berlin ap. 383,000 buildings HoBRB Brandenburg ap. 698,000 buildings HoMVP Mecklenburg West.-Pomer. ap. 412,000 buildings HoSAC Saxonia ap. 876,000 buildings HoSAN Saxonia-Anhalt ap. 650,000 buildings HoTHU Thuringia ap. 702,000 buildings HoGER Germany (complete) ap. 20,400,000 buildings
The data base tables "Geo Data German Houses" can be licenced economically for the Federal States of Germany or for completely Germany. Other compositions on administrative or postal units are possible. So the house coordinates can be arranged e.g. for a district or for a city / municipality or for a postal area. Please contact us, if you need the geo data in another composition.
The free test data, downloadable from the Internet, contain only a small, randomly selected representative excerpt from the original tables of the Federal States of Germany.
The test data may be used for test purposes only.
A commercial use of that data is not permitted.
To the table of contents of this site
These data fields are contained in the data tables:
To the table of contents of this site
Using the data field MUNIC_CODE, which contains the official municipality key (Kreisgemeindeschlüssel, KGS) of the town / city, you can link the house coordinates to additional town specific data from the database tables of the product "Geo Data German Admin". For example, you can add federal states, provinces, districts, population and area values, car license plates, landscapes, natural areas, topographic map numbers and names and much more.
More detailed information can be found in the data specifications of the product "Geo Data German Admin.
The geo data offered here are in very precise quality and are present in several coordinate and reference systems. The geo data are specifically for your order purchased from the current data release of well-known international manufacturers e.g. such as NAVTEQ, Tele Atlas or INFAS. The geo data then are supplemented, unified and, where appropriate, adapted to your needs by KilletSoft. The geo data therefore are always up to date and are subject to constant quality control by the manufacturer.
The house-exact geo data are used in many mobile navigation systems. They were determined by building-inspection and partially by interpolation of exact street-sections and residential district coordinates. The coordinates are not based on information of the land registry offices or the land surveying authorities. The accuracy refers to individual buildings or building complexes. House number suffixes and house number ranges are not dissolved, since the local proximity of a building complex can be represented regularly by an individual numeric house number.
Detailed information and hints to the use of the geo references can be found in the files of the download or in the detailed Data Specification.
To the table of contents of this site
The coordinates are present as geographic coordinates, as Gauss-Krueger coordinates and as UTM coordinates. 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(GK_E_CENT_1 - GK_E_CENT_2) difNorth = abs(GK_N_CENT_1 - GK_N_CENT_2) distance = sqrt(difEast * difEast + difNorth * difNorth) with GK_E_CENT_1: Easting of the first coordinate GK_N_CENT_1: Northing of the first coordinate GK_E_CENT_2: Easting of the second coordinate GK_N_CENT_2: Northing of the second coordinate abs(): Absolute value function sqrt(): Square root function distance: Distance in meters as result 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 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 (LON_DEC1, LAT_DEC1) and the longitude and latitude of the second point (LON_DEC2, LAT_DEC2) 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
As preparation for the distance computation the longitude and latitude are
converted into radians. The unit of the radian is [rad].
Lon1r = LON_DEC1 * PI / 180
Lat1r = LAT_DEC1 * PI / 180
Lon2r = LON_DEC2 * PI / 180
Lat2r = LAT_DEC2 * PI / 180
with
LON_DEC1: Longitude of the first point in degree notation
LAT_DEC1: Latitude of the first point in degree notation
LON_DEC2: Longitude of the second point in degree notation
LAT_DEC2: 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 (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: 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
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 purchase of economical updates on existing licenses is possible at any time.
The geo data presented here can be used company internal or for free of charge services in the Internet. The data are licensed for different types of use:
To the table of contents of this site
Pricing and ordering information can be found in the Price list.
Order the "Geo Data German Houses" with the electronic Order Form.
To the table of contents of this site
A selection of test data from "Geo Data German Houses" 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.
Price reduced!
Since February we have a new contract with our data supplier.
The prices for spatial data on street and building levels have been reduced substantially.
The up to 65 percent cheaper prices we pass directly to our customers!
New product BetaDLL
BetaDLL is a programming library with coordinate transformations and NTv2 datum shifts with the German BeTA2007 standard for calling from own applications or the use as C++ source code.
Read the Press Release ...
Free update by purchasing Geo Data German Admin
Geo Data German Admin are updated every year in March / April.
In order that you do not have any disadvantage when you acquire the data now before the annual updating, you get a free update.
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©.
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 ....
UTM coordinates
Display Formats of UTM Coordinates - How to Deal with Them?
Read the Worksheet and the Press Release ....
Snow and Wind Load Zones
The Snow and Wind Load Zones of all German towns and cities are available in a new data base.
Read the Press Release ...
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 the Press Release ...
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.