Planning Methods II Spring 2012 Exercise 2

Planning Methods II Spring 2012 Exercise 2 - Planning...

This preview shows pages 1–2. Sign up to view the full content.

Planning Methods II – Spring 2012 Exercise 2 1 Exercise 2: Data Analysis with ArcGIS and Excel In this exercise, students will continue to use the “DenverParcelsTractsNeighborhoods2” database to analyze various land use, demographic, geographic, and physical characteristics of the City & County of Denver from the 2010 Census and 2010 Denver Assessor’s Real Property data provided. Using the ArcGIS querying techniques reviewed in class, each student must perform the queries indicated below to generate output data that can be imported into Microsoft Excel to produce graphical exhibits and create thematic maps in ArcGIS that appropriately summarize the data. Exercise 2 is due on Monday, March 26, 2012 and must contain the following elements: Question 1-A : Use the Frequency Tool in ArcGIS to produce a Frequency of Parcels by Land Use Category with Summary Fields of Land Area, Land Value, Improvement Area, Improvement Value, and Total Value . Add New Field to the resulting table and Calculate the Percent of Total for each Land Use category. Export the output as a dBase table and open in Excel. Calculate sum fields for each field (Number of Parcels, Percentage of Total Land Use, Land Use Area, etc.) Format and label the table as necessary for clear presentation.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern