Special Topics: Lab 5

Lab 5 covers Vehicle Routing Problem and how adjusting setting and routes, it impacts how many stops and routes will be produced.  To start the analysis, I added the customer information for the orders.  I adjusted the parameters for pick up times and other parameters.  Next I added the distribution center for the depot.  I set the parameters for when the depot can be stopped at.

Next I added the routes I loaded the truck information.  For the route properties, I adjusted when the route can start, the cost per mile and cost per minute, assignment rules, and the maximum capacity.  I added route zones and adjusted the parameter to True so routes stay to the correct zone.  U-turns were also not allowed for the routes.

Finally, I ran the Solver and 6 orders were not reached.  To fix this, I adjusted the properties for Truck 15 and 16 to "include" the assignment rule.  Previously, they were set to exclude which meant forced the routes to only pick up orders assigned to that truck.

After adding the new routes, below is a screenshot of the new routes which services all orders.  Only one exceeds the time limit.  Customer service will increase since every order is taken care of and only one time violation.

Improved Routes

Special Topics: Lab 4

This week's lab looked at create new network datasets and adjusting the analysis settings.  I created a network dataset that used streets as the participating feature class.  I selected to model turns, but did not use restricted turns.  I used elevation fields, but did not select to use traffic modeling.  Once all the settings were adjusted, I built the network dataset.

In ArcMap, I added the recently created network dataset.  I enabled the network analysis and created a new route.  To create the route, I had to load the facilities for the stops.  The impedance was set to minutes and the stops were able to be reordered to find the fastest route.  However, the first and last stop had to remain the same.  The only restriction was one ways.

Next, I added the restricted turns to the Turn settings and rebuilt the network dataset.  In ArcMap, I added the streets and restricted turns layers.  I used the same network analysis setting as previously, and resolved the route.  By adding restricted turns, the route has to adjust slightly to find a new route.

Restricted Turns

The final route analysis required to build a new network analysis.  This time, I used traffic modeling.  I made sure to adjust all of the traffic settings.  The traffic data looked at speeds, and level of traffic.  It contains the free-flow speeds. The network analysis settings were the same was the other two routes.  With adding traffic information the route is adjusted to traffic speeds.  Previously, that information was not included in the travel time.

Traffic Data

Special Topics: Lab 3

This week's lab focused on analyzing the completeness of road networks.  I compared how complete the street centerlines and TIGER roads are for Jackson County.  Below is how I performed this analysis.

I needed to calculate the distance of the roads for both shapefiles.  I did this by adding a field and used Calculate Geometry.  This calculated the distance of each road segment in kilometers.  Next, I needed to find the roads that fall within the Grid shapefile.  To do this, I used the intersect tool to create a new shapefile that had all the road segments that intersect with the grids.  I used the tool on both the street centerlines and TIGER roads.

Once I had the new shapefiles of roads only within the grids, I had to recalculate the distance of the roads.  I used the calculate geometry tool again.  I then exported each attribute table of the new distance.  I found the difference between the length of road and also found the percentage.  Below is a table.

The map below shows the absolute difference between the roads completeness.  

Road Completeness Analysis

Special Topics: Lab 2

Lab 2 covered the National Standard for Spatial Data Accuracy.  The lab looked at junction points for two data sets.  To perform this lab, I needed to create two new Data set Networks for the street shapefiles.  I selected over 85 points of the junction shapefile for the city and over 85 for the USA street shapefile.

After selecting the points, I exported the points into new shapefiles.  I then added orthophotos to see where the true intersections are located.  Zooming into each pair a test points, I found the true location and added a reference point.  I did that for all points.  A unique identifier was applied to all three data sets.  I used the Add X Y Coordinates to the attribute tables.

I exported the attribute tables for the three shape files and inserted the data into the Horizontal Accuracy spreadsheet.  This spreadsheet found the difference between the X and Y coordinates.  The differences were squared and summed.  The Root Square Mean Error was also calculated and multiplied by 1.7308 for the standard error.  This was done for the city data points and the street data points.

City:
Positional Accuracy: Using the National Standard for Spatial Data Accuracy, tested 30.64 feet horizontal accuracy at 95% confidence level.
USA Street:
Positional Accuracy: Using the National Standard for Spatial Data Accuracy, test 62.67 feet horizontal accuracy at 95% confidence level.

Test Points