Data Access & Use Web Sessions

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 today

• Site Navigation
• SiteMap

• Kansas Demographic-Economic Data Analytics
.. updating VDAGIS project
.. KSDE Section

• Census 2020 Block Demographics
.. updating VDAGIS project .. housing trends by census block
.. Census 2020 Blocks Section

• Annual update -- BEA U.S. by County Personal Income by Major Source & related Files .. to be released 11/14/24
.. annual time series data through 2023
.. being integrated Regional Economic Information System
.. key components of analyzing/understanding local area economy and trends

• 2010-2020 Intercensal Population Estimates 11/7/24
.. annual time series 2010 through 2020; for states, counties, cities, towns/townshipa
.. Intercensal Interactive Table
.. being integrated into Regional Economic Information System
.. key components of analyzing/understanding local area economy and trends

• 119th Congressional District Election Results Interactive Table and related demographics
.. frequent election results updates
.. integrating ACS 2023 1-year 2023 data, additional Subject matter soon
.. integrating Census 2020 DP1 data -- December 2024
.. being integrated into VDAGIS Base project.
Application: new incumbents entering Congress

• Updates to the VDAGIS Base Project.
.. SLD 2024 layers have been added.
.. three (elm, sec, uni) school district layers with school district finances integrated.
.. Urban Areas layer showing population change
.. TIGER 2024 interstate layer
.. TIGER 2024 detailed roads layer (LA & Orange County)
.. Public Use Microdata Areas with demographics trends

Application: The 400 Myrtle St street segment (see pointer) is a bounding street segment for blocks 060590626052003 and 060590626052002
. Click the street segment to show the street segment profile.

• Notes about Using GIS & GeoDemographics Module 3 -- reviewed in 11/14/24 session.
- focus on K-12 schools and school district subject matter

• Weekly Update

End of Session
..

• Using GIS & GeoDemographics Course -- amplify your skillset

• Geographic Summary Levels & Geocodes
- new section

• Census Tracts Main Section updates
- updated interactive table

• Demographic-Economic Data Explorer (DEDE) updates
- creating demographic-economic datasets

• Using the Demographic Analytics Tool
- creating narrative profiles for your area

• 119th Congress Block Equivalency Files .. new this week
- integrating the CD code in block shapefiles
- adding CC code, selected 2020 pop & hsg items, 2024 hsg and GQ, urban/rural flag, urban area geocode
- will be available state by state layers as a VDAGIS project and accessible using most VDAGIS tools.

• 119th Congress, 2024 SLDs, ACS Data .. related topics

• iVDA updates
- new feature -- uploading your shapefile
- Knowing Your Neighborhood
- Metros
- America's Cities
- Examining K-12 Schools & School Districts
- Congressional Communities & Congressional Districts

• Vintage 2024 TIGER/Line files

• Hispanic Population by Specific Origin by ZIP Code Area .. https://proximityone.com/hispanic_origin_zip.htm
- embedded iVDA interactive mapping; demonstrating new iVDA features
- new VDA GIS Hispanic Population by Specific Origin project; acceesible by many VDAGIS tools
- blog post

• Accessing Healthcare Resources updates -- https://proximityone.com/healthcare_resources.htm
- to review next week

End of session

• Housing Units by Census Block -- 2020-2024 .. Using VDAD with US1_2024

• State Personal Income -- Quarterly PCPI 2020Q1-2023Q4
- integrated iVDA mapping and interactive table
- access using VDAGIS Discovery
- updates quarterly; next update June 28

• VDAGIS Discovery Updates -- https://proximityone.com/vdagis_discovery

• Examining Citizen Voting Age Population (CVAP) new section

• America's Cities -- Examining Population Change 2020-2023 .. interactive table

• 2023 Population Density by Vintage 2023 Metropolitan Statistical Area

- create views like above graphic using OpenVDA
- using only a Web browser; no registration, no login, no fee.

• Examining Longitudinal Patterns of Housing Price Index by ZIP Code
- HPI by ZIP Code section updated with 2020-2024 HPI

• Examining National Scope Census Block Housing Unit/Demographic Change 2020 to 2024

• VDA GIS Updates
- VDA Embedded Beta
- VDAW
- OVDAW .. OpenVDA
- VDA Desktop .. VDAD
- GeoSelect/Site Analysis feature updated in all VDAGIS tools
- Base Project updates .. available by all VDAGIS tools

• Dependency Ratio by Neighborhood/Census Tract
- new dependency ratio web section
- added VDA GIS Base project
• Diversity Index by Neighborhood/Census Tract
- about the diversity index
- added VDA GIS Base project
• DEDE3 updates
• DA2 updates
• Citizenship & Voting
- Citizenship Data from ACS2020 regular program
- Citizen Voting Age Population ACS 2022 Special Tabulation
- Citizenship & Voting Data from the Current Population Survey
• New annual estimates of housing units authorized by building permits
- released May 1, 2024: U.S., Region, State, Metropolitan Area, County, and Place
- new annual 2023 data
- revised annual 2022 data

04.30.24. Topics
• DEDE3 updates

• How & Why Michigan Demographics are Changing
- state by state sections developed in upcoming months

• How & Why County Demographics are Changing
- interactive table

• CountyTrends GIS Project

• Demographic Analytics 2 updates & illustrative views
- These web-based HTML versions can also be created using in XLS format using DA2.
- illustrative views
- select ACS 1-year or 5-year data
- census tract up by summary level

Recent Topics
04.16.24. Topic .. How & Why Metropolitan Areas are Changing
- updated main page, new interactive table, metro demographic change included in VDAGIS Base project

Did you know .. among the 15 2023 vintage Michigan Metropolitan Statistical Areas
.. six increased in population during 2020-2023, one had no change, and eight lost population?
.. learn how and why this change has occurred.

The Detroit MSA, its two component Metropolitan Divisions, the MSA component counties.

04.09.24. Topic .. Mobility .. 1-year migration based on residence one year ago
- developing for places using ACS 2022

04.02.24. Topic .. Language Spoken at Home (LSAH)
- developing for counties using ACS 2022

03.26.24. Topic .. Examining the School District Community
- Clark County School District

Topic 2 .. Updates to the VDAGIS "Base" project
- . Click to start Open VDA Web GIS featuring the Base project

03.19.24. Topic .. Migration .. how & why county population is changing
- developing for counties using Vintage 2023 model-based estimates

03.12.24. Topic .. Examining the Daytime (commuter adjusted) Population
- developing for places using ACS 2022
- reviewing computation and data required
- creating dataset using DEDE
- file created: C:\dede\api_items_acs22_daytime_places.dbf
- modify file: Commuter-adjusted population = Total resident population + Total workers working in area - Total workers living in area.
- integrate shapefile into places shapefile using CVXEGIS Database>dBMerge
- add shapefile to GIS project, adjust layer, show in map:

• Migration .. how & why county population is changing
- examining county/metro demographic change using Vintage 2023 model-based estimates

How & Why County Population Has Changed 2020-2023

Selected County Profiles
- Fresno, CA
- Orange, CA
- Los Angeles, CA
- Harris County, TX

Using US1 GIS project to examine county/metro population & components of change

• New Tracts 2022 Web section/page & interactive table
- dataset integrated into VDAGIS Base project
• Open VDA Web GIS CD review/update; very similar to Open VDA Web GIS
• Demographic Analytics (DA) updates
- tabular & narrative comparative analysis reports
• Demographic Economic Data Explorer (DEDE) updates
- DEDE2 - ACS time series & geocomposite
- DEDE-DP Update -- Demographic Economic Data Explorer - Data Profiles .. demo of work-in-progress
- dbtools/dbf development added; all school districts added
- illustrative DP views: DP5 General Demographics .. DP2 Social .. DP3 Economic .. DP4 Housing
• ChartGraphics update/review -- population pyramids
• January 2024 Place/County Building Permits time series monthly update; new data released 02.26.24

Using VDAGIS to Promote Community Business Growth
See related section

By establishing areas that promote economic development, qualified entities can encourage and sustain business growth in their communities. Federal programs available to facilitate such investment and growth are the Opportunity Zones and HUBZones.

The following map illustrates how VDAGIS tools can be used to examine qualified areas in the Atlanta region. The view shows block groups. Block group areas may be of interest to applicants and investors in understanding and documenting demographic-economic characteristics.

Opportunity Zones
An Opportunity Zone is an economically distressed area where new investments may be eligible for certain tax benefits. There are 8,764 Opportunity Zones spread throughout the 50 states, DC and five U.S. territories.

HUBZones
The HUBZone program creates incentives (called "preferences") for federal agencies to purchase goods and services from businesses that operate and employ people in areas designated as HUBZones. The acronym HUB stands for "Historically Underutilized Business," and a HUBZone is a historically underdeveloped business zone that meets one or more of five defined criteria. HUBZones are mainly areas that are Qualified Census Tracts.

Upcoming Topics:
Demographics Today:
• Migration
• Climate Change impact
• School District Community

Release dates:
• 03.06.24. QCEW 2023Q3 Quarterly
.. this table update; VDAGIS Base project updates
• 03.14.24. Census Model-based Vintage 2023 County Population Estimates & Components of Change
.. this table update; VDAGIS Base project updates
• 04.15.24. ProximityOne 2024 Q2 S&O Estimates & Projections

Recent:
• Block Groups ACS 2022 Interactive Table .. about Block Groups
• Voter Demographic Analytics
• Finding & Viewing a Census Tract .. Blog topic
• Demographic-Economic Data Explorer .. DEDE updates
• Vintage 2023 Population Estimates for the U.S. & States with Components of Change
- released 12/19/23 see below
- added to VDAGIS Base
• Using Demographic Analytics with Remote Desktop Service (P1 WinServer)
- nothing to install; use with PC, Mac, iOS, other
- use narrative for talking points; tell a story
- requires app add request
• vintage TIGER Digital Map Database updates

Topics
- 01 Federal GeoStatistical System
- 02 Selected News Items

- 03 Geography: Summary Levels & TIGER

- 04 K-12 Education & School Districts
- 05 Congressional Districts, State Legislative Districts, Congressional Communities
- 06 Metros, Counties, Cities, Towns
- 07 Neighborhoods, Census Tracts

- 08 Population, Births, Deaths, Migration Annual Estimates
- 09 Housing & Real Estate
- 10 Income & Poverty

- 11 GDP & Personal Income
- 12 Labor Force & Employment
- 13 Inflation & Cost of Living
- 14 Establishments, Employment, Wages

- 15 Energy & Environment
- 16 Banking & Finance
- 17 Crime & Social
- 18 Health & Healthcare

Selected Statistical Programs
- 19 American Community Survey (ACS)
- 20 Census 2020
- 21 Current Population Survey

- 22 Using Open VDA Web GIS
- 23 Using VDA Desktop GIS (VDAD)

- 24 Demographic Analytics
- 25 Demographic-Economic Data Explorer
- 26 Regional Economic Information System

- 27 Situation & Outlook Estimates & Projections

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

01. Federal GeoStatistical System .. goto topics
.. The Federal GeoStatistical System .. a dynamic "book"
- weekly updates in the Tuesday session
- section recaps shared in Tuesday session roughly monthly
- only available here until possible "printed" copy in ~spring 2024
- only here .. dialoging on topics of interest

.. Overview
.. multi-sourced data access and integration
.. what is where and how to access it; variations on public data structures

02. Selected News Items .. goto topics

12.19.23. Vintage 2023 Population Estimates for the U.S. and States with Components of Change
.. start of 2023-24 annual cycle

12.07.23. GDP by County, Metro .. series through 2022
.. released 12/07/23
.. Regional Economic Information System

12.07.23. ACS2022 5-year estimates .. annual update

12.01.23. Vintage 20230 TIGER Digital Map Database released .. 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. Geography: Summary Levels & TIGER .. goto topics

3.1. Selected Geography .. access data for these area using Demographic Analytics tool .. Summary Levels
- 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)

3.2. TIGER Digital Map Database
.. main section

04. K-12 Education & School Districts .. goto topics

Summary level 9xx

.. CCD
.. RCNE
.. School District Community

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

05. Congressional Districts & Congressional Communities .. goto topics

.. Congressional Districts .. summary level 500
.. Congressional Communities .. summary level 501

- 06 Metro, Counties, Cities, Towns
- 07 Neighborhoods, Census Tracts
06. Metros, Counties, Cities, Towns .. goto topics

07. Neighborhoods, Census Tracts .. goto topics

08. Population, Births, Deaths, Migration Annual Estimates .. goto topics

8.1. County Annual Estimates
.. Census sourced

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

8.3. Urban/Rural
.. Urban/Rural 2020

8.4.Vintage 2023 Population Estimates for the U.S. & States with Components of Change
.. July 1, 2023 with corresponding annual estimates and components of change since 2020 Census.
.. start of vintage 2023 estimates culminating in June 2024

09. Housing & Real Estate .. goto topics
.. Annual Census Estimates
.. Building Permits, monthly/annual

10. Income & Poverty .. goto topics
.. Small Area Income and Poverty Estimates
..

11. GDP & Personal Income .. goto topics
.. GDP
.. Personal Income

12. Labor Force & Employment .. goto topics
.. BLS programs
.. Census programs
.. BEA programs
13. Inflation & Cost of Living .. goto topics
.. CPI
.. PCE

14. Establishments, Employment, Wages .. goto topics
.. BLS QCEW
.. Census CBP

15. Energy & Environment .. goto topics
..

16. Banking & Finance .. goto topics
.. FDIC
.. FFIEC

17. Crime & Social .. goto topics
.. BJS

18. Health & Healthcare .. goto topics
.. HHS

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

20. Census 2020 .. goto topics
.. main section

