Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Sensor Data
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36220 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Continuous sensor data from three two-week observation periods at each site, including water level, salinity, and temperature at one-minute intervals above and below each culvert and vault, and at each reference channel.
DescriptionContinuous sensor data from three two-week observation periods at each site, including water level, salinity, and temperature at one-minute intervals above and below each culvert and vault, and at each reference channel.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
ID
NUMBER |
Record ID. |
Site
VARCHAR2 |
Site name (see Site Details table for more information on each site). |
Date
DATE |
Date of observation. |
Time
DATE |
Time of observation. |
DCE
NUMBER |
Id number of data collection event, with each site having been sampled three intervals during 2011. |
Upstream Water Elevation (NAVD88 meters)
NUMBER |
Measured elevation of water immediately upstream of the structure in NAVD88. |
Downstream Water Elevation (NAVD88 meters)
NUMBER |
Measured elevation of water immediately downstrem of the structure in NAVD88. |
Downstream Water Elevation and Perch Elevation Difference (m)
NUMBER |
Downstream water elevation relative to the elevation of the downstream interior floor of the structure (perch elevation), with negative values indicating that the structure is perched and a water fall has formed at the structure mouth. |
Inside Depth (m)
NUMBER |
Water depth inside the structure. |
Tilt (degree)
NUMBER |
Angle readings from tilt sensors used to determine when gate doors opened and closed. Values do not necessarily coorespond with actual angles of the door positions. |
Gate
VARCHAR2 |
Classification of the gate door position based on the tilt data. |
Temperature Upstream (C)
NUMBER |
Water temperature upstream of the structure. |
Salinity Upstream (ppt)
NUMBER |
Water salinity upstream of the structure. |
Temperature Downstream (C)
NUMBER |
Water temperature downstream of the structure. |
Salinity Downstream (ppt)
NUMBER |
Water salinity downstream of the structure. |
TideGage
VARCHAR2 |
Name of closest tide gage station. |
Tide_m
NUMBER |
Tide height in meters - not corrected for local lags between tide gage and site. |
Tide
VARCHAR2 |
Classification of tidal stage as ebbing or flooding. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NWFSC) for inquiries on this record.
Item Identification
Title: | Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Sensor Data |
---|---|
Short Name: | Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Sensor Data |
Status: | Planned |
Abstract: |
Continuous sensor data from three two-week observation periods at each site, including water level, salinity, and temperature at one-minute intervals above and below each culvert and vault, and at each reference channel. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | PARR |
Description: |
Continuous sensor data from three two-week observation periods at each site, including water level, salinity, and temperature at one-minute intervals above and below each culvert and vault, and at each reference channel. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ID | NUMBER | Record ID. | |
100
|
Site | VARCHAR2 | Site name (see Site Details table for more information on each site). | |
100
|
Date | DATE | Date of observation. | |
100
|
Time | DATE | Time of observation. | |
100
|
DCE | NUMBER | Id number of data collection event, with each site having been sampled three intervals during 2011. | |
100
|
Upstream Water Elevation (NAVD88 meters) | NUMBER | Measured elevation of water immediately upstream of the structure in NAVD88. | |
100
|
Downstream Water Elevation (NAVD88 meters) | NUMBER | Measured elevation of water immediately downstrem of the structure in NAVD88. | |
100
|
Downstream Water Elevation and Perch Elevation Difference (m) | NUMBER | Downstream water elevation relative to the elevation of the downstream interior floor of the structure (perch elevation), with negative values indicating that the structure is perched and a water fall has formed at the structure mouth. | |
100
|
Inside Depth (m) | NUMBER | Water depth inside the structure. | |
100
|
Tilt (degree) | NUMBER | Angle readings from tilt sensors used to determine when gate doors opened and closed. Values do not necessarily coorespond with actual angles of the door positions. | |
100
|
Gate | VARCHAR2 | Classification of the gate door position based on the tilt data. | |
100
|
Temperature Upstream (C) | NUMBER | Water temperature upstream of the structure. | |
100
|
Salinity Upstream (ppt) | NUMBER | Water salinity upstream of the structure. | |
100
|
Temperature Downstream (C) | NUMBER | Water temperature downstream of the structure. | |
100
|
Salinity Downstream (ppt) | NUMBER | Water salinity downstream of the structure. | |
100
|
TideGage | VARCHAR2 | Name of closest tide gage station. | |
100
|
Tide_m | NUMBER | Tide height in meters - not corrected for local lags between tide gage and site. | |
100
|
Tide | VARCHAR2 | Classification of tidal stage as ebbing or flooding. |
Attribute Details
ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Record ID. |
General Data Type: | NUMBER |
Site
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Site name (see Site Details table for more information on each site). |
General Data Type: | VARCHAR2 |
Format Mask: | @ |
Date
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of observation. |
General Data Type: | DATE |
Format Mask: | m/d/yyyy |
Time
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time of observation. |
General Data Type: | DATE |
Format Mask: | Short Time |
DCE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Id number of data collection event, with each site having been sampled three intervals during 2011. |
General Data Type: | NUMBER |
Format Mask: | 0 |
Upstream Water Elevation (NAVD88 meters)
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured elevation of water immediately upstream of the structure in NAVD88. |
General Data Type: | NUMBER |
Format Mask: | Fixed |
Downstream Water Elevation (NAVD88 meters)
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured elevation of water immediately downstrem of the structure in NAVD88. |
General Data Type: | NUMBER |
Format Mask: | Fixed |
Downstream Water Elevation and Perch Elevation Difference (m)
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Downstream water elevation relative to the elevation of the downstream interior floor of the structure (perch elevation), with negative values indicating that the structure is perched and a water fall has formed at the structure mouth. |
General Data Type: | NUMBER |
Format Mask: | Fixed |
Inside Depth (m)
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Water depth inside the structure. |
General Data Type: | NUMBER |
Tilt (degree)
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Angle readings from tilt sensors used to determine when gate doors opened and closed. Values do not necessarily coorespond with actual angles of the door positions. |
General Data Type: | NUMBER |
Format Mask: | 0.0 |
Gate
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Classification of the gate door position based on the tilt data. |
General Data Type: | VARCHAR2 |
Format Mask: | 0 |
Temperature Upstream (C)
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Water temperature upstream of the structure. |
General Data Type: | NUMBER |
Format Mask: | 0.0 |
Salinity Upstream (ppt)
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Water salinity upstream of the structure. |
General Data Type: | NUMBER |
Format Mask: | 0.0 |
Temperature Downstream (C)
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Water temperature downstream of the structure. |
General Data Type: | NUMBER |
Format Mask: | 0.0 |
Salinity Downstream (ppt)
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Water salinity downstream of the structure. |
General Data Type: | NUMBER |
Format Mask: | 0.0 |
TideGage
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of closest tide gage station. |
General Data Type: | VARCHAR2 |
Tide_m
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tide height in meters - not corrected for local lags between tide gage and site. |
General Data Type: | NUMBER |
Tide
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Classification of tidal stage as ebbing or flooding. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 36220 |
---|---|
GUID: | gov.noaa.nmfs.inport:36220 |
Metadata Record Created By: | Jeffrey W Cowen |
Metadata Record Created: | 2017-01-06 11:02+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-02-27 |
Owner Org: | NWFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-02-27 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-02-27 |