Assign 8 EK2

Document Sample
Assign 8 EK2 Powered By Docstoc
					Eunice Kim
UEP 232
Assignment 8

Project Description
         For my final project, I plan to conduct a service area analysis for the Watertown Community
Path, which is the focus of my UEP field project. I would like to determine who will have access to
the proposed path and in turn, who will likely benefit – and not benefit – from its development. By
looking at demographic information, I would like to compare this population to the population that
will be served by an adjacent multi-use path that has been funded and will be constructed this year
by the state Department of Conservation and Recreation and also compare it to the population that
is already being served by the Charles River Reservation path.
         The Community Path will run from School Street in east Watertown, through Watertown
Square and onto the Charles River where it will connect to the Charles River Reservation Path. The
DCR path, which is phase 1 of the Charles River Connector Rail Trail, will run from the end of the
Community Path at School Street north to Grove Street. I will map each of these paths.
         I want to use GIS to determine how many residents live near each path and thus find out
who will have or already has access to each. I will do this by creating a ¼ mile buffer around each
path based on a street network. I want to then compare the number of people (proportion of the
population within a 1.5 mile buffer of Watertown) who currently has access to the Charles River
Reservation path to the number/proportion that will have access when the DCR path is built and
also when/if the Community Path is built. I would also like to analyze and compare the socio-
economic characteristics of the three area’s populations (around each path) in order to examine any
issues of social equity in terms of access. I will look at the following demographics: age, race,
household income and commute to work. This will give me a better understanding of the
neighborhood around the Community Path as well as the other paths.

Data Layers
              Data layer                    Source             Source Scale       Year of data
 2000 Census Blocks                      ERSI Website                                 2000
 2000 Census Block Groups                ERSI Website                                 2000
 2000 Census Demographics                ERSI Website                                 2000
 2000 Census Block Group Poly               MassGIS                                   2000
 2000 Census BG Household
 Income                                     MassGIS                                   2000
 2000 Census BG Transportation
 Commute Means                              MassGIS
 EOT Major Roads                            MassGIS              1: 5,000       December 2007
 EOT Roads                                  MassGIS              1: 5,000       December 2007
 Hydro 25K Poly                             MassGIS              1: 25,000        October 2004
                                                                                  October 2002
 Towns Poly                                 MassGIS              1: 25,000       (updated 2003)
 Community Path                          Eunice created             NA             April 2010
 Bicycle Trails (Charles River          MassGIS (Eunice
 Reservation Path and Charles        created two paths using                    2010 (based on
 River Connector)                     MassGIS as a guide)           NA        MassGIS 2004 data)
Data Processing and Analysis Steps

   1.    Import all of the layers in the table above. Download the 2000 Census blocks and Census
         demographics from the ERSI website because the Census data on the M: drive does not
         include race information at the block level (but the ERSI data does). Download the
         Census blocks for Middlesex, Suffolk and Norfolk counties.
   2.    Add the 2000 Census BG Income Household table and 2000 Census Transportation
         Commute Means table
   3.    Using the interactive selection tool, select Watertown out of Towns Poly layer, and create a
         layer of this selection (“Watertown boundary”).
   4.    Create a 1.5-mile buffer around “Watertown boundary”: select by location
   5.    Select Census blocks that have their centroid within that 1.5-mile buffer: select by location.
         Do this all three county Census block layers, and then merge them (using the toolbox
         function “merge”) into one layer/shape file.
   6.    Select Census block groups that have their centroid within that 1.5-mile buffer: select by
         location. Create a new layer from that selected features.
   7.    Export the two newly created layers, so they become their own shape files.
   8.    Join the ESRI Census block demographic data with the ESRI Census block layer: join
   9.    Join the Census block group layer with the Census BG household income and commute
         tables
   10.   Add 2 new fields (racial minorities, population 17 and younger) to the newly created
         Census “blocks within buffer” layer: field calculator
   11.   Add 2 new fields (low-income households, commute by bike/foot) to the newly created
         Census “BG within buffer” layer: field calculator

   12.   Select Census blocks within Watertown: select by location, and create a new layer “blocks
         within Watertown”
   13.   Select Census block groups within Watertown: select by location, and create a new layer
         “BG within Watertown”
   14.   Create access points along the three paths in order to then create a buffer using a street
         network
         (Barbara, this is my fall back plan if we can’t figure out another way of
         automatically selecting access points at intersections of streets and paths)

   15.   Use network analyst to set up a network database and then create a “new service area”
               -Make this “service area” be ¼ mile within each path, essentially creating three new
               service areas
               (Barbara, does this sound right? Making 3 service areas?)
   16.   Select “blocks within Watertown” that have their centroid in this new “service area” and
         create a layer
   17.   Select “BG within Watertown” that have their centroid in this same “service area” and
         create a layer
   18.   Using the Symbology/Quantities option in Properties, create maps listed below with
         graduated colors (ex. Census map showing census blocks by percentage of 17 and younger
         population that are within the ¼ mile buffer)
   19.   Use the Summarize function in the Attribute Field to fill out the table below (ex.
         Summarize the number of 17 and younger people within the census blocks in the ¼ mile
         buffer, and then determine what percentage this represents in terms of the total 17 and
         younger population in the 1.5 mile area around Watertown. Do this twice for each
         variable/category: once using the 1.5 mile buffer and once using Watertown as the
         boundary.)
               -This has to be done for each path listed in the table