21. Current Population Survey (CPS) .. goto topics
.. BLS CPS main
.. Census CPS main
.. Monthly Supplements
ASEC .. Annual Demographic File

22. Using Open VDA Web GIS & Base project .. 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 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

23. Using VDA Desktop GIS (VDAD) .. goto topics
.. VDAD Installer .. click to run .. updated 11/07/23; shows as version 11.08.23

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

24. Demographic Analytics .. goto topics
.. Demographic Analytics main

25. Demographic-Economic Data Explorer .. goto topics
.. new DEDE2 & Installer .. about DEDE2
.. run DEDE2 installer

.. DEDE compared to DEDE2

.. DEDE Guide updates .. http://proximityone.com/dede_guide/guide
.. DEDE Installer Updated
.. run DEDE installer
.. 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

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

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

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

27. Situation & Outlook Estimates & Projections Overview .. goto topics
See S&O Calendar

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

04.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)

07.15.24. Situation & Outlook Quarterly Release

10.15.24. Situation & Outlook Quarterly Release

Navigating the Website & Accessing Resources
.. home page .. http://proximityone.com
.. SiteMap .. bottom of every page
.. Calendar .. via SiteMap or home page
.. using Calendar & searching for topics/events .. https://proximityone.com/calendar.htm

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.

Topics today:

• TIGER 2024 Digital Map Database -- released 9/26/24

• American Community Survey 2023 1-year estimates -- released 9/12/24

• Using GIS & GeoDemographics Course -- Module 3 for November starts today 11/14/24

• Demographic Economic Data Explorer DEDE Web page updated
- updated schedule

• Creating a Thematic Pattern Layer using CV XE GIS

• New Block Equivalency Files .. 119th Congressional District and 2024 State Legislative Districts

• iVDA applications .. new and updated
- iVDA Main
- VDAGIS Discovery
- Metros
- Knowing Your Neighborhood Tool
- America's Cities

• Using the US1_CC GIS Project with CVXEGIS
- US1_GIS GIS Project start-up view using CV XE GIS

- relation of CVXEGIS to VDAGIS Suite
.. CVXEGIS recommended for project development & modifications
.. VDAGIS Suite recommeded for users
- orientation to CVXEGIS user interface
- CV XE GIS User Guide
- a GIS project file defines the layers to be used and their start-up attributes
.. most layers correspond to a shapefile; multiple layers can use the same shapefile
- shapefiles consist of one or more shapes, often hundreds, like U.S. by county; each county is a shape/geographic object
- each shape has a set of associated fields or attributes specified in the shapefile dbf file

- setting user options: the default GIS project opened at setup
- GIS projects are named like ????.gis; opening other files (e.g., KML)
- open and saving a GIS project; overview of GIS project file
- adding and removing layers
- brief review of layers in the US1_CC GIS Project
- using the Layer Editor

- metadata for cc20_us_012723_2022acsitemset1_cvap.shp.fld

