Category Archives: Census Tracts

Location-Based Demographics Update

.. tools you can use to examine characteristics of addresses/locations .. many of us are interested in knowing attributes of addresses or locations. Often knowing address latitude-longitude is important so that the addresses can be viewed on a map .. see below.  Some might need to know what census block, or other geography, in which an address is located .. or what school district is an address located in.  Others need to know demographic-economic attributes of the neighborhood or area where an address is located.  These types of attributes can be obtained for addresses using the Location-Based Demographic (LBD) tools.  The LBD tool has just been made a part of the CV XE GIS software.  The LBD tool is available in all versions of CV XE GIS, including the no fee User Group version. See more about using the LBD tools to look-up and analyze address/location attributes.

Viewing Geocoded Addresses on a Map – automatically
The following view shows addresses geocoded using the LBD tool. Markers show addresses of 27 Trader Joe’s locations in the Los Angeles area. LBD automatically creates a shapefile that is added to your GIS project. The markers are labeled with population ages 18 and over in the corresponding census tract. Marker color/styles reflect different levels of median household income. A separate census tract layer shows patterns of economic prosperity.

Click graphic for larger view. Expand browser window. A mini profile is displayed showing demographic-economic attributes for the marker at pointer.

View the locations without the tract thematic pattern layer:

Make similar views for your addresses.

Get Started Using the LBD Tool
1 – join the User Group .. click here to join (no fee).
2 – run the installer to install on a Windows machine .. requires your userid.
3 – with CV XE GIS running, click Tools>Find Address/LBD
    enter an address .. a form appears showing characteristics of the address.
4 – see more about using the tools on the LDB page.

GeoStatistical Data Analytics Learning Sessions
We are developing a series of “GeoStatistical Data Analytics” (GSDA) Learning Sessions/modules. One of these is focused on using the LBD tools and methods in the broader context of data analytics. We plan to develop the GSDA models for self-guided use by analysts/practitioners as well as in the classroom setting with teacher/student materials. Upcoming blog posts will describe the program in more detail.

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Communities of U.S. Foreign Born Population

.. examining the U.S. foreign born population and how/where foreign born by country of origin communities exist .. the U.S. foreign born population includes anyone who is not a U.S. citizen at birth, including those who have become U.S. citizens through naturalization. The native born population includes anyone who is a U.S. citizen at birth, including those who were born in the U.S., Puerto Rico, a U.S. Island Area or abroad to U.S. citizen parent(s). Use the interactive table to examine foreign born population by country by census tract.

As of 2016, the U.S. foreign born population was estimated to be 43,739,345 compared to the total U.S. population of 323,127,515 (13.5%). See the related Web section for more detailed information about the U.S. foreign born population.

Chinese Foreign Born Population & $MHI Patterns; New York City Area
– red markers show census tracts with 500 or more Chinese foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Importance of the Foreign Born Data … knowing about the geographic, demographic and economic attributes of the foreign born population tells us about the size, distribution and characteristics of the immigrant population. Projections of the foreign born population tell us how our country will grow. See more in this related section.

An Illustrative View. The Chinese foreign born population is used in the graphic below to illustrate the distribution of U.S.national scope foreign born population. Other population groups could have been used. Based on the ACS 2016 5-year estimates, there are 851 census tracts having 500 or more Chinese foreign born population (of a total 73,056 tracts). Twenty of the 25 tracts having the largest number of Chinese foreign born population are located in New York City. Determine which tracts using the related interactive table.

Chinese Foreign Born Population Patterns
– China is one of 162 country/country groups reviewed in this section
– red markers show census tracts with 500 or more Chinese foreign born
– the distribution is wide and difficult to gain insights

– view developed with CV XE GIS software using related GIS project and datasets.

Communities of Foreign Born Population
These additional views illustrate how selected foreign born country population clusters in many cases. Some develop communities without formal boundaries or any formally designated structure. Use the GIS project and tools to develop your own views for country combinations and areas of interest.

