[OSM-talk] osm2pgsql

James McManus jmpmcmanus at gmail.com
Fri Jun 26 23:28:07 BST 2009


Hi - I'm trying to use osm2pgsql to extract a subset area of OSM, but the
--bbox option does not appear to be working.  I downloaded
planet-090617.osm.bz2 and then issued the following command:

osm2pgsql --bbox -0.5,51.25,0.5,51.75 -m -d gis planet-090617.osm.bz2

At first it appears to be working producing the following output:

planet-090617.osm.bz2
osm2pgsql SVN version 0.66-16084

Using projection SRS 900913 (Spherical Mercator)
Applying Bounding box: -0.500000,51.250000 to 0.500000,51.750000
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Mid: Ram, scale=100

Reading in file: planet-090617.osm.bz2
Processing: Node(1400k) Way(0k) Relation(0k)

But it runs for hours and uses up all of my RAM.  I eventually have to kill it.
How long should it take to subset a small area such as this?

Thanks
Jim
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20090626/fe19b1ff/attachment.html>


More information about the talk mailing list