CCN20=CCN Code
GEOID=GEOID (same as CCN20)
ST=State
aland=Land area sqmt
awater=Water area sqmt
D001=D001 Total Population
D002=D002 Male
D003=D003 Female
D005=D005 Under 5 Years
D006=D006 5 to 9 Years
D007=D007 10 to 14 Years
D008=D008 15 to 19 Years
D009=D009 20 to 24 Years
D010=D010 25 to 34 Years
D011=D011 35 to 44 Years
D012=D012 45 to 54 Years
D013=D013 55 to 59 Years
D014=D014 60 to 64 Years
D015=D015 65 to 74 Years
D016=D016 75 to 84 Years
D017=D017 85 Years and Over
D018=D018 Median age (years)
D019=D019 Under 18 years
D020=D020 16 years and over
D021=D021 18 years and over
D022=D022 21 years and over
D023=D023 62 years and over
D024=D024 65 years and over
D036=D036 One Race
D037=D037 One Race -- White
D038=D038 One Race -- Black or African American
D039=D039 One Race -- American Indian and Alaska Native
D044=D044 One Race -- Asian
D052=D052 One Race -- Native Hawaiian and Other Pacific Islander
D057=D057 One Race -- Some Other Race
D058=D058 Two or more races
D073=D073 Hispanic or Latino (of any race)
D074=D074 Hispanic or Latino (of any race) -- Mexican
D078=D078 Not Hispanic or Latino
D079=D079 Not Hispanic or Latino -- White Alone
D080=D080 Not Hispanic or Latino
D088=D088 Total housing units
D089=D089 Citizen 18 and Over Population
D090=D090 Citizen 18 and Over Population - Male
D091=D091 Citizen 18 and Over Population - Female
S001=S001 Total Households
S002=S002 Total Households -- Married-couple family
S004=S004 Total Households -- Cohabitating couple household
S006=S008 Total Households -- Householder living alone male
S010=S012 Total Households -- Householder living alone female
S016=S016 Average household size
S017=S017 Average family size
S018=S018 Population in Households
S053=S053 School Enrollment -- Pop 3 Yrs & Over Enrolled in School
S054=S054 School Enrollment -- Pop 3 Yrs & Over Enrolled in School -- Nursery School Preschool
S055=S055 School Enrollment -- Pop 3 Yrs & Over Enrolled in School -- Kindergarten
S056=S056 School Enrollment -- Pop 3 Yrs & Over Enrolled in School -- Elementary School (Grades 1-8)
S057=S057 School Enrollment -- Pop 3 Yrs & Over Enrolled in School -- High School (Grades 9-12)
S058=S058 School Enrollment -- Pop 3 Yrs & Over Enrolled in School -- College or Graduate School
S059=S059 Educational Attainment -- Pop 25 Yrs & Over
S060=S060 Educational Attainment -- Pop 25 Yrs & Over -- Less than 9th Grade
S061=S061 Educational Attainment -- Pop 25 Yrs & Over -- 9th to 12th Grade No Diploma
S062=S062 Educational Attainment -- Pop 25 Yrs & Over -- High School Graduate (Incl Equivalency)
S063=S063 Educational Attainment -- Pop 25 Yrs & Over -- Some College No Degree
S064=S064 Educational Attainment -- Pop 25 Yrs & Over -- Associate's Degree
S065=S065 Educational Attainment -- Pop 25 Yrs & Over -- Bachelor's Degree
S066=S066 Educational Attainment -- Pop 25 Yrs & Over -- Graduate or Professional Degree
S067=S067 Educational Attainment -- Pop 25 Yrs & Over -- Percent High School Graduate or Higher
S068=S068 Educational Attainment -- Pop 25 Yrs & Over -- Percent Bachelor's Degree or Higher
S079=S079 Residence 1 Year Ago -- Population 1 Year and Over
S080=S080 Residence 1 Year Ago -- Same House
S081=S081 Residence 1 Year Ago -- Different House in US or abroad
S082=S082 Residence 1 Year Ago -- Different House in US
S083=S083 Residence 1 Year Ago -- Different House in US -- Same County
S084=S084 Residence 1 Year Ago -- Different House in US -- Different County
S085=S085 Residence 1 Year Ago -- Different House in US -- Different County -- Same State
S086=S086 Residence 1 Year Ago -- Different House in US -- Different County -- Different State
S087=S087 Residence 1 Year Ago -- Abroad
S089=S089 Place of Birth -- Native
S090=S090 Place of Birth -- Native -- Born in U.S.
S091=S091 Place of Birth -- Native -- Born in U.S. -- State of Residence
S092=S092 Place of Birth -- Native -- Born in U.S. -- Different State
S093=S093 Place of Birth -- Native -- Born in PR, US Island Areas or Born Abroad to American Parents
S094=S094 Place of Birth -- Foreign Born
S095=S095 U.S. Citizenship Status -- Foreign-Born Population
S096=S096 U.S. Citizenship Status -- Foreign-Born Population -- Naturalized U.S. Citizen
S097=S097 U.S. Citizenship Status -- Foreign-Born Population -- Not a U.S. Citizen
S112=S112 Language Spoken at Home -- Pop 5 Yrs & Over
S113=S113 Language Spoken at Home -- Pop 5 Yrs & Over -- English Only
S114=S114 Language Spoken at Home -- Pop 5 Yrs & Over -- Language Other Than English
S115=S115 Language Spoken at Home -- Pop 5 Yrs & Over -- Language Other Than English -- Speak English Less Than Very Well
S116=S116 Language Spoken at Home -- Pop 5 Yrs & Over -- Language Other Than English -- Spanish
S117=S117 Language Spoken at Home -- Pop 5 Yrs & Over -- Language Other Than English -- Spanish -- Speak English Less Than Very Well
S152=S152 Computers and Internet Use -- Total Households
S153=S153 Computers and Internet Use -- Households with a Computer
S154=S154 Computers and Internet Use -- Households with a Broadband Internet Subscription
E001=E001 Employment Status -- Population 16 Years+
E002=E002 Employment Status -- in Labor Force
E003=E003 Employment Status -- Civilian Labor Force
E004=E004 Employment Status -- Employed
E005=E005 Employment Status -- Unemployed
E006=E006 Employment Status -- Armed Forces
E007=E007 Employment Status -- Not in Labor Force
E008=E008 Employment Status -- Civilian Labor Force
E009P=E009 Employment Status -- Percent Unemployed
E026=E026 Civilian Employed Population 16 Years+
E027=E027 Occupation -- Management, business, science, and arts
E028=E028 Occupation -- Service occupations
E029=E029 Occupation -- Sales and office occupations
E030=E030 Occupation -- Natural resources, construction & maintenance
E031=E031 Occupation -- Production, trans and material moving
E033=E033 Industry -- Agriculture Forestry Fishing & Hunting & Mining
E034=E034 Industry -- Construction
E035=E035 Industry -- Manufacturing
E036=E036 Industry -- Wholesale Trade
E037=E037 Industry -- Retail Trade
E038=E038 Industry -- Transportation & Warehousing & Utilities
E039=E039 Industry -- Information
E040=E040 Industry -- Finance & Insurance & Real Estate & Rental & Leasing
E041=E041 Industry -- Prof, Scientific, & Management & Admin & Waste Mgmt Svc
E042=E042 Industry -- Educational Services & Health Care & Social Assistance
E043=E043 Industry -- Arts, Entertainment, Recreation, Accommodation & Food Services
E044=E044 Industry -- Other Services Except Public Administration
E045=E045 Industry -- Public Administration
E047=E047 Class of Worker -- Private Wage & Salary Workers
E048=E048 Class of Worker -- Government Workers
E049=E049 Class of Worker -- Self-Employed, Not Inc Business Workers
E050=E050 Class of Worker -- Unpaid Family Workers
E052=E052 Total Households -- Income and Benefits -- Less Than $10,000
E053=E053 Total Households -- Income and Benefits -- $10,000 to $14,999
E054=E054 Total Households -- Income and Benefits -- $15,000 to $24,999
E055=E055 Total Households -- Income and Benefits -- $25,000 to $34,999
E056=E056 Total Households -- Income and Benefits -- $35,000 to $49,999
E057=E057 Total Households -- Income and Benefits -- $50,000 to $74,999
E058=E058 Total Households -- Income and Benefits -- $75,000 to $99,999
E059=E059 Total Households -- Income and Benefits -- $100,000 to $149,999
E060=E060 Total Households -- Income and Benefits -- $150,000 to $199,999
E061=E061 Total Households -- Income and Benefits -- $200,000 or More
E062=E062 Median Household Income
E063=E063 Mean Household Income
E064=E064 Income and Benefits -- Households -- with Earnings
E065=E065 Income and Benefits -- Households -- with Earnings -- Mean Earnings $
E066=E066 Income and Benefits -- Households -- with Social Security
E067=E067 Income and Benefits -- Households -- with Social Security -- Mean Social Security Income $
E068=E068 Income and Benefits -- Households -- with Retirement Income
E069=E069 Income and Benefits -- Households -- with Retirement Income -- Mean Retirement Income $
E070=E070 Income and Benefits -- Households -- with Supplemental Security Income
E071=E071 Income and Benefits -- Households -- with Supplemental Security Income -- Mean Supplemental Security Income $
E072=E072 Income and Benefits -- Households -- with Cash Public Assistance Income
E073=E073 Income and Benefits -- Households -- with Cash Public Assistance Income -- Mean Cash Public Assistance Income $
E074=E074 Income and Benefits -- Households -- with Food Stamp/Snap Benefits in the Past 12 Months
E075=E075 Income and Benefits -- Families
E076=E076 Income and Benefits -- Families -- Less Than $10,000
E077=E077 Income and Benefits -- Families -- $10,000 to $14,999
E078=E078 Income and Benefits -- Families -- $15,000 to $24,999
E079=E079 Income and Benefits -- Families -- $25,000 to $34,999
E080=E080 Income and Benefits -- Families -- $35,000 to $49,999
E081=E081 Income and Benefits -- Families -- $50,000 to $74,999
E082=E082 Income and Benefits -- Families -- $75,000 to $99,999
E083=E083 Income and Benefits -- Families -- $100,000 to $149 999
E084=E084 Income and Benefits -- Families -- $150,000 to $199 999
E085=E085 Income and Benefits -- Families -- $200,000 or More
E086=E086 Median Family Income
E087=E087 Mean Family Income
E088=E088 Per Capita Income
E089=E089 Nonfamily Households
E090=E090 Nonfamily Households -- Median Nonfamily Income
E091=E091 Nonfamily Households -- Mean Nonfamily Income
E092=E092 Median Earnings for Workers
E093=E093 Median Earnings for Male Full-Time Year-Round Workers
E094=E094 Median Earnings for Female Full-Time Year-Round Workers
E095=E095 Civ Noninst Population
E096=E096 Civ Noninst Population -- Health Insurance Coverage -- .. with Health Insurance Coverage
E097=E097 Civ Noninst Population -- Health Insurance Coverage -- ... with Private Health Insurance Coverage
E098=E098 Civ Noninst Population -- Health Insurance Coverage -- ...... with Public Health Coverage
E099=E099 Civ Noninst Population -- Health Insurance Coverage -- .... No Health Insurance Coverage
E119P=E119 Percent Families whose income past 12 onths below poverty level
E128P=E128 Percent All People whose income past 12 onths below poverty level
H001=H001 Total Housing Units
H002=H002 Occupied Housing Units
H003=H003 Vacant Housing Units
H004=H004 Homeowner Vacancy Rate
H005=H005 Rental Vacancy Rate
H007=H007 Total Housing Units -- Units in Structure -- 1-Unit Detached
H008=H008 Total Housing Units -- Units in Structure -- 1-Unit Attached
H009=H009 Total Housing Units -- Units in Structure -- 2 Units
H010=H010 Total Housing Units -- Units in Structure -- 3 or4 Units
H011=H011 Total Housing Units -- Units in Structure -- 5 to 9 Units
H012=H012 Total Housing Units -- Units in Structure -- 10 to 19 Units
H013=H013 Total Housing Units -- Units in Structure -- 20 or More Units
H014=H014 Total Housing Units -- Units in Structure -- Mobile Home
H015=H015 Total Housing Units -- Units in Structure -- Boat, RV, Van
H017=H017 Total Housing Units -- Year Built -- 2020 or later
H018=H018 Total Housing Units -- Year Built -- 2010 to 2019
H019=H019 Total Housing Units -- Year Built -- 2000 to 2009
H020=H020 Total Housing Units -- Year Built -- 1990 to 1999
H021=H021 Total Housing Units -- Year Built -- 1980 to 1989
H022=H022 Total Housing Units -- Year Built -- 1970 to 1979
H023=H023 Total Housing Units -- Year Built -- 1960 to 1969
H024=H024 Total Housing Units -- Year Built -- 1950 to 1959
H025=H025 Total Housing Units -- Year Built -- 1940 to 1949
H026=H026 Total Housing Units -- Year Built -- 1939 or earlier
H037=H037 Total Housing Units -- Rooms -- Median Rooms
H046=H046 Tenure -- Owner-Occupied
H047=H047 Tenure -- Renter-Occupied
H048=H048 Tenure -- Average Household Size of Owner-Occupied Unit
H049=H049 Tenure -- Average Household Size of Renter-Occupied Unit
H051=H051 Year Householder Moved into Unit -- 2019 or later
H052=H052 Year Householder Moved into Unit -- 2015 to 2018
H053=H053 Year Householder Moved into Unit -- 2010 to 2014
H054=H054 Year Householder Moved into Unit -- 2000 to 2009
H055=H055 Year Householder Moved into Unit -- 1990 to 1999
H056=H056 Year Householder Moved into Unit -- 1989 or earlier
H058=H058 Occ housing units -- No Vehicles Available
H059=H059 Occ housing units -- Vehicles Available -- 1 Vehicle Available
H060=H060 Occ housing units -- Vehicles Available -- 2 Vehicles Available
H061=H061 Occ housing units -- Vehicles Available -- 3 or More Vehicles Available
H063=H063 House Heating Fuel -- Utility Gas
H064=H064 House Heating Fuel -- Bottled Tank or LP Gas
H065=H065 House Heating Fuel -- Electricity
H066=H066 House Heating Fuel -- Fuel Oil Kerosene Etc.
H067=H067 House Heating Fuel -- Coal orCoke
H068=H068 House Heating Fuel -- Wood
H069=H069 House Heating Fuel -- Solar Energy
H077=H077 Occupants per Room -- 1.00 or Less
H078=H078 Occupants per Room -- 1.01 to 1.50
H079=H079 Occupants per Room -- 1.51 or More
H081=H081 Value -- Less Than $50 000
H082=H082 Value -- $50,000 to $99,999
H083=H083 Value -- $100,000 to $149,999
H084=H084 Value -- $150,000 to $199,999
H085=H085 Value -- $200,000 to $299,999
H086=H086 Value -- $300,000 to $499,999
H087=H087 Value -- $500,000 to $999,999
H088=H088 Value -- $1,000,000 or More
H089=H089 Median Housing Value
H090=H090 Owner-Occupied Units
H091=H091 Mortgage Status -- Housing Units with a Mortgage
H092=H092 Mortgage Status -- Housing Units Without a Mortgage
H126=H126 Occupied Units Paying Rent
H127=H127 Gross Rent -- Less Than $500
H128=H128 Gross Rent -- $500 to $999
H129=H129 Gross Rent -- $1,000 to $1,499
H130=H130 Gross Rent -- $1,500 to $1,999
H131=H131 Gross Rent -- $2,000 to $2,499
H132=H132 Gross Rent -- $2,500 to $2,999
H133=H133 Gross Rent -- $3,000 or More
H134=H134 Median Rent

