![]() |
|
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 Wednesdays 3:00 pm ET; Congressional Districts & Congressional Communities 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.03.23. Accessing & Using Geographic, Demographic, Economic 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
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 10.04.23. Congressional Districts & Congressional Communities Mapping & Analytics
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 10.05.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
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.
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:
States
Primary Roads CBSAs/Metros/MSAs Metro (query applied for selected metro) Metros 10 Largest Portland MSA Roads .. (OR, WA, TIGER+ edges; intersection to intersection) K12 Schools Label K12 Schools School Districts Label School Districts Blocks CA Blocks OR Blocks WA Urban Areas 20 ZIP Codes Label ZIP Codes Counties PUMA 2010 PUMA 2020 Label PUMA 2020 PUMA 2020 %CVAP A21 118th Cong Districts Congressional Communities Places, 5,000 Pop+ County, Pop 2010-20 %Chg County Name County Pop 2022 Cty Pop %Chg 2020-22 Cty Population Gain 2020-22 Cty Population Loss 2020-22 Cty %Net Mig 2yr avg 21-22 Block Groups Tracts Code Tracts $MHI BaseLayer (global) States1 .. using Table feature with K12 Schools examples:
with freshly opened County/Regional project ..
navigate to Portland, OR metro in legend panel, click on Selected metro (Portland, OR); adjust view make K12 Schools the active layer (top left dropdown) show table: click rightmost "A" button below table .. table now shows below table, set the "max" edit box to 1000000 (the size of the file) in legend panel, uncheck Tracts $MHI (to improve school visibility, not required) find high schools in Washington County, OR with more than 500 students: enter this query in the SQL Filter edit box: cnty='41067' and level like 'H%' and students>500 table refreshes with those selected schools to view these schools in map window, click "highlight all that meet query" button below table .. map view reshes showing these schools .. zoomout as required for preferred view find elementary schools in Hillsboro, OR: enter this query in the SQL Filter edit box: city1 like 'Hillsboro%' and state='OR' and level like 'E%' table refreshes with those selected schools to view these schools in map window, click "highlight all that meet query" button below table .. map view reshes showing these schools .. zoomout as required for preferred view 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 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. |
|