Category Archives: Shapefile

State Population & Components of Change: 2010-2016

.. data and tools to examine how state demographics are changing 2010-2016 … using the new 2016 population and components of changes estimates. The U.S. population changed from 308,758,105 (2010) to 323,127,513 (2016), a change of 14,369,408 (4.7%). Only three states lost population. See the growth rates for DC and the remaining states in this table. Highest growth rates were in D.C., North Dakota, Texas, Utah and Colorado.

Patterns of Population Change, 2010-2016, by State
The following graphic shows the percent population change by state with labels showing the rank among all states based on the percent change in population, 2010-16.

View created with CVGIS and related GIS project. Click graphic for larger view.

Resources to Analyze these Data
Use our tools to view and analyze annual population estimates, 2010 to 2016, rankings and components of change for the U.S., regions and states. Use the interactive table below in this section to view, rank, compare these data. Use the GIS tools and ready-to use project described below in this section to create maps for states and regions of interest. Create thematic maps for any of the fields/measures shown in the interactive table. Change color patterns and labels. Integrate your own data.

Using Interactive Table
Use the interactive table to view, rank, compare, query states 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 largest 10 states ranked in descending order based on 2016 population. The column “PopChg Rank 10b16” (second from right) shows the rank of this state, among all states, based on the population change from 2010 to 2016. The rightmost column shows the state’s rank for the period based on percent change in population over the period.

Largest 10 States based on 2016 Population

Try it yourself. Use the table to examine state 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.

ZIP Codes with Highest & Lowest Economic Prosperity

.. the latest data for ZIP Code Areas show that eleven had a median household income of $250,000 or more during the period 2011-15. More than 20 ZIP code areas had a median housing value of $2,000,000 or more. Contrast these ZIP code areas with higher economic prosperity with the more than 150 ZIP codes that had a median housing value of less than $30,000.  Use the interactive table in this related Web section to see which ZIPs meet these and other criteria.

ZIP Codes with MHI $100,000 or More; Dallas, TX Metro
Analyzing economic prosperity patterns using combined types of small area geography … the following graphic shows ZIP code areas a red markers with the median household income or $100,000 or more in context of median household income by census tract thematic pattern. Click graphic for larger view with more detail. Expand browser window for best quality view. Use CV XE GIS software and associated GIS project to develop variations of this view for your areas of interest. .

– view developed with CV XE GIS software.

This section reviews measures of economic prosperity for all ZIP code areas. These data were released in December 2016. This section updates with new data December 2017. See the list of all ZIP ccdes showing population, housing and economic characteristics in the interactive table shown below. Use the interactive table to view, rank, compare and query ZIP code attributes.

Examining demographic-economic characteristics by ZIP code is important for several reasons. We are familiar with our own ZIP codes as a geographic location. We tend to be interested in our area compared to other areas. ZIP codes provide an easy way to do that. Also, many secondary data resources are tabulated by ZIP code area; some important data are only available by ZIP code. See more about ZIP Code areas.

Resources & Methods to Examine Small Area Demographics
• See related ZIP Code Demographic-Economic Interactive Tables
  .. extended subject matter
• See related Census Tract Code Demographic-Economic Interactive Tables
• Examine ZIP Code Urban/Rural Characteristics
• Examine ZIP Code Business Establishment patterns
• Examine ZIP Code Housing Price Index patterns
• Join us in the weekly Data Analytics Lab Sessions
  .. reviewing applications using these and related data.

ZIP Code Areas with $MHI $100,000 or More
The following graphic shows ZIP code areas as red markers having median household income or $100,000 or more. Click graphic for larger view with more detail. Expand browser window for best quality view. Use CV XE GIS software and associated GIS project to develop variations of this view; integrate other data; select alternative ACS 2015 subject matter.

– view developed with CV XE GIS software. Click graphic for larger view.

ZIP Code Areas with $MHV Less than $30,000
The following graphic shows ZIP code areas as orange markers having median housing value of less than $30,000. Click graphic for larger view with more detail. Expand browser window for best quality view. Use CV XE GIS software and associated GIS project to develop variations of this view; integrate other data; select alternative ACS 2015 subject matter.

– view developed with CV XE GIS software. Click graphic for larger view.

ZIP Code Areas: Population & Economic Prosperity
  — Interactive Table –
Use the interactive table to view, rank, compare, query ZIP codes based on a selection of demographic-economic measures. The following graphic illustrates how the table can be used to examine patterns of the three digit ZIP code area (San Diego) by 5-digit ZIP code. Table operations are used to select ZIP codes in the 921 3-digit area (containing 39 5-digit ZIP codes). These 39 ZIP code are then ranked in descending order on median household income. See results in the table shown below. ZIP code 92145 has the highest $MHI in this group with $228.036.

– click graphic for larger view.

Try it yourself. Use the table to examine a set of ZIP codes 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.

New 2016 Digital Roads Database

.. new resources for updated geographic reference and statistical mapping and geography for routing logistics and optimization .. The Census Bureau TIGER/Line is a continuously updated geographic database used for geographic reference and geospatial processing of data from various Census statistical programs including the decennial census Census 2010 and American Community Survey (ACS 2014). The public use version of TIGER is released annually that includes updates developed during the year. ProximityOne integrates the TIGER geographic updates in the Digital Map Database. Warren Glimpse, founder of ProximityOne, developed the GBF/DIME used as the prototype for TIGER/Line development.  See related Web section for more details, interactive table and access to GIS resources.

The TIGER database includes many types of files and data. The data are developed in the form of shapefiles and dbase files that may be used directly with the ProximityOne CV XE GIS software at no fee. Perform wide-ranging mapping and geospatial analysis applications using these GIS resources. See more aboutmapping statistical data.

TIGER/Line Roads Data
This section is focused mainly on the use of the TIGER/Line “edges” shapefile. The edges shapefile U.S. wall-to-wall street/road coverage in the form of line shapefiles. Lines classified as roads are intersection-to-intersection road segments. Line segment fields include name, left- and right-side high and low addresses, and many related attributes.

Use the U.S. by county interactive table below to examine attributes of TIGER 2016 street/road coverage. ProximityOne developed these county summary data by processing each county edges shapefile. See about using the edges shapefile with the CV XE GIS software below in this section.

Illustrative Applications
The following sequence of graphics shows an example of a “road segment” in context of related geography. These applications focus on an area in Kansas City, MO (Jackson County),. Jackson County has 52,139 TIGER 2016 road segments. See the related step-by-step summary of how you can create these and similar map views using CV XE GIS below in this section.

Road Segment Map View & Profile
– Starbucks locations shown as red markers; pointer on road segment by a Starbucks location.
– View illustrates how non-Census, non-statistical data can be integrated with TIGER.
– Clicking on the road segment (in GIS operation), a mini-profile displays.
– The profile shows attributes of the selected road segment.
.. the TLID value shows the unique ID for this segment among all segments in U.S.
.. left- and right-side high and low address ranges and included in the profile.

Corresponding Census Block Profile
– The road segments are boundaries for census blocks.
– The census block boundaries are shown using a related TIGER blocks shapefile.
– The more that 11 million census blocks cover the U.S. wall-to-wall.
– The census block code (290950073002017) is shown as a label in the map graphic and in the profile.

Neighborhood & Shopping Area View
– A zoom-out shows the location, roads and blocks for a broader areas.

Regional View
– A further zoom-out shows the focus area view in context of the metro counties (a related TIGER shapefile)
– The January 2016 Kansas City city area (orange cross-hatch pattern) is shown using a related TIGER 2016 shapefile.

TIGER 2016 Roads
TIGER/Line 2016 vintage files were released in August 2016. While many aspects of road coverage remain as described in this section, TIGER/line 2016 includes many updates as well as “new vintage” geography for school districts, state legislative districts, congressional districts and other political/statistical area geography.
• More about TIGER 2016.
• More about TIGER/Line in general.

TIGER 2016 Road/Street Name/Address Coverage
— Interactive Table
The following graphic illustrates use of the interactive table to examine the number and characteristics of road segments by county. This view shows the top 10 counties based on the number of total road segments.

