ProximityOne Home Page Resources to create and apply insight




State Patterns Main

  Situation & Outlook

  CVXE GIS Tools

  Data Resources Guide
  - projections to 2060

  Related Sections
  - Applications Gallery
  - States
  - Congressional District
  - School Districts
  - Counties
  - Cities/Places
  - Tracts/Neighborhoods
  - Block Groups
  - Census Blocks

  - ZIP Codes
  - Urban Areas

  Estimates-Projections
  - 2060 Demographic
    ... all county interactive table
  - 2030 Demographic-Economic
  - Single Year of Age

  GIS Thematic Mapping
    Visual Analysis Tools

  Ranking Tables
    National Scope
    Demographic Change
    2000-2010
  - States
  - Metros
  - Congressional District
  - School Districts
  - Counties
  - Cities/Places
  - Census Tracts



 
Decision-Making Information
  ProximityOne
  information resources & solutions
  (888) DMI-SOLN
  (888) 364-7656

Visual analysis with ProximityOne tools
click graphic for info; hover to pause

 
visually analyze clients/markets
site analysis using 1 mile radius

S1

$median household income
patterns by census tract - Houston

hover to pause

113th Congressional Districts

Click for info

US Asian Indian population 2010

Click for info

geocoded students and school
McKinney ISD, TX

Click for info

geocoded students and school
with tax parcels & streets

Click for info

high school attendance zones
with schools by type

Click for info

%high school graduates by
census tract - Puerto Rico

Click for info

Austin, TX MSA counties &
places 10K+ population markers

Click for info

Appalachia counties (green) &
coalfield counties (orange)

Click for info

China provinces percent urban &
cities (markers) by state plan

Click for info

Honolulu census tracts (red)
& census blocks


Central Park area NYC

Click for info

Kansas City Metro & Counties
Home Depot locations (markers)

Click for info

World Cities; focus on Spain

Click for info

Mapping Missouri Neighborhood Patterns
... 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
  use Identify tool to show mini-profile of a tract attributes.


4. View Layer Data as Table/Spreadsheet
  use Database>dBrowse to view/query tracts in tabular manner.


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
  StateFIPS state code
  CountyFIPS county code
  TractCensus tract code
  GEOIDST+CTY+TRACT
  STABState postal abbreviation
  CBSACore-Based Statistical Area
General Demographics Items
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
HMDA01Small county flag. T=tract record S=small county I=Island Area 1
HMDA02Split tract flag. N=tract number occurs w/in one MA S=split between MAs
HMDA03Demographic data flag. X=Tot persons/population or median family income is 0
D=tot persons/population and median family income are not 0
I=Island Area 1
HMDA04Urban/rural flag. U=urban R=rural M=mixed I=Island Area 1
HMDA05Median Family Income of MSA in which tract resides 8 N ACS B19113_1 at MSA level
HMDA06Median Household Income of MSA in which tract resides 8 N ACS B19013_1 at MSA level
HMDA07Tract median family income as a percentage of the MSA/MD median family income. Two decimal places
HMDA08FFIEC Estimated MSA/MD Median Family Income 8 N
HMDA09Total persons 8 N SF1 P0010001
HMDA10Total families 8 N ACS B19101_1
HMDA11Total households 8 N ACS B19001_1
HMDA12Total female population 8 N SF1 P0120026
HMDA13Total male population 8 N SF1 P0120002
HMDA14Total population minus white alone population 8 N SF1 P0090001-P0090005
HMDA15Minority population as percent of tract population to two decimal places 6 N
SF1 When P0090001 is 0, then 0. Else, (P0090001-P0090005)*100.00/P0090001

HMDAS1Identifies Income Level Indicator (low, mod, mid, upper income areas) 1 N
Tract Income Level
  Corresponds to classifications defined by HMDA and CRA regulations; based on tract Median Family Income (MFI) percent:
  1 Median Family Income % is < 50% then the Income Level is Low (5,588)
  2 Median Family Income % is ≥ 50% and < 80% then the Income Level is Moderate (15,998)
  3 Median Family Income % is ≥ 80% and < 120% then the Income Level is Middle (31,940)
  4 Median Family Income % is ≥ 120% then the Income Level is Upper (18,527)
  0 Median Family Income % is 0% then the Income Level is not known (838)
HMDAS2Meets current year's poverty CRA distressed criterion? 'X' - Yes , ' ' (blank space) - No 1
HMDAS3Meets current year's unemployment CRA distressed criterion? 'X' - Yes , ' ' (blank space) - No 1
HMDAS4Meets current year's population CRA distressed criterion? 'X' - Yes , ' ' (blank space) - No 1
HMDAS5Meets current year's remote rural (low density) CRA underserved criterion? 'X' -Yes, ' ' (blank space) - No 1
HMDAS6Meets at least one of the previous year's CRA distressed criteria? 'X' - Yes , ' ' (blank space) - No 1
HMDAS7Meets previous year's CRA underserved criterion? 'X' - Yes , ' ' (blank space) - No 1
HMDAS8Meets at least one of current or previous year's CRA distressed/underserved tract criteria? 'X' - Yes, ' ' (blank space) - No 1


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.


Copyright © . ProximityOne. All Rights Reserved.
Sitemap | Contact Us | News