Visual Data Analytics


Welcome to Visual Data Analytics (VDA) Web GIS
.. develop insights into patterns, change and trends
.. geographic, demographic, economic characteristics
.. gateway to the Federal Statistical System
.. integrate your data; add your GIS projects
.. using TIGER roads database
    36 million street segments
.. smartphone user interface
.. Low & Moderate Income by census tract
.. examining Ukraine
.. examining largest 50 metros
Start VDA .. county profile a click away
E-mail questions or call (888)364-7656
News .. Using this Document .. Support
Terms of Use .. GeoSpatial Analytics Forum
Getting Started

VDA Situation & Outlook Project
Start-up view .. click graphic for larger view

.. Texas is clicked in map
.. displays Census 2020 demographic profile in lower left panel
.. see more about the S&O project below

Percent Population Change 2010-2020 by County
Upcoming & Recent Developments
You are invited ..
Join us in the every Thursday Web Sessions
GeoSpatial Analytics
a forum focused on GIS, geography, situation & outlook
02.05.22 Situation & Outlook Project Update
Congressional Communities update
.. use VDA tools to view/analyze these data in maps or tabular form
.. create your own custom interactive tables
.. see details soon
02.03.22 GeoSpatial Analytics Web Session
3:00 pm ET .. forum on GIS & geospatial analysis
introducing the TIGER digital map database learning modules
geography available via VDA; see related geography & TIGER/DMD sections in this guide
12.01.21 Quarterly Establishments by NAICS/County 2021Q2 Update
access these data, build your datasets, S&O reports using DEDE API
these updates integrated into VDA Situation & Outlook
11.25.21 Examining Urban Areas
an early way to examine 2020-based urban areas
11.24.21 Find Address feature updated
easier access; easier to locate a geography.
11.23.21 Real-time Geographic Area Computation
compute per capita measures for any polygon area
11.20.21 Geography and TIGER/DMD sections updated/expanded
These sections also show in the menu.
11.18.21 VDA Web GIS Situation & Outlook Update
U.S. by Tract HUD Qualified Census Tract analytics enabled
U.S. by Tract FFIEC Low & Moderate Income analytics enabled
11.17.21 New feature
Dynamic computation of shape/object geographic area
11.01.21 Creating City/Place Demographic Profiles
10.25.21 Analyzing the Housing Price Index
10.20.21 New features
.. Creating County Demographic Profiles
.. Creating ZIP Code Profiles
10.19.21 VDA User Guide (this document) restructured; device independent
10.05.21 New features
Project Editor - modify map views; create new projects

Introductory Notes About VDA
The initial Census 2020 demographics by census block and higher level geography became available August 12, 2021. See details. Use the Visual Data Analytics VDA Web GIS to access/use these data optionally with your data .. we invite you to join in!

Quick Click Comparative Analysis County Profile .. goto top
.. easy to use and powerful capabilities
.. a click or two away from a profile for any county:
  - login and select the "Situation & Outlook" project.
  - above the Map Window, enter the state+county FIPS code (stcty) for county of interest.
  - click Find County button.
    .. the default stcty code is 06019 (Fresno County, CA).
  - the county highlights in Map Window; the profile shows in the lower left panel.
      optionally change these layer settings in Legend Panel:
      - uncheck "County %PopChg 2010-2020"
      - uncheck "World by Country"
      - check on "OpenStreetMaps Tiles"
  - click the copy-to-clipboard button below the profile panel.
  - open the S&O County XLS template.
    .. the XLS template file initially shows data for the default area -- Fresno County
        - orienting .. note that the Census 2010 total population for Fresno County (cell C20) is 930,450.
    .. paste (Ctrl-V> into cell K1 .. adding the copy-to-clipboard data to the view; replacing the default data.
    .. data from profile panel show in Col 3 with descriptive stubs
        - 30 subject matter items from Census 2010
        - same set of items from Census 2020
        - set of richer demographics from ACS 2019
        - model-based estimates & projections.
  .. see more about County Trends

Quick Click Comparative Analysis ZIP Profile .. goto top
.. easy to use and powerful capabilities
.. a click or two away from a profile for any ZIP Code:
  - login and select the "Situation & Outlook" project.
  - above the Map Window, enter the 5-digit ZIP code for a ZIP code of interest.
    the default ZIP code is 91780 located in Los Angeles County, CA.
.. see details about this ZIP Code
.. the FHFA HPI is computed for approximately 19,000 ZIP codes (of approximately 33,000)
      the HPI values are zero for non-computed areas
.. the ZIP code area highlights in Map Window; the profile shows in the lower left panel.
      optionally change these layer settings in Legend Panel:
      - uncheck "County %PopChg 2010-2020"
      - uncheck "World by Country"
      - check on "OpenStreetMaps Tiles"
.. click the copy-to-clipboard button below the profile panel.
.. open the S&O ZIP Code XLS template.
    - the XLS template file initially shows data for the default area -- ZIP 91780
        note that the ACS 2019 total population for this ZIP (cell C6) is 35,133.
    .. paste (Ctrl-V> into cell K1 .. adding the copy-to-clipboard data to the view; replacing the default data.
    .. data from profile panel show in Col 3 with descriptive stubs
        - set of richer demographics from ACS 2019
        - annual FHFA HPI estimates 2010-2020 (base 2000=100).
  .. see more about HPI by ZIP Code

The World in Constant Change .. goto top
The world is in constant change. Keeping up with knowing about the where, what, how and how much of change is and might occur can be challenging. "Knowing" is important for many reasons from understanding opportunities that may exist to learning how change might impact us. Visual analysis using interactive mapping is often the most effective and fastest way to answer many types of geodemographic questions. Communicating and collaborating with others can produce better results using maps than using tabular data alone.

Viewing/Analyzing Data from Census 2010, Census 2020 & ACS .. goto top
Use the VDA3 ready-to-use projects to view/analyze data from Census 2010, Census 2020, American Community Survey down to the census block/block group level of detail. Integrate your geography and data.

GeoSpatial Analytics group - a forum focused on GIS, geography, situation & outlook
.. Request to join
.. Registered participants click here to access forum.

VDA Start-up View .. goto top
The following graphic shows the VDA start-up view using the "Census 2020" project. VDA operates with most browsers. Start VDA to dynamically see the view shown below. The Census 2020 start-up view is focused on southern California. This view shows patterns of economic prosperity -- median household income ($MHI) by census tract. Easily, flexibly and quickly shift the view to your area of interest.

.. click graphic for larger view.

About VDA, Credits, Using this Document .. goto top
This document provides an overview of the VDA3 Web GIS and instructions on its use. VDA has been developed by Warren Glimpse/ProximityOne/Alexandria, VA USA and Takashi Hamilton/Tsukasa/Osaka, Japan. All that is required to use VDA is a Web browser. iOS and Android versions are supported. VDA uses the same core structure as the Windows desktop VDA Desktop. VDA3 is the premier version of VDA, offering to manage your own GIS projects, securely and efficently.

What's Ahead & Happening .. goto top
  • Project Editor feature for Level 3 users; edit your project right down to a label color
  • VDA Web GIS now an integral part of the Certificate in Data Analytics
  • VDA Web GIS "every Thursday" training & support VDA Data Analytics Web Session
  • New and updated "Base Projects"; new structures and refreshed data.

Visual Data Analytics VDA Web GIS. VDA Web GIS is a learning resource, a tool that you can use for interactive mapping and geospatial analysis using only Internet and a browser. VDA is set apart from related tools due to the scope and style of accessing data for wide-ranging geography and frequently updated demographic-economic subject matter data. Use our unique combination of Federal statistical data with proprietary current estimates and projections.

There is nothing to install. Use VDA anywhere. VDA is available in these forms:
  • Web-based interactive access using a browser and HTML .. get started now, click this link.
  • Installed on your hosted server for your private (e.g., organization-wide) use.
  • Provided as a complete turnkey package for use on your site with related GIS project developer tools.
    .. integrate your own data.

Getting Started .. goto top

This section provides basic getting started information. Although VDA requires only a browser and can be used with most any device, it is suggested that a desktop computer be used for the best experience. To experience all features of VDA it is suggested that the the browser setting allows popups.

Login Form
When VDA starts (click this link to start VDA), enter your userid and password in the login screen.
    .

Registering as a New User
To register as a new user click "Signup" on the Login form (above), the following registration information appears.
  the following is just an example. Start VDA to signup and perform this step.
SignUp to use VDA ...
1) Add your name and email address below. Then click OK.
2) You will receive an e-mail with your initial password.
3) You can use the VDA Login form and start VDA.
See more information here
user name   
email address



You will receive an email confirming your account has been created and providing an initial password. You may then start VDA and login with your userid and password.
  • your userid is your e-mail address
  • your password is initially the one sent to you by VDA admin
  • you can optionally change your password on the login form.

Signing up to use VDA provides Level 1 access. Note that Level 1 users do not have access to all features and that a 10-minute automatic logoff will occur during sessions. Optionally login and resume VDA use.

After VDA Login
After logged in, the VDA User Profile form appears.

Select from your authorized projects, immediately starting that project,
  • to select a project, click on the project name; it turns blue.
  • then click the Select project button.
  • VDA starts and the selected project opens.

Which project to use?
  • If new to VDA, select "Situation & Outlook" project.
  • see more information about available projects.

Changing Password
After login, change your password on the VDA User Profile form (see above) by clicking the Change Password button at the bottom of the form. A new form appears where you can enter your new password.

Recommended Getting Started Steps .. tutorials/examples
Start using the "Situation & Outlook" project and follow these steps.

Using the Find ZIP Code feature
  • Enter a ZIP code in the Find ZIP Code edit box above the Map Window, then click the Find ZIP button.
  • The Map Window refreshes showing a zoom to the selected ZIP code and displayed the ZIP as crosshatched.
    .. this can be a useful tool to locate an area of interest.

  • If you use ZIP code 91780 (try it now), the Map Window refreshes to an area in Los Angeles.
  • As the ZIP code query is performed, a demographic-economic profile is diaplayed in the Profile Panel (lower left).
    .. see that the ZIP Code (ZCA) shows value 91780 and the total population 35,133.

Using the Find Address feature
  • Enter an address in the Find Address edit box above the Map Window, then click the Find Address button.
  • The Map Window refreshes showing a zoom to the selected ZIP code and displayed the ZIP as crosshatched.
    .. this can be a useful tool view the location of an address of interest.
    .. the default address "405 Hilgard Avenue 90095" is the UCLA address in Los Angeles.
    .. use of this partial address illustrates that an exact addrees or address form is not required.
  • This Find Address feature is one of several methods of finding/viewing an address.

What/Where is my Congressional Community?
  • This example introduces the Select Layer feature and Active Layer concept.
  • The Congressional Communities layer is one layer listed in the Legend panel at the left of the Map Window.
  • Make this layer the Active layer by selecting that layer name from the top left Select dropdown.
  • Click the default Find Address (see above) then click the blue triangle location.
    .. the Congressional Community displays crosshatched.

Using GeoSelect in combination with Find Address feature
  • This example gets a little more involved.
  • Once an address is located, the user may want to know more about that lcoation.
  • The GeoSelect tool can show demographic and other attributes for areas as small as a census block.

One-Click Profiles .. part of tutorials
Using the "Base" project. From the start-up view of the Base project:
  • enter a ZIP Code of interest above the Map Window click Find ZIP
    .. the Profile Panel (lower left) populates with attributes of that ZIP code.
    .. click the copy-to-clipboard button below Profile Panel and paste the profile to a spreadsheet, text editor, etc.
  • enter a state+county FIPS code for a county of interest above the Map Window click Find County
    .. the Profile Panel (lower left) populates with attributes of that county.
    .. the profile provides Census 2020 demographics for that county.
    .. click the copy-to-clipboard button below Profile Panel and paste the profile to a spreadsheet, text editor, etc.

County/Block Geographic Comparative Analysis Spreadsheet Profiles .. part of tutorials
A common application of interest is the ability to compare demographic-economic attributes in side-by-side columns, geographic area comparison profiles. The following notes show how to do this. Building on the "One-Click" tutorial above, proceed as follows:
  • select the "County" layer in the upper left dropdown, making it the Active Layer.
  • in the above view that you have created, click on Dallas County in the Map Window.
  • the demographic profile for Dallas County appears in the lower left Profile Panel.
  • click the copy-to-clipboard button under the Profile Panel.
  • open the Census 2020 excel profile template
  - in the Excel spreadsheet, Ctrl-V or paste into cell L1.
  - the profile should appear as shown below.


The profile shows selected geographic attributes in the upper rows and Census 2020 demographics in the lower section. To compare one county to another, after proceeding as above:
  • in the spreadsheet, copy columns 2 and 3 and paste into D1
  • click on another county in the map window, copy to clipboard
  • in the spreadsheet, paste into N1
The counties how appear side by side. Continue similarly with more areas.

Examining Metro Demographic Change: Census 2010 - Census 2020 .. part of tutorials
Use the "Base" project to view/examine how metropolitan area demographics have changed from Census 2010 to Census 2020. The following notes show how to do this. With the Base project open, proceed as follows:
  • select the "Metro 2020" layer in the upper left dropdown, making it the Active Layer.
  • check the "Pop %Chg 10-20 x MSA" layer on.
  • click the expand button to the left of that checkbox.
  • uncheck the click the "Pop %Chg 10-20 x County" layer.
  • the view shown below now appears.



Examining Census Tract Demographic-Economic Characteristics .. part of tutorials .. goto top
Use the "Situation & Outlook" (S&O) project to view/examine census tract demographic-economic characteristics. See details about the S&O project below. With the S&O project open, proceed as follows:

Map View and Pattern Analysis
  • click/check on the "$MHI x Tract ACS2019" layer in the Legend Panel.
    .. the map window refreshes to display patterns of median household income by census tract
  • click interval expansion button at left of the "$MHI x Tract ACS2019" layer name in the Legend Panel
    .. to view the color/interval settings
    .. the view should look similar to the following graphic; click graphic for larger view.


Table View and Analytics
  • select the "$MHI x Tract ACS2019" layer in the upper left dropdown, making it the Active Layer.
  • click the Query/Table button below Map Window at far right.
    .. the screen refreshes with with a split view of Map Window and Table.
    .. the table shows a row for each tract.
  • join us in a Tuesday or Thursday web session to learn more about using the table and map.

.. end of tutorials section.

VDA GIS Projects .. goto top
A GIS project is a set of "layers" each associated with a geographic file (an SQLite database in the case of VDA) with an integrated set of subject matter items ("attributes"). With VDA in operation, layers are shown in the legend panel. A GIS project has initial start-up settings that are the codifications for visual Map Window rendering like color assignments, attribute to be rendered, etc. Attributes are fields like geocode, geographic object name, or total population.

VDA has these initial projects available for use. This project list is presented in the Project Manager form presented after login. The list of available projects ("VDA projects") varies over time with new developments such as data availability.

These are projects developed for general use. Users may add and delete layers from these projects and save them for their own use. Users may also create their own GIS projects, eith building on the Base project or uploading a GIS project for their own exclusive use.
Level 2 users may modify existing projects, add/delete layers, and save/delete projects.

  The Situation & Outlook (S&O) project .. main VDA project with wide array of production data.
  This project includes extensive data from multiple sources:
    .. Census 2010
    .. Census 2020
    .. American Community Survey
    .. Model-based estimates
    .. other non-Federal statistical data

This project includes these layers (scroll section):
    .. the S&O project includes these layers (U.S. national scope unless otherwise noted):


States
State Label

Banks - FDIC Insured Bank Locations
Banks 01331 23030 24734 - selected illustrative FDIC Insured Bank Locations

Colleges 2021 - Postsecondary institutions; NCES IPEDS 2021

Primary Roads - primarily interstate roads
CA PriSec Roads - California primary-secondary roads
Los Angeles Cty Roads - Los Angeles County, CA intersection-to-intersection streets/roads

CSA 2020 - national scope Combined Statistical Areas
CBSA/MSA 2020 - Core-Based Statistical Areas (MSAs & MISAs); Census 2020

County Label - County boundaries 2020
County %PopChg 10-20 - County boundaries; thematic pattern; percent change in population, 2010-2020

Places ACS2019 - Census 2010 place boundaries with integrated ACS2019 demographic-economic data
Places 2020 - Census 2020 city/place boundaries

Cong Dist Code - 116th congressional districts code
Cong Dist - 116th congressional districts boundary
Cong Dist Bold - 116th congressional districts boundary (bold)
$MHI x Cong Dist - 116th CD boundaries; thematic pattern; median household income, ACS2019 1 year

PUMA 2010 Code - Census 2010 Public Use Microdata Area (PUMA) boundaries - code
PUMA 2010 - Census 2010 PUMA boundaries
$MHI x PUMA ACS2019 - Census 2010 PUMA boundaries; thematic pattern; median household income, ACS2019 1 year

Congressional Community Code
Cong Community - Congressional Communities boundaries
Cong Community Bold Congressional Communities bold boundaries

Cty SubDiv 2020 - Census County Division boundarie

Tract 2020 Code - Census Tract 2020 Code
%Maj-Min x Tract 2020 - Census Tract 2020 boundary; thematic pattern: Census 2020 %majority-minority population
Tract 2010 Code - Census Tract 2010 code
Tract 2010 - Census Tract 2010 boundary
Tract 2010 LMI 2021 - Census Tract 2010 LMI classification label; Low & Moderate Income
$MHI x Tract ACS2019 - Census Tract 2010 boundary; thematic pattern: median household income

BG 2020 Code - Block Group Census 2020 code as label
BG 2020 - Block Group Census 2020 boundaries
BG 2010 Code - Block Group Census 2010 code as label
BG 2010 ACS2019 - Block Group Census 2010 boundaries

LA Neighborhoods - Los Angeles City neighborboods (L.A. Times)

CA Block 2020 Code - California Census Block 2020 code as label
CA Block 2020 - California Census Block 2020 boundaries

K12 School Name - K-12 public schools; name as label
K12 Schools = K-12 public schools as markers (by school level)

School District Names -
School Districts 2020
School Districts

ZIP Code
ZIP Code Bold
$MHI x ZIP Code
$MHV x ZIP Code
Establishments x ZIP

Country Projections 2050
World by Country
OpenStreetMaps Tiles
States1




  The Base project is comprised of basic layers intended for use by users to augment into their own projects.
    .. all Census 2020 geography except ZIP code layer (includes latest ACS data).
    .. opening view: thematic pattern view shows U.S. by county population percent change, 2010-2020.
        - subject matter available for that county layer is shown in this interactive table
    .. the Base project is also used as a "base" for developing several other projects.
    .. the Base project includes these layers:

States - U.S. by State
Roads - U.S. Primary Roads
CBSA/MSA/Metro - U.S. Core Based Statistical Areas
MSA Name - Metropolitan Statistical Areas
MSA Pop 2020 - MSA Census 2020 population label
Pop %Chg 10-20 x MSA - thematic pattern layer: population Census 2010-2020 % change by MSA
Congressional District - U.S. by congressional district
Congressional Community - U.S. by congressional community
City/Place - U.S. cities/places
County Name - U.S. county name as label
County - U.S. by county boundary
Pop %Chg 10-20 x County - thematic pattern layer: population Census 2010-2020 % change by county
Tract - U.S. census tracts=
Block Group - U.S. block group
School District, Elementary - U.S. elementary school districts
School District, Secondary - U.S. secondary school districts
School District, Unified - U.S. unified school districts
ZIP Code - ACS 2019 U.S. ZIP Code areas with ACS 2019 demographics
Urban Areas - ACS 2019 Urban Areas
World by Country
BaseLayer - OSM Tiling topology
States1 - U.S. lower 48 states



  The Base -- Housing project is comprised of the Base project (above) layers
  with additional layers focused housing and new residential construction.
    .. this project expands on the Base project. The Base -- Housing project:
        - start-up view shows patterns of "CountyBP %BP/100 HU 2020"
            building permits in 2020 as a percent of 100 housing units based on Census 2020.
            this shows the county to county relative pace of new residential construction.

Additional layers compared to Base project:
    .. PlaceBP [month] .. building permits issued by U.S. permit issuing places
        - monthly time series data through most recent month.
    .. CountyBP [month] .. building permits issued by U.S. county, complete county monthly permit issuing
        - monthly time series data through most recent month.
    .. CountyBP %BP/100 HU 2020 .. annual building permits issued; U.S. by county

Illustrative Application using Table/Query
The graphic presented below illustrates use of the "CountyBP" layer in the Base-Housing project to examine annual new authorized residential contruction (total units) for each year 2016 through 2020 by county for Texas. Steps to develop to view are as follows:
  - open the Base-Housing project.
  - select the CountyBP layer as the Active Layer (top left dropdown)
  - click the Table/Query button (below map window at right)
  - enter this code in the SQL Filter:
    select uid, geoid, areaname, units16, units17, units18, units19, units20 where stab='TX'
  - and this code in the SORT edit box:
    units20 desc
  - click the Query button, at right of SORT
  - the following view is presented:

.

Insights: in this state you can see the total units authorized time series sorted on 2020 units.
  clicking the Dallas county area in the map view, the profile panel populates for that area.
  see that the 2020 units (units20) shows the same value as in the table.
  optionally copy to clipboard the profile for further analysis.

See related -- Using the Project Editor with Base-Housing Project.



  The Base -- Majority-Minority project is comprised of Base project layers
  with focus on the majority-minority population by census tract.
    .. all Census 2020 geography except ZIP code layer (includes latest ACS data).
    .. thematic pattern view shows U.S. by county population percent change, 2010-2020.
        - subject matter available for that county layer is shown in this interactive table



  Base -- Majority-Minority - Banks .. project comprised of basic layers intended for use by users to augment into their own projects.
    .. all Census 2020 geography except ZIP code layer (includes latest ACS data).
    .. thematic pattern view shows U.S. by county population percent change, 2010-2020.
        - subject matter available for that county layer is shown in this interactive table



  Census 2020 .. main VDA project with wide array of production data.
  This project includes extensive data from multiple sources:
    .. Census 2010
    .. Census 2020
    .. American Community Survey
    .. Model-based estimates
    .. other non-Federal statistical data

The Census2020 project includes these layers (scroll section):

States
State Label
CSA 2020 - national scope Combined Statistical Areas
CBSAs 2020 - national scope Core-Based Statistical Areas (MSAs & MISAs); Census 2020
County Outline -- national scope U.S. layer useful as "top layer" for many views

.. a set of national scope city/place layers
Cities Name - Census 2010 with integrated demographics
  Table query example: select uid, name, stab where name like 'Santa Clarita%'
Places 2020
Cities Population
Cities

.. a set of California roads/streets layers; add your own using the upload layers feature
CA Roads Name - primary roads name
CA Roads1 - primary roads light
CA Roads2 - primary roads bold
Orange Cty Roads - Orange County intersection-to-intersection detailed roads/streets
Los Angeles Cty Roads - LA County intersection-to-intersection detailed roads/streets

.. "location" layers illustrate how you can add and use point/location data
Locations 06037
Locations 06059

.. national scope congressional district layers
Cong Dist Code
Cong Dist
Cong Dist Bold
$MHI x Cong Dist

.. national scope 2010 Public Use Microdata Area layers
PUMA 2010 Code
PUMA 2010
$MHI x PUMA ACS2019

.. examine congressional communities:
Cong Comm Code
Cong Community
Cong Community Bold

Cty SubDiv 2020 -- census county divisions; administrative subdivisions of counties (towns in New England)

.. these tract layers enable you to compare how census tract boundaries changed from 2010 to 2020.
Tract 2020 Code
Tract 2020
Tract 2010 Code
Tract 2010
Tract 2010 Hispanic
$MHI x Tract ACS2019 -- the most recent "richer demographics"

.. these block group enable you to compare how block group boundaries changed from 2010 to 2020.
BG 2020 Code
BG 2020
BG 2010 Code
BG 2010

.. integrate non-statistical data
LA Neighborhoods -- Los Angeles neighborhoods developed by the Los Angeles Times

.. examine Census 2020 census block data for California (add others using the Upload Layers feature
CA Block 2020 Code
CA Block 2020

.. examine national scope K-12 schools and school districts
K12 School Name
K12 Schools School District Names
School Districts 2020
School Districts

.. national scope metropolitan statistical areas .. see more about CBSAs - the CBSA layer at top of list
Metros/MSAs
Metros/MSA Name
Metros/MSA Population

.. national scope counties
Counties Name
Counties Population
Cty Pop Gain 2010-19
Cty Pop Loss 2010-19
County PCPI
County PCPI

.. national scope ZIP code layers
ZIP Code - ZIP code as a label
ZIP Code Bold - bold boundary useful to highlight ZIP areas when using multiple geographic levels
$MHI x ZIP Code - median household income thematic pattern
$MHV x ZIP Code - median housing value thematic pattern
Establishments x ZIP -- business establishments by ZIP code

.. examine the global situation
Country Projections 2050
World by Country

.. global tiling layer providing views of underlying topology
OpenStreetMaps Tiles

.. this national scope "base layer" serves just that purpose
States1





  Census 2020A .. includes Census 2020 redistricting demographic data to the census block level (California).
    .. national scope shapefiles (SQLite) with integrated Census 2020 data included for:
        - states
        - congressional districts
        - counties
        - cities/places
        - school districts
        - census tracts
        - block groups
    .. click to view start-up
    .. patterns of 2020 Census %Asian population by census tract, zoomed to Orange County, CA
    .. using the project, view other areas and choose different geography & subject matter.
    .. view illustrates clicking a geographic object (congressional community in this example)
        to display demographic profile (lower left Profile panel).
    .. see Census 2020 scope of subject matter/record layout for census tract, BG, block layers

  • Census 2020AZ .. similar to Census 2020A with a zoom-in start-up view (hence "AZ" in name)
    .. uses same shapefiles/SQLite files as Census 2020A project
    .. uses different layer settings
    .. click to view start-up
    .. patterns of 2020 Census %Voting Age population by census block, zoomed further into Orange County, CA
    .. using the project, view other areas and choose different geography & subject matter.
    .. view illustrates clicking a geographic object (census block in this example).
        to display demographic profile (lower left Profile panel).
    .. Profile panel shows attributes of this census block (see pointer in map); click copytoclipboad to save block profile.
        click to view text file profilep for this block (060590626581003)
        see in profile .. Census 2020 total population is 75; optionally paste into spreadsheet.
    .. use Table/Query feature to view, analyze, extract block level data in tabular form.
        a query is used to show blocks (15) in tract 06-059-062658 in grid.
        all fields are displayed in grid; a row for each block in this example.
        the map view can interact with grid. This map view shows zoom-in to tract used above.
    .. see Census 2020 scope of subject matter/record layout for census tract, BG, block layers



  Hawaii .. based on Census 2020A project
    .. about this project
    .. national scope shapefiles (SQLite) with integrated Census 2020 data included for:
    .. differences compared to Census 2020A project:
        - start-up view focused on Honululu County
        - 4 Hawaii census block layers rather than California
        - includes Honolulu detailed roads layer



  Congressional Districts .. based on Census 2020A project.
    .. national scope shapefiles (SQLite) with integrated Census 2020 data included for:
    .. differences compared to Census 2020A project:
        - start-up view focused on lower 49 states
        - 4 Virginia census block layers rather than California
        - additional Congressional Districts layer with integrated ACS 2019 1 year estimates
        - includes Fairfax County, VA detailed roads layer



Tract S&O Layer: Subject Matter Items & Use .. goto top
The Tract S&O Layer is a U.S. national scope Census 2010 census tracts layer with approximatey 235 subject matter items selected from the 2019 ACS statistical program. This layer is available in the S&O project (named $MHI x Tract S&O in the VDA legend). Subject matter items included in this layer are listed below.

This section is focused on using this layer with the VDA Query/Table operations.
Access this section (being presently viewed) via this link:
http://proximityone.com/vda.htm#tracts_sao

These data are a part of the census tract demographic estimates and projections to 2026.
Learn more about how neighborhood level demographic-economic conditions might change.
See tract estimates and projections for details.

Create your own VDA interactive table using this layer
Using the S&O project ...
1. Select the "$MHI x Tract S&O" (top left dropdown) making it the active layer.
2. Click the "Query/Table" button at right below map window. Table then displays below window.
3. Enter the value 100000 in the "max" edit box below grid.
After step 2, the view appears as shown below; here are a few orienteering notes:
.. the selected/active layer is shown in the upper left edit box.
.. the attributes of this layer are shown in the table/grid below the map window.
.. there is a row for each tract in the U.S.
.. the name field has been expanded (drag field name separator) in table header.
.. the first row in the table has been clicked, making it the selected tract, coloring it blue.
.. the button "click geography in row to display" is clicked, resulting in:
  - the profile panel (lower left) shows attributes of this tract.
  - the map window refreshes with a zoom to this tract.


Application examples featuring E062 - median household income
The item "E062" is median household income (see in table below). Use any combination of items,

App 1. E062 is "top-coded" with the value $250,000. How many tracts are top-coded? What/where are the tracts?
Enter the following text in the SQL Filter edit box then click the query button:
select geoid,name,e062 where e062>=250000
The grid refreshes showing the tracts that meet the query criteria (e062>=250000) :
There are 114 tracts that meet this query; see in edit box below table.

Continuing with App 1, click "Highlight all that meet query" button below table.
The following view appears where the map is refreshed with zoom to to first tract in table

Optionally click zoom-out button 2-3 times to see that all tracts in the table are mapped/highlighted.
.. caution clicking on the map to avoid an unwanted highlighting of that tract.

App 2. Show a list of tracts that have $MHI (E062) between $248,000 and $250,000 in California
This query shows how to narrow a search based on more "where" criteria.
Enter the following text in the SQL Filter edit box then click the query button:
select geoid,name,e062 where e062>248000 and e062<250000 and geoid like '06%'
The grid refreshes with a view of 4 tracts.

App 3. Using "Select Field" feature to Select Items for Grid Display
This layer has more than 235 items. Select items to be displayed in the gridi
Click the Select Field button below the Table/Grid.
.. the Select Field form appears .. click checkbox on a few items and click "Set and Close" button.

The grid display refreshes showing the selected items.

Use the "Select Field" to view the metadata - descriptions for each attribute.
.. not fully populated with description column in all layers.

Tract S&O Layer Subject Matter Items (scroll section)
Use the ItemName in VDA applications.
ItemName           Description
  GEOID   Tract Geographic Code (Char 11 -- SSCCCTTTTTT)
  NAME   Tract Name (includes county name and state USPS abbreviation)
  D001   Total Population
  D002   Male
  D003   Female
  D005   Under 5 years
  D006   5 to 9 years
  D007   10 to 14 years
  D008   15 to 19 years
  D009   20 to 24 years
  D010   25 to 34 years
  D011   35 to 44 years
  D012   45 to 54 years
  D013   55 to 59 years
  D014   60 to 64 years
  D015   65 to 74 years
  D016   75 to 84 years
  D017   85 years and over
  D018   Median age (years)
  D019   Under 18 years
  D021   18 years and over
  D022   21 years and over
  D023   62 years and over
  D024   65 years and over
            Race/Origin
  D036   One Race
  D037   One Race -- White
  D038   One Race -- Black or African American
  D039   One Race -- American Indian and Alaska Native
  D044   One Race -- Asian
  D052   One Race -- Native Hawaiian and Other Pacific Islander
  D057   One Race -- Some other race
  D058   Two or more races
  D071   Hispanic or Latino (of any race)
  D072   Hispanic or Latino (of any race) -- Mexican
  D077   Not Hispanic or Latino -- White Alone
  D078   Not Hispanic or Latino -- Black or African American Alone
  D087   Citizen, 18 and over
            Housshold characteristics
  S001   Total Households
  S002   Total Households -- Family Households (Married-couple family)
  S016   Average household size
  S017   Average family size
  S018   Population in households
            School Enrollment
  S053   School Enrollment -- Population 3 Years and Over Enrolled in School
  S054   School Enrollment -- Population 3 Years and Over Enrolled in School -- Nursery school, preschool
  S055   School Enrollment -- Population 3 Years and Over Enrolled in School -- Kindergarten
  S056   School Enrollment -- Population 3 Years and Over Enrolled in School -- Elementary school (grades 1-8)
  S057   School Enrollment -- Population 3 Years and Over Enrolled in School -- High school (grades 9-12)
  S058   School Enrollment -- Population 3 Years and Over Enrolled in School -- College or graduate school
            Educational attainment
  S059   Educational Attainment -- population 25 years and over
  S060   Educational Attainment -- population 25 years and over -- Less than 9th trade
  S061   Educational Attainment -- population 25 years and over -- 9th to 12th grade, no diploma
  S062   Educational Attainment -- population 25 years and over -- High school graduate (includes equivalency)
  S063   Educational Attainment -- population 25 years and over -- Some College, No Degree
  S064   Educational Attainment -- population 25 years and over -- Associate's Degree
  S065   Educational Attainment -- population 25 years and over -- Bachelor's Degree
  S066   Educational Attainment -- population 25 years and over -- Graduate or Professional
  S067   Educational Attainment -- population 25 years and over -- High school graduate or higher
  S068   Educational Attainment -- population 25 years and over -- Bachelor's degree or higher
            Mobility/Migration
  S079   Residence 1 Year Ago -- Population 1 year and over
  S080   Residence 1 Year Ago -- Same House
  S081   Residence 1 Year Ago -- Different House in the U.S.
  S082   Residence 1 Year Ago -- Different House in the U.S. -- Same County
  S083   Residence 1 Year Ago -- Different House in the U.S. -- Different County
  S084   Residence 1 Year Ago -- Different House in the U.S. -- Different County -- Same State
  S085   Residence 1 Year Ago -- Different House in the U.S. -- Different County -- Different state
  S086   Residence 1 Year Ago -- Abroad
  S088   Place of Birth -- Native
  S089   Place of Birth -- Native -- Born in U.S.
  S090   Place of Birth -- Native -- Born in U.S. -- State of Residence
  S091   Place of Birth -- Native -- Born in U.S. -- Different State
  S092   Place of Birth -- Native -- Born in Puerto Rico, U.S. Island Areas, or Born Abroad
  S093   Place of Birth -- Foreign Born
  S094   U.S. Citizenship Status -- Foreign-Born Population
  S095   U.S. Citizenship Status -- Foreign-Born Population -- Naturalized U.S. Citizen
  S096   U.S. Citizenship Status -- Foreign-Born Population -- Not a U.S. Citizen
            Language spoken at home
  S111   Language Spoken at Home -- Population 5 Years and Over
  S112   Language Spoken at Home -- Population 5 Years and Over -- English Only
  S113   Language Spoken at Home -- Population 5 Years and Over -- Language Other Than English
  S114   Language Spoken at Home -- Population 5 Years and Over -- Language Other Than English - less than very well
  S115   Language Spoken at Home -- Population 5 Years and Over -- Language Other Than English - Spanish
  S116   Language Spoken at Home -- Population 5 Years and Over -- Language Other Than English - Spanish, less than very well
  S151   Computers and Internet Use -- Total Households
  S152   Computers and Internet Use -- Households with a Computer
  S153   Computers and Internet Use -- Households with a broadband Internet subscription
            Employment status
  E001   Employment Status -- Population 16 years & over
  E002   Employment Status -- Population 16 years & over -- in Labor Force
  E003   Employment Status -- Population 16 years & over -- Civilian Labor Force
  E004   Employment Status -- Population 16 years & over -- Employed
  E005   Employment Status -- Population 16 years & over -- Unemployed
  E006   Employment Status -- Population 16 years & over -- Armed Forces
  E007   Employment Status -- Population 16 years & over -- Not in Labor Force
  E009   Employment Status -- Population 16 years & over -- Percent Unemployed
            Employment by industry
  E032   Industry -- Civilian Employed Population 16 years & over
  E033   Industry -- Civilian Employed Population 16 years & over -- Agriculture, Forestr
  E034   Industry -- Civilian Employed Population 16 years & over -- Construction
  E035   Industry -- Civilian Employed Population 16 years & over -- Manufacturing
  E036   Industry -- Civilian Employed Population 16 years & over -- Wholesale Trade
  E037   Industry -- Civilian Employed Population 16 years & over -- Retail Trade
  E038   Industry -- Civilian Employed Population 16 years & over -- Transportation and warehousing, and utilities
  E039   Industry -- Civilian Employed Population 16 years & over -- Information
  E040   Industry -- Civilian Employed Population 16 years & over -- Finance & insurance, & real estate & rental & leasing
  E041   Industry -- Civilian Employed Population 16 years & over -- Professional, scientific & mgmt, & admin & waste mgmt svc
  E042   Industry -- Civilian Employed Population 16 years & over -- Educational Services
  E043   Industry -- Civilian Employed Population 16 years & over -- Arts, Entertainment
  E044   Industry -- Civilian Employed Population 16 years & over -- Other Services
  E045   Industry -- Civilian Employed Population 16 years & over -- Public Administration
  E046   Class of Worker -- Civilian Employed Population 16 years & over
  E047   Class of Worker -- Civilian Employed Population 16 years & over -- Private Wage & Salary
  E048   Class of Worker -- Civilian Employed Population 16 years & over -- Government Workers
  E049   Class of Worker -- Civilian Employed Population 16 years & over -- Self-Employed
  E050   Class of Worker -- Civilian Employed Population 16 years & over -- Unpaid Family
            Income & Benefits
  E051   Income and Benefits -- Total Households
  E052   Income and Benefits -- Households -- Less Than $10,000
  E053   Income and Benefits -- Households -- $10,000 to $14,999
  E054   Income and Benefits -- Households -- $15,000 to $24,999
  E055   Income and Benefits -- Households -- $25,000 to $34,999
  E056   Income and Benefits -- Households -- $35,000 to $49,999
  E057   Income and Benefits -- Households -- $50,000 to $74,999
  E058   Income and Benefits -- Households -- $75,000 to $99,999
  E059   Income and Benefits -- Households -- $100,000 to $149,999
  E060   Income and Benefits -- Households -- $150,000 to $199,999
  E061   Income and Benefits -- Households -- $200,000 or More
  E062   Income and Benefits -- Households -- Median Household Income (Dollars)
  E063   Income and Benefits -- Households -- Mean Household Income (Dollars)
  E064   Income and Benefits -- Households -- with Earnings
  E065   Income and Benefits -- Households -- with Earnings -- Mean Earnings (Dollars)
  E066   Income and Benefits -- Households -- with Social Security
  E067   Income and Benefits -- Households -- with Social Security -- Mean Social Security Income ($)
  E068   Income and Benefits -- Households -- with Retirement Income
  E069   Income and Benefits -- Households -- with Retirement Income -- Mean Retirement Income ($)
  E070   Income and Benefits -- Households -- with Supplemental Security Income
  E071   Income and Benefits -- Households -- with Supplemental Security Income -- Mean Supplemental Security Income ($)
  E072   Income and Benefits -- Households -- with Cash Public Assistance Income
  E073   Income and Benefits -- Households -- with Cash Public Assistance Income -- Mean cash public assistance income ($)
  E074   Income and Benefits -- Households -- with Food Stamp/Snap Benefits in the Past 12 months
  E075   Income and Benefits -- Families
  E076   Income and Benefits -- Families -- Less Than $10,000
  E077   Income and Benefits -- Families -- $10,000 to $14,999
  E078   Income and Benefits -- Families -- $15,000 to $24,999
  E079   Income and Benefits -- Families -- $25,000 to $34,999
  E080   Income and Benefits -- Families -- $35,000 to $49,999
  E081   Income and Benefits -- Families -- $50,000 to $74,999
  E082   Income and Benefits -- Families -- $75,000 to $99,999
  E083   Income and Benefits -- Families -- $100,000 to $149,999
  E084   Income and Benefits -- Families -- $150,000 to $199,999
  E085   Income and Benefits -- Families -- $200,000 or More
  E086   Income and Benefits -- Families -- Median Family Income (Dollars)
  E087   Income and Benefits -- Families -- Mean Family Income (Dollars)
  E088   Income and Benefits -- per Capita Income (Dollars)
  E089   Nonfamily households
  E090   Income and Benefits -- Median Nonfamily Income (Dollars)
  E091   Income and Benefits -- Mean Nonfamily Income (Dollars)
  E092   Income and Benefits -- Median Earnings for Workers (Dollars)
  E093   Income and Benefits -- Median Earnings for Male Full-Time, Year-Round Workers ($)
  E094   Income and Benefits -- Median Earnings for Female Full-Time, Year-Round Workers ($)
            Health insurance
  E095   Health Insurance Coverage -- .. Civilian Noninstitutionalized Population
  E096   Health Insurance Coverage -- .... with Health Insurance Coverage
  E097   Health Insurance Coverage -- ...... with Private Health Insurance Coverage
  E098   Health Insurance Coverage -- ...... with Public Health Coverage
  E099   Health Insurance Coverage -- .... No Health Insurance Coverage
            Housing characteristics
  H001   Total Housing Units
  H002   Occupied Housing Units
  H003   Vacant Housing Units
  H004   Homeowner Vacancy Rate
  H005   Rental Vacancy Rate
  H007   Units in Structure -- 1-Unit, Detached
  H008   Units in Structure -- 1-Unit, Attached
  H009   Units in Structure -- 2 Units
  H010   Units in Structure -- 3 or4 Units
  H011   Units in Structure -- 5 to 9 Units
  H012   Units in Structure -- 10 to 19 Units
  H013   Units in Structure -- 20 or More Units
  H014   Units in Structure -- Mobile Home
  H015   Units in Structure -- Boat, Rv, Van, Etc.
  H017   Year Built -- 2014 or later
  H018   Year Built -- 2010 to 2013
  H019   Year Built -- 2000 to 2009
  H020   Year Built -- 1990 to 1999
  H021   Year Built -- 1980 to 1989
  H022   Year Built -- 1970 to 1979
  H023   Year Built -- 1960 to 1969
  H024   Year Built -- 1950 to 1959
  H025   Year Built -- 1940 to 1949
  H026   Year Built -- 1939 orEarlier
  H037   Rooms -- Median Rooms
  H046   Tenure -- Owner-Occupied
  H047   Tenure -- Renter-Occupied
  H048   Average Household Size of Owner-Occupied Unit
  H049   Average Household Size of Renter-Occupied Unit
  H051   Year Householder Moved into Unit -- 2017 or later
  H052   Year Householder Moved into Unit -- 2015 to 2016
  H053   Year Householder Moved into Unit -- 2010 to 2014
  H054   Year Householder Moved into Unit -- 2000 to 2009
  H055   Year Householder Moved into Unit -- 1990 to 1999
  H056   Year Householder Moved into Unit -- 1989 or earlier
  H058   Vehicles Available -- No Vehicles Available
  H059   Vehicles Available -- 1 Vehicle Available
  H060   Vehicles Available -- 2 Vehicles Available
  H061   Vehicles Available -- 3 or More Vehicles Available
  H063   House Heating Fuel -- Utility Gas
  H064   House Heating Fuel -- Bottled, Tank, or LP Gas
  H065   House Heating Fuel -- Electricity
  H066   House Heating Fuel -- Fuel Oil, Kerosene, Etc.
  H067   House Heating Fuel -- Coal orCoke
  H068   House Heating Fuel -- Wood
  H069   House Heating Fuel -- Solar Energy
  H077   Occupants per Room -- 1.00 or Less
  H078   Occupants per Room -- 1.01 to 1.50
  H079   Occupants per Room -- 1.51 or More
            Housing value
  H081   Value -- Less than $50,000
  H082   Value -- $50,000 to $99,999
  H083   Value -- $100,000 to $149,999
  H084   Value -- $150,000 to $199,999
  H085   Value -- $200,000 to $299,999
  H086   Value -- $300,000 to $499,999
  H087   Value -- $500,000 to $999,999
  H088   Value -- $1,000,000 or More
  H089   Value -- Median (Dollars)
  H090   Owner-Occupied Units
  H091   Mortgage Status -- Housing Units with a Mortgage
  H092   Mortgage Status -- Housing Units Without a Mortgage
  H126   Occupied Units Paying Rent
  H127   Gross Rent -- Less than $500
  H128   Gross Rent -- $500 to $999
  H129   Gross Rent -- $1,000 to $1,499
  H130   Gross Rent -- $1,500 to $1,999
  H131   Gross Rent -- $2,000 to $2,499
  H132   Gross Rent -- $2,500 to $2,999
  H133   Gross Rent -- $3,000 or More
  H134   Gross Rent -- Median ($)
  H135   Gross Rent -- No Rent Paid
  H136   Occupied units paying rent (excluding units where GRAPI cannot be computed)
  H137   Gross Rent as a Percentage of Household Income (GRAPI) -- Less Than 15.0 Percent
  H138   Gross Rent as a Percentage of Household Income (GRAPI) -- 15.0 to 19.9 Percent
  H139   Gross Rent as a Percentage of Household Income (GRAPI) -- 20.0 to 24.9 Percent
  H140   Gross Rent as a Percentage of Household Income (GRAPI) -- 25.0 to 29.9 Percent
  H141   Gross Rent as a Percentage of Household Income (GRAPI) -- 30.0 to 34.9 Percent
  H142   Gross Rent as a Percentage of Household Income (GRAPI) -- 35.0 Percent or More

Subscription & Levels .. goto top
There are three levels VDA operation.
  • Level 1 -- no cost, no account, just signup and start using VDA (10-minute limit per session)
  • Level 2 -- fee-based, no 10 minute time-out
    .. availablility of selected features not available to Level 1.
        - Tools>GeoSelect/SiteAnalysis
        - Tools>Find Address/GeoCoding
        - File>SaveProject
        - File>SaveProjectAs
        - File>Upload Layer
        - File>Delete Layer
    .. access to selected projects not available to Level 1.
    .. existing version with updates through 2021, then periodic updates.
        - includes Census 2020 PL94-171 data to block level.
    .. support: Web documentation (this page) & weekly user Web sessions.

    .. Level 2 single user monthly subscription -- $395 -- $290 setup fee; $95 monthly
    .. Level 2 single user annual subscription -- $995 -- setup fee included; includes CV XE GIS Windows desktop

  • Level 3 -- features of Level 2 augmented
    .. availablility of selected features not available to Level 1 or 2.
        - Project Editor
    .. this is a Census 2020 and ACS delivery platform, integrating with other data.
    .. ability to create, modify and upload GIS projects (add to your "available projects" list)
    .. one hour connect time per month per user (5 cumulative hours).
    .. access to the continuously (weekly) updated augmented "Census 2020" project.
        - includes access to most Census 2020 and ACS 2020 data, updated on an as released basis.
        - this project, project suite, includes multi-sourced data, not only Census sourced data.
        - quarterly updates on BLS QCEW data, other BLS data, BEA REIS local area data, other BEA data, yet other.
    .. VDA Desktop single user license
    .. DEDE single user license
    .. optional availability of other proprietary data.
    .. availability of selected features like Project Editor
    .. ability to selectively download data
    .. support: e-mail & telephone plus Web documentation (this page) & weekly user Web sessions.

  • Level 3 for Universities -- use the special licensing terms for departments, campuses or university-wide settings.
    .. similar to standard Level 3 features except the number of seats and connect time are increased.
    .. College/university students, faculty/staff can use VDA at no cost to you as an individual
        when your university has a University license.

  • Credits & How They Work
    .. One credit is one hour of connect time.
    .. Minutes toward a credit are accumulated from log on until log off.
    .. Monthly Level 2 subscribers receive 1 credit/usage hour per month
    .. Annual Level 2 subscribers receive 2 credit/usage hours per month
    .. Allocation of credits expires at end of month without carry over

    .. Level 3 subscribers receive 2 credits per user per month for each of up to 5 users
        - up to 10 hours total, not sharable between users
        - allocation of credits expires at end of month without carry over

    .. Level 2 subscribers may purchase credits in 5 credit blocks
        - the fee for one 5 credit block is $195
        - purchased credit blocks expire at the end of monthly or annual term
    .. Level 3 subscribers may purchase credits in 5 credit blocks per user
        - the fee for one 5 credit block for each of up to 5 users is $495 (total)
        - 25 hours total, 5 hour block not sharable between users
        - purchased credit blocks expire at the end of annual term

Using this Document .. goto top
This web section is designed for device independent usage with the same content for any device. Use the menu to navigate this document. For desktops, the menu appears in the left panel. For phone and tablet devices, the menu is shown by the "hamburger" icon in the upper left of the window. Landscape viewing is recommended for smaller display devices.

VDA will operate with most browsers and there is nothing to install. For the best experience, it is recommended that VDA be used with a larger display device and Windows-based desktop computer.

Terms of Use .. goto top
There is no warranty of any type regarding any aspect of VDA Web GIS. The user is solely responsible for any aspect of using VDA Web GIS. Content developed using VDA Web GIS should reference the source as "VDA Web GIS https://vdagis.com". This document is intended for the sole use by VDA users and prospective users.

User Interface .. goto top
Overall VDA Window
Components of the overall VDA window are described below.
The overall window can be viewed as full screen or resized (drag corner) to meet special needs.

User Interface - Map Window .. goto top
The Map Window occupies most of the User Interface.
As the User Interface is dragged, enlarged, the Map Window expands accordingly.
Operations
  • Create a zoom-in or zoom-out view by mouse down, drag, release.
    .. lower right to upper left to zoom out.
    .. upper left to lower right to zoom in.
  • Pan/Drag map view: Shift key+mouse down and drag then release.
  • Click on a geographic object in the Map Window to display attributes for that item.
    .. the geographic object is determined by the Active Layer (set using Select Layer) at top left of UI.
    .. the selected geographic object appears cross-hatched.
    .. a profile is displayed in the Profile Panel (see below).

User Interface - Main Menu Bar .. goto top
The Main Menu Bar is located at the top of the User Interface (UI).
The File option enables the user to select a different project or save the current rendering of the Active Project.
The Help open provides access to a wide range of related information.

  • File operations
    .. Back to Select Project
    .. Save Project .. Level 2 feature
    .. Save ProjectAs .. Level 2 feature
    .. Upload Layer .. Level 2 feature
    .. Delete Layer .. Level 2 feature
    .. Logoff
  • Tool operations
    .. GeoSelect
    .. Find Address/GeoCoding
  • Help operations

User Interface - Find Geography Bar .. goto top
The Find Geography toolbar is located above the Map Window.
  • Find ZIP Code
    .. enter a ZIP code; e.g.; 91780, click query button and the Map Window refreshes.
    .. the Map Window refreshes with a zoom to 91780 ZIP polygon and shows ZIP code area with hatch pattern.

  • Find County
    .. enter a 5-character state-County FIPS code; e.g.; 06019, click query button.
    .. the Map Window refreshes with a zoom to Fresno County, CA and shows county area with hatch pattern.
    .. find State-County FIPS code using this list.

User Interface - Select Active Layer .. goto top
Select the Active Layer by using the top-left drop-down box.
The default layer is top-most layer shown in the legend panel.
1) The Active Layer is the layer selected for use in clicking on an object in the Map Window.
    .. when an object is clicked in the Map Window, the attributes of that object are displayed in the Profile Panel
