|
Exploring A Century of Population Change Across the United States with GIS Author: Joseph J. Kerski, Geographer, USGS, jjkerski@usgs.gov, 303-202-4315 Overview: In this lesson, you will have the opportunity to examine 100 years of population change by county across the United States. GIS Skills: 1) Data management. 2) Joining, summarizing, querying, and sorting data. 3) Creating and populating new fields in a database. 4) Creating graphs and pie chart maps. 5) 3D analysis. Data Management Create a folder on your computer where you will store the data. Click here to download the data that you will need for this lab exercise. This file is named popchangeusalesson.zip and totals approximately 1.4 MB. After downloading, unzip the file using the Winzip program. You now should have the following 6 files: co1900_2000.dbf county20thcentury.dbf county20thcentury.sbn county20thcentury.sbx county20thcentury.shp county20thcentury.shx
Using Windows Explorer, answer the following questions:
1) Which file of the above is the largest? Why do you suppose that is the case?
Exploring the Data Access ArcView GIS. Begin a new project with a new view. Add data to the view: county20thcentury Make the themes visible by checking on the box to the left of the theme name. 2) What extent of geography does the county20thcentury.shp file cover?
3) What level of geography does the county20thcentury.shp file cover?
Open the theme table for
county20thcentury. Access the “open theme table” tool 4) How many records are in this table?
5) How many county polygons are in the data set?
Go back to the map. Click on the Identify button (far left on the button bar) and click on one of the polygons. The data are mostly from the 1990 census. Remember that these are self-reported values--how people listed themselves--on the census forms. 6) Briefly describe the types of data that can you can analyze in this file:
Note the coordinates in the upper right as you move around the view with your mouse. 7) What coordinate system is the data in?
Save the project: File-->Save Project As - and name it “county20thcentury.apr” in your folder. Data Analysis Make View1 active. Go to the View--> Properties pull-down menu. Change the name of View1 to “USA Counties” Access the table behind the theme county20thcentury. Click on the field “Pop1990.” Access the menu: Field-->Statistics. 8) What was the total United States population in 1990, according to this database?
Click on the field “Ameri_es.” This is the population for American Indian and Alaska Natives in 1990. Go to Field-->Statistics. 9) What was the Native American population in 1990, according to this database?
Use the "sort
descending" button in the button bar 10) In which county and state did more Native Americans live than any other in 1990? Why?
11) What was the #2 most populous county in terms of Native Americans in 1990? Why?
12) Either by sorting the table, or by using the query tool, answer the following question: How many counties reported no (0) Native Americans in 1990?
13) By using the query tool or the "find" button (looks like a binoculars), answer the following question: What was the Native American population in Todd County, South Dakota, in 1990?
Click on this record in the table. On the map, zoom to this county
using the "zoom to selection" button. Clear the selection by clicking on the button that looks like a blank piece of notebook paper. Zoom to the full extent of all themes by clicking on the tool that looks like an arrow pointing into a stack of layers.
Access the legend editor by double-clicking on the theme name “county20thcentury.shp” in the view. Change the legend type from “single symbol” to “graduated color.” Access the pull-down menu. Change the classification field to “ameri_es". Apply. 14) What happened in your view?
15) The default classification that you just created is “natural breaks” with 5 categories. The software looks at the range of data, and decides where to place the break points. Is this type of legend helpful for analyzing Native American population? Why or why not?
Access the legend editor again. Under "classify" (right hand side), experiment with the other 4 classification methods: standard deviation, quantile, equal area, and equal interval. 16) In your opinion, which method was the best classification method to use for analyzing the Native American population by county?
Why?
17) In a few sentences, describe the pattern of population distribution of Native Americans in the USA by county in 1990.
Access the legend editor by double-clicking on the theme name “county20thcentury.shp” in the view. Change the field that you are mapping and make a map of Hispanic American Population for 1990. 18) Make two observations about the spatial pattern of Hispanic Americans on the map you just created.
Change the field that you are mapping and make a map of African American Population for 1990.
19) Make two observations about the spatial pattern of African Americans on the map you just created.
Change the legend back to mapping Native Americans. Click on the query
builder (hammer with question mark). You are interested in managing a program out of your Rosebud Sioux Tribal Land Office in Rosebud, South Dakota, for Native Americans across the country. For your program, you need to find counties with over 5,000 Native Americans. 20) What expression do you need to create to find these counties? Indicate it below:
Use your expression and select “new set.” 21) What happened to your map?
22) How many counties in your selection have over 5,000 Native Americans?
23) Promote these records to
the top
24) What are the names of the counties in South Dakota with over 5,000 Native Americans in 1990?
Accessing Additional Data Through Tabular Join In spatial analysis with GIS, sometimes you may want to access additional information that is not part of the original database. One way to access this information is to join additional tables to your original database. You did this in previous lessons, and you will have another opportunity to do it here. Make your view active.
Clear your selection with the blank piece of notebook paper tool. Make your county20thcentury.apr (the project window) active by clicking on it. If you have maximized all windows, go to the Window pull-down menu and select county20thcentury.apr. On the left side of the project window, go to “tables” and select “add”. Navigate to your folder where your data is stored. Add the table "co1900_2000.dbf" Open your co1900_2000.dbf table. 25) How many records are in this table?
26) Is this more, less, or the same number of records as the attributes of county20thcentury table?
27) What kind of data is found in the co1900_2000.dbf table?
Open your “attributes of county20th Century” table. Note the field that contains FIPS (Federal Information Processing Standard) codes for counties. You are now ready to join the 2 tables. It is very important to do the join in the correct order. You want to join FROM the table you just added (co1900_2000.dbf) TO the table associated with the map (attributes of county20thcentury table). Be careful not to click inside the table and inadvertently select any records in the table. If you did this, you’d only join these selected records, rather than the entire table. First, click on the FIPS code field in the table "co1900_2000.dbf." Second, click on the FIPS code field in the table "Attributes of county20thcentury." Third, click on the “Join
Tables” button. (looks like 2 tables with an arrow joining them)
Now, examine your attributes of county20thcentury table. 28) What happened to the original width of the table in terms of its size?
Double-click the county20thcentury shape file to access the legend editor. Access the “classification field” pull-down menu. 29) What has happened to the number of fields you can now map?
Your tables are joined, but not permanently. Make it a permanent join as follows: * Make sure you clear any
selections first! * Then: Theme --> Convert to shapefile. Name the shapefile “countyall.shp” and place it in your folder containing your other data for this project. Add the new shapefile into your view. 30) Does this new shapefile have the same number of records and fields as the one you have just been working with? Why or why not?
Make county20thcentury the active theme by single-clicking on it. Now, delete the county20thcentury theme. Edit-->Delete theme. 31) Why are you safe in deleting this theme?
1900 Analysis Change the legend and make a map of 1900 county population. Access the table. 32) What was the USA population as indicated by the sum of all the county populations in 1900? Use Field Statistics after clicking on the 1900 population field.
Sort by 1900
county population. 33) What was the county with the highest population in 1900?
On the map, use the "zoom to selected" button to zoom to that county. Use the label tool to label the county and those around it. 34) Why was this county's population so high in 1900? Anchor your answer to a discussion of immigration to the USA in 1900 and the point of arrival for most immigrants.
Analyze how this county has changed in population from 1900 to 2000 by creating a graph of its population. In the project window, go to Charts--> New. Give your chart a title, and, one by one, add the following fields to the chart: P1900, P1910, P1920, P1930, P1940, P1950, P1960, P1970, P1980, P1990, and P2000. 35) Print your graph and answer the following questions: How has this county changed in population over the past century? Why did the population decrease from the early until the latter part of the 20th Century? Why did the county start increasing in population? Anchor your discussion in internal migration, metropolitan suburbanization, changes in employment and economy, and gentrification. 36) Select two other center-city metropolitan counties such as Harris County, Texas, St Louis County, Missouri, and Wayne County, Michigan, make a graph of their population changes, and compare the growth of these counties compared to the county you examined in question 33.
Analyzing 20th Century Change Clear your selection 37) What USA county had the largest population in 1950?
38) What USA county had the largest population in 2000?
39) Describe the direction of population change from 1900 to 2000 across the United States as evidenced by the county with the largest population in 1900 vs 1950 vs 2000. Why did the population move the way it did?
40) Make a graph and describe how the population of Todd County, South Dakota has changed from 1900 to 2000. What influence do you think do Native Americans have on the historical and current population of the county? Why?
Access the table 41) What was the USA population as indicated by the sum of all the county populations in 1950?
42) What was the USA population as indicated by the sum of all the county populations in 2000?
Even though the
population of the entire country increased, not every county necessarily
increased. Use the query tool Use the following formula: ( [P1900] > [P2000] ) 43) How many counties were selected?
44) Do these represent counties that are growing or counties that are declining?
45) How many of these counties are in South Dakota?
46) Describe the pattern of the counties that decreased in population over those 100 years:
47) Indicate at least two reasons why the counties have decreased in populations according to the pattern you identified above.
Clear the selected
set. Using the above procedures, do the same thing for 1990 versus 2000 counties. 48) How many counties had more residents in 1990 than they did in 2000 ?
49) How many of these counties are in South Dakota? Compare this to the number you indicated above that lost population over the previous 100 years.
50) Compare the number of 1990 vs 2000 decreasing counties to your 1900 vs 2000 number above, and compare the spatial pattern of each set. Indicate two similarities and two differences between the 10 year pattern and the 100 year pattern.
51) Describe at least two characteristics of the pattern of county population that you believe will exist in the USA in 2100, and give at least two reasons for your prediction.
52) Clear selection and create a United States map of the change (the second to last field in the table) in population from 1990 to 2000. Make at least two observations of the resulting pattern.
53) In the table, sort by the population change. Which three counties gained the most population from 1990 to 2000?
54) In which states were they? Do the results surprise you?
55) In the table, sort by the population change. Which three counties lost the most population from 1990 to 2000?
56) In which states were they? Do the results surprise you?
57) Clear selection and create a United States map of the percent change (the last field in the table--percent) in population from 1990 to 2000. Make at least two observations of the resulting pattern.
58) Compare the percent change map to the raw population change map and make at least two observations of the differences and similarities between numeric change and percentage change.
59) In the table, sort by the percent change. Which three counties gained the most in percent from 1990 to 2000?
60) In which states were they? Do the results surprise you?
61) In the table, sort by the percent change. Which three counties lost the most population in percent from 1990 to 2000?
62) In which states were they? Do the results surprise you?
Creating New Data: Dust Bowl Analysis Thus far, you have been working with existing data. A GIS also allows you to create new data and analyze it. You are working for the US Natural Resources Conservation Service, and wish to examine the population change from 1930 to 1940, focusing on the Dust Bowl period when many people left farms across the Midwest during a series of dry years. Go to Table--> Start Editing. Go to Edit--> Add Field. Make your new field named p30vs40, a number, with 16 width and 2 decimal places. 63) Select the calculate button and calculate the values in your new field. What expression should you use to obtain a percentage change from 1930 to 1940?
Select Table--> Stop Editing and save your edits. 64) Make a graduated color map of your new field and make two observations about the pattern of population change across the country during the 1930s.
65) Based on your observations, which state would you say that most of the displaced farmers from the Midwest moved to during the 1930s? If time permits, read sections of The Grapes of Wrath by John Steinbeck.
South Dakota Next, you want to focus on
South Dakota counties. Clear any selections 66) What expression did you use to select South Dakota counties?
67) How many counties are selected?
Use Theme--> Convert to shapefile to save your South Dakota counties into its own data set. Name it sdcounty.shp and place it in your folder. 68) Access the table for your new theme. How many records are in its table?
69) Why?
Change the legend for South Dakota counties to a CHART legend type. Your goal is to create a pie chart in each county that indicates the relative percentage of Native Americans in each county. Add the fields pop1990 and Ameri_es to the right side of the box, to create a pie chart of Native Americans and total population in each county. Under "properties," change the size field to Pop1990 and Apply. 70) Describe what happened.
71) Does the chart map aid your understanding of Native American and Total Population distribution in South Dakota? Why or why not?
Experiment with the colors, sizes, and with other data in the chart map legend. Go to View--> Layout and make a layout of your map. Print the layout. Clear selections. Save your project. Three Dimensional Analysis Three dimensional analysis can aid in understanding many types of geographic phenomena. If you have the 3D Analyst extension, complete the following section to analyze county population change in three dimensions. If you do not have the extension, skip to the second last question of this lesson. Go to File-->Extensions, and turn on the 3D Analyst extension. Next, in the project window, click on 3D Scene, and select New. Add your countyall.shp data to the 3D scene. Make a graduated color map of the field "percent." Make the breaking point between the first and second categories a zero (0) by clicking in the legend itself and typing the new value. Be sure to end category 1 at zero, and begin category 2 at zero. In other words, the first category will represent the decreasing counties, and categories 2 through 5 will represent increasing counties. Next, go to 3D Scene --> Properties, and change the background color from black to white. Next, go to Theme--> 3D Properties. Extrude features by the following expression: [Percent] / 7 Apply and rotate and zoom around your 3D map of population change from 1990 to 2000. 72) Make two observations of the pattern of population change in the southwest USA--Arizona, Nevada, and California.
73) Rotate the map so that you are looking south from Canada into North Dakota. Make two observations of the pattern of population change in the midwest USA--the Dakotas through Oklahoma.
74) Make two additional observations about population change in the USA.
75) Summarize in a few sentences what you have learned about population changes in the United States over the past 100 years in this lesson.
76) Summarize in a few sentences what you have learned about GIS in this lesson.
Save your project and exit ArcView GIS.
|
|
U.S.
Department of the Interior
U.S. Geological Survey Rocky Mountain Mapping Center Maintainer: webmaster@rockyweb.cr.usgs.gov URL:http://rockyweb.cr.usgs.gov/public/outreach/sgu/popchangeusalesson.html Last modified: 2 March 2004 |