Unformatted text preview:

Massachusetts Institute of Technology - Department of Urban Studies and Planning 11.520: A Workshop on Geographic Information Systems 11.188: Urban Planning and Social Science Laboratory Notes for Homework #2 & Lab 7 (Raster Analysis) Homework #2 Questions: Most questions have concerned (a) computing the numbers for the table of Census data broken down by Town, and (b) using Access to combine the ma00007, mageo, and blkgrp2t.dbf tables in order to get the 'poverty by age' census data by blockgroup (for variable P87). (a) Filing in the gaps in the Census table: use either MS-Access queries or the Field/summarize tools in ArcMap. Be careful in matching the meaning of a table column to the right one (or more) census variables - e.g., determining which block groups have seniors with known poverty status. (b) Combining the census tables in Access • Need to use the MS-Access templates from lab Exercise #5 • When importing the text data (using the st00007 template instructions) be sure to turn off the checkbox about using the first line of the table for field names. (If you happen to check this box, it will stay 'on' and screw up the importing of text files.) • The 'Expression Builder' is fussy about syntax. Sometimes it will insert <<Expr>> as a place holder for a field name. For example: blkkey: <<Expr>>[Mageo]![STATE]+[Mageo]![COUNTY]+[Mageo]![TRACT]+[Mageo]![BLKGRP] In this case, remove <<Expr>> and all is well! • Use logrecno to join mageo and ma00007 and use the above 'blkkey' to join to blkgrp2t.dbf as well as to the blockgroup mapLab Exercise #7 Notes: The exercise is more or less self-explanatory. To be sure we all have the same general idea of what is going on, I'll demonstrate only the first few steps of each part of the exercise - viz., setting up 100m gridcells for Cambridge and using these to convert the sales89 and cambbgrp layers to


View Full Document

MIT 11 520 - Notes for Homework 2 & Lab 7 Raster Analysis

Download Notes for Homework 2 & Lab 7 Raster Analysis
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Notes for Homework 2 & Lab 7 Raster Analysis and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Notes for Homework 2 & Lab 7 Raster Analysis 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?