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:
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.
Since I am adding geom for each row the table now becomes around 8gb. Do we need geometries in the table ?