– click graphic for larger view

Using TIGER/Line with CV XE GIS
These operations require a Windows computer with Internet connection
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the TIGER Roads project fileset
… requires ProximityOne User Group ID (join now)
… unzip TIGER Roads GIS project files to local folder c:\tiger2016
3. Open the c:\tiger2016\riger2016_kc.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\tiger2016\tiger2016_kc.gis
4. Done. The start-up view is shown at top of this 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.

Mapping Statistical Data Updates

.. statistical mapping & visual data analysis … ready-to-use GIS projects/datasets … Geographic Information Systems (GIS) provide flexible and powerful capabilities to combine maps with data. In our increasingly data rich environment, we often experience “drowning in data.” GIS tools can help harness disparate and voluminous data and assist with data linkage. This section provides links to other sections that provide information on no cost GIS software and “production” GIS projects and datasets that you can use.

• Recent Additions
– Real Gross Domestic Product by State & Area – 06/23/16 – details
– Housing Price Index by Metro; 2015Q1-2016Q1 – 07/02/16 – details
– Housing Price Index by 5-Digit ZIP Code; 2010-2015; 07/02/16; details

Example: Mapping Median Housing Value by ZIP Code;  Los Angeles Area
Make this type of view/map for any area. Click graphic for larger view. Larger view illustrates use of identify/select tool to show mini profile for a selected ZIP code (see at pointer). Expand browser window for best quality view. Using GIS resources described here.


View developed with CV XE GIS software.

Related Topics in Mapping Statistical Data section …
• K-12 Curriculum Program
Data Analytics & Mapping Statistical Data in the Classroom

• GIS Projects/Datasets/Applications
World by Country
U.S. by State
U.S. by Congressional District
State Legislative Districts
U.S. by Metropolitan Area
U.S. by County
U.S. by City/Place
U.S. by ZIP Code Area
State by Census Tract (each/all states)
State by Block Group
State by Census Block
K-12 Schools & School Districts
K-12 Schools & School District Data Analytics

Join in … participate in the weekly Data Analytics Lab sessions 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.

Real Gross Domestic Product by State & Area

… tools to access and analyze GDP patterns and trends … Gross Domestic Product (GDP) is a comprehensive measure of U.S. economic activity. This section provides access to annual GDP estimates for the period 2010 through 2015 and tools to analyze these data. The 2015 data are the latest estimates as of June 2016 (about these data). This section provides data and tools focused on the U.S. and states. In September 2016, this section updates to include the new 2015 estimates of metropolitan area GDP and revised historical updates. Follow this blog to receive updates. See the related Web section for more details about topics covered in this post.

Patterns of Per Capita Real GDP & Percent Change by State
The following graphic shows patterns of the 2015 per capita real GDP by state. The color patterns/intervals are shown in the inset legend. In the larger view (click graphic), states are labeled with 2015 per capita real GDP (white label) and percent change in per capita real GDP, 2010-2015. Click graphic for larger view. Expand browser to full window for best quality view. The larger view shows a mini-profile for Texas. Use the GIS tools described below to develop thematic pattern map using any combination of these items from 2000 forward.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Importance
GDP is an important part of planning, management and decision-making in the private and public sectors. It is watched closely by all stakeholders as to how the economy is trending. By adjusting current dollar GDP to constant dollar GDP, we can better examine the trends and patterns by removing inflation from the measures. By examining GDP at the metro and sub-state area, businesses and policy-makers can better determine GDP patterns on a regional basis. Regional analysis of GDP is very important as magnitude and change vary widely. By examining the size and trends of regional real GDP on a per capita basis, we are better able to examine patterns and trends at the individual level.

Modeling, Projections & Access/Analysis/Interpretive Tools
GDP is an important part of the ProximityOne Regional Demographic-Economic Modeling System (RDEMS). The RDEMS model specifies cause and effect relationships with GDP and GDP components and other data to develop current estimates and projections.

Use these tools to access/analyze GDP characteristics and patterns:
• interactive table – access in related Web section
• analyzing patterns using GIS resources – see details in related Web ection
• RDEMS database access
.. illustrative example of GDP patterns in context with other measures
.. Texas briefing notes (see notes “Texas per capita real GDP” on that page)
.. Access briefing notes for any state

Interactive Table
Use the interactive table below to examine per capita real GDP by state in context of other states and the U.S. This table expands to include metros in September 2016. The content of the table also expands to include GDP sectors and components

Per Capita Real Gross Domestic Product by State & Area
— 2000-2015
— interactive table
The following graphic shows states ranked on percent change in per capita real GDP. Click graphic for larger view. Use the interactive table to view rankings of interest. Export the data for further analysis.

Analyzing GDP using GIS Resources
— requires Windows computer with Internet connection
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the GDP GIS project fileset
… requires ProximityOne User Group ID (join now)
… unzip GDP GIS project files to local folder c:\gdp
3. Open the c:\gdp\us1gdp.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\gdp\us1gdp.gis
4. Done. The start-up view is shown at top of this 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.

Census Tract-City Relationship Table

.. what census tracts are located in cities of interest? What are their codes? Conversely, do you have census tract codes and need to know corresponding city(s)? Get answers here.

This section provides access to an interactive table useful to examine relationships among Census 2010 census tracts, cities/places, and counties. Many cities and counties that might be experiencing demographic-economic decline will often have bright spots that are groups of a few or many census tracts. Census tracts are important sub-county geography in data analytics. See the related section on census data analytics. See more about census tracts and data analytics below in this section.

Relating Census Tracts to Cities & Counties
Census tracts are sub-county areas and nest coterminously within counties. The 6-character tract code is unique within county. For cities 10,000 and larger, there are some number of whole census tracts within the city. But around the perimeter of cities, census tracts will often be partly within and partly outside of the city. The following graphic shows the relationship of tracts, cities and counties in the Plano city area (green fill pattern) located mostly in Collin County within the Dallas metro. Click graphic for larger view, more detail and legend color/data intervals. This map illustrates the geographic level of detail available using census tract demographics and the relative ease to gain insights using geospatial data analytics tools.

– View developed using CV XE GIS and related GIS project.

Using the Interactive Relationship Table
A small part of Plano is located in Denton county (see north-south bold red-brown boundary). Tract 021627 (see pointer) is located in Denton County and includes a part of Plano. To determine what geography tract 021627 intersects, click the Tract> button below the interactive table shown below. See that the tract is contained in parts of 4 cities.

Census Tract to City/Place & County Equivalence Table
The following graphic illustrates use of the interactive table to view/examine the relationship between census tract 48121021627 (in Denton County, TX) and the city of Plano, TX. Click graphic for larger view.

The above view was developed using the interactive table:
– click the ShowAll button
– click the FindTract button (preset to locate this tract).

Click the ShowAll button and enter a city/place (case-sensitive) name of interest to view the set of intersecting tracts. See the table usage notes below the table in the related Web page. We review operation of the table in the 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.

State and Regional Decision-Making Information

Organized on a state-by-state basis, use tools and geographic, demographic and economic data resources in these sections to facilitate planning and analysis. Updated frequently, these sections provide a unique means to access to multi-sourced data to develop insights into patterns, characteristics and trends on wide-ranging issues. Bookmark the related main Web page; keep up-to-date.

Using these Resources
Knowing “where we are” and “how things have changed” are key factors in knowing about the where, when and how of future change — and how that change might impact you. There are many sources of this knowledge. Often the required data do not knit together in an ideal manner. Key data are available for different types of geography, become available at different points in time and are often not the perfect subject matter. These sections provide access to relevant data and a means to consume the data more effectively than might otherwise be possible. Use these data, tools and resources in combination with other data to perform wide-ranging data analytics. See examples.

Select a State/Area

Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
D.C.
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming

Topics for each State — with drill-down to census block
Visual pattern analysis tools … using GIS resources
Digital Map Database
Situation & Outlook
Metropolitan Areas
Congressional Districts
Counties
Cities/Places
Census Tracts
ZIP Code Areas
K-12 Education, Schools & School Districts
Block Groups
Census Blocks

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.