preprocess some selected building features automatically

[traveller195]

e.g. building height

address/ location...

[traveller195]

building height from LoD2 derived and joined with the colouring dresden database

• loading data into db with python
• merge data into buildings table with SQL

Important: take care about data format of target db... round(bld_height, 1) is here recommend. For the db would be okay, but otherwise it makes trouble with GUI and user edits on that

[traveller195]

[traveller195]

hint: always use API for data access.

no external db connection from Python or pgAdmin

[traveller195]

• address data
• ID of LoD2 building
• land parcel ID

[traveller195]

• OSM ID

[traveller195]

• morph building type / adjancy

[traveller195]

• building area / Grundfläche

[traveller195]

some building attributes, like

• osm id and osm type
• building height
• street, housenumber, postcode, city were added automatically via API into database