Monthly Archives: April 2016

Texas School District Demographic Trends

.. new data, new insights .. in the 2015-16 school year, there were 21 school districts in Texas (of a total 1,025) with enrollment of 50,000 or more students. Among these districts, six districts experienced an enrollment decline between the 2011-12 and 2015-16 school years. Four districts experienced more than 10-percent increase in enrollment (Frisco, Katy, Conroe and Klein). Use the interactive table to view, rank, query and compare Texas school districts by annual enrollment, 2011-12 to 2015-16 , and change over the period. This section provides access to data analytics tools to examine patterns and characteristics of enrollment for Texas local education agencies. Use the GIS project and datasets described here to examine districts and regions of interest. See the full Web page for more comprehensive version of topics reviewed here.

Enrollment Change Patterns: Texas School Districts. 2011-2015
The following graphic shows patterns of the percent enrollment change by Texas school district during the period 2011-12 to 2015-16 school year. The percent change intervals/colors as depicted in legend panel at left of map window. Create custom maps similar to this view for your regions of interest. Examine alternative patterns such as percent change for different time periods, enrollment change or enrollment level. Set queries to include school district by peer group. Click graphic for larger view with more detail; expand browser window for best quality view.

View developed with CV XE GIS software using the Texas school districts GIS project.

The following views (click link) show a zoom-in with districts labeled with name and 2015-16 enrollment .. install the software and GIS project on your Windows computer for alternative and more detailed views.
Dallas Metro Region
Houston Metro Region
San Antonio-Austin Metro Region

School Districts by Locale Code
The following view shows patterns of school districts by locale code. Examine districts based locale code in the interactive table below. See more about locale code below in this section.

View developed with CV XE GIS software using the Texas school districts project.

Additional School District Demographic-Economic Data
Use the following interactive tables to view attributes of individual school districts in context of others. These are national scope tables; select only Texas (or other state) using tools below table on respective pages. Compare Texas (or other state) school districts by national scope peer group size.
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics
More about data analytics and analyzing the school district community.

Enrollment by Texas Local Education Agency: 2011-12 – 2015-16
— Interactive Table
The following graphic illustrates use of the interactive table. This view shows districts having 2015-16 enrollment 50,000 or more ranked in descending order on the enrollment percent change from the 2011-12 school year to the 2015-16 school year. See the full interactive table to perform similar operations. Click graphic for larger view.

See about other demographic-economic interactive tables.

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 County Business Patterns by Type of Business

.. mapping and analyzing county business patterns by type of business … this section reviews use of tools and methods to develop custom U.S. by county business patterns data by type of business and develop mapping and related GIS applications. Steps illustrate how to develop a U.S. by county business patterns dataset for the supermarket  industry — NAICS type of business code 445100. Use the interactive table in this related section to examine supermarket business characteristics by county. Create map views such as shown below and perform wide-ranging business patterns data analytics using the tools. Develop similar applications for any type of business – see full list of NAICS/type of business categories. This section is focused on Census-sourced County Business Patterns released April 2016. There are additional data resources that can be used in a similar manner reviewed in main Web section.

Patterns of Supermarket Establishments by County
The following graphic shows patterns of the number of supermarket establishments by county for the Houston metro (bold boundary) region. Counties are labeled with the number of supermarkets and county name. Number of supermarkets shown by intervals/colors as depicted in legend panel at left of map window. Create custom maps similar to this view for your regions of interest depicting establishments, employment or payroll for your type of business selection(s). Click graphic for larger view with more detail; expand browser window for best quality view.

View developed with CV XE GIS software using GIS project.

See full Web section to access data, tools and more detail.

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.

Retail Trade Sales by ZIP Code

.. what is the meaning of few or no retail stores with sales over $1 million in a neighborhood or ZIP code? Residential tranquility might be accompanied by limited shopping conveniences. What about adjacent ZIP codes? Absence of larger retail stores suggests lower economic activity. ZIP code 89109 in Las Vegas has 478 retail establishments with sales over $1 million — the largest among all ZIP codes. There are more than 4,700 ZIP codes with no (and more than 10,200 with 1 or none) retail establishments with sales over $1 million. See the interactive table below to examine each/all ZIP codes. Use data and tools reviewed in this section to analyze retail sales patterns by ZIP code. See more detail in related Web section.

Patterns of Retail Trade by ZIP Code
The following map graphic shows patterns of retail trade establishments in Texas and adjacent states with more than $1 million in annual sales by ZIP code. Four Texas metros (Austin, Dallas, Houston, San Antonio) are highlighted with bold boundary. Click graphic for national scope, larger view. Expand browser window for best quality view.

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

As of 2012, there were 30,177 ZIP codes with more than 1.06 million retail trade business establishments. Of these, almost 500,000 establishments had more than $1 million in annual sales. Find out which ZIP codes and the characteristics of businesses in those ZIP codes using tools reviewed here. These are the most recent establishment sales data by ZIP code. They are not available from other national scope sources.

These data supplement the annual ZIP code business patterns data that provide data on the number of establishments, employment and payroll by type of business (NAICS codes) — but provide no data on sales. This section provides interactive access to the retail trade establishments by sales group for all ZIP codes. This section illustrates how these data can be used in GIS applications to examines patterns and associate these with other data. ZIP code and multi-ZIP code area profiles are also shown in this section. Examine market characteristics using profiles from ProximityOne for any combination of ZIP oode areas. ProximityOne uses the sales data to develop custom estimates of retail trade characteristics by additional categories linked with data from other sources.

Examining Retail Trade by Individual ZIP Codes and ZIP Code Groups
The following graphic shows ZIP codes (ZIP code shown by yellow label) in the New York city area. The total number of retail establishments (white label) and the number of retail establishments with annual sales in excess of $1 million (blue label). These ZIP codes are used in profile reviewed below. The interactive table below can be used to show that ZIP code 10036 is among the ZIP codes having the largest number of retail establishments in the U.S.

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

ZIP Code 10036 Retail Trade Establishments & Sales Profiles
View ZIP Code 10036 Retail Trade Establishments & Sales Profile
ZIP Code 10036 Group Supermarket Establishments & Sales Profile

Interactive Table
Use the interactive table in this related section to view, query, rank, compare characteristics of retail trade establishments by ZIP code.

The following graphic illustrates use of the interactive table. All ZIP codes are ranked in descending order based on total retail trade establishments. Click graphic for larger view. ZIP code 10013 in New York city has the largest number of retail establishments.

Use the interactive table to examine ZIP codes and establishment patterns of interest.

Retail Trade Business Categories
• Motor Vehicle and Parts Dealers: NAICS 441
• Furniture & Home Furnishings Stores: NAICS 442
• Electronics & Appliance Stores: NAICS 443
• Building Material & Garden Equipment & Supplies: NAICS 444
• Food & Beverage Stores: NAICS 445
• Health & Personal Care Stores: NAICS 446
• Gasoline Stations: NAICS 447
• Clothing & Clothing Accessories Stores: NAICS 448
• Sporting Goods, Hobby, Book & Music Stores: NAICS 451

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.

Using CV XE GIS: New GIS Start-up Project

.. expanding insights through data analytics ..  a new CV XE GIS start-up project, described in this section, is now part of the CV XE GIS installer. The latest GIS project uses U.S. national scope shapefiles newly developed as of April 2016. You can immediately start using this GIS project in a production manner. See more below. Join in the weekly Data Analytics Lab sessions where structure and use of this project and shapefiles are discussed. See the Web version of this section.

It is recommended that existing users re-install the CV XE GIS software. In addition to the new US1 GIS project, there are software updates. Software updates and related applications will be reviewed in upcoming blog sections focused on “Using CV XE GIS.”

Join the ProximityOne User Group and start using the new US1 GIS project — included with all versions of CV XE GIS software.

National scope state, metro and county layers are all active upon start-up. States are transparent showing only boundaries. Metros/CBSAs reflect a query that has been set to show only the largest 10 metros (based on 2015 population). The county layer shows a thematic pattern map of the population percent change between 2010 and 2015.

CV XE GIS US1 Project Start-up View
The start-up view shows a thematic pattern map of percent population change, 2010-2015.  Click graphic shown below for a larger. more detailed view. Expand browser window for best quality larger graphic viewing.

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

The US1 GIS project includes these shapefiles/resources:
• U.S. by State
• U.S. by Core-Based Statistical Area (CBSA) – 929 metropolitan areas
• U.S. by County – 3,142 county areas
• OpenStreetMaps Web-based tiling layer
• each shapefile includes integrated Census 2010 population and annual population estimates 2010 through 2015.

Full User Interface View

The legend panel, shown below at left of map window, includes seven layers. Five layers are checked on; this results in
the layer being displayed in the map window. The metros and counties layers are included twice; the upper, unchecked, layer is set to show area names as labels.

Applications
• Use the navigation tools to zoom to an area of interest.
.. for example, zoom-in to the Houston metro (click for larger view).
   
• Determine which counties, metros or states are changing most rapidly.
.. and how they are changing.
• Use the latest official population estimates.
• Easily compare county components of a metro to total metro.
• Use the navigation tools to zoom to an area of interest.
.. for example, zoom-in to the Houston metro (any metro).
• Use layer editor tools to add labels, modify intervals/colors, change/add patterns and more.
.. for example, check-on the county labels layer to easily view county names..
• Add other layers showing different types of geography and subject matter.
• Integrate other types of subject matter into the existing shapefiles.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

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

State of the States: 2010-2015

.. examining the how, why and where of population change by state from 2010 to 2015. This section provides an overview of this topic and provides a summary of tools, interactive table and GIS project, to analyze population change by state by county, using latest Census Bureau estimates data through 2015. These data are used by ProximityOne to develop/update annual national state and county demographic-economic projections. See schedule of related 2016 updates. See more about development of these data/reports below.

Updates … see related State and Regional Decision-Making Information section … frequently updated state-by-state pages.

Patterns of Net Migration by State, 2010-2015
The following graphic shows patterns of state net migration during 2010 to 2015. 14 states experienced negative net migration. See in table below. States are labeled with net migration 2010-15 as a percent of 2015 population. 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
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 region’s unique combination of natural change and migration provides insights into why its population is changing and how quickly the change is occurring.

State by County Profiles
Click a state link to view a state by county profile. For each state, eight tables of population change are presented. Each of the eight tables shows characteristics of each/all counties in the state in addition to state overall.

Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
District of Columbia
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

Use the Interactive Table
.. to examine patterns in states of interest. The following interactive table graphic shows the 14 states that experienced negative domestic migration during the period 2010-2015. See full full interactive table. Click link 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.

Appalachia Region & County Population Trends

.. examining how is the Appalachia population changing and why .. Appalachia is a region that includes parts of 13 states and has long been challenged with poverty. The population of Appalachia increased from 25,184,339 in 2010 to 25,449,932 in 2015. The extended report below, developed using the ProximityOne Regional Data Analytics tool, in combination with GIS tools provide insights into why, how and where the population change has occurred since 2010.

Patterns of Appalachia County Population Trends 2010-2015
Appalachia counties are shown in the following graphic with the black bold boundary. The thematic pattern map shows how counties have gained population (blue and green) and lost population (orange and red) during the period 2010 to 2015. It is easy to see clusters of counties that are increasing or losing population and why. Counties increasing in population are shown by the dominant factor contributing to their growth — net migration or natural change (where births exceed deaths). Counties decreasing in population are shown by the dominant factor contributing to their population loss — net migration or natural change (where deaths exceed births). See more detail and access data via interactive table in the County Trends 2010-2015 section. Click graphic for larger view; expand browser window for best quality view.

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

Summary of Population Change
Appalachia has increased in population since 2010 due to both net migration and natural increase. The analyses show that during the 2010 to 2015 period, the Appalachia population:
• increased by 1,688,832 births
• experienced 1,562,810 deaths
• had a natural increase (births less deaths) of 126,022 population
• increased by 166,990 net international migration
• increased by 53,209 net domestic migration
• had a net migration of 220,199 population

Region & County-by-County Population & Components of Change
The RDA report includes eight tables for each county and a summary for the Appalachia region. Tables displayed when using the “Population Estimates & Components” data include:
• Table 1 – total population
• Table 2 – births
• Table 3 – deaths
• Table 4 – natural change
• Table 5 – international migration
• Table 6 – domestic migration
• Table 7 – net migration
• Table 8 – group quarters population

Appalachia Counties & Region: Population Trends & Components of Change; 2010-2015
Click link below to view report. Data for all Appalachia counties, followed the regional summary, are provided table-by-table in the table sequence shown above.
Appalachia region population & components of change 2010-15

Terms of Use
The above report may be used for any purpose provided that:
1 – it is not used for commercial or consulting purposes.
2 – it is not used in funded research.
3 – all use is referenced as to source with Web URL:
— developed by ProximityOne based in part on Census Bureau data; http://proximityone.com/rda.htm.

Using the RDA Resources
Use the RDA tool to develop reports like the one shown here for counties and regions of interest. Possibly more importantly, these resources can help us examine related topics such as healthcare and education. What are the characteristics and requirements now and how are needs, services and capabilities distributed across a region? How will the population change over the next several years and possibly result in improving – or deteriorating – conditions? Use the RDA demographic insights features and predictive analytics to better assess future change and needs.

Contact ProximityOne (mention RDA in text section or call 888.364.7656) for more information about using the RDA resources or custom reports.

Support Using these Resources
Learn more about accessing and using demographic-economic data and related analytical tools. Join us in a Data Analytics Lab session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

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.

April 2016
M T W T F S S
« Mar   May »
 123
45678910
11121314151617
18192021222324
252627282930  
  • Recent Comments

    What’s New In… on Data Analytics Trends in the…
    What’s New In… on Creating & Using Address…
    Homeownership Patter… on Mapping Demographic Patterns:…
    Using Census 2010 Su… on Mapping Demographic Patterns:…
  • Archives

  • Meta