Decision-Making Information

ProximityOne   information resources & solutions   (888) DMI-SOLN   (888) 364-7656 Data Analytics Blog Power of Combining Maps with Data

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

Diversity Index: 118th Congressional Districts & Congressional Communities
.. Diversity -- what this is and why it is important
.. Congressional Districts main section
.. Diversity Index

Children's Demographics by School District
.. Grade Relevant Children Not Enrolled in School -- what this is and why it is important
.. Children's Demographics by School District main section

Accessing & Using ACS 2022 1-year Data
.. American Community Survey -- what this is and why it is important
.. about ACS 2022
.. to be released 9/14/23

Integrating Census 2020 DP1 for Congressional Communities & 118th Congressional Districts
.. the DP1 for CDs -- what this is and why it is important
.. about ACS 2022
.. new data developed 9/11/23

Open VDA Web GIS Updates
.. what this is and why it is important
.. about Open VDA Web GIS
.. Start no login Open VDA Web GIS

Every Wednesday -- 03:00 PM Eastern Time (US and Canada)
Meeting link: https://us06web.zoom.us/j/85954760288?pwd=fENb51ZjoOZ27bYFHJlrXPVbGHEVEn.1
Meeting ID: 859 5476 0288 - Passcode: 564716   .. above link & ID the same on Wednesdays through December 2023

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. Examine 118th U.S. Congressional District American Community Survey demographic-economic characteristics using VDA Web GIS.

We start with geographic visualization using the Open VDA Web GIS .. start the VDA Web GIS
.. optionally follow-along

Census 2020 & Congress Apportionmment -- where the 118th Congress began
.. as states establish final redistricting plans, the send their shapefile to the Census Bureau.
.. the Census Bureau standardizes the geographic structure for all states.
    - Census does not modify the boundaries or CD codes.
.. a national shapefile then exists for public use. That shapefile enables mapping and geospatial analysis.
.. demographic data are developed and made available separately.

118th Congressional Districts & 2020-2022 Demographics
Did you know .. that the CD with the lowest 2022 median household income ($MHI) was KY05 ($42,736) and the CD with the highest $MHI was NJ07 ($131,419).
.. Congressional Districts Main
.. using the CD Census 2020 & ACS 2022 interactive table
.. getting specific or more Census 2020 and ACS data

118th Congressional District Congressional Communities
Congressional Communities (CC) are a concept and development of Congressional Communities, a non-profit organization.
.. a set of national scope CCs have been developed by the CC team.
.. a national scope CC shapefile has been developed.
    - for each 118th CD there is a set of CCs that nest exactly within the CD.
.. separately, demographic data have been developed for each CC based on Census 2020 census block data.
.. CC stakeholders may now map and geospatially analyze their CCs.
.. residents of CCs make up their own CC membership composition. This is not a fee-based thing.
.. join in to a CC here

118th Congressional District & Congressional Community Diversity
Did you know .. the Diversity Index for the 118th Congressional Districts ranged from 12.5% (Kentucky 05) to 78.5% (Hawaii 02)?
.. Congressional Districts Diversity
.. Congressional Communities -- reducing the ratio
    - a new, unique geography; new, unique demographics
    - Size of the U.S. House of Representatives
    - VA 08 Congressional Communities -- exaamples
.. using the CD/CC Diversity interactive table
.. computing/analyzing other getting other diversity data

Comparative 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

Using VDA GIS to Map/View/Analyze these & Related Geographies
.. about GIS - Geographic Information Systems
.. the Visual Data Analytics (VDA) array of tools; VDA Desktop; VDA Web; Open VDA Web
.. about Open VDA Web GIS -- -- derivative of VDA Web GIS
.. about the Base project
.. Start Open VDA Web GIS -- no login, no fee version
.. VDA Desktop GIS -- Windows based; no fee installer -- demonstration - how to install

State Legislative Districts Cycle 2022
.. State Legislative Districts -- what this is and why it is important
.. VA 08 Congressional District
.. using VDA GIS & State Legislative Districts

.. example: Northern Virginia SLD22 Upper


.. example: Northern Virginia SLD22 Lower


Cities & Urban/Rural Areas; more about drill down geography
.. what this is and why it is important
.. VA 08 Congressional District

Using CV XE GIS
.. what this is and why it is important -- Windows based desktop GIS tool
.. about CV XE GIS
.. CV XE GIS Guide

What about precincts, voting districts & census blocks
.. see more about these topics/relations .. covered in session 10.11.23 .. join in

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

About Geographic Information Systems
.. what this is and why it is important
.. about GIS 2023
.. StoryMaps -- using VDAGIS
.. Congressional Communities .. two VDAGIS projects

FFIEC Census Flat Files 2023 released September 28, 2023
.. what this is and why it is important; how these data are integrated into GIS
.. tract level low and moderate income categories integrated with related ACS 2021 data
.. to be added to a tract for for use with VDA GIS tools; reviewed next week
.. Tracts LMI Interactive Table
.. more about FFIEC Census Flat Files overview

Open VDA Web GIS Updates
.. what this is and why it is important
.. the VDA GIS framework
.. about Open VDA Web GIS
.. Start no login VDA Web Base

