An important feature new to MetroDynamics is the availability of the integrated Pascal/Delphi-like scripting language and processing.  Use this feature for tasks ranging from computing/displaying a cell value in a grid to developing estimates and projections and performing impact analyses.  The estimation and projection process can optionally make use of the already existing MD data.  Insert estimates and projections into the standard MD display grid for both analysis and publication.  The Pascal/Delphi-like scripting language and processing is available in other Proximity tools including CommunityViewer.

The scripting language/processor is a special case deployment of the more general Proximity IDE (Integrated Development Environment).  The Proximity IDE enables the user to develop stand-alone projects independent of Proximity tools such as MetroDynamics or CommunityViewer.  Use the Proximity IDE to merge and analyze multi-sourced demographic-economic-geographic data to meet wide-ranging application needs.  The Proximity IDE is very similar to a Delphi or Visual Studio IDE.  All elements in the IDE like the code editor, object inspector, tool palette, etc., are available for standalone or integrated use.  A "developer tool", the Proximity IDE enables developers to create their own software for others to use.  Such resulting software/applications can be sold by developers with no royalty or fee paid to Proximity or any third party.

See more information about using the scripting operations.

The Census Bureau released the national scope county-level 5-year age-race/ethnicity-gender population estimates in August (next Census sourced update August 2009).  The new July 1, 2007 estimates extend on the annual population estimates starting with July 1, 2000.  These estimates provide the most detailed annual U.S. by county demographic updates by age-race-gender available for all counties.  See more about scope of age-race/ethnic-gender categories.

Using MetroDynamics, these county level data are summarized at the metropolitan statistical area level creating a separate dataset for all Core-Based Statistical Areas (CBSAs -- MSAs and MISAs) with the same level of 5-year age-race/ethnicity-gender as for the county level dataset (see examples of CBSA data rankings).

Proximity uses these data, in combination with other data, to develop county-level 5-year age-race/ethnicity-gender population projections to 2020.  These data are accessible in MetroDynamics or as a standalone dataset.

See more information about accessing/using these data in MetroDynamics.

See related news about associated single-year of age county-level estimates.

Second quarter 2008 census tract demographics are now accessible via MetroDynamics.  The extended census tract profile, accessible for any of the U.S. approximate 65,000 census tracts, now includes selected Census 2000 demographics, first quarter 2008 demographics, and second quarter 2008 demographics.  See additional information and examples of viewing/analyzing these tract demographics with MetroDynamics.

The 2007 American Community Survey (ACS) data is scheduled for release by Census beginning August 26.  These notes provide a schedule preview.  More detail will be provided in September and October DMINews.  The 2007 ACS data will join the 2006 ACS data now accessible in MetroDynamics.

The 2007 ACS will include one-year estimates available for the nation, all states, D.C., Puerto Rico, each congressional district and all counties, places and metropolitan areas with populations of 65,000 or more (thus including 361 MSAs of the total 363 MSAs).

August 26, 2008

Annual release of ACS income, earnings and poverty data, in conjunction with the Census Bureau’s annual release of income, poverty and health insurance estimates from the Annual Social and Economic Supplement to the Current Population Survey.  These are 2007 ACS one-year estimates for areas with populations of 65,000 or more.

September 23, 2008

2007 ACS one-year estimates on social, economic, demographic and housing characteristics; special population profiles; and Public Use Microdata Sample data.

(sample profiles based on 2006 ACS data using MetroDynamics)

December 2008

The first general demographic updates since Census 2000 become available for areas with population 20,000 to 64,999.  The three-year estimates will be based on data collected from 2005 to 2007.

In 2010, Census plans release of estimates based on the period 2005 to 2009 and will include the smallest of geographic areas — down to the tract and block group levels.

The Census Bureau has released the U.S. national population projections by detailed age-race/ethnicity-gender to 2050 (August 14).  There are no sub-national projections, although Proximity uses these national level data for state, metro, and county age-race/ethnicity-gender projections.

Total Population

The nation is projected to reach the 400 million population milestone in 2039.

The U.S. reached 300 million population in 2006-07.

-- See Outlook2050 table display showing population trends

School Age Population

