Skip to content

Retrofit Cost script

Jump to bottom
YONG WOOK KIM edited this page Feb 28, 2024 · 9 revisions

Galveston

For Galveston, cost table is given (but need to adjust for the inflation), then based on the foundation type (bsmt_typ) updated in the new galveston inventory, and the foot_sq column we can calculate the cost. image

bsmt_typ

  • 0: not identified and can be assumed slab on grade (1ft from the ground)
  • 1: slab on grade (1ft from the ground)
  • 2: crawlspace (5ft from the ground)
  • 3: Pile (10ft from the ground)

Retrofit Cost Analysis Implementation Design:

Inputs:

  • Retrofit Strategy: comes from data service
  • Building Inventory: comes from data service
  • Retrofit Cost Table (optional): created from the image manually then saved with the script
  • Use "retrofit strategy" as keyword to implement different method for calculating

Outputs:

  • a csv table with "guid", "retrofit_cost"
  • a json file that contains total cost information

Step 1. convert image to table

  • The column for bsmt 0 and 1 is Slab on Grade
  • The column for bsmt 2 is Slab Separation
  • The column for bsmt 3 is Open foundation

Step 2. calculate the retrofit cost

  • From shpaefile's dbf file, get bsmt_type and sq_foot.
  • The bsmt_type should be connected to the table created in step 1
  • Also, the given retrofit table, associate the guid to see what elevation the each building has
  • Then, calculate the cost by multiplying the cost from the step 1 table by using the bsmt_type and elevation to sq_foot.
  • Apply inflation to the cost by multiplying the value of 1.79

Step 3. create output file

  • create the same output file as SLC retrofit cost
  • output csv should have guid and cost
  • output json should have total cost

SLC

For SLC, retrofit cost is given as a table with "guid" "cost" as it is without any calculation

Retrofit Cost Analysis Implementation Design:

inputs

  • retrofit cost table: static csv table
  • retrofit strategy: comes from data service

outputs

  • a csv table with 'guid' and 'retrofit_cost'
  • a json file that contains total_cost information

notes

  • the retrofit cost for each building has pre calculate already and recorded in the input table
    • not every buildings has the cost
  • the output should only have the rows that only exists in the retrofit strategy table
    • to do this, the inner join between the input building inventory and retrofit strategy needed
    • after inner join, if the cost is missing, give the 'NA' value
  • the input inventory table was provided as static csv table
  • retrofit strategy table is from data service
  • there are two output files, one for csv table that has 'guid' and 'retrofit_cost' column, other is json file that has total cost
Clone this wiki locally