[OSM-dev] Minute Diffs

Peter Körner osm-lists at mazdermind.de
Wed Nov 11 08:39:00 GMT 2009


Peter Childs schrieb:
> I've been trying to get a copy of the OSM data set into a postgres
> database so I can extract some statical info to help with hopefully
> one day search etc.
> 
> Broadly speaking I've been following the instructions at
> http://wiki.openstreetmap.org/wiki/Minutely_Mapnik
> 
> except I'm skiping osm2psql and using osmisis to import the data directly.
I'm using osm2psql with osmosis to import the minutely replicating diffs 
and get I no errors.

/sql/diffs/osmosis-trunk/bin/osmosis --rri workingDirectory=. --wxc - \
   2> "$OSMOSISLOG" | /usr/bin/osm2pgsql --append --slim --cache 1024 \
   --username gis --style /sql/planet.osm/wikimedia.extended.style \
   --verbose - 1>&2 2> "$PSQLLOG"

As osmosis is putting the changesets into osm2pgsql via pipe you should 
be able to plug another osmosis task in between to cut out your bbox.

 > If any one knows how much space I would need that might help too.
You might want to apply for a toolserver account:
https://wiki.toolserver.org/view/Account_approval_process

I'm maintaining a (nearly) up2date database in mapnik postgis format, 
but with extended fields (phone, fax, url, opening_hours etc.).

Peter




More information about the dev mailing list