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


 
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
    Federal GeoStatistical Data


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
  • Wednesdays 3:00 pm ET; Congressional Districts & Congressional Communities
      strategists needing to understand district demographic-economic change
      policymakers and staff dealing with congressional policy development
      residents/constituents who are/want to be members of a CC
      learners & researchers regarding CC, CD mapping & geodemographic topics
  • 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.

ProximityOne develops and uses tools and data to provide fact-based, independent, non-partisan decision-making information to stakeholders on a wide range topics/issues. We focus on accessing, modeling and analyzing geographic, demographic and economic data to better understand recent trends and project future demographic-economic characteristics.

10.25.23. Congressional District & Congressional Community Demographic Patterns
.. a ProximityOne & Congressional Communities collaborative program
Every Wednesday -- 03:00 PM Eastern Time (US and Canada)
Meeting link: https://us06web.zoom.us/j/85954760288?pwd=fENb51ZjoOZ27bYFHJlrXPVbGHEVEn.1
Meeting ID: Meeting ID: 859 5476 0288 .. Passcode: 564716
  .. above link & ID the same on Wednesdays through December 2023
Navigating the Website & Accessing Resources

.. did you know? .. 19 congressional districts have lost more than 4% population since 2020? Which ones? What is causing the loss? How is the loss distributed across the district? Will these trends continue? Which districts are growing? Based on the 2020 Census, the Diversity Index for the 118th Congressional Districts ranged from 12.5% (Kentucky 05) to 78.5% (Hawaii 02). What and why is the Diversity Index important? What are economic characteristics of districts? How can you have your voice better heard by Congress through a congressional community? How can stakeholders easily relate diverse topics like school districts, K-12 education, urban/rural areas, low and moderate income by census tract, ZIP codes, state legislative districts among others to congressional districts? Get answers here. Learn more about these topics in this session.

Why is FL Congressional District 28 Losing Population?


Concepts, Terminology & References for this Session
Congressional Districts. The November 2022 elections determined the representatives for the 118th Congressional Districts (CDs) January 2023-December 2024 session. The 118th Congressional District boundaries reflect the redistricting process based on Census 2020 results.

Congressional Communities. Congressional Communities (CC) are a concept and development of Congressional Communities, a non-profit organization. CCs have been developed to better enable constituents have their voice heard by policymakers and vice-versa. The approximate 7,400 CCs cover the U.S. wall-to-wall developed by the CC team and typically range from 30,000 to 70,000 population. CCs have been developed based on several criteria and are not arbitrary subdivisions of CDs. There are a set of CCs that nest exactly within each CD. Demographic data have been developed for each CC based on Census 2020 census block data by the CC team.

CC stakeholders may map and geospatially analyze their CCs and CDs.
CC organizations are comprised of residents of their respective CCs.
join a Congressional Community .. illustrative details for a Congressional Community

References
  • Census Bureau Redistricting Data Program .. operation & selected topics
  • Census Bureau TIGER 2023 .. new

Topics In this session eight topics are covered.
.. illustrative applications are focused on CA CD 47. Use your own CD/region of interest.
.. this is not a slide show. Ask questions as we go.
.. ~30 minute presentation followed by discussion.

Topic sections:
01 CD/CC Visualization using the Open VDA Web GIS
02 118th Congressional Districts & 2020-2022 Demographics
03 118th Congressional District & Congressional Community Diversity
04 Related Geographies -- Cities/Places; Census Tracts; Other
05 Demographic Analytics -- Comparative GeoDemographic Narrative Profiles
06 Demographic Economic Data Explorer (DEDE)
07 Examining Policy Topics
08 Examining Coalitions

Who this session is for
.. strategists needing to understand district demographic-economic change
.. policymakers and staff dealing with congressional policy development
.. residents/constituents who are/want to be members of a CC
.. earners & researchers regarding CC, CD mapping & geodemographic topics

01. CD/CC Visualization using the Open VDA Web GIS
.. step-by-step example
.. optionally follow-along

Patterns of %Population Change 2020-2022 by 118th Congressional District

  .. learn how to develop variations of this view.

02. 118th Congressional Districts & 2020-2022 Demographics
.. Congressional Districts Main
.. using the CD Census 2020 & ACS 2022 interactive table

In August 2023, the Census Bureau released the first Census 2020 demographics for the 118th Congressional Districts. In September 2023, the Census Bureau released the American Community Survey 2022 1-year estimates (ACS2022) for the 118th Congressional Districts. These data provide reasonably current data on a myriad of socioeconomic data. The Census Bureau also maintains the official national scope boundary files (for mapping and geospatial analysis) for the 118th Congressional Districts.
The Census Bureau also develops the County Business Patterns data for the 118th Congressional DIstricts. Learn more about the scope of these data and how they can be accessed and used. Aside from these data resources, the Federal statistical system (FSS) produces very little data for congressional districts.

What can I learn? Scope of annual ACS-based subject matter.
2022: General Demographics 89 .. Social 154 .. Economic 137 .. Housing 143
2021: General Demographics 91 .. Social 154 .. Economic 137 .. Housing 143

03. 118th Congressional District & Congressional Community Diversity
.. Congressional Districts Diversity
.. using the CD & CC interactive table

Patterns of Diversity by Congressional Community .. CA CD 47
.. click for view with labels; discuss views/operations

  .. learn how to develop variations of this view.

04. Related Geographies -- contextually with CDs & CCs
.. Cities/Places
    - about cities/places
    - using OVDAW to map/analyze cities/places
.. Census Tracts
    - about census tracts
    - tracts demographics interactive table
    - using OVDAW to map/analyze Low & Moderate Income by Census Tract using FFIEC 2023 Data
.. Schools & School Districts
    - subsequent sessions

5. Demographic Analytics -- Comparative GeoDemographic Narrative Profiles
.. using Demographic Analytics (DA) tool to compare CDs, CCs, and other areas
.. Census 2020 "DHC" detailed data released 8/31/23
.. accessing the new Census 2020 DHC-based "Demographic Profile 1" (DP1)
.. examples -- running DA
    - CA CC 0647001 compared to CA CD 47 Tabular Report
    - CA CC 0647001 compared to CA CD 47 Narrative Profile
.. creating tabular report and narrative profile for areas of interest.

.. interpreting the data & insights; examples
    - diversity
    - dependency ratio

06. Demographic Economic Data Explorer (DEDE)
.. creating decennial census, ACS and other data extract files
.. using DEDE .. illustrative applications

07. Examining Policy Topics

08. Examining Coalitions

Discussion.

Attend future sessions. New applications, policy & rules topics, developing skill sets, new data, updated/extended tools, other/more methodologies.

Warren Glimpse
wglimpse@proximityone.com


12.05.23. Accessing & Using GeoStatistical Data Resources
Every Tuesday -- 03:00 PM Eastern Time (US and Canada)
Meeting link: https://us06web.zoom.us/j/85014898649?pwd=TTl4TnYrdUNvZ2x5RVhpREZvU2NPUT09 Meeting ID: 850 1489 8649 -- Passcode: 690129
  .. above link & ID the same on Tuesdays through December 2023
Navigating the Website & Accessing Resources

Warren Glimpse
ProximityOne -- http://proximityone.com
.. we build and apply decision-making information and develop related tools empowering you
wglimpse@proximityone.com

About this Session

This session is designed for a 30 minute presentation and up to 30 minute discussion.
.. the Topics section provides session structure but many items have only passing reference.
.. details vary by week.

Topics
- 01 Federal GeoStatistical System
- 02 Selected News Items

- 03 School District Analytics
- 04 Congressional Districts/Congressional Communities Applications

- 05 Population, Births, Deaths, Migration

- 06 American Community Survey (ACS)
- 07 Census 2020
- 08 TIGER Digital Map Database

- 09 Using Open VDA Web GIS .. Base project updated 11.28.23
- 10 Using VDA Desktop GIS (VDAD) .. with TIGERweb Web Map Service (WMS)

- 11 Demographic Analytics
- 12 Demographic-Economic Data Explorer
- 13 Regional Economic Information System
        .. U.S. & State Quarterly Personal Income Components Dataset

- 14 Situation & Outlook Estimates & Projections Overview

- 15 Selected Recent & Upcoming Data Releases; Tuesday Session Programs Ahead

01. Federal GeoStatistical System .. goto topics
.. Overview
.. multi-sourced data access and integration
.. what is where and how to access it; variations on public data structures

.. Selected Geography .. access data for these area using Demographic Analytics tool
    - Census Blocks (100)
        limited scope demographics available only from decennial census
    - Block Groups (150)
        richer demographics, smallest tabulation area available from annual ACS 5-year program
    - Census Tracts (140)
        yet richer demographics, available from decennial census & annual ACS 5-year program
        current estimates and projections available from ProximityOne Situation & Outlook program
    - Counties (050)
        above three geographies nest within counties
    - Metropolitan Statistical Areas (3XX) .. CBSAs
        above four geographies nest within CBSAs Core-Based Statistical Areas
    - Urban Areas (400)
    - Cities/Places (160)
    - Congressional Districts (500)
    - Congressional Communities (501)
    - ZIP Codes (860)
    - School Districts (9xx)

02. Selected News Items .. goto topics
12.07.23 data release day .. ACS2022 5-year estimates .. annual update

11.16.23. Personal Income by County, Metro .. series through 2022
.. released 11/16/23
.. Regional Economic Information System

11.09.23. Census Releases Population Projections to 2100
.. U.S. national scope only
.. Datasets
.. Projected Population by Year, Matrix

03. School/School District Data Analytics .. goto topics

Getting Your School District Total Population from ACS 2022
.. what is ACS 2022; why ACS 2022 1-year? when not to?
.. illustration for Lexington School District 5, SC
.. Step 1 .. get the school district code
.. Step 2 .. use the API
.. api call: https://api.census.gov/data/2022/acs/acs1?get=NAME,B01001_001E&for=school%20district%20(unified):02820&in=state:45
.. return: [["NAME","B01001_001E","state","school district (unified)"],
.. return: ["Lexington School District 5, South Carolina","107290","45","02820"]]

