Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Flow Data
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36219
| Published / External
Created: 2017-01-06
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 18067
ID: 36219
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Flow Data |
---|---|
Short Name | Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Flow Data |
* Status | Planned |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Water velocity measurements at each site. HACH Ultrasonic Submerged Area Velocity Meters (Sigma 950) were deployed approximately 24-hours at each site. Sensors were 7 cm above the ground in the middle of the culvert, vault, or channel floor. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | PARR |
» Description |
Water velocity measurements at each site. HACH Ultrasonic Submerged Area Velocity Meters (Sigma 950) were deployed approximately 24-hours at each site. Sensors were 7 cm above the ground in the middle of the culvert, vault, or channel floor. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | ID1 | NUMBER | Record ID. |
100 | No | No | Site | VARCHAR2 | Site name (see Site Details table for more information). |
100 | No | No | Date | DATE | Date of measurement. |
100 | No | No | Time | DATE | Time of measurement. |
100 | No | No | Gate | VARCHAR2 | Gate position as determined from tilt sensors and flow data. |
100 | No | No | Direction | VARCHAR2 | Direction of flow relative to the structure, with IN indicating water is flowing upstream, OUT indicating water is flowing downstream, and SLACK indicating that water is not moving in any detectable direction. |
100 | No | No | Depth | NUMBER | Depth of water inside the structure in meters. |
100 | No | No | Velocity | NUMBER | Velocity inside of structure in meters/second, with negative values indicating water flowing OUT of the structure. |
100 | No | No | Flow | NUMBER | Estimated flow based on the water level inside the structure or channel, dimensions of the structure or channel, and measured velocity of water. |
100 | No | No | TideGage | VARCHAR2 | Nearest tide gage name. |
100 | No | No | RiverGage | VARCHAR2 | Nearest USGS river gage ID. |
100 | No | No | Tide_ft | NUMBER | Tide height in ft at nearest tide gage - not corrected for time lag between gage and site. |
100 | No | No | River_ft | NUMBER | River gage height in ft at nearest USGS gage - not corrected for time lag between gage and site. |
Attribute Details
Attribute Name | ID1 |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Record ID. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Site |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Site name (see Site Details table for more information). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | @ |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Date |
---|---|
Seq. Order | 3 |
Data Storage Type | DATE |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date of measurement. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | m/d/yyyy |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Time |
---|---|
Seq. Order | 4 |
Data Storage Type | DATE |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time of measurement. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | h:nn;@ |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Gate |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Gate position as determined from tilt sensors and flow data. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | @ |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Direction |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Direction of flow relative to the structure, with IN indicating water is flowing upstream, OUT indicating water is flowing downstream, and SLACK indicating that water is not moving in any detectable direction. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | @ |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Depth |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Depth of water inside the structure in meters. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | General Number |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Velocity |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Velocity inside of structure in meters/second, with negative values indicating water flowing OUT of the structure. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | General Number |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Flow |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Estimated flow based on the water level inside the structure or channel, dimensions of the structure or channel, and measured velocity of water. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | General Number |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TideGage |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Nearest tide gage name. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | @ |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RiverGage |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Nearest USGS river gage ID. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | @ |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Tide_ft |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tide height in ft at nearest tide gage - not corrected for time lag between gage and site. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | General Number |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | River_ft |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
River gage height in ft at nearest USGS gage - not corrected for time lag between gage and site. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | General Number |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 36219 |
---|---|
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 Workflow State | Published / External |
Metadata Last Review Date | 2018-02-27 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-02-27 |
Tags |
---|