View In:   ArcGIS Online Map Viewer

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: true
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• WORKORDERID ( type: esriFieldTypeString, alias: WorkOrderID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORKORDERID )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• FIELDVERIFY ( type: esriFieldTypeString, alias: FieldVerify?, editable: true, nullable: true, length: 5, defaultValue: 0, modelName: FieldVerify , Coded Values: [0: No] , [1: Yes] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• CREATIONUSER ( type: esriFieldTypeString, alias: CreationUser, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• LASTUSER ( type: esriFieldTypeString, alias: LastEditUser, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LastUser )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: LastEditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• WORKREQUESTID ( type: esriFieldTypeString, alias: Designer:WorkRequestID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkRequestID )
• DESIGNID ( type: esriFieldTypeString, alias: Designer:DesignID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DesignID )
• WORKLOCATIONID ( type: esriFieldTypeString, alias: Designer:WorkLocationID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkLocationID )
• WMSID ( type: esriFieldTypeString, alias: Designer:WorkOrderManagementSystemID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WmsID )
• WORKFLOWSTATUS ( type: esriFieldTypeInteger, alias: Designer:WorkFlowStatus, editable: true, nullable: true, defaultValue: 0, modelName: WorkFlowStatus , Coded Values: [0: None] , [1: In Design] , [2: Pending Approval] , ...4 more... )
• WORKFUNCTION ( type: esriFieldTypeInteger, alias: Designer:WorkFunction, editable: true, nullable: true, defaultValue: 0, modelName: WorkFunction , Coded Values: [0: None] , [1: Install] , [2: Remove] , ...6 more... )
• FEEDERID ( type: esriFieldTypeString, alias: FeederID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FeederID )
• FEEDERID2 ( type: esriFieldTypeString, alias: SecondaryFeederID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FeederID2 )
• FEEDERINFO ( type: esriFieldTypeInteger, alias: FeederManagerInfo, editable: true, nullable: true, defaultValue: null, modelName: FeederInfo )
• ELECTRICTRACEWEIGHT ( type: esriFieldTypeInteger, alias: MMElectricTraceWeight, editable: true, nullable: true, defaultValue: null, modelName: ElectricTraceWeight )
• LOCATIONID ( type: esriFieldTypeString, alias: LocationID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATIONID )
• LENGTHSOURCE ( type: esriFieldTypeString, alias: MeasuredLengthSource, editable: true, nullable: true, length: 5, defaultValue: MS, modelName: LengthSource , Coded Values: [FM: Field Measurement] , [MS: Mapping System] )
• MEASUREDLENGTH ( type: esriFieldTypeDouble, alias: MeasuredLength, editable: true, nullable: true, defaultValue: null, modelName: MEASUREDLENGTH )
• LENGTHUOMCODE ( type: esriFieldTypeString, alias: LengthUnitofMeasure, editable: true, nullable: true, length: 5, defaultValue: M, modelName: LengthUOMCode , Coded Values: [FT: Feet] , [EA: Each] , [M: Meter] , ...2 more... )
• WIRECOUNT ( type: esriFieldTypeInteger, alias: WireCount, editable: true, nullable: true, defaultValue: null, modelName: WIRECOUNT )
• GISONUMBER ( type: esriFieldTypeInteger, alias: GISONumber, editable: true, nullable: true, defaultValue: null, modelName: GISONUMBER )
• GISOTYPENBR ( type: esriFieldTypeInteger, alias: GISOTypeNumber, editable: true, nullable: true, defaultValue: null, modelName: GisoTypeNbr )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SubtypeCode, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeCD )
• LABELTEXT ( type: esriFieldTypeString, alias: LabelText, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LABELTEXT )
• COMPATIBLEUNITID ( type: esriFieldTypeString, alias: CompatibleUnitID, editable: true, nullable: true, length: 5, defaultValue: 372, modelName: COMPATIBLEUNITID , Coded Values: [426: Cable/Wire #2 AC] , [387: Cable/Wire #4 AC] , [427: Cable/Wire #6 CU] , ...19 more... )
• OWNERSHIP ( type: esriFieldTypeString, alias: FeatureOwnedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Ownership )
• PHASEDESIGNATION ( type: esriFieldTypeInteger, alias: PhaseDesignation, editable: true, nullable: true, defaultValue: null, modelName: PhaseDesignation , Coded Values: [4: R] , [2: Y] , [1: B] , ...5 more... )
• OPERATINGVOLTAGE ( type: esriFieldTypeInteger, alias: OperatingVoltage, editable: true, nullable: true, defaultValue: null, modelName: OperatingVoltage , Coded Values: [10: 120V] , [20: 120/208V] , [22: 120/240V] , ...27 more... )
• NOMINALVOLTAGE ( type: esriFieldTypeInteger, alias: NominalVoltage, editable: true, nullable: true, defaultValue: null, modelName: NominalVoltage , Coded Values: [10: 120V] , [20: 120/208V] , [22: 120/240V] , ...27 more... )
• ISFEEDERTRUNK ( type: esriFieldTypeString, alias: FeederTrunk?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: IsFeederTrunk , Coded Values: [NA: Not Applicable] )
• NEUTRALUSECD ( type: esriFieldTypeString, alias: NeutralUseCode, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NeutralUseCd , Coded Values: [PN: Neutral in Primary Position] , [SN: Neutral in Secondary Position] , [CN: Concentric Neutral] )
• PHASECONFIGURATION ( type: esriFieldTypeString, alias: PhaseConfiguration, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PHASECONFIGURATION , Coded Values: [NA: Not Applicable] )
• CLEARANCE ( type: esriFieldTypeInteger, alias: OverheadClearance, editable: true, nullable: true, defaultValue: null, modelName: Clearance , Coded Values: [1: 4] , [2: 4.1] , [3: 4.2] , ...78 more... )
• FEATURE_STATUS ( type: esriFieldTypeString, alias: FEATURE_STATUS, editable: true, nullable: false, length: 10, defaultValue: Existing, modelName: FEATURE_STATUS , Coded Values: [Existing: Existing Feature] , [New: New Feature] , [Proposed: Proposed Feature] , ...2 more... )
• TL_DESIGNATION ( type: esriFieldTypeString, alias: Transmission Line Designation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TL_DESIGNATION , Coded Values: [1241: MH-10L] , [1242: MH-12L] , [1243: MH-15L] , ...11 more... )
• TREETRIMLEVEL ( type: esriFieldTypeSmallInteger, alias: Tree Trim Level, editable: true, nullable: true, defaultValue: null, modelName: TREETRIMLEVEL , Coded Values: [0: No Cutting] , [1: Light Cut] , [2: Medium Cut] , ...4 more... )
• TREETRIMDATE ( type: esriFieldTypeDate, alias: Tree Trim Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TREETRIMDATE )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID, editable: true, nullable: true, defaultValue: null, modelName: RULEID , Coded Values: [-1: Free Representation] , [1: Overhead Transmission Line] )
• CITYWORKSPROJECT ( type: esriFieldTypeInteger, alias: Cityworks Project?, editable: true, nullable: true, defaultValue: 0, modelName: CITYWORKSPROJECT , Coded Values: [0: No] , [1: Yes] )

Templates:

• Name: Overhead Transmission Line
  Description:
  Prototype:
  CITYWORKSPROJECT: null
  WMSID: null
  WORKFLOWSTATUS: 0
  LOCATIONID: null
  MEASUREDLENGTH: null
  GISONUMBER: null
  GISOTYPENBR: 13
  LABELTEXT: null
  OWNERSHIP: null
  PHASEDESIGNATION: 4
  NOMINALVOLTAGE: null
  CLEARANCE: null
  ENABLED: 1
  WORKORDERID: null
  INSTALLATIONDATE: null
  FIELDVERIFY: null
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WORKFUNCTION: 0
  FEEDERID: null
  FEEDERID2: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  LENGTHSOURCE: MS
  LENGTHUOMCODE: M
  WIRECOUNT: null
  SUBTYPECD: 1
  COMPATIBLEUNITID: 372
  OPERATINGVOLTAGE: 190
  ISFEEDERTRUNK: NA
  NEUTRALUSECD: null
  PHASECONFIGURATION: null
  FEATURE_STATUS: Existing
  TL_DESIGNATION: null
  TREETRIMLEVEL: null
  TREETRIMDATE: null
  ASSETID: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata