Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FE (Fish Ecology) Division > Data logger database - Physical and biological... >

Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Site Details

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:36221  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Details of each site surveyed, including site names and place names, site type, and physical dimensions and charecteristics of the site.

Description

Details of each site surveyed, including site names and place names, site type, and physical dimensions and charecteristics of the site.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Record ID.
Region
VARCHAR2 		North (Puget Sound) or South (Columbia and Chehalis River).
System
VARCHAR2 		Primary river or locality with multiple sites.
Site
VARCHAR2 		Site name within each system where multiple site types occur.
Type
VARCHAR2 		Type of structure (SRT or Flap Gated Culvert) or channel (reference tidal channel with no structures) at site.
Culvert Type
VARCHAR2 		Design of culvert.
Diamter (m)
NUMBER 		Diamter of circular culverts.
Width (m)
NUMBER 		Width of rectangular and square vaults.
Height (m)
NUMBER 		Height of rectangular and square vaults.
Downstream Perch Elevation (m) NAVD88
NUMBER 		Elevation of the interior floor of the strucrue on the downstream side in NAVD88.
Upstream Perch Elevation (m) NAVD88
NUMBER 		Elevation of the interior floor of the strucrue on the upstream side in NAVD88.

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 Site Details
Short Name: Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Site Details
Status: Planned
Abstract:

Details of each site surveyed, including site names and place names, site type, and physical dimensions and charecteristics of the site.

Entity Information

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

Details of each site surveyed, including site names and place names, site type, and physical dimensions and charecteristics of the site.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ID NUMBER Record ID.
100
 Region VARCHAR2 North (Puget Sound) or South (Columbia and Chehalis River).
100
 System VARCHAR2 Primary river or locality with multiple sites.
100
 Site VARCHAR2 Site name within each system where multiple site types occur.
100
 Type VARCHAR2 Type of structure (SRT or Flap Gated Culvert) or channel (reference tidal channel with no structures) at site.
100
 Culvert Type VARCHAR2 Design of culvert.
100
 Diamter (m) NUMBER Diamter of circular culverts.
100
 Width (m) NUMBER Width of rectangular and square vaults.
100
 Height (m) NUMBER Height of rectangular and square vaults.
100
 Downstream Perch Elevation (m) NAVD88 NUMBER Elevation of the interior floor of the strucrue on the downstream side in NAVD88.
100
 Upstream Perch Elevation (m) NAVD88 NUMBER Elevation of the interior floor of the strucrue on the upstream side in NAVD88.

Attribute Details

ID

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

Record ID.
General Data Type: NUMBER

Region

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

North (Puget Sound) or South (Columbia and Chehalis River).
General Data Type: VARCHAR2
Format Mask: @

System

CC ID: 733182
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Primary river or locality with multiple sites.
General Data Type: VARCHAR2
Format Mask: @

Site

CC ID: 733183
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Site name within each system where multiple site types occur.
General Data Type: VARCHAR2
Format Mask: @

Type

CC ID: 733184
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Type of structure (SRT or Flap Gated Culvert) or channel (reference tidal channel with no structures) at site.
General Data Type: VARCHAR2
Format Mask: @

Culvert Type

CC ID: 733185
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Design of culvert.
General Data Type: VARCHAR2
Format Mask: @

Diamter (m)

CC ID: 733186
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Diamter of circular culverts.
General Data Type: NUMBER
Format Mask: Fixed

Width (m)

CC ID: 733187
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Width of rectangular and square vaults.
General Data Type: NUMBER
Format Mask: Fixed

Height (m)

CC ID: 733188
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Height of rectangular and square vaults.
General Data Type: NUMBER
Format Mask: Fixed

Downstream Perch Elevation (m) NAVD88

CC ID: 733189
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Elevation of the interior floor of the strucrue on the downstream side in NAVD88.
General Data Type: NUMBER
Format Mask: General Number

Upstream Perch Elevation (m) NAVD88

CC ID: 733190
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Elevation of the interior floor of the strucrue on the upstream side in NAVD88.
General Data Type: NUMBER
Format Mask: General Number

Catalog Details

Catalog Item ID: 36221
GUID: gov.noaa.nmfs.inport:36221
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