Earthquake Magnitude, Damage And Impact

Modeling earthquake richter and impacts

@kaggle.arashnic_earthquake_magnitude_damage_and_impact

Table List

9 tables(97.68 MB)

N, Building Damage Assessment

N, Building Ownership And Use

N, Building Structure

N, Household Demographics

N, Household Earthquake Impact

N, Household Resources

N, Individual Demographics

Mapping

Ward Vdcmun District Name Mapping

N, Building Damage Assessment

@kaggle.arashnic_earthquake_magnitude_damage_and_impact.n__building_damage_assessment

11.25 MB
762106 rows
79 columns

building_id Building Id	district_id District Id	vdcmun_id Vdcmun Id	ward_id Ward Id	damage_overall_collapse Damage Overall Collapse	damage_overall_leaning Damage Overall Leaning	damage_overall_adjacent_building_risk Damage Overall Adjacent Building Risk	damage_foundation_severe Damage Foundation Severe	damage_foundation_moderate Damage Foundation Moderate	damage_foundation_insignificant Damage Foundation Insignificant	damage_roof_severe Damage Roof Severe	damage_roof_moderate Damage Roof Moderate	damage_roof_insignificant Damage Roof Insignificant	damage_corner_separation_severe Damage Corner Separation Severe	damage_corner_separation_moderate Damage Corner Separation Moderate	damage_corner_separation_insignificant Damage Corner Separation Insignificant	damage_diagonal_cracking_severe Damage Diagonal Cracking Severe	damage_diagonal_cracking_moderate Damage Diagonal Cracking Moderate	damage_diagonal_cracking_insignificant Damage Diagonal Cracking Insignificant	damage_in_plane_failure_severe Damage In Plane Failure Severe	damage_in_plane_failure_moderate Damage In Plane Failure Moderate	damage_in_plane_failure_insignificant Damage In Plane Failure Insignificant	damage_out_of_plane_failure_severe Damage Out Of Plane Failure Severe	damage_out_of_plane_failure_moderate Damage Out Of Plane Failure Moderate	damage_out_of_plane_failure_insignificant Damage Out Of Plane Failure Insignificant	damage_out_of_plane_failure_walls_ncfr_severe Damage Out Of Plane Failure Walls Ncfr Severe	damage_out_of_plane_failure_walls_ncfr_moderate Damage Out Of Plane Failure Walls Ncfr Moderate	damage_out_of_plane_failure_walls_ncfr_insignificant Damage Out Of Plane Failure Walls Ncfr Insignificant	damage_gable_failure_severe Damage Gable Failure Severe	damage_gable_failure_moderate Damage Gable Failure Moderate	damage_gable_failure_insignificant Damage Gable Failure Insignificant	damage_delamination_failure_severe Damage Delamination Failure Severe	damage_delamination_failure_moderate Damage Delamination Failure Moderate	damage_delamination_failure_insignificant Damage Delamination Failure Insignificant	damage_column_failure_severe Damage Column Failure Severe	damage_column_failure_moderate Damage Column Failure Moderate	damage_column_failure_insignificant Damage Column Failure Insignificant	damage_beam_failure_severe Damage Beam Failure Severe	damage_beam_failure_moderate Damage Beam Failure Moderate	damage_beam_failure_insignificant Damage Beam Failure Insignificant	damage_infill_partition_failure_severe Damage Infill Partition Failure Severe	damage_infill_partition_failure_moderate Damage Infill Partition Failure Moderate	damage_infill_partition_failure_insignificant Damage Infill Partition Failure Insignificant	damage_staircase_severe Damage Staircase Severe	damage_staircase_moderate Damage Staircase Moderate	damage_staircase_insignificant Damage Staircase Insignificant	damage_parapet_severe Damage Parapet Severe	damage_parapet_moderate Damage Parapet Moderate	damage_parapet_insignificant Damage Parapet Insignificant	damage_cladding_glazing_severe Damage Cladding Glazing Severe	damage_cladding_glazing_moderate Damage Cladding Glazing Moderate	damage_cladding_glazing_insignificant Damage Cladding Glazing Insignificant	area_assesed Area Assesed	damage_grade Damage Grade	technical_solution_proposed Technical Solution Proposed	has_repair_started Has Repair Started	has_damage_foundation Has Damage Foundation	has_damage_roof Has Damage Roof	has_damage_corner_separation Has Damage Corner Separation	has_damage_diagonal_cracking Has Damage Diagonal Cracking	has_damage_in_plane_failure Has Damage In Plane Failure	has_damage_out_of_plane_failure Has Damage Out Of Plane Failure	has_damage_out_of_plane_walls_ncfr_failure Has Damage Out Of Plane Walls Ncfr Failure	has_damage_delamination_failure Has Damage Delamination Failure	has_damage_staircase Has Damage Staircase
120101000011	12	1207	120703	Moderate-Heavy	Insignificant/light	nan	nan	Moderate-Heavy-(<1/3)	Insignificant/light-(<1/3)	Severe-Extreme-(<1/3)	nan	Insignificant/light-(>2/3)	Severe-Extreme-(>2/3)	nan	nan	Severe-Extreme-(<1/3)	nan	nan	Severe-Extreme-(>2/3)	nan	nan	nan	Moderate-Heavy-(>2/3)	nan	Severe-Extreme-(>2/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Both	Grade 3	Major repair			1	1	1	1		1
120101000021	12	1207	120703	Severe-Extreme	Severe-Extreme	Insignificant/light	Severe-Extreme-(>2/3)	nan	nan	Severe-Extreme-(>2/3)	nan	nan	Severe-Extreme-(>2/3)	nan	nan	Severe-Extreme-(>2/3)	nan	nan	Severe-Extreme-(>2/3)	nan	nan	Severe-Extreme-(>2/3)	nan	nan	Severe-Extreme-(>2/3)	nan	nan	nan	nan	nan	Severe-Extreme-(>2/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Exterior	Grade 5	Reconstruction	1	1	1	1	1	1	1	1	1
120101000031	12	1207	120703	Moderate-Heavy	Moderate-Heavy	Moderate-Heavy	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	nan	Insignificant/light-(1/3-2/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Both	Grade 2	Minor repair	1									1
120101000041	12	1207	120703	Moderate-Heavy	Moderate-Heavy	Moderate-Heavy	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(1/3-2/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	nan	nan	nan	nan	nan	Both	Grade 2	Minor repair	1
120101000051	12	1207	120703	Insignificant/light	nan	nan	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Exterior	Grade 1	Minor repair	1
120101000061	12	1207	120703	Insignificant/light	Insignificant/light	nan	nan	nan	Insignificant/light-(1/3-2/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(1/3-2/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(1/3-2/3)	nan	nan	Insignificant/light-(1/3-2/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Both	Grade 2	Minor repair
120101000071	12	1207	120703	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Both	Grade 5	Reconstruction
120101000081	12	1207	120703	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Insignificant/light-(>2/3)	nan	nan	Insignificant/light-(>2/3)	nan	nan	Insignificant/light-(1/3-2/3)	nan	nan	Insignificant/light-(>2/3)	nan	nan	Insignificant/light-(>2/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Both	Grade 2	Minor repair	1
120101000091	12	1207	120703	Moderate-Heavy	Insignificant/light	nan	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	nan	Insignificant/light-(>2/3)	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Both	Grade 3	Major repair	1
120101000101	12	1207	120703	Moderate-Heavy	nan	nan	nan	nan	Insignificant/light-(<1/3)	nan	nan	Insignificant/light-(<1/3)	nan	Moderate-Heavy-(<1/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	nan	Insignificant/light-(1/3-2/3)	nan	Moderate-Heavy-(>2/3)	nan	nan	Moderate-Heavy-(>2/3)	nan	nan	nan	nan	nan	nan	Insignificant/light-(<1/3)	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	Exterior	Grade 3	Major repair	1


CREATE TABLE n__building_damage_assessment (
  "building_id" BIGINT,
  "district_id" BIGINT,
  "vdcmun_id" BIGINT,
  "ward_id" BIGINT,
  "damage_overall_collapse" VARCHAR,
  "damage_overall_leaning" VARCHAR,
  "damage_overall_adjacent_building_risk" VARCHAR,
  "damage_foundation_severe" VARCHAR,
  "damage_foundation_moderate" VARCHAR,
  "damage_foundation_insignificant" VARCHAR,
  "damage_roof_severe" VARCHAR,
  "damage_roof_moderate" VARCHAR,
  "damage_roof_insignificant" VARCHAR,
  "damage_corner_separation_severe" VARCHAR,
  "damage_corner_separation_moderate" VARCHAR,
  "damage_corner_separation_insignificant" VARCHAR,
  "damage_diagonal_cracking_severe" VARCHAR,
  "damage_diagonal_cracking_moderate" VARCHAR,
  "damage_diagonal_cracking_insignificant" VARCHAR,
  "damage_in_plane_failure_severe" VARCHAR,
  "damage_in_plane_failure_moderate" VARCHAR,
  "damage_in_plane_failure_insignificant" VARCHAR,
  "damage_out_of_plane_failure_severe" VARCHAR,
  "damage_out_of_plane_failure_moderate" VARCHAR,
  "damage_out_of_plane_failure_insignificant" VARCHAR,
  "damage_out_of_plane_failure_walls_ncfr_severe" VARCHAR,
  "damage_out_of_plane_failure_walls_ncfr_moderate" VARCHAR,
  "damage_out_of_plane_failure_walls_ncfr_insignificant" VARCHAR,
  "damage_gable_failure_severe" VARCHAR,
  "damage_gable_failure_moderate" VARCHAR,
  "damage_gable_failure_insignificant" VARCHAR,
  "damage_delamination_failure_severe" VARCHAR,
  "damage_delamination_failure_moderate" VARCHAR,
  "damage_delamination_failure_insignificant" VARCHAR,
  "damage_column_failure_severe" VARCHAR,
  "damage_column_failure_moderate" VARCHAR,
  "damage_column_failure_insignificant" VARCHAR,
  "damage_beam_failure_severe" VARCHAR,
  "damage_beam_failure_moderate" VARCHAR,
  "damage_beam_failure_insignificant" VARCHAR,
  "damage_infill_partition_failure_severe" VARCHAR,
  "damage_infill_partition_failure_moderate" VARCHAR,
  "damage_infill_partition_failure_insignificant" VARCHAR,
  "damage_staircase_severe" VARCHAR,
  "damage_staircase_moderate" VARCHAR,
  "damage_staircase_insignificant" VARCHAR,
  "damage_parapet_severe" VARCHAR,
  "damage_parapet_moderate" VARCHAR,
  "damage_parapet_insignificant" VARCHAR,
  "damage_cladding_glazing_severe" VARCHAR,
  "damage_cladding_glazing_moderate" VARCHAR,
  "damage_cladding_glazing_insignificant" VARCHAR,
  "area_assesed" VARCHAR,
  "damage_grade" VARCHAR,
  "technical_solution_proposed" VARCHAR,
  "has_repair_started" DOUBLE,
  "has_damage_foundation" DOUBLE,
  "has_damage_roof" DOUBLE,
  "has_damage_corner_separation" DOUBLE,
  "has_damage_diagonal_cracking" DOUBLE,
  "has_damage_in_plane_failure" DOUBLE,
  "has_damage_out_of_plane_failure" DOUBLE,
  "has_damage_out_of_plane_walls_ncfr_failure" DOUBLE,
  "has_damage_gable_failure" DOUBLE,
  "has_damage_delamination_failure" DOUBLE,
  "has_damage_column_failure" DOUBLE,
  "has_damage_beam_failure" DOUBLE,
  "has_damage_infill_partition_failure" DOUBLE,
  "has_damage_staircase" DOUBLE,
  "has_damage_parapet" DOUBLE,
  "has_damage_cladding_glazing" DOUBLE,
  "has_geotechnical_risk" DOUBLE,
  "has_geotechnical_risk_land_settlement" BIGINT,
  "has_geotechnical_risk_fault_crack" BIGINT,
  "has_geotechnical_risk_liquefaction" BIGINT,
  "has_geotechnical_risk_landslide" BIGINT,
  "has_geotechnical_risk_rock_fall" BIGINT,
  "has_geotechnical_risk_flood" BIGINT,
  "has_geotechnical_risk_other" BIGINT
);