Monthly Archives: June 2016

User Group Notes Updated

.. new ProximityOne User Group notes were posted today, June 28, 2016.  See updates at http://proximityone.com/usergroup_notes.htm.

Join the no fee ProximityOne User Group … connect with like-minded folks interested in developing, integrating and using decision-making information. The User Group provides software, data access and application support privileges only available to members.

.. see more information. Join in.

Population by Age, Gender & Race/Origin 2010-2015

.. tools to examine characteristics and patterns of U.S. & state population by age, gender & race/origin, 2010-2015 annually .. access individual state and area profiles.

What are the 10 states with the largest Hispanic population? How is Hispanic population distributed by age in the U.S. or any particular state? In which states does the Hispanic population comprise more than half of the total population? And by age? Get answers to these types of questions using data access and analytical tools described in this section.

Using the Interactive Table
The following graphic illustrates use of the interactive table. Tools are used to select only 2015 and show only the total and Hispanic columns, then rank in descending order on Hispanic population. It is easy to see which states have the largest Hispanic population and in relation to the total population.

Tip of the Iceberg
It’s not just about Hispanic and total population; perform similar queries/analyses by gender and for each of the five major race groups. These data are based on the latest Census Bureau 2015 model-based population estimates released in June 2016. The data options are not limited to the 2015 data; annual revised data for 2010 through 2015 are included. Find out about the size and trends for specific age groups of interest.

More about the Interactive Table
Use the interactive table to perform other types of queries/analyses described above. Click a link in the table to view an extended profile for each area. The profiles are developed using the Regional Demographic-Economic Modeling System (RDEMS). When a profile is opened (new web page), analyze these population by age by gender by race/origin in context of related wide-ranging, multi-sourced data. Access the profiles for drill-down geography including counties and other areas.

Use the RDEMS current estimates (2016) and annual 5-year projections (to 2021) to examine this same scope of subject matter to the county level.

The interactive table includes a row for the U.S. and each state. Column structure and content are described below the table.
• Click the “link” (column 3) to view the RDEMS POP1 profile.
• See about more operations and usage notes below table.

Viewing Extended Profile for an Area
Clicking the link for Arizona, as illustrated above, shows the full “POP1” table/profile for Arizona. Clicking the link is equivalent to clicking this link: http://proximityone.com/rdems/1/rdems04000pop1.htm.
  • click the above link now to view the full profile.
  • California profile
  • Texas profile
  • Access any state using the interactive 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.

Real Gross Domestic Product by State & Area

… tools to access and analyze GDP patterns and trends … Gross Domestic Product (GDP) is a comprehensive measure of U.S. economic activity. This section provides access to annual GDP estimates for the period 2010 through 2015 and tools to analyze these data. The 2015 data are the latest estimates as of June 2016 (about these data). This section provides data and tools focused on the U.S. and states. In September 2016, this section updates to include the new 2015 estimates of metropolitan area GDP and revised historical updates. Follow this blog to receive updates. See the related Web section for more details about topics covered in this post.

Patterns of Per Capita Real GDP & Percent Change by State
The following graphic shows patterns of the 2015 per capita real GDP by state. The color patterns/intervals are shown in the inset legend. In the larger view (click graphic), states are labeled with 2015 per capita real GDP (white label) and percent change in per capita real GDP, 2010-2015. Click graphic for larger view. Expand browser to full window for best quality view. The larger view shows a mini-profile for Texas. Use the GIS tools described below to develop thematic pattern map using any combination of these items from 2000 forward.

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

Importance
GDP is an important part of planning, management and decision-making in the private and public sectors. It is watched closely by all stakeholders as to how the economy is trending. By adjusting current dollar GDP to constant dollar GDP, we can better examine the trends and patterns by removing inflation from the measures. By examining GDP at the metro and sub-state area, businesses and policy-makers can better determine GDP patterns on a regional basis. Regional analysis of GDP is very important as magnitude and change vary widely. By examining the size and trends of regional real GDP on a per capita basis, we are better able to examine patterns and trends at the individual level.

Modeling, Projections & Access/Analysis/Interpretive Tools
GDP is an important part of the ProximityOne Regional Demographic-Economic Modeling System (RDEMS). The RDEMS model specifies cause and effect relationships with GDP and GDP components and other data to develop current estimates and projections.

