Jens, Jens Lehmann wrote: > 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) > > How long will this query take? Is there a way to monitor its progress? > Why isn't the content of the column just copied in instead of > recomputing everything from scratch?
Well you have to compute it somewhere because it is not in the planet. But you can use the osmosis --wp option enableBboxBuilder to have the boox built in Java and then copied into PostGIS rather than having it built in PostGIS. Doing it in Java is faster but I don't know by how much. See http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage#--write-pgsql_.28--wp.29 Bye Frederik _______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
