Hi Brian, Yes, you should definitely use the built-in box builder functionality. I've never tried to use the database to do it on a complete planet. I have no idea how long it will take.
Brett On Sun, Apr 17, 2011 at 4:34 AM, Brian DeRocher <br...@derocher.org> wrote: > On Saturday 09 April 2011 22:27:31 you wrote: > > I started a full planet import on the 29th, 11 days ago. I'm trying to > get an idea how long this will take. I just want to know if this will take > about 20 days or more like 40 days. > > I think i found my answer, thanks to Toby: > > "enableBboxBuilder=yes: This tells the write-pgsql-dump task to calculate a > bounding box for each way. This is stored in a "geometry" type column in > postgres that can be used in spatial queries. This can be done in the > database but you may not live to see it finish if you are processing the > entire planet. Seriously." > > http://weait.com/content/build-your-own-openstreetmap-server > > Also i was using Osmosis 0.34 from Debian 6. I'll upgrade to the stable or > devel release, or try svn. > > For the record this import is on day 17.5 and it's currently running this > query for 15 days. > > UPDATE ways SET bbox = ( > SELECT Envelope(Collect(geom)) FROM nodes JOIN way_nodes ON > way_nodes.node_id = nodes.id > WHERE way_nodes.way_id = ways.id > ) > > Brian > > -- > Brian DeRocher > http://brian.derocher.org > > _______________________________________________ > osmosis-dev mailing list > osmosis-dev@openstreetmap.org > http://lists.openstreetmap.org/listinfo/osmosis-dev > >
_______________________________________________ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev