[OSM-dev] Osmosis: Bounding polygon does not support change data as input?

[Brett Henderson]

On Fri, Sep 19, 2008 at 2:18 AM, Andreas Kalsch <andreaskalsch at gmx.de>wrote:

> Thank you for your help.
> The fourth point means that in my planned application I am not going to use
> OSM database but just a subset of it - so I need kind of trigger which
> updates my application data from my local OSM database.
>
> I have tried to do this the way I described, but it still does not work. I
> described it in another post this morning. Either ...
>
> osmosis/bin/osmosis --read-xml-change data/osm/20080916-20080917.osc
> --apply-change --write-mysql host=localhost database=osm_de user=user
> password=xxx


>
> and ...
>
> osmosis/bin/osmosis --read-xml-change data/osm/20080916-20080917.osc
> --read-mysql host=localhost database=osm_de user=root password=qay
> --apply-change --write-mysql host=localhost database=osm_de user=user
> password=xxx
>
> do not work. What is the right syntax?


It should be like this (note use of --write-mysql-change).
osmosis/bin/osmosis --read-xml-change data/osm/20080916-20080917.osc
--write-mysql-change host=localhost database=osm_de user=user password=xxx

Note that you can also use the --read-change-interval task which will
automate the downloading of change files and eliminate the need for the
--read-xml-change task.  You can easily automate this via cron allowing you
to use minute changesets if you wish.
http://wiki.openstreetmap.org/index.php/Osmosis/DetailedUsage#--read-change-interval_.28--rci.29

Let me know if you have any problems with the --write-mysql-change task, it
hasn't been heavily used yet.

Have you looked at PostgreSQL?  Osmosis provides a "pgsql-simple" schema
which is very similar to the OSM MySQL schema but doesn't have history
tables and uses some geo-spatial extensions.  It is already being used by a
couple of people and may be more appropriate depending on your usage.

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20080919/5fa5cadb/attachment.html>