Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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

CC ID: 733191
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

CC ID: 733192
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

CC ID: 733193
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

CC ID: 733194
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

CC ID: 733195
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

CC ID: 733196
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)

CC ID: 733197
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)

CC ID: 733198
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)

CC ID: 733199
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

CC ID: 733200
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

CC ID: 733201
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: 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