Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: Sensor deployment details for water sensors deployed in the Snohomish River estuary Washington from 2010-02-18 to 2014-09-02
Short Name: Snohomish River Sensor Details
Status: Planned
Abstract:

Details for sensors deployed in the Snohomish River estuary.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: PARR
Description:

Details for sensors deployed in the Snohomish River estuary.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID Number Auto record ID.
100
SiteID Text Siteid linked to Sensor Data and Site Details tables.
100
Deployment Start Date Date/Time Start date and time of sensor deployment.
100
Deployment End Date Date/Time End date and time of sensor deployment.
100
SN Number Serial number of sensor.
100
DCE Number Data collection event, coded as the YYYYMMDD of when the sensor was downloaded.
100
SNDCE Text Contantenation of SN and DCE fields to link to Sensor Data table.
100
Processed? Text Data flag to indicate whether or not data for the sensor download has been processed and added to the Sensor Data table.
100
Deployment Notes Text Notes from deployment of sensor at time of deployment start date.
100
Retrieval Notes Text Notes from retieval of sensor at time of deployment end date.

Attribute Details

ID

CC ID: 793233
Seq. Order: 1
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Auto record ID.

General Data Type: Number

SiteID

CC ID: 793234
Seq. Order: 2
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Siteid linked to Sensor Data and Site Details tables.

General Data Type: Text
Format Mask: @

Deployment Start Date

CC ID: 793235
Seq. Order: 3
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Start date and time of sensor deployment.

General Data Type: Date/Time
Format Mask: m/d/yyyy

Deployment End Date

CC ID: 793236
Seq. Order: 4
Data Storage Type: Date/Time
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

End date and time of sensor deployment.

General Data Type: Date/Time
Format Mask: m/d/yyyy

SN

CC ID: 793237
Seq. Order: 5
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Serial number of sensor.

General Data Type: Number

DCE

CC ID: 793238
Seq. Order: 6
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Data collection event, coded as the YYYYMMDD of when the sensor was downloaded.

General Data Type: Number

SNDCE

CC ID: 793239
Seq. Order: 7
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Contantenation of SN and DCE fields to link to Sensor Data table.

General Data Type: Text

Processed?

CC ID: 793240
Seq. Order: 8
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Data flag to indicate whether or not data for the sensor download has been processed and added to the Sensor Data table.

General Data Type: Text
Format Mask: @

Deployment Notes

CC ID: 793241
Seq. Order: 9
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Notes from deployment of sensor at time of deployment start date.

General Data Type: Text
Format Mask: @

Retrieval Notes

CC ID: 793242
Seq. Order: 10
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Notes from retieval of sensor at time of deployment end date.

General Data Type: Text
Format Mask: @

Catalog Details

Catalog Item ID: 54428
GUID: gov.noaa.nmfs.inport:54428
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2018-10-25 14:08+0000
Metadata Record Last Modified By: Jeffrey W Cowen
Metadata Record Last Modified: 2018-10-25 14:08+0000
Metadata Record Published: 2018-10-25
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-10-26