Name: Overhead Transmission Line

Display Field: WORKORDERID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: For maping purposes of the Primary Overhead Conductors only 1 line is shown in ArcMap. This line represents the neutral only. The phase conductors are saved in Conductor_Info related table and a 1:M relationship is formed between this features object ID and the OHPrimaryLineObjectID field in that table.Rules for reading OH phase designation labels:1. Always read labels Left to Right.2. Flat construction labels are perpendicular to the line.3. Line post construction labels are parallel to the line.4. Line post construction is labelled top to bottom (i.e., the top phase is the first label letter). SubtypeCode: 1- Overhead LineUsed Fields:OperatingVoltage:CompatibleUnitID:PhaseDesignation:PhaseConfiguration: IsFeederTrunk: (336,477,795 AC)=YesUnused Fields:NeutralUseCode, OverheadClearance

Copyright Text: City of Medicine Hat - UDS - Electric Picture is a screen shot from ArcMap 2019/07/10

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 101000.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: 17496.0
YMin: 5539117.0
XMax: 28969.0
YMax: 5550667.0
Spatial Reference: 3779  (3779)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 2
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• LENGTHSOURCE ( type: esriFieldTypeString, alias: MeasuredLengthSource, length: 5 , Coded Values: [FM: Field Measurement] , [MS: Mapping System] )
• MEASUREDLENGTH ( type: esriFieldTypeDouble, alias: MeasuredLength )
• LENGTHUOMCODE ( type: esriFieldTypeString, alias: LengthUnitofMeasure, length: 5 , Coded Values: [FT: Feet] , [EA: Each] , [M: Meter] , ...2 more... )
• WIRECOUNT ( type: esriFieldTypeInteger, alias: WireCount )
• 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: [426: Cable/Wire #2 AC] , [387: Cable/Wire #4 AC] , [427: Cable/Wire #6 CU] , ...19 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 , Coded Values: [10: 120V] , [20: 120/208V] , [22: 120/240V] , ...27 more... )
• ISFEEDERTRUNK ( type: esriFieldTypeString, alias: FeederTrunk?, length: 5 , Coded Values: [NA: Not Applicable] )
• NEUTRALUSECD ( type: esriFieldTypeString, alias: NeutralUseCode, length: 5 , Coded Values: [PN: Neutral in Primary Position] , [SN: Neutral in Secondary Position] , [CN: Concentric Neutral] )
• PHASECONFIGURATION ( type: esriFieldTypeString, alias: PhaseConfiguration, length: 5 , Coded Values: [NA: Not Applicable] )
• CLEARANCE ( type: esriFieldTypeInteger, alias: OverheadClearance , Coded Values: [1: 4] , [2: 4.1] , [3: 4.2] , ...78 more... )
• FEATURE_STATUS ( type: esriFieldTypeString, alias: FEATURE_STATUS, length: 10 , Coded Values: [Existing: Existing Feature] , [New: New Feature] , [Proposed: Proposed Feature] , ...2 more... )
• TL_DESIGNATION ( type: esriFieldTypeString, alias: Transmission Line Designation, length: 50 , Coded Values: [1241: MH-10L] , [1242: MH-12L] , [1243: MH-15L] , ...11 more... )
• TREETRIMLEVEL ( type: esriFieldTypeSmallInteger, alias: Tree Trim Level , Coded Values: [0: No Cutting] , [1: Light Cut] , [2: Medium Cut] , ...4 more... )
• TREETRIMDATE ( type: esriFieldTypeDate, alias: Tree Trim Date, length: 8 )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, length: 50 )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID , Coded Values: [-1: Free Representation] , [1: Overhead Transmission Line] )
• CITYWORKSPROJECT ( type: esriFieldTypeInteger, alias: Cityworks Project? , Coded Values: [0: No] , [1: Yes] )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.LEN ( type: esriFieldTypeDouble, alias: SHAPE.LEN )

Types:

ID: 1
Name: Overhead Line
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• LENGTHSOURCE:
  Inherited
• LENGTHUOMCODE:
  Inherited
• COMPATIBLEUNITID:
  Inherited
• 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...
• ISFEEDERTRUNK:
  Inherited
• NEUTRALUSECD:
  Inherited
• PHASECONFIGURATION:
  Inherited
• CLEARANCE:
  Inherited
• FEATURE_STATUS:
  Inherited
• TL_DESIGNATION:
  Inherited
• TREETRIMLEVEL:
  Inherited

---

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata