Planning Methods II Spring 2012 Exercise 2

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

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

View Full Document Right Arrow Icon
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.
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern