On Tue, Nov 24, 2009 at 20:44, Colin Marquardt <cmarqu42(a)googlemail.com> wrote:
2009/11/24 Peter Körner
<osm-lists(a)mazdermind.de>de>:
Colin Marquardt schrieb:
2009/11/24 Peter Körner
<osm-lists(a)mazdermind.de>de>:
When I asked around in the past, it sounded as if it wouldn't be too
hard to modify osm2pgsql to make it create new columns in the DB for
such things. Maybe someone has the need *and* the skill for it at some
point :)
Yes it wouldn't be to hard to create them, but they'd be empty
then.
The diff-import may fill them within some months, but it will only add
them if their value changed. The only possibility is to go over the
planet again..
Depends on whether the planet parsing is the slow thing or the writing
of lots of data into the DB. Might still be lots better than a full
import...
If we ever get a full DB replication going (not just PostGIS) we could
theoretically populate new columns with the planet data and then keep
them up to date by changing the style (used when applying diffs).
Should work, but AFAIK OSM itself just does a full re-import, but then
again they add new fields rarely.