View In:
ArcGIS Online Map Viewer
Name: Final Flood Prone Roads
Display Field: road_nam
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P STYLE="margin:0 0 11 0;"><SPAN>Coastal- "Flood Prone Communities", Coastal- "Nuisance Flooding Locations", Inland- "Flood Prone Roads", Inland- "Critical Structure Maintenance", Inland- "Storm Event Road Closure”, Modelled- "Potential Roadway Overtop Location". </SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN>This layer was initially developed by WPRP in 2019 by conflating several datasets with information regarding frequently flooded roads. Between July and December of 2019, BOH GIS Intern Adam Mills updated this layer by verifying the existing data points in the layer, as well as adding new data to meet the expanding needs of BOH. This layer was added to an ArcMap MXD and then the STATUS field was added to the attribute table, which used coded data values to indicate if the point was confirmed as flooded or not in the past. In order to verify points already existing in the layer, other layers were used for verification (EOC Historic Flooded Roads, DPW WPRP Potentially Overtopped Crossings, and Flood Prone Communities). In addition to adding these layers to the ArcMap MXD, other support layers were added such as street centerlines, culverts, bridges, streams, aerial photos, ADC Grids, address points, outfalls/inlets, road district yard boundaries, and the County boundary. These layers contributed to where points should be placed by indicating potential areas that could flood. Adam also utilized data outside of ArcMap to verify points, such as legacy PDF maps containing aerial photos of flood plains and Microsoft Excel spreadsheets (Nuisance_Storm Road_Community Flood Locations 7_2019 and Fld Prone Rds_Must Chk Locations 1_2018). In this process, Adam found points that were not in the layer and added them at the appropriate locations, making note of the addition in the COMMENTS field. The next step was reviewing the the 5 year and 10 year emergency service request (ESR) list Microsoft Excel spreadsheets in to identify all the areas where flooding had occurred in the past. Once all the data had been reviewed, Adam created a Feature Dataset and imported the layer in, as well as the street centerline layer, and created a Topology. This identified all points not snapped to the street centerline. At the request of Alex Baquie, BOH Director, Adam then went through all the points again to organize them into 3 categories, which were represented by a coded data value. Eventually additional data was provided by Alex in the 8 Roadway Categories Excel sheet, which Adam went through to add any points not already listed. From there, all the points were categorized into 8 categories, but would be condensed into 6 (at Alex’s request) for the final layer. These 6 categories are attributed in the STATUS field as Coastal- Flood Prone Communities, Coastal- Nuisance Flood locations, Inland-Flood Prone Roads, Inland- Critical Structure Maintenance, Inland- Storm Event Road Closures, and Modeled- Potential Roadway Overtop Locations. The Coastal-Flood Prone Communities category is represented by a separate polygon file that already existed (supplied by WPRP), while the other 5 categories are the points of this layer.</SPAN></P></LI></UL></DIV></DIV></DIV>
Service Item Id: 63603c5e26384a5d91a042794ecdef47
Copyright Text: Anne Arundel County Office of Emergency Management GIS (Geographic Information Systems)
Anne Arundel County, Watershed Protection and Restoration Program
Anne Arundel County, Department of Public Works, Bureau of Highways:
Adam Mills, BOH GIS Intern - map layer author. 410-222-1465, pwmill26@aacounty.org
Wayne McCready, BOH IMD GIS Specialist - project review. 410-222-0561, pwmccr48@aacounty.org
Jeff Cox, BOH IMD GIS Program Manager - project oversight. 410-222-4163, pwcox000@aacounty.org
Alex Baquie, BOH Director - project guidance. 410-222-7045, pwbaqu11@aacounty.org
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
XMin: -8553534.092586992
YMin: 4680725.356305279
XMax: -8507431.594793905
YMax: 4754673.298389591
Spatial Reference: 102100
(3857)
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: false
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: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
objectid
(
nullable: false, editable: false, defaultValue: null, alias: OBJECTID, type: esriFieldTypeOID
)
-
road_nam
(
nullable: true, editable: true, defaultValue: null, length: 25, alias: Road_Nam, type: esriFieldTypeString
)
-
intersects
(
nullable: true, editable: true, defaultValue: null, length: 25, alias: Intersects, type: esriFieldTypeString
)
-
source
(
nullable: true, editable: true, defaultValue: null, length: 25, alias: Source, type: esriFieldTypeString
)
-
floodrisk
(
nullable: true, editable: true, defaultValue: null, length: 50, alias: FloodRisk, type: esriFieldTypeString
)
-
roadstreamcrossingid
(
nullable: true, editable: true, defaultValue: null, length: 50, alias: RoadStreamCrossingID, type: esriFieldTypeString
)
-
status
(
nullable: true, editable: true, defaultValue: null, length: 7, alias: STATUS, type: esriFieldTypeString
, Coded Values:
[01: Inland- Flood Prone Roads]
, [05: Coastal- Nuisance Flood Locations]
, [07: Inland- Critical Structure Maintenance]
, ...2 more...
)
-
comments
(
nullable: true, editable: true, defaultValue: null, length: 250, alias: COMMENTS, type: esriFieldTypeString
)
-
globalid
(
nullable: false, editable: false, defaultValue: null, length: 38, alias: globalid, type: esriFieldTypeGlobalID
)
Templates:
-
Name: Final Flood Prone Roads
Description:
Prototype:
comments: null
intersects: null
road_nam: null
floodrisk: null
source: null
status: null
roadstreamcrossingid: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Sync
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Attachments
Query Analytic
Query Top Features
Query Bins
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata