Geo Data German Streets (streets with geo references)

Geo data of the Federal Republic of Germany with coordinates on street level for navigation and geo coding.

Data base tables "Geo Data German Streets"
==========================================

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

Street coordinates or also called street section coordinates are meaning the 
summary of several postal house addresses to an averaged position in the 
coordinate system on street or street section basis. The street coordinates 
are to be used with applications, which are developed to assign street 
oriented address groups positions in the form of coordinates. By Geo Coding 
streets or street sections become cartographically representable. 


Geo data with sreet cordinates of the Federal States
----------------------------------------------------
 

For the area of the Federal Republic of Germany street coordinates with a 
coverage of 100% are available. The Street Coordinates are delivered as a 
standard for the whole Federal Republic of Germany or divided in its Federal 
States. The approximate data scopes of the street coordinates of all German 
Federal States are specified here.

StSWH  Schleswig-Holstein                  53,000 streets
StHHA  Hamburg                              9,400 streets
StNDS  Lower Saxony                       175,000 streets
StHBR  Bremen                               5,700 streets
StNRW  North-Rhine Westphalia             234,000 streets
StHES  Hesse                              106,000 streets
StRPL  Rhineland Palatinate                82,000 streets
StBAW  Baden-Wurttemberg                  194,000 streets
StBAY  Bavaria                            271,000 streets
StSAL  Saarland                            17,000 streets
StBER  Berlin                              13,000 streets
StBRB  Brandenburg                         45,000 streets
StMVP  Mecklenburg West.-Pomerania         28,000 streets
StSAC  Saxonia                             62,000 streets
StSAN  Saxonia-Anhalt                      40,000 streets
StTHU  Thuringia                           39,000 streets
StGER  Germany (entire country)         1,380,000 streets


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

The geo data offered here are in high quality and are present in different 
coordinate and reference systems. They are constantly updated by an 
internationally active geo data manufacturer and they are subject to a 
continuous quality control. The street-exact geo data are used in many mobile 
navigation systems. 


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

First the data base tables are present in a standard data base format 
(dBase, ASCII / OEM character set). They can be imported directly into 
MS-EXCEL, MS-ACCESS and in Borlands dBase and other programs supporting this 
data base format. 
  
The freeware program CONVERT, downloadable from the site 
http://www.killetsoft.de/p_cona_e.htm, converts dBase formatted data base 
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 data base management system or file system 
will be possible.

For the import in MySQL or SQL data bases 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, as Gauss-Krueger 
coordinates and as UTM coordinates.

UTM coordinates are globally present in 60 meridian strips with a width of 6 
degree each. Gauss-Krueger coordinates are distributed on 120 meridian strips 
with a width of 3 degree each. In order to be able to accomplish country-wide 
distance calculations between the coordinates, the UTM coordinates and the 
Gauss-Krueger coordinates are converted country-wide to a uniform, national 
central meridian strip. 

The geographical coordinates 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 WGS84 named ellipsoid. It is used for navigation with the American 
satellite navigation system GPS (Global Positioning System). 

The Gauss-Krueger coordinates are present in the reference system 
"Potsdam-Datum (PD, DHDN), Bessel". This reference system together with 
Gauss-Krueger coordinates is still in use for the official topographic 
cartography of the FRG. 

The UTM coordinates 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.

Because 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
-------------------------------------------------------------

Because the UTM coordinates and the 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


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

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. 

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


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

Field      Width Typ Description
STREET     40    C   Designation of the street / street section
STR_NO_B    4    N   Begin of the street number range of the street / 
                     street section
STR_NO_E    4    N   End of the street number range of the street / 
                     street section
POST_CODE   5    C   Postal zip code
TOWN       40    C   Designation of the town / city
QUARTER    40    C   Designation of the town quarter (optional)
MUNIC_CODE  8    C   Administration ID (municipality key)
LON_DEC     8    N   Geographic longitude in degree notation (WGS84)
LAT_DEC     8    N   Geographic latitude in degree notation (WGS84)
LON_GEO     8    N   Geographic longitude in degree/minute/second notation 
                     (WGS84)
LAT_GEO     8    N   Geographic latitude in degree/minute/second notation 
                     (WGS84)
GK_E_NAT    7    N   Gauss-Krueger easting (DHDN) on the natural meridian 
                     strip
GK_N_NAT    7    N   Gauss-Krueger northing (DHDN) on the natural meridian 
                     strip
GK_E_CENT   7    N   Gauss-Krueger easting (DHDN) on an uniform meridian 
                     strip
GK_N_CENT   7    N   Gauss-Krueger northing (DHDN) on an uniform meridian 
                     strip
UTM_E_NAT   8    N   UTM easting (ETRS89) on the natural meridian strip
UTM_N_NAT   7    N   UTM northing (ETRS89) on the natural meridian strip
UTM_E_CENT  8    N   UTM easting (ETRS89) on an uniform meridian strip
UTM_N_CENT  7    N   UTM northing (ETRS89) on an uniform meridian strip


Data field STREET
-----------------

Designation of the street / street section. If in a town / municipality 
several times the same road designation occurs, the streets are 
differentiated by the criteria Postal Zip Code and / or town / municipality 
quarter. Long street are splitted into several street sections by the 
criteria Postal Zip Code and / or town / municipality quarter.


Data field STR_NO_B
-------------------

Begin of the street number range of the street / street section. It should 
be noted that a long street is splitted into several street sections by the 
criteria Postal Zip Code and / or town / municipality quarter.


Data field STR_NO_E
-------------------

End of the street number range of the street / street section. It should be 
noted that a long street can be splitted into several street sections by the 
criteria Postal Zip code and / or town / municipality quarter.


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

Postal Zip Code of the postal area, in which the street / street section is 
placed. If in a town a street designation is several times present, the 
address is differentiated by the criteria Postal Zip Code and / or town / 
municipality quarter. A long street is splitted into several street sections 
by the criteria Postal Zip Code and / or town / municipality quarter.


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

Designation of the town / municipality in which the street / street section 
is located. 


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

Designation of a town / municipality quarter in which the street / street 
section is located. If the data field contains the designation "Center", the 
street is in the main quarter of the town. If in a town a street designation 
is several times present, the address is differentiated by the criteria 
Postal Zip Code and / or town / municipality quarter. A long street is 
splitted into several street sections by the criteria Postal Zip Code and / 
or town / municipality quarter.


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

Eight-digit Administration ID (municipality key).

  Digits 1 and 2:  Key for the Federal State
                   01: Schleswig-Holstein
                   02: Hamburg
                   03: Lower Saxony
                   04: Bremen
                   05: North-Rhine Westphalia
                   06: Hesse
                   07: Rhineland-Palatinate
                   08: Baden-Wurttemberg
                   09: Bavaria                        
                   10: Saarland
                   11: Berlin
                   12: Brandenburg
                   13: Mecklenburg-Western Pomerania
                   14: Saxonia
                   15: Saxonia-Anhalt
                   16: Thuringia

  Digit 3:          Key for the Administrative District
                    0: No Administrative District assigned 

  Digits 4 and 5:   Key for the County
                    00: No County assigned 

  Digits 6 to 8:    key for the City or a Municipality
                    000: County independent City


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

Geographic longitude (WGS84) of the street / street section in degree 
notation.

The degree notation is also called the decimal notation. The minute and 
second portion of the coordinate are converted into a decimal fraction of a 
degree and are placed behind the comma. 

As geodetic reference system "WGS84 (worldwide, GPS), geocentric, WGS84" is 
used. Please read the section "Coordinate and Reference Systems" for 
resuming information.

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 International Streets", which can represent 
the location of Killet Software Ing.-GbR: 
http://maps.google.com/maps?t=k&ll=51.397363,6.450883&spn=0.002,0.002
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. 

  Digits 1 to 8:   Geographic longitude in degree


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

Geographic latitude (WGS84) of the street / street section in degree 
notation.

See information of the data field LON_DEC.

  Digits 1 to 8:   Geographic latitude in degree


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

Geographic longitude (WGS84) of the street / street section in 
degree/minute/second notation.

The degree/minute/second notation is also called the DMS notation. The 
degree, minutes and seconds of the geographical longitude and latitude are 
represented as two digits each before the comma. The decimal part of one 
second is placed behind the comma. 

As geodetic reference system the WGS84 datum on the WGS84 ellipsoid is used. 
Please read the section "Coordinate and Reference Systems" for resuming 
information.

  Digits 1 and 2:  Degree portion of the geographic longitude
  Digits 3 and 4:  Minute portion of the geographic longitude
  Digits 5 and 6:  Second portion of the geographic longitude
  Digits 7 and 8:  Decimal fraction of a second


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

Geographic latitude (WGS84) of the street / street section in 
degree/minute/second notation.

See information of the data field LON_GEO.

  Digits 1 and 2:  Degree portion of the geographic latitude
  Digits 3 and 4:  Minute portion of the geographic latitude
  Digits 5 and 6:  Second portion of the geographic latitude
  Digits 7 and 8:  Decimal fraction of a second


Data field GK_E_NAT
-------------------

Gauss-Krueger easting (DHDN) of the street / street section on the natural 
meridian strip.

Please read the section "Coordinate and Reference Systems" for resuming 
information.

  Digit 1:         Gauss-Krueger meridian strip number of the natural 
                   meridian
  Digits 2 to 7:   Gauss-Krueger easting in meter


Data field GK_N_NAT
-------------------

Gauss-Krueger northing (DHDN) of the street / street section on the natural 
meridian strip.

Please read the section "Coordinate and Reference Systems" for resuming 
information.

  Digits 1 to 7:   Gauss-Krueger northing in meters


Data field GK_E_CENT
--------------------

Gauss-Krueger easting (DHDN) of the street / street section on an uniform 
meridian strip. 

Please read the section "Coordinate and Reference Systems" for resuming 
information.

  Digit 1:         Gauss-Krueger meridian strip number of the uniform 
                   meridian
  Digits 2 to 7:   Gauss-Krueger easting in meters on the meridian strip


Data field GK_N_CENT
--------------------

Gauss-Krueger northing (DHDN) of the street / street section on an uniform 
meridian strip. 

Please read the section "Coordinate and Reference Systems" for resuming 
information.

  Digits 1 to 7:   Gauss-Krueger northing in meters


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

UTM easting (ETRS89) of the street / street section on 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 meter


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

UTM northing (ETRS89) of the street / street section on the natural meridian 
strip.

Please read the section "Coordinate and Reference Systems" for resuming 
information.

  Digits 1 to 7:   UTM northing in meters


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

UTM easting (ETRS89) of the street / street section on 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_N_CENT
---------------------

UTM northing (ETRS89) of the street / street section on an uniform meridian 
strip. 

Please read the section "Coordinate and Reference Systems" for resuming 
information.

  Digits 1 to 7:   UTM northing in meters