Use these tools to access/analyze GDP characteristics and patterns:
• interactive table – access in related Web section
• analyzing patterns using GIS resources – see details in related Web ection
• RDEMS database access
.. illustrative example of GDP patterns in context with other measures
.. Texas briefing notes (see notes “Texas per capita real GDP” on that page)
.. Access briefing notes for any state

Interactive Table
Use the interactive table below to examine per capita real GDP by state in context of other states and the U.S. This table expands to include metros in September 2016. The content of the table also expands to include GDP sectors and components

Per Capita Real Gross Domestic Product by State & Area
— 2000-2015
— interactive table
The following graphic shows states ranked on percent change in per capita real GDP. Click graphic for larger view. Use the interactive table to view rankings of interest. Export the data for further analysis.

Analyzing GDP using GIS Resources
— requires 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 GDP GIS project fileset
… requires ProximityOne User Group ID (join now)
… unzip GDP GIS project files to local folder c:\gdp
3. Open the c:\gdp\us1gdp.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\gdp\us1gdp.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.

State Demographic-Economic Briefing Notes

.. with the ever increasing availability of demographic and economic data, it can be difficult to access key up-to-date data for the U.S. and individual states, metros and counties … among other geography.

Here we look at the “tip of the iceberg” — intentionally. This section provides links to access State Demographic-Economic Briefing Notes. A summary of selected key demographic-economic measures and trends for each state are presented in comparison with the U.S. Use the Briefing Notes to facilitate briefings to others, collaboration and to obtain a snapshot of current and trending conditions. These data are mostly taken from the more detailed tables available as links at the bottom of each Briefing Notes section.

The Briefing Notes have been developed using the Regional Demographic-Economic Modeling System (RDEMS). The Briefing Notes sections and related detailed tables update frequently.

The per capita real Gross Domestic Product (GDP) estimates, new this past week from the Bureau of Economic Analysis, for 2010 and 2015 were added today. See how this comprehensive measure of economic well-being is trending and compares to the U.S. overall in states of interest.

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
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

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.

K-12 School System Revenue & Expenditure Patterns

.. while we might first associate K-12 school systems with children and education, they are also an important part of the economy .. jobs, businesses and more. Total expenditure by public school systems, mostly school districts, was $613.6 billion in fiscal year 2014, up 2.6 percent from 2013. These data are based on the latest survey of public school systems conducted by the Census Bureau and sponsored by the U.S. Department of Education. This section provides an overview of these data and tools to access and view/analyze the data. See related full Web section for data access and more details.

Current Spending per Student by School District, FY 2014
… Houston metro area .. click graphic for larger view.

  … view developed using the CV XE GIS software.


.. click graphic to view all states table

Using the Interactive Table
Use the interactive table in the related Web section to examine sources and uses of funds in school districts of interest. The following graphic illustrates use of the table to view selected characteristics (select from many other items) of districts in the Houston metro. Districts are ranked on percent total revenue received from Federal sources. Click graphics for larger view.

Create Analytical Profiles for Districts of Interest
Follow steps in this related section to create analytical profiles for selected districts.

Illustrative comparative analysis profile for two districts
.. graphic shows partial view .. open full xls profile

Join me in a Data Analytics Lab session to discuss more details about accessing these data 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 Million+ Population Cities: Chicago

.. there are 10 U.S. cities having population of 1 million or more … Chicago is ranked 3rd among all U.S. cities based on 2015 population.  The population of Chicago, IL changed from 2,695,605 in 2010 to 2,720,546 in 2015 (24,941 or 0.9%). The population of the U.S. overall changed from 308,758,105 in 2010 to 321,418,820 in 2015 (12,660,715 or 4.1%). Examine population characteristics and trends of the city of Chicago in context of other cities and counties using the interactive table.

Chicago is a principal city of the Chicago-Naperville-Elgin, IL-IN-WI Metropolitan Statistical Area (CBSA 16980). This section reviews selected geographic, demographic and economic characteristics of the city of Chicago and tools to analyze these data.

Chicago City in Regional Context
Chicago city is shown as green-fill semi-transparent area.

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

Chicago Urbanized Area (orange fill pattern below city layer)
.. about urbanized areas

Examining Characteristics, Patterns and Trends of Chicago
View extended demographic-economic characteristics of Chicago in this table. Compare attributes of the city for 2012, 2014 and change. Annual demographic-economic estimates are available for all geographies for areas of 65,000 population or more from the American Community Survey (ACS).

Regional Demographic-Economic System & Cook County, IL
View Cook County tables from RDEMS. Click links below to view demographic-economic characteristics of the county.
POP1 Population & Components of Change
POP2 Population by Age
HSG1 Housing Units & New Residential Construction
DEM1 Demographic-Economic Profile
LF1 Labor Force
LF2 Labor Force
EST1 Establishments, Employment, Earnings
CA4 Personal Income and Employment by Major Component
CA5 Personal Income by Major Component and Earnings by Industry
CA6 Compensation of Employees by Industry
CA25 Employment by Industry
CA30 Economic Profile
CA35 Current Transfer Receipts
CA45 Farm Income & Expenses

Comparing Chicago Annual Total Population to Other Areas
Use the interactive table in the related section to view, rank, query and compare annual population estimates for states, cities, counties and sub-county areas of interest.

View, Rank, Compare Chioago with any/all Other Cities
Use these tables based on ACS 2014 5-year estimates to view Chicago in context with other cities.
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

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.

Metro Situation & Outlook Reports Updated

Regional Demographic-Economic Modeling System (RDEMS) county table links are now embedded in Metro Situation & Outlook (S&O) Reports. Easily access the RDEMS county demographic-economic tables for metros of interest.

Use this link to access the Metro S&O Reports:
http://proximityone.com/metro_reports.htm
… click link in the “Code” column to access a specific metro.

… selected metros …
Atlanta .. Boston .. Charlotte .. Chicago .. Dallas .. Denver .. Los Angeles .. Honolulu .. Houston .. Miami .. Minneapolis .. New York .. Philadelphia .. Phoenix .. San Diego .. San Francisco .. Seattle .. Washington

All metros are available.

Join in … join us in the 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.

New Residential Construction by County

.. what’s happening in the north Dallas metro? .. a lot, take a look at the patterns of new residential construction for Collin and Denton counties using data and tools presented in this section. Examine new residential construction, leading economic indicator, for counties and regions of interest to you anywhere in the U.S. Use of the Regional Demographic-Economic Modeling System (RDEMS) to examine patterns of residential construction in context of related wide-ranging, multi-sourced data.

This section provides a summary of new housing units authorized by building permits for new residential construction for each/all counties. Use data analytics tools and data described here analyze these data and related housing issues.
• interactive data analytics – details/access
• use GIS project/datasets – details/access
• access individual county profiles – details/access

Patterns of New Authorized Residential Units by County
The following graphic shows the 2015 per capita value of total units authorized by county. The four largest Texas metros are shown with bold brown boundaries.
See about subject matter included in datasets.

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

Additional views with counties labeled with name, 2015 housing units and 2015 total new housing units authorized.
Charlotte, NC-SC metro by county
Dallas, TX metro by county
Houston, TX metro by county

Leading Economic Indicator
Building permit data (housing units authorized by building permits for new residential construction) are economic leading indicators. Investors and housing developers use these data to examine the characteristics and trends in new residential housing development. The short time lag between the data reference date and data access date, 1-2 months, makes this set of indicators important in assessing the current situation and patterns during the past year or more. The national scope coverage and geographic granularity (state, metro, county and city) enable comparison among types of areas and peer groups. Finance and real estate professional and researchers examine building permit patterns to develop strategic insights. Government and policy makers use these data to get a pulse on markets and changing patterns to administer programs and operations. See more about these data below in this section.

New residential construction begins with building permits. Overall U.S. housing starts are approximately 2.5% less than permits issued (22.5% less for multi-family units). Completions are approximately 4% less than starts (7.5% less for multi-family units). During the past year-plus, “residential fixed investment” has been approximately $500 billion and remained steady at 3.1% of real Gross Domestic Product.

Access Individual County Profiles
The following graphic illustrates use of the Regional Demographic-Economic Modeling System (RDEMS) to access the HSG1 Housing Units & New Residential Construction tables for a selected county. Click graphic for larger view.

Mecklenburg County, NC [37119] located in the Charlotte, NC-SC metro

Add a link to your Web page for areas of interest: The URL structure for Mecklenburg County is:
http://proximityone.com/rdems/1/rdems37119hsg1.htm
– more in general, substitute the county state+county FIPS code (37119 in this case) to access a county of interest.

Using the Interactive Table
The interactive table includes a row for each county. Column structure and content are described below the table.
• Click the StCty link to view the housing unit/new construction profile.
• Select a metro to examine component counties

The following graphic illustrtaes use of the table to examine characteristics of the Dallas metro counties. 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.