2) The Active layer is the layer selected for use in the Table/Query operations.

User Interface - Legend Panel .. goto top
The Legend Panel is shown to the left of the Map Window.
The Legend Panel provides a list of all layers in the Active GIS Project.
To make a layer visible in the Map Window, click the checkbox on.
To make a layer invisible in the Map Window, click the checkbox off.
To show intervals/sections that are defined as visible for a layer, check the leftmost toggle for the layer.
To hide/collapse intervals/sections that are defined as visible for a layer, uncheck the leftmost toggle for the layer.

User Interface - Profile Panel .. goto top
The Profile Panel is shown below the Legend Panel.
It shows attributes/fields and their values for items in the Active Layer for an object clicked in the Map Window.
Contents of the Profile Panel may be copied to clipboard by clicking the Copy to Clipboard button below the Panel.
Once in clipboard, it may be pasted (Ctrl-V) to an external application such as a spreadsheet program or text editor.

User Interface - Button Operations .. goto top
Button Operations are shown below the Map Window
  • Free Select -- frees elected objects
  • Remove Crosshatch -- removes cross-hatch
  • Zoom-in -- click to incrementally zoom in
  • Zoom-out -- click to incrementally zoom out
  • Query/Table On/Off -- toggles Map Window view with Table/Grid view

Navigation & Operations .. goto top

GeoSelect/Site Analysis Feature .. Level 2 feature .. goto top

GeoSelect is used to visually, geospatially select and group geographic objects of the active layer and aggregate their demographic-economic attributes. For example, GeoSelect can be used to select a set of counties or tracts (examples) and automatically aggregate summary items for those areas (or lines/points) and display the data in the Profile Panel.

GeoSelect operates on the Active Layer of a project. The first step is to use a project having a layer that you want to use. Select the Active Layer using the dropdown at top left. Next, position the view in the Map Window in the area for analysis. GeoSelect is then started by clicking the Tools>GeoSelect from the Main Menu bar.


GeoSelect Form
When GeoSelect is started, the GeoSelect form appears:


GeoSelect Operation Options

There are two types of GeoSelect operations described below. The methods should not be mixed. Click the clear button to change the type of operation.

Radius Button Method
.. click the Radius button then click an Active-Layer-object in the Map Window.
.. Active layer object(s) are selected that intersect within a 2.5 km radius from the point clicked.
.. manually change the radius setting to increase/decrease the radius.
.. as successive shapes/objects are selected they show as crosshatched and become part of the Site Area.
.. using this method it is easy to select and add one polygon the Site Area.
.. as shapes/objects are added to the Site Area, the Profile Panel (lower left) is updated
    and displays summary data for the Site Area.
.. optionally use the copy-to-clipboard button below the Profile Panel
    to copy and paste the summary data to a speadsheet, text editor, etc.
.. click the Clear button to start over.

Click 2 Points Button Method
.. with the click 2 points method, the radius is set by clicking two points on the Map Window.
    - clicking the first time sets the center position for a circle.
        a plus marker is shown in the Map Window
    - clicking the second time sets the radius for the circle.
        a second plus marker is shown in the Map Window
    - the circle is shown in the Map Window.

.. as successive shapes/objects are selected they show as crosshatched and become part of the Site Area.
.. using this method it is easy to select and add one polygon the Site Area.
.. as shapes/objects are added to the Site Area, the Profile Panel (lower left) is updated
    and displays summary data for the Site Area.
.. optionally use the copy-to-clipboard button below the Profile Panel
    to copy and paste the summary data to a speadsheet, text editor, etc.
.. click the Clear button to start over.

Using GeoSelect with a County Layer
In this example, the County layer in the "Base -- Majority-Minority Project" is used.
.. the county layer has been selected (top left).
.. GeoSelect is started and the Radius button is clicked.
.. click a point in Madera County; the geocode listbox populates with the Madera geocode.
.. click a second point in Fresno County; The Fresno geocode is added to the set of counties.
.. this process can continue as long as desired.
.. when done, the profile panel (lower left) shows demographic attributes for the aggregate area.
.. the total population in the aggregate area (two counties) is 1.16 million.


Using GeoSelect to Develop/Modify/Examine Bank Assessment/Service Areas .. GeoSelect top .. goto top
The view shown below illustrates how the GeoSelect/Site Analysis feature can be used to develop, modify or examine assessment/service areas by selecting/aggregating Census 2020 census tracts in the vicinity of a bank location (the 7th Street branch).

In this example, the "%Maj-Min x Tract" layer in the "Base -- Majority-Minority Project - Banks" project is used.
.. the map window shows a thematic pattern map of percent majority-majority population by tract.
.. the application is located in the Dallas metro. Click Find County with code 48349 to zoom to Tarrant County, TX
.. the profile panel at the lower left shows the aggregated demographics for the set of selected tracts.
.. the user selects the "%Maj-Min x Tract" layer as the active layer (upper left dropdown).
.. the Tools>GeoSelect is started, the popup form appears.
.. in the GeoSelect form the top left radius value is set small, 0.25 km and Radius button clicked.
.. tracts in the vicinity of the bank location are clicked, progressively.
  - adding each tract geoid to the running list in the GeoSelect form.
  - updating the profile panel with the cumulative demographics for the service area.
.. the process may be stopped or cleared at any time.
.. the cumulative demographics and the list of tract geoids may be copied to clipboard and saved for other use.
.. in this example, 5 tracts have been selected.
  - the total population is 16,217; the White alone, non-Hispanic population is 11,102.


Find Address/Geocoding Feature .. goto top
Several methods of finding and viewing an address location in the Map Window are supported by VDA. The simplest method is to use the Find Address feature above the Map Window. The default value is "405 Hilgard Avenue 90095" -- the address for UCLA. Click Find Address and the location is shown in the Map Window.

Find a Geography and Attributes
Using the Situation & Outlook project, here are some examples ...
Congressional Community
.. make the Congressional Communities layer the Active Layer
.. that is, select that layer name (Congressional Communities) from the upper left dropdown.
.. next click the Find Address button .. finally click the triangle marker in the Map Window.
.. the Congressional Community code (0633012) is shown in the Profile Panel in the lower left.
Census 2020 Census Tract
.. make the Census 2020 layer the Active Layer
.. that is, select that layer name (Tract 2020 Code) from the upper left dropdown.
.. next click the Find Address button .. finally click the triangle marker in the Map Window.
.. the Census 2020 tract code (06037265301) is shown in the Profile Panel in the lower left.
School District 2020
.. make the School District 2020 layer the Active Layer
.. that is, select that layer name (School District 2020) from the upper left dropdown.
.. next click the Find Address button .. finally click the triangle marker in the Map Window.
.. the 2020 School District code (0622710) is shown in the Profile Panel in the lower left.

This method is similar to the Find Address Option 1 described below.

Additional Find Address Operations
Examining locale attributes for a Amazon Bosch TV series residential filming location:
Using Find Address Blog Post

The Find Address feature determines location attributes of an address entered by the user and shows the address location as a marker in the Map Window. The Find Address feature can return the latitude-longitude for the address and the Census block code (both 2010 and 2020 block codes). With the block code, the state, county and tract codes are also determined. The Find Address feature is started by selecting Tools>Find Address from the Main Menu toolbar.


Benefits of Using Find Address. Why not just use Google Maps, or similar Web-based tools, to find an address? Those methods show the address as a marker on a map. However, the map view presented by those methods do not enable the user to view/analyze related statistical/political geography. With VDA, you choose the layers that you want to associate with addresses. With VDA you can click that layer object (e.g., a census block) and view/access the related demographic-economic profile.

You might know the address but not the census block or census tract code or congressional community. Why not just use the Ceneus Geocoder? One, the Census geocoder has only an approximate 75 percent hit rate. 25 percent of existing addresses might not be matchable. That is because the Census geocoder uses TIGER which does not have comprehensive street segment coding. Many street names or address ranges are missing. Another limitation of the Census Geocoder is that it returns the codes, but the location is not shown in a map; there is no direct way to link the geography with the demographics. With VDA, you choose the layers (geography and demographic-economic attributes) that you want to associate with addresses.

Other Find Address methods may not be able to relate the address to many types of geographic areas, like congressional communities or your customer service areas. See Find Address examples below.

Find Address Illustrative View. An illustrative view of using Find Address Option 3:
When Find Address option 3 is used, the blue marker is displayed as shown in the map view.
- in this example, the Census 2020 block code layer is showing;
- it shows the same block code as a label in the block polygon as returned using Find Address.
- the profile panel shows the profile of the TIGER line segment matched to the address.
- the TIGER Line ID in the profile is the same as returned by the Find Address operation.


Find Address Options. There are three types of Find Address options:
  • Option 1 - Basic, most accurate in general
  • Option 2 - 2010 block code with match score
  • Option 3 - 2020 block code Census TIGER based, overall 75% hit rate

After selecting a Find Address option, a Find Address form is shown as a pop-up in the upper right of the overall window. All three options operate similarly, each requiring an address to be entered as shown in the Option 1 graphic below.   - after entering address, click the Go button to locate the address.
    - the default address for all options is 1600 Pennsylvania Ave NW, Washington, DC, 20502
    - the Map Window refreshes with a zoom to the location and shows the location with a blue triangle marker
    - the Find Address form refreshes showing attributes of the location (this varies by option selected)
  - the scale setting provides a way to set the map extent for location viewing.
    - in most instances 1:10000 might be preferred; 1:100000 will provide more of a zoomed-out view.
  - use the clear button to set the default settings.
  - use the close button to end the operation.

Find Address Option 1 - Basic, most accurate in general

This option:
  - works with global addresses.
  - provides most address specification flexibility; "White House" returns the same result as the default address.
  - returns only the latitude-longitude on the form.
  - enables to user to find a location by entering a latitude-longitude.
    - click Latlon button after entering latitude-longitude in the format shown.

Find Address Option 2 - 2010 block code with match score

This method uses a range of address coders and select the one with best match score.
- it will generally have a higher match score than option 3.
- works with U.S. addresses only.
A structured address is required for this option:
  streeetaddress,city,stusab,ZIP
  - 4 commas are required.
As shown in the graphic above, this option returns:
  - the Census 2010 block code (15 character code).
  - these attributes:
    - LatLon: 38.8976960,-77.0386955
    - MatchScore: 97.1005917159763
    - CensusBlock: 1036
    - CensusTract: 0062.02
    - CensusCountyFips: 001
    - CensusStateFips: 11
A match score above 90 is good; above 95 preferred; a score of 60 means it is matching to ZIP centroid.

Find Address Option 3 - 2020 block code Census TIGER based, overall 75% hit rate

This method uses a range of address coders and select the one with best match score.
- it will generally have a lower hit rate (ability to find address) that option 1 or 2.
- works with U.S. addresses only.
This method is the slowest among all options.
A structured address is required for this option:
  streeetaddress,city,stusab,ZIP
  - 4 commas are required.
As shown in the graphic above, this option returns:
  - the Census 2020 block code (15 character code).
  - these attributes:
LatLon: 38.898754,-77.03535
STATE: 11
COUNTY: 001
TRACT: 980000
BLOCK: 1034
PLACE: Washington city (50000)
INTPTLAT: +38.8970383
INTPTLON: -077.0372535
AREALAND: 144892
AREAWATER: 0
Tigerline ID: 76225813
Tigerline ID: L

Find Address Examples
Example 1. What is the Low and Moderate Income (LMI) status for a census tract containing an address of interest? You might have many addresses where this information is needed. With VDA, you can determine LMI status (where you have the tract layer with LMI coding) for any tract. See your locations on a map with other relevant geography/information. Use our LMI (and related details) for Census 2020 tracts (available December 2021).


Uploading Layers & Integrating Data .. Level 2 feature .. goto top
Add your own shapefile/data to an existing project to view/analyze your data with other existing layers/data. Analytical opportunities are unlimited! Use any existing project to upload layers. With project open, use File>Upload Layer and proceed as illustrated in the following examples.

This section shows how to add 2020 TIGER detailed roads ("edges") for a county.

Los Angeles County, CA is used here as an example. There are 394,798 detailed road segments in Los Angeles County, CA based on the 2020 TIGER edges shapefile. Typically these are intersection to intersection, but often comprised of shorter connected segments.

Step 1. Extract the Los Angeles County, CA (06037) edges shapefile to c:\vdauploads
  .. it is suggested that all VDA upload files be kept in one folder, such as C:\vdauploads, and not contain other files.
Note: get the edges shapefile for any county from this set of links.
.. the counties are organized by state+county FIPS code
.. to use another county, replace 06037 in the following the state+county edges file that is downloaded.

Step 2. Delete all unzipped files in c:\vdauploads except these:
  tl_2020_06037_edges.shp
  tl_2020_06037_edges.shx
  tl_2020_06037_edges.dbf

Step 3. Develop the INI file
Copy the 11 lines below, paste into Notepad (any text editor) and save as c:\vdauploads\tl_2020_06037_edges.shp.ini
.. when uploading a file that has large, detailed objects displayed, set Active=NO
.. otherwise set Active=YES
.. if Active=No, the layer will show as unchecked and not display in the Map Window

Active=NO
Caption=06037 Roads
CodePage=932
CS.EPSG=4269
Ground=OnDem
Label.Alignment=FOLLOW
Label.Color=$10101
Label.Field=FULLNAME
Label.OutlineWidth=2
Query=roadFLG='Y'
Visible=YES
.. the spelling/characters used in file names must match exactly.
.. the Los Angeles County roads (edges) shapefile has state county code 06037

Step 4. Zip (for example using Winzip) these four files to the new file c:\vdauploads\tl_2020_06037_edges.zip

Step 5. With VDA running, use File>Upload Layer from the Main Menu bar to start the upload. The upload form appears:

The above view shows that the user chose the file c:\vdauploads\tl_2020_06037_edges.zip. The final step is to click the "upload and write to project" button. A zip file of this size (~50MB) may require several minutes to complete; wait for a message and do not click upload again

Close the upload form when done. The following view shows the "06037 Roads". To obtain a view similar, click Find ZIP with the ZIP code set to 90068. Then check the "06037 Roads" layer box in legend panel to show streets/roads.


Zoom-in View
The zoom tools could be used to "manually" zoom to an area of interest. Here the Find Address feature is used. The Find Address feature is used to locate, zoom to and place a marker in the map view for the address 7207 Woodrow Wilson Dr, Los Angeles, CA 90068, a filming location used in the the Amazon Bosch TV series as shown in the following graphic.



Notes on Viewing/Using the Street Segments
Proceeding from the above view, a profile of the street segment containing an address of interest is obtained as follows:
.. make the "06037 Roads" layer active.
.. click the street segment by the address location marker.
.. the street segment is selected and highlighted green as ahown in the above graphic.
.. the street segment attributes are shown in the Profile Panel at lower left.
.. note that this address is on/adjacent to TLID (TIGER Line ID) 692806227
    -- a unique ID among all road segments in the U.S.
.. the address range of the left and right side of the road segment ar also shown.
.. see related details about using the TIGER edges files.

Step 6. Optionally save the updated project with existing or as a new name.



This section shows how to upload Census 2020 TIGER census blocks for a county (Fresno County, CA)

Step 1. Extract the Fresno County, CA (06019) tabblock shapefile to c:\vdauploads
  .. it is suggested that all VDA upload files be kept in one folder, such as C:\vdauploads, not containing other files.
Note: get the 2020 census block shapefile for any county from this set of links.
.. the counties are organized by state+county FIPS code
.. to use another county, replace 06059 in the following the state+county blocks file that is downloaded.

Step 2. Delete all unzipped files in c:\vdauploads except these:
  tl_2020_06019_tabblock20.shp
  tl_2020_06019_tabblock20.shx
  tl_2020_06019_tabblock20.dbf

Step 3. Develop the INI file
Copy the 18 lines below, paste into Notepad (any text editor) and save as c:\vdauploads\tl_2020_06019_tabblock20.shp.ini

Active=YES
Area.OutlineWidth=2
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=06019 2020 blocks
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=GEOID20
Label.OutlineWidth=2
Label.Position=MIDDLECENTER
Label.Visible=NO
Name=tl_2020_06019_tabblock20
OutCodePage=1252
Path=tl_2020_06019_tabblock20.shp
Visible=YES
.. the spelling/characters used in file names must match exactly.
.. the Fresno County 2020 census blocks (tabblock20) shapefile has state county code 06019
.. choose a different county such as 11001 (Washington, DC)

Step 4. Zip (for example using Winzip) these four files to the new file c:\vdauploads\tl_2020_06019_tabblock20.zip

Step 5. With VDA running, use File>Upload Layer from the Main Menu bar to start the upload. The upload form appears:

The above view shows that the user chose the file c:\vdauploads\tl_2020_06019_tabblock20.zip
The final step is to click the "upload and write to project" button
.. wait for a message and do not click upload again

Close the upload form when done. The initial view is shown below.


Step 6. Optionally save the updated project with a new name



This section shows how to upload the 2020 TIGER water areas for a county (Orange County, FL)

Step 1. Extract the Orange County, FL (12095) tabblock shapefile to c:\vdauploads
  .. it is suggested that all VDA upload files be kept in one folder, such as C:\vdauploads, that does not contain other files.
Note: get the 2020 water areas shapefile for any county from this set of links.
.. the counties are organized by state+county FIPS code
.. to use another county, replace 06059 in the following the state+county blocks file that is downloaded.

Step 2. Delete all unzipped files in c:\vdauploads except these:
  tl_2020_12095_areawater.shp
  tl_2020_12095_areawater.shx
  tl_2020_12095_areawater.dbf

Step 3. Develop the INI file
Copy the 18 lines below, paste into Notepad (any text editor) and save as c:\vdauploads\tl_2020_12095_areawater.shp.ini

Active=YES
Area.Color=$FF8080
Area.OutlineColor=BLUE
Area.OutlineWidth=2
Area.SmartSize=16
Caption=12095 Warer Areas
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Name=12095 water areas
OutCodePage=1252
Path=tl_2020_12095_areawater.shp
Visible=YES
.. the spelling/characters used in file names must match exactly.

Step 4. Zip (for example using Winzip) these four files to the new file c:\vdauploads\tl_2020_12095_areawater.zip

Step 5. With VDA running, use File>Upload Layer from the Main Menu bar to start the upload. The upload form appears:

The above view shows that the user chose the file c:\vdauploads\tl_2020_12095_areawater.zip
The final step is to click the "upload and write to project" button
.. wait for a message and do not click upload again

Close the upload form when done. The initial view is shown below. This view shows both the linear water and area water layers.


Step 6. Optionally save the updated project with a new name



This section shows how to upload the 2020 TIGER water areas for a county (Orange County, FL)

Step 1. Extract the Orange County, FL (12095) tabblock shapefile to c:\vdauploads
  .. it is suggested that all VDA upload files be kept in one folder, such as C:\vdauploads, that does not contain other files.
Note: get the 2020 linear water shapefile for any county from this set of links.
.. the counties are organized by state+county FIPS code
.. to use another county, replace 06059 in the following the state+county blocks file that is downloaded.

Step 2. Delete all unzipped files in c:\vdauploads except these:
  tl_2020_12095_linearwater.shp
  tl_2020_12095_linearwater.shx
  tl_2020_12095_linearwater.dbf

Step 3. Develop the INI file
Copy the 18 lines below, paste into Notepad (any text editor) and save as c:\vdauploads\tl_2020_12095_linearareawater.shp.ini

Active=YES
Caption=12095 Linear Water
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Line.Color=BLUE
Line.OutlineColor=BLUE
Line.SmartSize=16
Line.Width=2
Name=12095 linearwater
OutCodePage=1252
Path=tl_2020_12095_linearwater.shp
Visible=YES

.. the spelling/characters used in file names must match exactly.

Step 4. Zip (for example using Winzip) these four files to the new file c:\vdauploads\tl_2020_12095_linearwater.zip

Step 5. With VDA running, use File>Upload Layer from the Main Menu bar to start the upload. The upload form appears:

The above view shows that the user chose the file c:\vdauploads\tl_2020_12095_linearwater.zip
The final step is to click the "upload and write to project" button
.. wait for a message and do not click upload again

Close the upload form when done. The initial view is shown below. This view shows both the linear water and area water layers.


Step 6. Optionally save the updated project with a new name



This section shows how to upload the 2020 TIGER VTDs/Precincts for a county (Westchester County, NY)
It is suggested that the Base - Majority-Minority Tracts project be used.

VOTING DISTRICTS
Voting district is the generic name for an area, such as a precinct or ward that is established by state and local governments for purposes of elections. States participating in the 2020 Census Redistricting Data Program provided the Census Bureau with boundaries, codes, and optional names for their voting districts. The voting district code is a six-character field that may contain any ASCII character.
Voting District Indicator
States participating in the 2020 Census Redistricting Data Program have the option to indicate whether the voting district boundaries they submitted to the Census Bureau are "pseudo" or "actual." Pseudo voting districts are those that were approximated. These approximated voting districts are represented in the voting district indicator field as a “P.” Actual voting districts represent ground truth and are represented in this field as an “A.” Actual voting districts are additionally identified by an asterisk (*) appended to the voting district name in the Area Name-Legal/Statistical Area Description (LSAD) Term-Part Indicator. If a state did not provide voting districts for a county, this field is blank.

Step 1. Extract the Westchester County, NY (36119) VTD shapefile to c:\vdauploads
  .. it is suggested that all VDA upload files be kept in one folder, such as C:\vdauploads, that does not contain other files.
Note: get the 2020 VTD shapefile for any county from this set of links.
.. the counties are organized by state+county FIPS code
.. to use another county, replace 36119 in the following the state+county file that is downloaded.

Step 2. Delete all unzipped files in c:\vdauploads except these:
  tl_2020_36119_vtd20.shp
  tl_2020_36119_vtd20.shx
  tl_2020_36119_vtd20.dbf

Step 3. Develop the INI file
Copy the 18 lines below, paste into Notepad (any text editor) and save as c:\vdauploads\tl_2020_36119_vtd20.shp.ini

Active=YES
Area.OutlineColor=$10101
Area.OutlineWidth=30
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=Westchester Cty NY 2020 VTD 
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=VTDST20
Label.OutlineWidth=2
Label.Position=MIDDLECENTER
Name=tl_2020_36119_vtd20
OutCodePage=1252
Path=tl_2020_36119_vtd20.shp
Visible=YES

.. the spelling/characters used in file names must match exactly.

Step 4. Zip (for example using Winzip) these four files to the new file c:\vdauploads\tl_2020_36119_vtd20.zip

Step 5. With VDA running, use File>Upload Layer from the Main Menu bar to start the upload. The upload form appears:

The above view shows that the user chose the file c:\vdauploads\tl_2020_36119_vtd20.zip
The final step is to click the "upload and write to project" button
.. wait for a message and do not click upload again

Close the upload form when done. To obtain a view similar to the one shown below, navigate to Westchester County.
.. in the legend panel at left, uncheck %Maj-Min x Tract layer.
    - uncheck World by Country layer.
    - check on the OpenStreetMaps layer.
.. in top left dropdown, select the Westchester County layer (makes it the active layer).
.. enter the stcty code for Westchester County (36119) in the Find County edit box above the map window.
.. click Find County button.
.. position pointer in cross-hatched VTD in view below & click on that VTD.
    - Profile panel in lower left populates with attributes of this VTD.


Step 6. Optionally save the updated project with a new name



This section shows how to upload the most recent U.S. national scope FDIC Summary of Deposits data for financial institutions and branch locations. Details in this section are a little different that other upload sections.

Use the existing VDA project "Base - Majority-Minority Tracts - Banks" to view/examine bank locations in context of majority-minority tracts. This is an illustrative project; add other banks; use ofther geography/data.

About the data. This project includes all 2021 FDIC banks and banking locations with integrated "summary of deposits" data. The project also includes all/national scope Census 2020 census tracts with associated Census 2020 demographics.

The FDIC bank data used here contains the subject matter described here (xls). Overall features of these data include: 4,941 institutions, 83,991 insured branch offices, $22,877 billion $USD total assets, $18,771 billion $USD total deposits.

The analytical concept behind use of these data is to provide a resource to 1) visually/geographically compare one set of bank locations with others, 2) use SQL queries and dynamically compute values in table/query grid and/or 3) examine a set of banks in context of small area/market demographics. It is recommended that the uploaded shapefile be added to the "base_mmtracts" project. This project includes a 2020 tracts layer with showing patterns of Census 2020 percent majority-minority population.

Step 1. Download the FDIC Banks 2021 upload file to c:\vdauploads
  .. download this file to your computer where it is then uploaded to the VDA server (step 2 below).
  .. this is a dropbox location and requires a password provided separately
  .. when the dropbox screen appears, click the download button (button at far right)
      - download the zip file as one file, not unzipped files.
  .. all VDA upload files should be kept in one folder, such as C:\vdauploads, that does not contain other files.

Step 2. With VDA running, use File>Upload Layer from the Main Menu bar to start the upload. The upload form appears:

The above view shows that the user chose the file c:\vdauploads\fdic2021pts.zip (this is the file downloaded from dropbox).
The final step is to click the "upload and write to project" button
.. wait for a message and do not click upload again

