View In:   ArcGIS Online Map Viewer

Name: Culverts Resilience Results

Display Field: Route_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A total of 1,385 culverts were analyzed for their vulnerability to inland flood, coastal flood, and geohazards. This data set is limited to NBI culverts on North Carolina primary roads, NBI bridge data was joined to the NCDOT structures data. The combined data was intersected with flood data from NCDOT's resilience applications (https://www.ncdot-raft.info/applications.php), i.e., the Roadway Inundation Tool (RIT) 2.0 for inland flooding, and the Coastal Roadway Inundation Simulator (CRIS) for coastal flooding. In addition, each culvert was intersected with layer representing NCDOT's Geotechnical Asset Management (GAM) database. A score for sensitivity was derived from NBI Item 62, Culvert Condition. The final prioritization score is the sum of exposure scores for flooding and geohazards, criticality, sensitivity, whether the bridge overlaps a State Transportation Improvement Plan (STIP) project. For a complete discussion of the resilience analysis and scoring process, see Appendix C of the NCDOT 2023 RIP.

Copyright Text: Credits: source data is (1) NCDOT structures spatial data at https://www.nconemap.gov/maps/7367c33b80f346178ea5e158ec4d5b68/explore and (2) Federal Highway Administration, National Bridge Inventory at https://www.fhwa.dot.gov/bridge/nbi.cfm

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 399781.2753471881
YMin: 61941.89602586156
XMax: 2878147.5809345664
YMax: 1067108.088211782
Spatial Reference: 102719  (2264)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: priority_idx
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 3
  Label: 3
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [128, 0, 255, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 4
  Label: 4
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 115, 255, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 5
  Label: 5
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [85, 255, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 6
  Label: 6
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 7
  Label: 7
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 8
  Label: 8
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: priority_idx

Fields:

• asset_class ( type: esriFieldTypeString, alias: Asset Class, editable: true, nullable: true, length: 10, defaultValue: null, modelName: asset_class )
• RouteID ( type: esriFieldTypeString, alias: RouteID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RouteID )
• Route_Name ( type: esriFieldTypeString, alias: Route_Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Route_Name )
• STIP_ID ( type: esriFieldTypeString, alias: STIP_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STIP_ID )
• MEAN_BeginMp1 ( type: esriFieldTypeDouble, alias: MEAN_BeginMp1, editable: true, nullable: true, defaultValue: null, modelName: MEAN_BeginMp1 )
• MEAN_EndMp1 ( type: esriFieldTypeDouble, alias: MEAN_EndMp1, editable: true, nullable: true, defaultValue: null, modelName: MEAN_EndMp1 )
• depth_10 ( type: esriFieldTypeDouble, alias: depth_10, editable: true, nullable: true, defaultValue: null, modelName: depth_10 )
• depth_25 ( type: esriFieldTypeDouble, alias: depth_25, editable: true, nullable: true, defaultValue: null, modelName: depth_25 )
• depth_50 ( type: esriFieldTypeDouble, alias: depth_50, editable: true, nullable: true, defaultValue: null, modelName: depth_50 )
• depth_100 ( type: esriFieldTypeDouble, alias: depth_100, editable: true, nullable: true, defaultValue: null, modelName: depth_100 )
• depth_500 ( type: esriFieldTypeDouble, alias: depth_500, editable: true, nullable: true, defaultValue: null, modelName: depth_500 )
• e_10 ( type: esriFieldTypeSmallInteger, alias: e_10, editable: true, nullable: true, defaultValue: null, modelName: e_10 )
• e_25 ( type: esriFieldTypeSmallInteger, alias: e_25, editable: true, nullable: true, defaultValue: null, modelName: e_25 )
• e_50 ( type: esriFieldTypeSmallInteger, alias: e_50, editable: true, nullable: true, defaultValue: null, modelName: e_50 )
• e_100 ( type: esriFieldTypeSmallInteger, alias: e_100, editable: true, nullable: true, defaultValue: null, modelName: e_100 )
• e_500 ( type: esriFieldTypeSmallInteger, alias: e_500, editable: true, nullable: true, defaultValue: null, modelName: e_500 )
• flood_exp_idx ( type: esriFieldTypeSmallInteger, alias: Flood Exposure Index, editable: true, nullable: true, defaultValue: null, modelName: flood_exp_idx )
• SLRF_6 ( type: esriFieldTypeSmallInteger, alias: SLRF 6 ft, editable: true, nullable: true, defaultValue: null, modelName: SLRF_6 )
• SLRF_16 ( type: esriFieldTypeSmallInteger, alias: SLRF 16 ft, editable: true, nullable: true, defaultValue: null, modelName: SLRF_16 )
• SLRF_35 ( type: esriFieldTypeSmallInteger, alias: SLRF 35 ft, editable: true, nullable: true, defaultValue: null, modelName: SLRF_35 )
• SLRF_Exposure ( type: esriFieldTypeSmallInteger, alias: SLRF Exposure, editable: true, nullable: true, defaultValue: null, modelName: SLRF_Exposure )
• GAM_Rating ( type: esriFieldTypeDouble, alias: GAM_Rating, editable: true, nullable: true, defaultValue: null, modelName: GAM_Rating )
• GAM_Exposure ( type: esriFieldTypeSmallInteger, alias: GAM Exposure, editable: true, nullable: true, defaultValue: null, modelName: GAM_Exposure )
• CULVERT_COND_062 ( type: esriFieldTypeString, alias: Culverts, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CULVERT_COND_062 )
• sensitivity_idx ( type: esriFieldTypeSmallInteger, alias: Sensitivity Index, editable: true, nullable: true, defaultValue: null, modelName: sensitivity_idx )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Condition )
• Criticality_Score ( type: esriFieldTypeSmallInteger, alias: Criticality Score, editable: true, nullable: true, defaultValue: null, modelName: Criticality_Score )
• priority_idx ( type: esriFieldTypeSmallInteger, alias: Priority Index, editable: true, nullable: true, defaultValue: null, modelName: priority_idx )
• BRDG_NBR ( type: esriFieldTypeString, alias: BRDG_NBR, editable: true, nullable: true, length: 6, defaultValue: null, modelName: BRDG_NBR )
• BSIP_BRDG_ ( type: esriFieldTypeString, alias: BSIP_BRDG_, editable: true, nullable: true, length: 7, defaultValue: null, modelName: BSIP_BRDG_ )
• STRUCTURE_NUMBER_008 ( type: esriFieldTypeString, alias: Structure Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STRUCTURE_NUMBER_008 )
• JoinField ( type: esriFieldTypeString, alias: JoinField, editable: true, nullable: true, length: 255, defaultValue: null, modelName: JoinField )
• PROTECT ( type: esriFieldTypeString, alias: PROTECT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROTECT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: 3
Name: 3
Domains:
Templates:
• Name: 3
  Description:
  Prototype:
  PROTECT: null
  asset_class: null
  RouteID: null
  Route_Name: null
  STIP_ID: null
  MEAN_BeginMp1: null
  MEAN_EndMp1: null
  depth_10: null
  depth_25: null
  depth_50: null
  depth_100: null
  depth_500: null
  e_10: null
  e_25: null
  e_50: null
  e_100: null
  e_500: null
  flood_exp_idx: null
  SLRF_6: null
  SLRF_16: null
  SLRF_35: null
  SLRF_Exposure: null
  GAM_Rating: null
  GAM_Exposure: null
  CULVERT_COND_062: null
  sensitivity_idx: null
  Condition: null
  Criticality_Score: null
  priority_idx: 3
  BRDG_NBR: null
  BSIP_BRDG_: null
  STRUCTURE_NUMBER_008: null
  JoinField: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: 4
Domains:
Templates:
• Name: 4
  Description:
  Prototype:
  PROTECT: null
  asset_class: null
  RouteID: null
  Route_Name: null
  STIP_ID: null
  MEAN_BeginMp1: null
  MEAN_EndMp1: null
  depth_10: null
  depth_25: null
  depth_50: null
  depth_100: null
  depth_500: null
  e_10: null
  e_25: null
  e_50: null
  e_100: null
  e_500: null
  flood_exp_idx: null
  SLRF_6: null
  SLRF_16: null
  SLRF_35: null
  SLRF_Exposure: null
  GAM_Rating: null
  GAM_Exposure: null
  CULVERT_COND_062: null
  sensitivity_idx: null
  Condition: null
  Criticality_Score: null
  priority_idx: 4
  BRDG_NBR: null
  BSIP_BRDG_: null
  STRUCTURE_NUMBER_008: null
  JoinField: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: 5
Domains:
Templates:
• Name: 5
  Description:
  Prototype:
  PROTECT: null
  asset_class: null
  RouteID: null
  Route_Name: null
  STIP_ID: null
  MEAN_BeginMp1: null
  MEAN_EndMp1: null
  depth_10: null
  depth_25: null
  depth_50: null
  depth_100: null
  depth_500: null
  e_10: null
  e_25: null
  e_50: null
  e_100: null
  e_500: null
  flood_exp_idx: null
  SLRF_6: null
  SLRF_16: null
  SLRF_35: null
  SLRF_Exposure: null
  GAM_Rating: null
  GAM_Exposure: null
  CULVERT_COND_062: null
  sensitivity_idx: null
  Condition: null
  Criticality_Score: null
  priority_idx: 5
  BRDG_NBR: null
  BSIP_BRDG_: null
  STRUCTURE_NUMBER_008: null
  JoinField: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: 6
Domains:
Templates:
• Name: 6
  Description:
  Prototype:
  PROTECT: null
  asset_class: null
  RouteID: null
  Route_Name: null
  STIP_ID: null
  MEAN_BeginMp1: null
  MEAN_EndMp1: null
  depth_10: null
  depth_25: null
  depth_50: null
  depth_100: null
  depth_500: null
  e_10: null
  e_25: null
  e_50: null
  e_100: null
  e_500: null
  flood_exp_idx: null
  SLRF_6: null
  SLRF_16: null
  SLRF_35: null
  SLRF_Exposure: null
  GAM_Rating: null
  GAM_Exposure: null
  CULVERT_COND_062: null
  sensitivity_idx: null
  Condition: null
  Criticality_Score: null
  priority_idx: 6
  BRDG_NBR: null
  BSIP_BRDG_: null
  STRUCTURE_NUMBER_008: null
  JoinField: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: 7
Domains:
Templates:
• Name: 7
  Description:
  Prototype:
  PROTECT: null
  asset_class: null
  RouteID: null
  Route_Name: null
  STIP_ID: null
  MEAN_BeginMp1: null
  MEAN_EndMp1: null
  depth_10: null
  depth_25: null
  depth_50: null
  depth_100: null
  depth_500: null
  e_10: null
  e_25: null
  e_50: null
  e_100: null
  e_500: null
  flood_exp_idx: null
  SLRF_6: null
  SLRF_16: null
  SLRF_35: null
  SLRF_Exposure: null
  GAM_Rating: null
  GAM_Exposure: null
  CULVERT_COND_062: null
  sensitivity_idx: null
  Condition: null
  Criticality_Score: null
  priority_idx: 7
  BRDG_NBR: null
  BSIP_BRDG_: null
  STRUCTURE_NUMBER_008: null
  JoinField: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: 8
Domains:
Templates:
• Name: 8
  Description:
  Prototype:
  PROTECT: null
  asset_class: null
  RouteID: null
  Route_Name: null
  STIP_ID: null
  MEAN_BeginMp1: null
  MEAN_EndMp1: null
  depth_10: null
  depth_25: null
  depth_50: null
  depth_100: null
  depth_500: null
  e_10: null
  e_25: null
  e_50: null
  e_100: null
  e_500: null
  flood_exp_idx: null
  SLRF_6: null
  SLRF_16: null
  SLRF_35: null
  SLRF_Exposure: null
  GAM_Rating: null
  GAM_Exposure: null
  CULVERT_COND_062: null
  sensitivity_idx: null
  Condition: null
  Criticality_Score: null
  priority_idx: 8
  BRDG_NBR: null
  BSIP_BRDG_: null
  STRUCTURE_NUMBER_008: null
  JoinField: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query DateBins   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata