Tag Archives: GIS

Urban Area Demographic Trends 2010-15

.. tools and analytics to examine all urban areas with particular focus on Urbanized Areas and demographic change between 2010 and 2015 .. examining urban areas in context of metropolitan areas .. the four fastest growing Urbanized Areas (UAs) from 2010 to 2015 were in Texas. McKinney, TX UA led the nation with an increase of 27.5% in total population. View, rank, compare 2010 and 2015 demographic characteristics for UAs using the interactive table in this related section. Urban areas (Urbanized Areas and Urban Clusters) are important for many reasons. More than metros and cities, urban area geography better reflects how the urban and rural population is changing. Both metros and cities can change geographic boundary over the years. Urban areas are based on Census 2010 and unchanging between 2010 and 2020. Annual demographic updates are available from the American Community Survey (ACS 2015).

This section is focused on tools and analytics to examine all urban areas with particular focus on Urbanized Areas and demographic change between 2010 and 2015. Use the interactive table >in the related section to view, rank, query urban areas and demographic change for larger urban areas. Use the related GIS tools and data to develop related thematic and relationship maps. Perform geospatial analysis of geographic and demographic-economic characteristics using the resources we have developed. Gain insights into patterns that might affect you. Use these resources to collaborate on how, where, what, when and why of change.

McKinney TX Urbanized Area in Context of City
The McKinney, TX UA (bold orange pattern) is shown in context of McKinney city (cross-hatched area) and other urban areas (lighter orange pattern). It is easy to see that some parts of the city are rural and that the UA extends beyond the city in many areas. See more about the McKinney UA and in comparison to other urban areas using the interactive table.


– view created using CVGIS software and related GIS project.

Most Urbanized Areas (UAs, 435 of 487) have population 65,000 population or more resulting in the availability of annual demographic-economic estimates. Data are fresher than available for smaller urban areas (ACS 5-year estimates for areas under 65,000). This means more current data to assess more recent characteristics. As annual data are available UAs enabling analysis of change over time. The “2010s” marks the first time these refreshed, time series-like data have been available for urban areas. Businesses and those examining change performing market analysis benefit from the ability to examine characteristics or urban areas in combination with counties and metros.

Houston Urbanized Area in Context of Houston Metro
The Houston metro has a bold brown boundary. It is easy to see how the Houston UA (darker orange fill pattern) geographically relates to the metro. Other urban areas (all) are shown with a lighter orange fill pattern. It is easy to see the urban/pattern character of the general region. While the Houston UA is the largest, there are four UAs that intersect with Houston metro. Use the interactive table below to view their names and characteristics.


– view created using CVGIS software and related GIS project.

Urbanized Areas tend to be associated with metropolitan areas having a similar name. But very often there are multiple UAs within a metro; sometimes one is not dominant. Often there are several UAs in a metro having similar size. Use the interactive table below to view the relationship of UAs and metros (CBSAs).

Using Interactive Table
Use the interactive table to view, rank, compare, query urban areas based on a selection of demographic measures. The following graphic illustrates how the table can be used. Click graphic for larger view.

The graphic shows the urbanized areas ranked in descending order based on 2010-2015 population. The rightmost column shows the area percent change in population over the period.

Fastest Growing Urbanized Areas, 2010-15

Try it yourself. Use the table to examine urban area patterns and characteristics based on your selected criteria.

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.

School District Demographic Trends: 2010-2015

.. data and tools to examine how school districts of interest are changing … based on total population, the largest 10 school districts in 2015, all experienced an increase in total population over the period 2010-2015. Five of these districts had a decrease in school age population (ages 5-17 years). Four of these districts had a decrease in the number of related children in families ages 5-17 years. See characteristics of districts in this interactive table. See the related Web section for more details.

School Districts with 2015 Population 100,000 or More
More than 600 of the total 13,245 school districts have a total 2015 population of 100,000 or more (red markers).

– view developed with CVGIS software and related GIS project.

Using New 2015 Estimates Released December 2016
– for use in 2017 ESEA Title I Allocations
Analyze annual demographic data for each U.S. school district for the period 2010 through 2015. These data include the Federal official 2015 estimates available for all districts. Developed for use as inputs for the ESEA Title I allocation formula, the data have broader uses of interest to school district demographics stakeholders. Use the interactive table in this section to view, rank, compare, query demographic characteristics of districts of interest.

The annual estimates for each school district include:
• total population
• number of children ages 5 to 17
• number of related children ages 5 to 17 in families in poverty

Using Interactive Data Tools
Use the interactive table to view, rank, compare, query ZIP codes based on a selection of demographic measures. The following graphics illustrate how the table can be used. Click graphic for larger view.

Total Population — 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

School Age Population — 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

Related Children Ages 5-17 in Poverty
– 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

Try it yourself. Use the table to examine a set of districts on your selected criteria in for a state/area of interest.

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.

Personal Consumption Expenditures by State: Updates & Pattern Analysis

.. data and tools to develop insights into personal consumption patterns by state .. growth in state personal consumption expenditures (PCE) – the measure of goods and services purchased by or on behalf of households – decelerated to 3.6 percent on average in 2015 from 4.4 percent in 2014. In 2015, PCE growth ranged from 1.5 percent in Wyoming to 5.0 percent in Florida. PCE by state data for 16 expenditure categories are shown for the U.S. and by state in the interactive table. See related Web section for more detail.

Per Capita Personal Consumption Expenditures
  — Patterns & Characteristics by State

The following graphic shows patterns of percent change in total PCE 2010-2015 by state labeled with 2015 per capita total PCE. Use CVGIS project to examine PCE by types and different years. Integrate additional subject matter and types of geography. Click graphic for larger view with details.

– views developed with CVGIS and related GIS project & datasets.

In 2015, the fastest growing categories of expenditures across all states were food services and accommodations, health care and other nondurable goods. These categories along with housing and utilities were also the largest contributors to growth in total PCE by state.

Per capita PCE by state measures average PCE spending per person in a state. Across all states, per capita total PCE was $38,196. Per capita PCE by state ranged from a high of $49,717 in Massachusetts to a low of $29,330 in Mississippi.

Personal Consumption Expenditure by Category
PCE by state is the state counterpart of the Nation’s personal consumption expenditures (PCE). PCE by state measures the goods and services purchased by or on behalf of households and the net expenditures of nonprofit institutions serving households (NPISHs) by state of residence for all states and DC. PCE by state reflects spending on activities that are attributable to the residents of a state, even when those activities take place outside of the state. Per capita PCE by state measures average PCE spending per person in a state.

Interactive Analysis
The following two graphics illustrate use of the interactive PCE table. View 1 shows Texas by PCE type ranked in ascending order on percent change from 2010 to 2015 (ranked on far right column). View 2 shows Texas by PCE type ranked in descending order on percent change from 2010 to 2015 (ranked on far right column). Use the table to examine characteristics of states of interest. Click graphic for larger view.

Texas by PCE Type; Ranked Ascending on PCPCE Change 2010-15

Texas by PCE Type; Ranked Descending on PCPCE Change 2010-15

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.

Monthly Local Area Employment Situation; 2015-2016

.. this update on the monthly and over-the-year (August 2015-August 2016) change in the local area employment situation shows general improvement. Yet many areas continue to face challenges due to both oil prices, the energy situation and other factors.  This section provides access to interactive data and GIS/mapping tools that enable viewing and analysis of the monthly labor market characteristics and trends by county and metro for the U.S. See the related Web section for more detail. The civilian labor force, employment, unemployment and unemployment rate are estimated monthly with only a two month lag between the reference date and the data access date (e.g., August 2016 data are available in October 2016).

Unemployment Rate by County – August 2016
The following graphic shows the unemployment rate for each county.

— view created using CV XE GIS and associated LAES GIS Project
— click graphic for larger showing legend details.

As shown in the illustrative interactive table view below, seven of the ten MSAs having the highest August 2016 unemployment rate were in California. Use the table to examine characteristics of counties and metros in regions of interest. As apparent from the monthly patterns shown in the table, some areas are impacted by season factors, but others are not.

View Labor Market Characteristics section in the Metropolitan Area Situation & Outlook Reports, providing the same scope of data as in the table below integrated with other data. See example for the Dallas, TX MSA.

The LAES data and this section are updated monthly. The LAES data, and their their extension, are part of the ProximityOne Situation & Outlook database and information system. ProximityOne extends the LAES data in several ways including monthly update projections of the employment situation one year ahead.

Interactive Analysis
The following graphic shows an illustrative view of the interactive LAES table. Seven of the ten MSAs having the highest August 2016 unemployment rate were in California (ranked on far right column in descending order). Use the table to examine characteristics of counties and metros in regions of interest. Click graphic for larger view.

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 Diversity by State 2015