Close the upload form when done. The objective view shown below. Bank locations are included for two banks (California & Texas). See query notes below. An easy way to navigate to the specific banking area is to use the Find County above the map window.
.. use county code 06019 (Fresno County) for Calfornia central valley area.
.. use county code 48113 (Dallas County) for Dallas metro area.
A zoom-out/some navigation is required to see all locations for a bank (black square markers with branch name as label).


Step 4. Optionally view bank branches in table/grid format:


Step 5. Optionally save the updated project with a new name.

Modify Bank Selection

Use your own banks of interest. Find a bank using this search tool.
.. on the bank profile, see the bank "FDIC Cert #"

Modifying the INI file with a different bank/Cert #
The INI file that specifies the start-up values for viewing of this layer is shown below.

Active=YES
Caption=Bank Locations
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Field=namebR
Label.OutlineWidth=2
Legend=Selected Locations
Marker.Color=$10101
Marker.OutlineColor=$10101
Marker.OutlineWidth=2
Marker.ShowLegend=YES
Marker.SmartSize=16
Name=fdic2021pts
OutCodePage=1252
Path=fdic2021pts.shp
Query=CERT='23030'
Visible=YES
This INI specifies that :
.. Label.Field=namebR sets label used for each object (bank locations) as the branch name field.
    - change label by setting label parameter to any field in the dataset.
.. Query=CERT='23030' sets visible objects (bank locations) to those with FDIC certification code as 23030.
    - change bank by setting query setting to any bank cert code.



End of uploading layers section .. goto Upload Layers top .. goto page top

Delete Layer .. Level 2 feature .. goto top
Delete a layer in an existing project

Project Editor .. Level 3 feature .. goto top
The Project File contains configuration data for the project referenced.
.. sometimes referred to as an INI file, it controls the way SQLite files are rendered in the Map Window at startup.
The Project Editor enables the user to modify and save the project file for any existing VDA project.

Examples Shown Below
  • Using Base Project
  • Using Base-Housing Project
  • Using Base-Majority-Minority-Banks Project

Start the Project Editor using the main menu File>Project Editor.
The Project Editor form then appears populated with content of the project file for the currently active project.
Using the "Base" project, the form appears as shown below.


There are two basic steps to using the Project Editor:
.. 1) make changes in Editor text section; 2) Click update button.
As an example, you might want to change the "Caption" of the layer presently shown as "States1" to "StatesBase"
.. see highlighted in above graphics.
You would make that change to that text showing in the Project Editor form, then click "Update Project button. .. the project is saved in a temporary mode and the Legend and Map Window refresh.

If the project appears as desired, use the File>Save to permanently save the project.

Project File
Project File content must adhere to strict rules. One invalid character can render the project unusable.
.. the file contains only text characters.
.. the file has a top section; layers section and possibly layer/intervals section.
    .. top section has overall project attributes.
    .. layers section contains several attribute and their settings for each layer.
    .. layer/interval sections contains "additional" interval settings for layers where applicable.
.. layers are numbered in the layer file. Numbering is sequential and cannot be modified in general,
.. layers are presented in "reverse order" compared to way presented in the Legend Panel.

Project File parameters and their usage will be provided in an updated version of this document.

Project File for the Base Project
[VDAGIS]
BackgroundColor=$ECBEA0
CodePage=1252
CS.EPSG=3785
OutCodePage=1252
VisibleExtent.XMax=-8218044.19628549
VisibleExtent.XMin=-13506981.2436234
VisibleExtent.YMax=6769716.21310892
VisibleExtent.YMin=2436796.94109156

[VDAGIS Layer1]
Active=YES
Area.Color=$EAFFFF
Area.OutlineWidth=2
Area.SmartSize=16
Caption=States1
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Name=cb_2017_us_state48
OutCodePage=1252
Path=cb_2017_us_state48.ttkls
Visible=YES

[VDAGIS Layer2]
Active=YES
Caption=BaseLayer
CodePage=1252
CS.EPSG=3785
CurrentPage=1
IncrementalPaint=YES
Name=tatukgis_osm
OutCodePage=1252
Path=mapquest openstreetmaps tiles.ttkwp
Visible=YES

[VDAGIS Layer3]
Active=NO
Area.Color=$EAFFFF
Area.OutlineColor=SILVER
Area.OutlineWidth=2
Area.SmartSize=16
Caption=World by Country
CodePage=1252
CS.EPSG=4326
Ground=OnDem
IgnoreShapeParams=YES
Name=world_states_provinces
OutCodePage=1252
Path=world_states_provinces.ttkls
Visible=YES

[VDAGIS Layer4]
Active=NO
Area.Color=$97B9FF
Area.OutlineColor=$2068FF
Area.OutlineWidth=2
Area.SmartSize=16
Caption=Urban Areas
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Name=cb_2019_us_ua10_500k.shp17
OutCodePage=1252
Path=cb_2019_us_ua10_500k.ttkls
Transparency=70
Visible=YES

[VDAGIS Layer5]
Active=NO
Area.OutlineColor=$10101
Area.OutlineWidth=2
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=ZIP Code
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=ZCA
Label.OutlineStyle=SOLID
Label.OutlineWidth=0
Label.Position=MIDDLECENTER
Name=cb_2019_us_zcta510_500kzbp1
OutCodePage=1252
Path=cb_2019_us_zcta510_500kzbp.ttkls
Visible=YES

[VDAGIS Layer6]
Active=NO
Area.OutlineColor=$10101
Area.OutlineWidth=2
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=School District, Unified
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=AREANAME
Label.OutlineWidth=2
Label.Position=UPCENTER
Label.Visible=NO
Name=cb_2020_us_unsd_500k1
OutCodePage=1252
Path=cb_2020_us_unsd_500k.ttkls
Visible=YES

[VDAGIS Layer7]
Active=NO
Area.OutlineColor=$10101
Area.OutlineWidth=2
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=School District, Secondary
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=AREANAME
Label.OutlineWidth=2
Label.Position=MIDDLECENTER
Label.Visible=NO
Name=cb_2020_us_scsd_500k1
OutCodePage=1252
Path=cb_2020_us_scsd_500k.ttkls
Visible=YES

[VDAGIS Layer8]
Active=NO
Area.OutlineColor=$10101
Area.OutlineWidth=2
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=School District, Elementary
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=AREANAME
Label.OutlineWidth=2
Label.Position=DOWNCENTER
Label.Visible=NO
Name=cb_2020_us_elsd_500k1
OutCodePage=1252
Path=cb_2020_us_elsd_500k.ttkls
Visible=YES

[VDAGIS Layer9]
Active=NO
Area.OutlineWidth=0
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=Block Group
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=GEOID
Label.OutlineWidth=2
Label.Position=MIDDLECENTER
Label.Visible=NO
Name=cb_2020_bg
OutCodePage=1252
Path=cb_2020_us_bg_500k.ttkls
Visible=YES

[VDAGIS Layer10]
Active=NO
Area.OutlineColor=$10101
Area.OutlineWidth=2
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=Tract
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Name=cb_2020_us_tract_500k1
OutCodePage=1252
Path=cb_2020_us_tract_500k.ttkls
Visible=YES

[VDAGIS Layer11]
Active=YES
Area.Color=$FFA8A8
Area.OutlineColor=$FF7777
Area.OutlineWidth=2
Area.ShowLegend=YES
Area.SmartSize=16
Caption=Pop %Chg 10-20 x County
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Legend=15% or more increase
Name=cb_2020_us_county_500k_10201
OutCodePage=1252
Path=cb_2020_us_county_500k_1020.ttkls
Query=100*(totpop-p008001)/p008001>=15
Visible=YES

[VDAGIS Layer12]
Active=NO
Area.OutlineColor=$A3A3A3
Area.OutlineWidth=10
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=County
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=AREANAME
Label.OutlineWidth=2
Label.Position=MIDDLECENTER
Name=cb_2020_us_county_500ka
OutCodePage=1252
Path=cb_2020_us_county_500k.ttkls
Visible=YES

[VDAGIS Layer13]
Active=NO
Area.OutlineColor=$10101
Area.OutlineWidth=2
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=City/Place
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=AREANAME
Label.OutlineWidth=2
Label.Position=UPCENTER
Name=cb_2020_us_place_500kb
OutCodePage=1252
Path=cb_2020_us_place_500k.ttkls
Visible=YES

[VDAGIS Layer14]
Active=NO
Area.OutlineColor=$404080
Area.OutlineWidth=10
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=Congressional Community
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Name=states_cc_081820
OutCodePage=1252
Path=states_cc_081820.ttkls
Visible=YES

[VDAGIS Layer15]
Active=NO
Area.OutlineColor=$4F9D
Area.OutlineWidth=30
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=Congressional District
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Name=cb_2020_us_cd116_500k2
OutCodePage=1252
Path=cb_2020_us_cd116_500k.ttkls
Visible=YES

[VDAGIS Layer16]
Active=NO
Area.OutlineColor=$10101
Area.OutlineWidth=2
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=MSA Pop 2020
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Field=TOTPOP
Label.OutlineWidth=2
Label.Position=DOWNCENTER
Name=cb_2020_us_cbsa_500k.shp19
OutCodePage=1252
Path=cb_2020_us_cbsa_500k.ttkls
Visible=YES

[VDAGIS Layer17]
Active=NO
Area.OutlineColor=$404080
Area.OutlineWidth=70
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=MSA Name
CodePage=1252
Collapsed=YES
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=CENTER
Label.Color=WHITE
Label.Field=NAME
Label.OutlineWidth=2
Label.Position=UPCENTER
Name=cb_2020_us_cbsa_500k
OutCodePage=1252
Path=cb_2020_us_cbsa_500k.ttkls
Visible=YES

[VDAGIS Layer18]
Active=NO
Area.OutlineColor=$404080
Area.OutlineWidth=30
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=CBSA/MSA/Metro
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Legend=LSAD='M1'
Name=cb_2020_us_cbsa_500ka
OutCodePage=1252
Path=cb_2020_us_cbsa_500k.ttkls
Query=LSAD='M1'
Transparency=80
Visible=YES

[VDAGIS Layer19]
Active=NO
Caption=Roads
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Alignment=FOLLOW
Label.Color=$10101
Label.Field=FULLNAME
Label.OutlineWidth=2
Label.Visible=NO
Line.Color=$9FCFFF
Line.OutlineColor=$10101
Line.OutlineWidth=2
Line.SmartSize=16
Line.Width=2
Name=tl_2020_us_primaryroads
OutCodePage=1252
Path=tl_2020_us_primaryroads.ttkls
Visible=YES

[VDAGIS Layer20]
Active=YES
Area.OutlineColor=$10101
Area.OutlineWidth=16
Area.Pattern=TRANSPARENT
Area.SmartSize=16
Caption=States
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Name=states
OutCodePage=1252
Path=cb_2020_us_state_500k.ttkls
Visible=YES

[VDAGIS Hierarchy]
Other=world_states_provinces;tatukgis_osm;states;cb_2017_us_state48;states_cc_081820;cb_2020_us_cd116_500k2;cb_2020_us_place_500kb;cb_2020_us_cbsa_500ka;tl_2020_us_primaryroads;cb_2019_us_zcta510_500kzbp1;cb_2020_us_unsd_500k1;cb_2020_us_scsd_500k1;cb_2020_us_elsd_500k1;cb_2020_us_tract_500k1;cb_2020_us_county_500k_10201;cb_2020_us_county_500ka;cb_2020_bg;cb_2019_us_ua10_500k.shp17;cb_2020_us_cbsa_500k;cb_2020_us_cbsa_500k.shp19

[VDAGIS Group1]
Active=YES
Caption=Other
CodePage=1252
Name=Other
OutCodePage=1252
Visible=YES

[VDAGIS Layer11 1]
Area.Color=$2FFF97
Area.OutlineColor=$CA65
Ground=OnDem
Legend=5 to 15% increase
Query=100*(totpop-p008001)/p008001>=5 and 100*(totpop-p008001)/p008001<15
Visible=YES

[VDAGIS Layer11 2]
Area.Color=$B7FFFF
Area.OutlineColor=$F2F2
Ground=OnDem
Legend=0 to 5% increase
Query=100*(totpop-p008001)/p008001>=0 and 100*(totpop-p008001)/p008001<5
Visible=YES

[VDAGIS Layer11 3]
Area.Color=$B7CEFF
Area.OutlineColor=$8AB0FF
Ground=OnDem
Legend=-0.01 to -10% decrease
Query=100*(totpop-p008001)/p008001>=-10 and 100*(totpop-p008001)/p008001<0
Visible=YES

[VDAGIS Layer11 4]
Area.Color=$6C6CFF
Area.OutlineColor=$4F4FFF
Ground=OnDem
Legend=More than -10% decrease
Query=100*(totpop-p008001)/p008001<-10
Visible=YES

Using the Project Editor with Base-Housing Project .. goto projecteditor top .. goto top
In this example, the "PlaceBP Aug2021" layer in the "Base-Housing" project is modified. The "PlaceBP Aug2021" portion of the project file is edited to display the August 2021 building permits as a label in the map view. These are monthly permit issuing places in the Dallas, TX metro. This graphic shows the resulting view, places with blue boundary labeled with the number of building permits issued in context of the urban areas (salmon fill pattern). The Dallas city area (crosshatched) is clicked and shows a profile for the place in the Profile Panel (lower left). As shown in the profile and in the map view, there were 136 single family unit permits issued in August 2021.


To develop the above view, the Project Editor is used to modify the settings for the "PlaceBP Aug2021" layer in the "Base-Housing" project. The Editor is started; the portion of the project file relating that layer is shown in the upper portion of the following scroll section (Before).
The edited portion of the project file is shown further down (After). Note that this text section relater to "[VDAGIS Layer14]". The "Before" differs from the "After" by adding the lines/setting highlighted in red to the "After". The above map view displays after the Update button is clicked in the Project Editor form.
Before
[VDAGIS Layer14]
Active=NO
Area.OutlineColor=BLUE
Area.OutlineWidth=2
Area.SmartSize=16
Caption=PlaceBP Aug2021
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Legend=units1+units2+units3+units5>0
Name=cb_2020_us_place_500kbp.shp22
OutCodePage=1252
Path=cb_2020_us_place_500kbp.ttkls
Query=units1+units2+units3+units5>0
Visible=YES

After [VDAGIS Layer14] Active=NO Area.OutlineColor=BLUE Area.OutlineWidth=2 Area.SmartSize=16 Area.Pattern=TRANSPARENT Label.Alignment=CENTER Label.Field=UNITS1 Label.OutlineWidth=2 Label.Position=MIDDLECENTER Caption=PlaceBP Aug2021 CodePage=1252 CS.EPSG=4269 Ground=OnDem IgnoreShapeParams=YES Legend=units1+units2+units3+units5>0 Name=cb_2020_us_place_500kbp.shp22 OutCodePage=1252 Path=cb_2020_us_place_500kbp.ttkls Query=units1+units2+units3+units5>0 Visible=YES


Using the Project Editor with Base-Majority-Minority-Banks Project .. goto projecteditor top .. goto top
In this example, the "Bank Locations FDIC 23474" layer in the "Base-Majority-Minority-Banks" project is modified.
Use your own banks of interest. Find a bank using this search tool.
.. on the bank profile, see the bank "FDIC Cert #"


To develop the above view, the Project Editor is used to modify the settings for the "PlaceBP Aug2021" layer in the "Base-Housing" project. The Editor is started; the portion of the project file relating that layer is shown in the upper portion of the following scroll section (Before).
The edited portion of the project file is shown further down (After). Note that this text section relater to "[VDAGIS Layer14]". The "Before" differs from the "After" by adding the lines/setting highlighted in red to the "After". The above map view displays after the Update button is clicked in the Project Editor form.
Before
[VDAGIS Layer23]
Active=YES
Caption=Bank Locations
CodePage=1252
CS.EPSG=4269
Ground=OnDem
IgnoreShapeParams=YES
Label.Field=NAMEBR
Label.OutlineWidth=2
Legend=FDIC #23474
Marker.Color=BLUE
Marker.OutlineColor=$10101
Marker.OutlineWidth=2
Marker.ShowLegend=YES
Marker.Size=140
Marker.SmartSize=16
Marker.Style=TRIANGLEUP
Name=fdic2021ptsb
OutCodePage=1252
Path=fdic2021pts.ttkls
Query=CERT='23474'
Visible=YES

After [VDAGIS Layer23] Active=YES Caption=Bank Locations CodePage=1252 CS.EPSG=4269 Ground=OnDem IgnoreShapeParams=YES Label.Field=NAMEBR Label.OutlineWidth=2 Legend=FDIC #23474 Marker.Color=BLUE Marker.OutlineColor=$10101 Marker.OutlineWidth=2 Marker.ShowLegend=YES Marker.Size=140 Marker.SmartSize=16 Marker.Style=TRIANGLEUP Name=fdic2021ptsb OutCodePage=1252 Path=fdic2021pts.ttkls Query=CERT='23474' Visible=YES

End of Project Editor section.

Using the Table/Query Operations .. goto top
The Table/Query operations differ from the Find ZIP/Find County navigation tools reviewed above.

The Table/Query feature enables viewing/processing the attribute data for a selected layer in a tabular/grid form.
This feature enables the user to do these things:
  • view all fields of the selected layer in a tabular form.
  • sort tabular data in grid on any column/field.
  • perform a query on tabular data/grid to view only selected rows (geographic objects).
  • click a row in grid to select that item then click "click geography row to display".
    .. Map Window refreshes with zoom to that geography.
  • output data in CSV or other format.

Using Table/Query
  • to start Table/Query, click the Table/Query button below the Map Window at right (see graphic).
  • with the full Map Window displayed, clickin the Table/Query toggle button splits what was the Map Window.
    .. it becomes a split Map Window and Table Grid as shown below.
  • the Table/Query button is a toggle operation; click it again and the grid is removed.

If you are using the "Census 2020" project (or any project where the "States" layer is the top layer), the default overall display will appear as shown here.



Using the Table/Query Query Operations
There are two queries that can be performed on/filter the grid:
  • One Item
    .. set an arithmetic or logical condition on a selected field in Active Layer
    .. field name selected in left dropdown.
    .. logical/arithmetic condition set in center dropdown.
    .. criteria value set in right edit box.
    .. click query button to perform filter operation on grid.
  • VDA SQL
    .. use a combination of fields and conditions based fields in Active Layer
    .. use parentheses and nested conditions.
    .. criteria value set in right edit box.
    .. click query button to perform filter operation on grid.

Refreshing the Table Content
After a query has been performed, only those records meeting the criteria appear in the grid.
To reset/refresh the grid, so that it shows all records/rows, use the query UID > 0
.. The UID is the "unique identifier for current shape/geographic object".
.. The UID appears as the leftmost column in the grid.
The UID is the sequential number of the row in the file. UID > 0 will show all records.

Copying Rows from Grid for External Use
To copy rows from the grid (click on one row or multi-select), right click the blue highlighted area, copying to clipboard. Ctrl-V to paste in an open editor or worksheet in another program/application.
To copy the header/field names,
  .. click an object in the Map Window, the profile appears in the Profile panel.
  .. click the copy to clipboard button below the panel.
  .. Ctrl-V paste into a spreadsheet.
  .. copy the first column cells and paste special>transpose into the first row of the spreadsheet.
  .. from the grid, select the rows of interest and Ctrl-V into cell A2 of the spreadsheet.

