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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
