Sync asset types with feature classes and related tables

Before you map and sync asset types in Civic Platform with feature classes and their related tables in Esri’s geodatabase, ensure that you have added the related tables into your map document (.mxd). This allows the Related Table drop-down list in the Asset Type edit form to retrieve the table names for your selection. Later you must publish the map service with the map document and integrate the map service into Accela GIS for Civic Platform use.

To add feature-class-related tables into a map document

1. Open your map document (.mxd) in Esri ArcMap.

2. Drag and drop the tables that relate to feature classes into the map document.

   Note: The Layers panel in Esri ArcMap lists the related tables, which do not display in the Layers panel in Accela GIS.

3. Save your map document and publish it as a map service.

A feature class in the geodatabase is represented visually on the map as a layer and contains a collection of common features with the same spatial representation, such as points, lines, or polygons. A stand-alone table in the geodatabase provides descriptive information about features or contains a collection of features without spatial representation. Your agency can associate objects in one feature class with objects in another, or associate objects in one feature class with records in a table. However, you can only sync the relationships between the objects in a feature class and records in the related tables in the geodatabase to the parent and child hierarchy of assets in Civic Platform. The relationships between objects of different feature classes cannot be synced to Civic Platform.

The asset type that a feature class is mapped to is the parent asset type while the asset type that a stand-alone table is mapped to is the child asset type. When you perform a synchronization for the parent asset type, Civic Platform does the following for both the parent asset type and the child asset type.

• Syncs the relationship between assets and GIS objects with GIS

• Syncs asset attribute fields with GIS attribute fields, if the GIS attribute mapping is established

• Syncs the parent and child hierarchy of assets based on the relationship in which the related table participates

When you perform a synchronization for the child asset type, Civic Platform syncs the relationship between assets of this type and GIS objects with Accela GIS, and syncs asset attributes with GIS attributes, as needed. Civic Platform does not synchronize the parent asset type or the sibling asset type with Accela GIS.