Often is it necessarily for an address characteristic, e.g. the place name or the postal zip code, to establish a local relationship - a geo reference.
The geo reference can be used e.g. to show a customer the nearest branches of a business chain by doing a proximity search.
Or on the basis of the determined geo references statistics or general maps can be made.
Distances between places or postal areas can be determined also with the geo references contained in the country database tables.
The geo references are available in all country database tables as UTM coordinates on the natural and an uniformly meridian strip and as geographical coordinates in degree and deg/min/sec notation.
With the elevation data from a Digital Elevation Model the ground level height of each place can be determined.
All these possibilities are offered by the country database tables, which are briefly described in the following text.
An exact data description and information for the use of the database tables and a lot of test data you can find in the 
download file.
Available countries Data fields of the country data tables Quality of the Geo data of the respective countries Use of the coordinates contained in the country data tables Conversion to the necessary data format Acquisition of a license and right of use of the database tables Pricing and ordering Note to the download of the test data and the data converterGeo Data Australasia Australia (10,000) New-Zealand (1,900) Geo Data West Europe Andorra (40) Gibraltar (5) Monaco (3) Austria (10,000) Greece (820) Netherl.-ZIP4 (8,800) Belgium (3,800) Greece (gr) (6,200) Norway (6,900) Cyprus (210) Ireland (1,400) Portugal-ZIP4 (11,000) Denmark (5,200) Isle of Man (220) San Marino (12) Finland (6,200) Italy (38,000) Spain (33,000) France (68,000) Liechtenstein (20) Sweden (13,000) GB-ZIP4 (60,000) Luxembourg (4,200) Switzerland (7,200) Germany (123,000) Malta (64) Vatican (2) Geo Data East Europe Albania (390) Ex-Yugoslavia (1,700) Romania (13,000) Belarus (74) Georgia (19) Russia (1,100) Bosnia/Herc. (870) Hungary (4,300) Russia (ky) (14,000) Bulgaria (180) Latvia (1,300) Serbia (1,500) Bulgaria (ky) (370) Lithuania (3,900) Slovakia (4,600) Croatia (3,800) Macedonia (300) Slovenia (6,100) Czech Rep. (14,000) Moldova (78) Turkey (1,100) Estonia (5,500) Poland (42,000) Ukraine (490) Geo Data North America Canada-ZIP3 (8,100) Mexico (72,000) Greenland (23) USA (79,000) High resolution postcodes Canada-ZIP6 (797,000) Netherl.-ZIP6 (663,000) GB-ZIP7 (6,460,000) Portugal-ZIP7 (65,000)
In parentheses the number of data records for each country is located. Point data of other countries we offer on request.
To the table of contents of this site
The available country data tables contain different counts of data records with geo referenced local data and postal data.
Detailed information, linkage possibilities with other database tables, hints to the use of the geo references and the formulas for distance calculation you find in the files of the download or in the detailed 
Data Specification.
These data fields are contained in the country data tables:
To the table of contents of this site
The geo data offered here are subject to a continuing quality control.
The raw data of the individual countries as basis for the Geo data are recorded from there residents authorities, institutions and suppliers.
As result the quality of the raw data depends on the infrastructure and the possibilities inside the respective countries.
Geo data of the industrial nations exhibit therefore normally a higher quality than those of the developing countries.
The geo data are prepared, computed and standardized from these raw data with best knowledge by well trained personal.
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 longitude/latitude and as UTM coordinates with UTM easting and UTM northing on the natural meridian strip and on a uniform meridian strip. Because UTM coordinates are converted country-wide 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/minute/second notation. For further calculations with the coordinates, the minute and second portions must be converted into parts of a degree. The representation of latitude and longitude in degrees is called the decimal notation. For a distance computation the longitude and latitude of the first point (Lon1, Lat1) and the longitude and latitude of the second point (Lon2, Lat2) are needed. If the latitude has a minus sign, the point is on the southern earth hemisphere, otherwise on the northern earth hemisphere. If the longitude has a minus sign, the point is situated west of the Greenwich meridian, otherwise east of it. If the latitude has a minus sign, the point is on the southern earth hemisphere, otherwise on the northern earth hemisphere.
Print page body
Data Description
Representation of the longitude and latitude of a coordinate in the
degree/minute/second notation (Data fields LON_GEO and LAT_GEO).
| Two to three digit degree portion of the coordinate (d)
| | Two digit minute portion of the coordinate (m)
| | | Two digit second portion of the coordinate (s)
| | | | Decimal portion of one second(s)
dddmmss.ss
with
d: Degree portion of longitude or latitude
m: Minute portion of longitude or latitude
s: Second portion with decimals of longitude or latitude
Conversion of the lengths and widths of the two coordinates into the
decimal notation. This is not necessary if Geographic coordinates in
degree notation are used directly (data fields LON_DEC and LAT_DEC).
Lon1d = d + (m / 60) + (s / 3600)
Lat1d = d + (m / 60) + (s / 3600)
Lon2d = d + (m / 60) + (s / 3600)
Lat2d = d + (m / 60) + (s / 3600)
with
Lon1d: Decimal longitude of the first point
Lat1d: Decimal latitude of the first point
Lon1d: Decimal longitude of the second point
Lat1d: Decimal latitude of the second point
For further computation the longitude and latitude are converted into
radians. The unit of the radian is [rad].
Lon1r = Lon1d * PI / 180
Lat1r = Lat1d * PI / 180
Lon2r = Lon2d * PI / 180
Lat2r = Lat2d * PI / 180
with
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: The result is the distance in meters
The conversion of the geographic and UTM coordinates into state-specific coordinates or in 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
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
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 database tables presented here can be used as data volumes of computer programs and Internet sites (applications) and can be passed in the context of the application to customers. The database tables are licensed for different types of use:
To the table of contents of this site
Pricing and ordering information for the database tables presented here and for other software products can be found in the Price list.
Order the "Geo Data International Admin" with the electronic Order Form.
To the table of contents of this site
A selection of test data of some countries 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.