.. states with the highest race/origin diversity in 2015 were Hawaii, California and New Mexico. States with the lowest diversity were West Virginia, Maine and Vermont. Higher levels of diversity tend to provide a better framework for understanding, tolerance and cooperative developments and progress. Use the interactive table to view, rank, compare states on the diversity index, percent population by race/origin and population by race/origin.

What is the chance that the next person I meet will be different from me, in terms of race origin? The Diversity Index is a number on a scale from 0 to 100 that shows the chance that two people chosen randomly from an area will be different by race and origin. A higher number means more diversity, a lower number, less diversity.

2015 Diversity Patterns by State
The following graphic shows patterns of the percent non-White population (see legend in lower right) the 2015 diversity index as a label for each state

– view developed using CVGIS and related project.
– use the software and project to create variations of this view; add your own data.

See the related section on diversity. USA TODAY used ProximityOne population projections to 2060 by county to examine diversity trends between 2010 and 2060 – a 50-year trend analysis.

This section provides a new estimate of the 2015 diversity index for the U.S. by state based on the latest data. The 2015 population by race/origin estimates are the most recent official Federal U.S. by state data (updated annually). See more about these estimates; access individual state profiles. In addition, the computational methodology is summarized. The U.S. by state demographics dataset is provided as a part of the U.S. State Diversity GIS project. Analyze alternative computations and views of the diversity index.

Examining the 2015 Diversity Index & Race/Origin by State
Some illustrative examples of the interactive table to view … click the Diversity Index column header cell in the table to sort states in ascending order on the Diversity Index. Click that column header cell again to sort states/rows in descending order on the Diversity Index. Find state(s) of interest; see what peer group those states are in based on demographic measures of interest.

Double-click the %Hispanic column header cell in the table to see that New Mexico has the highest %Hispanic population. Click the “population columns only” button below the table, navigate to far right and double-click the Hispanic column header cell to see that California has the largest Hispanic population.

Interactive Table Example
The following graphic illustrates use of the interactive table. States are ranked in descend order on the 2015 Diversity Index.

– Click graphic for larger view

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.

Mapping Census Tract Demographics

.. using visual data analytics and developing business intelligence .. this section provides a 4-step procedure to develop thematic pattern and reference maps for census tracts. The focus of this section is on mapping Census 2010 census tracts using data from the 2014 American Community Survey (ACS2014). A similar set of steps could be followed for Census 2000 tracts with Census 2000 data or Census 2010 tracts with Census 2010 demographics or different vintage ACS data. Steps summarized here can be used with most any Windows-based computer having Internet access. See the related full Web section with more details.

• how do customers and sales relate to market area characteristics?
• is their a better configuration of locations or service areas?
• how can you more effectively examine customer and sales patterns?
• what and where are areas of missed opportunities?

See related sections:
Using GIS & Data Analytics
Mapping Statistical Data

Benefits of this section include providing help for those:
• having a specific interest in mapping census tract demographics.
• with little or no experience in using GIS.
• getting started with CVGIS.

These resources and instructions provide a real, not demo, valuable tool that anyone can use, without fee, to create county by census tract thematic pattern maps. Use any of the “richer” demographic-economic data (not just median household income) from the latest ACS 5-year data (see scope — table shells xls).

The steps described below can be performed with any version of CVGIS, including the no fee version. Start from scratch and develop thematic pattern maps like that shown below. Questions, need help? See the FAQs. Call with questions – 888.364.7656. Or, use this form and put questions in the text section.

While this application is focused on ACS 2014 median household income for Dallas County, TX census tracts, you can follow these steps for other areas and subject matter. In your own applications, choose any ACS subject matter for any county/area of interest. The following view shows the end result of steps described below. Choose your own county of state; choose your own subject matter; select your own colors and labeling; choose your own zoom view; and more. Dallas Metro Situation & Outlook.

Patterns of Economic Prosperity; Dallas County, TX by Tract

Mapping Census Tracts Demographics Steps
These steps should take an inexperienced user 10-15 minutes to develop a new CVGIS project view. Steps can be performed at separate times.
Click on a link to view step-by-step instructions.
1. Install CVGIS
2. Get census tract shapefile
3. Get census tract subject matter data (median household income or other)
4. Create map view(s)

Create your own maps for your own county/tracts for your own subject matter.

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.