Database>dBMerge enables merging dBase files based on common key fields.
This section reviews use of the dBMerge operation to integrate subject matter data into a shapefile. The dBase file gz_2010_us_050_00_500k.dbf described in the dBCreate section contains no demographic subject matter data. While a map can be made of the U.S. by county using the shapefile gz_2010_us_050_00_500k.shp, thematic pattern maps cannot be created before first integrating data with the shapefile.
This section illustrates steps to integrate demographic subject matter data from the U.S. by county Census 2010 Demographic Profile Summary File (DPSF) into the gz_2010_us_050_00_500k.dbf.
Levels 2, 3
Main menu Database>dBMerge
Setup steps ...
|•||Expand http://proximityone.com/usergroup/1/dpsf2010mstr_050.zip to c:\cvxe\1\dpsf2010mstr_050.dbf|
|•||Expand http://proximityone.com/usergroup/1/gz_2010_us_050_00_500k_copy.zip to c:\cvxe\1|
Verify the files c:\cvxe\1\GZ_2010_US_050_00_500K_copy.DBF and c:\cvxe\1\dpsf2010mstr_050.dbf exist on your computer.
Use Open Source File 1 to open c:\cvxe\1\GZ_2010_US_050_00_500K_copy.DBF (the dbf associated with the shapefile)
Use Open Source File 2 to open c:\cvxe\1\dpsf2010mstr_050.dbf
The dBMerge form now appears as shown below.
Click the Create button; the Source Fie 1 and Source File2 fields populate:
Change the Key1 and Key2 files to state+county as shown below.
Select the 6 fields in Source File 1 and click Move Selected under Source File 1.
View now appears as shown below,
Select fields in Source File 2 starting at D0010001 though last field and click Move Selected under Source File 2.
Click Merge button and merge starts. Wait until merge complete and allow overwrite.