Proximity Home PagedBMerge ... data integration tool




dBMerge Main Page
 
 
Integrating 2003 County Population Estimates
  into Shapefiles for Visual Analysis

Click to View The Census Bureau released the July 1, 2003 U.S. by county population estimates (and components of change) in April 2004. These data are important as they are believed to be the most accurate county level population estimates available, developed through a coordinated process involving input from specialists in all states. In addition, these population estimates are regarded as official for all Federal programs, most state and local government programs, and in other applications requiring the "most current official county population data." See the press release for an overview.

Using Proximity dBMerge, you can create a map file (shapefile) containing the population estimates and components of change data. In addition to the July 1, 2003 population estimates, updated/revised estimates are provided making the annual series from 2000 through 2003. Within minutes you are able to use these data in thematic maps and for visual analysis. Prepare maps such as the one shown on this page. Follow the steps outlined below.
  1. Download the Census Bureau sourced dataset. Right click this link and save to ("Save target as ...") c:\cty2003\co-est2003-alldata.csv on your computer.

  2. Download/expand the U.S. by county boundary file
      - Unzip/expand this file to the folder c:\cty2003.

    Alternatively, use any selected state by county boundary file and build the state by county population estimates shapefile for the selected state.

    - Choose the selected state from this list.
    - Follow procedures as otherwise described here, being careful to substitute your selected state by county boundary file name (e.g., co48_d00 for Texas) wherever the U.S. by county file name is referenced (co99_d00).

  3. Download the CTY2003 file structure. Right click this link and save to ("Save target as ...") c:\cty2003\cty2003.dbf on your computer.

  4. Start dBMerge and use DBFManage>View/Process to load the data into the dBase structure.

      • On the DataView file name, select c:\cty2003\cty2003.dbf
      • Click on Import on the DataView window.
      • Choose File of type All files and file name c:\cty2003\co-est2003-alldata.csv.
      • The file load occurs immediately and requires seconds to complete.
      • Click X to close DataView and return to dBMerge main window.

  5. From dBMerge main window choose Integrate>Merge and proceed as follows:

      • Set Source File 1 as c:\cty2003\co99_d00.dbf
      • Set Source File 2 as c:\cty2003\cty2003.dbf
      • Let Output File use default location
      • Click Create button
      • Click Move All Fields under Source File 1
      • Click Move All Fields under Source File 2
      • Delete the entry "200NAME,C,65,0" in Output File listbox (redundant entry)
      • Set the Source File 1 Index Field to state+county
      • Set the Source File 2 Index Field to st+cty
      • Click Merge
          In the integrate process not all DBF2 records will be located:
          - ST+CTY=51560 (Clifton Forge merged into county) will not exist
          - ST=72 (Puerto Rico) will not exist
          Click 'OK' as necessary until message "Overwrite Source File 1" appears
      • Respond Yes to Message "Overwrite Source File 1?"

  6. The shapefile co99_d00.shp may now be used with software such as ArcExplorer or ArcView to create thematic maps using the subject matter fields listed in the table shown below.

CTY2003 Data Fields

CTY2003 Data Fields
NAME County Name
ST State FIPS code
CTY County FIPS cod
REG Census Region
DIV Census Division
MISA03 MISA 2003 code
MSA03 MSA 2003 code
CSA03 CSA 2003 code
MD03 MD 2003 code
MISANAME MISA Name
MSANAME MSA Name
CSANAME CSA Name
MDNAME MD Name
P2000 4/1/2000 resident Census 2000 population
P2000B 4/1/2000 resident total population estimates base
P2000E 7/1/2000 resident total population estimate
P2001E 7/1/2001 resident total population estimate
P2002E 7/1/2002 resident total population estimate
P2003E 7/1/2003 resident total population estimate
P0003 Population Change 7/1/200 - 7/1/2003
P0003PCT Population Percent Change 7/1/200 - 7/1/2003
B2000 Births in period 4/1/2000 to 7/1/2000
B2001 Births in period 7/1/2000 to 7/1/2001
B2002 Births in period 7/1/2001 to 7/1/2002
B2003 Births in period 7/1/2002 to 7/1/2003
D2000 Deaths in period 4/1/2000 to 7/1/2000
D2001 Deaths in period 7/1/2000 to 7/1/2001
D2002 Deaths in period 7/1/2001 to 7/1/2002
D2003 Deaths in period 7/1/2002 to 7/1/2003
MINTL2000 Net international migration in period 4/1/2000 to 7/1/2000
MINTL2001 Net international migration in period 7/1/2000 to 7/1/2001
MINTL2002 Net international migration in period 7/1/2001 to 7/1/2002
MINTL2003 Net international migration in period 7/1/2002 to 7/1/2003
MINT2000 Net internal migration in period 4/1/2000 to 7/1/2000
MINT2001 Net internal migration in period 7/1/2000 to 7/1/2001
MINT2002 Net internal migration in period 7/1/2001 to 7/1/2002
MINT2003 Net internal migration in period 7/1/2002 to 7/1/2003
R2000 Residual for period 4/1/2000 to 7/1/2000
R2001 Residual for period 7/1/2000 to 7/1/2001
R2002 Residual for period 7/1/2001 to 7/1/2002
R2003 Residual for period 7/1/2002 to 7/1/2003


goto top
Copyright © . Proximity. All Rights Reserved.
Sitemap | Contact Us | News