OSM2PostGIS Project Web

Documentation

Installation

Database server

The host machine that runs the PostGIS spatially-enabled database

• Stores the desired geometry data and routing network topology (as relational tuples) that is the output

The dependencies below are listed assuming that you are going to compile and install many of the packages from sources. If you are compiling on a different host, most of these dependencies are actually for the host where you compile the server-side packages.

TODO: Separate compile- and run-time dependencies.

1. CentOS release 5.4 (Final) Linux 2.6.18-164.11.1.el5xen x86_64
2. PostgreSQL 8.1.18 server (CentOS postgresql-server.x86_64)
3. PostgreSQL 8.1.18 development headers (CentOS postgresql-devel.x86_64)
4. Flex: The Fast Lexical Analyzer 2.5.4 (CentOS flex.x86_64)
5. Boost C++ Libraries 1.33.1 (CentOS boost-devel.x86_64)
6. PROJ.4 Cartographic Projections Library (proj-4.7.0)
7. Geometry Engine - Open Source (geos-3.2.0)
8. Subversion (CentOS subversion.x86_64)
9. PostGIS 1.3.6
10. Genetic Algorithm Utility Library (gaul-devel-0.1849-0)
11. CMake build system (cmake-2.8.0)
12. pgRouting 1.03

You will want to install the PROJ.4 and GEOS libraries before installing PostGIS.

TODO: Please report any missing dependencies.

Client host

The host machine that runs the osm2postgis program

• Has access to a copy of the OpenStreetMap source data that is the input (.osm XML files)

So far, the OSM data for Malta and Iceland have been used for testing—because both are comfortably small.

1. Sun Java SE 6 JRE (or JDK)
2. PostgreSQL JDBC4 driver (postgresql-8.4-701.jdbc4.jar)
3. PostGIS JDBC extension (postgis_1.3.6.jar)
4. OSM2PostGIS executable (OSM2PostGIS-0.0.0.*.jar)

Development host

Where you compile and build the OSM2PostGIS package (This may be the same machine as the client host.)

Building

$ cd osm2postgis

$ ant

dist/lib/OSM2PostGIS-<version>.jar

Configuration and usage

Map feature specification

OSM2PostGIS makes it quite easy to generate almost any kind of database you like from the OSM data. You can design the table names, column names, and specify which map features go into which tables and are associated with which attributes. You can create as many tables you like with as many columns you like, be it only one or dozens. All the target tables can be similar or they can be entirely different. It's up to you to decide what kind of data you want.

The default features.json file that comes with current OSM2PostGIS (in the conf/ directory) contains rough instructions on how to to configure map feature recognition. A better tutorial on that will be written later.

Command line interface

Ensure that the compiled class files and the client dependencies are in the Java class path:

• OSM2PostGIS-<version>.jar
• postgresql-8.4-701.jdbc4.jar
• postgis_1.3.6.jar

Run the program from the command line:

$ java net.sourceforge.osm2postgis.Shell -d host:port/database planet.osm

Alternatively, you can use a similar Eclipse run configuration.

For example, in the current test environment the database server hostname is "kanta" (using the default port 5432) and the PostGIS database name is "routing", so:

$ java net.sourceforge.osm2postgis.Shell -d kanta/routing malta.osm

If you need to specify a database password, you can do so by adding the -W option. However, please keep in mind that the password given on the command line is not masked. Also storing passwords in plain text files is a security risk. Even if you are not writing a script, your operating system shell may automatically store the whole command line—including the password—in command line history. Usually it's a better idea to use some other authentication method, for example PostgreSQL 'ident' authentication.

You can also add the -s option to set the number of lines to be skipped from the start of the file. This is useful, if you want to continue an interrupted import.

The -p option sets which process phases are run. The choices are "changesets, nodes, ways, relations, topology, features" that must be a comma-separated list. If there are spaces, the list must be enclosed in double quotes. Only the first letter of each keyword is required. E.g. to only create topology and geometry for rendering, use:

Shell -p t,f

To only import nodes without overwriting any other data, use:

Shell -p n

Note that you must import nodes before importing any ways referring to those nodes. Similarly you must import all ways and nodes before any relations referring to those ways and nodes.

If you import a larger area to an existing database, remember to recalculate the layer bounds in GeoServer.

The -f option sets the location of the feature specification file for map feature recognition. The default name is "features.json" in the current directory.

Using the resulting data

The relational model

Visualization

Routing