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".

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.