In this blog I did data analysis to see which road dataset was more complete within a grid. The first thing I did was use the Projection tool to project the Tiger Road data to be the same as the Centerline.
Next I used the summarize within tool. When using this tool I set the input polygon as grid and the input summary feature at the tiger roads polygon. For the summary fields I used the LengthinKM field I created to generate the length in Km of the roads and for the statistic I chose sum. In shape unit I used KM. This left me with a table with the sum of roads within each grid. I did the same analysis for the centerline roads data. When both of these were complete I created 2 new fields in the grid: Tiger, for the tiger roads sum, and centerline, for the centerline roads sum.
I joined the summary table of each of the roads to the grid and calculated the field with the summary data. I then created another field for my percent difference calculation. I used the calculate field tool to run this formula.
For symbology I wanted to have a graduated color ramp to show the difference in percentage. I chose to use Natural Breaks with 7 different breaks in the data.
No comments:
Post a Comment