Class Plan (06/16)

Posted by mapz on 3:09 PM

This class project may take more than one class. We will see.

Create a map showing the distribution of median household income (1999) in Tarrant County, TX.

--> Note: Yes this is old data. We will learn how to access current data as soon as this exercise is complete.

Topics to cover:

  1. What are TIGER files?
  2. What are the common boundaries as designated by the U.S. Census Bureau?
  3. What data can be gathered from the decennial Census 2000?
  4. How to extract Census 2000 data from Old American Factfinder?
  5. How to join TIGER 2000 boundaries to Census 2000 data tables?
  6. How to create a choropleth map (color distribution)?

Resources we will explore:
  1. TIGER Files - Topologically Integrated Geographic Encoding and Referencing system
  2. Old American Factfinder

Retrieving Census 2000 Data
  1. Use this guide here - Decennial Data 1990-2000 tab

Preparing Tables for Use Within ArcMap:
  1. There are five rules to remember.
    1. First, there can be only one header row (horizontal row at the top). ArcGIS will interpret the top row as the attribute names and the second row through the end of the table as the data contents. Often times tables may contain 2 or more rows at the top that help to define the contents of each attribute (vertical columns). Other times tables may contain no header row whatsoever. In both of these instances, the tables must be edited so there is one single header row before importing into ArcMap.
    2. Second, the header row can only contain letters, numbers, and underscores. All other characters (including space) will cause errors either when importing into ArcMap or when attempting to be made a permanent part of a feature class.
    3. Third, the header row may not begin with a number. For example, POP2010 is acceptable, but 2010POP may generate errors.
    4. Fourth, save your file in a format ArcMap can read. ArcMap can read a variety of file formats, but the most popular include Excel (.XLS or .XLSX), tab-delimited (.TXT), comma-delimited (.CSV), and dBase table (.DBF).
    5. Fifth, be careful how many characters you use in your header row. If you plan on integrating this table into a shapefile, all headers will be truncated to the first 10 characters.
Tabular Joins
  1. Right-click the layer or table you want to join, point to Joins and Relates, and click Join.
  2. Click the first drop-down arrow and click Join attributes from a table.
  3. Click the second drop-down arrow and click the field name in the layer on which the join will be based.
  4. Click the third drop-down arrow to choose the table to join to the layer. If the table is not currently part of the map, click the Browse button to search for it on disk.
  5. Click the fourth drop-down arrow and click the field in the table on which to base the join.
  6. Click OK.

Export Shapefile to Make Permanent
  1. If you want to permanently save joined data with your geographic features, export the data to a new feature class, right-click the layer in the table of contents, point to Data, and click Export data.
  2. Right-click shapefile, select Data, and click Export Data.