Tag Archives: mapping

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.

Examining County Migration: 2010-2016

.. tools and data to examine U.S. by county migration 2010 to 2016 … is the population moving away or into your counties of interest? What are the trends; what is causing the change? What are the characteristics of the population moving in and out? How might this impact your living environment and business?

The total net international migration among all counties 7/1/2010 – 7/1/2016 was 5,641,260, an annual average of 940,432. The sum of net domestic migration among counties is zero by definition, but domestic migration among counties varies radically by size and direction. This section is focused on U.S. by county migration from 2010 to 2016. Migration is one component of change used to develop population estimates. See more about county population estimates and components of change in this related Web section.

Largest 10 Counties Based on 2016 Population
This table shows how domestic migration varies widely among the most populated counties. Use this interactive table to develop your own custom views for counties of interest.

Patterns of Population Change by County, 2010-2016
– the role and impact of migration
The following graphic shows how counties have gained population (blue and green) and lost population (orange and red) during the period 2010 to 2016. Click graphic for larger view; expand browser window for best quality view.

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

Examining Population Components of Change
– net migration and natural change
Population change can be examined in terms of components of change. There are three components of change: births, deaths, and migration. The change in the population from births and deaths is often combined and referred to as natural increase or natural change. Populations grow or shrink depending on if they gain people faster than they lose them. Examining a county’s unique combination of natural change and migration provides insights into why its population is changing and how quickly the change is occurring.

Using the Interactive Table
– examining migration by county
Use the interactive table to examine characters of counties by states, metro or peer group. The following graphic illustrates use of the interactive table to view net migration for the Houston metro by county. The net migration button was used to select only the net migration columns, FindCBSA button used to show only counties in this metro and the final step was to sort the resulting table on 2016 population. 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.

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.

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.

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.