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
    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.
Population Group PopulationPercent
Total Population 308,745,538 
Not Hispanic or Latino258,267,944 
Hispanic or Latino (200-299)50,477,594100.00
    Mexican (210-220)31,798,25862.99
    Puerto Rican (260-269)4,623,7169.16
    Cuban (270-274)1,785,5473.54
    Dominican (275-279)1,414,7032.80
    Central American (excluding Mexican) (221-230):3,998,2807.92
        Costa Rican (221)126,4180.25
        Guatemalan (222)1,044,2092.07
        Honduran (223)633,4011.25
        Nicaraguan (224)348,2020.69
        Panamanian (225)165,4560.33
        Salvadoran (226)1,648,9683.27
        Other Central American (227-230)31,6260.06
    South American (231-249):2,769,4345.49
        Argentinean (231)224,9520.45
        Bolivian (232)99,2100.20
        Chilean (233)126,8100.25
        Colombian (234)908,7341.80
        Ecuadorian (235)564,6311.12
        Paraguayan (236)20,0230.04
        Peruvian (237)531,3581.05
        Uruguayan (238)56,8840.11
        Venezuelan (239)215,0230.43
        Other South American (240-249)21,8090.04
    Other Hispanic (200-209, 250-259, 280-299):4,087,6568.10
        Spaniard (200-209)635,2531.26
        Spanish (282)455,1570.90
        Spanish American (286)35,3460.07
        All other Hispanic (250-259, 280-281, 283-285, 287-299)2,961,9005.87

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


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