Mapping Missouri Neighborhood Patterns
information resources & solutions
Visual analysis with ProximityOne tools
click graphic for info; hover to pause
... 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
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
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.
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
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
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 ...
General Demographics Items
| State||FIPS state code|
| County||FIPS county code|
| Tract||Census tract code|
| STAB||State postal abbreviation|
| CBSA||Core-Based Statistical Area|
P2010 Total population (Census 2010; remaining items ACS 2011 5 year estimates)
AGE AND GENDER
D001 Total population
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
D025 65 years and over
D028 Total population
D029 One race
D030 Two or more races
D031 One race
D033 Black or African American
D034 American Indian and Alaska Native
D047 Native Hawaiian and Other Pacific Islander
D052 Some other race
D053 Two or more races
D066 Hispanic or Latino (of any race)
D068 Puerto Rican
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
S017 Population in households
S052 Population 3 years and over enrolled in school
S053 Nursery school, preschool
S055 Elementary school (grades 1-8)
S056 High school (grades 9-12)
S057 College or graduate school
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
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"
S115 Speak English less than "very well"
Economic Characteristics Items
E001 Population 16 years and over
E002 In labor force
E003 Civilian labor force
E006 Armed Forces
E007 Not in labor force
E008 Civilian labor force
E009 Percent Unemployed
Civilian employed population 16 years and over
E033 Agriculture, forestry, fishing and hunting, and mining
E036 Wholesale trade
E037 Retail trade
E038 Transportation and warehousing, and utilities
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)
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)
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
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
Occupied housing units
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
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)
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
|HMDA01||Small county flag. T=tract record S=small county I=Island Area 1 |
|HMDA02||Split tract flag. N=tract number occurs w/in one MA S=split between MAs |
|HMDA03||Demographic 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
|HMDA04||Urban/rural flag. U=urban R=rural M=mixed I=Island Area 1 |
|HMDA05||Median Family Income of MSA in which tract resides 8 N ACS B19113_1 at MSA level |
|HMDA06||Median Household Income of MSA in which tract resides 8 N ACS B19013_1 at MSA level |
|HMDA07||Tract median family income as a percentage of the MSA/MD median family income. Two decimal places |
|HMDA08||FFIEC Estimated MSA/MD Median Family Income 8 N |
|HMDA09||Total persons 8 N SF1 P0010001 |
|HMDA10||Total families 8 N ACS B19101_1 |
|HMDA11||Total households 8 N ACS B19001_1 |
|HMDA12||Total female population 8 N SF1 P0120026 |
|HMDA13||Total male population 8 N SF1 P0120002 |
|HMDA14||Total population minus white alone population 8 N SF1 P0090001-P0090005
|HMDA15||Minority 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
|HMDAS1||Identifies 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)
|HMDAS2||Meets current year's poverty CRA distressed criterion? 'X' - Yes , ' ' (blank space) - No 1 |
|HMDAS3||Meets current year's unemployment CRA distressed criterion? 'X' - Yes , ' ' (blank space) - No 1 |
|HMDAS4||Meets current year's population CRA distressed criterion? 'X' - Yes , ' ' (blank space) - No 1 |
|HMDAS5||Meets current year's remote rural (low density) CRA underserved criterion? 'X' -Yes, ' ' (blank space) - No 1 |
|HMDAS6||Meets at least one of the previous year's CRA distressed criteria? 'X' - Yes , ' ' (blank space) - No 1 |
|HMDAS7||Meets previous year's CRA underserved criterion? 'X' - Yes , ' ' (blank space) - No 1 |
|HMDAS8||Meets at least one of current or previous year's CRA distressed/underserved tract criteria? 'X' - Yes, ' ' (blank space) - No 1 |
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.
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
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.