2022 population for Lexington School District 5, SC: 107,290

04. Congressional Districts & Congressional Communities Applications .. goto topics
.. Congressional Districts
.. Congressional Communities

05. Population, Births, Deaths, Migration .. goto topics

5.1. Migration
.. annual county estimates interactive table

.. DEDE County Profile .. Fresno County, CA report section 3.1 .. Fresno County, CA Movers Dataset (XLS)
    annual; most recent year 2020 ACS 5-year based

.. State-to-State Migration Flows ACS 2022 1-year

06. American Community Survey (ACS) .. goto topics
.. main section .. ACS 2022

07. Census 2020 .. goto topics
.. main section

08. TIGER Digital Map Database .. goto topics
.. main section


09. Using Open VDA Web GIS .. Base project updated 11.28.23 .. goto topics
.. click here to start .. see more about .. as shown in the graphic below.
.. no fee, no login, nothing to install, any browser, desktop recommended.



Layers in 11.28.23 Base Project -- recently added layers/subject matter
States
New Interstate
New State $PCPI %Chg22_23Q2
New State $PCPI 23Q2
State PCRealGDP 2023Q1
New K-12 Schools Elem
New K-12 Schools Middle
New K-12 Schools High
CBSAs/Metros/MSAs Label
CBSAs/Metros/MSAs
Cong District Code
Cong Districts
Cong Districts Bold
Cong Comm Label
Cong Communities
Cong Communities Div Lbl
Cong Communities Diversity
Cong District Diversity Label
Cong District Diversity
CD 118 PopChg% 2020-22
St Leg Dist Upper
St Leg Dist Lower
School Districts Label
Replaced School Districts
Urban Areas Label
Urban Areas
ZIP Codes Label
ZIP Codes
County Name
Counties1
Counties2
Cities/Places Label
Cities/Places
Cty Population Gain 2020-22
Cty Population Loss 2020-22
Tracts Label
Tracts DP1 Label
Tracts DP1 %Age 65+
Tracts ACS $MHI
Tracts LMI23 Label
Tracts LMI23 MFI Tract/MSA%
BaseLayer
States1

10. Using VDA Desktop GIS (VDAD) .. with TIGERweb Web Map Service (WMS) .. goto topics
.. VDAD Installer .. click to run .. updated 11/07/23; shows as version 11.08.23

.. TIGERweb Web Map Service (WMS)
.. illustrative appplication

11. Demographic Analytics .. goto topics
.. Demographic Analytics main

12. Demographic-Economic Data Explorer .. goto topics
.. DEDE Installer Updated
.. run installer 11.10.23
.. software not updated but ACS 2021 and 2022 subject matter items files (SMIF) have been updated.
.. see ACS 2021 SMIF used for the start-up display
.. similar to ACS 2022 SMIF
.. items scroll section:
Each of these files include these newly added age fields:
B01001_003E A0004MA22 Male: Under 5 years
B01001_004E A0509MA22 Male: 5 to 9 years
B01001_005E A1014MA22 Male: 10 to 14 years
B01001_006E A1517MA22 Male: 15 to 17 years
B01001_027E A0004FA22 Female: Under 5 years
B01001_028E A0509FA22 Female: 5 to 9 years
B01001_029E A1014FA22 Female: 10 to 14 years
B01001_030E A1517FA22 Female: 15 to 17 years
enabling computation of the dependency ratio.

They also include these newly added educational attainment fields
B15002_011E EAHSMA22 Male: High school graduate (includes equivalency)
B15002_015E EABMA22 Male: Bachelor's degree
B15002_016E EAMMA22 Male: Master's degree
B15002_017E EAPMA22 Male: Professional school degree
B15002_018E EADMA22 Male: Doctorate degree
B15002_028E EAHSFA22 Female: High school graduate (includes equivalency)
B15002_032E EABFA22 Female: Bachelor's degree
B15002_033E EAMFA22 Female: Master's degree
B15002_034E EAPFA22 Female: Professional school degree
B15002_035E EADFA22 Female: Doctorate degree
Enabling new ability to create percentages of educational attainment by highest EA level

They also include these newly added citizen fields:
B29001_001E VATOTA22 Total Citizen, Voting-Age Population
B29001_002E VA1829A22 Total Citizen, Voting-Age Population 18 to 29 years
B29001_003E VA3044A22 Total Citizen, Voting-Age Population 30 to 44 years
B29001_004E VA4564A22 Total Citizen, Voting-Age Population 45 to 64 years
B29001_005E VA65UPA22 Total Citizen, Voting-Age Population 65 or more years
Enabling analysis of age-based citizen voting age population

13. Regional Economic Information System (REIS) .. goto topics

13.1. REIS Main Section
.. reviewing new county level 2022 personal income data released 11/16/22
.. reviewing updated REIS software package

13.2. U.S. & State Quarterly Personal Income Components Dataset
.. 6 BEA sourced datasets developed into a standardized structure running from 2010Q1 through 2023Q2
.. to be restructured some in the week or two ahead
.. other series to be added
.. data reflect a comprehensive update that was finalized this fall

