Name: ONC_Instruments
Display Field: sitename
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: Currently deployed devices are retrieved from the Oceans 3.0 database using sitedevice, device, site, and device category tables. The SQL script: "ONC_CurrentlyDeployedDevicesQueryPGres_Images_20250107.sql" is used to populate this feature class. Last updated 2026-01-20.
Copyright Text: Ocean Networks Canada
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -16074534.4705487
YMin: 5481387.77963633
XMax: -5913410.24015486
YMax: 12380813.2476264
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature['sitename']","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"all","removeDuplicatesDistance":0,"stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":2,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- siteid (type: esriFieldTypeInteger, alias: siteid, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sitename (type: esriFieldTypeString, alias: sitename, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- latitudedd (type: esriFieldTypeDouble, alias: latitudedd, SQL Type: sqlTypeOther, nullable: true, editable: true)
- longitudedd (type: esriFieldTypeDouble, alias: longitudedd, SQL Type: sqlTypeOther, nullable: true, editable: true)
- depth (type: esriFieldTypeDouble, alias: depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
- locationname (type: esriFieldTypeString, alias: locationname, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- deviceid (type: esriFieldTypeInteger, alias: deviceid, SQL Type: sqlTypeOther, nullable: true, editable: true)
- devicename (type: esriFieldTypeString, alias: devicename, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- devicecategoryname (type: esriFieldTypeString, alias: devicecategoryname, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- devicecode (type: esriFieldTypeString, alias: devicecode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- locationcode (type: esriFieldTypeString, alias: locationcode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- image_url (type: esriFieldTypeString, alias: image_url, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Templates:
Name: ONC_Instruments
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/20/2026 7:38:26 PM
Schema Last Edit Date: 1/20/2026 7:38:26 PM
Data Last Edit Date: 1/20/2026 7:38:26 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat