UP 503- Site & Physical Planning

UP 503- Site & Physical Planning Socio-Economic Context

Goals- by the end of the tutorial we will be able to.. • Identify the tract and block groups • Gather relevant socio-economic data for the area and its surroundings • Draw the physical implications of the identified socio-economic characteristics

Step 1: Identify socio-economic indicators • What might be some indicators of a region’s socio-economic conditions? • Census reports a number of characteristics in their Summary File 1 & 3 (SF1 & SF3) tables: • SF 1 • Housing: H1 Hse Units, H3 Occupancy, H4 Tenure (Own/Rent), H5 Vacancy • Population: P1 Total Pop, P7 Race, P15 # of HHs, P17 Avg HH Size • SF 3 (in addition to those listed above) • P30 Transportation to Work, P31 Travel Time to Work, P53 Median HH Income, P64 Public Assistance Income, P87 Poverty Status, P43 Labor Force Status

Identifying area characteristics • http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml provides the relevant census tract, block group, and block numbers based on the street address you provide. • Click “Street Address “and type an address you want. • Choose “Map” option to see it on a map. Click Here!

Identifying area characteristics • Pictured: Census tract  block group  block

Getting the Data • US Census American Factfinder for tables of demographic data http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml • ESRI (ArcGIS) Census 2000 shapefiles for tracts, block groups, and/or blocks http://arcdata.esri.com/data/tiger2000/tiger_county.cfm?sfips=17

US Census Factfinder Under “Decennial Census” select “get data”

US Census Factfinder Notice that you are working with the 2000 Census by default. You Can repeat the following steps for the 1990 Census if you click on that tab. The SF 3 table is a more detailed version of SF 1, so you can use either one, but for the purposes of this guide we will use SF 1. Select “detailed tables”.

US Census Factfinder Select the “geo within geo” tab. This will allow you to select all of the elements of a chosen level of geography that fall within a larger level (e.g. block groups within a county). The alternative is manually adding each block group one at a time, which can take a very long time if you are looking at the whole county. Choose either Census Tracts, Block Groups or Blocks based on the scale of your analysis.

US Census Factfinder Select “County” as the chosen geography level, then select the state, and choose Champaign County. Highlight “All Groups”, click Add, and then click Next.

US Census Factfinder You can view all the categories in a long list, or choose to search for them by subject or by keyword. Highlight any relevant categories of data and click “Add” to add them to the custom table you are building. When you are done, hit Show Result.

US Census Factfinder Select “Download” from the “Print/Dowload” Menu. In the resulting pop-up window, choose to save as an Excel table. Click OK, and save the file somewhere where you will be able to find it.

US Census Factfinder The Excel file will look something like this after you have unzipped it. Since it has two column headers, you will have to delete one before you are able to use this table in GIS. Column headers cannot have any spaces or special characters in them, so you can’t use the second row, but the names in the first row are not very descriptive either. You should rename the first row so you will know what data each column contains, but remember: NO SPACES! Use underscores instead.

Make sure you do not restrict your analysis to the census figures. • ‘Understanding Density’ exercise may also be helpful in understanding the physical implications of the socio-economic conditions.

ESRI Census 2000 shapefiles Using the link from slide 3, navigate to the ESRI TIGER shapefile page. Choose Illinois as your state and hit Submit Selection. On the following page, choose Champaign as your county and again hit Submit Selection.

ESRI Census 2000 shapefiles Choose the appropriate level of geography and Census year that you are working with. Scroll to the bottom of the page and hit “Proceed to Download”, and then “Download file” on the following page.

ESRI Census 2000 shapefiles • In order for the layers you downloaded to work in ArcGIS after you unzip them, you will have to define the projection, as we did in the “Using ArcGIS with Adobe Illustrator Tutorial” • The following slides are exerpts from that tutorial and outline the procedure for defining a projection.

ESRI Census 2000 shapefiles

Step 2: Identify growth numbers • CCRPC has population projections for the CU urbanized area by TAZ (Transportation Analysis Zones)- aggregate information may be used as the total population change. • CU Population Projection file presents the information. (Check the sum of the red boxes in the file to calculate total population change in the region.) • LEAM projections give an estimate of the population distribution as per the socio-economic indicators

Step 3: Identify area requirements • What do the population projections mean in terms of area requirements? • Avg. household size in Champaign: 2.23 persons (http://www.zillow.com/local-info/IL-Champaign-people/r_4042/) • Avg. office space per employee: 175-250 usable sq. ft. per person; plus an additional 10-18% for non usable space (http://www.officefinder.com/how.html) • Average retail space per person: 46.6 sq. ft. per person in USA (http://www.icsc.org/srch/faq_category.php?cat_type=research&cat_id=3) • Use Neighborhood Prototypes reading to estimate acreage for other land uses • Can the growth be accommodated? What sort of development patterns are most feasible? • Comment on your findings and arrive at an estimate of area required- there may not be a correct answer.

Step 4: Determining Demand for Development • You have identified population projections and area requirements for your region. • You have been asked to development a site that is approximately 1-1.5 sq. mile. How much of the projected growth will be accommodated by your development?

UP 503- Site & Physical Planning