View In:   ArcGIS Online Map Viewer

Name: Traffic Light Pole - 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: 22867.3737000003
YMin: 5544584.276
XMax: 23401.2127
YMax: 5544951.95
Spatial Reference: 3779  (3779)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [61, 0, 140, 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: 7, modelName: SubtypeCD )
• LABELTEXT ( type: esriFieldTypeString, alias: LabelText, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LABELTEXT )
• OWNERSHIP ( type: esriFieldTypeString, alias: Joint Use, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Ownership )
• COMPATIBLEUNITID ( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: COMPATIBLEUNITID , Coded Values: [1020: Combination Tr St Lt 11m Davit Galvanized] , [1021: Combination Tr St Lt 13m Davit Galvanized] , [1022: Combination Tr St Lt 15m Davit Galvanized] , ...91 more... )
• STRUCTURENUMBER ( type: esriFieldTypeString, alias: StructureNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STRUCTURENUMBER )
• STREETLIGHT_FACILITY ( type: esriFieldTypeString, alias: STREETLIGHT_FACILITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETLIGHT_FACILITY )
• REPLACED_DATE_MM_DD_YYYY ( type: esriFieldTypeDate, alias: REPLACED_DATE_MM_DD_YYYY, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPLACED_DATE_MM_DD_YYYY )
• DEVICENUMBER ( type: esriFieldTypeString, alias: DeviceNumber, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DEVICENUMBER )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: CONDITION, editable: true, nullable: true, defaultValue: 0, modelName: CONDITION , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• CONDITION_STATUS ( type: esriFieldTypeString, alias: CONDITION_STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION_STATUS )
• CONDITION_DATE ( type: esriFieldTypeDate, alias: CONDITION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITION_DATE )
• 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 Pole - 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: 7
  LABELTEXT: null
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  STRUCTURENUMBER: null
  STREETLIGHT_FACILITY: null
  REPLACED_DATE_MM_DD_YYYY: null
  DEVICENUMBER: null
  CONDITION: 0
  CONDITION_STATUS: null
  CONDITION_DATE: 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