The school age population (ages 5-17 years) is projected to increase from 53.9 million in 2008 to 73.4 million in 2050.

The school age population, as a percent of total population, is projected to continue to decline through 2050.

-- See Outlook2050 table display showing population projections for school age children

Minorities

Now roughly one-third of the U.S. population, minorities are expected to become the majority in 2042.

-- See Outlook2050 table display showing population by race/ethnicity by year

The nation is projected to be 54 percent minority in 2050.

By 2023, minorities will comprise more than half of all children.

By 2050, the minority population (all except for non-Hispanic, single-race whites) is projected to be 235.7 million of total 439 million.

65 Years and Over

In 2030, when all of the baby boomers will be 65 and older, nearly one in five U.S. residents is expected to be 65 and older.

This age group is projected to increase to 88.5 million in 2050, more than doubling the number in 2008 (38.7 million).

-- See Outlook2050 table display showing population 65 years and over in context of other age groups.

The 85 and older population is expected to more than triple, from 5.4 million to 19 million between 2008 and 2050.

How will your state(s), metro(s), and counties of interest be changing?  See more on this topic in the September DMINews.

Using these Data.  As released by Census, these data are structured in four Excel/CSV files (population, births, deaths, migration) with the time series structure arranged row-by-row rather than by age across columns (thus enabling analysis of an age/age group in a more conventional time series manner).  The MetroDynamics Database>Build Data feature restructures and integrates these data with other related data for analysis.  The resulting file may be used with any application.  This also enables the analysis of these estimates/projections with the MetroDynamics U.S. by county (and geo-aggregates) Single-Year of Age-Race/Ethnicity-Gender View (See details in MetroDynamics Guide).

The Census Bureau annual county housing unit updates/estimates (July 2007) are now available (August 21).  See the interactive county housing units ranking table to view annual housing units by county 2000 through 2007, change/percent change 2006-07, and change/percent change 2000-07.  This ranking table joins many other ranking tables available for county and other types of geography with wide-ranging demographic-economic subject matter.  See ranking tables main page.

The housing unit time series data have been integrated in the MetroDynamics Metros master file and aggregated to the CBSA-level for all MSAs and MISAs.  This makes the county level data conveniently available for assessing change/composition for metro-to-metro and within metro composition analyses.  \

Labor force, employment and unemployment estimates by metropolitan area and county for July 2008, were released by the U.S. Bureau of Labor Statistics on August 27.  Based on the monthly data, Proximity updates the corresponding MetroDynamics (MD) quarterly labor force time series.  See example of how these data are displayed as a times series for a metropolitan area in the MetroProfile View. See national map  quarterly unemployment rate by MSA below.  Prepare your own custom analytical views of MD data with your data and preferred labeling, coloring, rendering, etc. using MD

MSAs ranked on unemployment rate 2008Q2 (descending order, rightmost column) with unemployment rate above 10% in 2008Q2 (using MetroDynamics). This partial view of the MD spreadgrid shows selected labor force items integrated with many other related measures for spreadsheet and related analyses.

Selected labor force characteristics may be viewed in the interactive ranking table. http://www.proximityone.com/mdselected_lf.htm.

The following ranking table view shows MSAs ranked in ascending order based on 2008Q2 unemployment rate.

Unemployment rate 2008Q2 by MSA using MetroDyanmics MapView

The housing price index by metropolitan area for 2nd quarter 2008 data were released by the Office of Federal Housing Enterprise Oversight on August 26.  These data have been added to the MetroDynamics (MD) database.  See national map HPI quarterly percent change by MSA below.  Prepare your own custom analytical views of MD data with your data and preferred labeling, coloring, rendering, etc. using MD

MSAs ranked on HPI change 2007Q2 unemployment rate 2008Q2 (descending order, rightmost column) with unemployment rate above 10% in 2008Q2 (using MetroDynamics).  This partial view of the MD spreadgrid shows selected HPI items integrated with many other related measures for spreadsheet and related analyses.

The MD MetroProfile for the Merced, CA MSA shows more HPI detail and in context with many other related measures.

HPI Percent Change 2007Q2 to 2008Q2 MSA using MetroDynamics MapView