Name: Transformer

Display Field: DEVICENUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 2500.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 12564.2165000001
YMin: 5532615.0715
XMax: 31424.5865000002
YMax: 5552732.7995
Spatial Reference: 3779  (3779)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1
  Label: Polemount - 1 Phase
  Description:
  Symbol:
  
• Value: 2
  Label: Padmount - 1 Phase
  Description:
  Symbol:
  
• Value: 3
  Label: Submersible - Network
  Description:
  Symbol:
  
• Value: 5
  Label: Submersible - 1 Phase
  Description:
  Symbol:
  
• Value: 6
  Label: Padmount - Network
  Description:
  Symbol:
  
• Value: 7
  Label: Padmount - 3 Phase
  Description:
  Symbol:
  
• Value: 9
  Label: Polemount - 3 Phase
  Description:
  Symbol:
  
• Value: 10
  Label: Polemount - 2 Phase
  Description:
  Symbol:
  
• Value: 11
  Label: Padmount - 2 Phase
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SubtypeCD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: AncillaryRole )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• WORKORDERID ( type: esriFieldTypeString, alias: WorkOrderID, length: 20 )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• FIELDVERIFY ( type: esriFieldTypeString, alias: FieldVerify?, length: 5 , Coded Values: [0: No] , [1: Yes] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 100 )
• CREATIONUSER ( type: esriFieldTypeString, alias: CreationUser, length: 20 )
• DATECREATED ( type: esriFieldTypeDate, alias: DateCreated, length: 8 )
• LASTUSER ( type: esriFieldTypeString, alias: LastEditUser, length: 20 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: LastEditDate, length: 8 )
• WORKREQUESTID ( type: esriFieldTypeString, alias: Designer:WorkRequestID, length: 20 )
• DESIGNID ( type: esriFieldTypeString, alias: Designer:DesignID, length: 20 )
• WORKLOCATIONID ( type: esriFieldTypeString, alias: Designer:WorkLocationID, length: 20 )
• WMSID ( type: esriFieldTypeString, alias: Designer:WorkOrderManagementSystemID, length: 50 )
• WORKFLOWSTATUS ( type: esriFieldTypeInteger, alias: Designer:WorkFlowStatus , Coded Values: [0: None] , [1: In Design] , [2: Pending Approval] , ...4 more... )
• WORKFUNCTION ( type: esriFieldTypeInteger, alias: Designer:WorkFunction , Coded Values: [0: None] , [1: Install] , [2: Remove] , ...6 more... )
• FEEDERID ( type: esriFieldTypeString, alias: FeederID, length: 25 )
• FEEDERID2 ( type: esriFieldTypeString, alias: SecondaryFeederID, length: 25 )
• FEEDERINFO ( type: esriFieldTypeInteger, alias: FeederManagerInfo )
• ELECTRICTRACEWEIGHT ( type: esriFieldTypeInteger, alias: MMElectricTraceWeight )
• LOCATIONID ( type: esriFieldTypeString, alias: LocationID, length: 50 )
• SYMBOLROTATION ( type: esriFieldTypeSingle, alias: SymbolRotation )
• GPSDATE ( type: esriFieldTypeDate, alias: GPSDate, length: 8 )
• GISONUMBER ( type: esriFieldTypeInteger, alias: GISONumber )
• GISOTYPENBR ( type: esriFieldTypeInteger, alias: GISOTypeNumber )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SubtypeCode )
• LABELTEXT ( type: esriFieldTypeString, alias: LabelText, length: 255 )
• COMPATIBLEUNITID ( type: esriFieldTypeString, alias: CompatibleUnitID, length: 5 , Coded Values: [98: TRANSFORMER-PADMNT 75kVA 13.8kV 208/120V F 3PH] , [99: TRANSFORMER-PADMNT 75kVA 13.8kV 208/120V NF 3PH] , [103: TRANSFORMER-PADMNT 150kVA 13.8kV 208/120V NF 3PH] , ...74 more... )
• OWNERSHIP ( type: esriFieldTypeString, alias: FeatureOwnedBy, length: 20 )
• PHASEDESIGNATION ( type: esriFieldTypeInteger, alias: PhaseDesignation , Coded Values: [4: R] , [2: Y] , [1: B] , ...5 more... )
• OPERATINGVOLTAGE ( type: esriFieldTypeInteger, alias: OperatingVoltage , Coded Values: [10: 120V] , [20: 120/208V] , [22: 120/240V] , ...27 more... )
• NOMINALVOLTAGE ( type: esriFieldTypeInteger, alias: NominalVoltage )
• GROUNDREACTANCE ( type: esriFieldTypeInteger, alias: GroundReactance )
• GROUNDRESISTANCE ( type: esriFieldTypeInteger, alias: GroundResistance )
• MAGNETIZINGREACTANCE ( type: esriFieldTypeDouble, alias: MagnetizingReactance )
• MAGNETIZINGRESISTANCE ( type: esriFieldTypeDouble, alias: MagnetizingResistance )
• HIGHSIDEGROUNDREACTANCE ( type: esriFieldTypeInteger, alias: HighSideGroundReactance )
• HIGHSIDEGROUNDRESISTANCE ( type: esriFieldTypeInteger, alias: HighSideGroundResistance )
• HIGHSIDEPROTECTION ( type: esriFieldTypeString, alias: HighSideProtection, length: 5 , Coded Values: [BR: Breaker] , [BY: Bayonet Fuse] , [DW: Dry Well Canister] , ...3 more... )
• LOCATIONTYPE ( type: esriFieldTypeString, alias: LocationType, length: 5 , Coded Values: [DLV: Delivery Point] , [GEN: Generator] , [PRI: Primary Meter] , ...2 more... )
• DEVICENUMBER ( type: esriFieldTypeString, alias: DeviceNumber, length: 25 )
• FAULTINDICATOR ( type: esriFieldTypeString, alias: HasFaultIndicator?, length: 5 , Coded Values: [0: No] , [1: Yes] )
• COOLINGTYPE ( type: esriFieldTypeString, alias: CoolingType, length: 5 , Coded Values: [NA: Not Applicable] )
• FEATURE_STATUS ( type: esriFieldTypeString, alias: FEATURE_STATUS, length: 10 , Coded Values: [Existing: Existing Feature] , [New: New Feature] , [Proposed: Proposed Feature] , ...2 more... )
• KVA ( type: esriFieldTypeString, alias: KVA, length: 15 )
• UNITS ( type: esriFieldTypeSmallInteger, alias: UNITS , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• DEMAND_KVA ( type: esriFieldTypeString, alias: DEMAND_KVA, length: 10 )
• DEMAND_DATE_MM_DD_YYYY ( type: esriFieldTypeDate, alias: DEMAND_DATE_MM_DD_YYYY, length: 8 )
• STREET_LIGHT_FACILITY ( type: esriFieldTypeString, alias: STREETLIGHT_FACILITY, length: 50 , Coded Values: [STLT-REN: Streetlights-rental lights] , [LT-OTHER: Lights - Other] , [STLT-MED: Streetlights-in Medicine Hat (529760)] , ...8 more... )
• HIGHSIDECONFIGURATION ( type: esriFieldTypeString, alias: HIGHSIDECONFIGURATION, length: 5 )
• LOWSIDECONFIGURATION ( type: esriFieldTypeString, alias: LOWSIDECONFIGURATION, length: 5 )
• LOWSIDEGROUNDRESISTANCE ( type: esriFieldTypeDouble, alias: LOWSIDEGROUNDRESISTANCE )
• LOWSIDEVOLTAGE ( type: esriFieldTypeInteger, alias: LOWSIDEVOLTAGE )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• RATEDKVA ( type: esriFieldTypeDouble, alias: RATEDKVA )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID , Coded Values: [1: Overhead 1 Phase Transformer] , [2: Padmount 1 Phase Transformer] , [3: Network Submersible Transformer] , ...7 more... )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, length: 50 )
• CONNECTEDLOAD ( type: esriFieldTypeInteger, alias: ConnectedLoad )
• SERIALNUMBER ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• INSULATOR_MATERIAL ( type: esriFieldTypeInteger, alias: Insulator Material , Coded Values: [1281: Porcelain] , [1282: Polymer] , [0: Unknown] )
• CUOUTINSULATORMANUFACTURER ( type: esriFieldTypeString, alias: Cutout Insulator Manuracturer, length: 50 , Coded Values: [0: Unknown] , [ABB: ABB] , [C: Chance] , ...7 more... )
• CITYWORKSPROJECT ( type: esriFieldTypeInteger, alias: Cityworks Project? , Coded Values: [0: No] , [1: Yes] )
• PEAKSUMMERCONSUMPTION ( type: esriFieldTypeDouble, alias: Peak Summer Consumption )
• LASTINSPECTION ( type: esriFieldTypeDate, alias: Last Inspection Date, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• NEUTRALBONDINGPOINT ( type: esriFieldTypeInteger, alias: NeutralBondingPoint , Coded Values: [0: No] , [1: Yes] )

Types:

ID: 4
Name: Power Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Inherited
• PHASEDESIGNATION:
  Inherited
• OPERATINGVOLTAGE:
  Inherited
• NOMINALVOLTAGE:
  Coded Values: [35: 69 kV] , [34: 15 kV]
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• COOLINGTYPE:
  Coded Values: [FO: Forced Oil] , [RFA: Radiator Forced Air] , [OTH: Other]
• RULEID:
  Inherited

---

ID: 7
Name: Padmount 3 Phase Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [1428: TRANSFORMER-PADMNT 1000kVA 13.8kV 480/277V F 3PH] , [573: TRANSFORMER-PADMNT 1000kVA 13.8kV 480/277V NF 3PH] , [1289: TRANSFORMER-PADMNT 1000kVA 13.8kV 600/347V F 3PH] , ...39 more...
• PHASEDESIGNATION:
  Coded Values: [7: RYB]
• OPERATINGVOLTAGE:
  Inherited
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• COOLINGTYPE:
  Inherited
• RULEID:
  Inherited

---

ID: 1
Name: Overhead 1 Phase Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [1284: TRANSFORMER-POLEMNT 1kVA 8.0kV 120/240V Tavrida 1PH] , [294: TRANSFORMER-POLEMT 10kVA 13.8kV 120/240V 1PH] , [122: TRANSFORMER-POLEMT 10kVA 8.0kV 120/240V 1PH] , ...35 more...
• PHASEDESIGNATION:
  Coded Values: [4: R] , [2: Y] , [1: B]
• OPERATINGVOLTAGE:
  Inherited
• NOMINALVOLTAGE:
  Coded Values: [120: 4.2 kV Grounded Y] , [160: 7.2 kV Grounded Y] , [210: 12.5 kV Grounded Y] , ...1 more...
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Inherited
• COOLINGTYPE:
  Inherited
• RULEID:
  Inherited

---

ID: 9
Name: Overhead 3 Phase Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [1284: TRANSFORMER-POLEMNT 1kVA 8.0kV 120/240V Tavrida 1PH] , [294: TRANSFORMER-POLEMT 10kVA 13.8kV 120/240V 1PH] , [122: TRANSFORMER-POLEMT 10kVA 8.0kV 120/240V 1PH] , ...35 more...
• PHASEDESIGNATION:
  Coded Values: [7: RYB]
• OPERATINGVOLTAGE:
  Inherited
• NOMINALVOLTAGE:
  Coded Values: [120: 4.2 kV Grounded Y] , [160: 7.2 kV Grounded Y] , [210: 12.5 kV Grounded Y] , ...1 more...
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Inherited
• COOLINGTYPE:
  Inherited
• RULEID:
  Inherited

---

ID: 2
Name: Padmount 1 Phase Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [116: TRANSFORMER-MINPAD 100kVA 8.0kV 120/240V F 1PH] , [114: TRANSFORMER-MINPAD 50kVA 8.0kV 120/240V F 1PH] , [115: TRANSFORMER-MINPAD 75kVA 8.0kV 120/240V F 1PH] , ...2 more...
• PHASEDESIGNATION:
  Coded Values: [4: R] , [2: Y] , [1: B]
• OPERATINGVOLTAGE:
  Inherited
• NOMINALVOLTAGE:
  Coded Values: [120: 4.2 kV Grounded Y] , [160: 7.2 kV Grounded Y] , [210: 12.5 kV Grounded Y] , ...1 more...
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• COOLINGTYPE:
  Inherited
• RULEID:
  Inherited

---

ID: 3
Name: Network Submersible Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [117: TRANSFORMER-NETWRK 500kVA 13.8kV 208/120V NF 3PH] , [118: TRANSFORMER-NETWRK 750kVA 13.8kV 600/347V NF 3PH] , [1401: TRANSFORMER-NETWRK 840kVA 13.8kV 600/347V NF 3PH]
• PHASEDESIGNATION:
  Inherited
• OPERATINGVOLTAGE:
  Inherited
• NOMINALVOLTAGE:
  Coded Values: [120: 4.2 kV Grounded Y] , [160: 7.2 kV Grounded Y] , [210: 12.5 kV Grounded Y] , ...1 more...
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• COOLINGTYPE:
  Inherited
• RULEID:
  Inherited

---

ID: 5
Name: Submersible Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [288: TRANSFORMER-SUBMRS 50kVA 8.0kV 120/240V NF 1PH] , [289: TRANSFORMER-SUBMRS 75kVA 8.0kV 120/240V NF 1PH] , [1427: TRANSFORMER-SUBMRS 50kVA 8.0kV 120/240V F 1PH]
• PHASEDESIGNATION:
  Inherited
• OPERATINGVOLTAGE:
  Inherited
• NOMINALVOLTAGE:
  Coded Values: [120: 4.2 kV Grounded Y] , [160: 7.2 kV Grounded Y] , [210: 12.5 kV Grounded Y] , ...1 more...
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• COOLINGTYPE:
  Inherited
• RULEID:
  Inherited

---

ID: 6
Name: Network Padmount Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Inherited
• PHASEDESIGNATION:
  Inherited
• OPERATINGVOLTAGE:
  Inherited
• NOMINALVOLTAGE:
  Coded Values: [120: 4.2 kV Grounded Y] , [160: 7.2 kV Grounded Y] , [210: 12.5 kV Grounded Y] , ...1 more...
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• COOLINGTYPE:
  Inherited
• RULEID:
  Inherited

---

ID: 10
Name: Overhead 2 Phase Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [1284: TRANSFORMER-POLEMNT 1kVA 8.0kV 120/240V Tavrida 1PH] , [294: TRANSFORMER-POLEMT 10kVA 13.8kV 120/240V 1PH] , [122: TRANSFORMER-POLEMT 10kVA 8.0kV 120/240V 1PH] , ...35 more...
• PHASEDESIGNATION:
  Coded Values: [6: RY] , [5: RB] , [3: YB]
• OPERATINGVOLTAGE:
  Inherited
• NOMINALVOLTAGE:
  Coded Values: [120: 4.2 kV Grounded Y] , [160: 7.2 kV Grounded Y] , [210: 12.5 kV Grounded Y] , ...1 more...
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Inherited
• COOLINGTYPE:
  Inherited
• RULEID:
  Inherited

---

ID: 11
Name: Padmount 2 Phase Transformer
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [116: TRANSFORMER-MINPAD 100kVA 8.0kV 120/240V F 1PH] , [114: TRANSFORMER-MINPAD 50kVA 8.0kV 120/240V F 1PH] , [115: TRANSFORMER-MINPAD 75kVA 8.0kV 120/240V F 1PH] , ...2 more...
• PHASEDESIGNATION:
  Inherited
• OPERATINGVOLTAGE:
  Inherited
• HIGHSIDEPROTECTION:
  Inherited
• LOCATIONTYPE:
  Inherited
• FAULTINDICATOR:
  Inherited
• COOLINGTYPE:
  Inherited
• FEATURE_STATUS:
  Inherited
• UNITS:
  Inherited
• STREET_LIGHT_FACILITY:
  Inherited
• RULEID:
  Inherited

---

Relationships:

• Dynamic Protective Device (1) -- Related To: Dynamic Protective Device (3)
• Secondary Meter (2) -- Related To: Secondary Meter (4)
• Pole (9) -- Related To: Pole (15)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata