Problem:
The goal of this project is to evaluate accidents that happened along a specific route in Pitt County. Additionally, pavement ratings could be evaluated to determine if they were impacting accident rates. This assignment also allowed the users to get familiar with customizing the ArcGIS Pro ribbon and using linear referencing tools.
Analysis Procedures:
ArcGIS Pro was used to perform a series of linear referencing tools including: Make Route Event layer, Overlay Route Events (and subsequently a Python code), and Identify Route Locations. The data used for this assignment was provided by the instructor of GIS 520. This data included a geodatabase for Pitt County, routes in Pitt County, city and county shapefiles and tables of accidents and pavement data.
First the provided data was added to the map. Initially this included: county, cities, all route, just roads and some routes. After the different route layers were explored, it was decided that some routes would be used for simplicity. Next, the accident table was added to the map and accidents along Route1=30000030 were selected. After this was examined a layer was created from the table in order to see the accidents geospatially. This was done using the Make Route Event layer tool. This process was then repeated for the pavements table to determine how many miles along Route1=30000030 had a rating above and below 75. Finally, the accidents and pavements layers were intersected in order to have all the information in one table regarding a route. This intersect was performed by running a python code under the analyze tab in ArcGIS Pro. This intersect allowed us to determine the number of accidents along Route1=30000030 that occurred on a portion of the road with a rating of <=75 and a rating of >75.
Application and Reflection:
The assignment has taught me how to use linear referencing to examine both types of route events (points and lines). I also learned how to combine these two types of files using python since ArcGIS Pro does not currently have the capability to overlay point and line route events. A situation I could see using these tools would be evaluating stream reaches and in stream structures. In stream restoration, practitioners often times put in stream structures as part of the design, examples include riprap, vanes and weirs. Streams reaches (a length of stream segment) can also be categorized with a type or health rating. If a company had shapefiles for streams prior to restoration and after restoration, we could use the stream reaches (line route events) with associated health rating to compare the health ratings of the stream reaches using the Overlay Route Events tool and creating a field in the attribute table to calculate the difference in health rating. Additionally, the in stream structures (point Route Event) could be overlayed (using python code) with the two stream reach route events to determine if in stream structures are impacting the overall health (or the difference in health) of the streams.
Spatial Problem Solving Portfolio 