Demographic Data Analyst


Hide Navigation Pane


Previous topic Next topic No directory for this topic No expanding text in this topic  


Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Comments (...)




dBMerge is used to merge two dBase 4 files based on a common key and user selected fields.


Use Tools>dBMerge to start.  When started, the dBMerge window/form opens.  See below.

Close dBMerge by clicking formclose in upper right of form.

dBMerge processes only dBase 4 files.


dBMerge Operations Example


In this example dBMerge is used to census tract demographic data into the Census 2010 census tracts shapefile dbf.

The resulting shapefile may be used in a subsequent application to develop thematic maps showing demographic patterns.

This application illustrates the process using New York statewide census tracts.


Required files:

1.Census 2010 census tracts shapefile (tl_2010_36_tract10.dbf)

2.Census 2010 Demographic Profile (cen2010tdp1_36.dbf)

3.ACS 2010 5-year estimates Demographic Profile 2 (acs2010tdp2_36.dbf)


See in graphic below ...

Source File 1

Use Source File 1 Open button to open C:\cv\rome\tl_2010_36_tract10.dbf

Source File 2

Use Source File 2 Open button to open C:\dda\CEN2010TDP1_36.dbf

Output File

Normally leave as specified



Click Create button (top of form) and item sections populate.

Set the keys under Source File 1 and Source File 2.


Select Items

Source File 1

In this example, all items are selected from Source File 1 (click SelectAll below Source File 1)

Click Move Selected and those items will be moved to the first set of fields in the new output file.

Note that the output file has now been populated.


Source File 2

Selected code fields are selected from Source File 2 plus all demographic fields except male age fields and female age fields.

Source File 2 Move Selected is clicked.  Source File 2 items are shown as "type 2" in the Output File following the list of Source File 1 fields.



Review all settings and click Merge (top of form).


The merge progresses and status is shown by a progress bar (not shown in these graphics).


4919 tracts are processed.  The final step is to click Yes to overwrite of Source File 1 with the new Output File.



The dBMerge form then closes.





Each record is sequentially processed in Source File 1.

For each record in Source File 1, a query is performed on Source File 2 based on the KEY values.


Comments (...)