36584 Physical and Biological Effects of Fish-friendly Tide Gates Site Details Entity Published / External 18066 Fish and logger summaries - Physical and biological effects of fish-friendly tide gates Data Set Planned Details of sites sampled. Spreadsheet Yes PARR Details of sites sampled. 1 System VARCHAR2 No No Active The system is the river or placename in which the site is located. VARCHAR2 2 Site VARCHAR2 No No Active Site name used to link data in the data table to the site details table. VARCHAR2 3 Type VARCHAR2 No No Active 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. VARCHAR2 4 Culvert Type VARCHAR2 No No Active 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. VARCHAR2 5 Northing NUMBER No No Active Northing coordinates for the location of the site. Units for values are NAD_1983_UTM_Zone_10N meters. NUMBER NAD_1983_UTM_Zone_10N meters 6 Easting NUMBER No No Active Easting coordinates for the location of the site. Units for values are NAD_1983_UTM_Zone_10N meters. NUMBER NAD_1983_UTM_Zone_10N meters 7 Diamter (m) NUMBER No No Active Diameter of culverts for circular culverts. Units for values are meters. NUMBER meters 8 Width (m) NUMBER No No Active Width of rectancular and square vaults. Units for values are meters. NUMBER meters 9 Height (m) NUMBER No No Active Height of rectancular and square vaults. Units for values are meters. NUMBER meters 10 Downstream Perch Elevation (m) NAVD88 NUMBER No No Active Elevation of the floor of the culvert or vault on the upstream side of the structure. Units for values are NAVD88 meters. NUMBER NAVD88 meters 11 Upstream Perch Elevation (m) NAVD88 NUMBER No No Active Elevation of the floor of the culvert or vault on the downstream side of the structure. Units for values are NAVD88 meters. NUMBER NAVD88 meters gov.noaa.nmfs.inport:36584 Jeffrey Cowen 2017-01-31T18:05:59 SysAdmin InPortAdmin 2022-08-09T17:11:17 2018-02-27 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No 2018-02-27 1 Year 2019-02-27