View In:   ArcGIS Online Map Viewer

Name: Light

Display Field: DEVICENUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: 13032.714899999999
YMin: 5535903.966
XMax: 31428.9266999997
YMax: 5550870.3756
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: Steel Standard
  Description:
  Symbol:
  
• Value: 2
  Label: Traditional/Misc.
  Description:
  Symbol:
  
• Value: 3
  Label: Wood Pole
  Description:
  Symbol:
  
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: esriServerHTMLPopupTypeNone

Type ID Field: SUBTYPECD

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: CompatibleUnitID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: COMPATIBLEUNITID , Coded Values: [1297: Light - 10 LED (Type 2) - 16] , [1221: Light - 100 LED] , [1230: Light - 100 LED - 13] , ...64 more... )
• DEVICENUMBER ( type: esriFieldTypeString, alias: DeviceNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DEVICENUMBER )
• BREAKTYPE ( type: esriFieldTypeString, alias: BreakType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BREAKTYPE )
• BREAKDESC ( type: esriFieldTypeString, alias: BreakDescription, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BreakDesc )
• 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: esriFieldTypeDate, alias: REPLACED_DATE_MM_DD_YYYY, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPLACED_DATE_MM_DD_YYYY )
• 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: SecondaryFeederID, 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 )
• TAP_SETTINGS ( type: esriFieldTypeString, alias: Tap Settings, editable: true, nullable: true, length: 50, defaultValue: Med, modelName: TAP_SETTINGS , Coded Values: [Low: Low] , [Med: Med] , [High: High] )
• PHOTOHEAD ( type: esriFieldTypeInteger, alias: Photo Head, editable: true, nullable: true, defaultValue: 0, modelName: PHOTOHEAD , Coded Values: [0: No] , [1: Yes] )
• LIGHTMISCANNO ( type: esriFieldTypeString, alias: LightMiscAnno, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LIGHTMISCANNO )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID, editable: true, nullable: true, defaultValue: null, modelName: RULEID , Coded Values: [1: Streetlight on Wood Pole] , [2: Streetlight on Steel Pole] , [3: Miscellaneous Light] , ...1 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] )
• AIRQUALITYMONITOR ( type: esriFieldTypeInteger, alias: Liveable Cities ECCC Air Quality Monitor, editable: true, nullable: true, defaultValue: null, modelName: AIRQUALITYMONITOR , Coded Values: [0: No] , [1: Yes] )

Types:

ID: 1
Name: Streetlight on Steel Pole
Domains:
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• GISOTYPENBR:
  Coded Values: [701212: Light Polemount] , [700215: Light] , [702515: Light Miscellaneous]
• COMPATIBLEUNITID:
  Inherited
• ENABLED:
  Inherited
• PHASEDESIGNATION:
  Inherited
• TAP_SETTINGS:
  Inherited
• PHOTOHEAD:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Steel Standard
  Description:
  Prototype:
  INSTALLATIONDATE: null
  WMSID: null
  WORKFLOWSTATUS: 0
  GISONUMBER: null
  GISOTYPENBR: 701212
  OWNERSHIP: null
  BREAKDESC: null
  REPLACED_DATE_MM_DD_YYYY: null
  ELECTRICTRACEWEIGHT: null
  TAP_SETTINGS: Med
  AIRQUALITYMONITOR: null
  WORKORDERID: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WORKFUNCTION: 0
  SYMBOLROTATION: null
  GPSDATE: null
  SUBTYPECD: 1
  LABELTEXT: null
  COMPATIBLEUNITID: 1035
  DEVICENUMBER: null
  BREAKTYPE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  ENABLED: 1
  FEEDERID: null
  FEEDERID2: null
  PHASEDESIGNATION: null
  FEEDERINFO: null
  PHOTOHEAD: 0
  LIGHTMISCANNO: null
  RULEID: null
  ASSETID: null
  CITYWORKSPROJECT: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Miscellaneous Light
Domains:
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• GISOTYPENBR:
  Coded Values: [701212: Light Polemount] , [700215: Light] , [702515: Light Miscellaneous]
• COMPATIBLEUNITID:
  Inherited
• ENABLED:
  Inherited
• PHASEDESIGNATION:
  Inherited
• TAP_SETTINGS:
  Inherited
• PHOTOHEAD:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Traditional/Misc.
  Description:
  Prototype:
  INSTALLATIONDATE: null
  WMSID: null
  WORKFLOWSTATUS: 0
  GISONUMBER: null
  GISOTYPENBR: 702515
  OWNERSHIP: null
  BREAKDESC: null
  REPLACED_DATE_MM_DD_YYYY: null
  ELECTRICTRACEWEIGHT: null
  TAP_SETTINGS: Med
  AIRQUALITYMONITOR: null
  WORKORDERID: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WORKFUNCTION: 0
  SYMBOLROTATION: null
  GPSDATE: null
  SUBTYPECD: 2
  LABELTEXT: null
  COMPATIBLEUNITID: 825
  DEVICENUMBER: null
  BREAKTYPE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  ENABLED: 1
  FEEDERID: null
  FEEDERID2: null
  PHASEDESIGNATION: null
  FEEDERINFO: null
  PHOTOHEAD: 0
  LIGHTMISCANNO: null
  RULEID: null
  ASSETID: null
  CITYWORKSPROJECT: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Streetlight on Wood Pole
Domains:
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• GISOTYPENBR:
  Coded Values: [701212: Light Polemount] , [700215: Light] , [702515: Light Miscellaneous]
• COMPATIBLEUNITID:
  Inherited
• ENABLED:
  Inherited
• PHASEDESIGNATION:
  Inherited
• TAP_SETTINGS:
  Inherited
• PHOTOHEAD:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Wood Pole
  Description:
  Prototype:
  INSTALLATIONDATE: null
  WMSID: null
  WORKFLOWSTATUS: 0
  GISONUMBER: null
  GISOTYPENBR: 700215
  OWNERSHIP: null
  BREAKDESC: null
  REPLACED_DATE_MM_DD_YYYY: null
  ELECTRICTRACEWEIGHT: null
  TAP_SETTINGS: Med
  AIRQUALITYMONITOR: null
  WORKORDERID: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WORKFUNCTION: 0
  SYMBOLROTATION: null
  GPSDATE: null
  SUBTYPECD: 3
  LABELTEXT: null
  COMPATIBLEUNITID: 366
  DEVICENUMBER: null
  BREAKTYPE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  ENABLED: 1
  FEEDERID: null
  FEEDERID2: null
  PHASEDESIGNATION: null
  FEEDERINFO: null
  PHOTOHEAD: 0
  LIGHTMISCANNO: null
  RULEID: null
  ASSETID: null
  CITYWORKSPROJECT: 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