- assignment for week 2 using the US1_CC project
.. each of the following steps are discussed and operationally reviewed in this sessionn
.. add a second layer using the shapefile "D:\_us1_2024\cc20_us_012723cd_dp1.shp"
.. File>SaveAs to save the project as "d:\_us1_2024\us1_cc2.gis"
.. place it below the layer "Cong Comm C20 DP1"; name the layer "Cong Comm C20 DP1 Diversity"
.. rename the layer "Cong Comm C20 DP1" to "Cong Comm C20 DP1 Code"
.. in the layer "Cong Comm C20 DP1 Code" set the label to the field "GEOID" and in the shape center position
.. File>Save to resave the project

- Notes on Creating Intervals/Sections for Diversity
.. dbl-click the layer "Cong Comm C20 DP1 Diversity" to start the Layer Editor
.. the following graphic illustrates using the Layer Editor to develop the intervals and thematic map

End of Subsection

Earlier:

• Median Age, U.S. by County 7/1/2023
- Census Bureau sourced model-based estimates released 6/27/24
- the U.S. redident population increased from 38.5 years (2020) to 40.2 years (2023)

- graphic developed using VDAGIS with the US1 GIS Project

• VDA Desktop GIS Installer Updates
- the "code signing tool" used for security signing of the VDAD installer has been updated.
this will help eliminate the security warnings.
- the VDAD installer content has also been updated.
- the installer https://proximityone.com/vda/1/vdagis_installer.exe
no longer requires a userid to download/start using.
- then VDAD starts locally, the user is "level 0"
- a Level 0 user can use the File>OpenVDAServer project to open the Base project
- a user who has "signed up" (using VDA Web GIS) can File>Login and open with their user id.
this is what establishes feature availability.

