Lab 9 Working with Tables (1)

Lab 9 Working with Tables (1) - 44:005 Foundations of GIS...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
44:005 Foundations of GIS Lab 9: Working with Tables Up until this point in lab we have worked with attribute data lightly. In this lab we will take a closer look at table data, specifically finding appropriate data from the web and working with it in ArcMap. In future work you may be required to find your own data to work with, and it becomes important to understand how ArcMap will read (or won’t read) tables in order to use this data in conjunction with other spatial datasets we have access to. Overview of the exercise… Finding and formatting table data Table statistics Summarize statistics Joins and Relates Add field and Field calculator use I. Obtaining data from the internet The datasets available to you on the GIS servers in Jessup Hall are just a small example of the vast amounts of spatial data that are available for analysis and visualization. While some of these are shapefiles or imagery that you are familiar with, there is a great deal of table data created by agencies such as the U.S. Census Bureau freely available. ArcGIS can read many of these table formats, which include: Excel (.xls), dBase, and Comma- delimited (.csv). Unfortunately, ArcGIS cannot work with tables found in PDF’s. In this lab we will be working with data provided by County Health Rankings , an organization based at the University of Wisconsin dedicated to ranking different factors contributing to the health of a community (more information can be found at: http://www.countyhealthrankings.org/about-project). To obtain the data you will need to use in this lab: Go to http://www.countyhealthrankings.org/Iowa/downloads-and-links Click on the link for the Excel Spreadsheet for “2011 Iowa Data” When table opens in Excel, Save the file as an Excel 97-2003 Workbook to your student folder. (If you get an error, click ‘OK’). There are many different sheets in this workbook. We will work with a subset of the sheet titled ‘Additional Measure Data.’ A copy of this data containing only the portion of interest to us is available on the S-drive in a file called IowaHealth . o If you would like to prepare the data yourself, delete all of the sheets except for Additional Measure Data . Delete these columns: FIPS, State, % diabetic, HIV rate, Physical inactivity, % with high housing costs, children eligible, % illiterate and % of labor force that drives alone 44:005 Lab 9 Working with Tables Pg 1 of 9
Background image of page 1

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

View Full Document Right Arrow Icon
II. Formatting Excel table Before you can add your table to ArcMap you need to format the table in Excel so it can be used effectively. The following are a list of guidelines for preparing your table for effective use in ArcGIS.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 9

Lab 9 Working with Tables (1) - 44:005 Foundations of GIS...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online