[OSM-dev] Fwd: Osmosis - Cutting out a bounding box from a diff file (.osc)

[Jais Pedersen]

As usual i forgot to send it to the list.

---------- Forwarded message ----------
From: Jais Pedersen <jais at pedersens.net>
Date: Wed, Sep 5, 2012 at 3:15 PM
Subject: Re: [OSM-dev] Osmosis - Cutting out a bounding box from a diff
file (.osc)
To: Stéphane Henriod <s at henriod.info>


I setup a Vietnam tile server just for fun and I made a script that worked
like this:

1. Make a copy of the Vietnam extract.
2. Apply the update to the copy
3. Clip the copy using the Vietnam clip bounds file (I think i made my own
from the admin boundary, but it might have been the one from Geofabrik)
4. Make a diff between the original and the copy
5. Apply the diff to the PostGIS database
6 Finally make the copy the new original for next update

Unfortunately the server died (it was a retired PC), so I no longer have
the script and it never had more than a single digit number of users, so I
don't know how it will perform under real load, but for a small (as in the
amount of data) extract it seemed to work quite well - I never really
checked how it worked with object that grew or was moved across the border,
but i suspect that would not be handled so well.

I'm planning to setup a new one after the license change, so I would love
to hear if anybody has a better way to do it.

/Jais


On Wed, Sep 5, 2012 at 2:19 PM, Stéphane Henriod <s at henriod.info> wrote:

> PS: it looks like only the tables
>
>    - planet_osm_rels
>    - planet_osm_ways
>
> Get data from outside my bounding box and thus grow extremely quickly.
>
> Don't really know how to interpret this behavior!
> --
> "Le mot progrès n'aura aucun sens tant qu'il y aura des enfants
> malheureux" -- Albert Einstein
>
> "A journey does not need reasons. Before long, it proves to be reason
> enough in itself. One thinks that one is going to make a journey, yet soon
> it is the journey that makes or unmakes you." -- Nicolas Bouvier
>
> Photos de voyages, photos de montagne: http://www.henriod.info
>
>
>
> On Wed, Sep 5, 2012 at 8:56 AM, Stéphane Henriod <s at henriod.info> wrote:
>
>> Dear all
>>
>> I now have a running process where I dowload the hourly diffs and those
>> are applied to the PostGIS database with osm2pgsql.
>>
>> My problem is that, despite the *osm2pgsql -b* option, it seems that my
>> bounding box is ignored and the full diff file is added to my database, As
>> a consequence, the database is growing very quickly and includes lots of
>> data outside of my area of interest.
>>
>> My question is thus: is it possible to cut out the bounding box from the
>> diff file before calling osm2pgsql? If I understand correctly, the
>> bounding-box task (
>> http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage#--bounding-box_.28--bb.29)
>> only works on planet files, not diff files. Correct?
>>
>> Is there a way to get the following process working:
>>
>>    1. Get the last hourly diff file
>>    2. Extract from the diff file all the objects within my bounding box
>>    3. Apply this to the PostGIS database with osm2pgsql
>>
>> Thanks in advance and best wishes
>>
>> Stéphane
>> --
>> "Le mot progrès n'aura aucun sens tant qu'il y aura des enfants
>> malheureux" -- Albert Einstein
>>
>> "A journey does not need reasons. Before long, it proves to be reason
>> enough in itself. One thinks that one is going to make a journey, yet soon
>> it is the journey that makes or unmakes you." -- Nicolas Bouvier
>>
>> Photos de voyages, photos de montagne: http://www.henriod.info
>>
>>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20120905/15990c08/attachment-0001.html>