geo3710 attributedata_lab7_pricePro2e-1-1

Lab 7 Attribute Data Points: 100 Objectives: Understanding how to create, edit, and use tables in a GIS is critical to utilizing its most important toolset – spatial data analysis. This chapter introduces you to attribute tables and standalone tables . You will be exposed to many aspects of tables and will begin to learn how to answer questions related to the data stored in tables. Specific objectives include:  Understand how tabular data are stored in a GIS and database  Using queries to select records of interest  Edit and calculate fields in tables  Define appropriate field properties  Learn to calculate statistics, and create summary statistics for table fields  Understand joins and cardinality relationships.  Create joins and relates between tables  Generating point layers from x-y coordinates in tables You will be performing some of the tutorial and exercises in Chapter 7 of the lab manual, Mastering ArcGIS Pro, Second Edition , written by Dr. Maribeth Price. Instructions: 1. ATTRIBUTE DATA Review the Concepts section for Chapter 7: Attribute Data. Answer questions 1 – 5, and 7 in the Chapter Review Questions (p. 226 - 227). Accomplish the Mastering the Skills / Teaching Tutorial section. You are NOT REQUIRED to turn in the answers. Complete PRACTICE EXERCISES 1, 2, 4, 5, 7 (p. 243). 2. Utah Demographic Data Challenge Problem Download the Lab7-SGID100_CountyBoundaries_stand-table.zip file from the Canvas assignment 7 link and put it in your working directory. This zip file contains all the files associated with the Utah county boundaries shapefile ( SGID100_CountyBoundaries.shp ) and the standalone table file , utah-census2000-popul_area-corrected-students.dbf . Unzip the file by double-clicking on it and extract the files to your folder. 1

Accomplish the following tasks: 1. Export the County Boundaries shapefile ( SGID100_CountyBoundaries.shp ) to the project geodatabase as a polygon feature class (Ensures the Shape_Length and Shape_Area fields are accurate). 2. JOIN the attribute table for the County Boundaries polygon feature class to the standalone table ( utah-census2000-popul_area-corrected-students.dbf ). 3. Population Density a. Create a new attribute field in the joined table called “POP_DEN” . Set the field up with the following parameters i. Float field type ii. Following numeric settings b. Populate the POP_DEN field by calculating the population density based on the total area (in square miles) of each county (based on Shape_Area field. i. BE SURE you know what area units these values represent….you may have to do some calculations) . ii. Hint: Create a new attribute field (AREA_SQMI) in the joined table. Use “Calculate Field” in table view to generate area value in square miles. iii. Calculate POP_DEN using the AREA_SQMI field. 2