View In:   ArcGIS Online Map Viewer

Name: Hazardous_Roadway_Overtopping_Edit

Display Field: StreamName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Hazardous Roadway Overtopping Locations:SummaryThis layer contains the locations in City of Fort Worth, which experience repeated flooding due to water overtopping from adjacent streams and water ponding due to inadequate storm drain conveyance system. Most of these locations were originally identified and studied by Deotte, Inc. in 2005 in order to develop a risk based priority. This priority was being used by the city for managing flood warning systems. However, a need for a comprehensive program to improve the existing infrastructure at these locations was recognized in order to reduce the number of such frequently flooded locations which would in turn enable relocating the flood warning system to other locations that didn’t have a warning system before. This led to the development of Hazardous Roadway Overtopping Mitigation program based on a revised scoring methodology and while incorporating more storm water incidents observed in the city since Deotte’s study. Freese and Nichols assisted the city with reprioritizing the locations based on hazard, developing cost estimates, and scoring the feasibility of providing infrastructure improvements for high priority hazardous overtopping locations.Contact persons: Naven Kathuroju, Kiran KonduruDescriptionThe following are the metrics and the scoring system used to compute the hazard based score:Depth of Flow over Road:DepthPoints0-1’51’-3’8>3’10Frequency of Overtopping:FrequencyPointsInfrequent1Frequent4>3’10Stormwater Incidents:IncidentPointsComplaints0.5Rescue5Fatality10Flooding or Downstream Threat:DS ThreatPoints0-10%210-50%850-100%10The scoring based on these metrics is added and sorted among all locations for ranking purposes. A low rank or a high score indicates high hazard.Contact person: Naven Kathuroju, Kiran Konduru

