migrate source csv files from model-input repo to openquake-input

[wkhchow]

migrate source csv files from model-input repo to openquake-input

add_data.sh

• Changes between lines 169 - 239 ?
• All source inputs change from model-inputs to respective openquake-inputs except site_model exposure lines 175 -177

- #Physical Exposure

• BldgExpRef_CA_master_v3p1.csv to BldgExpRef_CA_master_v3p2.csv
• Column change new column "OccType", update copy statement to reflect Update BldgExpRef_CA_master_v3p2.csv to include extra indicator (OccType) openquake-inputs#12)

- #vs30

• site-vgrid_CA.csv
• Column change, update copy statement to reflect - sql already updated in model-factory

- #census

• [ ] census-attributes-2016.csv to census-attributes.csv
• Filename is the same. No column changes. census-attributes-2016.csv

- #sovi

• social-vulnerability-census_2021 to social-vulnerability-census.csv

• No column changes

• social-vulnerability-index_2021.csv to social-vulnerability-index.csv

• No column changes

• [ ] sovi_thresholds_2021.csv to sovi_thresholds.csv

• Filename is the same. No column changes. sovi_thresholds_2021.csv

- #lut

• No change for collapse_probability.csv

• Enhancement for future (Rewrite necessary DSRA/PSRA scripts to handle Hazus xlsx openquake-inputs#11)

• Retrofit costs table removed and not needed. Remove lines 215 - 218, update in copy statement.

- #GHSL

• Filename is the same. No column changes

• #MH

• HTi_Sauid_2021.csv to HTi_Sauid.csv

• No column changes

• HTi_threshold_2021.csv to HTi_threshold.csv

• No column changes

• Hazard_threat_rating_threshold.csv is a new lut - update copy table statements to include. New create tables in model factory. Updated sql indicators in model factory.

• Create_table_mh_rating_thresholds.sql

• Add extra run_psql Create_table_mh_rating_thresholds.sql line 234

• Create_MH_risk_sauid_prioritization_prereq_tables.sql

• Replaces Create_MH_risk_building_ALL.sql, update line 235

• Create_MH_risk_sauid_prioritization_Canada.sql

• Replaces Create_MH_risk_building_ALL.sql, update line 236