GIS for Week 3 (2/8)

Submitted by Andy Anderson on Monday, 2/7/2011, at 12:46 PM

By Tuesday, February 8, at 1 PM, please do the following exercises:

  1. On whichever Windows computer you're using, set up the assignment:
    1. Map the network drive \\storage\colq-32 (if necessary).
    2. Inside your own folder, locate your copy of the folder named “Class Week 2 - Mapping Names” and drag a copy to your desktop (this will make your work faster).
    3. Rename the folder on your desktop “Assignment Week 3”.
    4. Copy all of the files in the folder
           \\storage\colq-32\@Data\Assignment Week 3
      into your desktop folder “Assignment Week 3”. These are all necessary to display the shapefile Cambridge_Schools_2000.shp.
    5. In the folder “Assignment Week 3”, find your map document from Tuesday's class with the Year 2000 poverty information, and open it in ArcMap.
  2. Compare census poverty information with school information:
    1. If it's not already on your map, add the layer
          Boston_Area_Census_2000.shp 
      and symbolize it with FeaturesSingle symbol using hollow interiors and thick black boundaries.
    2. Zoom your map to Cambridge, and make sure that its census tracts use the symbology Quantities — Graduated colors, and a set of distinguishable poverty classes appropriate for Cambridge.
    3. How do the poverty classes for Cambridge compare to the rest of Middlesex County? Write your answer in a text file named “Answers” and save it in your folder “Assignment Week 3”.
    4. Add the layer
           Assignment Week 3\Cambridge_Schools_2000.shp
      to your map, and label it.
    5. Using Excel, copy the table “Demographics of Elementary Schools in Cambridge, Massachusetts, 2000-2001” from p. 171 of Edward B. Fisk, “Controlled Choice in Cambridge, Massachusetts”. Format the table so that it can be used with ArcMap. Recall the basic rules described on this web page:
      http://www.ats.amherst.edu/software/gis/mapping_named_data/#MakinganExcelFileCompatiblewithArcGIS 
    6. Add an extra column to the Fisk table representing the school popularity, as described on p. 179. This information is an incomplete ranking of the schools, but they could be assigned a few categorical values.
    7. Join the Fisk table to the Cambridge School Districts layer, as described on this web page:
      http://www.ats.amherst.edu/software/gis/mapping_named_data/#JoiningaTabletoaLayer 
    8. Investigate the relationship between poverty and the locations of the schools:
      1. Symbolize the Schools layer by the percentage of students receiving subsidized lunch, using QuantitiesProportional Symbols.
      2. Menu File and then Export Map…, and in the resulting dialog locate the menu Save as Type: and choose PNG; name the file appropriately and then navigate to your folder “Assignment Week 3”  and click the button Save.
      3. How do the schools with a larger percentage of students receiving subsidized lunch compare with the higher-poverty areas of Cambridge? Write your answer in the text file “Answers” in your folder “Assignment Week 3”.
    9. Investigate the relationship between the popularity and the locations of the schools:
      1. Symbolize the Schools layer by the popularity of the schools, using Quantities — Graduated Symbols (if you assigned numerical categories) or CategoriesUnique Symbols and different-sized symbols (if you assigned textual categories).
      2. Menu File and then Export Map…, and in the resulting dialog locate the menu Save as Type: and choose PNG; name the file appropriately and then navigate to your folder “Assignment Week 3”  and click the button Save.
      3. How do the schools that are more popular compare with the higher-poverty areas of Cambridge? Write your answer in the text file “Answers” in your folder “Assignment Week 3”.
    10. Don't forget to save your map!
  3. Investigate historical poverty in Cambridge:
    1. Save a new copy of your map from step (2) with a new name.
    2. Visit the National Historical Geographic Information System, http://nhgis.org/ . 
      1. You'll have to create an account on this web site in order to get its data. 
      2. Download a Year 1980 census tract shapefile.
      3. Request a basic poverty table (NT91A) that includes the census tracts in Cambridge. Note that the site may take a while to prepare a data set for you, so it sends you a link in an e-mail when it’s finished.
      4. Make sure you download both the GIS CSV file and the ASCII codebook. The latter is a simple text file that provides the metadata for the former, including attribute descriptions.
      5. Give the files a relevant name, e.g. “MA_Census_1980_Poverty”.
    3. Open the poverty data in Excel:
      1. Notice how its structure is different than that provided for Year 2000.
      2. In the first blank column, create your own Total column to describe the total population for whom poverty is determined. For example, if the Income above poverty level and the Income below poverty level are in columns M and N, then click on cell O1 and type
             Total
        and key Enter.
      3. To calculate the total for row 2, select cell O2, type
             = M2 + N2
        and key Enter.
      4. Finally, select cell O2 again, grab the lower-right corner of its outline, and drag it to the bottom of the table to copy it downward and at the same time update its row number.
      5. Save the file and say Yes and No to the next two dialogs.
    4. Add the tract shapefile to your map, join the poverty data, and provide the same symbolization as for the Year 2000 data in step 2(b). 
    5. Menu File and then Export Map…, and in the resulting dialog locate the menu Save as Type: and choose PNG; name the file appropriately and then navigate to your folder “Assignment Week 3”  and click the button Save.
    6. How does poverty change in Cambridge over these twenty years? Write your answer in the text file “Answers” in your folder “Assignment Week 3”.
    7. Don't forget to save your map!
  4. Drag the folder “Assignment Week 3” from your desktop to your folder in \\storage\colq-32.
Due Date: 
Tue, 02/08/2011 - 14:00