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
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:
Hey everyone,
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.
Here's my setup:
2 dual core Opterons, cpu is not the bottleneck
8 GM ram, htop reports this
On Tue, Sep 28, 2010 at 10:25 AM, Nakor nakor@gmail.com wrote:
On 09/24/2010 09:52 AM, Nakor wrote:
Brett,
I should have read the whole documentation first. I am using --write-pgsql
. I'll let it continue (as I am now over 200 Gb) and see how it goes. Next
time I need to import I
On 09/27/2010 08:42 PM, Brett Henderson wrote:
On Tue, Sep 28, 2010 at 10:25 AM, Nakor nakor@gmail.com
mailto:nakor@gmail.com wrote:
On 09/24/2010 09:52 AM, Nakor wrote:
Brett,
I should have read the whole documentation first. I am using
--write-pgsql .
Hello,
how much time does an import of the whole OSM planet into a
PostgreSQL/PostGIS database, including bbox and linestrings, require on
modern hardware?
Osmosis seems to get stuck at computing bounding boxes, i.e. this query:
UPDATE ways SET bbox = (SELECT Envelope(Collect(geom)) FROM
Hello,
Frederik Ramm schrieb:
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
Hi,
Jens Lehmann wrote:
A solution would be to include it in the planet or provide it as a
separate file, which can be loaded into the database.
Well it isn't even in our central database so it would have to be
computed at the time we dump the planet file which already is an
expensive