Creating a cross-reference database

Disponible avec une licence Production Mapping.

The Create Cross-Reference tool is used to automatically create a cross-reference database based on the source and target database schemas you specify. The source workspace is the basis for the cross-reference database and the primary point of comparison, while the target workspace is the destination for the data.

The source for the cross-reference database can be a geodatabase or shapefile. The target for the cross-reference database must be a geodatabase.

Once you choose the source and target, the cross-reference database is created, and the tables are populated based on the tables and fields that exist in the two schemas, as well as those they have in common.

For instance, if you have the VMap 1 and VMap 2 data models, the source tables in the cross-reference database would contain all the feature classes and fields contained in VMap 1. The target tables would contain all the feature classes and fields in VMap 2, and the mapping tables would contain all the feature classes and tables that are common between the two, as well as a list of all the common fields. Therefore, the cross-reference database does contain information about all the tables included in the source and target schemas, but only the common information is mapped within the mapping tables.

Mapping information for the source to the target can also be provided in a separate file as a Microsoft Excel spreadsheet. This file can be created for instances in which the Create Cross-Reference tool will not be able to automatically match feature classes and field names. For example, if source Road_L should be loaded into target RoadL but the target doesn't contain Road_L, you can create a file that contains the name of the target feature class where RoadL should be loaded.

Learn more about the cross-reference database

1. Start ArcCatalog.
2. On the main menu, click Customize > Toolbars > Production Mapping.
3. Click the Create Cross-Reference button on the Production Mapping toolbar.

   The Create Cross-Reference dialog box appears.

   

4. Click the options button next to the Source Workspace text box.

   The Select source workspace dialog box appears.

5. Browse to the workspace that contains the source schema.
6. Click Select.

   The Create Cross-Reference dialog box appears.

7. Click the options button next to the Target Geodatabase text box.

   The Select target geodatabase dialog box appears.

8. Browse to the geodatabase that contains the target schema.
9. Click Select.

   The Create Cross-Reference dialog box appears.

10. Click the options button next to the Cross-reference Database text box.

    The Select cross-reference database path dialog box appears.

11. Browse to the location where the cross-reference database will be saved.
12. Type a name for the cross-reference database in the Name text box.
13. Click Save.

    The Create Cross-Reference dialog box appears.

14. If you have an Excel mapping file for the source and target workspaces, check the Import mapping from file check box.
15. Click the options button next to the Import mapping from file text box.

    The Select Excel file dialog box appears.

16. Browse to the Excel file that contains the mapping information for your source and target workspaces.
17. Click Open.

    The Create Cross-Reference dialog box appears.

    A message appears once the cross-reference database is successfully created and populated.

18. Click OK.
19. Click Cancel on the Create Cross-Reference dialog box to close it.