[OSM-dev] osm2pgsql diff mechanics

[Jukka Rahkonen]

Michael wrote:

> Hi,
>
> I plan to do osm2pgsql diffs on my PostgreSQL setup. For my use-case it is
> important that all geometry data is valid, so after the initial import I
> do a cleaning of all non-valid geometry data (self-intersection, ...).
> Now my question: If I cleaned a geometry (e.g. forest) and a diff
> specifies a change in this geometry, what will happen?
>


I have a related question. What might be the best procedure to follow if I
just want to keep the Finnish excerpt up to date? I have been using the
Geofabrik country file and osm2pgsql, but now it takes about 40 minutes to
run and some 20 minutes more for some updates and extra indexes etc. which
I want to have. Is it possible to generate something like Finland.diff
files to be used with osm2pgsql for updating the PostGIS database?  I have
been thinking that all that I would really need would be osm_point,
osm_line and osm_polygon tables, and all those three would only need one
attribute field, tags as hstore datatype.  All the rest I could do with
SQL inside database.

-Jukka Rahkonen-