Data source: Big Local News · About: big-local-datasette

5 rows where subdomain_name = "PEI"

View and edit SQL

Link rowid ▼ obsid index item_code domain_code domain_name domain_description subdomain_code subdomain_name subdomain_description subdomain_long_desc measure_name measure_description measure_rationale data_source verbose_data_source data_dates limitations
122 259.0 Index 6.3.1 6.0 EOH Environmental & Occupational Health 19.0 PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. M922 Transportation Structural Integrity, percent of bridges that are in good or fair condition (not poor) Core elements of transportation infrastructure shape many aspects of health security, including mitigation of health and safety risks due to bridge failures, timely mass evacuations, timely emergency responses, and timely restoration of economic and social activity. US DOT U.S. Department of Transportation, Federal Highway Administration, Office of Bridges and Structures 2012—2017 The frequency of bridge inspections varies according to numerous criteria. Most bridges are on a one-, two-, or four-year inspection cycle. Consequently, the data year does not necessarily coincide with the inspection year.
123 259.1 Index 6.3.2 6.0 EOH Environmental & Occupational Health 19.0 PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. M923 Surface Water Control Structural Integrity, percent of High-Hazard Potential Dams that are in Fair or Satisfactory condition Core elements of surface water control infrastructure contribute to health security through mitigation of flood risks and protection of drinking water sources. NID & ASDSO U.S. Corp of Engineers, National Inventory of Dams (NID) and the Association of State Dam Safety Officials (ASDSO) 2016 & 2018 A small, but growing number of states exempt categories of dams from inspection based on the purpose of the impoundment or the owner type.  Nationally roughly a quarter (22%) of the high-hazard dams are not rated for condition, with wide differences among the states
124 259.2 Index 6.3.3 6.0 EOH Environmental & Occupational Health 19.0 PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. M928 Housing Mitigation for Flood Hazards, population living in a community participating in the FEMA Community Rating System (communities with a CRS of 1 through 9) as a percent of all communities participating in the National Flood Insurance Program States can reduce health, safety and financial risks posed by flooding by encouraging communities to participate in the community rating system. FEMA FEMA National Flood Insurance Program (NFIP) Community Rating System (CRS) 2017—2018 Participation in the National Flood Insurance Program (NFIP) is voluntary.  It is possible that some communities located in flood zones are not part of the NFIP. 
125 259.3 Index 6.3.4 6.0 EOH Environmental & Occupational Health 19.0 PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. M929 Flood Insurance Coverage, FEMA National Flood Insurance Policies (NFIP) in-force as a percentage of total housing units located in 100- and 500-year floodplains NFIP participation indicates household and community awareness of flood risks and provides financial protections that accelerate community recovery after flood-related disasters. FEMA & NYU Furman Center U.S. Department of Homeland Security, FEMA, National Flood Insurance Program, and the NYU Furman Center (FloodzoneData.us) 2013—2018 Participation in the National Flood Insurance Program (NFIP) is voluntary.  It is possible that some communities located in flood zones are not part of the NFIP.  Also, many flood zone maps are outdated.
126 259.5 Index 6.3.6 6.0 EOH Environmental & Occupational Health 19.0 PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. M334 State has a climate change adaptation plan Climate change is already increasing global temperatures, leading to rising sea levels and more frequent and intense extreme weather events. These changes could affect coastlines, water supplies, human health, ecosystems, and more. Each community will be affected differently, so formal planning and concrete actions are needed to address these changes at both the state and local level. States and municipalities are recognizing the importance of preemptive action to address their vulnerabilities to climate change impacts. Many states have begun to address adaptation concerns either within broader climate action plans or through separate efforts. C2ES Center for Climate and Energy Solutions (C2ES), State and Local Climate Adaptation 2014—2018 The measure does not evaluate the quality or comprehensiveness of the plan, or the degree to which the plan is implemented.

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [NHSPI_measure_metadata] (
   [obsid] TEXT,
   [index] TEXT,
   [item_code] TEXT,
   [domain_code] TEXT,
   [domain_name] TEXT,
   [domain_description] TEXT,
   [subdomain_code] TEXT,
   [subdomain_name] TEXT,
   [subdomain_description] TEXT,
   [subdomain_long_desc] TEXT,
   [measure_name] TEXT,
   [measure_description] TEXT,
   [measure_rationale] TEXT,
   [data_source] TEXT,
   [verbose_data_source] TEXT,
   [data_dates] TEXT,
   [limitations] TEXT
);