Name: Electric Transformers

Display Field: FeederID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Feature class containing record of City owned transformers.

Copyright Text: Modified from the ArcFM Electrical Distribution Data Model. Original data field collected by Davey Resource Group in 2014. Updated with assistance from Geotech Inc.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1.2752836905700684E7
YMin: 506924.4168701172
XMax: 1.2801342339477539E7
YMax: 559486.388671875
Spatial Reference: PROJCS["NAD_1983_StatePlane_Michigan_South_FIPS_2113_IntlFeet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",13123359.58005249],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.36666666666666],PARAMETER["Standard_Parallel_1",42.1],PARAMETER["Standard_Parallel_2",43.66666666666666],PARAMETER["Latitude_Of_Origin",41.5],UNIT["Foot",0.3048]]

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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] )
• SubtypeCD ( type: esriFieldTypeInteger, alias: Subtype )
• FeederID ( type: esriFieldTypeString, alias: Feeder ID, length: 20 )
• OperatingVoltage ( type: esriFieldTypeInteger, alias: Operating Voltage , Coded Values: [160: 7.2 kV Grounded Wye] , [210: 12.5 kV Grounded Wye] , [80: 2400 V Delta] , ...4 more... )
• ConstructionStatus ( type: esriFieldTypeInteger, alias: Construction Status , Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...6 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• LocationType ( type: esriFieldTypeString, alias: Location Type, length: 5 , Coded Values: [DLV: Delivery Point] , [GEN: Generator] , [PRI: Primary Meter] , ...2 more... )
• LabelText ( type: esriFieldTypeString, alias: Label Text, length: 100 )
• PhaseDesignation ( type: esriFieldTypeInteger, alias: Phase Designation )
• RatedKVA ( type: esriFieldTypeDouble, alias: Rated kVA )
• HighSideConfiguration ( type: esriFieldTypeString, alias: High Side Configuration, length: 5 )
• LowSideConfiguration ( type: esriFieldTypeString, alias: Low Side Configuration, length: 5 )
• LowSideVoltage ( type: esriFieldTypeInteger, alias: Low Side Voltage )
• SwitchType ( type: esriFieldTypeString, alias: Switch Type, length: 20 )
• SecondaryID ( type: esriFieldTypeString, alias: Secondary ID, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Transformer ID, length: 38 )
• SymbolRotation ( type: esriFieldTypeDouble, alias: Symbol Rotation )
• KVAfromMylar ( type: esriFieldTypeString, alias: KVAfromMylar, length: 5 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 10 )
• Asset_Num ( type: esriFieldTypeInteger, alias: Asset_Num )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Location_Code ( type: esriFieldTypeString, alias: Location_Code, length: 12 )
• Activity_Code ( type: esriFieldTypeString, alias: Activity_Code, length: 12 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 10 , Coded Values: [GOOD: Good] , [FAIR: Fair] , [POOR: Poor] , ...3 more... )

Types:

ID: 2
Name: Single Phase Overhead
Domains:
• AncillaryRole:
  Coded Values: [0: None] , [1: Source] , [2: Sink]
• Enabled:
  Inherited
• FeederID:
  Coded Values: [Ann: Ann] , [Belknap: Belknap] , [East Leonard: East Leonard] , ...10 more...
• OperatingVoltage:
  Inherited
• ConstructionStatus:
  Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...5 more...
• LocationType:
  Inherited
• PhaseDesignation:
  Coded Values: [4: X] , [6: XY] , [5: XZ] , ...4 more...
• HighSideConfiguration:
  Coded Values: [LG: Single Phase Line - Ground] , [LL: Single Phase Line - Line]
• LowSideConfiguration:
  Coded Values: [SP: SinglePhase]
• LowSideVoltage:
  Coded Values: [10: 120 V] , [20: 120/208 V] , [30: 120/240 V] , ...3 more...

---

ID: 8
Name: Step
Domains:
• AncillaryRole:
  Coded Values: [0: None] , [1: Source] , [2: Sink]
• Enabled:
  Inherited
• OperatingVoltage:
  Inherited
• ConstructionStatus:
  Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...5 more...
• LocationType:
  Inherited
• PhaseDesignation:
  Coded Values: [4: X] , [6: XY] , [5: XZ] , ...4 more...
• HighSideConfiguration:
  Coded Values: [D: Delta] , [OD: Open Delta] , [OY: Open Wye] , ...3 more...
• LowSideConfiguration:
  Coded Values: [SP: SinglePhase]
• LowSideVoltage:
  Coded Values: [10: 120 V] , [20: 120/208 V] , [30: 120/240 V] , ...3 more...

---

ID: 6
Name: Three Phase Overhead
Domains:
• AncillaryRole:
  Coded Values: [0: None] , [1: Source] , [2: Sink]
• Enabled:
  Inherited
• FeederID:
  Coded Values: [Ann: Ann] , [Belknap: Belknap] , [East Leonard: East Leonard] , ...10 more...
• OperatingVoltage:
  Inherited
• ConstructionStatus:
  Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...5 more...
• LocationType:
  Inherited
• PhaseDesignation:
  Coded Values: [7: XYZ]
• HighSideConfiguration:
  Coded Values: [D: Delta] , [Y: Wye]
• LowSideConfiguration:
  Coded Values: [3D: 3 Wire Delta] , [4D: 4 Wire Delta] , [Y: Wye]
• LowSideVoltage:
  Coded Values: [20: 120/208 V] , [50: 277/480 V] , [60: 480 V]

---

ID: 9
Name: Power Transformer
Domains:
• AncillaryRole:
  Coded Values: [0: None] , [1: Source] , [2: Sink]
• Enabled:
  Inherited
• FeederID:
  Coded Values: [Ann: Ann] , [Belknap: Belknap] , [East Leonard: East Leonard] , ...10 more...
• OperatingVoltage:
  Inherited
• ConstructionStatus:
  Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...5 more...
• LocationType:
  Inherited
• PhaseDesignation:
  Coded Values: [7: XYZ]
• RatedKVA:
  Coded Values: [167: 167 kVA] , [2000: 2000 kVA]
• HighSideConfiguration:
  Coded Values: [D: Delta] , [OD: Open Delta] , [OY: Open Wye] , ...1 more...
• LowSideConfiguration:
  Coded Values: [D: Delta] , [Y: Wye]
• LowSideVoltage:
  Coded Values: [2400: 2400 V] , [4160: 2400/4160 V]

---

ID: 10
Name: Single Phase Pad
Domains:
• AncillaryRole:
  Coded Values: [0: None] , [1: Source] , [2: Sink]
• Enabled:
  Inherited
• FeederID:
  Coded Values: [Ann: Ann] , [Belknap: Belknap] , [East Leonard: East Leonard] , ...10 more...
• OperatingVoltage:
  Inherited
• ConstructionStatus:
  Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...5 more...
• LocationType:
  Inherited
• PhaseDesignation:
  Coded Values: [4: X] , [6: XY] , [5: XZ] , ...4 more...
• HighSideConfiguration:
  Coded Values: [LG: Single Phase Line - Ground] , [LL: Single Phase Line - Line]
• LowSideConfiguration:
  Coded Values: [SP: SinglePhase]
• LowSideVoltage:
  Coded Values: [10: 120 V] , [20: 120/208 V] , [30: 120/240 V] , ...3 more...

---

ID: 11
Name: Three Phase Pad
Domains:
• AncillaryRole:
  Coded Values: [0: None] , [1: Source] , [2: Sink]
• Enabled:
  Inherited
• FeederID:
  Coded Values: [Ann: Ann] , [Belknap: Belknap] , [East Leonard: East Leonard] , ...10 more...
• OperatingVoltage:
  Inherited
• ConstructionStatus:
  Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...5 more...
• LocationType:
  Inherited
• PhaseDesignation:
  Coded Values: [7: XYZ]
• HighSideConfiguration:
  Coded Values: [D: Delta] , [Y: Wye]
• LowSideConfiguration:
  Coded Values: [3D: 3 Wire Delta] , [4D: 4 Wire Delta] , [Y: Wye]
• LowSideVoltage:
  Coded Values: [20: 120/208 V] , [50: 277/480 V] , [60: 480 V]

---

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata