Category Archives: Maps

Block Group Demographic Data Analytics

.. use tools described here to access block group data from ACS 2016 (or ACS2017 in December 2018) using a no cost, menu driven tool accessing the data via API. Select from any of the summary statistic data. Save results as an Excel file or shapefile. Add the shapefile to a GIS project and create unlimited thematic pattern views. Add your own data. Join us in a Data Analytics Web session where use of the tool with the ACS 2017 data is reviewed.

See related Web section for more details.
– examine neighborhoods, market areas and sales territories.
– assess demographics of health service areas.
– create maps for visual/geospatial analysis of locations & demographics.

Illustration of Block Group Thematic Pattern Map – make for any area

– click graphic to view larger view
– pointer (top right) shows location of Amazon HQ2

Topics in this how-to guide (links open new sections/pages)
• 01 Objective Thematic Pattern Map View
• 02 Install the CV XE GIS software
• 03 Access/Download the Block Group Demographic-Economic Data
• 04 Download the State by Block Group Shapefile
• 05 Merge Extracted Data (from 03) into Shapefile (04)
• 06 Add Shapefile to the GIS Project; Set Intervals
• 07 Viewing Profile for Selected Block Group
• 08 BG Demographics Spreadsheet
• 09 Block Group Demographics GIS Project
• 10 Why Block Group Demographics are Important

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.

How the New York Metro is Changing

.. or more precisely, how the New York Metropolitan Statistical Area (MSA) is changing. As of Census 2010 the New York MSA (officially the New York-Newark-Jersey City, NY-NJ-PA MSA) consisted of 20 counties. With the new OMB metropolitan statistical areas defined as of February 2013, the New York MSA became 22 counties, absorbing the Poughkeepsie, NY MSA two counties (Dutchess and Orange). The Poughkeepie MSA was removed from the official MSAs. The delineation remained that way until the new September 2018 delineations when the Census 2010 delineation was restored. Now, the Poughkeepsie, NY MSA exists as a 2 county area and the New York MSA exists as a 20 county area (both as they existed geographically in Census 2010).

These metro-county relationships are shown in the graphic presented below. The Poughkeepsie, NY MSA is shown with the blue cross-hatch to the north and the New York MSA is shown with the salmon color pattern.

– view developed using the CV XE GIS software and related GIS project.
– see the related New York Metro Situation & Outlook report.

What Difference Does it Make?
A lot! First, during the interim period 2013-2018, the Poughkeepsie, NY MSA lost the metropolitan area identity/status as conferred by the OMB delineations. It might have been omitted from size class market development and research analyses. Related, that metro was not included as a tabulation or estimation area of MSAs by Federal statistical agencies. An example of the impact is that the official demographic estimates for the Poughkeepsie, NY MSA developed by the Census Bureau were not tabulated as such and omitted from various statistical reports. Also, the removal of designation and now adding the designation back, creates a hiccup in the time series — affecting both the Poughkeepsie NY MSA and the New York MSA.

Detailed Demographic Profiles for New York MSA and Poughkeepsie, NY MSA
.. click link to view profile.

New York-Newark-Jersey City, NY-NJ-PA MSA
  Bergen County, NJ (34003)
  Essex County, NJ (34013)
  Hudson County, NJ (34017)
  Hunterdon County, NJ (34019)
  Middlesex County, NJ (34023)
  Monmouth County, NJ (34025)
  Morris County, NJ (34027)
  Ocean County, NJ (34029)
  Passaic County, NJ (34031)
  Somerset County, NJ (34035)
  Sussex County, NJ (34037)
  Union County, NJ (34039)
  Bronx County, NY (36005)
  Kings County, NY (36047)
  Nassau County, NY (36059)
  New York County, NY (36061)
  Putnam County, NY (36079)
  Queens County, NY (36081)
  Richmond County, NY (36085)
  Rockland County, NY (36087)
  Suffolk County, NY (36103)
  Westchester County, NY (36119)
  Pike County, PA (42103)

Poughkeepsie-Newburgh-Middletown, NY (CBSA 39100)
  Dutchess County, NY (36027)
  Orange County, NY (36071)

Looking Forward
The September 2018 CBSA delineations define counties that will be used for Census 2020 (likely, there could be yet further changes) — 384 MSAs in the U.S. In the cases of the New York MSA and the Poughkeepsie, NY MSA, it appears that the geography (component counties) used for Census 2010 will be the same as for Census 2020. Going forward, ProximityOne estimates and projections will use the most current vintage of CBSAs.

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.

Examining State-to-State Geographic Mobility

.. tools, resources and insights to examine U.S. by state migration 2011-2017 and migration flows in 2016 .. this post is an excerpt from the more detailed Web page http://proximityone.com/statemigration.htm.

In examining future demographic trends, the most challenging component of change to project (develop data values into the future) is migration. Migration, comprised net domestic and net international migration, is a function of many factors whose cause and effect behavior can change year by year, and geographic area by area. While this section is focused on states, the same scope of data is available to the county and sub-county levels. In this section, U.S. by state migration is examined using two data sources: annual population and components of change model-based estimates (2010-2017 model-based estimates) and annual American Community Survey estimates (ACS 2016 estimates). While these Census Bureau programs are highly related, the migration data/subject matter differ some.

State Net Domestic Migration, 2011-2017
The following graphic shows patterns net domestic migration for the period 2011-2017, based on the model-based estimates. The patterns of migration change, direction and magnitude are immediately evident. Click on the graphic to see a larger view showing more detail. Expand browser to full screen for best quality view. The larger view shows a portion of a mini-profile for Florida. The mini-profile illustrates how these data are comprised … annual net domestic migration estimates and the sum over the years 2011-2017. See the interactive table to view these data, and related components of change, in a tabular, numeric form. Use the GIS project (details here) to create similar views for any state; visual analysis of outmigration for any state showing outmigration by destination state. Label areas as desired. Add other layers. Add your own data.

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

State OutMigration by Destination State
The model-based estimates, reviewed above, do not provide detail on state-to-state migration. Those data are provided by the related ACS 2016 estimates. Note that the ACS 2016 1-year estimates are for the calendar year 2016. From these data we can get the following migration detail … In 2016, there were an estimated 605,018 people who moved from a residence 1 year earlier, in a different state, to Florida. Florida experienced the largest number of movers (inflows) from other states among all states. 60,472 of these movers were from New York. See the interactive table in this section to examine similar characteristics for any state. These data are based on the 2016 ACS 1 year estimates. See about related data.

The American Community Survey (ACS) asks respondents age 1 year and over whether they lived in the same residence 1 year ago. For people who lived in a different residence, the location of their previous residence is collected. The state-to-state migration flows are created from tabulations of the current state (including the District of Columbia) of residence crossed by state of residence 1 year ago.

Movers Within and Between States & Selected Areas During 2016
Use the interactive table to examine state outmigration by destination state. View, compare, query, rank and export data of interest.

Data Analytics Web Sessions
.. is my area urban, rural or …
.. how do census blocks relate to congressional district? redistricting?
.. how can I map census block demographics?
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

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.

How America’s Cities are Changing

… tools, data and insights into how America’s cities are changing, 2010-to 2017.  Of the nation’s 325.7 million people, an estimated 205.0 million (62.9%) live within an incorporated place as of July 1, 2017. Of approximately 19,500 incorporated places, about 76 percent had fewer than 5,000 people and nearly 50 percent had fewer than 1,000 people. Examine characteristics of individual city population trends and compare cities in states, regions and peer groups using the interactive table in this related section. See three related static tables below showing characteristics the 15 largest cities. Use the U.S. by cities shapefile with your GIS projects. See related GIS & mapping details. See more about the sources and uses of these data in this related section.

Mapping America’s 15 Largest Cities
The following view shows cities with 2017 population of 874,000 or more in blue. Labels show rank among all cities based on 2017 population. These 15 cities have a total 2017 population of 30.6 million of the 205 million total population in all U.S. cities (15%). Click graphic for larger view; expand window to full screen.
… click links in Table 3 below to view maps of these cities.

– View developed using the CV XE GIS software.

Patterns of City Percent Change in Population 2010-17
— Cities in the Los Angeles Area
The following view shows thematic patterns of population percent change, 2010-17 for cities in the Los Angeles, CA area. See color/interval assignment in legend. Click graphic for larger view; expand window to full screen. Larger view shows city names and 2017 population.

– View developed using the CV XE GIS software.
– Flexibly create your own views using the cities GIS project.
– Examine city population trends, patterns; zoom to desired areas; label as needed; integrate other data.

Tables Showing the Largest 15 cities
Data/characteristics shown in the following static tables may also be viewed in the interactive table above with more flexibility and details.

Table 1. 15 Cities With the Largest Numeric Increase, 7/1/16-7/1/17
.. cities with populations of 50,000 or more in 2016

Table 2. 15 Fastest-Growing Large Cities, 7/1/16-7/1/17
.. having populations of 50,000 or more in 2016

Table 3. 15 Most Populous Cities as of July 1, 2017
These 15 cities have a total 2017 population of 30.6 million of the 205 million total population in all U.S. cities (15%).

Mapping & GeoSpatial Analysis of the Largest 15 Cities
Click link in the list below to view map of city shown in the above table.
1 New York
2 Los Angeles
3 Chicago
4 Houston
5 Phoenix
6 Philadelphia
7 San Antonio
8 San Diego
9 Dallas
10 San Jose
11 Austin
12 Jacksonville
13 San Francisco
14 Columbus
15 Fort Worth

City/Place Demographics in Context & Related Data
• State & Regional Demographic-Economic Characteristics & Patterns
.. individual state sections with analytical tools & data access to block level
• Metropolitan Area Situation & Outlook
.. continuously updated characteristics, patterns & trends for each/all metros
• ACS 2016 5-year estimates
.. related City/Place Demographic-Economic Interactive Tables
.. General Demographics … Social … Economic … Housing Characteristics
• Corresponding U.S. by County 2010-2017 Estimates

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

School District Revenue & Expenditure Patterns, FY 2016

.. many school districts are adopting 4-day school weeks.  Part of the reason is shortage of funds.  The amount spent per student for public elementary-secondary education for all 50 states and D.C. increased by 3.2 percent to $11,762 during the 2016 fiscal year, based on new data from the Census Bureau released May 21, 2018. The increase in spending in 2016 was due in part to the increase in revenue across all 50 states and D.C. In 2016, public elementary-secondary education revenue, from all sources, amounted to $670.9 billion, up 4.6 percent from the prior year. This is the largest increase since 2007. Yet for many districts this is not enough.

This section provides access to tools and data to to examine K-12 school district finances — sources and uses of funds for FY 2016. The Census Bureau collects these data annually to meet to needs of the National Center for Education Statistics. ProximityOne restructures and integrates these data with other data for GIS/geospatial analysis using the CV XE GIS tools and School District GeoDemographic Information System (SDGIS).

View annual school district finances Web sections: FY 2014 .. FY 2015 .. FY 2016
• Use interactive table to examine school system finances
• Create/view profile for a district(s) of interest.

Current Spending per Student by School District, FY 2016
The following graphic shows patterns of current spending per student by school district, FY 2016, for Texas and adjacent areas. The four largest Texas metros are shown with the bold brown boundary; counties with gray boundaries. Color/fill patterns and corresponding values are shown in the inset legend. Click graphic for larger view showing a partial mini-profile for Houston ISD (at pointer in map).

– view developed using the CV XE GIS analytical tools.
– use these tools on your computer to examine these data & related geography/subject matter.

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

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.
 

Metropolitan Area New Residential Construction in 2017

.. understanding the housing situation; examining housing supply and demand market conditions; assessing trends for metropolitan areas … and how metros of interest are changing .. tools and data to examine patterns and change.

During 2017, cities and counties in permit issuing places authorized the construction of 1,281,977 new privately owned housing units with a total valuation of $258.5 billion. This was 1.4 percent above the annual estimate of 1,264,051 housing units and is a 6.2 percent increase from the 2016 total of 1,206,642.

Patterns of New Residential Construction by Metropolitan Area
The following graphic shows the 20 largest metropolitan statistical areas (MSAs) based on the number of new residential housing units authorized in 2017. Click graphic for larger view showing MSAs labeled with rank and name.

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

Residential Construction Data Analytics — Using Tools & Data
Visit the related Web section to access interactive table and GIS/GeoSpatial analytical tools and data.

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

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.
 

Insights into County/Metro Business Establishment Patterns

.. new data, released this past week, enable us to better assess county and metro business establishment patterns .. these data help businesses understand how sales of their products and services align with markets .. what counties might be underserved? .. where should marketing and sales operations be ramped up or reduced in scope/reallocated? .. what do these tell us us about organization of market territories? how are these characteristics trending by county? Use the this interactive table to examine business establishments characteristics by county and metro by type of business. See more detail in the related Web section about topics covered in this post. 

• U.S. establishments rose 1.2% from 7,663,938 in 2015 to 7,759,807 in 2016.
• First quarter employment was up 2.1% from 124,085,947 to 126,752,238
• Annual payroll was up 2.9% from $6.3 trillion in 2015 to $6.4 trillion in 2016.

Based on the 2016 data (new April 2018), there are 7.3 million establishments in Metropolitan Statistical Areas (MSAs). In these MSAs ..
• 5.3 million establishments have fewer than 10 employees.
• 6,522 of these establishments have 1,000 or more employees.
• 374 of these establishments have 5,000 or more employees.

MSAs by Number of Establishments with 1,000 or more Employees
The following graphic shows Metropolitan Statistical Areas (MSAs) by number of establishments with 1,000 or more employees. Click graphic for larger view view showing metros labeled with number of these establishments. Expand brower to full window for best quality view.
.. View developed with CV XE GIS software and related GIS project.

Business Establishment Characteristics Updated in Metro Reports
Examine 2014, 2015, 2016 mini trend profiles for establishments by 2-digit sector in Metro Situation & Outlook Reports Choose any MSA by clicking column 3 in this table .. then view section 6.3. Examples:
New York .. Los Angeles .. Miami .. Chicago .. Dallas .. Houston .. Denver .. Seattle

Gaining Insights
Gain insights into these types of patterns by county by detailed type of business (NAICS). Use the interactive table below to examine business establishment characteristics for counties and metros of interest. Data reviewed in this section are based on the Census-sourced County Business Patterns released in April 2018. We have integrated current population estimates with the establishment data in the interactive table.

Tools You Can Use
• create maps and geospatially analyze business establishments at 6-digit industry detail with ready-to-use GIS project/tools .. see related section for details.
• Use the APIGateway tools to build custom business establishment datasets.
• Use the interactive table to query/view sort business establishment characteristics by county and metro.

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

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.