Network Analysis

The goal of this project is to create a network analysis about the truck traffic that will happen on the Wisconsin roads from the excess traffic created from the frac sand mines. We can also calculate roughly the amount of money that it will implement on the counties from the extra road traffic. The network analysis model that is created will show the shortest distance from the mines to the mine distribution rail system



 

To begin this exercise I imported the base map of Wisconsin as well as topographic data and county data. I overlaid the county data and made it transport while keeping the outline opaque in order to create a see through version of the counties without having to extract a second layer. I did however create an attribute layer of just Trempleau county since this is an area of interest. From here I started the network analyst tool. I had to set the mines as incidents and the rail loading terminals as facilities since the mines will be going towards the facilities not facilities to mines. From here I had Arc Map solve the closest distance between the mines and the loading terminals.

 

This represents the incidents and facilities
in a network analyst map.
the quickest route from incidents to facilities is in yellow.

I also created a data model out of Data Model builder to build a network analyst quickly that can be used over and over again. This data model uses the same tools from ArcGIS that can be used separately with the same result however this allows the data model to be implemented multiple times and can be edited to suit different needs. Here I have it creating the best possible route from the frac mines to the rail distribution centers.

The Data model to create the quickest route

 



The results from the model builder.
note that this model builder includes all facilities and incidents
this will require some editing to remove the unneeded facilites and incidences

This is the final product that results from the use of my data model and from the network analysis of the county data and frac mines. We can see the quickest route and have a total distance in the form of time measurement. We can also calculate the amount of damage that the extra truck traffic is having on the county roads.

 



 These are the three final maps that I created using the Network Analyst tool and Model Builder

 

 This map showcasees all the frac mines to the distribution plants

This network analyst map showcases the Truck routes that will pass through
Trempealeau County on their way to a distribution rail system.
with this map we can calculate the total cost that was placed on the roads of
Trempealeau county.

 This is the final map showing all the quickest routes from the frac mines
to the distribution rail systems.

The results that are from the network analyst map shows the quickest route from the mines to the distribution plants. the way that this is significant is that it shows the quickest route and hence it is the cheapest route that the mine would be interested in making since it will cut into the profit margin less. This also shows the total amount of road maintenance that a frac sand mine may have on a county so they can be taxed to offset the amount of damage that the heavy truck traffic will have on the road systems.

 The total amount of cost for all of the routes in wisconsin
calculated using the ArcGIS network analyst tool.

 Using the total time coluom in the Trempealeau county data we can
calculate the total cost on the roads from the frac mine routes.

 

Using ArcGIS and Network analyst with model builder we can create a many multi layered projection of the quickest routes from frac mines to the rail distribution centers. This also allows us to calculate the total distance and we can then in turn create a projected cost that the trucks will have on the roads. This shows how powerful of a tool network analyst can be.