|
|
|
Integrate Data from Federal Servers dBMerge Tour |
dBMerge: software for integrating multisourced data dBMerge is a data integration program that allows you to merge data from multisourced files to new, merged data output databases. 
Make a ZIP code (or most any type of geography) thematic map using demographic data
similar to the one shown at the right for your area by downloading map and subject matter data files
from the Census Bureau Web servers. The downloaded files are then processed with dBMerge
enabling you to prepare maps and use the data with various programs.
See details.
dBMerge is a Win32 application that you use on your Windows-based computer. dBMerge is available as a standalone application. It is also an integrated feature in the CommunityViewer software. Click here to purchase:
dBMerge can provide cross statistical program/statistical agency data integration solutions. For example, merge national scope school district administrative and fiscal data from the National Center for Education Statistics with data from Census 2000. See how dBMerge can automatically convert downloaded data from Federal Geostatistical Servers into ready to use data. Not limited to geographic-subject matter integration. Though important, the applications of dBMerge that involve integration of geographic and demographic data for mapping is only one of many important, diverse application areas. Any set of data that share, or can be structured to share, common keys can be integrated into value added databases using dBMerge. While dBMerge provides technical solutions to technical problems, the software is designed for use by people having a wide range of abilities. dBMerge has a very light learning curve and is well supported by Proximity. The following screen shows the core of the operation for merging source data into a new database. 
In the above application, DBF1 is the shapefile dbf (dbase file) for Honolulu County, HI by census tract. The list box shows all fields in that file. DBF2 is a statistical dbf containing Census 2000 data by census tract. The list box shows all fields in that file. In this example, the user clicks 'move all fields' for both DBF1 and DBF2. See the resulting list of fields under DBF3, the output database. The fields could have been selectively moved, one at a time, by clicking on the desired field. The user instructs the software as to which fields to use in the file/field integration. These match keys are specified by using field names in the edit boxes below the Index Fields labels. Have you been frustrated to find that in some programs when you try to match fields that you have to restructure the file to get the match keys properly structured? Not here. You can use multiple fields linked together to form the search/match key. When the user clicks Merge, each record is processed for DBF1 and a search is performed for the matching record in DBF2. When the matching record is located, the fields in the output file are populated using the fields specified from the input files. dBMerge makes it easy to: • Merge any type of data on common key fields. • Populate geographic shapefiles with your subject matter. • Combine your data with data from other sources. With dBMerge, you can ... • Integrate data from multisourced files. • Create databases that contain the right data. • Save time by using a ready-to-go program. • Minimize errors from developing ad hoc solutions. [goto top] |
|
|