About this Dataset

Hazard Mitigation Plan - Mitigation Actions Database

New York City’s comprehensive effort to reduce or eliminate potential losses from the hazards described in the Hazard Specific section of the website. The map includes existing and completed mitigation actions that will minimize the effects of a hazard event on New York City’s population, economy, property, building stock, and infrastructure. It is the result of a coordinated effort by 46 New York City agencies and partners to develop and implement a broad range of inventive and effective ways to mitigate hazards.

NOTE: This table can be joined to the mapped projects using the HMP Index field.
For the Hazard Mitigation Plan map, please follow this link: https://data.cityofnewyork.us/d/n6jh-qsrw

Spatial data for projects that were mapped is available here:
Points: https://data.cityofnewyork.us/City-Government/New-York-City-Emergency-Management-Points-/t7k8-wj6b
Lines: https://data.cityofnewyork.us/City-Government/Hazard-Mitigation-Plan-Mitigation-Actions-Database/hqhh-iv7p
Polygons: https://data.cityofnewyork.us/City-Government/Hazard-Mitigation-Plan-Mitigation-Actions-Database/cj2p-e3ej
Organization: City of New York
Last updated: 2020-11-10T17:05:45.369063
Tags: hazard-mitigation, resiliency

Tables

Table 1

@usgov.city_of_new_york_hazard_mitigation_plan_mitigation_act_37cc13f9.table_1

264.78 kB
965 rows
52 columns

CREATE TABLE table_1 (
  "hmp_index" VARCHAR,
  "title" VARCHAR,
  "description_of_action" VARCHAR,
  "description_of_problem" VARCHAR,
  "managing_agency" VARCHAR,
  "supporting_agencies" VARCHAR,
  "action_category" VARCHAR,
  "action_status" VARCHAR,
  "action_status_date" TIMESTAMP,
  "hazards_addressed" VARCHAR,
  "coastal_erosion" BIGINT,
  "coastal_storms" BIGINT,
  "disease_outbreak" BIGINT,
  "drought" BIGINT,
  "earthquakes" BIGINT,
  "extreme_heat" BIGINT,
  "flooding" BIGINT,
  "high_winds" BIGINT,
  "poor_air_quality" BIGINT,
  "winter_weather" BIGINT,
  "non_natural" BIGINT,
  "estimated_start" VARCHAR,
  "estimated_finish" VARCHAR,
  "estimated_cost" VARCHAR,
  "federal_funding_source" VARCHAR,
  "state_funding_source" VARCHAR,
  "city_funding_source" VARCHAR,
  "private_funding_source" VARCHAR,
  "other_funding_source" VARCHAR,
  "climate_change_addressed" VARCHAR,
  "description_of_climate_change_addressed" VARCHAR,
  "social_vulnerability_addressed" VARCHAR,
  "description_of_social_vulnerability_addressed" VARCHAR,
  "related_to_a_critical_facility" VARCHAR,
  "description_of_critical_facility" VARCHAR,
  "planning_regulation_capability" VARCHAR  -- Planning & Regulation Capability,
  "administrative_technical_capability" VARCHAR  -- Administrative & Technical Capability,
  "financial_capability" VARCHAR,
  "education_outreach_capability" VARCHAR  -- Education & Outreach Capability,
  "contact_name" VARCHAR,
  "contact_email" VARCHAR,
  "web_link" VARCHAR,
  "notes" VARCHAR,
  "prioritization_support" DOUBLE,
  "prioritization_social" DOUBLE,
  "prioritization_environmental" DOUBLE,
  "prioritization_planning_and_regulation" DOUBLE,
  "prioritization_administrative_and_technical" DOUBLE,
  "prioritization_financial" DOUBLE,
  "prioritization_education_and_outreach" DOUBLE,
  "prioritization_score" DOUBLE,
  "priority" VARCHAR
);