Problem:
Linear Referencing is a mechanism that allows me to associate multiple sets of attributes to the portion of linear features like roads, highways, pipeline or railways. etc. A route is a linear feature associated with several other features that has unique identifier and a measurement system stored with its geometry.
Pitt County of NC road data has been provided. There are 3 different kind of roads feature layer of NC Pitt county like all routes, just routes and some routes including Pitt county and cities feature layer. Accident and Pavement dbf file has been provided for the routes. I need to project the accident and pavement data for a NC route no 30 on the map and superimpose the data on the map to clarify the problem on NC route 30 and try to solve the problem.
Analysis Procedure:
Arc GIS 10.4 module had been used to solve this problem. Pitt county, city boundaries, roads, routes and their segments Data has been provided from NCSU GIS 520 web course. Accident points, route segments and their pavement type had also been provided from web course. After reviewing the data in Arc catalogue, I matched the accidents data with the pavement and overlay the resulting information to the routes to visualize. In order to make a link with the route data with county dataset, I needed to create route event layer first and made a feature layer out of it for both accidents and pavement type. In order to make a correlation between pavement and accident type, both layer had to be intersected at each other by overlaying route events. Then I needed to visualize this in the map, for this purpose I created another route event layer, so that I saw there is a correlation with route condition and accidents.
Workflow Diagram
Results:
Application and Reflection:
In my point of view, stream or river data from usgs.gov can be used as feature layer of a county or city. Pollution table in those river or stream can be used as event table and factories’ sewerage pipeline data parallel to the river or stream can be used as another table. Then pollution table and factories’ sewerage pipeline data retrieved from local government would have been used to make an event feature layers. Then by overlaying route events layer tool Pollution level in the river or stream and factories’ sewerage pipeline data along the river with the common river or stream field, both data can be intersected. Then again making a combined feature layer we can corelate both data and clarify the problem and try to solve problem. Data can be found from US.gov and Tiger line data.