.. using these and related data to simulate projection of the 2023Q3 data to be released by BEA in December
.. also in December, BEA will release similar annual time series data at the county level thru 2022

Scope of Subject Matter .. Corresponding County Level Components
.. Table CA4 - Personal Income by Major Source
.. Table CA5 - Earnings by Source & Sector
.. Table CA25 - Employment by Sector
.. Table CA30 - Economic Profile
.. Table CA35 - Transfer Payments

14. Situation & Outlook Estimates & Projections Overview .. goto topics

1. U.S. by State/County; population by age-race/origin-gender; 2020 through 2060 annual
      updated July annually; next release 12.15.23
      features annual county-to-county to-from migration matrix
      12.15.23 release: 2020-2060 (2023 vintage)
      06.15.24 release: 2020-2060 (2024 vintage)
      06.15.25 release: 2020-2060 (2025 vintage)

1.a. U.S. by Census Tract; population by age-race/origin-gender; 2020 through 2023 annual
      updated July annually; next release 12.15.23
      controlled to item 1 above
      synched with item 5 below
      12.15.23 release: 2020-2060 (2023 vintage)
      06.15.24 release: 2020-2060 (2024 vintage)
      06.15.25 release: 2020-2060 (2025 vintage)

2. U.S. by State/County; demographic-economic mix; 2020 through 2030 annual
      subject matter includes:
      - ACS-like subject matter (~100 items)
      - BEA REIS-like items
      - BLS QCEW-like items (2-digit NAICS)
      - other
      updated July annually; next release 12.15.23
      features annual county-to-county to-from migration matrix
      12.15.23 release: 2020-2030 (2023 vintage)
      06.15.24 release: 2020-2030 (2024 vintage)
      06.15.25 release: 2020-2030 (2025 vintage)

Scope of ACS-like Subject Matter
Rooms in unit
Bedrooms in unit
Housing tenure
Year householder moved into unit
Vehicles available
House heating fuel
Selected housing unit characteristics
Occupants per room
Housing value (owner occupied units)
Mortgage status
Selected monthly owner costs
Gross rent (renter occupied units)
Gross rent as percent of household income
Language spoken at home
Linguistic isolation
Employment status
Employment by occupation
Employment by industry
Employment by class of worker
Commuting
Income and benefits
Families and population in poverty
Housing units & occupancy
Year structure built
Units in structure
 
Geographic identification
Citizen Voting Age Population
Age and gender
Race/Origin
Households by type
Relationship within household
Marital status
School enrollment
Educational attainment
Migration - residence 1 year ago
Place of birth
Citizenship status
 

3. U.S. by State/County; demographic-economic mix; 2020Q1 through 2026Q1 quarterly
      subject matter includes quarterly data:
      - ACS-like subject matter (~100 items)
      - BEA REIS-like items
      - BLS QCEW-like items (2-digit NAICS)
      - other
      updated quarterly; next release 12.15.23
      12.15.23 release: 2020Q1-2026Q1 (2023Q4 vintage)
      03.15.24 release: 2020Q1-2026Q2 (2024Q1 vintage)
      06.15.24 release: 2020Q1-2026Q3 (2024Q2 vintage)

4. U.S. by State/School District; demographic-economic mix; 2020 through 2028 annual
      subject matter includes:
      - single year of age by race/ethnicity by gender
      - total population (universe 1) demographic-economic mix (~30 items)
      - children (age 0-20 years) (universe 2) demographic-economic mix (~30 items)
      - selected NCES CCD-like admin data
      - other
      "5-year projections"; rolls ahead one year annually
      updated mid-year annually; though next release 12.15.23
      12.15.23 release: 2020-2028 (2023 vintage)
      06.15.24 release: 2020-2029 (2024 vintage)

5. U.S. by State/County/Tract; demographic-economic mix; 2020 through 2023 annual (rolling 1 year ahead)
      subject matter includes:
      - ACS-like subject matter (~100 items)
      - other
      derivative areas: Congressional Communities; school attendance zones; custom areas
      12.15.23 release: 2020-2023 (2023 vintage)
      06.15.24 release: 2020-2024 (2024 vintage)
      06.15.25 release: 2020-2025 (2025 vintage)

6. Up to 4-digit (selected) NAICS sector/level projections
7. Individual company projections

Estimates and projections developed for 6 and 7 are ad hoc/custom.
Estimates and projections are developed using the ProximityOne Modeler software.
Model specifications use cause and effect time series simultaneous equations.

Generic County Model ... scroll section .. goto top
Selected equations illustrate structure of the simultaneous equation model. A generic county level model is used but has some specification differences from county to county. The generic county model makes use of the population identity equation:

P[i,a,g,r,t] = P[i,a,g,r,t-1] + B[i,a,g,r,t] - D[i,a,g,r,t] + MD[i,a,g,r,t] +MI[i,a,g,r,t]
  for the ith geographic area; a: age (0, 1, 2, ... 100, 100+); g: gender; r: race/origin; t: year
  total population for any single area, gender, race/origin, year determined by summing over age (a).

