[OSM-dev] Adding an additional altitude column to pgsnapshot schema nodes table

[arminus]

Hi,

how would I best go about putting SRTM based altitude data into a pgsnapshot
database ? This database only holds nodes for certain ways, my idea is to
add an altitude column in the nodes table which is filled by an SRTM import
(I have that covered).

The first problem I encounter is that something blocks an "ALTER TABLE nodes
ADD COLUMN altitude integer;" (I use pgsnapshot_schema_0.6) - pgsql simply
doesn't return after I run this.

The 2nd question is: how would I go about extending osmosis to export this
new column as part of an XML/OSM output ? (I'm presently using the new 
https://github.com/iandees Xapi   from Ian to query this database and it
relies on osmosis to write the output data).

Any hints are appreciated !

Thanks,
Armin
-- 
View this message in context: http://gis.638310.n2.nabble.com/Adding-an-additional-altitude-column-to-pgsnapshot-schema-nodes-table-tp5890169p5890169.html
Sent from the Developer Discussion mailing list archive at Nabble.com.