Handling Text Fields with Lead-zeroes
Many fields in layers are geography codes with lead zeroes. The lead zeroes need to be retained when pasting into a spreadsheet.
To accomplish this, before proceeding as described above, follow these steps:
  .. select the cells that will hold the data you are going to paste.
  .. display the Home tab of the Excel ribbon.
  .. click the small icon at the lower-right corner of the Number group.
  .. Ctrl-V the rows copied to clipboard from grid.

Example: Using the Table/Query with Congressional Communities
The following graphic illustrates using the Congressional Communities (CC) layer in the "census 2020" project.
  • this view shows a row in the grid for each CC in congressional district "0648" -- California 48.
  • after the query was applied, the number of rows, CCNs, meeting the criteria is shown as 15 below the table.
  • after the query was applied, the row with CCN 0648007 was clicked in grid.
  • next, the "click geography row to display" button below grid was clicked.
    .. the Map Window refreshes with a zoom to that CCN.

Steps to obtain this view, assuming start-up using Census 2020 project:
  • select CC 2010 as selected/Active Layer using top left dropdown.
  • in legend panel click CC 2010 checkbox on
  • click Table/Query toggle button.
  • set basic query CCN (the field to match on), begin (indicates first few characters in criteria must match), 0648 (no quotes).
  • click query button.
  • to zoom to a selected CCN, click that row in the grid.



GIS Projects & Project Management .. goto top
The following summarizes basic procedures to upload a CV XE GIS project for use with the VDA3 Web GIS. These steps make use of the "base.gis" project included with CV XE GIS installer. It is recommended that users follows these steps, actually using the base.gis project for first time upload. As described elsewhere, the purpose/role of the base.gis project is to provide a "basic" starter project that users can easily build on by adding their own shapefiles/layers. Those topics are reviewed in the CV XE GIS user guide. This procedure requires CV XE GIS Level 1 or higher. The steps below should be followed exactly.

On the computer where CV XE GIS is installed ...
1. Create a new folder: c:\gisbase
2. With CV XE GIS running, use File>Open>Dialog and open c:\cvxe\1\base.gis
3. Use File>Package GIS Project .. on form that appears
3.1. set the edit box value to "c:\gisbase\base.zip" (no quotes)
3.2. click "ZIP to" button and wait for confirming reply (less than a minute)
3.3. CV XE GIS can be optionally closed.
4. unzip "c:\gisbase\base.zip" (no quotes) to "c:\gisbase\" (no quotes)
4.1. verify the files are in "c:\gisbase\" (no quotes) and not in a subfolder.
4.2. make the folder "c:\gisbase\out"
5. run the utility tcSHP2SQLITE.exe from the command prompt (included with CV XE GIS installer)
5.1. run c:\cvxe\tcSHP2SQLITE.exe. In the form that appears:
5.2. enter "c:\gisbase" in the "from" edit box.
5.3. enter "c:\gisbase\out" in the "to" edit box.
5.4. click the convert button, wait for notification, close that application.
5.4.1. close the tcSHP2SQLITE program.
6. copy "c:\gisbase\base.gis" to c:\gisbase\out
7. copy "c:\gisbase\mapquest openstreetmaps tiles.ttkwp" to c:\gisbase\out

Ready for upload ...
1. Start VDA3 and login.
2. After login, use the section "Register a Project"
3. Click the Choose File button
3.1. Select the file "c:\gisbase\out\base.gis" (no quotes)
4. Enter a Project Code value
5. Enter a Project Name value
6. Click the upload and register
7. The project name now shows as available. Select it and click Select button to open.

Examining Metro-Urban Area Characteristics .. goto top
Metropolitan Statistical Areas (MSAs) and corresponding Urbanized Areas are both areas having 50,000 or more population. There is always one or more Urbanized Area(s) intersecting with an MSA. They relate in important ways, overlap and are defined in different ways. An MSA is a set of contiguous counties. A Census 2010 Urbanized Area (UA) has 50,000 or more people and an Urban Cluster (UC) must have at least 2,500 and less than 50,000 people. Urban areas are comprised of a set of census blocks.

The VDA "Base" project provides a layer with Census 2020 vintage metros and Census 2010 vintage Urban Areas. Create views like shown below for urban areas of interest in context of other geographic areas using VDA Web GIS. This graphic shows urban areas in context of the Dallas MSA.


Steps to develop similar views using VDA
With the "Base" project open, follow these steps.
  • enter state-county code 48113 (Dallas County) in the Find County box above map window.
    .. later, use any county of interest; get state+county code from this list.
    .. click Find County button; the map view refreshes with a zoom-in to the selected county
  • in the legend panel:
    .. uncheck the "Pop %Chg 10-20 x County" layer
    .. check the "CBSA/MSA/Metro" layer on
    .. check the "MSA Name" layer on
    .. check the "County" layer on
  • navigate using Zoom window tool
    .. Zoom out, a little, to see the entire metro .. similar to the above view

Geography .. goto top

Geometry is represented in VDA in these structures (many others are possible):
  • SQLite point files, such as schools
  • SQLite line files, such as roads
  • SQLite polygons, such as states
  • Tiling Raster Graphics, topology; land coverage

The above geography data are organized into VDA GIS projects.

Real-time Geographic Area Computation .. goto top
Clicking a geographic object in the Map Window displays attributes of that object for the Active Layer (e.g., census tract) in the Profile Panel (lower left). For polygons, the area of the object is computed real time and displayed in the last/bottom field in the profile. The area is presented with the name VDA_Area and displayed in square meters. Using square meters enables accurate computation for any size geography. It also provides a standardized measurement unit across all types of source geography. Compute square miles by dividing the square meters value by 2589988.

Availability of the geographic area enables easy computation of per capita measures for any appropriate measure or attribute for any polygon area.

VDA projects use Census-sourced TIGER files, among other types of geometry, described below.

TIGER/DMD .. goto top
TIGER (Topologically Integrated Geographic, Encoding & Reference), or TIGER/Line, is an annually updated Census Bureau public domain geographic database. See more about TIGER and related technical documentation.

VDA SQLite Files & TIGER
Where used in VDA projects TIGER shapefiles ..
  • are converted to SQLite structure.
  • almost always include integrated subject matter not part of the original shapefile.
  • are often modified with respect ot original attributes/fields included.

Datum (GCS NAD 83)
Each TIGER shapefile contains a project (.prj) file that contains the GIS industry standard well-known text (WKT) format to describe the coordinate system, projection, datum information for each shapefile. All Census Bureau generated shapefiles are in Global Coordinate System North American Datum of 1983 (GCS NAD83). Each .prj file contains the following:
GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GR

TIGER Usage in VDA. Many of the VDA GIS projects make use of TIGER-sourced shapefiles and related data. Shapefiles are digital representations of geographic features (e.g., lakes, landmarks, roads, and boundaries) used to create maps. A shapefile stores non-topological geometry and attribute information for the spatial features in a data set. In general, TIGER-sourced shapefiles contain only geographic data and no demographic or subject matter data.

Accessing TIGER Files (FTP)
  • TIGER Files -- All Vintages
  • TIGER 2019 Smoothed .. most recent Census 2010 small area geography
  • TIGER 2020 .. Census 2020 geography (all geo types)
    .. extends to 3-mile limit
  • TIGER 2020 Smoothed .. Census 2020 geography (all geo types)
    .. truncated at shoreline
  • TIGER 2021 Smoothed .. January 1, 2021 legal areas updates

TIGER Shapefiles & Related Files Available
  • Legal entities (areas/polygons)
  • Statistical entities (areas/polygons)
  • Features (points and lines) -- detailed streets/roads
  • Relationship Files

Legal Entities (boundary shapefiles) .. goto TIGER Files
• American Indian Off-Reservation Trust Lands
• American Indian Reservations – Federal
• American Indian Reservations – State
• American Indian Tribal Subdivisions (within legal American Indian areas)
• Alaska Native Regional Corporations
• Congressional Districts – 116th Congress
• Consolidated Cities
• Counties and Equivalent Entities (except census areas in Alaska)
• Estates (U.S. Virgin Islands only)
• Hawaiian Home Lands
• Incorporated Places
• Minor Civil Divisions
• School Districts – Elementary
• School Districts – Secondary
• School Districts – Unified
• States and Equivalent Entities
• State Legislative Districts – Upper
• State Legislative Districts – Lower
• Subminor Civil Divisions (Subbarrios in Puerto Rico)

Statistical entities (boundary shapefiles) .. goto TIGER Files
• Alaska Native Village Statistical Areas
• American Indian/Alaska Native Statistical Areas
• American Indian Tribal Subdivisions (within Oklahoma Tribal Statistical Areas)
• Block Groups
• Census Areas
• Census Blocks
• Census County Divisions (Census Subareas in Alaska)
• Unorganized Territories (statistical county subdivisions)
• Census Designated Places (CDPs)
• Census Tracts
• Combined New England City and Town Areas
• Combined Statistical Areas
• Metropolitan and Micropolitan Statistical Areas and related statistical areas
• Metropolitan Divisions
• New England City and Town Areas
• New England City and Town Area Divisions
• Oklahoma Tribal Statistical Areas
• Public Use Microdata Areas (PUMAs)
• State Designated Tribal Statistical Areas
• Tribal Designated Statistical Areas
• Urban Areas
• ZIP Code Tabulation Areas (ZCTAs)

Features (points and lines shapefiles) .. goto TIGER Files
• All Lines (Edges) -- derivation of intersection to intersection roads
• Address Range-Feature
• All Roads
• Area Hydrography
• Area Landmark
• Coastline
• Linear Hydrography
• Military Installation
• Point Landmark
• Primary Roads
• Primary and Secondary Roads
• Topological Faces (polygons with all geocodes)

Relationship Files .. goto TIGER Files
• Address Range-Feature Name
• Address Ranges
• Feature Names
• Topological Faces – Area Landmark
• Topological Faces – Area Hydrography
• Topological Faces – Military Installations

Selected Topics .. goto top

Using TIGER roads database .. goto top
    36 million street segments
Use the VDA TIGER GIS project (select from Project Manager form) to search/locate/examine the more than 36 million U.S. national scope intersection-to-intersection street segments using the augmented Census-sourced TIGER "edges" database. The TIGER edges/roads database is represented as a single layer in the VDA TIGER GIS project.
See more about TIGER -- Topologically Integrated Geographic Encoding and Referencing database

Features of the TIGER all lines/edges shapefile
The TIGER all lines/edges shapefile (~35 GB) include ~70 million line segments (mainly roads and streams):
.. approximately 45 million line segments are roads (typically intersection to intersection).
.. among road segments, 32 million segments have a populated name field;
.. .. the remaining 12 million road segments have no name assigned.
.. among road segments, 17 million segments have an assigned left-side low address field;
.. .. the remaining 26 million segments have no address in the left-side low address field.

Illustrative View of Edges/Road Attributes & Topology
Each TIGER line/road segment/record contains attributes/fields for a line starting at the "from node" and ending at the "to node" as illustrated in the following graphic. These attributes, as shown in another graphic below, describe features of the left- and right-side of the segment, such as address ranges and geocodes.


Using the VDA TIGER GIS Project

Start-up View & Layers
The start-up view shows as zoom-in to the White House and Washington, DC.
.. the layers, as shown in the legend panel, include:
  .. Tracts .. all U.S. Census 2020 census tracts layer -- the start-up active layer
  .. TIGER .. all U.S. TIGER roads layer
  .. Counties .. all U.S. counties layer
  .. ZIP Codes . all U.S. ZIP code areas layer

To illustrate, at start-up, click the White House location and the corresponding census tract highlights as selected. Demographic-economic attributes of the tract appear in lower left profile panel. See that there are 176 residents in this tract as of Census 2020. See that the Census 2020 tract code is 11001980000. Click the HTML button to show the profile in a new window HTML page.

Results of using "White House" in Find Address
.. with VDA TIGER GIS project open, key in "white house" (no quotes) in Find Address edit box
    then lick Find Address button.
.. map view refreshes with zoom-in to location.
.. click + zoomin button below map window a few times


Results of clicking Street Segment
.. click street segment shown at pointer in above view.
.. profile panel at lower left in VDA screen populates.
.. click HTML button to view sample profile shown below as HTML page.


Using the Table/Query Feature
To use the Table/Query feature with the TIGER layer, first make the TIGER layer active by selecting it from the upper left dropdown.

Click Table/Query button below map window to show street segments in table form.
.. enter the SQL query "statefp='11'" and click query button.
.. table refreshes with only street segments in D.C., District of Columbia.
.. there are 18,543 street segments in this area.

To locate instances of a specific street, use a query such as:
statefp='11' and fullname like "Pennsylvania%"
.. the above query results in 165 street segments displayed in the grid.

To locate a specific street segment, use a query such as:
statefp='11' and fullname like "Pennsylvania%" and lfromadd=1600



Finding/showing Street Segments that meet an SQL Criteria
The following query illustrates how to show all street segments named like "King St" in Alexandria, VA.
fullname like 'King St%' and statefp='51' and countyfp='510'
There are 117 street segments that meet the above criteria. Show the segments in the map view by clicking the button "Highlight all that meet criteria". The selected segments are shown in the map highlighted green with the TLID unique ID as shown below.



End of this topic .. goto top
Using VDA Web GIS with a Smartphone .. goto top

See details about using a smartphone with VDA Web GIS
End of this topic .. goto top
Global Applications using VDA Web GIS .. goto top
  -- Examining Ukraine and Region using VDA
VDA supports worldwide applications. Follow the steps described below to examine characteristics of Ukraine and countries in that region.
  • Start VDA Web GIS using a browser -- link to start VDA Web GIS.
  • Start fresh with the Situation and Outlook Project.
    - if you are using the Level 1 free version, VDA operation times out in 10 minutes.
    - just start over ... you are now more familiar with operations.
    - if you are new to VDA, please review getting started.
  • Make these settings to Legend Panel layer settings (scroll to bottom):
   
    - check the OpenStreetMaps layer on
  • Navigate to Kyiv, Ukraine
    - Key in the name Kyiv in Find Address edit box and click Find Address button
    - the view refreshes and a marker (for the location) is placed on the address as shown below.
   
  • In the legend panel, click on the "Country Projections to 2050" layer
  • Zoom-out to Ukraine country view
    - click zoom-out button below map window 6 times (or use zoom window).
    - navigate in the map window to obtain this view of the region:
   
  • To obtain the above view, with Ukraine as the selected country, proceed as follows:
    - select "Country Projections to 2050" in the "Select Layer" dropdown (upper left)
    - click anywhere in map window on Ukraine
    - the crosshatching appears; a profile of Ukraine appears in lower left Profile Panel.
    - click the HTML button (lower left) to open a new window showing this profile in HTML format.
    - in the HTML profile, see that the 2022 estimated population of Ukraine is approximately 43.5 million.
  • Examining Ukraine provinces -- Luhansk Oblast (eastern Ukraine):
    - select "Country by State" in the "Select Layer" dropdown (upper left)
    - navigate to eastern Ukraine
    - click anywhere in map window on Luhansk Oblast and the following view appears:
   
    - the crosshatching appears; a profile of Luhansk Oblast appears in lower left Profile Panel.
    - click the HTML button (lower left) to open a new window showing this profile in HTML format.
    - in the HTML profile, see that the VDA computed area is 26,310,276,552 square meters or
      10,158 square miles (26310276552/2589988).

End of this topic .. goto top
Examining the Largest 50 Metros using VDA Web GIS .. goto top
Follow the steps described below to examine characteristics of the largest 50 metros in the U.S. based on Census 2020. Also referred to as Core-Based Statistical Areas (CBSAs), the largest 50 metros based on total population are also referred to as Metropolitan Statistical Areas (MSAs). See more about metros.

  • Start VDA Web GIS using a browser -- link to start VDA Web GIS.
  • Start fresh with the Situation and Outlook Project.
    - if you are using the Level 1 free version, VDA operation times out in 10 minutes.
    - just start over ... you are now more familiar with operations.
    - if you are new to VDA, please review getting started.
  • Hide the Title panel from main menu bar: Tools>Show/Hide/Set Title>Hide

  • The objective of this "application topic" is to develop the view and table shown here:
    This view shows the map of the largest 50 metros (upper section)
      and table showing the metros in a grid (lower section):
   
    - check the OpenStreetMaps layer on

