Name: ONC_Instruments_Alltime

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_Instruments_All_20250702.sql" is used to populate this feature class. Last updated 2025-10-14.

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: -144.4
YMin: -62.657553
XMax: -53.1208799999999
YMax: 74.6602500000001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[50,168,89,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Time Info:

Start Time Field: datefrom
End Time Field: dateto
Track ID Field: null
Time Extent
[2/8/2006 12:00:00 AM UTC, 9/15/2025 4:45:00 AM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

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)
• devicecategoryname (type: esriFieldTypeString, alias: devicecategoryname, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• devicename (type: esriFieldTypeString, alias: devicename, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• deviceid (type: esriFieldTypeInteger, alias: deviceid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• devicecode (type: esriFieldTypeString, alias: devicecode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• datefrom (type: esriFieldTypeDate, alias: datefrom, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• dateto (type: esriFieldTypeDate, alias: dateto, SQL Type: sqlTypeOther, length: 8, 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)
• image_url (type: esriFieldTypeString, alias: image_url, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: ONC_Instruments_Alltime
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/9/2025 6:35:02 PM

Schema Last Edit Date: 12/9/2025 6:35:02 PM

Data Last Edit Date: 10/14/2025 8:20:03 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat