|
|
|
DMINews -- April 2008
Topics: • MetroDynamics Quarterly Economic Updates • High Level Industry County Quarterly Economic Analysis • CommunityViewer Feature Updates • Using TIGER/Line Shapefiles -- creating streets shapefiles • Assessing Regional Economic Change -- Local Personal Income Updates • Analyzing Metropolitan Area Population Change -- new 2007 estimates and 2020 projections • School District Finances MetroDynamics Quarterly Economic Updates MetroDynamics (MD -- http://proximityone.com/md.htm) will be updated with the detailed (subject matter data by maximum detailed NAICS category) 2007Q3 quarterly establishments, employment, and earnings (EEE) data based on employer reported data from the Bureau of Labor Statistics ES-202 program. See http://proximityone.com/md1.htm for a description of subject matter included in MD. MD provides quarterly time series EEE data from 2004Q1 forward, then making a 15 quarter series. Use the optional MD feature to estimate data suppressed data and use continuous quarterly measurements in your analyses. EEE-HI Database. Use the new U.S. by county "high level industry" EEE data (EEE-HL) for visual and tabular analysis. Updated quarterly, these data may be used with the new HLIAnalyst (see below) to examine composition, patterns, and trends. High Level Industry County Quarterly Economic Analysis -- introducing HLIAnalyst The new HLIAnalyst integrated software and database tool enables uses to analyze county level quarterly economic high level industry trend data. The quarterly updated database enables users to examine employer reported "ES-202" data on establishments, employment and earnings with only a 7-8 month lag from the reporting period. Easy access to county (or custom aggregate) area economic trend data. Supported with on-demand graphic analysis/charts and analytical operations such as location quotient analysis. CommunityViewer (CV) Feature Updates Merging Hierarchical Files. The CV Database>dBMerge feature (Level 2+) has been enhanced to support merging of hierarchical files. The following graphic illustrates merging the output file from HLIAnalyst with the U.S. by county 2007 population estimates file. The filter edit box beneath the Source File 2 specifies owner='5' .and. naics='10 ' which filters source file 2 to include only records that meet this criteria. Any existing fields in the source file 2 may be used in the SQL-like query instruction. CV 2 and higher user may download the upgraded CV version. 
click for larger view then press F11 key Generating Streets Shapefiles. The CV Tools>Edge2Street feature (Level 2+) has been added to process TIGER/Line shapefiles released 3/31/08 Edge2Shape integrates the Census sourced edge shapefile and address/faces associated database files to create a streets shapefile. A streets shapefile is not available from Census. No source file fields are modified; new fields are added to the edge structure in generating the streets shapefile. Automated TIGER/Line Shapefile (TLS) Downloading. The CV File>GetWebGeodata feature (Level 2+) has been totally revamped to enable pick-from-list TLS downloading. National, state and county files are supported. When the county>edges option is selected the edge shapefile, addr.dbf and faces.dbf are downloaded/expanded and ready ready for Edge2Street operation (above). Using TIGER/Line Shapefiles -- Developing Maps The Census Bureau TIGER/Line shapefiles were released in March. Notes in this section will provide links to additional information on procedure for developing maps using these files. Making Street Maps for Geospatial Analysis. Steps summarized below provide a guide to developing a streets shapefile and making this shapefile part of a reusable GIS project. The application is focused on Maricopa County, AZ (Phoenix area) but can be applied to any area. Note that Maricopa County is now MTAIP completed with release of the 3/2008 TLS data; previously small area geography shapefile for this county were substantially inaccurate. 1. Use CV>GetWebGeodata to download and expand the TIGER/Line shapefiles (Maricopa County edges and associated database files; Maricopa County census blocks; and Arizona state by county and place). This step places the basic data on your computer. 
2. Create GIS project using File>Autoload. This step builds the basic CV project, a reusable GIS project. Ignore section 4 for LUCA operations only. 
3. Use CV>Edge2Street to create streets shapefile from edge shapefile (before this step, use Database>Create/Modify to reattribute the TLID field to character in the ADDR and FACES dbase files). The resulting streets shapefile can now be used for many applications. 
4. Add the streets shapefile and modify the view. The place of Goodyear, AZ (as of 1/1/2007) appears in red. 
5. Add the Census block layer added. Census blocks appear with blue boundaries. Zoom-in view to northern section of Goodyear place. A census block is profiled. 
The "Using TIGER/Line Shapefiles" is the first of a continuing series of coverage in DMINews, linking these files and their use to other map files, economic, and demographic data becoming available. Assessing Regional Economic Change -- Local Personal Income Updates How is the regional economic infrastructure in your counties/regions of interest changing? The Bureau of Economic Analysis is scheduled to release the annual local area personal income series updates in April. Also referred to as the Regional Economic Information System (REIS) data, the local area personal income series provides annual economic measures by county, metropolitan area, economic area and other geographies. This annual update will provide new 2006 annual estimates and revised earlier year estimates as applicable. Most data items are available annually from 1969 forward. The personal income estimates and related components of personal income are perhaps the most widely used, reliable measures of economic activity and trends for individual counties and multi-county regions. The REIS data are integrated into MetroDynamics (MD -- http://proximityone.com/md.htm) included in metropolitan area ranking tables. Watch this section for updates. Analyzing Metropolitan Area Population Change Metropolitan area 2007 (7/1/2007) population estimates and components of changes have been tabulated by Proximity based on estimates are based on the county 2007 population estimates released the Census Bureau in March (see March DMINews). These updated estimates have been used by Proximity to develop all MSA population projections to 2020. • See overview description -- http://proximityone.com/msa0007.htm • See interactive ranking table with projections to 2020 -- http://proximityone.com/msa07rnk.htm • Acquire the estimates/projections in shapefile structure -- http://proximityone.com/msa0007.htm#file The metropolitan area population estimates and components of change data data are integrated into MetroDynamics (MD -- http://proximityone.com/md.htm). School District Finances School district financial data for fiscal year 2006, collected and tabulated by the Census Bureau under the sponsorship/funding of the U.S. Department of Education, are now available. These data are the only source of national scope school district level financial data. These data will be covered in more detailed at counterpart (updated for year of coverage) Web page http://proximityone.com/sdf.htm. The school district financial data are integrated into CommunityViewer School Demographic Analysis integrated software and database (CV SDA -- http://proximityone.com/cv_sda.htm) and included in school district ranking tables. Additional Information Contact Proximity for more information about any of the topics reviewed in this section. |
|
|