|
|
|
DMINews -- September 2007
Topics: • County Population Trends by Single Year of Age by Race-Ethnicity by Gender • County School Age Population Trends • American Community Survey 2006 • CommunityViewer Online Data Access Updates • Metropolitan Area Gross Domestic Product County Population Trends -- Single Year of Age by Race/Ethnicity by Gender The Census Bureau released the 2006 county population estimates by age-race/ethnicity-gender in August 2007. These data have been integrated into the CountyTrends (http://proximityone.com/countytrends.htm) module of CommunityViewer enabling comparative and trend analysis at the county and multi-county (such as a metro) level. Estimates prepared by Census are used in CommunityViewer to develop/analyze annual projections. Census Bureau age-race/ethnicity-gender estimates provide 5-year age cohort breakouts. Many analyses, such as those focused on the K-12 school age population, require different age breaks. The ideal way to meet all such needs is to use single year of age detail. The Census Bureau, in collaboration with the National Center for Health Statistics, develops annual (through 2006) bridge estimates. The bridge estimates provide single year of age (0 through 84 and 85+) by race/ethnicity by gender. 
The Proximity AREG (Age-Race/Ethnicity-Gender) software may be used to directly
expand the Web-sourced 4.4 million record dataset in zip format into dbase file structure
for use on your computer.
The source zip file is automatically downloaded, expanded, converted into dbase, and source/intermediate files deleted.
Following that step, use AREG to aggregate single year of age data to meet your needs.
The illustrative settings shown in the graphic were used to generate a file containing records for Arizona by county summarizing the population ages 5 through 17, White, Hispanic, and Male. See the sample Excel file. The file shows records for three counties. The first set of columns correspond to the Census Bureau annual population estimates and components of change (see full field listing). Those columns are followed with the MSA/MISA codes and names as applicable. Those columns are followed by the columns containing the annual estimates for the population ages 5 through 17, White, Hispanic, and Male -- as derived through use of the AREG software. Percentages, relative to total population are included. This file is ready to be use in the following ways: • open in CommunityViewer dBrowser for query/filter/tabular viewing, • open in Excel or equivalent for tabular file processing, • open in your preferred statistical package for more extensive analyses, and/or • integrate with a state/U.S. county shapefile for geospatial analysis (using CommunityViewer dBMerge) • view/analyze the data in thematic maps. County School Age Population Trends 53 Texas counties had population growth in the K-12 school age population (ages 5-17 years) from 2000 to 2006. Which counties are they? How did they change? What about other Texas county school age population trends? What about similar trends in other states? Use the new county ranking table http://proximityone.com/cty0006_517.htm to view how school age population has changed by county throughout the U.S. since 2000. Click on a header column and sort the table on an enrollment or enrollment change measure. Click the same column header again to sort the other direction. Data used to develop the ranking table were developed/extracted using the AREG utility (see above). Similar ranking tables can be developed for any age group crossed by race/ethnicity and gender using the AREG utility. American Community Survey 2006 The 2006 American Community Survey (ACS) data are now available. The ACS is the Census Bureau annual population and housing statistical survey program. The ACS 2006 data will be widely used to access more up-to-date demographics for areas for 2006 and examine change since Census 2000. The scope of subject matter data have some similarity to the approximate 600 subject matter items in the Census 2000 Demographic Profiles (DP) DP1-General Demographics, DP2-Social Characteristics, DP3-Economic Characteristics, and DP4-Housing Characteristics. Summary data developed from this program provide demographic estimates for geographic areas including 109th Congress congressional districts, metro areas (core based statistical areas), counties, places, school districts, and other having a population of 65,000 population and over. Access data using the Census Bureau FactFinder -- Interactive or Download. Access data by FTP from the Census Bureau server. Access data interactively using the Proximity CommunityViewer Online Data Access feature -- see next item. CommunityViewer Online Data Access Updates The CommunityViewer (CV) Online Data Access (ODA) module, available in all versions of CV (no fee and fee versions), is a client/server application enabling the user to access diverse, multi-sourced demographic/economic data. ODA gives you easy access to demographic/economic data by state, metro, county, school district, census tract and other geographies, from Proximity and several Federal statistical agencies and programs, using a simple, standardized form. Recent updates to ODA include access to the 2006 American Community Survey; 2005-06 school district enrollment and related characteristics; metro, county, place/subcounty intercensal population estimates (annual 2000 to 2006); metro and county regional economic time series data and narrative summaries; among others. ODA provides easy-to-use access to Census 2000 SF1 through SF4 for all of the above geographies and the Census 2000 School District Special Tabulation for school districts. As illustrated in the following graphic, the user can have a CV GIS map project open (this example shows San Diego by census tract), select a geographic object in the map (a census tract in this example) and then access any of the standard Census 2000 summary data (SF1 through SF4 tables) using ODA (this example shows the FactFinder accessed profile (SF3 Table P053, median household income) in the panel beneath the map view). ODA performs this operation without new/additional software or database, using the existing server applications. Navigate back-and-forth between the local Win32 application (map view) and the ODA client-server operation to call up data for any selected geographic object. Click the graphic for a larger view; press F11 key when it displays for the best view. 
Watch DMINews for updates and extensions. Metropolitan Area Gross Domestic Product: Analyzing Trends & Industrial Composition New annual estimates of Gross Domestic Product (GDP) by metropolitan area have been developed by the U.S. Bureau of Economic Analysis. GDP by metropolitan area is the measure of the market value of final goods and services produced within a metropolitan area in a particular period of time. GDP estimates provide the most comprehensive measure of economic activity. The new metro annual (2000 through 2005) estimates mark the first time these estimates have been developed for metros/sub-state areas. The metro GDP estimates are broken out by industrial sector where confidentiality and data availability permit. GDP estimates can help answer questions such as: what is the size of the metro economy? Is a metro economy growing or declining? What industries are driving a metro economic growth? How does the change in one metro economy compare to change in other metros, states and the U.S.? What has been the trend in economic change over time in a metro? Proximity has developed tools that help users answer these questions, integrate these data with other data, and gain insights into metros of interest. See the Gross Domestic Product by MSA ranking table at http://www.proximityone.com/msa_gdp_rank.htm. The Proximity MetroGDP is an integrated software and database tool that you can install on your Windows computer. MetroGDP includes the all U.S. MSA BEA GDP database, Census Bureau annual population estimates (2000 annually through 2006) with components of change and housing estimates, and shapefiles for mapping applications. The MetroGDP software includes the MetroGDP program and CommunityViewer GIS software. Virtually no training is required to make immediate effective use of these tools. Integrate your own data. The MetroGDP package is designed for users who do not need the more extensive data and software capabilities available in MetroDynamics. Database management features enable you to view, query/filter, export and perform other database operations. Per Capita Real Gross Domestic Product 2005 by MSA (click graphic for larger view then press F11) 
Sample screenshots of the MetroGDP operations are shown below. Press F11 key after display for bet view. Single MSA, time series, by general subject matter category -- these views show two years; 5 years are available or choose any one. • Coeur d'Alene, ID MSA GDP by Sector • Coeur d'Alene, ID MSA Real GDP by Sector • Coeur d'Alene, ID MSA Per Capita GDP by Sector • Coeur d'Alene, ID MSA Price Deflators by Sector Multiple MSAs, Comparative Analysis, time series, all sectors • Coeur d'Alene, ID & Idaho Falls, ID MSA Per Capita GDP by Sector Multiple MSAs, Comparative Analysis, time series, selected industry -- pick any sector by using dropdown pick-from-list. • MSAs intersecting Georgia -- Per Capita GDP for Information Sector Multiple MSAs, Comparative Analysis, time series, selected industry -- example of Excel copy (click a button to generate XLS from any grid view) • MSAs intersecting Georgia -- Per Capita GDP for Information Sector More Information Contact Proximity for more information about any of the topics reviewed in this section. |
|
|