Category Archives: ProximityOne User Group

Examining America’s 10 Largest Urban Areas

.. why it matters .. among other reasons, these 10 areas have 24% of the total U.S. population. Three have increased by more than 20% in the past 5 years.

More than 80-percent of America’s population is urban, but far more than 80-percent of America’s geography is rural. Census 2010 shows that America’s urban population increased by 12.1 percent from 2000 to 2010, compared to the national overall growth rate of 9.7 percent. Urban areas now account for 80.7 percent of the U.S. population, compared to 79.0 percent in 2000.

America’s 10 Largest Urbanized Areas
The following table shows the largest 10 Urbanized Areas (UAs) based on the American Community Survey 2011 and 2016 1-year estimates (ACS2016) and change over the period. UAs are sorted in descending order based on the 2016 population estimate. Note that Atlanta, Dallas and Houston moved up in rank.

Geodemographic relationships vary widely between the urbanized areas (UAs). Some, such as Miami, comprise most or all of the urban area within the corresponding metropolitan statistical area. Others, such as Philadelphia, are nested within a mix of adjacent urban areas interspersed with rural areas. Among other things, these different geodemographic structures reflect how planning, needs assessment and market development vary widely from associated metro-to-metro. These data show the importance and need to consider the urban/rural population distribution even in the largest metros.

Visual Analysis — Dallas Urbanized Area
The urbanized area (UA) of the corresponding metropolitan statistical area (MSA) generally occupies less than half of the MSA.
See the Dallas-Fort Worth-Arlington, TX MSA Situation and Outlook Report

… View developed using CV XE GIS.

Map Views for Each of the Largest 10 Urbanized Areas
Maps for each of the 10 largest UAs are shown at
http://proximityone.com/urbanareas_2016.htm.

Each graphic shows the designated urbanized area in a darker salmon color fill pattern, associated metropolitan statistical area with bold brown boundary, and other urban areas with a lighter shade of salmon fill color, counties black boundaries and yellow labels. The ACS 2016 UA population is shown as a white label under the UA name. The ACS 2016 estimates are the most recent data available and will update with 2017 estimates in late 2018.

More About Analyzing Urban/Rural Patterns and Characteristics
See the related section on America’s urban/rural population and geography:
http://proximityone.com/urbanpopulation.htm.

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 L

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.

America’s Cities: Demographic-Economic Characteristics Annual Update

.. tools and data to interactively examine demographic-economic characteristics of America’s 29,321 cities/places .. understanding demographic-economic characteristics of cities and places is 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 characteristics of all cities/places in the U.S. This annual update includes data for 29,321 cities/places based on ACS 2015 data.

Accessing the Data; Using Interactive Tables
Each of the four links below opens a new page providing access to U.S. by city/place interactive tables — by type of subject matter. Use tools and usage notes below table to select operations to perform queries, sort and select columns.
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

How the the Tables/Data Can be Used
The following table shows data derived from the Economic Characteristics table. The top 10 cities/places having the highest median household income ($MHI) are shown. The table also shows population, median family income ($MFI) and per capita income ($PCI). The $250,000 value is a cap; the actual value is $250,000 or higher. Use the interactive tables to create similar views for states of interest. Use the button below the table to select/view cities within a selected metro. Compare attributes of cities of interest to a peer group based on population size.

Visual Analysis of City/Place Population Patterns
Use GIS resources to visually examine city/place demographic-economic patterns. The following view shows patterns of population percent change by city in the Charlotte, NC-SC metro area.

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

Related Data
Cities/Places Main Section
Citie Population Estimates & Trends, 2010-15

More About Using These Data
Using ACS 1-year and 5-year data

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.

Daytime Population by Census Tract & Neighborhood

.. examining workers living/working in area .. population change due to commuting & employment/residence ratio .. the concept of the daytime population refers to the number of people who are present in an area during normal business hours, including workers. This is in contrast to the resident population present during the evening and nighttime hours. Information on the expansion or contraction experienced by different communities/areas between nighttime and daytime populations is important for many planning purposes, including those dealing with market size, trade/service areas, transportation, disaster, and relief operations. See related Web section with more detail.

This section reviews use of analytical tools to examine daytime population and related measures by census tract using GIS resources. These data are based on the 2013 American Community Survey 5-year estimates (ACS2013).

Topics:
• Patterns of Resident Population by Census Tract
• Patterns of Daytime Population Census Tract
• Patterns of Employment-Residence Ratio by Census Tract

Patterns of Resident Population by Census Tract
The following graphic shows patterns of the resident population by census tract for the Los Angeles area. Census tracts are statistical areas designed to average 4,000 population as reflected in this view. See population size/color intervals in inset legend. Primary roads are shown in the graphic; the pointer shows the Los Angeles-Orange County boundary. Click graphic for larger view. Expand browser window for best quality view. The larger graphic shows Los Angeles city as a cross-hatched overlay. This graphic is presented to compare/contrast patterns of the daytime population shown in the next graphic.

– View created with CV XE GIS.

See more about the Los Angeles metro and California state & regional data resources.

Patterns of Daytime Population Census Tract
The following graphic shows patterns of the daytime population by census tract for the Los Angeles area. This graphic is presented to compare/contrast patterns of the daytime population shown in the above graphic. As the employed population commutes during the data, the daytime population of census tracts change as reflected in this view. See population size/color intervals in inset legend. Primary roads are shown in the graphic; the pointer shows the Los Angeles-Orange County boundary. Click graphic for larger view. Expand browser window for best quality view. The larger graphic shows Los Angeles city as a cross-hatched overlay.

View created with CV XE GIS. Click graphic for larger view.

Patterns of Employment-Residence Ratio by Census Tract
The following graphic shows patterns of the Employment-Residence (E-R) Ratio by tract for the Los Angeles area. See E-R/color intervals in inset legend. See about the E-R ratio below. Primary roads are shown in the graphic; the pointer shows the Los Angeles-Orange County boundary. Click graphic for larger view. Expand browser window for best quality view. The larger graphic shows Los Angeles city as a cross-hatched overlay.

View created with CV XE GIS. Click graphic for larger view.

About the Employment-Residence (E-R) Ratio
The E-R ratio is a measure of the total number of workers working in the area, relative to the total number of workers living in the area. The E-R ratio is used sn indicator of the jobs-workers balance in an area. A value greater than 1.00 shows there are more workers working in the area than living there (net importers of labor). A value of less than 1.00 is shown in areas that send more workers to other areas than they receive (net exporters of labor).

See related Web section for information on daytime population terms and concepts.

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.

Housing Price Index by 5-Digit ZIP Code

.. tools to examine housing prices by 5-digit ZIP code and how they are changing .. of the 17,931 5-digit ZIP codes tabulated, 8,074 experienced a decrease in housing value during the period 2010 to 2015. At the same time, 8,672 ZIP code areas experienced an increase in housing value. Housing prices increased for most ZIP codes from 2014 to 2014.  Find out more about housing prices and trends for ZIP codes of interest using tools described here. These data are based on experimental estimates of the Housing Price Index (HPI) by 5-digit ZIP code based in part on home sales price data from Fannie Mae- and Freddie Mac-acquired mortgages. See more about these data.

• Use the interactive table to view, rank, compare the HPI for all 5-digit ZIP code areas tabulated.
• Use GIS tools described here to develop thematic pattern maps; add your own data & geography, select different HPI measures or criteria; zoom to different geographic extents, label and modify colors as desired.

Gaining Insights in Housing Prices, Conditions & Markets
  .. Characteristics, Patterns & Trends
  .. join in .. one hour web session — overview & connectivity details

Patterns of Housing Value Change by ZIP Code: 2010-15
The following graphic shows patterns of housing value appreciation by ZIP Code: 2010-15 for the Houston metro (bold brown boundary). The color patterns/intervals are shown in the inset legend. Data are not available, using the criteria applied (2000 base year), for areas not colored In the larger view (click graphic), ZIP codes are labeled with HPI percent change from 2010 to 2015. Click graphic for larger view. Expand browser to full window for best quality view. Use the GIS tools described here to develop thematic pattern maps for a range of data and criteria.

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

Additional views:
Atlanta area
New York City area
Washington, DC area
Los Angeles area

Examining Recent Trends; Current Estimates & Projections
The interactive table presents annual HPI data 2010 through 2015. A much larger set of these ZIP codes show a negative change between 2010 and 2015 compared to the one year change 2014-2015; The data generally show more ZIP codes experiencing housing value appreciation 2014-2015 compared to the longer period 2010 to 2015. These trends underscore the importance of having more recent data for use in analysis, planning and decision-making. The next update based on transaction data will be May 2017 or later.

ProximityOne uses the HPI transaction data with other data to develop HPI current estimates (2016) and annual projections to 2021 with quarterly updates as a part of the Regional Demographic-Economic Modeling System (RDEMS). Experimental county-up (metro, state, U.S.) and sub-county estimates and projections are planned for the fall 2016 quarterly update. The model based estimates and projections include the number of units by type and value that are added to the housing stock used to compute a variation of the HPI.

Housing Price Index by 5-Digit ZIP Code: 2010-2015
  — Interactive Table
Use the interactive table to examine the Housing Price Index (HPI) by 5-digit ZIP code. The following graphic illustrates use of the table to show the 10 ZIP codes experiencing the largest percentage increase in the HPI from 2014 to 2015. Click graphic for larger view. Examine cities or ZIP code ranges of interest using tools below the table.

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.