Skip to content

Mapped building exposure attributes and their values in BuildingAsset table

Simantini Shinde requested to merge feature/map_building_asset into refactoring_to_sql

Created a BuildingAsset table and added all the building assets required for GDE in the table. I have added structural as 1 because I don't have the rebuilding costs, I will add them once I find some numbers. @tara said that she doesn't need the structural column and I can just keep it as any value. I hope this is OK.

There are two issues with this I need help with:

  1. In line 2025 I am trying to add characters JP_ in front of the admin_id but its not working. Do you know any SQL function that can make it happen ? I tried concat but that didn't work.

  2. Since I am adding geom for each row the table now becomes around 8gb. Do we need geometries in the table ?

\approve @ds \fyi @tara

Merge request reports