Name: Specific_Variables_Enhanced_Indices_ExportTable

Display Field: NRI_ID

Type: Table

Description: The dataset includes carefully derived indices to aid financial institutions, policymakers, and researchers in assessing climate-related financial risks and vulnerabilities across U.S. census tracts. Variables incorporate historical climate conditions, future climate projections (e.g., changes in cooling degree days, drought frequency, flood conditions), and socio-economic factors influencing community resilience. The dataset supports spatial analysis, financial risk assessment, regulatory compliance (e.g., SEC climate risk disclosures), and strategic decision-making related to climate change adaptation and disaster preparedness.Key indices include:Enhanced CREI: Highlights regions where climate change significantly amplifies existing natural hazard risks.Enhanced FRAI: Measures how climate-related factors potentially amplify economic losses due to natural disasters.Enhanced MHCSI: Reflects cumulative impacts from multiple concurrent climate hazards (heat waves, drought, flood, wildfire).Enhanced ACI: Assesses community resilience by integrating socio-economic vulnerabilities and adaptive capacities.The dataset is structured to facilitate direct use in ArcGIS Pro for spatial analysis, modeling, and visualization, enhancing stakeholders' ability to manage and mitigate climate and financial risks proactively.

Copyright Text: Data integrated from: FEMA (Federal Emergency Management Agency), National Risk Index (NRI) NOAA (National Oceanic and Atmospheric Administration), Climate Mapping for Resilience and Adaptation (CMRA) Derived indices and calculations prepared by Johns Hopkins University Advanced Academic Programs GIS Student for a Capstone project.

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OID_ (type: esriFieldTypeDouble, alias: OID_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NRI_ID (type: esriFieldTypeString, alias: NRI_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STATEABBRV (type: esriFieldTypeString, alias: STATEABBRV, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STATEFIPS (type: esriFieldTypeDouble, alias: STATEFIPS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COUNTYTYPE (type: esriFieldTypeString, alias: COUNTYTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COUNTYFIPS (type: esriFieldTypeDouble, alias: COUNTYFIPS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STCOFIPS (type: esriFieldTypeDouble, alias: STCOFIPS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRACT (type: esriFieldTypeDouble, alias: TRACT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRACTFIPS (type: esriFieldTypeDouble, alias: TRACTFIPS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POPULATION (type: esriFieldTypeDouble, alias: POPULATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUILDVALUE (type: esriFieldTypeDouble, alias: BUILDVALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGRIVALUE (type: esriFieldTypeDouble, alias: AGRIVALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AREA (type: esriFieldTypeDouble, alias: AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RISK_VALUE (type: esriFieldTypeDouble, alias: Overall Risk Economic Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RISK_SCORE (type: esriFieldTypeDouble, alias: Overall Natural Hazard Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RISK_RATNG (type: esriFieldTypeString, alias: RISK_RATNG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RISK_SPCTL (type: esriFieldTypeDouble, alias: Percentile rank of Natural Hazard risk compared to other census tracts, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EAL_SCORE (type: esriFieldTypeDouble, alias: Expected Annual Loss Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EAL_RATNG (type: esriFieldTypeString, alias: Expected Annual Loss Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SOVI_SCORE (type: esriFieldTypeDouble, alias: Social Vulnerability Index Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOVI_RATNG (type: esriFieldTypeString, alias: Social Vulnerability Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESL_SCORE (type: esriFieldTypeDouble, alias: Community Resilience Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESL_RATNG (type: esriFieldTypeString, alias: Community Resilience Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRGT_RISKS (type: esriFieldTypeDouble, alias: Drought Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRGT_RISKR (type: esriFieldTypeString, alias: Drought Risk Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HWAV_RISKS (type: esriFieldTypeDouble, alias: Heat Wave Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HWAV_RISKR (type: esriFieldTypeString, alias: Heat Wave Risk Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RFLD_RISKS (type: esriFieldTypeDouble, alias: Riverine Flood Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RFLD_RISKR (type: esriFieldTypeString, alias: Riverine Flood Risk Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WFIR_RISKS (type: esriFieldTypeDouble, alias: Wildfire Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WFIR_RISKR (type: esriFieldTypeString, alias: Wildfire Risk Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NRI_Geo_ID (type: esriFieldTypeDouble, alias: NRI_Geo ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CDD_Change_Pct (type: esriFieldTypeString, alias: Percentage Change in Cooling Degree Days, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HDD_Change_Pct (type: esriFieldTypeString, alias: Percentage Change in Heating Degree Days, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Drought_Change_Pct (type: esriFieldTypeString, alias: Percentage Change in Drought Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Flood_Change_Pct (type: esriFieldTypeString, alias: Percentage Change in Flood Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Enhanced_ACI (type: esriFieldTypeDouble, alias: Enhanced Adaptive Capacity Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Enhanced_MHCSI (type: esriFieldTypeDouble, alias: Enhanced Multi-Hazard Climate Stress Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Enhanced_CREI_Num (type: esriFieldTypeDouble, alias: Enhanced_CREI_Num, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Enhanced_FRAI_Num (type: esriFieldTypeDouble, alias: Enhanced_FRAI_Num, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Specific_Variables_Enhanced_Indices_ExportTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/12/2025 12:26:55 AM

Schema Last Edit Date: 7/12/2025 12:26:55 AM

Data Last Edit Date: 7/12/2025 12:26:55 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat