Wednesday, November 12, 2014

The purpose of this script is to look at the sand mines in Wisconsin and the effect the transportation of the sand is having on the road ways by county. In order to do this we first made defined our variables. All this doing is making abbreviated names for the actual names of the data so it is easier to make a script. We then had to make a selection. We are only interested in the active mines because non active mines won't be transferring sand. We want to exclude the active mines with rail lines connected to them because they will be putting the sand directly to the rail instead of over the roads. This created a new feature class with active mines with no rail lines.Once we had this we wrote part of the script to makes make sure only the mines in Wisconsin are selected and then of those mines the ones that do not have a rail with in 1.5 kilometers are the ones we want. So finally we end up with active mines in Wisconsin that do not have a rail within 1.5 kilometers of the plants. Once we ran the script I ended up with 41 mines in my new feature class.