Land Use Analysis

1. Land Use Analysis An important aspect of any GIS is the use of analysis. Analysis helps us to say something meaningful about the work that we have done, and it makes the work uniquely ours. Paper maps have been made for years, but it’s your work that creates a unique GIS. In this section, we are going to work through some analysis of your school and the way that the land is used on your campus. For this, we will need both ArcGIS and Excel.

2. Land Use on Campus Your final task is to create a pie chart to show the relative amount of land on campus dedicated to various functions.

3. Create a table in Excel resembling the one above. Now open your ArcGIS Project. • You can minimize your Excel spreadsheet while you go back to work in ArcGIS, if you wish. 1. For this exercise you will need to open Microsoft’s Excel spreadsheet application in addition to your workspace in ArcGIS.

4. 4. Right-click on the word parking-lot and open attribute table. 5. Click on the Options button and select “Add Field.”

5. 6. Type “area” in the name box, then select “Double” as the type. Click OK

6. 7. Go to the Editor button and Start Editing. Select the location of the shapefiles from your GPS and click OK. 8. Right click on the area field and choose “Calculate Values.”

7. 9. Our school features have been created using latitude and longitude coordinates, which we measure in degrees. We don’t want our “area” measurement to be in “square degrees” – no one would know what you are talking about!! The script above will calculate area based upon the coordinate system of our data frame, which is measured in meters. Click this link to open a text version of the script; copy the script and paste it in the Pre-Logic VBA Script code box.

8. 10. In the “area =“ field, type “dArea”. This tells ArcGIS which variable in the script will contain the final area calculation. Click OK. 11. The area measurement, in square meters, will appear in the area column. Repeat this process for all of your polygon features.

9. 13. Right-click on Function and select Summarize…. 12. The next step will sum up the area for each building function. Open the attribute table for Buildings

10. 14. Select Function as the field to summarize and check Sum under area. Click OK. 15. Click Yes to add to the map.

11. 16. In your legend you should see something called Sum_output with a number. Right-click on it and select Open. 17. Notice that all of your academic area has been summed, as well as athletic area, etc.

12. Total athletic area = Sum of athletic buildings + Sum of athletic fields. Total athletic area = 1861.3174 + (10287.232336 + 2132.350417 + 5026.44319) Total athletic area = 1861.3173 + 19307.343343 Total athletic area = 21168.66743 Place the total in the appropriate category in the Excel spread sheet. 18. Sum up all of your categories of your polygon features as in this example.

13. 19. After entering your area sums in the Excel table, calculate the total area of all categories. 20. For the Area Percentage, divide the category area by the total. Example: Athletic Area Percentage = (21168.66074 / 36523.60615) * 100 = 0.579588463 * 100 = 58%

14. 21. Highlight all of the cells of your table other than “Total”. 22. Click on the Chart Wizard button.

15. 23. Select Pie for your Chart type. Click “Next”. 24. Click “Next”.

16. 25. You can type in a new title here if you like. After changing your title, click Next. 26. You may select either to have the chart in a new worksheet, or in the same sheet as your table. Click finish.

17. 27. Your pie chart will appear in your worksheet. Double-click on the “pie.” 28. Select the Data Labels tab and check Percentage.

18. Your final step is getting your work into presentation form. Chapter 12 will help you with creating an interesting map.