|
|
|
... visual analysis of geographic-demographic-economic patterns Neighborhood demographic-economic patterns might be most effectively understood using GIS tools supplemented with tabular/spreadsheet data. Geographic Information System (GIS) applications provide an appealing and flexible way of visually examining thematic patterns ... such as patterns of median household income as one measure of economic prosperity. By combining different layers, such as counties, cities and census tracts, we are able to better understand patterns in the context of multiple types of geography. This section is focused on use of GIS and related geographic-demographic-economic data to examine neighborhood patterns. You can use resources described here to flexibly examine neighborhood patterns for your areas of interest. The GIS resources reviewed in this section are provided as a part of the ProximityOne User Group. Join now ... there is no fee to participate. Visual Analysis of Neighborhood Patterns The graphic presented below (click for larger view) shows a thematic pattern map of Missouri census tracts by median household income. This graphic shows the "start-up" view of the GIS project described in this section. We will review how, in just a few steps, how you can develop maps like this one for interactive use; perform geographic drill-down and navigation; label tracts and other geography; change attributes of patterns and/or variables used in thematic maps; add other layers; and examine the data in tabular form. 
Steps to Develop the Above Map (requires Windows computer with Internet connection) 1. Install the ProximityOne CV XE GIS ... run the CV XE GIS installer ... take all defaults during installation 2. Download the Missouri Neighborhoods GIS Project zip file. ... requires ProximityOne User Group ID (join now, no fee) 3. Expand the zip file to the folder c:\dmi. 4. Initial start-up. ... after completing the above steps and with CV XE running (use desktop icon) ... use File>Open>Dialog to open the project file named c:\dmi\mo1.gis ... the map view shown above should appear. About the GIS Project The GIS project includes several shapefiles, represented as layers, and OpenStreetMaps (OSM) as an optional base layer. Use of the OSM requires an Internet connection. The OSM layer is optional. It can be deleted from the project, However, the automatic roads and topology view is then not available. Other than the OSM layer, there are no Internet dependencies; CV XE and this project operate without Internet. The layers include U.S. by states, state by county, state by city/place, state by census tract. Project Operations See User Guide for information on opening and closing project. When the GIS project is opened, the GIS project file is read; this operation is what establishes the start-up view. No changes to the project are saved if CV XE is closed without saving the active GIS project. If the active project is saved, the settings active at that time will be reflected when that project is subsequently opened. It is recommended that a new name is used when a GIS project is saved. You can add other layers, representing different shapefiles (for example schools as point locations or roads as lines), to the GIS project and save the new project. When getting started, saving the project with the same project filename is not recommended. Simply close CV XE. CV XE Selected Operations See User Guide for additional information. Develop a vision for what you want to show or analyze. A simple example would be to zoom to view of a particular county or city, highlight those boundaries, possibly label with an item of interest (e.g. educational attainment) and save a graphic of the new view; add the graphic to a web page or document where it might be discussed with related text. Selected CV XE operations are reviewed below. 1. Map View Navigation
See summary of navigation operations
If the view becomes disoriented, close CV XE, restart, re-open as in step 4 above. 2. Map View Composition -- selecting layers & setting layer attributes
click layer checkbox on in legend panel to make the layer visible.
change layer attributes -- use Layer editor to set layer attributes -- label tracts with tract code (yellow background). slide layer up or down: click on a layer in legend panel, hold down mouse button & drag up or down. 3. View Profile for a Geographic Object -- use select/identify tool 4. View Layer Data as Table/Spreadsheet Dataset Fields The scroll section below shows attributes/fields available for each census tract/neighborhood. Most items are derived from four datasets: General Demographics (D items), Social Characteristics (S items), Economic Characteristics, (E items) and Housing Characteristics (H items). A few items (HDMA) have been derived from the HMDA "Census 2013" dataset and integrated into the shapefile used in the project. Several hundred additional items can be made available. Item HMDAS1 is the Tract Income Level and determines the census tract HMDA LMI designation. The values that this field can take on are shown as codes 0 .. 4. Using this classification there are 5,588 tracts having a HMDAS1 value of 1 or low income. Use vertical scroll bar at right to scroll and view all fields. Data Items -- scroll section Click a link to navigate to those items in the scroll section. General Demographics ... Social Characteristics ... Economic Characteristics ... Housing Characteristics ... HMDA Items
Codes
P2010 Total population (Census 2010; remaining items ACS 2011 5 year estimates) AGE AND GENDER D001 Total population D002 Male D003 Female D004 Under 5 years D005 5 to 9 years D006 10 to 14 years D007 15 to 19 years D008 20 to 24 years D009 25 to 34 years D010 35 to 44 years D011 45 to 54 years D012 55 to 59 years D013 60 to 64 years D014 65 to 74 years D015 75 to 84 years D016 85 years and over D017 Median age (years) D018 18 years and over D019 21 years and over D020 62 years and over D021 65 years and over D022 18 years and over D023 Male D024 Female D025 65 years and over D026 Male D027 Female RACE D028 Total population D029 One race D030 Two or more races D031 One race D032 White D033 Black or African American D034 American Indian and Alaska Native D039 Asian D047 Native Hawaiian and Other Pacific Islander D052 Some other race D053 Two or more races D066 Hispanic or Latino (of any race) D067 Mexican D068 Puerto Rican D069 Cuban D070 Other Hispanic or Latino Social Characteristics Items HOUSEHOLDS BY TYPE S001 Total households S002 Family households (families) S010 Nonfamily households S015 Average household size S016 Average family size RELATIONSHIP S017 Population in households SCHOOL ENROLLMENT S052 Population 3 years and over enrolled in school S053 Nursery school, preschool S054 Kindergarten S055 Elementary school (grades 1-8) S056 High school (grades 9-12) S057 College or graduate school EDUCATIONAL ATTAINMENT S058 Population 25 years and over S059 Less than 9th grade S060 9th to 12th grade, no diploma S061 High school graduate (includes equivalency) S062 Some college, no degree S063 Associate's degree S064 Bachelor's degree S065 Graduate or professional degree S066 Percent high school graduate or higher S067 Percent bachelor's degree or higher RESIDENCE 1 YEAR AGO S078 Population 1 year and over S079 Same house S080 Different house in the U.S. S081 Same county S082 Different county S083 Same state S084 Different state S085 Abroad LANGUAGE SPOKEN AT HOME S110 Population 5 years and over S111 English only S112 Language other than English S113 Speak English less than "very well" S114 Spanish S115 Speak English less than "very well" Economic Characteristics Items EMPLOYMENT STATUS E001 Population 16 years and over E002 In labor force E003 Civilian labor force E004 Employed E005 Unemployed E006 Armed Forces E007 Not in labor force E008 Civilian labor force E009 Percent Unemployed INDUSTRY Civilian employed population 16 years and over E033 Agriculture, forestry, fishing and hunting, and mining E034 Construction E035 Manufacturing E036 Wholesale trade E037 Retail trade E038 Transportation and warehousing, and utilities E039 Information E040 Finance and insurance, and real estate and rental and leasing E041 Professional, scientific, and management, and administrative and waste management services E042 Educational services, and health care and social assistance E043 Arts, entertainment, and recreation, and accommodation and food services E044 Other services, except public administration E045 Public administration INCOME AND BENEFITS (IN 2010 INFLATION-ADJUSTED DOLLARS) Total households E052 Less than $10,000 E053 $10,000 to $14,999 E054 $15,000 to $24,999 E055 $25,000 to $34,999 E056 $35,000 to $49,999 E057 $50,000 to $74,999 E058 $75,000 to $99,999 E059 $100,000 to $149,999 E060 $150,000 to $199,999 E061 $200,000 or more E062 Median household income (dollars) E063 Mean household income (dollars) E075 Families E076 Less than $10,000 E077 $10,000 to $14,999 E078 $15,000 to $24,999 E079 $25,000 to $34,999 E080 $35,000 to $49,999 E081 $50,000 to $74,999 E082 $75,000 to $99,999 E083 $100,000 to $149,999 E084 $150,000 to $199,999 E085 $200,000 or more E086 Median family income (dollars) E087 Mean family income (dollars) PERCENT FAMILIES & PEOPLE W/INCOME PAST 12 MONTHS BELOW POVERTY LEVEL E119 All families E120 With related children under 18 years E121 With related children under 5 years only E122 Married couple families E123 With related children under 18 years E124 With related children under 5 years only E125 Families with female householder, no husband present E126 With related children under 18 years E127 With related children under 5 years only E128 All people Housing Characteristics Items HOUSING OCCUPANCY H001 Total housing units H002 Occupied housing units H003 Vacant housing units H004 Homeowner vacancy rate H005 Rental vacancy rate UNITS IN STRUCTURE H006 Total housing units H007 1-unit, detached H008 1-unit, attached H009 2 units H010 3 or 4 units H011 5 to 9 units H012 10 to 19 units H013 20 or more units H014 Mobile home H015 Boat, RV, van, etc. YEAR STRUCTURE BUILT H016 Total housing units H017 Built 2005 or later H018 Built 2000 to 2004 H019 Built 1990 to 1999 H020 Built 1980 to 1989 H021 Built 1970 to 1979 H022 Built 1960 to 1969 H023 Built 1950 to 1959 H024 Built 1940 to 1949 H025 Built 1939 or earlier HOUSING TENURE Occupied housing units H045 Owner-occupied H046 Renter-occupied H047 Average household size of owner-occupied unit H048 Average household size of renter-occupied unit YEAR HOUSEHOLDER MOVED INTO UNIT H049 Occupied housing units H050 Moved in 2005 or later H051 Moved in 2000 to 2004 H052 Moved in 1990 to 1999 H053 Moved in 1980 to 1989 H054 Moved in 1970 to 1979 H055 Moved in 1969 or earlier OCCUPANTS PER ROOM Occupied housing units H076 1.00 or less H077 1.01 to 1.50 H078 1.51 or more VALUE H079 Owner-occupied units H080 Less than $50,000 H081 $50,000 to $99,999 H082 $100,000 to $149,999 H083 $150,000 to $199,999 H084 $200,000 to $299,999 H085 $300,000 to $499,999 H086 $500,000 to $999,999 H087 $1,000,000 or more H088 Median (dollars) SELECTED MONTHLY OWNER COSTS (SMOC) H092 Housing units with a mortgage H093 Less than $300 H094 $300 to $499 H095 $500 to $699 H096 $700 to $999 H097 $1,000 to $1,499 H098 $1,500 to $1,999 H099 $2,000 or more H100 Median (dollars) GROSS RENT H124 Occupied units paying rent H125 Less than $200 H126 $200 to $299 H127 $300 to $499 H128 $500 to $749 H129 $750 to $999 H130 $1,000 to $1,499 H131 $1,500 or more H132 Median (dollars) H133 No rent paid HMDA Sourced Items
Terms of Use. Resources made available via this Web page are proprietary to ProximityOne. The resources may be used in any manner without further authorization except that none of the resources may be redistributed and none of the resources may be used with other software. Links to this page are encouraged as well as use of the data in stories and analyses. Any use of these resources is solely at the discretion of the user. There is no warranty or guarantee of any type. Additional Information ProximityOne develops geographic-demographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our tools (software, data, methodologies) to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact ProximityOne (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest. |
|
|
