View In:   ArcGIS Online Map Viewer

Name: Primary Underground Line

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: SubtypeCode: 1- Underground Primary R Phase2- Underground Primary Y Phase3- Underground Primary B Phase4- Underground Primary 2 Phase5- Underground Primary 3 Phase99- UnknownUsed Fields:OperatingVoltage:CompatibleUnitID:Phase Designation:ConductorRejuvenationDate:IsFeederTrunk: (350, 500, 600) MCM=YesCityworks ProjectUnused Fields:NeutralUseCode.

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

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: 13380.0
YMin: 5535750.0
XMax: 31440.0
YMax: 5551080.0
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: R
  Description:
  Symbol:
  Style: esriSLSDashDot
  Color: [169, 0, 230, 255]
  Width: 1
• Value: 2
  Label: Y
  Description:
  Symbol:
  Style: esriSLSDashDot
  Color: [169, 0, 230, 255]
  Width: 1
• Value: 3
  Label: B
  Description:
  Symbol:
  Style: esriSLSDashDot
  Color: [169, 0, 230, 255]
  Width: 1
• Value: 5
  Label: 3
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 1
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: SUBTYPECD

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: 3, 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: 232, 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 )
• 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] )
• 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... )
• CONDUCTOR_REJUVENATION ( type: esriFieldTypeDate, alias: Conductor Rejuvenation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDUCTOR_REJUVENATION )
• 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... )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• CITYWORKSPROJECT ( type: esriFieldTypeInteger, alias: Cityworks Project, editable: true, nullable: true, defaultValue: 0, modelName: CITYWORKSPROJECT , Coded Values: [0: No] , [1: Yes] )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID, editable: true, nullable: true, defaultValue: null, modelName: RULEID , Coded Values: [1: 1 Phase] , [2: 2 Phase] , [3: 3 Phase] , ...3 more... )
• DEDICATEDNEUTRAL ( type: esriFieldTypeString, alias: Dedicated Neutral, editable: true, nullable: true, length: 10, defaultValue: 1, modelName: DEDICATEDNEUTRAL , Coded Values: [1: C.N.] , [4: 4/0 Cu. Sec. RW90/XLPE/XLINK] , [2: 2/0 Cu. Sec. RW90/XLPE/XLINK] , ...5 more... )
• NEUTRALBONDINGTYPE ( type: esriFieldTypeString, alias: NeutralBondingType, editable: true, nullable: true, length: 1, defaultValue: null, modelName: NEUTRALBONDINGTYPE , Coded Values: [1: Single Point Bond - See equipment for where conductor bond is located] , [2: Double Point Bond - Conductor is bonded at both ends.] )

Types:

ID: 1
Name: Underground Primary R Phase
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• LENGTHSOURCE:
  Inherited
• LENGTHUOMCODE:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [232: Cable/Wire #2 CU CN 15kV] , [225: Cable/Wire 500 MCM CU CN 15kV] , [400: Cable/Wire #2 AL CN 15kV] , ...10 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...
• ISFEEDERTRUNK:
  Coded Values: [NA: Not Applicable]
• NEUTRALUSECD:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Underground Primary R Phase
  Description:
  Prototype:
  DEDICATEDNEUTRAL: null
  NEUTRALBONDINGTYPE: null
  ENABLED: 1
  WORKORDERID: null
  INSTALLATIONDATE: null
  FIELDVERIFY: 0
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WMSID: null
  WORKFLOWSTATUS: 0
  WORKFUNCTION: 0
  FEEDERID: null
  FEEDERID2: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  LOCATIONID: null
  LENGTHSOURCE: MS
  MEASUREDLENGTH: null
  LENGTHUOMCODE: M
  WIRECOUNT: 1
  GISONUMBER: null
  GISOTYPENBR: 23
  SUBTYPECD: 1
  LABELTEXT: null
  COMPATIBLEUNITID: null
  OWNERSHIP: null
  PHASEDESIGNATION: 4
  OPERATINGVOLTAGE: 190
  NOMINALVOLTAGE: null
  ISFEEDERTRUNK: NA
  NEUTRALUSECD: null
  FEATURE_STATUS:
  CONDUCTOR_REJUVENATION: null
  TL_DESIGNATION: null
  ASSETID: null
  CITYWORKSPROJECT: null
  RULEID: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Underground Primary Y Phase
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• LENGTHSOURCE:
  Inherited
• LENGTHUOMCODE:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [232: Cable/Wire #2 CU CN 15kV] , [225: Cable/Wire 500 MCM CU CN 15kV] , [400: Cable/Wire #2 AL CN 15kV] , ...10 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...
• ISFEEDERTRUNK:
  Coded Values: [NA: Not Applicable]
• NEUTRALUSECD:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Underground Primary Y Phase
  Description:
  Prototype:
  DEDICATEDNEUTRAL: null
  NEUTRALBONDINGTYPE: null
  ENABLED: 1
  WORKORDERID: null
  INSTALLATIONDATE: null
  FIELDVERIFY: 0
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WMSID: null
  WORKFLOWSTATUS: 0
  WORKFUNCTION: 0
  FEEDERID: null
  FEEDERID2: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  LOCATIONID: null
  LENGTHSOURCE: MS
  MEASUREDLENGTH: null
  LENGTHUOMCODE: M
  WIRECOUNT: 1
  GISONUMBER: null
  GISOTYPENBR: 23
  SUBTYPECD: 2
  LABELTEXT: null
  COMPATIBLEUNITID: null
  OWNERSHIP: null
  PHASEDESIGNATION: 2
  OPERATINGVOLTAGE: 190
  NOMINALVOLTAGE: null
  ISFEEDERTRUNK: NA
  NEUTRALUSECD: null
  FEATURE_STATUS:
  CONDUCTOR_REJUVENATION: null
  TL_DESIGNATION: null
  ASSETID: null
  CITYWORKSPROJECT: null
  RULEID: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Underground Primary B Phase
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• LENGTHSOURCE:
  Inherited
• LENGTHUOMCODE:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [232: Cable/Wire #2 CU CN 15kV] , [225: Cable/Wire 500 MCM CU CN 15kV] , [400: Cable/Wire #2 AL CN 15kV] , ...10 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...
• ISFEEDERTRUNK:
  Coded Values: [NA: Not Applicable]
• NEUTRALUSECD:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Underground Primary B Phase
  Description:
  Prototype:
  DEDICATEDNEUTRAL: null
  NEUTRALBONDINGTYPE: null
  ENABLED: 1
  WORKORDERID: null
  INSTALLATIONDATE: null
  FIELDVERIFY: 0
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WMSID: null
  WORKFLOWSTATUS: 0
  WORKFUNCTION: 0
  FEEDERID: null
  FEEDERID2: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  LOCATIONID: null
  LENGTHSOURCE: MS
  MEASUREDLENGTH: null
  LENGTHUOMCODE: M
  WIRECOUNT: 1
  GISONUMBER: null
  GISOTYPENBR: 23
  SUBTYPECD: 3
  LABELTEXT: null
  COMPATIBLEUNITID: null
  OWNERSHIP: null
  PHASEDESIGNATION: 1
  OPERATINGVOLTAGE: 190
  NOMINALVOLTAGE: null
  ISFEEDERTRUNK: NA
  NEUTRALUSECD: null
  FEATURE_STATUS:
  CONDUCTOR_REJUVENATION: null
  TL_DESIGNATION: null
  ASSETID: null
  CITYWORKSPROJECT: null
  RULEID: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: Underground Primary 3 Phase
Domains:
• ENABLED:
  Inherited
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• LENGTHSOURCE:
  Inherited
• LENGTHUOMCODE:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [232: Cable/Wire #2 CU CN 15kV] , [225: Cable/Wire 500 MCM CU CN 15kV] , [400: Cable/Wire #2 AL CN 15kV] , ...10 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...
• ISFEEDERTRUNK:
  Coded Values: [0: No] , [1: Yes]
• NEUTRALUSECD:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Underground Primary 3 Phase
  Description:
  Prototype:
  DEDICATEDNEUTRAL: null
  NEUTRALBONDINGTYPE: null
  ENABLED: 1
  WORKORDERID: null
  INSTALLATIONDATE: null
  FIELDVERIFY: 0
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WMSID: null
  WORKFLOWSTATUS: 0
  WORKFUNCTION: 0
  FEEDERID: null
  FEEDERID2: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  LOCATIONID: null
  LENGTHSOURCE: MS
  MEASUREDLENGTH: null
  LENGTHUOMCODE: M
  WIRECOUNT: 3
  GISONUMBER: null
  GISOTYPENBR: 25
  SUBTYPECD: 5
  LABELTEXT: null
  COMPATIBLEUNITID: null
  OWNERSHIP: null
  PHASEDESIGNATION: 7
  OPERATINGVOLTAGE: 250
  NOMINALVOLTAGE: null
  ISFEEDERTRUNK: null
  NEUTRALUSECD: null
  FEATURE_STATUS:
  CONDUCTOR_REJUVENATION: null
  TL_DESIGNATION: null
  ASSETID: null
  CITYWORKSPROJECT: null
  RULEID: 3
  
  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