• Geo Data International Streets
•  Brief Description and Current News
•  Data Description
•  Data Specification
•  Screenshots
•  Download Geo Data International Streets test data
•  Download Data Converter CONVERT
•  Prices Geo Data International Streets
•  Order Geo Data International Streets

International Geo Data with coordinates on street level for navigation and geo coding.

Data base tables "Geo Data International 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 exact positions in the form of 
coordinates. By Geo Coding streets or street sections become 
cartographically representable. 


Geo data with street coordinates of many countries 
--------------------------------------------------

For many countries street coordinates are present with coverage degrees 
upto 100 percent. The approximate data scopes and the coverage degrees of 
the street coordinates of some countries are specified here. 

StANDORRA   Andorra, 590 streets, coverage 100%
StAUSTRIA   Austria, 143,000 streets, coverage 100%
StBELGIUM   Belgium, 178,000 streets, coverage 100%
StCZECH     Czech Rep., 70,000 streets, coverage 100%
StDENMARK   Denmark, 131,000 streets, coverage 100%
StFINLAND   Finland, 251,000 streets, coverage 100%
StFRANCE    France, 1,630,000 streets, coverage 100%
StGERMANY   Germany, 1,380,000 streets, coverage 100%
StGIBRALT   Gibraltar, 100 streets, coverage 100%
StGR_BRIT   Great Brit., 823,000 streets, coverage 100%
StGREECE    Greece, 47,000 streets, coverage 54%
StIRELAND   Ireland, 35,000 streets, coverage 100%
StITALY     Italy, 903,000 streets, coverage 100%
StLIECHTEN  Liechtenst., 990 streets, coverage 100%
StLUXEMB    Luxembourg, 9,100 streets, coverage 100%
StMONACO    Monaco, 180 streets, coverage 100%
StNETHERL   Netherlands, 266,000 streets, coverage 100%
StNORWAY    Norway, 71,000 streets, coverage 100%
StPOLAND    Poland, 93,000 streets, coverage 70%
StPORTUGAL  Portugal, 131,000 streets, coverage 100%
StS_MARINO  San Marino, 1,000 streets, coverage 100%
StSLOVAKIA  Slovakia, 8,500 streets, coverage 39%
StSPAIN     Spain, 706,000 streets, coverage 100%
StSWEDEN    Sweden, 179,000 streets, coverage 100%
StSWITZERL  Switzerland, 156,000 streets, coverage 100%
StVATICAN   Vatican, 19 streets, coverage 100%


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

The geo data offered here are in high-precision 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 and as 
UTM coordinates.

UTM coordinates are globally present in 60 meridian strips with a width of 
6 degree each. In order to be able to accomplish country-wide distance 
calculations between the coordinates, the UTM 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 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 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 UTM 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 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.

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

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
ISO2_CODE   2    C   Unique ID of the country (ISO 3166 ALPHA-2)
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   6    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    10    N   Geographic longitude in degree notation (WGS84)
LAT_DEC     9    N   Geographic latitude in degree notation (WGS84)
LON_GEO    10    N   Geographic longitude in degree/minute/second notation 
                     (WGS84)
LAT_GEO     9    N   Geographic latitude in degree/minute/second notation 
                     (WGS84)
UTM_E_NAT   8    N   UTM easting (ETRS89) on the natural meridian strip
UTM_N_NAT   8    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  8    N   UTM northing (ETRS89) on an uniform meridian strip
UTM_STRIP   2    N   UTM strip number of the uniform meridian strip


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

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


Data field 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
---------------------

Country dependend Administration ID (municipality key).


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. 

  Digit 1:         Sign for coordinates to the west of Greenwich
  Digits 2 to 10:  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.

  Digit 1:         Sign for coordinates of the southern hemisphere
  Digits 2 to 9:   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.

  Digit 1:         Sign for coordinates to the west of Greenwich
  Digits 2 to 4:   Degree portion of the geographic longitude
  Digits 5 and 6:  Minute portion of the geographic longitude
  Digits 7 and 8:  Second portion of the geographic longitude
  Digits 9 and 10: Decimal fraction of a second


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

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

See information of the data field LON_GEO.

  Digit 1:         Sign for coordinates of the southern hemisphere
  Digits 2 and 3:  Degree portion of the geographic latitude
  Digits 4 and 5:  Minute portion of the geographic latitude
  Digits 6 and 7:  Second portion of the geographic latitude
  Digits 8 and 9:  Decimal fraction of a second


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

UTM easting (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.

  Digit 1:         Sign for coordinates of the southern hemisphere
  Digits 2 to 8:   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.

  Digit 1:         Sign for coordinates of the southern hemisphere
  Digits 2 to 8:   UTM northing in meters


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

Strip number of the uniform UTM coordinates of the data fields UTM_E_CENT 
and UTM_N_CENT.

  Digits 1 to 2:   UTM strip number of the uniform meridian