View In:   ArcGIS Online Map Viewer

Name: Traffic Light Cable - Downtown - Municipal Works

Display Field: WORKORDERID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This is all equipment that is behind the meter downtown and owned by Municipal Works but we track and locate on their behalf.Originally was like normal Municipal Works Street and Traffic Lighting. In 2016 it was decided to put them behind a meter. Generally anything behind a meter is not Electric's responsibiility, but a deal was made that we would maintain the records and do the locates for these features.

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

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 2500.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: 22858.8947000001
YMin: 5544582.463
XMax: 23468.5207000002
YMax: 5544958.0816
Spatial Reference: 3779  (3779)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 43, 150, 255]
Width: 1
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 )
• 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 )
• LENGTHSOURCE ( type: esriFieldTypeString, alias: LengthSource, 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 , Range: [1, 1000000000] )
• 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... )
• USECODE ( type: esriFieldTypeString, alias: USECODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: USECODE )
• 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: 4, modelName: SubtypeCD )
• LABELTEXT ( type: esriFieldTypeString, alias: LABELTEXT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LABELTEXT )
• OWNERSHIP ( type: esriFieldTypeString, alias: FeatureOwnedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Ownership )
• COMPATIBLEUNITID ( type: esriFieldTypeString, alias: Conductor Size, editable: true, nullable: true, length: 5, defaultValue: null, modelName: COMPATIBLEUNITID , Coded Values: [230: Cable/Wire #6 CU CN 600V] , [231: Cable/Wire 2/0 CU CN 600V] , [373: Cable/Wire #10 CU] , ...60 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... )
• PHASEDESIGNATION ( type: esriFieldTypeInteger, alias: PhaseDesignation, editable: true, nullable: true, defaultValue: null, modelName: PhaseDesignation , Coded Values: [4: R] , [2: Y] , [1: B] , ...5 more... )
• FDRMGRNONTRACEABLE ( type: esriFieldTypeInteger, alias: FdrMgrNonTraceable, editable: true, nullable: true, defaultValue: 1, modelName: FDRMGRNONTRACEABLE , Coded Values: [0: Traceable] , [1: Non-Traceable] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• 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... )
• STREETLIGHT_FACILITY ( type: esriFieldTypeString, alias: STREETLIGHT_FACILITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETLIGHT_FACILITY , Coded Values: [STLT-REN: Streetlights-rental lights] , [LT-OTHER: Lights - Other] , [STLT-MED: Streetlights-in Medicine Hat (529760)] , ...8 more... )
• REPLACED_DATE_MM_DD_YYYY ( type: esriFieldTypeString, alias: REPLACED_DATE_MM_DD_YYYY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REPLACED_DATE_MM_DD_YYYY )
• CONTROL_CABLE ( type: esriFieldTypeString, alias: Control Cable, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTROL_CABLE , Coded Values: [0: No] , [1: Yes] )
• 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 )
• FEEDERID2 ( type: esriFieldTypeString, alias: SecondaryFeederID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FEEDERID2 )
• ASSETID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• FEATURESTATUS ( type: esriFieldTypeString, alias: Feature Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FEATURESTATUS , Coded Values: [E: Existing] , [A: Abasnonded In Place] , [R: Removed from Field] )

Templates:

• Name: Traffic Light Cable - Downtown - Municipal Works
  Description:
  Prototype:
  ASSETID: null
  FEATURESTATUS: null
  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
  LENGTHSOURCE: MS
  MEASUREDLENGTH: null
  LENGTHUOMCODE: M
  USECODE: null
  WIRECOUNT: null
  GISONUMBER: null
  GISOTYPENBR: null
  SUBTYPECD: 4
  LABELTEXT: null
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  OPERATINGVOLTAGE: null
  PHASEDESIGNATION: null
  FDRMGRNONTRACEABLE: 1
  ENABLED: 1
  FEATURE_STATUS: Existing
  STREETLIGHT_FACILITY: null
  REPLACED_DATE_MM_DD_YYYY: null
  CONTROL_CABLE: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  FEEDERID2: 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