A single piece of equipment has two different types of attributes: settings and specifications. There are the attributes - or settings - whose values may change given the situation. For example, a fuse's Phase Designation may change (A, B, C). A piece of equipment may also have attributes whose values do NOT change - or specifications. For example, this same fuse has electrical specifications defined by the model and manufacturer (e.g., rated voltage, continuous current rating).
Generally, specifications are stored in the Equipment database in the engineering analysis engine. Specifications might not be stored in the GIS because storing the identical specifications for every feature in the geometric network would be redundant. The feature specific attributes (or settings) are stored in the GIS and the Equipment ID is used to map the features to their corresponding types in the Equipment database.
Geodatabase features are mapped to the Equipment database using an Equipment ID. This value is a unique identifier for the type of equipment (not the specific feature). There are two methods available for configuring your equipment ID.
Network Adapter uses field model names to identify the attributes that make up the Equipment ID. Because you may wish to use multiple concatenated geodatabase fields to create an Equipment ID, Network Adapter allows you to assign multiple numbered field model names.
Example: The Equipment ID value in the Equipment database for a transformer's equipment type may consist of the SubtypeCD followed by the Rated kVA. Assign the following model names:
Model name assigned to Transformer class: CYMDISTEXPORT
Field model names assigned to SubtypeCD field: SYNERGEE_EQUIP1, CYMDISTEXPORT
Field model names assigned to RatedKVA field: SYNERGEE_EQUIP2, CYMDISTEXPORT
The resulting value for an individual transformer configured using the example above may be "7 500". This value should be included as a Transformer type in the Equipment database in the engineering analysis engine. Note: If the field has a coded domain assigned, the coded value will be concatenated in the Equipment ID (NOT the Description value).
When assigning field model names, you must always assign them in numerical order beginning with 1 and with no gaps in sequence. You may assign up to 20 field model names per feature class.
Each unique combination of Equipment ID must be defined in the Equipment database or the Protection database. Refer to SynerGEE's documentation for information about setting up your Equipment database.
If an Equipment ID value is invalid, Network Adapter warns the user during export (one warning per unique invalid ID). Network Adapter cannot validate Equipment IDs that reside in the Protection database.
This configuration also requires that model names and field model names be assigned according to the Configuration page. All fields used to create Equipment IDs must have the CYMDISTEXPORT field model name assigned.
Equipment Database Field |
Geodatabase Field Model Names (Equipment ID) |
---|---|
Equipment type fields for transformers, regulators, switches |
SYNERGEE_EQUIP1, SYNERGEE_EQUIP2, etc. |
Conductor Type fields for individual phases on a conductor* |
SYNERGEE_PHASECONDUCTOR1, SYNERGEE_PHASECONDUCTOR2, etc. |
Conductor Type fields for neutral wire in a conductor |
SYNERGEE_NEUTRALCONDUCTOR1, SYNERGEE_NEUTRALCONDUCTOR2, etc. |
Conductor configuration fields for spacing wires in a conductor* |
SYNERGEE_CONFIGURATION1, SYNERGEE_CONFIGURATION2, etc. |
*The Conductor Configuration is required if the Conductor Type contains a mixture of conductor types (e.g., material and size).
Protection Database Field |
Geodatabase Field Model Names (Equipment ID) |
---|---|
Model fields for fuses and reclosers |
SYNERGEE_MODEL1, SYNERGEE_MODEL2, etc. |
Manufacturer fields for fuses and reclosers |
SYNERGEE_MANUFACTURER1, SYNERGEE_MANUFACTURER2, etc. |
Mechanical responder ID fields for reclosers and breakers |
SYNERGEE_MECHANICALRESPONSE1, SYNERGEE_MECHANICALRESPONSE2, etc. |
Sample Conductor Configuration
Below is an example of how a conductor might be configured for export by Network Adapter.
Feature Class or Table
Field
Model Name/Field Model Name
PriOHElectricLineSegment
--
CYMDISTEXPORT
PriOHElectricLineSegment
NeutralSize
SYNERGEE_NEUTRALCONDUCTOR1, CYMDISTEXPORT
PriOHElectricLineSegment
NeutralMaterial
SYNERGEE_NEUTRALCONDUCTOR2, CYMDISTEXPORT
PriOHElectricLineSegment
ConductorConfiguration
SYNERGEE_CONFIGURATION1, CYMDISTEXPORT
ConductorInfo
--
CYMDISTEXPORT
ConductorInfo
ConductorSize
SYNERGEE_PHASECONDUCTOR1, CYMDISTEXPORT
ConductorInfo
ConductorMaterial
SYNERGEE_PHASECONDUCTOR2, CYMDISTEXPORT
This method allows you to create an Equipment ID by populating a single geodatabase field for each conductor feature's phase. This option does NOT allow you to concatenate multiple fields to create an Equipment ID.
Network Adapter looks for Equipment ID in the following three fields: EquipType_A, EquipType_B, EquipType_C. These fields must exist on either the Conductor feature or the ConductorInfo object class. They MUST be spelled and capitalized exactly as shown.
These three fields should be populated in the geodatabase with the Equipment ID specific to each feature and phase. Below is an example of how an Equipment ID may be configured.
Feature Class or Table |
Field |
Model Name/Field Model Name |
---|---|---|
PriOHElectricLineSegment or ConductorInfo |
-- |
CYMDISTEXPORT |
PriOHElectricLineSegment or ConductorInfo |
EquipType_A |
CYMDISTEXPORT |
PriOHElectricLineSegment or ConductorInfo |
EquipType_B |
CYMDISTEXPORT |
PriOHElectricLineSegment or ConductorInfo |
EquipType_C |
CYMDISTEXPORT |
Use an XSL style sheet to manipulate XML to determine the information to be concatenated into a single Equipment ID. A sample is provided below. In the highlighted portion below, the XML selects the LinkRtg and FuseType values for the feature and appends them to "_OH_FUS" (e.g., 200H_OH_FUS). You may modify the XML to change the attributes displayed in the EquipmentID field to fit your business needs.
Example Title |
Copy Code
|
---|---|
<xsl:template match="FEATURE" mode="FuseEquipment"> <xsl:variable name="EquipmentID" select="FIELDS/FIELD[translate(FIELDNAME,&uc;,&lc;) = 'equipmentid']/FIELDVALUE"/> <xsl:variable name="LinkRtg" select="FIELDS/FIELD[translate(FIELDNAME,&uc;,&lc;) = 'linkrating']/FIELDVALUE"/> <xsl:variable name="FuseType" select="FIELDS/FIELD[translate(FIELDNAME,&uc;,&lc;) = 'linktype']/FIELDVALUE"/> <xsl:variable name="eaEquipment"> <xsl:choose> <xsl:when test="$EquipmentID != ''"> <xsl:value-of select="$EquipmentID"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="$LinkRtg"/> <xsl:value-of select="$FuseType"/> <xsl:text>_FUS</xsl:text> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:element name="eaEquipment"> <xsl:value-of select="$eaEquipment"/> </xsl:element> </xsl:template> |