Using CV XE GIS
.. what this is and why it is important -- Windows based desktop GIS tool
.. about CV XE GIS
.. CV XE GIS Guide

Mapping & GIS Applications Using ACS 2022 1-year Data
.. what this is and why it is important
.. about ACS 2022
.. released 9/14/23

Mapping & GIS Applications Using Census 2020 DP1 for Congressional Communities & 118th Congressional Districts
.. what this is and why it is important
.. about ACS 2022
.. new data developed 9/11/23

Children's Demographics by School District
.. Grade Relevant Children Not Enrolled in School -- what this is and why it is important
.. Children's Demographics by School District main section

Demographic Analytics Updates
.. what this is and why it is important
.. Demographic Analytics
.. narrative report (optionally generated after the grid display) has been expanded
    - now includes the Diversity Index
    - now includes the K-12 school age population (ages 5-17 years)
    - neither are directly included in the tabular report or DP1 dataset

-------------------- End this session ----------------------------

Examining County Demographic Trends
.. what this is and why it is important
.. about CountyTrends
.. counties are CBSA/Metro building blocks

New 2023 Vintage Metropolitan Statistical Areas
.. what this is and why it is important
.. use VDA GIS to compare 2020 & 2023 vintages.
.. about New 2023 Vintage Metropolitan Statistical Areas
.. using VDA Web GIS with the MetroDynamics Project
.. start VDA Web GIS
.. about the start-up views

2023 Vintage Metropolitan Statistical Areas Blog Post
.. New 2023 Metropolitan Area Delineations

VDAGIS Email Updates
.. new program -- .. about VDAGIS Group
.. weekly email updates
.. this past week .. new MetroDynamics projects posted
.. tenative topics:
.. 8/21 .. accessing/using the updated Congressional Communities projects
    - Census 2020 DP1 data by CC built from block DHC data
    - feature updates -- usign the no fee VDA Web Base site
      - iPhone/mobile interface
.. 8/28 .. accessing/using the updated K-12 Schools & School Districts project
.. 9/4 .. accessing/using the updated CD 118 Congressional Districts
    - using Census 2020 DP1 by CD118 first time
    - feature updates

FFIEC "2023 Census Flat File" Released (8/10/23)
.. FFIEC website
.. 2023 FFIEC "Census Flat File" Documentations
.. key data from this release to be available:
    - ProximityOne Tracts LMI Section interactive table
    - VDA Web GIS MetroDynamics projects
.. more next week

End of today's topics

Hispanic Population by Specific Origin
.. Origins tabulated .. scroll section ... 63% 2010 Hispanic population is Mexican.
.. illustrative applications using VDA Desktop GIS (via c:\hso2021)

K-12 Schools & School Districts: Geography, Mapping Geospatial Analytics
.. what this is and why it is important
.. about Geographic Information Systems
.. using VDA Web GIS with the K-12 Schools & School Districts GIS Project
.. start VDA Web GIS
.. about the start-up view

K-12 Analytics .. Windows based tools/data
.. illustrative applications using VDA Desktop GIS (via d:\k12)


VDA Desktop GIS .. installation & use
.. what this is and why it is important
  Visual Data Analytics Desktop GIS VDAD User Guide
.. install on your Windows computer via VDA Web GIS
.. this is the Viewer/no fee version; cannot save project; not database features
.. review of using local project
.. review of using server project

Census 2020 Weekly Update
.. what this is and why it is important
.. follow the weekly update posted Mondays
.. the more detailed Census 2020 data released 5/25/23 -- "Demographic & Housing Characteristics" data
    (follows release of P.L. 94-171 redistricting data)
.. join us in our continuous support & data access/analytics program
.. Census 2020 Main Section Topics
.. using Demographic-Economic Data Explorer with the Census 2020 DHC data
.. an update on accessing/using Census 2020 DP file/profiles and DHC file/tables

Census 2020, GIS and the DHC Geographic Reference File

Applications: examine the 13-14 year old population by census block to see what the 2023-24 school year 17-18 year olds would be like in service areas/attendance zones/school districts under assumption that births-deaths=0 and net migration=0. Optionally make adjustment with different assumptions. Compare with using ACS data.

Examining Housing Price Index Trends by Census Tract
.. HPI: what this is and why it is important
.. annual data based on HPI 2000=100; updated annually; 2022 now available
.. available for ~50,000 of total 84,000 tracts
.. using updated VDA GIS project County/Regional Trends with VDA GIS tools
.. Graphic below shows the 11 tracts in San Diego County that have a high HPI2022 (>1500)
    ranked on the HPI2021 to HPI2022 %change, then mapped by clicking show all selected button.
Open the County/Regional Trends project
Set active layer to Tracts HPI
Click show table on
Set SQL Filter to:
  select geoid, hpi2021, hpi2022,100*(hpi2022-hpi2021)/hpi2021 where hpi2022>1500 and geoid like '06073%'
Set Sort to:
  100*(hpi2022-hpi2021)/hpi2021 desc
Click Query button; table updates
Click "Highlight all that meet query" button; map refreshes showing selected tract
Zoom out to view all selected tracts
Click on a highlighted tract to view profile & HPI annual trend data
Change the SQL Filter GEOID and try your area



VDA Web GIS Updates
.. what this is and why it is important
.. about Visual Data Analytics Web GIS
.. about Geographic Information Systems
.. updated with new navigation features; reviewed in session
.. illustrative applications .. congressional districts & census tracts:
    - anyone can do these with only a web browser and most any device (desktop/laptop recommended)
    - Citizen Voting Age Population by 118th Congressional District (ACS 2021 1 year data)
    - Citizen Voting Age Population by Census Tract (ACS 2021 5 year data)

With VDA Web GIS running, select the Congressional District/SLD project
.. Citizen Voting Age Population by 118th Congressional District (ACS 2021 1 year data)
.. 118th Congressional Districts in California and %CVAP>70
.. with CD118 table open, add this SQL filter then click query:
.. select geoid,d001,d087,(100*d087/d001) where geoid like '06%' and (100*d087/d001)>70
.. 14 118th CDs meet the criteria
.. click "highlight all that meet query" button below table to display this view:
..
.. discuss

.. Citizen Voting Age Population by Census Tract (ACS 2021 5 year data)
.. Census tracts in Los Angeles County, %CVAP>85 and total population>3000
.. with Tracts table open, add this SQL filter then click query:
.. select geoid,d001,d087,(100*d087/d001) where geoid like '06037%' and (100*d087/d001)>85 and d001>3000
.. 21 tracts meet the criteria
.. click "highlight all that meet query" button below table to display this view:
    - table shows a row for each area meeting criteria
    - map shows highlighted areas meeting criteria
..
.. discuss

.. review of selected projects (Select Projects form in VDA Web GIS start-up)
    - Situation & Outlook
    - MetroDynamics
    - Census 2020 Blocks
    - ZIPCode-CensusTracts
    - Neighborhoods
    - Congressional Communities
    - Congressional Districts/State Legislative Districts
    - CountyTrends -- integrates new Census population & components of change 2022 estimates
    - add your own

VDA Desktop Updates
.. what this is and why it is important
.. operational review/demo
    - geocoding
    - search & build shapefile
    - adding, managing shapes
.. structure of "US1.gis" project

DEDE Updates
.. what this is and why it is important
.. about Demographic-Economic Data Explorer
.. new installer 5/15/23
.. new ACS 2020 county-to-county migration added; now access any year 2018, 2019, 2020
.. new County Business Patterns 2021 added; CBP 2016 added; earlier vintage; more detailed release
.. new county QCEW for 2022Q3 (quarterly time series starting 2020 and earlier)
.. new authorized residential construction; time series from 2015 .. new annual 2022 by county
.. ahead .. DEDE will enable comprehensive development of Census 2020 DP & DHC extract files; more below


Census 2020 Weekly Update
.. what this is and why it is important
.. the initial primary data from Census 2020 to be released 5/25/23
.. join us in our continuous support & data access/analytics program
.. Census 2020 Main Page
.. an update on accessing/using Census 2020 DP file/profiles and DHC file/tables

Congressional Reapportionment 2020 Ceneus Brief new 5/3/23

County/Regional Trends GIS Project
.. what this is and why it is important
.. preparing for use of 2020 Public Use Microdata Areas (PUMAs)
    with ACS 2022 1-year Public Use Microdata Samples (PUMS) - October 2023
.. VDA GIS metro/regional projects
.. example: Examining Patterns of Median Household Inome by ZIP Code Area
    - select/open "County/Regional Trends" project
    - make ZIP Code Label the active layer
    - search for 85258
    - open table view
    - select three fields
    - enter this text in SQL Filter edit box:
    - zipcode like '852%' and mhia21>150000
    - click query button
    - two ZIP codes selected:
   
    - click selected ZIP, click HTML button, view profile in XLS structure:
    ZCTA 85253 Demographic Profile xls

.. example: Examining Patterns of Percent Citizen Voting Age Population by 2020 PUMA

.. click graphic for larger view
.. layers with selected subject matter; national scope layers except as noted:

.. using Table feature with K12 Schools examples:
TIGER Digital Map Database Updates
.. what this is and why it is important
.. 2022 Smoothed Boundary Files released 4/6/23
.. integrating these shapefiles into GIS projects
.. generally do not include demographic-economic data -- exceptions
.. access in most VDA Web GIS projects

Census Tracts CB22 Shapefiles .. click graphic for larger view


Census Tracts CB22 & TL22 Shapefiles .. click graphic for larger view

Census Tracts CB22 & TL22 Shapefiles - Zoom .. click graphic for larger view


CV XE GIS Installation & Navigation Basics
.. CV XE GIS main

Run the installer to install CV XE GIS on your Windows computer.
Requires your User Group userid (no fee)
Accept all default settings during installation recommended.
See the CV XE GIS user guide for more information.

Video on "Downloading & Using the U.S. Census Tracts Shapefile" using CV XE GIS File>GeoGateway
Downloading & Using the U.S. Census Tracts Shapefile Video
** Save your GIS project for next session.
See more about census tracts and Census Tracts Main