Detailed view: integrating existing assets/features - HxGN EAM - Version 11.07.01 - Feature Briefs

HxGN EAM GIS

Language
English
Product
HxGN EAM
Search by Category
Feature Briefs
HxGN EAM Version
11.7.1

Case 1: Existing GIS user is implementing HxGN EAM. GIS features need to be created as equipment in HxGN EAM

In the case where an existing GIS user is implementing HxGN EAM and GIS features need to be created as equipment; you should first determine which layers will be integrated with HxGN EAM. Next, add the GISOBJID column to each layer’s attribute table. The GISOBJID is used to link each map feature to an individual HxGN EAM equipment record. This is a one-to-one association. The column exists in both the GIS database for each feature as well as the HxGN EAM DB (r5objects/obj_gisobjid). The unique GISOBJID for each record will be the same in both systems. The map layer attribute tables also contain specific data about each feature. In most cases, there is enough data here to satisfy the basic requirements for creation of equipment in HxGN EAM (such as description, status, and type). Using the HxGN EAM GIS integration toolbar, map the data from the GIS attribute table for each layer to similar fields in the object table of the HxGN EAM database. The integration toolbar will then allow you to create the new HxGN EAM equipment records in a batch, sending them via existing EAM web services. This synchronization should be done for each layer to be integrated until all GIS features have been created as HxGN EAM equipment. The toolbar allows you to export lists of records for comparison or historical purposes.

See the HxGN EAM Help for GIS and the HxGN EAM Configuration for GIS for more information.

Case 2: Existing HxGN EAM user implements GIS system. HxGN EAM equipment records such as assets, systems, and positions already exist and need to be created as features in the GIS database.

In this scenario, HxGN EAM equipment records such as assets, systems, and positions already exist and need to be linked to features in the GIS database. First, determine which layers will be integrated with HxGN EAM then add the GISOBJID column to each layer’s attribute table as described in Case 1. Configure UPDATE_COUNT as needed. Consider which if any fields from GIS need to be available in EAM and use the HxGN EAM GIS integration toolbar create the data mappings. In HxGN EAM, create equipment profiles for each type of equipment that will be synchronized between HxGN EAM and GIS. You may also consider creating equipment classes to identify specific types of equipment in GIS. A profile contains the all the data required by HxGN EAM for asset creation including a class if one is specified. Once all of this has been determined, use the HxGN EAM GIS integration toolbar to link the various HxGN EAM equipment profiles to specific layers and synchronize the records.

Case 3: Existing HxGN EAM and GIS environments. Need to integrate where equipment records such as assets, systems, and positions exist in the HxGN EAM system and GIS features already exist in a mature GIS system.

In this scenario, we have existing HxGN EAM and GIS environments that have been in use for some time. GIS features exist and have been configured with the necessary data for normal GIS operations. The HxGN EAM environment has equipment with much transactional data such as structure, work orders, and cost data. Data may also be captured in custom and user defined fields of various types depending on workflows. There is now a need to integrate the two systems. First, determine which layers will be integrated with HxGN EAM then add the GISOBJID column to each layer’s attribute table. Also, configure the UPDATE_COUNT column. Consider which if any fields need to be mapped between the two systems and use the HxGN EAM GIS integration toolbar create the data mappings. As mentioned before a unique GISOBJID is needed to link a GIS feature to an HxGN EAM equipment record. Normally this number is system generated by HxGN EAM when the feature record is created or when the asset is initially created. Since both records already exist and both have data that needs to be preserved, the GISOBJID must be manually created. For each feature that is to be integrated, manually enter a unique GISOBJID value in the feature table. All GIDOBJIDs that are manually created must be in a range of less than 100000000 because the HxGN EAM system generates GISOBJIDs beginning at 100000000. Carefully plan the numbering convention so that the range is well below this threshold to avoid duplicate GISOBJIDs. Note that both GISOBJID and layer must be added to each equipment record to complete the manual integration. If other equipment fields need to be populated with GIS data, it can be synchronized using the GIS Integration Toolbar.