URBDP 573 Digital Design Practicum
Tutorial 3.2
Social-demographic Analysis
In this tutorial, you will learn how to use GIS to "geographically" present Census data. Tutorial 3.2 - Part 1 (Getting Census Data)First go to: http://factfinder.census.gov/home/saff/main.html?_lang=en Select "Show me all Block Groups" within "Place",
"Washington", "Seattle city".
Move mouse over "Print/Download", and click "Download".
There will be two Excel files listed as being zipped in the file. Open
both. Make note of what the variables represent, and eliminate the second row of the Excel file (with all of the descriptions). You may want to save a copy with the descriptions, just in case.
Save the file and leave Excel. Open Microsoft Access and choose "Blank
Database", and click OK In the File drop-down menu, choose "Get External Data"
and then "Import" Check "First Row contains Column Headings" in the first window of the Import Spreadsheet Wizard
Keep all the default settings for the rest of the windows in the wizard, But before clicking "Finish", rename the table as "popu" (or other name makes sense to you). Click Finish Now you have a table contains both census information and census block group codes and ready to join it into GIS. Tutorial 3b - Part 2 (Linking the External Data)You are now going to import this data table into ArcMap. But before doing that, you have to download a base layer with census boundaries on it. Go to U:/ to download a zipped file named newblkgrps (containning a GIS layer) and unzip it into your folder (or directly download the following file: newblkgrps.zip). Then open ArcMap with a blank map and add this newblkgrps GIS layer from your folder to the map. Right-click the layer and open its attribute table, pay attention to the last field (to your right) called CODE1, this field contains exactly the same identifiers that you created for your census data. And we will use these IDs to join the census data table to this GIS layer. First add the census data table to your map. Right-click the layer again, and choose Joins and Relates > Join In the dialog window, set the settings as shown below Be sure to use CODE1 as the IDs for the layer and CODE for the census Table. When done, open the attribute table again, and you should find a field that contains census information (such as population) for all the census block groups. Now you can play with symbology to change the way ArcGIS shows this layer. Right-click the layer again, and choose Properties, then Symbology, In the dialog, set the settings as shown below. 1. Shows: Quantities then apply these new settings to your layer as shown below
|
||
Send mail to: kuangt@u.washington.edu
Last modified: 4/29/2009 12:19 PM |