NAME¶

osm2pgsql - Openstreetmap data to PostgreSQL converter.

SYNOPSIS¶

osm2pgsql [options] planet.osm osm2pgsql [options] planet.osm.{gz,bz2} osm2pgsql [options] file1.osm file2.osm file3.osm

DESCRIPTION¶

This manual page documents briefly the osm2pgsql command. osm2pgsql imports data from OSM file(s) into a PostgreSQL database suitable for use by the Mapnik renderer. OSM planet snapshots can be downloaded from http://planet.openstreetmap.org

OPTIONS¶

These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below.

-a, --append

Add the OSM file into the database without removing existing data.

-b, --bbox

Apply a bounding box filter on the imported data Must be specified as: minlon,minlat,maxlon,maxlat e.g. --bbox -0.5,51.25,0.5,51.75

-c, --create

Remove existing data from the database. This is the default if --append is not specified.

-d, --database

The name of the PostgreSQL database to connect to (default: gis).

-l, --latlong

Store data in degrees of latitude & longitude.

-m, --merc

Store data in proper spherical mercator (default)

-M, --oldmerc

Store data in the legay OSM mercator format

-E, --proj num

Use projection EPSG:num

-u, --utf8-sanitize

Repair bad UTF8 input data (present in planet dumps prior to August 2007). Adds about 10% overhead.

-p, --prefix

Prefix for table names (default planet_osm)

-s, --slim

Store temorary data in the database. This greatly reduces the RAM usage but is much slower.

-S, --style

Location of the style file. Default to /usr/share/osm2pgsql/default.style

-C, --cache

Only for slim mode: Use up to this this many MB for caching nodes. Default is 800MB.

-U, --username

Postgresql user name.

-W, --password

Force password prompt.

-H, --host

Database server hostname or socket location.

-P, --port

Database server port.

-e, --expire-tiles [min_zoom-]max_zoom

Create a tile expiry list.

-o, --expire-output filename

Output filename for expired tiles list.

-r, --input-reader

Input frontend.

 

libxml2 - Parse XML using libxml2. (default)

 

primitive - Primitive XML parsing.

 

pbf - OSM binary format.

-O, --output

Output backend.

 

pgsql - Output to a PostGIS database. (default)

 

null - No output. Useful for testing.

-x, --extra-attributes

Include attributes for each object in the database.

 

This includes the username, userid, timestamp and version.

 

Note: this option also requires additional entries in your style file.

-k, --hstore

Generate an additional hstore (key/value) column to postgresql tables

-z, --hstore-column

Generate an additional hstore (key/value) column to containing all tags that start with the specified string, for example --hstore-column "name:" will produce an extra hstore column that contains all name:xx tags

-G, --multi-geometry

Generate multi-geometry features in postgresql tables.

-K, --keep-coastlines

Keep coastline data rather than filtering it out.

 

By default natural=coastline tagged data will be discarded based on the assumption that post-processed Coastline Checker shapefiles will be used.

-h, --help

Help information.

 

Add -vh to display supported projections.

 

Use -E to access any espg projections (usually in /usr/share/proj/epsg)

-v, --verbose

Verbose output.

SUPPORTED PROJECTIONS¶

Latlong (-l) SRS: 4326 (none) WGS84 Mercator (-M) SRS: 3395 +proj=merc +datum=WGS84 +k=1.0 +units=m +over +no_defs Spherical Mercator (-m) SRS:900913 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +over

SEE ALSO¶

proj(1), postgres(1).

AUTHOR¶

osm2pgsql was written by Jon Burgess and Artem Pavlenko. This manual page was written by Andreas Putzo <andreas@putzo.net>, for the Debian project (but may be used by others).