Editing field mappings

Field mappings indicate which fields in the geodatabase correspond to selected fields in the Operations and Regulations database so the two can be synchronized. You must create a field mapping catalog before you can add any field mappings.

Note: Field mappings for address records are handled differently, because addresses require mappings for multiple fields. To map the required address fields, click the Address Field Mappings button on the Field Updates tab of the Preferences box. You can use the standard Edit Field Mappings button to map extended fields for addresses.
  1. Click Preferences on the GeoAdministrator tab.
  2. On the Field Updates tab, click Edit Field Mappings.
  3. In the Field Mapping dialog box, click Add.
  4. Specify this information:
    Comp Type
    Select the type of record for which you're setting up a mapping.
    O&R Field
    Select the field in the Operations and Regulations table that you want to map.
    Note: You do not need to select a table. GeoAdministrator automatically shows the table for the type of record that you select in the Comp Type list. You can select any field in the table, but be aware that mapping to a foreign key field can lead to corrupted data. If you select a foreign key field, GeoAdministrator shows a warning message and requires you to confirm the mapping.
    GIS Field
    Select the GIS layer and field that correspond to the selected O&R field.

    The field that you select must have the same data type as the O&R field.

    Subtype/Domain Link
    If the GIS field has subtypes or a domain, select either Code or Description.

    Each subtype and each domain in the geodatabase has both a numeric code and an alphanumeric description. Depending on the Operations and Regulations field you're mapping to, you might have to use either the code or the description so that the data types match. You can thus maintain consistency between the two databases while enforcing subtype and domain rules.

    If you're mapping a subtype or domain to an Operations and Regulations code definition, you can select either the code or the description for the code definition.

    Owner
    Select GIS or O&R.

    The owner is the database that this field will be copied from when you synchronize data. This is typically the database that gets updated first, so its data is considered more up-to-date and correct.

    If you select GIS, the value in the geodatabase will be copied to the Operations and Regulations database. Conversely, if you select O&R, GeoAdministrator will copy the value from the Operations and Regulations database to the geodatabase.

  5. Click OK.