UP 503- Site & Physical Planning

1. UP 503- Site & Physical Planning Socio-Economic Context

2. 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

3. 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

4. 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!

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

6. 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

7. US Census Factfinder Click “Decennial Census”

8. US Census Factfinder • You Can repeat the following steps for the other Decennial Census if you click other year. • 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. “Decennial Census” and “2000 SF1 100% Data” are added to Your Selections.

9. US Census Factfinder Select the “Geographies” 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. Census Tract 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 (This will be explained in the next slide!). Choose “Census Tract”.

10. US Census Factfinder By opening the “Name” tap, you can choose different scale of geographic type (Block Groups, Blocks, etc) based on the scale of your analysis. You can manually add each block group one at a time as well.

11. US Census Factfinder You can go through different data options in “Topics” tab. This time we will search directly. Type “P1” in the search tap.

12. US Census Factfinder “P1” is added into Your Selections and there is one option for “Age Groups and Sex:2000”. Click the blue letters. v

13. US Census Factfinder Select “Download” from the “Actions” Menu. In the 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.

14. US Census Factfinder The Excel file will look something like this after you download it. Since it has three column headers, you will have to delete two before you are able to use this table in GIS. Column headers cannot have any spaces or special characters in them. You should rename a row so you know what data each column contains, but remember: NO SPACES! Use underscores instead.

15. 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.

16. ESRI Census 2010 shapefiles Using the link below to navigate to the ESRI TIGER shapefile page. Choose Block Groups as your data type and hit Submit Selection. On the following page, choose year what you are looking for. http://www.census.gov/cgi-bin/geo/shapefiles2010/main

17. ESRI Census 2000 shapefiles Choose Illinois as your state and Champaign as your county. Hit submit button. On the page shown on this slide, hit Download button to attain your data.

18. 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.

19. ESRI Census 2000 shapefiles

20. ESRI Census 2000 shapefiles

21. ESRI Census 2000 shapefiles

22. 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

23. 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.

24. 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?

25. A tip for someone who is working hard! Tip :D You can paly with “Modify Table” tab before you download the data! v