OpenLR™ - Test data
Tele Atlas provides free map samples as a relational database using SQLite. The table schema is a simple design of three tables (directed LINES, NODES, METADATA) and is illustrated in the following picture.

SQLite table schema
Available map samples include the following areas and map releases:
- Area around Utrecht, The Netherlands (2008.04 map release)
- Area around Utrecht, The Netherlands (2007.07 map release)
The differences between the two map releases in the Utrecht area are outlined in the following animated picture.
Access to the map samples is governed by a "click-through" Evaluation License Agreement.
Download (a new window with the Evaluation License
will open)
Map sample access
Two supplementary software packages are provided for a test implementation of the four OpenLR™ software packages to work with the free map samples: Database Access Layer and Command Line Interface.
Database Access Layer
Tele Atlas provides a Java library called "Tele Atlas OpenLR Access Layer for SQLite" which enables the OpenLR™ en-/decoder components to use Tele Atlas Digital Maps for location referencing. The map data must be stored in a SQLite database which complies to the above illustrated schema.The implementation uses Java version 6 (see http://java.sun.com) and is licensed under the terms of the GNU General Public License, version 2 (see http://www.gnu.org/licenses/gpl-2.0.html).
The "map sqlite" library makes use of several other libraries and therefore we recommend to use the "with-dependencies" package where all required libraries are included.
| Database Access Layer | |
|---|---|
| Provided for accessing the map samples |
map-sqlite-1.2.0.jar map-sqlite-1.2.0-javadoc.jar map-sqlite-1.2.0-sources.jar map-sqlite-1.2.0-with-dependencies.jar |
Map loader
Tele Atlas provides a map loader library which can be used to load the Tele Atlas test maps within the OpenLR™ "Map Viewer" tool. The map loader requires the "Database Access Layer" and the map data must be stored in a SQLite database which complies to the above illustrated schema.The implementation uses Java version 6 (see http://java.sun.com) and is licensed under the terms of the GNU General Public License, version 2 (see http://www.gnu.org/licenses/gpl-2.0.html).
| Map Loader | |
|---|---|
| Provided for loading the map samples within the Map Viewer tool |
map-sqlite-loader-1.2.0.jar map-sqlite-loader-1.2.0-javadoc.jar map-sqlite-1.2.0-loader-sources.jar |
Command Line Interface
In addition to the database access layer Tele Atlas provides a utility which enables users to use the OpenLR™ en-/decoder components in conjunction with the "Tele Atlas OpenLR Access Layer for SQLite" library using an easy-to-use command line interface. It provides the possibility to encode locations, described by a comma separated list of IDs (and optional offsets), to location references in readable Base64 format and vice versa. Furthermore the utility is able to create KML files visualising the location/location reference.The "cli sqlite" library makes use of several other libraries and therefore we recommend to use the "with-dependencies" package where all required libraries are included.
NOTE: An updated version will be released soon!
| CLI | |
|---|---|
| Utility for using maps samples & database access layer together with the OpenLR™ software package |
cli-sqlite-1.1.1.jar cli-sqlite-1.1.1-javadoc.jar cli-sqlite-1.1.1-sources.jar cli-sqlite-1.1.1-with-dependencies.jar |
Examples
The following examples show the usage of the "Command Line Interface" tool.
The Example 1 shows a location which consists of three lines (see Map IDs) in the 2008.04 map release of the map around Utrecht (The Netherlands). The result of the OpenLR™ encoding is Base64-encoded. This location reference was decoded on the same map and the result is shown in the KML output file. If you want to replay this example you can use the provided command line.
| Example 1 | |
|---|---|
| Location (Map IDs) |
15280001229524, 15280001349498, -15280001349500 |
| Location Reference (Base64-encoded OpenLR binary) |
CgOiYCUMoBNWAv9P/+MSBg== |
| KML file | Download |
| Command line | java -jar cli-sqlite-1.1.1-with-dependencies.jar -m teleatlas_utrecht_2008_04.db3 -i 15280001229524,15280001349498,-15280001349500 -if MAP_ID_STRING -of OPENLR_BASE64 -k openlr-example-01.kml |
The Example 2 shows a location in both map samples. The location in the encoder map (area around Utrecht, 2008.04 map release) consists of six lines. The location reference was decoded on the map release 2007.07 and results in a location of nine lines. The KML output file shows a comparison of this location. If you want to replay this example you can use the provided command line.
| Example 2 | |
|---|---|
| Location (Map IDs, 2008.04 map release) |
15280049399532, 15280049399523, 15280049399521, -15280002764570, -15280049399525, -15280002736845 |
| Decoded location (Map IDs, 2000.07 map release) |
15280049343797, 15280002736803, 15280002764569, -15280002764567, 15280002764532, 15280002736874, 15280002736875, -15280002736845, -15280002736844 |
| KML file | Download |
| Command line | java -jar cli-sqlite-1.1.1-with-dependencies.jar -em teleatlas_utrecht_2008_04.db3 -dm teleatlas_utrecht_2007_07.db3 -i 15280049399532,15280049399523,15280049399521, -15280002764570,-15280049399525,-15280002736845 -if MAP_ID_STRING -of MAP_ID_STRING -k openlr-example-02.kml |


