View In:   ArcGIS Online Map Viewer

Name: Underground Transmission Line

Display Field: WORKORDERID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: SubtypeCode: 1- Underground LineUsed Fields:OperatingVoltage:CompatibleUnitID:Phase Designation:ConductorRejuvenationDate:IsFeederTrunk: (350, 500, 600) MCM=YesUnused 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: 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: 19960.0
YMin: 5541693.2085
XMax: 26482.999800000303
YMax: 5547370.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: 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 , 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] )
• 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 )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID, editable: true, nullable: true, defaultValue: null, modelName: RULEID , Coded Values: [-1: Free Representation] , [1: Underground Transmission Line] )
• CITYWORKSPROJECT ( type: esriFieldTypeInteger, alias: Cityworks Project?, editable: true, nullable: true, defaultValue: 0, modelName: CITYWORKSPROJECT , Coded Values: [0: No] , [1: Yes] )

Templates:

• Name: Underground Transmission Line
  Description:
  Prototype:
  CITYWORKSPROJECT: null
  WMSID: null
  WORKFLOWSTATUS: 0
  LOCATIONID: null
  MEASUREDLENGTH: null
  GISONUMBER: null
  GISOTYPENBR: 23
  OWNERSHIP: null
  PHASEDESIGNATION: 4
  NOMINALVOLTAGE: null
  NEUTRALUSECD: 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
  LABELTEXT: null
  COMPATIBLEUNITID: null
  OPERATINGVOLTAGE: 190
  ISFEEDERTRUNK: NA
  FEATURE_STATUS: Existing
  CONDUCTOR_REJUVENATION: null
  TL_DESIGNATION: 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