CV XE GIS Home Page






  ProximityOne Main

  Geospatial Analytics
    VDA Web GIS
    VDA Desktop GIS
    DEDE Data Access

  S&O Metro Reports

  Situation & Outlook

  Related Sections
  - States
  - School Districts
  - Metros
  - Congressional
  - Counties
  - Census Tracts
  - Block Groups
  - Census Blocks
  - ZIP Codes
  - Urban Areas

  Estimates-Projections
  - County Interactive
  - 5-year Projections
  - Quarterly Projections
  - 2030 Projections
  - 2060 Projections

  CV XE GIS
    Visual Analysis

  Interactive Tables

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


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





Data Analytics Blog
Power of Combining Maps with Data


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

Metros Interactive Table Updates
  Interactive Table Groups

Resource Summary
    .. Demographic Economic Data Explorer -- DEDE
    .. VDA Desktop GIS
    .. VDA Web GIS
    .. Geographic Information System GIS Projects & project filesets
        - MetroDynamics
    .. Digital Map Databases

Application: Low and Moderate Income Data Analytics by Block Group
See more about Examining Low and Moderate Income

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)

  • MetroDynamics
.. http://proximityone.com/md.htm

  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

  • American Community Survey (ACS)
    .. ACS 2019 1 Year Estimates Demographic-Economic Characteristics
    .. ACS 2020 5 Year Estimates Demographic-Economic Characteristics
    .. using DEDE to access these data
    .. General Demographics .. Social Characteristics .. Economic Characteristics .. Housing Characteristics

  • CBSA Vintage Definitions

  • CBSA Shapefiles
    .. TIGER 2020 CBSA non-smoothed zip file
    .. TIGER 2020 CBSA smoothed zip file
    .. TIGER 2020 county non-smoothed zip file
        .. these county dbf records included the CBSA code

  • 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

Selected Topics
  • VDA Web GIS .. Smartphone interface updates reviewed
    ..

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

  • Metros Interactive Table updates reviewed

Resources to create & apply insights ..
  • Demographic Economic Data Explorer -- DEDE
  • VDA Desktop GIS
  • VDA Web GIS
  • Digital Map Databases
  • Geographic Information System GIS Projects & project filesets
    .. Situation & Outlook
    .. MetroDynamics
    .. TIGER
    .. Congressional Communities

Application: Low and Moderate Income Data Analytics by Block Group
See more about Examining Low and Moderate Income

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)

  • MetroDynamics
.. http://proximityone.com/md.htm

  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

  • American Community Survey (ACS)
    .. ACS 2019 1 Year Estimates Demographic-Economic Characteristics
    .. ACS 2020 5 Year Estimates Demographic-Economic Characteristics
    .. using DEDE to access these data
    .. General Demographics .. Social Characteristics .. Economic Characteristics .. Housing Characteristics

  • CBSA Vintage Definitions

  • CBSA Shapefiles
    .. TIGER 2020 CBSA non-smoothed zip file
    .. TIGER 2020 CBSA smoothed zip file
    .. TIGER 2020 county non-smoothed zip file
        .. these county dbf records included the CBSA code

  • 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

Selected Topics
  • VDA Web GIS .. Smartphone interface updates reviewed
    ..

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

  • Metros Interactive Table updates reviewed

Resources to create & apply insights ..
  • Demographic Economic Data Explorer -- DEDE
  • VDA Desktop GIS
  • VDA Web GIS
  • Digital Map Databases
  • Geographic Information System GIS Projects & project filesets
    .. Situation & Outlook
    .. MetroDynamics
    .. TIGER
    .. Congressional Communities

Application: Low and Moderate Income Data Analytics by Block Group
See more about Examining Low and Moderate Income

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)

  • MetroDynamics
.. http://proximityone.com/md.htm

  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

  • American Community Survey (ACS)
    .. ACS 2019 1 Year Estimates Demographic-Economic Characteristics
    .. ACS 2020 5 Year Estimates Demographic-Economic Characteristics
    .. using DEDE to access these data
    .. General Demographics .. Social Characteristics .. Economic Characteristics .. Housing Characteristics

  • CBSA Vintage Definitions

  • CBSA Shapefiles
    .. TIGER 2020 CBSA non-smoothed zip file
    .. TIGER 2020 CBSA smoothed zip file
    .. TIGER 2020 county non-smoothed zip file
        .. these county dbf records included the CBSA code

  • 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

Selected Topics
  • VDA Web GIS .. Smartphone interface updates reviewed
    ..

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

  • Metros Interactive Table updates reviewed

Resources to create & apply insights ..
  • Demographic Economic Data Explorer -- DEDE
  • VDA Desktop GIS
  • VDA Web GIS
  • Digital Map Databases
  • Geographic Information System GIS Projects & project filesets
    .. Situation & Outlook
    .. MetroDynamics
    .. TIGER
    .. Congressional Communities

Application: Low and Moderate Income Data Analytics by Block Group
See more about Examining Low and Moderate Income

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
Topics:
  • Examining the K-12 School District Community
    .. what this is and why it is important
  • Focus Region: Central New York School Districts
    .. Camden
    .. Canastota
    .. Hamilton
    .. Madison
    .. Morrisville-Eaton
    .. Oneida City .. demographic-econmic profile
    .. Rome City
    .. Stockbridge Valley
    .. Vernon-Verona-Sherrill

  • Applications using ..
        - Demographic Economic Data Explorer -- DEDE
        - VDA Desktop GIS
        - VDA Web GIS
        - Geographic Information System GIS Projects & project filesets

  • School Attendance Zones

  • Sources & Uses of Funds



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.


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