• Embedding VDAGIS in Youe Web Pages
- see/discuss application mapping census tract demographics

• Using the Open VDA GIS and VDA Desktop Updated GeoSelect/Site Analysis Feature

• Examining Patterns of 2020-23 HPI Percent Change by ZIP Code
- thematic pattern map depicting HPI 2022-2023 percent change by ZIP Code.
-

- use OpenVDA to create similar views:
- Click to start OpenVDA
- Click for more information about OpenVDA

• Geospatial analysis of 2020-2024 Housing Unit Change by Census Block
- “How are our neighborhoods changing?”
- query applied to census blocks layers .. hu24-hu20>10
- showing blocks in Lansing, MI area increasing by more than 10 housing units, 2020 to 2024
- pointer is in a block that increased from 369 to 449 units and is in Congressional Community 2607010
- not estimates but counts. The 2024 data only includes HU & GQ. These can aggregate to any summary level
- next update January 2025
-

• Census Smoothed/clipped Vintage 2023 TIGER/Line Shapefiles & Related File Available
- why this is important
- access files
- about TIGER/Line

• Using the new Banks layer in VDAGIS Base project .. - about these data
- using these data with VDAGIS tools
-

• Using Census 2023 Vintage County Model-Based Estimates Released 3/14/24
- adding layers to the US1.GIS project; updating the US1.GIS project

• How & Why County Demographics are Changing
- interactive table

• CountyTrends GIS Project

• Demographic Analytics 2 updates & illustrative views
- These web-based HTML versions can also be created using in XLS format using DA2.
- Clark County, NV ACS2022 1-year
- Wayne County, MI ACS2022 1-year
- Congressional District MI 07 ACS2022 5-year
- Congressional District MI 07 ACS2022 1 year
- Congressional District CA 47 ACS2022 1 year
- Unites States ACS2022 1 year
- select ACS 1-year or 5-year data
- census tract up by summary level

• How & Why Metropolitan Areas are Changing
- updated main page, new interactive table, metro demographic change included in VDAGIS Base project

Did you know .. among the 15 2023 vintage Michigan Metropolitan Statistical Areas
.. six increased in population during 2020-2023, one had no change, and eight lost population?
.. learn how and why this change has occurred.

The Detroit MSA, its two component Metropolitan Divisions, the MSA component counties.

How & Why County Population Changed 2020-2022

How & Why County Population Changed 2020-2023

• Getting started with VDAGIS tools and CV XE GIS
- CV XE GIS Desktop - Windows; run installer
- VDA Desktop GIS - Windows; run installer
- US1 project .. part of installer

• VDA Web GIS .. register for credentials
• Open VDA Web GIS

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