Accessing & Using Geographic-Demographic-Economic Data
GeoSpatial Analytics
Join us in the weekly web sessions where we review wide-ranging topics on
• current and trending geographic-demographic-economic characteristics
• tools to access & use demographic-economic data with other data
• using decision-making information & developing insights
One-hour Data web sessions are conducted by Warren Glimpse.
• Tuesdays 3:00 pm ET; Accessing & Using Demographic-Economic Data
• Thursdays 3:00 pm ET; GeoSpatial Analytics
Visual Data Analytics (VDA) Training & Support
• gain insights into information change, patterns that might affect you
• see connectivity details below
Who benefits? Anyone who is directly or indirectly engaged in accessing/using geographic, demographic, economic data for management,
analysis or decision-making. While we cover many technical details, managers and leaders benefit from understanding what is possible even though perhaps not engaged in daily
data development or analytics. Topics are heavily cross-related. The thread of small area demographics runs throughout the sessions,
even though the main topic might be on congressional districts or cities/counties. The sessions provide a forum for problem-solving and continuity not found elsewhere.
E-mail us or call (888-364-7656) with questions/help.
06.09.22. GeoSpatial Analytics: Using Census TIGER & MetroDynamics GIS
Archived
GeoSpatial Analytics: Mapping Statistical Data
.. what this is and why it is important
FFIEC & HUD low and moderate income data and applications focus on
census tracts
The focus here is on block groups.
.. also these applications provide flexibility in defining "minority population" and income metrics.
Objective
The objective is to create thematic pattern maps showing Merced County, CA area block groups (BGs) that meet the criteria:
>= 60% minority population or HH income <80% of the median income
.. see Merced County, CA Demographic-Economic Profile
Follow these steps:
Build Required Demographics Data File
Access/develop the basic demographics data file.
Do this using DEDE – http://proximityone.com/dede.htm
.. to develop the California by 2020 block group dataset.
.. illustrate real-time
.. the resulting dbf contains a row for each CA BG.
.. columns contain the ACS 2020 subject matter fields as described in
this metadata file.
.. scope of data much broader application potential ..discuss
Among the items in that file are median household income, median family income
and a set of fields useful to determine minority population. Two computed fields are included:
minority and percent minority.
The definition of minority used here is (total population – white alone, nonHispanic population).
Define minority other ways as desired.
Integrate Demographics into Shapefile
The above dbf file is integrated into a California by block group shapefile.
.. using the CV XE GIS Database>dBMerge feature.
.. this uses the CA 2020 BG shapefile
Add Shapefile to GIS Project; Create Map Views
Two map views have been developed using CV XE GIS.
California by block group where the BG is selected/colored when:
%minority <60% or MFI<80% of CA MFI (89798)
Zoom into the Merced County area:
Other Considerations
The original objective involved use of median household income.
.. median family income is used for the map views; both are in the dataset.
The original criteria references "below 80%" (median household income) which requires a "parent area"
.. these applications used California statewide ($89,798).
.. an alternative might be to substitute the CA statewide MHI with the Merced county MHI.
.. here is the link to ACS 2020 5-year CA economic profile showing MFH & MFI:
.. scroll down to locate MHI & MFI
.. use a variation on this to get the Merced county value.
06.14.22. MetroDynamics: Examining Metro Characteristics & Trends
Archived
General update notes:
• Census 2020 data access delayed; next data release May 2023
.. only data available now is from P.L. 94-171 .. basically
these items
.. the P.L. 94-171 data are the only source of 2020 block level data now available
• U.S. National Scope Census TIGER Edges+ Geography & VDA Applications
.. 75+ million intersection to intersection street/road segments
• Housing Price Index updated; annually through 2021
.. by census tract, ZIP code, county
.. now integrated into Location-Based Demographics tool
• Demographic-Economic Data Explorer (DEDE) updated
.. 2020 County Business Patterns; new ACS Table/Item Access; new Insights profile
Topics:
• Situation & Outlook Weekly Demographic-Economic Update
.. what this is and why it is important
.. examining 384 metros/MSAs, states, U.S.
- each week, one metro, related state, U.S.
- all areas in monthly report.
.. past quarter, now, one year ahead
.. content example
California
Composite Index
..
Work Force
.. March 2022 unemployment rate: 4.9%
.. Year-over-year change in unemployment Feb. 2021: 6.4%
GDP
.. Q4 2021 GDP per capita: $89,540
.. GDP growth Q3 2021-Q4 2021: 9.5%
Inflation & Cost of Living
.. Measuring inflation
.. CPI
.. Personal consumption expenditure index
Establishments (quarterly 941 based)
.. Number
.. Employment (monthly)
.. Average weekly wages Sept. 2020: $1,576
.. Percent change in average weekly wages Sept. 2020-Sept. 2021: 7.7%
Income, Consumption & Poverty
.. Median household income
.. Median family income
.. Personal consumption expenditures
.. Percent of population below poverty line 2020: 10.6%
Migration
..
Housing
.. Total, occupied, vacant
.. Homeowner vacancy rate
.. Rental vacancy rate
.. Median housing value
.. Building permits (by units in structure & valuation)
Patterns of Net Migration by Metro
.. sum of annual net migration year ending 6/30/2011-6/30/2020
• Core-Based Statistical Areas (Metros: MSAs & MISAs) (Metros)
.. what this is and why it is important
.. resources reviewed here
- Demographic Economic Data Explorer -- DEDE
- VDA Desktop GIS
- VDA Web GIS
- Geographic Information System GIS Projects & project filesets
Review of Data Resources; Access & Use
• Census 2020
.. P.L. 94-171 data (~30 subject matter items
.. more extended data May 2023
.. using DEDE to access these data
• Census model-based population estimates program (one element is interactive table)
• Census model-based annual housing unit annual estimates all counties (only FSS source)
• Census model-based annual median household income estimates all counties (only FSS source)
• Census Housing Vacancy Survey (75 metros)
• Census Building Permits by units in structure & value (Annual 2021 data released May 2022)
• BLS Consumer Price Index (top right)
• BLS Employment & Unemployment (survey)
• BLS Quarterly Establishments, Employment & Wages by 6-digit NAICS (administratively reported 941)
• BEA Personal Inocme by Major Source (and related)
• BEA Gross Domestic Product (and related)
.. regional price parities index
• FHFA Quarterly Housing Price Index
Related
• City/Place Population Trends
• County Population Trends
• County Population Projections to 2060
06.16.22. GeoSpatial Analytics: Using Digital Map Databases & MetroDynamics GIS
Archived
GeoSpatial Analytics: Mapping Statistical Data
.. what this is and why it is important
• Situation & Outlook Projections Feature Added to DEDE
.. new Outlook feature is introduced
.. the DEDE page is not yet updated.
.. to start the Outlook feature, click Tools>Outlook; a new form appears .. dbl-click any county in listbox
.. not fully in operation and awaits release of Census county age race/origin gender data at the end of June
.. user enabled to generate any county(s) annual estimates and projections through 2060
.. start-up uses a default scenario/model
.. underlying database might be updated quarterly
.. user will be able to set their own assumptions; create alternative scenario projections
.. other data categories will be added, selected ACS, other BEA/BLS data and yet other data.
FFIEC & HUD low and moderate income data and applications focus on
census tracts
The focus here is on block groups.
.. also these applications provide flexibility in defining "minority population" and income metrics.
Objective
The objective is to create thematic pattern maps showing Merced County, CA area block groups (BGs) that meet the criteria:
>= 60% minority population or $MHI <80% of the parent area $MHI
.. see Merced County, CA Demographic-Economic Profile
Follow these steps:
Build Required Demographics Data File
Access/develop the basic demographics data file.
Do this using DEDE – http://proximityone.com/dede.htm
.. to develop the California by 2020 block group dataset.
.. illustrate real-time
.. the resulting dbf contains a row for each CA BG.
.. columns contain the ACS 2020 subject matter fields as described in
this metadata file.
.. scope of data much broader application potential ..discuss
Among the items in that file are median household income, median family income
and a set of fields useful to determine minority population. Two computed fields are included:
minority and percent minority.
The definition of minority used here is (total population – white alone, nonHispanic population).
Define minority other ways as desired.
Integrate Demographics into Shapefile
The above dbf file is integrated into a California by block group shapefile.
.. using the CV XE GIS Database>dBMerge feature.
.. this uses the CA 2020 BG shapefile
Add Shapefile to GIS Project; Create Map Views
Two map views have been developed using CV XE GIS.
California by block group where the BG is selected/colored when:
>= 60% minority population or $MHI <80% of the parent area $MHI (CA MHI $89,798)
Zoom into the Merced County area:
Other Considerations
The original objective involved use of median household income.
.. median family income is used for the map views; both are in the dataset.
The original criteria references "below 80%" (median household income) which requires a "parent area"
.. these applications used California statewide ($89,798).
.. an alternative might be to substitute the CA statewide MHI with the Merced county MHI.
.. here is the link to ACS 2020 5-year CA economic profile showing MFH & MFI:
.. scroll down to locate MHI & MFI
.. use a variation on this to get the Merced county value.
Refresh this page to get the most up-to-date information.
06.21.22. MetroDynamics: Examining Metro Characteristics & Trends
Archived
General update notes:
• Census 2020 data access delayed; next data release May 2023
.. only data available now is from P.L. 94-171 .. basically
these items
.. the P.L. 94-171 data are the only source of 2020 block level data now available
• U.S. National Scope Census TIGER Edges+ Geography & VDA Applications
.. 75+ million intersection to intersection street/road segments
• Housing Price Index updated; annually through 2021
.. by census tract, ZIP code, county
.. now integrated into Location-Based Demographics tool
• Demographic-Economic Data Explorer (DEDE) updated
.. 2020 County Business Patterns; new ACS Table/Item Access; new Insights profile
Topics:
• Situation & Outlook Weekly Demographic-Economic Update
.. what this is and why it is important
.. examining 384 metros/MSAs, states, U.S.
- each week, one metro, related state, U.S.
- all areas in monthly report.
.. past quarter, now, one year ahead
.. content example
California
Composite Index
..
Work Force
.. March 2022 unemployment rate: 4.9%
.. Year-over-year change in unemployment Feb. 2021: 6.4%
GDP
.. Q4 2021 GDP per capita: $89,540
.. GDP growth Q3 2021-Q4 2021: 9.5%
Inflation & Cost of Living
.. Measuring inflation
.. CPI
.. Personal consumption expenditure index
Establishments (quarterly 941 based)
.. Number
.. Employment (monthly)
.. Average weekly wages Sept. 2020: $1,576
.. Percent change in average weekly wages Sept. 2020-Sept. 2021: 7.7%
Income, Consumption & Poverty
.. Median household income
.. Median family income
.. Personal consumption expenditures
.. Percent of population below poverty line 2020: 10.6%
Migration
..
Housing
.. Total, occupied, vacant
.. Homeowner vacancy rate
.. Rental vacancy rate
.. Median housing value
.. Building permits (by units in structure & valuation)
Patterns of Net Migration by Metro
.. sum of annual net migration year ending 6/30/2011-6/30/2020
• Core-Based Statistical Areas (Metros: MSAs & MISAs) (Metros)
.. what this is and why it is important
.. resources reviewed here
- Demographic Economic Data Explorer -- DEDE
- VDA Desktop GIS
- VDA Web GIS
- Geographic Information System GIS Projects & project filesets
Review of Data Resources; Access & Use
• Census 2020
.. P.L. 94-171 data (~30 subject matter items
.. more extended data May 2023
.. using DEDE to access these data
• Census model-based population estimates program (one element is interactive table)
• Census model-based annual housing unit annual estimates all counties (only FSS source)
• Census model-based annual median household income estimates all counties (only FSS source)
• Census Housing Vacancy Survey (75 metros)
• Census Building Permits by units in structure & value (Annual 2021 data released May 2022)
• BLS Consumer Price Index (top right)
• BLS Employment & Unemployment (survey)
• BLS Quarterly Establishments, Employment & Wages by 6-digit NAICS (administratively reported 941)
• BEA Personal Inocme by Major Source (and related)
• BEA Gross Domestic Product (and related)
.. regional price parities index
• FHFA Quarterly Housing Price Index
Related
• City/Place Population Trends
• County Population Trends
• County Population Projections to 2060
06.23.22. GeoSpatial Analytics: Using Census TIGER & MetroDynamics GIS
Archived
GeoSpatial Analytics: Mapping Statistical Data
.. what this is and why it is important
• Situation & Outlook Projections Feature Added to DEDE
.. new Outlook feature is introduced
.. the DEDE page is not yet updated.
.. to start the Outlook feature, click Tools>Outlook; a new form appears .. dbl-click any county in listbox
.. not fully in operation and awaits release of Census county age race/origin gender data at the end of June
.. user enabled to generate any county(s) annual estimates and projections through 2060
.. start-up uses a default scenario/model
.. underlying database might be updated quarterly
.. user will be able to set their own assumptions; create alternative scenario projections
.. other data categories will be added, selected ACS, other BEA/BLS data and yet other data.
FFIEC & HUD low and moderate income data and applications focus on
census tracts
The focus here is on block groups.
.. also these applications provide flexibility in defining "minority population" and income metrics.
Objective
The objective is to create thematic pattern maps showing Merced County, CA area block groups (BGs) that meet the criteria:
>= 60% minority population or $MHI <80% of the parent area $MHI
.. see Merced County, CA Demographic-Economic Profile
Follow these steps:
Build Required Demographics Data File
Access/develop the basic demographics data file.
Do this using DEDE – http://proximityone.com/dede.htm
.. to develop the California by 2020 block group dataset.
.. illustrate real-time
.. the resulting dbf contains a row for each CA BG.
.. columns contain the ACS 2020 subject matter fields as described in
this metadata file.
.. scope of data much broader application potential ..discuss
When DEDE is used to create the extract file, check these settings:
.. Statistical Program (upper left dropdown): ACS 2020_5
.. Geographic Group dropdown: 150 Block Group
.. Subject Matter Items File Path/Name: D:\dede\api_items_acs20_base.txt
.. Output File Path/Name: D:\dede\api_items_acs20_base_cabg.dbf
.. Query (upper right): stab='CA'
With above 5 items set as shown, click Start button (upper left).
.. it should take 30 seconds to generate the file and the grid populates with extracted data.
Among the items in that file are median household income, median family income
and a set of fields useful to determine minority population. Two computed fields are included:
minority and percent minority.
The definition of minority used here is (total population – white alone, nonHispanic population).
Define minority other ways as desired.
Integrate Demographics into Shapefile
The above dbf file is integrated into a California by block group shapefile.
.. using the CV XE GIS Database>dBMerge feature.
.. this uses the CA 2020 BG shapefile
Add Shapefile to GIS Project; Create Map Views
Two map views have been developed using CV XE GIS.
California by block group where the BG is selected/colored when:
>= 60% minority population or $MHI <80% of the parent area $MHI (CA MHI $89,798)
Zoom into the Merced County area:
Other Considerations
The original objective involved use of median household income.
.. median family income is used for the map views; both are in the dataset.
The original criteria references "below 80%" (median household income) which requires a "parent area"
.. these applications used California statewide ($89,798).
.. an alternative might be to substitute the CA statewide MHI with the Merced county MHI.
.. here is the link to ACS 2020 5-year CA economic profile showing MFH & MFI:
.. scroll down to locate MHI & MFI
.. use a variation on this to get the Merced county value.
06.28.22. Accessing & Using Geographic, Demographic, Economic Data
.. with the weekly demographic-economic update
Time: Jun 28, 2022 03:00 PM Eastern Time (US and Canada)
Meeting link: https://us06web.zoom.us/j/83454974147?pwd=SktFU0dFN2VlSmJqMkZpTmhUS0hHdz09
Meeting ID: 834 5497 4147 -- Passcode: 899957
General update notes:
• Census 2020 data access delayed; next data release May 2023
.. only data available now is from P.L. 94-171 .. basically
these items
.. the P.L. 94-171 data are the only source of 2020 block level data now available
• U.S. National Scope Census TIGER Edges+ Geography & VDA Applications
.. 75+ million intersection to intersection street/road segments
• Housing Price Index updated; annually through 2021
.. by census tract, ZIP code, county
.. now integrated into Location-Based Demographics tool
• Demographic-Economic Data Explorer (DEDE) updated
.. 2020 County Business Patterns; new ACS Table/Item Access; new Insights profile
Topics:
• Situation & Outlook Weekly Demographic-Economic Update
.. what this is and why it is important
.. examining 384 metros/MSAs, states, U.S.
- each week, one metro, related state, U.S.
- all areas in monthly report.
.. past quarter, now, one year ahead
.. content example
California
Composite Index
..
Work Force
.. March 2022 unemployment rate: 4.9%
.. Year-over-year change in unemployment Feb. 2021: 6.4%
GDP
.. Q4 2021 GDP per capita: $89,540
.. GDP growth Q3 2021-Q4 2021: 9.5%
Inflation & Cost of Living
.. Measuring inflation
.. CPI
.. Personal consumption expenditure index
Establishments (quarterly 941 based)
.. Number
.. Employment (monthly)
.. Average weekly wages Sept. 2020: $1,576
.. Percent change in average weekly wages Sept. 2020-Sept. 2021: 7.7%
Income, Consumption & Poverty
.. Median household income
.. Median family income
.. Personal consumption expenditures
.. Percent of population below poverty line 2020: 10.6%
Migration
..
Housing
.. Total, occupied, vacant
.. Homeowner vacancy rate
.. Rental vacancy rate
.. Median housing value
.. Building permits (by units in structure & valuation)
Patterns of Net Migration by Metro
.. sum of annual net migration year ending 6/30/2011-6/30/2020
• Core-Based Statistical Areas (Metros: MSAs & MISAs) (Metros)
.. what this is and why it is important
.. resources reviewed here
- Demographic Economic Data Explorer -- DEDE
- VDA Desktop GIS
- VDA Web GIS
- Geographic Information System GIS Projects & project filesets
Review of Data Resources; Access & Use
• Census 2020
.. P.L. 94-171 data (~30 subject matter items
.. more extended data May 2023
.. using DEDE to access these data
• Census model-based population estimates program (one element is interactive table)
• Census model-based annual housing unit annual estimates all counties (only FSS source)
• Census model-based annual median household income estimates all counties (only FSS source)
• Census Housing Vacancy Survey (75 metros)
• Census Building Permits by units in structure & value (Annual 2021 data released May 2022)
• BLS Consumer Price Index (top right)
• BLS Employment & Unemployment (survey)
• BLS Quarterly Establishments, Employment & Wages by 6-digit NAICS (administratively reported 941)
• BEA Personal Inocme by Major Source (and related)
• BEA Gross Domestic Product (and related)
.. regional price parities index
• FHFA Quarterly Housing Price Index
Related
• City/Place Population Trends
• County Population Trends
• County Population Projections to 2060
06.30.22. GeoSpatial Analytics: Using Census TIGER & GIS Applications
Time: Jun 30, 2022 03:00 PM Eastern Time (US and Canada)
Meeting link: https://us06web.zoom.us/j/84809107049?pwd=KzMzWFNwdWlvM3VVVVFWRTkzejg2UT09
Meeting ID: 848 0910 7049 -- Passcode: 110248
GeoSpatial Analytics: Mapping Statistical Data
.. what this is and why it is important
• Situation & Outlook Projections Feature Added to DEDE
.. new Outlook feature is introduced
.. the DEDE page is not yet updated.
.. to start the Outlook feature, click Tools>Outlook; a new form appears .. dbl-click any county in listbox
.. not fully in operation and awaits release of Census county age race/origin gender data at the end of June
.. user enabled to generate any county(s) annual estimates and projections through 2060
.. start-up uses a default scenario/model
.. underlying database might be updated quarterly
.. user will be able to set their own assumptions; create alternative scenario projections
.. other data categories will be added, selected ACS, other BEA/BLS data and yet other data.
FFIEC & HUD low and moderate income data and applications focus on
census tracts
The focus here is on block groups.
.. also these applications provide flexibility in defining "minority population" and income metrics.
Objective
The objective is to create thematic pattern maps showing Merced County, CA area block groups (BGs) that meet the criteria:
>= 60% minority population or $MHI <80% of the parent area $MHI
.. see Merced County, CA Demographic-Economic Profile
Follow these steps:
Build Required Demographics Data File
Access/develop the basic demographics data file.
Do this using DEDE – http://proximityone.com/dede.htm
.. to develop the California by 2020 block group dataset.
.. illustrate real-time
.. the resulting dbf contains a row for each CA BG.
.. columns contain the ACS 2020 subject matter fields as described in
this metadata file.
.. scope of data much broader application potential ..discuss
When DEDE is used to create the extract file, check these settings:
.. Statistical Program (upper left dropdown): ACS 2020_5
.. Geographic Group dropdown: 150 Block Group
.. Subject Matter Items File Path/Name: D:\dede\api_items_acs20_base.txt
.. Output File Path/Name: D:\dede\api_items_acs20_base_cabg.dbf
.. Query (upper right): stab='CA'
With above 5 items set as shown, click Start button (upper left).
.. it should take 30 seconds to generate the file and the grid populates with extracted data.
Among the items in that file are median household income, median family income
and a set of fields useful to determine minority population. Two computed fields are included:
minority and percent minority.
The definition of minority used here is (total population – white alone, nonHispanic population).
Define minority other ways as desired.
Integrate Demographics into Shapefile
The above dbf file is integrated into a California by block group shapefile.
.. using the CV XE GIS Database>dBMerge feature.
.. this uses the CA 2020 BG shapefile
Add Shapefile to GIS Project; Create Map Views
Two map views have been developed using CV XE GIS.
California by block group where the BG is selected/colored when:
>= 60% minority population or $MHI <80% of the parent area $MHI (CA MHI $89,798)
Zoom into the Merced County area:
Other Considerations
The original objective involved use of median household income.
.. median family income is used for the map views; both are in the dataset.
The original criteria references "below 80%" (median household income) which requires a "parent area"
.. these applications used California statewide ($89,798).
.. an alternative might be to substitute the CA statewide MHI with the Merced county MHI.
.. here is the link to ACS 2020 5-year CA economic profile showing MFH & MFI:
.. scroll down to locate MHI & MFI
.. use a variation on this to get the Merced county value.
07.12.22. Examining the School District Community
Time: Jul 12, 2022 03:00 PM Eastern Time
Meeting link mailed to registrants
• Applications using ..
- Demographic Economic Data Explorer -- DEDE
- VDA Desktop GIS
- VDA Web GIS
- Geographic Information System GIS Projects & project filesets
07.14.22. GeoSpatial Analytics: Mapping & GIS Applications Using TIGER .. goto top
• Geographic Information Systems
.. what this is and why it is important
.. Desktop (Windows) .. VDA Desktop GIS
.. Web (any browser/device) .. VDA Web GIS
• TIGER Digital Map Database
01. what this is and why it is important
.. Topologically Integrated Geographic, Encoding & Reference (TIGER)
.. origin, purpose, role, scope, importance, and organization of TIGER files
02. Using TIGER with Geographic Information Systems
.. Desktop (Windows) .. VDA Desktop GIS
.. Web (any browser/device) .. VDA Web GIS
03. review of TIGER BASE GIS project and TIGER files
.. some terminology
04. install (Windows computer) & using VDA Desktop GIS with TIGER & demographic data
.. requires no fee UserGroup userid (register; check VDA Installer)
.. install & run in advance of session recommended; not required
.. an overview of basic operations
05. organization, content, structure of BASE GIS Project
06. organization of TIGER shapefiles and accessing other shapefiles
07. integrating subject matter data into shapefiles
.. Census-sourced ACS 2020 data into TIGER tract shapefile (using DEDE)
.. Census-sourced Census 2020 data into TIGER census block shapefile (using DEDE)
.. BEA-sourced GDP data into TIGER county shapefile
08. adding non-Census sourced shapefile
.. address coded data
09. creating thematic pattern maps using above integrated shapefiles
10. interpreting results
11. saving the GIS project & extending it
12. creating your own projects
13. accessing a VDA Desktop GIS project via VDA Web GIS
• Using the TIGER Shapefiles with VDA Web GIS
.. what this is and why it is important
.. LBD illustrative view
Additional Information
ProximityOne develops geodemographic-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 us (888-364-7656) with questions about data covered in this section or to discuss
custom estimates, projections or analyses for your areas of interest.
