Category Archives: Geography

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.

Location-Based Demographics Update

.. tools you can use to examine characteristics of addresses/locations .. many of us are interested in knowing attributes of addresses or locations. Often knowing address latitude-longitude is important so that the addresses can be viewed on a map .. see below.  Some might need to know what census block, or other geography, in which an address is located .. or what school district is an address located in.  Others need to know demographic-economic attributes of the neighborhood or area where an address is located.  These types of attributes can be obtained for addresses using the Location-Based Demographic (LBD) tools.  The LBD tool has just been made a part of the CV XE GIS software.  The LBD tool is available in all versions of CV XE GIS, including the no fee User Group version. See more about using the LBD tools to look-up and analyze address/location attributes.

Viewing Geocoded Addresses on a Map – automatically
The following view shows addresses geocoded using the LBD tool. Markers show addresses of 27 Trader Joe’s locations in the Los Angeles area. LBD automatically creates a shapefile that is added to your GIS project. The markers are labeled with population ages 18 and over in the corresponding census tract. Marker color/styles reflect different levels of median household income. A separate census tract layer shows patterns of economic prosperity.

Click graphic for larger view. Expand browser window. A mini profile is displayed showing demographic-economic attributes for the marker at pointer.

View the locations without the tract thematic pattern layer:

Make similar views for your addresses.

Get Started Using the LBD Tool
1 – join the User Group .. click here to join (no fee).
2 – run the installer to install on a Windows machine .. requires your userid.
3 – with CV XE GIS running, click Tools>Find Address/LBD
    enter an address .. a form appears showing characteristics of the address.
4 – see more about using the tools on the LDB page.

GeoStatistical Data Analytics Learning Sessions
We are developing a series of “GeoStatistical Data Analytics” (GSDA) Learning Sessions/modules. One of these is focused on using the LBD tools and methods in the broader context of data analytics. We plan to develop the GSDA models for self-guided use by analysts/practitioners as well as in the classroom setting with teacher/student materials. Upcoming blog posts will describe the program in more detail.

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.

Redistricting & Census 2020

.. most states will not have new redistricting plans until after Census 2020. Redistricting is the process of developing a redistricting plan for 2 or more areas (districts) disjoint and contiguous that are contained within the collective area of all districts based on some criteria. Redistricting is perhaps most familiar with regard to congressional districts and state legislative districts based on a set of demographic characteristics … but may apply to many other types of geographies. This post briefly reviews the Census 2020 & Redistricting Program.

Redrawing the Pennsylvania 115th Congressional Districts
The following views show Pennsylvania 115th Congressional Districts in their gerrymandered configuration (old) and the redrawn configuration (February 2018, new). Counties shown with light gray boundary. Click graphic for larger view. Expand browser window for best quality view.
Pennsylvania 115th CDs — Old

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

Pennsylvania 115th CDs — New, redrawn February 2018

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

Census 2020 & Redistricting Program
The ProximityOne Census 2020 & Redistricting Program enables participants to engage now in preparation for redistricting based on Census 2020. Use resources and processes provided by ProximityOne and the Congressional Districts/State Legislative Districts Group (CDSLD) .. participate in hands-on redistricting for your areas of interest. We start now using Census 2010 redistricting data, current congressional districts and state legislative districts, and related data/tools. Progressively, we move toward accessing the live Census 2020 redistricting data (March 2021). There is no cost to participate. See more about the Census 2020 & Redistricting Program at http://proximityone.com/cen2020_redistricting.htm. Join the CDSLD Group via this form to receive updates on the program and begin participation.

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 the Census 2020 redistricting Program. 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 & Why State Demographics Are Changing

.. to examine how and why state demographics are changing, we look at the state as the sum of its parts — counties. Here we review tools and data to examine how and why state/county population is changing … is the population moving away or into your areas 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? See related Web section for more detail on topics covered here and access interactive table.

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

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

The above graphic provides a visual summary of how and why demographics are changing from 2010 to 2017 in terms of components of change: births, deaths and migration. See the underlying data in this interactive table.

Change in the population from births and deaths is often combined and referred to as natural increase/change. The other way an area population changes is through migration (net international, net domestic, net migration). Examining an area’s unique combination of natural change and migration provides insights into why its population is changing and how quickly the change is occurring.

Examine States of Interest
Click a state link to view details about specific states …
Alabama .. Alaska .. Arizona .. Arkansas .. California .. Colorado .. Connecticut .. Delaware .. 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

Situation & Outlook Briefing Sessions
Join me in a Situation & Outlook Briefing Session, every Tuesday, where we review the where, what, how, and when of demographic-economic-business change – and how change might impact you.  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.