• 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.

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.

Street-exact geo data are on the one hand less expensive than the high resolution building-exact geo data, on the other hand they are more exact than the economically priced administrative geo data.

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 administrative or postal unit a street belongs to.

The coordinates of the streets are present as geographic coordinates and UTM 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 International Streets", which can represent the location of Killet Software Ing.-GbR:  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.

Table of contents of this site

•  Geo data with street coordinates of many Countries
•  Data fields of a street coordinate table
•  Quality of the street-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 converter

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.

StAUSTRIA   Austria, 123,000 streets, coverage 100%
StBELGIUM   Belgium, 192,000 streets, coverage 100%
StBULGARIA  Bulgaria, 54,000 streets, coverage 24%
StCZECH     Czech Rep., 323,000 streets, coverage 100%
StDENMARK   Denmark, 170,000 streets, coverage 100%
StFINLAND   Finland, 884,000 streets, coverage 100%
StFRANCE    France, 1,810,000 streets, coverage 100%
StGERMANY   Germany, 1,540,000 streets, coverage 100%
StGR_BRIT   Great Brit., 651,000 streets, coverage 100%
StGREECE    Greece, 435,000 streets, coverage 75%
StHUNGARY   Hungary, 262,000 streets, coverage 100%
StITALY     Italy, 1,100,000 streets, coverage 100%
StNETHERL   Netherlands, 196,000 streets, coverage 100%
StNORWAY    Norway, 315,000 streets, coverage 100%
StPOLAND    Poland, 211,000 streets, coverage 100%
StPORTUGAL  Portugal, 157,000 streets, coverage 99%
StROMANIA   Romania, 240,000 streets, coverage 10%
StSPAIN     Spain, 437,000 streets, coverage 100%
StSWEDEN    Sweden, 373,000 streets, coverage 100%
StSWITZERL  Switzerland, 182,000 streets, coverage 100%

The  free test data, downloadable from the Internet, contain only a small representative excerpt from the original tables. The test data may be used for test purposes only. A commercial use of this data is not permitted.

 To the table of contents of this site

Data fields of a house coordinate table

These data fields are contained in the data tables:

1. Unique ID of the country (ISO 3166 ALPHA-3)
2. Unique ID for the Language used in the data record
3. Designation of the street / street section
4. Begin of the street number range of the street / street section
5. End of the street number range of the street / street section
6. Postal zip code
7. Designation of the town / city
8. Designation of the town quarter
9. Administration ID (municipality key)
10. Name of the 1st administr. unit (e.g. federal state)
11. Name for the 2nd adm. unit (e.g. province)
12. Name of the 3rd admin. unit (e.g. county / district)
13. Geographic longitude in degree notation (WGS84)
14. Geographic latitude in degree notation (WGS84)
15. Geographic longitude in degree/minute/second notation (WGS84)
16. Geographic latitude in degree/minute/second notation (WGS84)
17. UTM easting (ETRS89) on the natural meridian strip
18. UTM northing (ETRS89) on the natural meridian strip
19. UTM easting (ETRS89) on an uniform meridian strip
20. UTM northing (ETRS89) on an uniform meridian strip
21. UTM strip number of the uniform meridian strip

 To the table of contents of this site

Quality of the street-exact Geo data

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 street-exact geo data are used in many mobile navigation systems. The accuracy refers to streets or street sections. The street coordinate is always on the middle of the road.

Detailed information, hints to the use of the geo references and the formulas for distance calculation can be found in the  Data Specification.

 To the table of contents of this site

Use of the coordinates contained in the Geo data tables

The coordinates are present as geographic coordinatesand as UTM 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

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

The conversion of the geographic or UTM coordinates into another coordinate and/or reference system, can be accomplished with the coordinate transformation program  TRANSDAT or as purchase order.

 To the table of contents of this site

Conversion to the necessary data format

As a standard the database tables are present in the file format CSV (Comma Separated Values). The used character set is UTF8. This format is used often and in most cases you can import data directly into your own data system.

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

Acquisition of a license and right of use of the database tables

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:

1. Simple License: The licensed database may be used on up to five workplaces in a branch / office of the licensee.
2. Company License: The licensed database may be used on up to twenty workplaces within a company at several branches / offices of the licensee.
3. Internet License: The licensed database may be used in one Internet presence of the licensee. Thereby the data are merged exclusively into for the Internet users free of charge accessible services.

 To the table of contents of this site

Prices and source of supply

Pricing and ordering information can be found in the  Price list. Order the "Geo Data International Streets" with the electronic  Order Form.

 To the table of contents of this site

Download of the test data and the data converter

A selection of  test data from "Geo Data International Streets" 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.

 To the table of contents of this site