Submitted by Andy Anderson on Thursday, 2/24/2011, at 11:17 AM

By Tuesday, February 22, 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 4 - Editing Map Data” and drag a copy to your desktop (this will make your work faster). You don't need to do this if you're sitting at the same computer as on Tuesday, and haven't made any changes to this folder on COLQ-32.
    3. Rename the folder on your desktop “Assignment Week 5”.
    4. Locate the updated file Inner_Belt_Cambridge_Plats.xlsx in the folder “@Data” and then “Class Week 4 - Editing Map Data” and copy it to your folder “Assignment Week 5”.
    5. In the folder “Assignment Week 5”, find your “Inner Belt Detailed” map document from Tuesday's class with the Interstate 695 Route image, and open it in ArcMap.
    6. Verify that the map document is using relative pathnames; change it if necessary, and save it.
  2. You will be georeferencing the Interstate 695 Route maps, tracing the route of the planned highway, creating a table of affected property owners, and locating at least some of them or their families in However you divide up this work, the other member of your pair should check your work for accuracy.
    1. You will be working in pairs:
      1. DA & JBR: Interstate 695 Route p70 and Interstate 695 Route p71 (Plats 86-89)
      2. RS & NN: Interstate 695 Route p72 (Plats 89-93)
      3. TL & JF: Interstate 695 Route p73 (Plats 92-94)
      4. YZ & EP: Interstate 695 Route p74 (Plats 94-97)
    2. The table Inner_Belt_Cambridge_Plats.xlsx has already been partially prepared for Plats 79, 86, 88, and 89, hence the extra map for the first group.
    3. Georeferencing these maps shouldn't require too many points, though the edges may be off due to the photocopying. Use at least two widely separated road intersections. Save your control point links and rectify your image as described in Procedure 2 in your handout Mapping Image Data.
    4. Once you have finished georeferencing, you can create a layer that outlines the highway route.
      1. Each of these maps have two highway Approximate Sidelines, which run between opposite sides of the scanned map. Identify the full lengths of these sidelines. Note that they sometimes follow the edges of the streets (you can see them cross at intersections).
      2. Trace out the highway route:
        1. In the toolbar Drawing, click on the menu button next to the button New Rectangle, and select New Polygon.
        2. Starting at one edge of the map, carefully click in a series along one of the Approximate Sidelines, using short enough segments that you keep the sideline underneath the polygon boundary you are creating.
        3. When you reach the other edge of the map, click again at the near end of the other Approximate Sideline and carefully trace along it back to the first edge.
        4. When you reach the first edge again, double click to end the polygon.
        5. If you make mistakes, wait until after step (iv) to fix them, using Procedures 8 and 12 in your handout Editing Map Data.
      3. The item you just traced out is only a graphic, not a geographic feature, so you'll need to convert it.
        1. In the toolbar Drawing, click on the menu Drawing and select Convert Graphics To Features…
        2. Name the shapefile appropriately, e.g. Interstate 695 Route p70.shp;
        3. Check the box Automatically delete graphics after conversion;
        4. Click the button OK.
        5. When asked Do you want to add the exported data to the map as a layer? click the button Yes.
      4. Change the symbology of the highway route so that it has no fill and a visible boundary.
      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 5” and click the button Save.
    5. If you are transcribing the property owner information, use the same format as in the file Inner_Belt_Cambridge_Plats.xlsx. Try to be as literal as possible; possible spelling variations you may notice later should be noted in a separate column. Only transcribe the properties on your own map — you may need to get names off of another sheet, as some of the plats overlap two maps. Note that their order in the list does have a rough geographic order, which should help figure out the lot numbers. 
    6. To access the census data:
      1. Go to;
      2. Scroll down to and click on the link Ancestry Library;
      3. Under Census Collections, click on U.S. Census Collection;
      4. Under Included data collections:, click on 1930 United States Federal Census.
    7. Starting with the more unusual names on the list, try to locate them in the census tracts in Massachusetts State, Middlesex County, Cambridge "Township". Compare the addresses in the census with the address points in your GIS map, and the owner of that property. If you find close matches in surnames at a particular property or full names nearby (beawear speling kan very!), or even the same grouping of names in both documents, describe them in a new set of columns next to their listing in Inner_Belt_Cambridge_Plats.xlsx:
      1. Census_1930: Copy the Source Citation from the Ancestry Page (the one before you go to the image), and append the line number on the image;
      2. Census_Name: the name as listed in the census (it could be different from the property record);
      3. Address: Number and street;
      4. Home: O or R
      5. Relation: relationship to the head of household;
      6. Sex: M or F
      7. ColorRace: W or N or M or I or C or J or F or H or K
      8. Age: Age on April 1, 1930.
      9. BirthPlace: Place of Birth — Person
      10. FatherBP: Place of Birth — Father
      11. MotherBP: Place of Birth — Mother
      12. Language: Mother Tongue/Native Language
    8. These items come from the general description page of the 1930 United States Federal Census that you reached in step (f)(iv) above.

    9. If there is more than one property owner and more than one of them show up in the census at the same location, use the first one on the census (probably either the head of household or the eldest). If they are at different locations, use the one who is at the property of interest, or if none of them are, use the first property owner.
  3. Don't forget to save your map!
  4. Drag the folder “Assignment Week 5” from your desktop to your folder in \\storage\colq-32.
Due Date: 
Tue, 02/22/2011 - 13:00