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

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

Data base tables "Geo Data International Houses"
================================================

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

House Coordinates or also called Geo Coded Building Addresses are meaning 
the connection between the postal addresses of buildings or building 
complexes and their accurate positions in the coordinate system. The house 
coordinates are the basis for applications, which are developed to assign 
buildings or building complexes as exact as possible positions in the form 
of coordinates. By Geo Coding buildings or building complexes become 
cartographically representable.


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

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

HoANDORRA   Andorra, 2,900 buildings, coverage 50%
HoAUSTRIA   Austria, 3,050,000 buildings, coverage 100%
HoBELGIUM   Belgium, 4,870,000 buildings, coverage 100%
HoCZECH     Czech Rep., 238,000 buildings, coverage 26%
HoDENMARK   Denmark, 2,300,000 buildings, coverage 100%
HoFINLAND   Finland, 6,610,000 buildings, coverage 99%
HoFRANCE    France, 34,300,000 buildings, coverage 80%
HoGERMANY   Germany, 19,000,000 buildings, coverage 100%
HoGR_BRIT   Great Brit., 18,900,000 buildings, coverage 100%
HoGREECE    Greece, 603,000 buildings, coverage 30%
HoIRELAND   Ireland, 663,000 buildings, coverage 70%
HoITALY     Italy, 15,200,000 buildings, coverage 86%
HoLIECHTEN  Liechtenst., 37,000 buildings, coverage 100%
HoLUXEMB    Luxembourg, 149,000 buildings, coverage 100%
HoNETHERL   Netherlands, 8,160,000 buildings, coverage 100%
HoNORWAY    Norway, 1,100,000 buildings, coverage 100%
HoPOLAND    Poland, 1,510,000 buildings, coverage 47%
HoPORTUGAL  Portugal, 2,930,000 buildings, coverage 67%
HoSLOVAKIA  Slovakia, 52,000 buildings, coverage 39%
HoSPAIN     Spain, 8,600,000 buildings, coverage 91%
HoSWEDEN    Sweden, 1,260,000 buildings, coverage 67%
HoSWITZERL  Switzerland, 2,360,000 buildings, coverage 99%


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 house-exact geo data are used in many 
mobile navigation systems. 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.


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 (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
ISO2_CODE   2    C   Unique ID of the country (ISO 3166 ALPHA-2)
STREET     40    C   Designation of the road
STR_NO      4    N   House number of a building or building complex
STR_RANGE   4    N   End number of a house number block (usual in Finland)
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 / road, where the building / building complex is 
placed. If in a town / municipality several times the same road 
designation occurs, the streets are differentiated with the entries in the 
fields POST_CODE and QUARTER.


Data field STR_NO
-----------------

House number of a building or building complex.


Data field STR_RANGE
--------------------

End number of a house number block. In some countries, e.g. Finland, house 
number blocks are usual.


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

Postal Zip Code of the postal area, in which the building / building 
complex is placed. If in a town a street designation is several times 
present, the address is differentiated with the entries in the fields 
POST_CODE and QUARTER.


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

Designation of the town / municipality in which the building / building 
complex is located.


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

Designation of a town / municipality quarter in which the building / 
building complex is located. If the data field contains the designation 
"Center", the building is in the main quarter of the town. If in a town a 
street designation is several times present, the address is differentiated 
with the entries in the fields POST_CODE and QUARTER.


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

Country dependend Administration ID (municipality key).


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

Geographic longitude (WGS84) of the building / building complex 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 Houses", which can represent 
the location of Killet Software Ing.-GbR point-exactly: 
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 building / building complex 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 building / building complex 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 building / building complex 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 building / building complex 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 building / building complex 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 building / building complex 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 building / building complex 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 and 2:  UTM strip number of the uniform meridian