Copyright Text: Freese and Nichols

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: 2255737.9629757553
YMin: 6896009.038037673
XMax: 2412124.4920655936
YMax: 7052158.208350256
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SiteID ( type: esriFieldTypeSingle, alias: Site ID, editable: true, nullable: false, defaultValue: null, modelName: SiteID1 )
• Site_Desc ( type: esriFieldTypeString, alias: Site Description, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Site_Desc )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Address )
• StudiedHRO ( type: esriFieldTypeString, alias: StudiedHRO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StudiedHRO , Coded Values: [FNI: FNI] , [SEE: SEE] , [None: None] )
• Fatality ( type: esriFieldTypeInteger, alias: Fatality, editable: true, nullable: true, defaultValue: null, modelName: Fatality )
• FatalityPts ( type: esriFieldTypeInteger, alias: FatalityPts, editable: true, nullable: true, defaultValue: null, modelName: FatalityPts )
• Rescue ( type: esriFieldTypeInteger, alias: Rescue, editable: true, nullable: true, defaultValue: null, modelName: Rescue )
• RescuePts ( type: esriFieldTypeInteger, alias: RescuePts, editable: true, nullable: true, defaultValue: null, modelName: RescuePts )
• Complaints ( type: esriFieldTypeInteger, alias: Complaints, editable: true, nullable: true, defaultValue: null, modelName: Complaints )
• ComplaintPts ( type: esriFieldTypeSingle, alias: ComplaintPts, editable: true, nullable: true, defaultValue: null, modelName: ComplaintPts1 )
• Score ( type: esriFieldTypeSingle, alias: Score, editable: true, nullable: true, defaultValue: null, modelName: Score1 )
• Priority ( type: esriFieldTypeSingle, alias: Priority, editable: true, nullable: true, defaultValue: null, modelName: Priority1 )
• Ex_Size ( type: esriFieldTypeString, alias: Ex_Size, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Ex_Size )
• OPCC_Planning_Level ( type: esriFieldTypeInteger, alias: OPCC_Planning_Level, editable: true, nullable: true, defaultValue: null, modelName: OPCC_Planning_Level_1 )
• HWWS ( type: esriFieldTypeString, alias: HWWS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HWWS , Coded Values: [Y: Yes] , [N: No] )
• Traffic_Count_2018 ( type: esriFieldTypeString, alias: Traffic_Count_2018, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Traffic_Count_2018 )
• Traffic_Count_Source ( type: esriFieldTypeString, alias: Traffic_Count_Source, editable: true, nullable: true, length: 35, defaultValue: null, modelName: Traffic_Count_Source , Coded Values: [NCTCOG: NCTCOG] , [CFW Traffic: CFW Traffic] , [DeOtte : DeOtte] , ...1 more... )
• Hazard_Concealment ( type: esriFieldTypeInteger, alias: Hazard_Concealment, editable: true, nullable: true, defaultValue: null, modelName: Hazard_Concealment )
• Detour_Length ( type: esriFieldTypeString, alias: Detour_Length, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Detour_Length , Coded Values: [<3 blks: <3 blks] , [3 blks-0.5 mile: 3 blks-0.5 mile] , [>0.5 mile: >0.5 mile] )
• StreamName ( type: esriFieldTypeString, alias: StreamName, editable: true, nullable: true, length: 60, defaultValue: null, modelName: StreamName )
• FEMA_Floodplain ( type: esriFieldTypeString, alias: FEMA_Floodplain, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FEMA_Floodplain , Coded Values: [Y: Yes] , [N: No] )
• StreetType ( type: esriFieldTypeString, alias: StreetType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: StreetType , Coded Values: [Collector: Collector] , [Arterial: Arterial] , [Neighborhood: Neighborhood] )
• CouncilDistrict ( type: esriFieldTypeSmallInteger, alias: CouncilDistrict, editable: true, nullable: true, defaultValue: null, modelName: CouncilDistrict , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...6 more... )
• SMMA ( type: esriFieldTypeString, alias: SMMA, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SMMA , Coded Values: [Y: Yes] , [N: No] )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Jurisdiction , Coded Values: [TXDOT: TXDOT] , [CFW SW: CFW SW] , [CFW Parks: CFW Parks] , ...4 more... )
• BarricadedTotal ( type: esriFieldTypeInteger, alias: BarricadedTotal, editable: true, nullable: true, defaultValue: null, modelName: BarricadedTotal )
• Issue_Type ( type: esriFieldTypeString, alias: Issue_Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Issue_Type , Coded Values: [Sump: Sump] , [Stormdrain issue: Stormdrain issue] , [Stream overtopping: Stream overtopping] , ...2 more... )
• ExistingLOS ( type: esriFieldTypeString, alias: ExistingLOS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ExistingLOS , Coded Values: [1yr: 1 yr] , [2yr: 2 yr] , [5yr: 5 yr] , ...4 more... )
• ProposedLOS ( type: esriFieldTypeString, alias: ProposedLOS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ProposedLOS , Coded Values: [1yr: 1 yr] , [2yr: 2 yr] , [5yr: 5 yr] , ...4 more... )
• ImprovedLOS ( type: esriFieldTypeString, alias: ImprovedLOS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ImprovedLOS , Coded Values: [1yr: 1 yr] , [2yr: 2 yr] , [5yr: 5 yr] , ...4 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Status , Coded Values: [Blank: Blank] , [Completed: Completed] , [Construction: Construction] , ...3 more... )
• Improvement_Type ( type: esriFieldTypeString, alias: Improvement_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Improvement_Type , Coded Values: [ Blank: Blank] , [Major: Major] , [Other: Other] , ...2 more... )
• Existing_Safety ( type: esriFieldTypeString, alias: Existing_Safety, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Existing_Safety , Coded Values: [Flashers: Flashers] , [Guardrails: Guardrails] , [Lighting: Lighting] , ...2 more... )
• Proposed_Safety ( type: esriFieldTypeString, alias: Proposed_Safety, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Proposed_Safety )
• Funding_Partner ( type: esriFieldTypeString, alias: Funding_Partner, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Funding_Partner )
• Report_2019 ( type: esriFieldTypeString, alias: Report_2019, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Report_2019 )
• Report_2005 ( type: esriFieldTypeString, alias: Report_2005, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Report_2005 )
• Ext_Coord_POC ( type: esriFieldTypeString, alias: External Coordination Point of Contact, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Ext_Coord_POC )
• Ext_Coord_Date ( type: esriFieldTypeDate, alias: External Coordination Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Ext_Coord_Date )
• General_Notes ( type: esriFieldTypeString, alias: General_Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: General_Notes )
• Year_Added ( type: esriFieldTypeSmallInteger, alias: Year_Added, editable: true, nullable: true, defaultValue: null, modelName: Year_Added )
• Year_Studied ( type: esriFieldTypeSmallInteger, alias: Year_Studied, editable: true, nullable: true, defaultValue: null, modelName: Year_Studied )
• Improved ( type: esriFieldTypeString, alias: Improved, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Improved , Coded Values: [Y: Yes] , [N: No] )
• SEE_Hazard ( type: esriFieldTypeString, alias: SEE_Hazard, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SEE_Hazard , Coded Values: [Y: Yes] , [N: No] )
• SEE_Notes ( type: esriFieldTypeString, alias: SEE_Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SEE_Notes )
• Edited_By ( type: esriFieldTypeString, alias: Edited_By, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Edited_By , Coded Values: [Ranjan: Ranjan] , [Ford: Ford] , [Kiran: Kiran] , ...1 more... )
• Edited_Date ( type: esriFieldTypeDate, alias: Edited_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Edited_Date )
• D_MTP ( type: esriFieldTypeString, alias: MTP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: D_MTP )
• D_TrafficPnts ( type: esriFieldTypeDouble, alias: TrafficPnts, editable: true, nullable: true, defaultValue: null, modelName: D_TrafficPnts )
• Site_ID ( type: esriFieldTypeString, alias: Site_ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Site_ID )
• D_Depth ( type: esriFieldTypeSingle, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: D_Depth1 )
• D_DepthPts ( type: esriFieldTypeSingle, alias: DepthPts, editable: true, nullable: true, defaultValue: null, modelName: D_DepthPts1 )
• D_DSThreat ( type: esriFieldTypeSingle, alias: DSThreat, editable: true, nullable: true, defaultValue: null, modelName: D_DSThreat1 )
• D_DSThreatPts ( type: esriFieldTypeSingle, alias: DSThreatPts, editable: true, nullable: true, defaultValue: null, modelName: D_DSThreatPts1 )

Templates:

• Name: Hazardous_Roadway_Overtopping_Edit
  Description:
  Prototype:
  D_DSThreat: null
  D_DSThreatPts: null
  SiteID: 0
  Site_Desc: null
  Address: null
  StudiedHRO: null
  Fatality: null
  FatalityPts: null
  Rescue: null
  RescuePts: null
  Complaints: null
  ComplaintPts: null
  Score: null
  Priority: null
  Ex_Size: null
  OPCC_Planning_Level: null
  HWWS: null
  Traffic_Count_2018: null
  Traffic_Count_Source: null
  Hazard_Concealment: null
  Detour_Length: null
  StreamName: null
  FEMA_Floodplain: null
  StreetType: null
  CouncilDistrict: null
  SMMA: null
  Jurisdiction: null
  BarricadedTotal: null
  Issue_Type: null
  ExistingLOS: null
  ProposedLOS: null
  ImprovedLOS: null
  Status: null
  Improvement_Type: null
  Existing_Safety: null
  Proposed_Safety: null
  Funding_Partner: null
  Report_2019: null
  Report_2005: null
  Ext_Coord_POC: null
  Ext_Coord_Date: null
  General_Notes: null
  Year_Added: null
  Year_Studied: null
  Improved: null
  SEE_Hazard: null
  SEE_Notes: null
  Edited_By: null
  Edited_Date: null
  D_MTP: null
  D_TrafficPnts: null
  Site_ID: null
  D_Depth: null
  D_DepthPts: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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