Tag Archives: CV XE GIS

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.

115th Congressional Districts: Analysis and Insights

.. interpretative data analytics; tools, data & methods ..  this section is focused on 115th Congressional District geographic, demographic and economic patterns and characteristics. Use tools and data reviewed here to examine/analyze characteristics of one congressional district (CD) or a group of CDs based on state, party or other attribute. Use the GIS resources described here for general CD reference/pattern/analytical views, to examine current demographics and demographic change and for redistricting applications. See this related Web section for more details.

Examining the 115th Congressional Districts
• the 115th Congress runs from January 2017 through December 2018.
• FL, MN, NC, VA have redistricted since the 114th CD vintage;
  .. some 115th CDs have new boundaries compared the 114th CDs.
• view, rank, compare CDs using the interactive table.
  .. table uses ACS 2015 data for 115th CDs & include incumbent attributes.
  .. examine districts by party affiliation.
• use these more detailed 114th CD interactive tables
  .. data based on 2015 American Community Survey – ACS 2015.
  .. corresponding data for the 115th CDs from ACS 2016 available Sept 2017.
• use the new GIS project including 114th & 115th CDs described below.
  .. create CD thematic and reference maps;
  .. examine CDs in context of other geography & subject matter.
• join us in the April 25 Data Analytics Lab session

Visual Analysis of Congressional Districts
The following views 1) provide insights into patterns among the 115th CDs and 2) illustrate how 114th to 115th geographic change can be examined. Use CV XE GIS software with the GIS project to create and examine alternative views.

Patterns of Household Income by 115th Congressional District
The following graphic shows the patterns of the median household income by 115th Congressional District based on the American Community Survey 2015 1-year estimates (ACS2015). The legend in the lower left shows data intervals and color/pattern assignment

.. view developed with ProximityOne CV XE GIS and related GIS project.

Charlotte NC-SC Metro Area
  – with 114th/115th Congressional District 12

The following graphic shows North Carolina CD 12 with 114th boundary (blue) and 115th boundary (pale yellow) and Charlotte metro bold brown boundary. Click graphic for larger view with more detail. Expand browser window for best view.

.. view developed using the CVGIS software.

• View zoom-in to Charlotte city & Mecklenburg County.

115th Congressional District Interactive Table
Use the interactive table to examine characteristics of one congressional district (CD) or a group of CDs. The following graphic illustrates use of the interactive table. First, the party type was selected, Democratic incumbents in this example. Next, the income and educational attainment columns were selected. Third, the set of districts were sorted on median household income. It is quick and easy to determine that CA18 has the highest median household income and that the MHI is $1,139,900. Try using the table to examine districts 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.

Creating Custom School District Maps

…tools & data to map & geospatially analyze school districts. Ready-to-use state-by-state GIS projects may be downloaded enabling you to view and create custom maps almost instantly. Benefit from the power of using GIS software to perform tasks not available on Web-based mapping options. Use the latest school district and related shapefiles. See more information about using these resources in this related Web section.

Federal Revenue per Student by School District
Create views similar to the one shown below. Optionally combine layers as illstrated here by showing four Texas metros.

.. view developed with CV XE GIS and related GIS project.

Extending Reference and Analytical Possibilities

Texas by School District
Examine reference maps at the state, regional or local level. Optionally combine with roads/streets and other layers.

Patterns of Economic Prosperity by School District
Select from many ready-to-use demographic-economic subject matter items to create custom pattern views.

Drill-down — Houston Metro Area by School District
Zoom-in to a school district of interest. Set attributes of district as shown here.

County/School District
Visually examine the boundaries or school districts and counties. This view shows Harris County, TX area; select a county of interest.

Drill-down to Street Level
Add road/street and other layers. Drill-down within Fort Bend ISD, Houston metro, showing general earth surface features with streets layers. Mouse used to click on street (see pointer) and display mini-profile of street segment attributes.

Use for Analysis, Reference or in the Classroom
Schools and teachers: consider using these resources for classroom use. Familiarize students about how GIS resources can be used with a minimum of learning time and no cost. Enable students to use their own geography and adapt that learning to more general geography. See related Mapping Statistical Data ready-to-use GIS projects.

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.

Tools to Analyze County Demographic-Economic Characteristics

.. demographic-economic characteristics of counties are essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine these data for all counties in the U.S. This annual update includes geographic area characteristics based on ACS 2015 data.  The tools/data are organized into four related sections summarized below.

1. General Demographics
View interactive table at http://proximityone.com/us155dp1.htm
Patterns of School Age Population by County
Use GIS tools to visually examine county general demographics as illustrated below. The following view shows patterns of percent population ages 5 to 17 years of age by county — item D001-D004-D018 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

2. Social Characteristics
View interactive table at http://proximityone.com/us155dp2.htm 
Patterns of Educational Attainment by County
– percent college graduate
Use GIS tools to visually examine county social characteristics as illustrated below. The following view shows patterns of percent college graduate by county — item S067 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

3. Economic Characteristics
View interactive table at http://proximityone.com/us155dp3.htm 
Patterns of Median Household Income by County
Use GIS tools to visually examine county economic characteristics as illustrated below. The following view shows patterns median household income by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

4. Housing Characteristics
View interactive table at http://proximityone.com/us155dp4.htm 
Patterns of Median Housing Value by County
Use GIS tools to visually examine county housing characteristics as illustrated below. The following view shows patterns median housing value by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

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.

Accessing & Using ZIP Code Demographics

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur.

… February 2017 updates .. 5 ways to access/analyze the most recent estimates of median housing value and other subject matter by ZIP Code area .. updates on accessing/downloading/using American Community Survey (ACS1115) 5-year estimates. See more detail in related Web section.

Site analysis (Option 5 below)
– create site analysis profiles from a location/ZIP code.

Contents
Five data access and use options, listed in the links below, are reviewed. Each method illustrates how ZIP code demographic-economic data can be accessed/ analyzed/used in different contexts. The most basic data access/data download is illustrated in Option 3. The following links open new windows that take you to the related section with more detail.
Option 1 – View the data as a thematic pattern map.
Option 2 – View, compare, rank query data in interactive tables.
Option 3 – Access data using API Tools; create datasets.
.. Option 3a – Extended ZIP Code subject matter access.
.. Option 3b – ZIP code urban/rural data access.
.. Option 3c – Additional API ACS data access resources.
Option 4 – View $MHI in structured profile in context of related data.
Option 5 – Site analysis – view circular area profile from a location.

Related ZIP Code Data Access & Use sections
Interactive access to demographics based on an address
Summary of ZIP Code Data Resources & Tools
10 Reasons to use Census Tracts Versus ZIP Codes
Analyzing Census Tract Demographics by ZIP Code Area
ZIP Code to Census Tract Equivalence Table
ZIP Code Urban/Rural Geography & Demographics
Mapping ZIP Code Demograhics
Housing Price Index by 5-digit ZIP Code – time series; annual updates
Housing Price Index by 3-digit ZIP Code – time series; quarterly updates
ZIP Code Business Establishment, Employment & Earnings by industry
ZIP Code Retail Trade Establishment & Sales by industry
ZIP Code Equivalence Tables — ZIP Code to School District

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.