Final maps and table

Map of the Census blocks whose center is within ¼ mile (based on a street network) of each of the
three paths. These three paths will be marked on each of the following maps:

Age maps (17 and younger, 65 and older), Census maps
Attribute field: new field including all age groups 17 and younger, existing “Age 65 Up” field
Query: Field calculator (add new field), Summarize (to get count)
    - 18 and younger map will show which Census blocks within ¼ mile of each path have a high
        percentage of youth
    - 65 and older map will show which Census blocks within ¼ mile of each path have a high
        percentage of seniors
    - Both maps will show whether a lot of youth or seniors currently have access to multi-use
        paths in Watertown and whether access for either group will likely be improved with the
        development of the Community Path.

Racial minorities map, Census map
Attribute field: new field including all race groups except white
Query: Field calculator (add new field), Summarize (to get count)
    - This map will show which Census blocks within ¼ mile of each path have a high percentage
        of racial minorities (all but white, not including Hispanic due to data insufficiencies).
    - This will help show whether a lot of minorities currently have access to multi-use paths in
        Watertown and whether their access will likely be improved with the development of the
        Community Path. They will also show whether the Community Path will disproportionately
        benefit minorities or non-minorities.

Low-income household income map, Census map
Attribute field: new field including all income groups up to $60,000
Query: Field calculator (add new field), Summarize (to get count)
    - This map will show which Census block groups within ¼ mile of each path have low
        household incomes.
    - This will help show whether a lot of low-income households currently have access to multi-
        use paths in Watertown and whether their access will likely be improved with the
        development of the Community Path. They will also show whether the Community Path
        will disproportionately benefit high or low-income households.
    - For low-income households, I am using less than $60,000 as my threshold. This is because
        the US Department of Housing and Community Development define “low income”
        households as those earning up to 80% of the Area Median Income, or in Watertown’s case,
        $66,150 for a four-person household. The Census has pre-defined income groups, with one
        being less than $60,000, which is closest to $66,150.
        (Barbara: Do you think I should use a lower threshold for my low-income field?)
Commute to work by bike/foot map, Census map
Attribute field: new field including commute by walking and commute by bike
Query: Field calculator (add new field), Summarize (to get count)
    - This map will show which Census block groups within ¼ mile of each path have a high
        percentage of people walking or biking to work.
    - This will show whether there is any spatial relationship between the location of existing
        multi-use paths and the percentage of those within ¼ mile of the paths who walk/bike to
        work. It will also help show whether the development of the Community Path will provide
        residents who do not walk or bike to work an opportunity to do so.
    - I will try to figure out what the margin of error is for this type of Census analysis.

Table that includes the following information:

 Populations within 1/4 mile of         Watertown         Charles River       Charles River
 each path                            Community Path    Reservation Path       Connector
 Population
   Total
   % of Area
   Watertown total
   % of Watertown population
 Population 17 and under
   Total
   % of Area
   Watertown total
   % of Watertown population
 Population 65 and older
   Total
   % of Area
   Watertown total
   % of Watertown population
 Minority Population
   Total
   % of Area
   Watertown total
   % of Watertown population
 Low-income Population
   Total
   % of Area
   Watertown total
   % of Watertown population
 Commute by Bike/Foot
   Total
   % of Area
Watertown total
% of Watertown population

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:12/18/2011
language:
pages:5