Category Archives: Patterns

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.
 

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.

2018 U.S. & World Population

.. Welcome to 2018 .. how the U.S. and world are changing …

The Census Bureau estimates the U.S. population is 326,971,407 as of January 1, 2018. This represents an increase of 2,314,238, or 0.71 percent, from New Year’s Day 2017. Since Census Day (April 1) 2010, the population has grown by 18,225,587, or 5.90 percent.

In January 2018, the U.S. is expected to experience one birth every 8 seconds and one death every 10 seconds. Meanwhile, net international migration is expected to add one person to the U.S. population every 29 seconds. The combination of births, deaths and net international migration will increase the U.S. population by one person every 18 seconds.

The world population on January 1, 2018 is estimated to be 7,444,443,881. The world has experienced a population increase of 78,521,283, or 1.07 percent, from New Year’s Day 2017. During January 2018, 4.3 births and 1.8 deaths are expected worldwide every second.

Patterns of Population Change by State, 2010-2017
The following graphic shows patterns of percent population change from 2010 to 2017. Use the associated GIS project to examine different years or subject matter items. Click graphic for larger view; expand browser window for best quality view.

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

How the U.S. Population is Changing
The following graphic shows how the population of the U.S. has changed from 2010 to 2017 and how the population might change 2018 through 2020. Click graphic for large view. The population is as of July 1 for each year. The components of change (birth, deaths and migration) are for the period July 1 through June 30 for that year.

Population for each year is computed by the population identity equation:
  P[t]=P[t-1] + B[t,t-1] -D[t,t-1] + M[t,t-1]
Viewing the larger image, see how each of the components of change are impacting the total population and population change.
… see more detail about these data for the U.S. and by state at http://proximityone.com/states2017.htm.

More About Population Trends, Patterns and Characteristics
See more about how population dynamics; use the interactive tables in these sections:
  • School Districts — http://proximityone.com/sdtrends.htm
  • Cities — http://proximityone.com/places2016.htm
  • Counties — http://proximityone.com/countytrends2016.htm
  • Metros — http://proximityone.com/metrotrends2016.htm
  • States — http://proximityone.com/states2017.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 LinkedIn.

Congressional District/State Legislative District Data Analytics Sessions

.. join me in the Congressional District/State Legislative District Data Analytics Sessions .. http://proximityone.com/cdsld/cdsld_vasessions.htm .. face-to-face sessions in the Washington, DC area.

Legislative Districts & Patterns of Neighborhood Economic Prosperity
Census tracts labeled with median household income in context VA House District 11 (bold blue boundary) in Fairfax County, VA. Use the GIS project to examine any state legislative district.

— click for larger view
— view created using CV XE GIS & associated GIS project.

CDSLD Sessions These sessions are focused on tools, data and analytical methods relating to Congressional Districts (115th CDs) and State Legislative Districts (2016 cycle SLDs). We focus on national and Virginia CDs and SLDs in context of the total population, voting population, the Citizen Voting Age Population characteristics and patterns with drill down to census blockblock groupcensus tractelection precinctcity/placeZIP codecountymetro and other geography.

Program details as PDF: http://proximityone.com/cdsld/cdsld_vasessions.pdf.

Anyone may attend. There is no fee. There is no promotional content. Sessions are presented by Warren Glimpse an expert on the topics covered. Learn more about the potentials of using these tools, data and methods. Get answers to your questions to learn more about what data are available, options to access the data, how to integrate these data with other data and insights into how you can use and the data. Attend one or many sessions. While there are core topics, new related material and updates are covered in each session. Join in as a continuing program. Develop and extend data analytics skills.

Patterns of Economic Prosperity by VA Senate District
– Virginia Upper/Senate SLDs by Median Household Income

– click graphic for better quality view; districts labeled with district code

More About Congressional Districts & State Legislative Districts
See the related section for more information:
• 115th Congressional Districts ..
.. Main .. http://proximityone.com/cd115.htm
.. demographic-economic tables http://proximityone.com/cd161dp1.htm
• State Legislative Districts Main .. http://proximityone.com/sld2016.htm
.. with demographic-economic interactive table
• Virginia State Legislative Districts .. http://proximityone.com/sld_va.htm
.. interactive table with incumbency details

CDSLD Data Analytics Web Sessions
Unable to join the face-to-face session? Join me in a Data Analytics Web 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 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

TractWatch — Examining Small Area Change

Understanding the demographic-economic landscape for small area geography and how it is changing is vital for many stakeholders. Businesses and other organizations need to know how their market/service areas are changing … getting answers to questions like knowing about recent trends, where we are now and the how/where/how much things might change in the future.

Examining Tract Change
The following view shows census tracts (black boundary) located in the northeast Houston, TX area. Tracts are labeled with 2017 population estimates and percent population change from 2010 to 2017. Tract geography and characteristics are shown in context of three cities/places — Houston (orange cross-hatch), Humble (blue) and Atascocita CDP (green). It is easy to see what census tracts intersect with what cities and where. The pointer/hand is located in census tract 48-201-240902, partly intersecting with Humble city. The tract 2017 population of 12,984 reflects an increase of 10.4% since 2010. The dark brown bold boundary at the top of this tract is the Harris County, TX boundary.

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. create views like this for any area in the U.S.; add your own data.

TractWatch tells us which tracts in a region of interest changed during the past year based on quarterly observable data with only a one quarter lag.

Census Tracts & TractWatch
TractWatch is a new tool/service focused on examining recent demographic-business change for each census tract. These approximate 74,000 geographic areas cover the U.S. wall-to-wall and averaged 4,000 population as of Census 2010. Tracts have a generally stable geography between decennial censuses and are coterminous with county boundaries. Tracts cover the U.S. with more than a 2-to-1 ratio compared to ZIP code areas (see tract-ZIP relationship table).

Integrated with Situation & Outlook
TractWatch insights are developed through the use of the ProximityOne Situation & Outlook (S&O) database and information system — a part of S&O demographic-economic estimates and projections developed and updated annually. The 2017 vintage tract estimates and projections (annual data) cover the period 2010 through 2022 (5-year projection).

TractWatch – Monitoring Change
As a part of the S&O annual estimates and projections development, a range of measures are updated quarterly at the census tract level. Quarterly data are developed that include population, housing units, vacant units, households and business establishments.

There is only a one-quarter lag in the availability of observable census tract data. For example, observable 2017Q1 data can be added to the S&O database in July 2017. Data are analyzed and converted into a TractWatch national dataset.

Situation & Outlook Reports
The Situation & Outlook Reports (S&O Reports) are updated weekly, for the U.S. and each county, metro and state. TractWatch is a part of the “Recent Change and Outlook” S&O Report section and updated quarterly. See schedule of updates the shows when TractWatch is updated.

The S&O Reports (metro and county) Recent Change and Outlook section includes a list of census tracts which have shown significant change over the past year for that geography. A table of typically 10-to-25 key tracts are listed in a table with selected demographic-business change attributes.

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.

Analyzing Block Group Demographics

.. tools & data to analyze sub-census tract households, education, income, housing, more … Block Groups, subdivisions of census tracts, are the smallest geographic areas for which “richer demographics” are developed by the Census Bureau. Block group demographic-economic estimates, based on Census 2010 geography, are annually updated beginning with American Community Survey (ACS) 2010. The latest ACS estimates for these 217,740 areas covering U.S. wall-to-wall are from ACS 2015. The ACS 2016 update will be released in December 2017.  See the related Web section for more detail about accessing and using block group geography and demographic-economic data.

Patterns of Economic Prosperity by Block Group
The following graphic shows patterns of median household income by block group in the Houston, TX area. Markers show block groups with 10 or more housing units having value of $2 million or more. Markers are labeled with the number of housing units having value of $2 million or more in that block group. Click graphic for larger view, more detail and legend color/data intervals. This map illustrates the geographic level of detail available using block group demographics and the relative ease to gain insights using geospatial data analytics tools.

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

Block Group Demographic-Economic Data & Shapefiles
… selection of key demographic-economic attributes; annual update
… subject matter categories include:
  • Total population>
  • Population by gender iterated by age
  • Population by race/origin
  • Households by type of household
  • Educational attainment by detailed category
  • Household Income by detailed category
  • Housing units by owner/renter occupancy
  • Housing units by units in structure
  • Housing units by detailed value intervals

See the related Web section for a detailed list of items.

Use these Data on Your Computer
Use the above U.S. national scope dataset with your own software or in ready-to-use GIS projects with the CV XE GIS software.

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.