Proceed with these steps:
  • Make the the CBSA/MSA layer the "active layer".
    - select "CBSA/MSA" in the "Select Layer" dropdown (upper left)
  • Click Query Table button -- below map at right.
      .. view refreshes showing table/grid
  • Set "max" edit box (below table) value to 50.
  • Set "SORT" edit box (above table at right to "POP20 DESC" (no quotes).
  • Click Query at right; the grid refreshes showing the 50 MSAs sorted on population (POP20).
  • Click "Highlight all thet meet query" button (below table at right).
    .. map window refreshes showing selected MSAs that meet query as crosshatched.
  • Zoom out to see all selected metros.
    .. the map view should now be similar to the view shown above.
  • Optionally use the "Select field" button below table to select only a few fields in dsiplay.
  • Optionally click a metro of interest in the maps to view profile.
    .. in the example above, the Houston, TX metro was clicked.
  • Optionally click the "HTML" button below profile panel to view an HTML structured profile.

Try it yourself. What is the median household income for the Kansas City MSA? From the table? From the profile?

What if you want the top 10 MSAs based on Median Household Income?
    - start over with setting the MAX edit box at 10 and use the SORT value "MEDHHINC DESC"

End of this topic .. goto top
Demographic-Economic Estimates & Projections .. goto top
How might the pandemic, climate change and other events impact affect demographic-economic patterns and characteristics in the future? The U.S. population ages 65 and over is expected to more than double between now and 2060, from 43.5 million to 92.0 million. How will this, and other age groups, be distributed by state and metro? Find out more about these topics and related demographic-economic trends. Visually and tabularly examine model-based estimates and projections, time series data running from 2010 to 2060, using VDA.

Demographic estimates and projections developed by ProximityOne are available via the "Situation & Outlook" project and in more detail via VDA user projects. These data are a part of the Situation & Outlook estimates and projections program. Integrate these data with your data. Examine how current and evolving trends might impact you and your stakeholders.

VDA supports access to two sets of synchronized annual estimates and projections
  • "richer demographics" 2019-2025
  • "population by age,race/origin,gender 2019-2060

Projections to 2025 (5-year projections). VDA provides access to "richer demographic" annual estimates and projections to 2025.
Geography: U.S. by tract, county, metro, state and the U.S.
Time Frame: annual 2019-2025 (extending forward annually; in 2022 the series will be 2019-2026)

Illustrative Scope of Subject Matter for Fresno County, CA (~550 subject matter items):
  • General Demographics Items D001-D089
  • Social Characteristics Items S001-S153
  • Economic Characteristics Items E001-E137
  • Housing Characteristics Items H001-H143

Projections to 2060 (40-year projections). VDA provides access to annual population estimates and projections to 2060 by single year of age (under 1, 1, 2 .. 84, 85 and over) by gender by race/origin.
Geography: U.S. by county, metro, state and the U.S.
Time Frame: annual 2019-2060

Illustrative Scope of Subject Matter & Projections for Sedgwick County (Wichita), Kansas (XLS): http://proximityone.com/outlook/de120173.xls
Standard DE-1 County Outlook Estimates and Projections Dataset; Record Layout:
Field Item DescriptionItemNameNotes/ValuesFormat
1Dataset IDDATASET  C,10
2Geographic Summary LevelSUMLEVC,3
3Geographic Identifier (SSCCCTTTTTBBBB)GEOID  C,15
4ReservedRES1  C,4
5ITEMITEM  C,10
6FORMATFORMAT  C,15
9D2010D2010  N,9,0
10D2011D2011  N,9,0
11D2012D2012  N,9,0
.........  fmt
57D2059D2059  fmt
58D2060D2060  fmt

where ITEM is structured as characters; zero is required for total or where category not applicable.
sample codes:
PAGEGRAMD -- see character codes below
P015MH000 -- Population age 15, male, Native Hawaiian/Other Pacific Islander alone
P0150WN00 -- Population age 15, total, White alone, Non-Hispanic
P01500000 -- Population age 15, total
P0150000D -- Deaths, total population, age 15
P015M00I0 -- International migration, total male population, age 15

where GRAMD (see in item code field in above table):
CodeValueDescription
G: GenderMMale
  FFemale
R: Race WWhite alone
  BBlack alone
  IAmerican Indian/Native Alaskan alone -- AIAN
  AAsian alone
  NNative Hawaiian/Other Pacific Islander alone -- NHPI
  SSome Other Race alone
  2Two or More Races
A: Attribute HHispanic
  NNonHispanic
M: Migration HDomestic
  CInternational
D: Deaths DDeaths

Housing Situation .. goto top
Examining the "Housing Situation" involves a broad view of the housing market, supply-demand, as well as focus on more specific attributes -- at wide-ranging geographies. VDA helps stakeholders assess these patterns and characteristics.

New Residential Construction .. goto top


Housing Price Index .. goto top
A broad measure of the movement of single-family house prices, the Housing Price Index (HPI) provides an indicator of house price trends at various geographic levels. When used with related data, it provides analysts with a measure that is useful for estimating changes in the rates of mortgage defaults, prepayments and housing affordability in specific geographic areas.

The following graphic illustrates use of VDA to analyze HPI by ZIP Code. A query is used with the ZIP Code layer to select only those ZIP codes meeting certain criteria. Selected attributes of those ZIP Codes are shown in the table/grid and map window.


In this application a query is used to access and use selected HPI data from the ZIP Code layer included in the VDA "Situation & Outlook" project. The following query is used:
select uid,geoid,hpi2010, hpi2020, hpi2020-hpi2010, 100*(hpi2020-hpi2010)/hpi2010 where hpi2010>0 and hpi2020-hpi2010>260 and stusps='CA'
This query says to display these items: uid,geoid,hpi2010, hpi2020, hpi2020-hpi2010, 100*(hpi2020-hpi2010)/hpi2010 when hpi2010 is greater than 0, the HPI growth between 2010 and 2020 is greater than 260 and consider only ZIPs in California. Using VDA, you can set your own criteria.

The sort order is set using this text: hpi2020-hpi2010 desc

Finally, click the query button. The results are shown in the table/grid.

Additional settings and details. Sequence of steps after the "Situation & Outlook" project opens:
.. in the upper right dropdown, select "ZIP Code" as the active layer.
.. in the Legend Panel, uncheck the "County %PopChg 10-20" layer
.. click the table/query button (at right, below map window)
.. paste this query in the SQL edit box:
  select uid,geoid,hpi2010, hpi2020, hpi2020-hpi2010, 100*(hpi2020-hpi2010)/hpi2010 where hpi2010>0 and hpi2020-hpi2010>260 and stusps='CA'

.. paste this text in the sort edit box:
  hpi2020-hpi2010 desc

.. click query button
.. click highlight all ..
.. in the legend panel:
  check on "ZIP Code Bold" layer
  uncheck "World by Country" layer
  checl on "OpenStreetMaps Tile" layer

Congressional Communities .. goto top
Congressional Communities (CCs) are geographic areas that subdivide congressional districts. CCs have been developed by the Congressional Communities organization to meet their mission. CCs are included as layers within the VDA "Census 2020" GIS project (details below). CC stakeholders may use the VDA Census 2020 GIS project to locate CCs and view/analyze characteristics of CCs. "Census 2020" does not mean that this is only information associated with Census 2020. This section provides step-by-step procedures for finding your CC and examining CCs in context of congressional districts (CDs) and other geography and demographic patterns.

User Support -- navigating VDA, geography, demographics, other data to meet your objectives
  • join us in the "Accessing & Using Demographics Web Sessions" every Tuesday
    .. get your questions answers about CCs & geodemographic analysis
    .. see use of VDA and related tools to analyze CCs and congressional Districts
    .. see details
    .. there is no fee for these one-hour Web sessions.
  • Add my e-mail to receive Congressional Communities & Census 2020 updates

Congressional Community Tutorials
Follow the steps below to locate and examine a CC in context of Congressional District CA 48 (in Orange County, CA). The following graphic shows Congressional District CA 48 with a cross-hatch pattern in context of other congressional districts (CD number shown as yellow label) and patterns of economic prosperity by census tract. The view also shows congressional communities (CCs) with a black boundary. The pointer is located CC 0648004 (CC 004 in CD 48 in state 06-California). The tutorials are easily applied to any congressional community/congressional district.


Congressional Community Tutorials
  • Finding a CC based on a ZIP code; using CC Layers, Legend and Map Window
    .. video
    .. why important: enables finding a CC in your location or elsewhere without using an address.
    .. once you know the CC code (SSCDCC), optionally join the community.
    .. introduces VDA operations used in next steps.
  • Finding a CC based on the CC code; using the VDA Table/Query Operations with CCs
    .. video
    .. why important: enables finding a CC by using a CC code (SSCDCC) -- and show it on a map.
    .. introduces VDA Table/Grid used in next steps.
    .. lear how to find CCs having certain demographic characteristics.
    .. learn how to list, count, sort CCs within particular congressional district(s).
  • Using the VDA GeoSelect feature with Block Groups and CCs
    .. video
    .. why important: enables you to visually select & examine CC component areas
        -- e.g., census blocks, block groups ...
        -- view demographic characteristics of aggregated component areas.
    .. introduces VDA GeoSelect used elsewhere.
  • Examining Census 2020 Census Block Demographics & Congressional Communities
    .. upcoming video
    .. the first Census 2020 census block demographics (redistricting data) will be released in mid-August.
    .. this video will be available in late August 2021.

School Districts .. goto top
The Census2020A project provides Census 2020 demographics for all school districts. The following view shows Houston ISD, TX with a crosshatch pattern and other districts in the vicinity of Harris County, TX. Each district is shown with name and Census 2020 total population.


Click the Houston ISD area (with VDA running); the Census 2020 demographic profile shows in lower left profile panel.
    .. in this example, it shows the Census 2020 population for Houston ISD was 1,482,147
    .. use the copy to clipboard button below the profile panel to copy the profile and paste in a spreadsheet.

Develop a similar view and generate a Census 2020 demographic profile for any school district; follow these steps.
  • open the Census2020A project from the VDA project manager form.
  • make the Unified School Districts (USD 2020 Population) the active layer.
    .. select that layer name using the top-left dropdown.
  • in the legend panel, check these layers off
    .. 2020 %Asian by Tract
    .. World by Country
  • in the legend panel, check these layers on
    .. County Boundary Bold
    .. USD Name (Unified School Districts)
    .. USD 2020 Population
    .. USD Boundary Bold
    .. OpenStreetMaps Tiles
  • navigate to the region and district of interest
    .. method 1, use zoom tool and pan/drag (shift key, drag with mouse)
    .. method 2, use the Find ZIP or Find County to center the map view on one of those.
    .. method 3, use the Tools>Find Address and key in the name of a district or school or related address.
    .. method 4. use table/query (click table/query button below map window); find based on name or other attribute.
  • to view the demographic profile, click the district of interest.
    .. the profile appears in the Profile panel shown at lower left.
    .. use the copy to clipboard button below the profile panel to copy the profile and paste in a spreadsheet.
  • compare school districts.
    .. click a second district in map window; demographic profile panel refreshes.
    .. use copy to clipboard button and paste in an adjacent set of columns in the spreadsheet.
    .. continue as desired; optionally compare to other types of areas such as county, city, state ,etc.

K-12 Schools .. goto top
The Situation & Outlook and Census2020 projects include all U.S. K-12 schools and school districts. The following view shows K-12 schools in the Houston ISD, TX area by grade level. See level type marker in legend. The select/identify tool is used to click on a school (located at pointer in map window) showing the school profile in lower left profile panel. Optionally export profile to spreadsheet. Zoom-in to examine schools in context of Census 2020 block group/census tract characteristics. Use table/query feature to view/analyze school characteristics in a spreadsheet linked with map view.


Urban Areas .. goto top
As defined by the Census Bureau, and as used in VDA, urban areas are geographic areas with boundaries based on Census Bureau criteria. The remainder of the U.S. geography is classified as rural. There presently no provision for "suburban." Ultimately, urban areas are sets of census blocks. See more about the concept/definition of urban areas. See the proposed Census 2020 urban area criteria. While no date has been established for the release of 2020 urban area delineations by the Census Bureau, it could be into 2023.
Using already available Census 2020 census block level geography and demographics, it is possible to explore areas that will almost certainly be 2020-based urban blocks using the Situation & Outlook project. Follow these steps to explore 2020 urban area geography based on 2020 census blocks. One of the core elements of the proposed 2020 urban area criteria is that the are must have a housing density of 385 housing units per square mile.
To examine patterns of census blocks that meet this pattern in the Orange County, CA area, follow these steps:
With VDA running and the Situation & Outlook project open in the start-up state,
.. select the CA 2020 Census Blocks layer as the Active Layer.
.. click the Table/Query button below and to the right of the Map Window.
.. set the "max" edit box to the value 1000000.
.. when the table/grid is populated, enter the following text in the SQL edit box:
    select uid, geoid,totpop,aland20 where county='059' and tot_hsg*2589988/(aland20+1)>385
.. there should be approximately 19,212 blccks that meet this criteria and show in the table.
.. click CTRL-A in the grid to select all rows.
.. under development

ZIP Codes .. goto top
Developed by the Postal Service to more efficiently deliver mail, ZIP codes are lines corresponding to delivery routes or points corresponding to post office locations or delivery points. The Postal Service does not develop ZIP codes as polygons.

ZIP codes are popular because most everyone knows their ZIP code and can relate to others by a 5-digit code. ZIP codes are popular in the data world because often data are only collected or tabulated only with the ZIP code as the geographic identifier.

VDA uses ZIP code geometry based on the Census Bureau ZIP Code Tabulation Areas (ZCTAs). A primary reason for using the ZCTAs in VDA GIS projects is that these codes are the ZIP code tabulation areas used to develop the American Community Survey (ACS) demographic-economic data. Another important reason is that ZCTA are defined as a set of census blocks. It is straight forward to accurately compare ZCTA geometry with that of block groups, census tracts and most other Census-sourced political-statistical geography. Another reason for using ZCTAs for ZIP code polygon geometry is that they are based on a Federal standard.

Presently the VDA ZIP Code layers are based on the Census 2010 ZCTAs, the 2020 ZCTAs are now available.

See related:
  • developing a ZIP code demographic economic profile using VDA

This section is under development.

Examining Demographic Characteristics of a Census Block .. goto top
Find a Census 2020 census block based on an address. View the block in a a map and view/analyze demographics for that block and other blocks, individually or grouped as an aggregate. Steps in this section make use of the Census2020A project and apply to California 2020 census blocks. These operations can be performed for any state and require uploading a layer (see about uploading a layer) for other states of interest. In the following examples, the same census block is used, located in the Encino, CA area.

Characteristics of a Census Block - Option 1 .. the block geocode is known
The census block geocode, unique identifier among all 8.1. million blocks, is a 15-character code.
The block code of interest is 060371397052001
Steps:
Start with a fresh rendering of the Census2020A project.
Set the active layer to the CA Block Layer.
Set these layers in the legend panel
.. 2020 %Asian x Tract unchecked
.. World by Country unchecked
.. OpenStreetsMaps unchecked

Click the Table/Query toggle button; the block layer grid populates.
Set the One Item query to GEOID = 060371397052001 then click query button at right.

.. wait for the grid to show just this one block.
.. click that row (it turns blue) then click the button "click geography row to display"
.. the map window refreshes; the select block is shown with crosshatch.
.. the demographic profile is shown in the Profile Panel (lower left)
.. scroll down to see the Census 2020 total population is 447
in the legend panel, click on these layers:
.. CA Block Code
.. CA Block Population.
That completes this example.

Characteristics of a Census Block - Option 2 .. based on an address
.. under development


Census 2020 Project .. goto top
The "Census 2020" project is described in detail below. VDA users may have many projects that use Census 2020 data. This project is both illustrative and production oriented. The "Census 2020" project is updated as Census 2020 data become available. News on updates are provided through the updates section of this page and via email updates posted to the user group (join here).

The Census 2020 project includes both Census 2010 and 2020 geography and data. It illustrates how you can use other data such as topography, neighborhood delineations, address-coded data and more. Layers include (U.S. national scope unless otherwise noted):
States
State Label
County Outline
Metropolitan Statistical Areas (MSAs) 2020
CA Roads Name -- shows road name using either of the following roads layers
CA Roads1 -- primary/secondary roads rendered with simple black line
CA Roads2 -- primary/secondary roads rendered with bolder line
Locations -- illustrative geocoded address locations in ZIP code 91436
117th Congressional Districts Code
117th Congressional Districts
117th Congressional Districts Bold
117th Congressional Districts x $MHI
PUMA 2010 Code -- 2010 Public Use Microdata Areas
PUMA 2010
$MHI x PUMA
CC 2010 Code -- Congressional Communities
CC 2010
CC 2010 Bold
Tract 2020 Code -- Census 2020 Census Tracts
Tract 2020
Tract 2010 Code -- Census 2010 Census Tracts
Tract 2010
Tract 2010 Hispanic
Tract 2010 x $MHI
BG 2020 Code -- Census 2020 Block Groups
BG 2020
BG 2010 Code -- Census 2010 Block Groups
BG 2010
LA Roads -- 2020 TIGER-based roads -- intersection to intersection -- Los Angeles County
LA Neighborhoods -- illustrative neighborhood boundaries -- for Los Angeles
CA Block 2020 Code -- 2020 Census Blocks -- California ~ 517,000 blocks
CA Block 2020
K12 School Name
K12 Schools
School District Names
School Districts
Metros/MSAs
Metros/MSA Name
Metros/MSA Population
Counties Name
Counties Population
Cty Pop Gain 2010-19
Cty Pop Loss 2010-19
County PCPI
County PCPI
Cities Name
Cities
Cities Population
ZIP Code
ZIP Code Bold
$MHI x ZIP Code
$MHV x ZIP Code
Establishments x ZIP
Country Projections 2050
World by Country
OpenStreetMaps
States1

Roads Related Layers/Data .. goto top
The following streets/roads layers are included in the Census 2020 project and the focus of this sub section:
  • LA Roads layer: intersection to intersection detailed roads
    .. these data are based on the Census 2020 TIGER shapefiles.
        - specifically the "edge shapefiles".
    .. these data provided for only Los Angeles County; users may add their own.
  • Roads, Roads1 and Roads2 layers: roads
    .. these data are based on the Census 2020 TIGER shapefiles.
        - specifically the "primary/secondary roads shapefiles" and are major roads.
    .. these data geometrically match the "edges" based roads (above).
    .. these data provided for California; users may add their own.
  • OpenStreetMaps layer: tiling, graphics-based topology layer showing road features
    .. global coverage.

Census 2020 Block Layer/GeoDemographics .. goto top

In this section, usage of the Census 2020 block file/data is reviewed for census block 060371397052001 in Los Angeles County; see pointer in above graphic. The focus is on the structure/use of the Census TIGER 2020 block shapefile and integration of Census 2020 P.L. 94-171 data. Integration of other block level, becoming available later, will be reviewed in updates.

The following view of the Encino/Los Angeles area shows the vicinity for the subsequent drill-down review of more detailed geography. The pointer is located in the same census block as reviewed below.
  • Census 2020 blocks are shown with red boundaries.
  • Los Angeles neighborhood boundaries are shown with blue boundaries.
  • Locations (Locations layer) are shown with red markers.



Note while this block has the same geometry and block code (2001) for Census 2010 and Census 2020; the GEOID (15 character unique ID) differs because the Census 2010 tract was 139702 and the Census 2020 tract is 139705.


Census 2020A Project Files/Layers .. goto top
The first sub-state Census 2020 data are expected to be available on August 12, 2021.
This section describes the layers/data that will be available via VDA on August 16, 2021 in the project "Census 2020A". The Census 2020A project shows as an "available project" for authorized users in the Project Manager section after login. The Census 2020A project is initially populated with U.S. national scope layers described below. All layers include selected data from the Census 2020 P.L. 94-171 "redistricting" data. The Census 2020A project will evolve to include more Census 2020 data as more data are released.

Standardized/Evolving Census 2020 datasets

Files with a standardized structure are available for the geographic levels listed below. The summary level code is also shown.
  • U.S. & State 010/040
  • Core Based Statistical Area (CBSA -- Metro: MSA/MD/MISA) 3xx
  • Combined Ststistical Area (CSA 330)
  • Congressional District (CD 500)
  • Congressional Community (CC 550)
  • State Legislative District (Upper Chamber) (SLDU 610)
  • State Legislative District (Lower Chamber) (SLDL 620)
  • Voting District 700
  • County 050
  • County Subdivision (CCD 060)
  • Urban Area (UA 400)
  • School District (9xx; 950, 960, 970)
  • Place 160
  • ZIP Code Tabulation Area (ZCTA 860)
  • Census Tract 140
  • Block Group 150
  • Block 750 (by state)

See related DEDE section for more information about file structure.

Census 2020 Census Block Structure (with coded CCN) .. goto top
.. Census 2020 block shapefiles with integrated Census 2020 demographics ..
The Census 2020 census block attributes are reviewed in this subsection. The integrated demographic shapefiles have developed by ProximityOne on a state by state basis. Use VDA to view/analyze these data in map format or in spreadgrid form using the table/query mode.

Illustrative View of Census 2020 Census Blocks in Honolulu, HI
.. bold boundary is Census 2020 census tract 15-003-008000 with Census 2020 population 3,770.
.. census blocks shown with black boundary; block by pointer is block 15-003-000800-2001 with population 519).


Attributes of Census 2020 Census Blocks with Integrated Demographics
The table below shows the fields included in the Census 2020 block shapefiles with integrated Census 2020 demographics. The demographic data column is populated for census block (150030008002001) by pointer in the view shown above. Compare Census 2020 total population (519) in map profile (upper right) with value shown in the table.

