Physical and Biological Effects of Fish-friendly Tide Gates Site Details
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36584 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Physical and Biological Effects of Fish-friendly Tide Gates Site Details |
---|---|
Short Name: | Physical and Biological Effects of Fish-friendly Tide Gates Site Details |
Status: | Planned |
Abstract: |
Details of sites sampled. |
Entity Information
Entity Type: | Spreadsheet |
---|---|
Active Version?: | Yes |
Schema Name: | PARR |
Description: |
Details of sites sampled. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
System | VARCHAR2 | The system is the river or placename in which the site is located. | |
100
|
Site | VARCHAR2 | Site name used to link data in the data table to the site details table. | |
100
|
Type | VARCHAR2 | The type designates the type of the site, which includes reference channels with no structures, flap gates, side-hinged self regulating tidegates (SRT), and pet doors. | |
100
|
Culvert Type | VARCHAR2 | The cuvlert type designates whether a structure was a round culvert, square vault, or rectangular vault, or an open channel where no structures were present. | |
100
|
Northing | NUMBER | Northing coordinates for the location of the site. Units for values are NAD_1983_UTM_Zone_10N meters. | |
100
|
Easting | NUMBER | Easting coordinates for the location of the site. Units for values are NAD_1983_UTM_Zone_10N meters. | |
100
|
Diamter (m) | NUMBER | Diameter of culverts for circular culverts. Units for values are meters. | |
100
|
Width (m) | NUMBER | Width of rectancular and square vaults. Units for values are meters. | |
100
|
Height (m) | NUMBER | Height of rectancular and square vaults. Units for values are meters. | |
100
|
Downstream Perch Elevation (m) NAVD88 | NUMBER | Elevation of the floor of the culvert or vault on the upstream side of the structure. Units for values are NAVD88 meters. | |
100
|
Upstream Perch Elevation (m) NAVD88 | NUMBER | Elevation of the floor of the culvert or vault on the downstream side of the structure. Units for values are NAVD88 meters. |
Attribute Details
System
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The system is the river or placename in which the site is located. |
General Data Type: | VARCHAR2 |
Site
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Site name used to link data in the data table to the site details table. |
General Data Type: | VARCHAR2 |
Type
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The type designates the type of the site, which includes reference channels with no structures, flap gates, side-hinged self regulating tidegates (SRT), and pet doors. |
General Data Type: | VARCHAR2 |
Culvert Type
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The cuvlert type designates whether a structure was a round culvert, square vault, or rectangular vault, or an open channel where no structures were present. |
General Data Type: | VARCHAR2 |
Northing
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Northing coordinates for the location of the site. Units for values are NAD_1983_UTM_Zone_10N meters. |
General Data Type: | NUMBER |
Unit of Measure: | NAD_1983_UTM_Zone_10N meters |
Easting
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Easting coordinates for the location of the site. Units for values are NAD_1983_UTM_Zone_10N meters. |
General Data Type: | NUMBER |
Unit of Measure: | NAD_1983_UTM_Zone_10N meters |
Diamter (m)
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Diameter of culverts for circular culverts. Units for values are meters. |
General Data Type: | NUMBER |
Unit of Measure: | meters |
Width (m)
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Width of rectancular and square vaults. Units for values are meters. |
General Data Type: | NUMBER |
Unit of Measure: | meters |
Height (m)
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Height of rectancular and square vaults. Units for values are meters. |
General Data Type: | NUMBER |
Unit of Measure: | meters |
Downstream Perch Elevation (m) NAVD88
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Elevation of the floor of the culvert or vault on the upstream side of the structure. Units for values are NAVD88 meters. |
General Data Type: | NUMBER |
Unit of Measure: | NAVD88 meters |
Upstream Perch Elevation (m) NAVD88
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Elevation of the floor of the culvert or vault on the downstream side of the structure. Units for values are NAVD88 meters. |
General Data Type: | NUMBER |
Unit of Measure: | NAVD88 meters |
Catalog Details
Catalog Item ID: | 36584 |
---|---|
GUID: | gov.noaa.nmfs.inport:36584 |
Metadata Record Created By: | Jeffrey W Cowen |
Metadata Record Created: | 2017-01-31 18:05+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 |