Introduction

In a previous post (http://travisflohr.com/2016/10/05/arcgis-census-basics/) I talked about basic census concepts and how to map them. In this series of tutorial videos I will illustrate how to exact basic trends across three different decades of census information. To accomplish this you will need to have compiled (i.e. joined your census tables to your shapefiles). If you need help joining tables, see the aforementioned link.

tf_tutorials_arcmap_excel_graphing_census_trends_800_125

Downloads

If you are student in UW-Madison Land Arc 462 Regional Design studio I have provided you all the requisite census GIS data for your assignment. To follow along with these videos you will need a census variable from three different census. For example, I will be evaluating population density from 1990, 2000, and 2010. However, if you are interested in acquiring different census data, you can do so in the following locations:

  • https://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml – FactFInder is the official US Census website. However, I find it hard to navigate and search their website. Additionally, their data downloads are hard to use and requiring additional processing to obtain useful information.
  • https://www.nhgis.org/ – I encourage my students to obtain US Census data from the National Historic GIS (NHGIS) organization  at the University of Minnesota. NHGIS has the same data as FactFinder, but their website is easier to navigate and search. They process the data so use in GIS software is intuitive and easy. They also have tutorial videos for how to use their website.

Tutorial outline

The tutorials are organized as follows:

  1. ArcMap attribute table field statistics to Excel (for very small amounts of data)
  2. ArcMap attribute table copy and paste to Excel (for medium amounts of data)
  3. ArcMap attribute table export to dBase (.dbf) file to Excel (for large amounts of data)
  4. Excel – creating pivot table
  5. Excel – creating graphs

Topic 1: ArcMap attribute table field statistics to Excel

Topic 2: ArcMap attribute table copy and paste to Excel

Topic 3: ArcMAP attribute table export to dBase (.dbf) file to excel

Topic 4: Excel - creating pivot tables

Topic 5: Excel - creating graphs