India Foreign Born Population & $MHI Patterns; New York City Area
– red markers show census tracts with 500 or more India foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Asia Foreign Born Population & $MHI Patterns; Houston, TX Area
– red markers show census tracts with 500 or more Asia foreign born
.. all Asia countries (item 047 in country list above in this section
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Cuba Foreign Born Population & $MHI Patterns; Miami, FL Area
– red markers show census tracts with 500 or more Cuba foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Vietnam Foreign Born Population & $MHI Patterns; Los Angeles, CA Area
– red markers show census tracts with 500 or more Vietnam foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Using the Interactive Table
— Foreign Born Population by Country by Census Tract

The following graphic illustrates use of the interactive table to examine census tracts in Queens County, NY (code 36081, New York City). South East Asia countries (columns) have been selected and sorted in descending order on China. The table shows the size of the China foreign born population by census tract; the census tract code is shown in the left column.

Use the interactive table and examine areas of interest to you.

Data Analytics Web Sessions
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

 

Congressional District/State Legislative District Data Analytics Sessions

.. join me in the Congressional District/State Legislative District Data Analytics Sessions .. http://proximityone.com/cdsld/cdsld_vasessions.htm .. face-to-face sessions in the Washington, DC area.

Legislative Districts & Patterns of Neighborhood Economic Prosperity
Census tracts labeled with median household income in context VA House District 11 (bold blue boundary) in Fairfax County, VA. Use the GIS project to examine any state legislative district.

— click for larger view
— view created using CV XE GIS & associated GIS project.

CDSLD Sessions These sessions are focused on tools, data and analytical methods relating to Congressional Districts (115th CDs) and State Legislative Districts (2016 cycle SLDs). We focus on national and Virginia CDs and SLDs in context of the total population, voting population, the Citizen Voting Age Population characteristics and patterns with drill down to census blockblock groupcensus tractelection precinctcity/placeZIP codecountymetro and other geography.

Program details as PDF: http://proximityone.com/cdsld/cdsld_vasessions.pdf.

Anyone may attend. There is no fee. There is no promotional content. Sessions are presented by Warren Glimpse an expert on the topics covered. Learn more about the potentials of using these tools, data and methods. Get answers to your questions to learn more about what data are available, options to access the data, how to integrate these data with other data and insights into how you can use and the data. Attend one or many sessions. While there are core topics, new related material and updates are covered in each session. Join in as a continuing program. Develop and extend data analytics skills.

Patterns of Economic Prosperity by VA Senate District
– Virginia Upper/Senate SLDs by Median Household Income

– click graphic for better quality view; districts labeled with district code

More About Congressional Districts & State Legislative Districts
See the related section for more information:
• 115th Congressional Districts ..
.. Main .. http://proximityone.com/cd115.htm
.. demographic-economic tables http://proximityone.com/cd161dp1.htm
• State Legislative Districts Main .. http://proximityone.com/sld2016.htm
.. with demographic-economic interactive table
• Virginia State Legislative Districts .. http://proximityone.com/sld_va.htm
.. interactive table with incumbency details

CDSLD Data Analytics Web Sessions
Unable to join the face-to-face session? Join me in a Data Analytics Web session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

TractWatch — Examining Small Area Change

Understanding the demographic-economic landscape for small area geography and how it is changing is vital for many stakeholders. Businesses and other organizations need to know how their market/service areas are changing … getting answers to questions like knowing about recent trends, where we are now and the how/where/how much things might change in the future.

Examining Tract Change
The following view shows census tracts (black boundary) located in the northeast Houston, TX area. Tracts are labeled with 2017 population estimates and percent population change from 2010 to 2017. Tract geography and characteristics are shown in context of three cities/places — Houston (orange cross-hatch), Humble (blue) and Atascocita CDP (green). It is easy to see what census tracts intersect with what cities and where. The pointer/hand is located in census tract 48-201-240902, partly intersecting with Humble city. The tract 2017 population of 12,984 reflects an increase of 10.4% since 2010. The dark brown bold boundary at the top of this tract is the Harris County, TX boundary.

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. create views like this for any area in the U.S.; add your own data.

TractWatch tells us which tracts in a region of interest changed during the past year based on quarterly observable data with only a one quarter lag.

Census Tracts & TractWatch
TractWatch is a new tool/service focused on examining recent demographic-business change for each census tract. These approximate 74,000 geographic areas cover the U.S. wall-to-wall and averaged 4,000 population as of Census 2010. Tracts have a generally stable geography between decennial censuses and are coterminous with county boundaries. Tracts cover the U.S. with more than a 2-to-1 ratio compared to ZIP code areas (see tract-ZIP relationship table).

Integrated with Situation & Outlook
TractWatch insights are developed through the use of the ProximityOne Situation & Outlook (S&O) database and information system — a part of S&O demographic-economic estimates and projections developed and updated annually. The 2017 vintage tract estimates and projections (annual data) cover the period 2010 through 2022 (5-year projection).

TractWatch – Monitoring Change
As a part of the S&O annual estimates and projections development, a range of measures are updated quarterly at the census tract level. Quarterly data are developed that include population, housing units, vacant units, households and business establishments.

There is only a one-quarter lag in the availability of observable census tract data. For example, observable 2017Q1 data can be added to the S&O database in July 2017. Data are analyzed and converted into a TractWatch national dataset.

Situation & Outlook Reports
The Situation & Outlook Reports (S&O Reports) are updated weekly, for the U.S. and each county, metro and state. TractWatch is a part of the “Recent Change and Outlook” S&O Report section and updated quarterly. See schedule of updates the shows when TractWatch is updated.

The S&O Reports (metro and county) Recent Change and Outlook section includes a list of census tracts which have shown significant change over the past year for that geography. A table of typically 10-to-25 key tracts are listed in a table with selected demographic-business change attributes.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Examining Houston Metro Demographic-Economic Characteristics

.. tools & data to examine metro demographic-economic characteristics .. this Houston, TX metro focused section is one of several similar metro sections that will be covered in weeks ahead.  Each metro-focused section provides a summary of tools and data that can be used to view, rank, compare, analyze conditions and trends within the metro and this metro relative to other metros, regions and the Nation.  The ready-to-use GIS project/datasets provide the basis for extended data/geographic views and analysis immediately.  See more detail about topics covered in this related Web section.

Relating your data to demographic-economic characteristics and trends in a region involves more than information provided by a report or set of statistical tables. It is important to use your data to be able to identify areas of missed opportunity and competitive position. It is important to have a “10,000 foot” view as well as understanding individual neighborhoods and market/service areas. Geographic Information System (GIS) tools, with the right set of geographic, demographic and economic data can facilitate decision-making through the use of visual and tabular data analytics.

This section provides information on installing and using the Houston Metro Demographic-Economic GIS software and project/datasets. This same scope of data, tools and operation is available for any metro, state or combination.

10,000 Foot View
The following graphic shows patterns of median household income by census tract for the Houston metro area. This is the start-up view when using the GIS tools and data described below. The color patterns/intervals are shown in the highlighted layer in legend at left of map window. Use the GIS tools described below to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CVGIS software.

See more about census tracts; see tracts main page.

Several additional views follow, developed using this same GIS project. These views illustrate different levels of geographic granularity and patterns of different subject matter.

Median Household Value by Block Group
See more about block groups; see block groups main page.

.. view developed using the CVGIS software.

Population/Housing Unit by Block
See more about census blocks; see census block main page.

.. view developed using the CVGIS software.

Zoom-in to Sugarland/Fort Bend County
See more about cities/places; see cities/places main page.
Access data for any city using interactive table.

.. view developed using the CVGIS software.

Further Zoom-in Showing Street/Road Detail
See more about streets.

.. view developed using the CVGIS software.

Additional Information
See the related Houston metro Situation & Outlook Report.

Using the GIS Software and Project/Datasets
(requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… requires UserID; take all defaults during installation
2. Download the Houston Metro GIS project fileset
… requires UserID; unzip Houston Metro GIS project files to local new folder c:\p1data
3. Open the c:\p1data\us1_metros_houston.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\p1data\us1_metros_houston.gis
4. Done. The start-up view is shown above.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Developing Geographic Relationship Data

.. tools and methods to build and use geographic relationship files … which census blocks or block groups intersect with one or a set of school attendance zones (SAZ)? How to determine which counties are touched by a metropolitan area? Which are contained within a metropolitan area? Which pipelines having selected attributes pass through water in a designated geographic extent? This section reviews use of the Shp2Shp tool and methods to develop a geographic relationship file by relating any two separate otherwise unrelated shapefiles. See relasted Web page for a more detiled review of using Shp2Shp.

As an example, use Shp2Shp to view/determine block groups intersecting with custom defined study/market/service area(s) … the only practical method of obtaining these codes for demographic-economic analysis.

– the custom defined polygon was created using the CV XE GIS AddShapes tool.

Many geodemographic analyses require knowing how geometries geospatially relate to other geometries. Examples include congressional/legislative redistricting, sales/service territory management and school district attendance zones.

The CV XE GIS Shape-to-Shape (Shp2Shp) relational analysis feature provides many geospatial processing operations useful to meet these needs. Shp2Shp determines geographic/spatial relationships of shapes in two shapefiles and provides information to the user about these relationships. Shp2Shp uses the DE-9IM topological model and provides an extended array of geographic and subject matter for the spatially related geometries. Sh2Shp helps users extend visual analysis of geographically based subject matter. Examples:
• county(s) that touch (are adjacent to) a specified county.
• block groups(s) that touch (are adjacent to) a specified block group.
• census blocks correspond to a specified school attendance zone.
• attributes of block groups crossed by a delivery route.

Block Groups that Touch a Selected Block Group
The following graphic illustrates the results of using the Shp2Shp tool to determine which block groups touch block group 48-85-030530-2 — a block group located within McKinney, TX. Shp2Shp determines which block groups touch this block group, then selects/depicts (crosshatch pattern) these block groups in the corresponding GIS map view.

Geographic Reference File
In the process, Shp2Shp creates a geographic relationship file as illustrated below. There are six block groups touching the specified block group. As shown in the above view, one of these block groups touches only at one point. The table below (derived from the XLS file output by Shp2Shp) shows six rows corresponding to the six touching block groups. The table contains two columns; column one corresponds to the field GEOID from Layer 1 (the output field as specified in edit box 1.2 in above graphic) and column 2 corresponds to the field GEOID from Layer 2 (the output field as specified in edit box 2.2 in above graphic). The Layer 1 column has a constant value because a query was set (geoid=’480850305302′) as shown in edit box 1.3. in the above graphic. Any field in the layer dataset could have been chosen. The GEOID may be used more often for subsequent steps using the GRF and further described below. It is coincidental that both layers/shapefiles have the field named “GEOID”.

Layer 1 Layer 2
480850305302 480850305272
480850305302 480850305281
480850305302 480850305301
480850305302 480850305311
480850305302 480850305271
480850305302 480850305312

Note that in the above example, only the geocodes are output for each geography/shape meeting the type of geospatial relationship. Any filed within either shapefile may be selected for output (e.g., name, demographic-economic field value, etc.)

How it Works — Shp2Shp Operations
The following graphic shows the settings used to develop the map view shown above.

See related section providing details on using the Shp2Shp tool.

Geographic Relationships Supported
The Select Relationships dropdown shown in the above graphic is used to determine what type of spatial relationship is to be used. Options include:
• Equality
• Disjoint
• Intersect
• Touch
• Overlap
• Cross
• Within
• Contains
See more about the DE-9IM topological model used by Shp2Shp.

Try it Yourself

See full details on how you can use any version, including the no fee versin, of CV XE GIS to use the Shp2Shp tools. Here are two examples what you can d. Use any of the geospatial relatoinships. Apply your own queries.

Using Touch Operation
Select the type of geographic operation as Touch. Click Find Matches button. The map view now shows as:

Using Contains Operation
Click RevertAll button. Select the type of geographic operation as Contains. Click Find Matches button. The map view now shows as:

Relating Census Block and School Attendance Zones
The graphic shown below illustrates census blocks intersecting with Joyner Elementary School attendance zone located in Guilford County Schools, NC (see district profile). The attendance zone is shown with bold blue boundary. Joyner ES SAZ intersecting blocks are shown with black boundaries and labeled with Census 2010 total population (item P0010001 as described in table below graphic). Joyner ES is shown with red marker in lower right.


– view developed using CV XE GIS and related GIS project; click graphic for larger view

See more about this application in this related Web section.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Creating Maps & GIS Projects

.. follow these steps to create custom maps & GIS projects .. while maps are “everywhere,” there is a continuing need to make new maps. Reasons for this include changing underlying geography, new features (like stores or customers to be viewed), visually examining geographic relationships not available elsewhere (e.g., census tracts and ZIP codes), different geographic depictions for an area (smoothed versus precise vertices) and other reasons. A map can provide view(s) that relate to geospatial analysis; map visualization can be indispensable (showing road features adjacent to selected properties).

View of Initial Map Objective — University Park, TX; Dallas Metro area
Census tracts (black boundary) shown with census tract code as label.

— view developed using CV XE GIS software

Follow steps in this section to make a map like above for any area in the U.S. This section provides an overview of how to use the CVGIS software to quickly build a map. It is actually more than a map, it is the process of building a GIS project. A map is one rendering that can be displayed, and optionally published, using a GIS project. Map/GIS project development steps reviewed here can be performed using the no fee CVGIS software and no fee data resources, CVGIS Levels 1 and higher can save the GIS project and have additional geography available. With geographic extension, the process illustrated here can work for any place in the world. A GIS project is a file itself that contains references to map files (shapefiles) located on your computer. Once a GIS project has been created and saved, it can be immediately opened with CVGIS using the File>Open operation. After turning your computer off, and restarting it, the GIS project can be re-opened to display the same view as saved in an earlier session.

No Previous GIS/Mapping Experience Required
This section is designed for use by anyone including those with no previous GIS/mapping experience. Requirements are a Windows computer and Internet access. This section is a part of a module used in the Certificate in Data Analytics and the CVGIS Certification Programs. Developers can also benefit from this and related tutorials to learn more about how GIS can be integrated with other data analytics tools and methods.

Making Maps Steps
The objective of this session is to develop a map (and GIS project) to view characteristics of census tract “48113019301”. The first step in making a map (GIS project) is to have a clear objective. This 11 character geocode uniquely identifies this Census 2010 census tract among all other 73,057 tracts in the U.S. See more about census tract geography and geocodes. While this application shows a process for adding only two layers, it could be extended by adding more. Similarly, while this application uses a census tract boundary files (shapefile), alternatives are census blocks, block groups, ZIP code areas, among others.

These steps should take an inexperienced user 10-15 minutes to develop a new CVGIS project view. If anything becomes confused, close the program and start over.
Step 1. Install CVGIS (1/1/2017 or later version)
Step 2. Open Base Project
Step 3. Get Census Tract Shapefile
Step 4. Get Roads Shapefile
Step 5. Modify Map View
Step 6. Optionally Save GIS Project

The view should now be similar to the view at the top of this section.

Next Steps
Try the process yourself with geography of interest to you. View/use other “Creating Maps & GIS Projects” tutorials to learn about:
• integrating subject matter
• developing and using thematic maps
• creating site profiles

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.