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
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
|
|
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 |