Slide Menu
Search Help Show/Hide Menu

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: 2019-06-04 13:14+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-02-28