This file provides an equivalence table; the geocode of each census block is related to the geocode of higher level geography of which it is a part .. block 15-003-000800-2001 is a part of county 15-003, CCD 15-90810, etc.
1     GEOIDEXT     7500000US150030008002001     String[ 25];
2     AREANAME     Block 2001     String[ 20];
3     STAB     HI     String[ 2];
4     GEOID     150030008002001     String[ 15];
5     DATE         String[ 7];
6     STATE     15     String[ 2];
7     COUNTY     3     String[ 3];
8     TRACT     800     String[ 6];
9     BLOCK     2001     String[ 4];
10     RES1     1     String[ 5];
11     SUMLEV     750     String[ 3];
12     CBSA     46520     String[ 5];
13     CSA     999     String[ 3];
14     SLDU     15009     String[ 7];
15     SLDL     15019     String[ 7];
16     SDELM     1599999     String[ 7];
17     SDSEC     1599999     String[ 7];
18     SDUNI     1500030     String[ 7];
19     ZIP         String[ 5];
20     VTD         String[ 5];
21     CCD     1590810     String[ 7];
22     UA         String[ 5];
23     PLACE     1571550     String[ 7];
24     CD     1     String[ 4];
25     CC     1501018     String[ 7];
26     AREALAND     155379     String[ 14];
27     AREAWATR     0     String[ 14];
28     INTPTLAT     21.276117     Real; { width = 12, decimals = 6}
29     INTPTLON     -157.80036     Real; { width = 12, decimals = 6}
30     TOTPOP     519     LongInt; { width = 9}
31     TOTPOP1     423     LongInt; { width = 9}
32     WHITE1     112     LongInt; { width = 9}
33     BLACK1     9     LongInt; { width = 9}
34     AIAN1     1     LongInt; { width = 9}
35     ASIAN1     286     LongInt; { width = 9}
36     NHOPI1     14     LongInt; { width = 9}
37     OTHER1     1     LongInt; { width = 9}
38     MLTRACE1     96     LongInt; { width = 9}
39     WHITE1NH     107     LongInt; { width = 9}
40     BLACK1NH     7     LongInt; { width = 9}
41     HISPANIC     16     LongInt; { width = 9}
42     TOTPOP18     431     LongInt; { width = 9}
43     TOTPOP118     374     LongInt; { width = 9}
44     WHITE118     96     LongInt; { width = 9}
45     BLACK118     9     LongInt; { width = 9}
46     AIAN118     0     LongInt; { width = 9}
47     ASIAN118     255     LongInt; { width = 9}
48     NHOPI118     13     LongInt; { width = 9}
49     OTHER118     1     LongInt; { width = 9}
50     MLTRACE18     57     LongInt; { width = 9}
51     WHITE1NH18     91     LongInt; { width = 9}
52     BLACK1NH18     7     LongInt; { width = 9}
53     HISPANIC18     10     LongInt; { width = 9}
54     GRPQTR     6     LongInt; { width = 9}
55     GRPQTRINST     0     LongInt; { width = 9}
56     GRPQTRNIST     6     LongInt; { width = 9}
57     TOT_HSG     233     LongInt; { width = 9}
58     OCC_UNITS     211     LongInt; { width = 9}
59     VAC_UNITS     22     LongInt; { width = 9}

Viewing Attributes of Census 2020 Blocks .. goto top
.. separate, but related to above topic. These operations are supported by the currently available "Census 2020" (not "Census 2020A") project.

The following graphic illustrates use of the Table/Query feature to view Census 2020 blocks as a table (lower section) and geospatially in a map context (upper section).
  • the selected block (cross-hatched) is the same block as reviewed above.
  • the CA 2020 Block layer has been made the Active Layer (see top left).
  • the block is shown in context:
    .. with locations layer (red markers)
    .. LA neighborhood layer (in Encino)
    .. OpenStreetMaps topology
  • in the map, the block was clicked, resulting in the profile display (lower left).
    .. in the profile, see the UID is 440085.
  • in the table, a query could be performed on the block record list to find UID=440085.
    .. clicking the query button would instantly locate the record in the table.
.. click graphic for larger view

U.S. National Scope Census 2020 Block Layers .. goto top
Census 2020 census block layers are available to Level 2+ users in the Census 2020 project.
These are two 8.1 million block layers: a point shapefile or SQLite and a polygon shapefile or SQLite file.
Illustrative view using the block point layer/data in southern California.
.. red markers show "point in polygon" for each Census 2020 census block.


Illustrative view using the block polygon layer/data in southern California.
.. gray boundaries show each Census 2020 census block polygon.


Illustrative view using the combined block point and polygon layers/data in vicinity of Encino/Los Angeles.
.. the combined block points and polygons.


GIS Project Layers/Fields .. goto top
Detailed information on the scope of subject matter included in layers for each VDA GIS project are available to Level 2 subscibers.


Excel Templates .. goto top
To display/use the content of the Profile Panel as an excel file, excel templates are provided for selected types of geography/layers as described below. An advantage of using the templates is to present the Profile Panel content in a more consumable format and enable side-by-side comparison of multiple geographic areas/objects.

S&O City/Place Profile .. goto top
Create your own city/place profile for any of the 32,000 city/place areas based on Census 2020. Examine demographic change from 2010 to 2020. View/analyze data from the Census 2010 Summary File 1 with corresponding data from the Census 2020 PL 94-171 data. Develop side-by-side comparative analysis profiles and more.

About Cities/Places & VDA City Place Layers
Cities/Places are geographies/areas that include Incorporated Places and Census Designated Places (CDPs). Incorporated Places are legally bounded entity such as cities, boroughs, towns, or villages depending on the state. There are almost 22,000 incorporated places based on Census 2020. Census Designated Places (CDPs) are "statistically defined entities" (by the Census Bureau and local agencies) that are unincorporated community, concentration of population, housing, and commercial structures, identifiable by name, but not within an incorporated place. CDP's have a LSAD (Legal/Statistical Area Description) code of 57. These codes can be useful when analyzing types of places using VDA. For Census 2020, there are 10,195 CDPs and 21,993 Incorporated Places/cities.

The VDA "Situation & Outlook" project includes two "all places" layers. The "Places ACS2019" layer includes Census 2010 places (Census 2010 geographic areas and codes) with integrated ACS 2019 subject matter. The "Places 2020" layer includes Census 2020 places (Census 2020 geographic areas and codes) with integrated Census 2010 and Census 2020 subject matter. The Places 2020 layer is based on Census 2020 geography and codes (32,188 areas). Data from Census 2010 has been merged into the Places 2020 layer by matching the Census 2010 place code with the Census 2020 place code. 327 of the Census 2020 places have zero population; 3,261 have less than 100 population.

Using Query/Table
There are 15,201 Census 2020 non-CDP places (total 21,993 non-CDP places) with population under 5,000:
  select uid, name, pop20 where pop20<5000 and lsad<>'57'
  pop20 desc

About this Illustrative Application
The illustrative application is focused on the Irvine, CA area. Irvine, CA increased in population from 212,375 (Census 2010) to 307,670 (Census 2020), an increase of 95,295 (44.9%). How to view these data (and more extended demographics) as an organized profile for Irvine, or any city/place, using VDA? Follow these steps. While Irvine city did not have a boundary change between 2010 and 2020, many places have had a boundary change since 2010.


How to develop the above view using VDA? This is a separate/different topic reviewed below.

With VDA running and the "Situation & Outlook" project open, proceed as follows:
1) select the "Places 2020" layer in the upper left dropdown, making it the Active Layer.
2) click Query/Table button below map window at right
    VDA refreshes, showing cities in the table/grid.
3) enter the text below (copy and paste) in the SQL Filter edit box
    select uid, name, stusps where name like 'Irvine'
4) click the query button on the same row.
    the grid rereshes showing 2 cities named Irvine.
    click the Irvine, CA row; it turns blue.
5) click the click geography row to display button below the grid.
.. the demographic profile for the selected city appears in the lower left Profile Panel.
6) click the copy-to-clipboard button under the Profile Panel.
7) open the Places excel profile template
.. the XLS template file initially shows data for the default area -- Houston, TX
    note that the Census 2010 total population for Houston, TX (cell C20) is 930,450.
8) paste (Ctrl-V> into cell K1 .. adding the copy-to-clipboard data to the view; replacing the default data.
    .. data from profile panel show in Col 3 with descriptive stubs
        - subject matter items from Census 2010
        - subject matter items from Census 2020

This ends the illustrative steps to develop an Excel profile for a city/place.

Creating the Irvine, CA Place Vicinity Map
Starting at Step 5 above, click the Query/Table; VDA refreshes with Map Window only.
Zoom-in to the Irvine (crosshatched) area.
In the Legend Panel ...
- Uncheck the "County %PopChg 10-20" layer
- Check on "Places ACS2019" layer
- Check on "Places 2020" layer
- Uncheck the "World by Country" layer
- Check on the "OpenStreetMaps" layer
The Map Window should now be similar to the above view.

This ends the illustrative steps to develop the above view of the Irvine, CA and related places.

County/Block Geographic Comparative Analysis Spreadsheet Profiles
Using the County layer as the active layer in the Base project.
To view the profile with descriptive stubs, proceed as follows:
.. select the "County" layer in the upper left dropdown, making it the Active Layer.
.. click on any county in the Map Window.
.. the demographic profile for that county appears in the lower left Profile Panel.
.. click the copy-to-clipboard button under the Profile Panel.
.. open the Census 2020 excel profile template
.. click CTRL-V, paste, in column L1; results shown in columns 1-3.

Congressional Community Profile
Using the "Cong Comm Census 2020" layer as the active layer in the Census2020A project.
To view the profile with descriptive stubs, proceed as follows:
.. select the "Cong Comm Census 2020" layer in the upper left dropdown, making it the Active Layer.
.. click on any congressional community (CC) in the Map Window.
.. the demographic profile for that CC appears in the lower left Profile Panel.
.. click the copy-to-clipboard button under the Profile Panel.
.. open the CC 2020 excel profile template
.. click CTRL-V, paste, in column L1; results shown in columns 1-3.

Census 2020 Block Profile
Using the Block layer as the active layer in the Census2020A project.
To view the profile with descriptive stubs, proceed as follows:
.. select the "2020 Block" layer in the upper left dropdown, making it the Active Layer.
.. click on any census block in the Map Window.
.. the demographic profile for that block appears in the lower left Profile Panel.
.. click the copy-to-clipboard button under the Profile Panel.
.. open the Census Block 2020 excel profile template
.. click CTRL-V, paste, in column L1; results shown in columns 1-3.

Bank Profile
Using the Bank layer as the active layer ...
To view the profile with descriptive stubs, proceed as follows:
.. select the "Bank" layer in the upper left dropdown, making it the Active Layer.
.. click on any bank marker in the Map Window.
.. the demographic profile for that bank appears in the lower left Profile Panel.
.. click the copy-to-clipboard button under the Profile Panel.
.. open the Bank excel profile template
.. click CTRL-V, paste, in column L1; results shown in column G.

S&O County Profile
Using the Situation & Outlook project with the County layer as active layer or clicking on Find County ...
To view the profile with descriptive stubs, proceed as follows:
Option 1.
.. above the Map Window, enter the state+county FIPS code (stcty) for county of interest.
.. click Find County button.
    the default stcty code is 06019 (Fresno County, CA).
.. the county highlights in Map Window; the profile shows in the lower left panel.
.. click the copy-to-clipboard button below the profile panel.
.. open the S&O County XLS template.
    - the XLS template file initially shows data for the default area -- Fresno County
        note that the Census 2010 total population for Fresno County (cell C20) is 930,450.
    .. paste (Ctrl-V> into cell K1 .. adding the copy-to-clipboard data to the view; replacing the default data.
    .. data from profile panel show in Col 3 with descriptive stubs
        - 30 subject matter items from Census 2010
        - same set of items from Census 2020
        - set of richer demographics from ACS 2019
        - model-based estimates & projections.
Option 2.
.. select the "County" layer in the upper left dropdown, making it the Active Layer.
.. click on any county in the Map Window.
.. the demographic profile for that county appears in the lower left Profile Panel.
.. click the copy-to-clipboard button under the Profile Panel.
.. open the County excel profile template
.. click CTRL-V, paste, in column K1; results shown in column 3.

S&O ZIP Code Profile
Using the Situation & Outlook project with the ZIP Code layer as active layer or clicking on Find ZIP ...
To view the profile with descriptive stubs, proceed as follows:
Option 1.
.. above the Map Window, enter the 5-digit ZIP code for ZIP code of interest.
.. click Find ZIP button.
    the default ZIP code is 91780 located in Los Angeles County, CA.
.. see details about this ZIP Code
.. the FHFA HPI is computed for approximately 19,000 ZIP codes (of approximately 33,000); the HPI values are zero for non-computed areas .. the ZIP code area highlights in Map Window; the profile shows in the lower left panel.
.. click the copy-to-clipboard button below the profile panel.
.. open the S&O ZIP Code XLS template.
    - the XLS template file initially shows data for the default area -- ZIP 91780
        note that the ACS 2019 total population for this ZIP (cell C6) is 35,133.
    .. paste (Ctrl-V> into cell K1 .. adding the copy-to-clipboard data to the view; replacing the default data.
    .. data from profile panel show in Col 3 with descriptive stubs
        - set of richer demographics from ACS 2019
        - annual FHFA HPI estimates 2010-2020 (base 2000=100).
        - see more about HPI by ZIP Code
Option 2.
.. select the "ZIP" layer in the upper left dropdown, making it the Active Layer.
.. click on any ZIP area in the Map Window.
.. the demographic profile for that county appears in the lower left Profile Panel.
.. click the copy-to-clipboard button under the Profile Panel.
.. open the ZZIP excel profile template
.. click CTRL-V, paste, in column K1; results shown in column 3.

SQL Operations .. goto top
SQLite operations are used in the VDA Table/Query feature. They are used to "place a query" on the Active Layer or filter the universe of records in the total dataset of the Active Layer.
The following view illustrates use of VDA Table/Query with the "Hawaii" project with ZIP Code as the active layer.
.. Select Field feature used to select only UID, ZCA, MEDHHINC in table
.. the SQL Filter is set to "stusps='HI'"
.. the SORT field is selected as MEDHHINC desc (sort the table on the field name MEDHHINC
.. clicking Query, the table is displayed as shown below.
.. the ZIP code 96821 is clicked/selected, showing as blue highlighted.
.. the "click geography row to display" button is clicked;
      the map window refreshes with a zoom to that area (crosshatched).
.. the Profile panel (lower left) is populated with the ZIP code layer attributes.


SQLite LIKE operator .. goto top
SQLite LIKE operator is used to match text values against a pattern using wildcards. If the search expression can be matched to the pattern expression, the LIKE operator will return true, which is 1. There are two wildcards used in conjunction with the LIKE operator:
.. the percent sign (%)
.. the underscore (_)
The percent sign represents zero, one, or multiple numbers or characters. The underscore represents a single number or character. These symbols can be used in combinations.

Syntax .. the following shows the basic syntax of % and _.
GEOID LIKE 'XXXX%'
AreaName LIKE '%XXXX%'
column LIKE 'XXXX_'
column LIKE '_XXXX'
column LIKE '_XXXX_'
Combine N number of conditions using AND or OR operators. Here, XXXX could be any numeric or string value.

Examples. Below are examples having different LIKE clauses with '%' and '_' operators.
GEOID LIKE '200%'
Finds any values that start with 200

GEOID LIKE '%200%' .. finds any values that have 200 in any position
GEOID LIKE '_00%' .. finds any values that have 00 in the second and third positions
GEOID LIKE '2_%_%' .. finds any values that start with 2 and are at least 3 characters in length
GEOID LIKE '%2' .. finds any values that end with 2
GEOID LIKE '_2%3' .. finds any values that has a 2 in the second position and ends with a 3
GEOID LIKE '2___3' .. finds any values in a five-digit number that starts with 2 and ends with 3

SQLite WHERE Operations .. goto top

Enter the sample values/strings in the SQL Filter and click query button.

100*totpop18/totpop between 10 and 50
.. all fields in native order or selected fields

SQLite SELECT Operations .. goto top

UID, the universal ID, must be used first in SELECT operations

Enter the sample values/strings in the SQL Filter and click query button.

Using States as the Active Layer.

select uid,white1,asian1,black1
select uid,areaname,stab,white1,asian1,black1,100*white1/totpop

select avg(totpop),sum(black1),sum(asian1) as result1

select max(totpop),max(black1),max(aian1)
select max(totpop),max(black1),max(aian1), min(totpop)+2

select black1+aian1 as result2
.. totpop desc

select stab,white1,asian1,black1 where stab="VA" or stab="CA"
.. 100*white1/totpop desc

Using HI Blocks as Active Layer

SQL Filter .. select stab,ccn, totpop, white1,asian1,black1,100*white1/totpop where totpop>10 and ccn='1501016'
SORT .. 100*white1/totpop desc select stab,white1,asian1,black1 where totpop>0 and ccn='1501016'
.. 100*white1/totpop desc

select totpop where 100*totpop18/totpop between 10 and 50

Using Hawaii project wirh Cong Community as Active Layer

SQL Filter: select count(*)
.. returns 37

SQL Filter: select ccn, totpop, 100*totpop18/totpop where 100*totpop18/totpop between 80 and 100
SORT: 100*totpop18/totpop desc

FAQ - Frequently Asked Questions .. goto top

Q. How I learn what subject matter items are included in a layer?
A. Select the layer of interest in the top left dropdown.
  Start Table/Query (rightmost button under Map Window)
  When the Table/Window form the split view, click the "Select Field" button below the table.
    .. a list of fields in that layer is displayed.
    .. click the "set and close" button (nothing needs to be checked).

Q. How can I set the project extent to the U.S. lower 48 states?
A. Use the project editor and modify the extent properties of the project with these setting:
  using a text editor, copy these 4 lines and replace them with the existing 4 lines (as used in Base-Housing project).
VisibleExtent.XMax=-8022881.69697409
VisibleExtent.XMin=-13354380.2097085
VisibleExtent.YMax=6633997.20497627
VisibleExtent.YMin=2266209.79366904

Q. How do I view patterns of median household income by census tract for a city of interest?
A. Follow these steps:
.. Select the right project. Using existing projects, select the Census2020 project using File>Select Project.
.. With that project open, enter a zip code for the city of interest in the Find ZIP edit box and click Find ZIP.

Q. I do not find Urban Areas as a layer in the Census2020 project. How can I view Urban Areas?
A. Follow these steps:
.. The Urban Areas layer is included in the Base Project and variations of the Base project.
.. The Urban Areas layer can be added to any project using the Upload Layers feature.

Terms, Glossary & Feature Links .. goto top

Use this link to the general glossary

Support .. goto top

  • Participate in a Weekly VDA Training & Support Session
    .. every Thursday, 3:00 pm ET
    .. get tips, structured description of operations, answers to questions.

  • Participate in a Accessing & Using Demographic Data Weekly Web Session
    .. every Tuesday, 3:00 pm ET
    .. get tips, updates on new data developments, answers to questions.

  • Join the User Group to receive updates about accessing, intergating & using geographis, demographic, economic data.

  • Join the GeoSpatial Analytics Group; receive updates; Q&A forum,

  • Send your question through the Contact Us form.

  • E-mail us with questions or comments.



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