On Tue, Nov 24, 2009 at 20:44, Colin Marquardt cmarqu42@googlemail.com wrote:
2009/11/24 Peter Körner osm-lists@mazdermind.de:
Colin Marquardt schrieb:
2009/11/24 Peter Körner osm-lists@mazdermind.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.