View In:   ArcGIS Online Map Viewer

Name: Traffic Controller - Downtown - Municipal Works

Display Field: WORKORDERID

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: 22874.2166999998
YMin: 5544614.637
XMax: 23384.7956999997
YMax: 5544920.256
Spatial Reference: 3779  (3779)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [138, 0, 37, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 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... )
• SYMBOLROTATION ( type: esriFieldTypeSingle, alias: SymbolRotation, editable: true, nullable: true, defaultValue: null, modelName: SYMBOLROTATION )
• GPSDATE ( type: esriFieldTypeDate, alias: GPSDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• 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 )
• OWNERSHIP ( type: esriFieldTypeString, alias: FeatureOwnedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Ownership )
• COMPATIBLEUNITID ( type: esriFieldTypeString, alias: Compatible Unit ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: COMPATIBLEUNITID , Coded Values: [994: Controller-Traffic Light] )
• DEVICENUMBER ( type: esriFieldTypeString, alias: DeviceNumber, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DEVICENUMBER )
• 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... )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, editable: true, nullable: true, length: 100, defaultValue: L:\shared2\Electric\DOWNLOAD\PS-trcontr_pdf\, modelName: HYPERLINK )
• HYPERLINK_PGDB ( type: esriFieldTypeString, alias: HYPERLINK_PGDB, editable: true, nullable: true, length: 50, defaultValue: C:\ARCFM\PS-trcontr_pdf\, modelName: HYPERLINK_PGDB )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• FEEDERID ( type: esriFieldTypeString, alias: FeederID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FEEDERID )
• FEEDERID2 ( type: esriFieldTypeString, alias: FeederID2, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FEEDERID2 )
• PHASEDESIGNATION ( type: esriFieldTypeInteger, alias: Phase Designation, editable: true, nullable: true, defaultValue: null, modelName: PHASEDESIGNATION , Coded Values: [4: R] , [2: Y] , [1: B] , ...5 more... )
• FEEDERINFO ( type: esriFieldTypeInteger, alias: FeederInfo, editable: true, nullable: true, defaultValue: null, modelName: FEEDERINFO )
• ELECTRICTRACEWEIGHT ( type: esriFieldTypeInteger, alias: MMElectricTraceWeight, editable: true, nullable: true, defaultValue: null, modelName: ELECTRICTRACEWEIGHT )
• 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 Controller - 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
  SYMBOLROTATION: null
  GPSDATE: null
  GISONUMBER: null
  GISOTYPENBR: null
  SUBTYPECD: 1
  LABELTEXT: null
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  DEVICENUMBER: null
  FEATURE_STATUS: Existing
  HYPERLINK: L:\shared2\Electric\DOWNLOAD\PS-trcontr_pdf\
  HYPERLINK_PGDB: C:\ARCFM\PS-trcontr_pdf\
  ENABLED: 1
  FEEDERID: null
  FEEDERID2: null
  PHASEDESIGNATION: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  
  Drawing Tool: esriFeatureEditToolPoint

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