Births: B[i,a,g,r,t] determined by fertility rates; where B[i,a,g,r,t] =0 for a>=1 (births only in age 0 cohort)
Deaths: D[i,a,g,r,t] determined by mortality rates
Domestic Migration: MD[i,a,g,r,t] = f1(MD explanatory variables)
International Migration: MI[i,a,g,r,t] = f2(MI explanatory variables)

Race/origin categories include, but not limited to:
Total population
  One race alone
    White alone
    Black alone
    American Indian/Alaska Native alone
    Asian alone
    Native Hawaiian/Pacific Islander alone
    Other Race alone
  Two or More Races
  Hispanic/Latino population (any race)

Other identities and cause and effect equations are included in the SEM to determine behavior/values of other items summarized in lists shown below. Examples:
  Employment: E004[i,a,g,r,t] = f_e004(E004 explanatory variables)
  School Enrollment: S052[i,g,r,t] = f1_s052(S052 explanatory variables)
  Educational Attainment, High School Graduate : S061[i,g,r,t] = f_s061(S061 explanatory variables)
  Households with Income $100,000 to $149,999: E059[i,a,t] = f_e059(E059 explanatory variables)
  Vacant Housing Units: H003[i,a,t] = f_h003(H003 explanatory variables)
  Owner Occupied Housing Units: H045[i,a,t] = f_h045(H045 explanatory variables)


Data Access. Groups 1-5 above. Standard estimates and projections by ProximityOne are synergistically developed and released quarterly. As applicable, estimates and projections are aggregated to higher level geography (e.g., states and the U.S.) An independent U.S. and state model is run synergistically with data groups 1-5.

A primary data access option is to download datasets as released.
Data access modules may be downloaded for geographic coverage: U.S., state, county

Users can run the Modeler software on their own computer using the historical database. Additional or variations on model specifications and assumptions can be set/managed by the user.

Data are accessible on release day via VDAGIS tools

Quarterly Release Dates
12.15.23 -- winter
03.15.24 -- spring
06.15.24 -- summer
09.15.24 -- fall


15. Selected Recent & Upcoming Data Releases; Tuesday Session Programs .. goto topics
09.06.23. QCEW Quarterly 2023Q1 U.S. by County Establishments, Employment, Earnings (BLS)
        - updated quarterly/annual time series by type of business/NAICS
        - related Regional Economic Information System
10.04.23. Personal Consumption Expenditures by State, 2022
11.16.23. Personal Income by County and Metropolitan Area, 2022 (BEA); updated annual time series
        - related Regional Economic Information System
12.07.23. QCEW Quarterly 2023Q2 U.S. by County Establishments, Employment, Earnings (BLS)
        - updated quarterly/annual time series by type of business/NAICS
        - related Regional Economic Information System
12.07.23. Gross Domestic Product by County and Metropolitan Area, 2022 (BEA); updated annual time series
        - related Regional Economic Information System
12.07.23. 2022 American Community Survey 5-year estimates (Census); data to block group level
        - related 2022 American Community Survey
12.14.23. Real Personal Consumption Expenditures by State and Real Personal Income
        - by State and Metropolitan Area, 2022
12.15.23. 2022 Small Area Income and Poverty Estimates (Census); school district & county
        - related SAIPE


12.22.23. Gross Domestic Product by State and Personal Income by State, 3rd Quarter 2023

01.15.24. U.S. by County Population by Age, Race/Ethnicity, Gender Annual Projections to 2060 (ProximityOne)
        - aggregates to metro, state & U.S.
        - related Demographics 2060

01.15.24. Situation & Outlook Quarterly Release

01.25.24. K-12 School & School District Administrative Data release (NCES/CCD)
        - data for 2022-23 school year

03.08.24. QCEW Quarterly 2023Q3 U.S. by County Establishments, Employment, Earnings (BLS)
        - updated quarterly/annual time series by type of business/NAICS
        - related Regional Economic Information System

03.15.24. Situation & Outlook Quarterly Release

03.31.24. Gross Domestic Product by State and Personal Income by State, 4th Quarter 2023 and Year 2023 (Preliminary)

06.15.24. Situation & Outlook Quarterly Release

09.15.24. Situation & Outlook Quarterly Release


12.06.23. Congressional District & Congressional Community Demographic Patterns
.. a ProximityOne & Congressional Communities collaborative program
Every Wednesday -- 03:00 PM Eastern Time (US and Canada)
Meeting link: https://us06web.zoom.us/j/85954760288?pwd=fENb51ZjoOZ27bYFHJlrXPVbGHEVEn.1
Meeting ID: Meeting ID: 859 5476 0288 .. Passcode: 564716
  .. above link & ID the same on Wednesdays through December 2023
Navigating the Website & Accessing Resources

Warren Glimpse
ProximityOne -- http://proximityone.com
.. we build and apply decision-making information and
    develop/operate/provide tools for related data access/integration/analysis
wglimpse@proximityone.com

Dan Carracino
Founder, Congressional Communities
.. about Congressional Communities
.. https://congressionalcommunities.org
dan@congressionalcommunities.org

Who this session is for and how you benefit
.. strategists needing to understand district demographic-economic change
.. policymakers and staff dealing with congressional policy development
.. residents/constituents who are/want to be members of a CC
.. earners & researchers regarding CC, CD mapping & geodemographic topics

Optionally listen to/view Prolog/Introduction to Concepts/Background (5 minutes)
.. did you know? .. 19 congressional districts have lost more than 4% population since 2020? Which ones? What is causing the loss? How is the loss distributed across the district? Will these trends continue? Which districts are growing? Based on the 2020 Census, the Diversity Index for the 118th Congressional Districts ranged from 12.5% (Kentucky 05) to 78.5% (Hawaii 02). What and why is the Diversity Index important? What are economic characteristics of districts? How can you have your voice better heard by Congress through a congressional community? How can stakeholders easily relate diverse topics like school districts, K-12 education, urban/rural areas, low and moderate income by census tract, ZIP codes, state legislative districts among others to congressional districts? Get answers here. Learn more about these topics in this session.

Why is FL Congressional District 28 Losing Population?


Concepts, Terminology & References for this Session
Congressional Districts. The November 2022 elections determined the representatives for the 118th Congressional Districts (CDs) January 2023-December 2024 session. The 118th Congressional District boundaries reflect the redistricting process based on Census 2020 results.

Congressional Communities. Congressional Communities (CC) are a concept and development of Congressional Communities, a non-profit organization. CCs have been developed to better enable constituents have their voice heard by policymakers and vice-versa. The approximate 7,400 CCs cover the U.S. wall-to-wall developed by the CC team and typically range from 30,000 to 70,000 population. CCs have been developed based on several criteria and are not arbitrary subdivisions of CDs. There are a set of CCs that nest exactly within each CD. Demographic data have been developed for each CC based on Census 2020 census block data by the CC team.

CC stakeholders may map and geospatially analyze their CCs and CDs.
CC organizations are comprised of residents of their respective CCs.
join a Congressional Community .. illustrative details for a Congressional Community

References
  • Census Bureau Redistricting Data Program .. operation & selected topics
  • Census Bureau TIGER 2023 .. new


Topics This session includes the topics listed below.
.. illustrative applications are focused on Washington State by CD with CD zoom-in.
.. Use your own CD/region of interest.
.. this is not a slide show. Ask questions as we go.
.. ~30 minute presentation followed by discussion.

Topic sections:
01 CD/CC Visualization using the Open VDA Web GIS
02 118th Congressional District & Congressional Community 2020-2022 Demographics
03 CD/CC Demographic Analytics: Using Comparative Analysis Stories
04 Today's focus topic: 118th Congressional District & Congressional Community Diversity
05 Voting Registration & Voter Participation
06 Using ACS 2022 Data with 118th Congressional Districts
07 Upcoming tentative CD focus and section 4 topic
08 Selected Applications
09 Discussion

01. CD/CC Visualization using the Open VDA Web GIS .. goto topics
.. step-by-step example
.. optionally follow-along

Washington State by Congressional District .. Patterns of Low & Moderate Income by Census Tract

  .. learn how to develop variations of this view.

02. 118th Congressional Districts & 2020-2022 Demographics .. goto topics
.. Congressional Districts Main
.. using the CD Census 2020 & ACS 2022 interactive table

Patterns of %Population Change 2020-2022 by 118th Congressional District

  .. learn how to develop variations of this view.

Patterns of %Population Change 2020-2022 by 118th Congressional District

.. using the CD Census 2020 & ACS 2022 interactive table

In August 2023, the Census Bureau released the first Census 2020 demographics for the 118th Congressional Districts. In September 2023, the Census Bureau released the American Community Survey 2022 1-year estimates (ACS2022) for the 118th Congressional Districts. These data provide reasonably current data on a myriad of socioeconomic data. The Census Bureau also maintains the official national scope boundary files (for mapping and geospatial analysis) for the 118th Congressional Districts.
The Census Bureau also develops the County Business Patterns data for the 118th Congressional DIstricts. Learn more about the scope of these data and how they can be accessed and used. Aside from these data resources, the Federal statistical system (FSS) produces very little data for congressional districts.

What can I learn? Scope of annual ACS-based subject matter.
2022: General Demographics 91 .. Social 154 .. Economic 137 .. Housing 143
2021: General Demographics 91 .. Social 154 .. Economic 137 .. Housing 143

Overview of ACS Subject Matter
Rooms in unit
Bedrooms in unit
Housing tenure
Year householder moved into unit
Vehicles available
House heating fuel
Selected housing unit characteristics
Occupants per room
Housing value (owner occupied units)
Mortgage status
Selected monthly owner costs
Gross rent (renter occupied units)
Gross rent as percent of household income
Language spoken at home
Linguistic isolation
Employment status
Employment by occupation
Employment by industry
Employment by class of worker
Commuting
Income and benefits
Families and population in poverty
Housing units & occupancy
Year structure built
Units in structure
 
Geographic identification
Citizen Voting Age Population
Age and gender
Race/Origin
Households by type
Relationship within household
Marital status
School enrollment
Educational attainment
Migration - residence 1 year ago
Place of birth
Citizenship status
 

03. Demographic Analytics -- Comparative GeoDemographic Narrative Profiles .. goto topics
.. using Demographic Analytics (DA) tool to compare CDs, CCs, and other areas
.. Census 2020 "DHC" detailed data released 8/31/23
.. accessing the new Census 2020 DHC-based "Demographic Profile 1" (DP1)
.. examples -- running DA

Demographic Analytics User Interface


    - WA CC 53017012 compared to CD WA 5301 Tabular Report
    - WA CC 5301012 compared to CD WA 5301 Narrative Profile
.. creating tabular report and narrative profile for areas of interest.

Using DA to Generate Tabular Data and Narrative Profiles --Illustrative Video

.. interpreting the data & insights; examples
    - diversity
    - dependency ratio

More in-depth review of narrative profile: telling a story, understanding a situation, investigative analysis

04 Today's Focus Topic: 118th Congressional District & Congressional Community Diversity .. goto topics
.. Congressional Districts Diversity
.. using the CD & CC interactive table

Patterns of Diversity by Congressional Community .. CD WA 01
.. click for view with labels; discuss views/operations

  .. develop variations of this view.

Patterns of Diversity by Congressional Community .. CD WA 01 Interactive Table
.. using the CD & CC interactive table
.. interactive table with query for 5301

  .. develop variations of this view.


05. Voting Registration & Voter Participation .. goto topics
.. assessing where we are .. data based on the Current Population Survey

Voter turnout for the 2022 U.S. congressional elections was the second highest for a nonpresidential election year since 2000, with 52.2% of the citizen voting-age population participating. Registration rates were the highest for a midterm election since 2000, with 69.1% of the citizen voting-age population registered to vote, up 2.2 points from 66.9% in 2018, according to Current Population Survey (CPS).

For the 2022 election, the CPS show that nearly one-third (31.8%) of all voters voted by mail, up from 23.1% in 2018. Almost half (47.1%) voted before Election Day, up from 37.8% in 2018.



Reported Voting and Registration of the Total Voting-Age Population, for States: November 2022 XLS

Reported Voting and Registration for States: November 2020 XLS

06. Using ACS 2022 Data with 118th Congressional Districts .. goto topics
The American Community Survey 2022 1 year data (ACS2022) are the most recent demographic-economic data for the 118th Congressional Districts. The ACS 2022 1 year estimates are the most recent source of "richer demographics" for the 118th Congressional districts.

Access the ACS 2022 1 year estimates using the Demographic-Economic Data Explorer (DEDE). The following graphic illustrates the settings to use DEDE to extract ACS 2022 data for the 118th CDs. Discuss.
While DEDE can extract a wider range of subject matter, this application illustrates extracting data based on the api_items_acs22_base.txt "subject matter items" file. See the extract file generated here (xls).

07. Upcoming tentative CD focus and focus topic (04 segment) .. goto topics
Attend future sessions. New applications, policy & rules topics, developing skill sets, new data, updated/extended tools, other/more methodologies.

.. all sessions have national scope coverage; all tools/data are nationsl scope.
.. in some cases specific congressional communities/congressional districts are used as listed below.
.. we will schedule a focus session for any congressional community/congressional district on request.

11.29.23: Washington State with WA01/WA08/other Demographic Analytics Narrative Profile
Using "richer demographics" in DA narrative profile from ACS 2022
12.06.23: New York State with NY22 Focus
Review of basic NY22 GIS project
12.13.23: New York State with NY22/NYxx/other Demographic Analytics Narrative Profile
Review of ACS 2022 5-year data (Census release 12/7/23)

More states/congressional districts announced as calendar extends.

08. Selected Applications .. goto topics

Percent Citizen Voting Age Population (of Population 18 years & Over)
.. by Census Tract; Orange County, CA
This view shows a thematic pattern map of the percent Citizen Voting Age Population (CVAP) of Population 18 years & Over by census tract in context of 118th Congressional Districts (CD118). See values of %CVAP in the inset legend.

Make maps like this for your areas of interest using the OVDAW. See below.

Patterns of Income Inequality by Census Tract; Orange County, CA
This view shows a thematic pattern of income inequality (as measured by the
Gini Index) by census tract in context of 118th Congressional Districts (CD118). See values of the Gini Index and colors in the inset legend. The Gini Index ranges from 0, perfect equality (where everyone receives an equal share), to 1, perfect inequality (where only one recipient receives all the income).



09. Discussion .. goto topics


12.07.23. GeoSpatial Analytics: Examining Geographies & Subject Matter
Mapping & GeoSpatial Analysis; GeoDemographic Analytics
Every Thursday -- 03:00 PM Eastern Time (US and Canada)
Meeting link: https://us06web.zoom.us/j/85006479895?pwd=SVJrZHBaZjFaTURTeEZiemFWTzdkdz09
Meeting ID: 850 0647 9895 -- Passcode: 646930
  .. above link & ID the same on Thursdays through December 2023
Navigating the Website & Accessing Resources

Host ...
Warren Glimpse
ProximityOne -- http://proximityone.com
.. we build and apply decision-making information and develop related tools empowering you
wglimpse@proximityone.com

About this Session

Who this session is for and how you benefit
.. strategists needing to understand use of geospatial methods in collaborative settings
.. analysts and researchers
.. librarians and information specialists
.. learners & researchers use of GIS & geospatial tools and methods

This session is designed for a 30 minute presentation and up to 30 minute discussion.
.. the Topics section provides session structure but many items have only passing reference.
.. details vary by week.

Topics This session includes the topics listed below.
.. this is not a slide show. Ask questions as we go.
.. ~30 minute presentation followed by discussion.

Topic sections:
01 About Geographic Information Systems
02 Recent News
03 Visual Data Analytics (VDA) GIS Framework
04 Visual Data Analytics Desktop (VDAD) GIS
05 Using VDA Desktop GIS (VDAD) with TIGERweb Web Map Service (WMS)
06 TIGER Digital Map Database Updates
07 Geospatial Analysis of State & Local Personal Income
08 MapMaker, GeoGateway, Adding Shapefiles to GIS Projects
09 Discussion

01. About Geographic Information Systems
.. what this is and why it is important
.. about GIS 2023

02. Recent News
12.07.23 data release day .. ACS2022 5-year estimates .. annual update

11.16.23. Personal Income by County, Metro .. series through 2022
.. released 11/16/23
.. Regional Economic Information System

11.09.23. Census Releases Population Projections to 2100
.. U.S. national scope only
.. Datasets
.. Projected Population by Year, Matrix

03. Visual Data Analytics (VDA) GIS Framework .. goto topics
.. VDA Desktop GIS (Windows); accessing local and VDAGIS Server projects
.. VDA Web GIS
.. VDA Web GIS - phone interface
.. Open VDA Web GIS .. no login, no fee
.. common features

Visual Data Analytics (VDA) Desktop GIS .. goto topics
.. what this is and why it is important; a part of the VDAGIS Framework
.. installer updated 11.08.23
.. run installer .. requires Windows 10/11
.. https://proximityone.com/vda/1/vdagis_installer.exe
.. no fee option available .. requires user id to install .. request via Contact page
    - check checkbox "Requesting userid to install VDA Desktop GIS"
.. today: reviewing:
    - start-up & navigation
    - new feature .. using Select Fields with Table/Grid feature

VDAD HTML Guide https://proximityone.com/vda_desktop.htm
VDAD H&M Guide https://proximityone.com/vda/guide/index.html?welcome.htm

05. Using VDA Desktop GIS (VDAD) .. with TIGERweb Web Map Service (WMS) .. goto topics
.. VDAD Installer .. click to run .. updated 11/07/23; shows as version 11.08.23

.. TIGERweb Web Map Service (WMS)
.. illustrative appplication

06. TIGER Digital Map Database Updates .. goto topics
.. what this is and why it is important
.. 2022 Smoothed Boundary Files released 4/6/23
.. TIGER 2023 to be released November 2023
.. integrating these shapefiles into GIS projects
.. generally do not include demographic-economic data -- exceptions
.. access in most VDA Web GIS projects

07. Geospatial Analysis of State & Local Personal Income .. goto topics

7.1. State Quarterly Personal Income (SQPI)
Overview of multiple SQPI files/data as released by BEA
Role & Importance

Using the shapefile cb_2022_us_state_500kpcpi
.. Opening, using OVDAW and VDAD

Shapefile contains a record for each state.
Each record contains selected attributes followed by
.. 60 quarterly PCPI per capita personal income fields followed by
.. 60 quarterly PI total personal income (millions of dollars, seasonally adjusted) fields.
.. the fields extend through 2024Q4.
The current data run 2010Q1 through 2023Q2 and as sourced from BEA.
Data restructured for use as presented and added four over-the-year change fields.
There six unloaded PCPI and PI fields.
The BEA sourced 2023Q3 data will be added in an updated version in late December (when released).

File to be updated at end of December 2023 with:
.. the new BEA 2023Q3 data and revised historical data
.. simulated estimates of the 2023Q3 data using the P1 model
.. quarterly projections through 2024Q4 using the P1 model
.. likely adding other fields

A county version of this file may be available at that time.

7.2. County Annual Personal Income (LAPI)
Overview of multiple SQPI files/data as released by BEA
Role & Importance

Overview of multiple LAPI files/data as released by BEA (11/16/23)

Regional Economic Information System

To be added to:
.. Demographic-Economic Data Explorer (DEDE)
.. VDAGIS "Base" Project (VDAGIS Base)

08. MapMaker, GeoGateway, Adding Shapefiles to GIS Projects .. goto topics

Mapping/Geospatial Analysis using 2020 Census Blocks
.. in context of congressional communities, congressional districts, tracts & the VDA GIS Base Project
.. integrated CC/CD codes and Census 2020 PL subject matter and use
.. Cen 2020 Orange County CA Blocks Shapefile (zip file)

Mapping/Geospatial Analysis using 2020 Public Use Microdata Areas (PUMAs)
.. in context of congressional communities, congressional districts, tracts & the VDA GIS Base Project
.. application development starting with TIGER-sourced shapefiles
.. https://www2.census.gov/geo/tiger/TIGER2020/PUMA20/

09. Discussion .. goto topics

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