Physical and Biological Effects of Fish-friendly Tide Gates
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36585
| Published / External
Created: 2017-01-31
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 18066
ID: 36585
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Physical and Biological Effects of Fish-friendly Tide Gates |
---|---|
Short Name | Physical and Biological Effects of Fish-friendly Tide Gates |
* Status | Planned |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Summary of physical parameters and fish counts. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
Schema Name | PARR |
» Description |
Summary of physical parameters and fish counts. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | Site | VARCHAR2 | Site name used to link data in the data table to the site details table. |
100 | No | No | Visit | NUMBER | The sequential visit number to that site. |
100 | No | No | Date | DATE | The date of the visit to that site. |
100 | No | No | Location | VARCHAR2 | Location of sample, with DS indicating downstream of structures and US indicating upstream of structures. |
100 | No | No | PropDis | NUMBER | Proportion of time upstream and downstream habitat are disconnected to fish passage based on the position of tide gates (open = connected, closed = disconnected); whether or not the upstream inlet is perched above the upstream water elevation (not perched = connected, perched = disconnected); water velocity (< 0.4 m/s = connected, > 0.4 m/s = disconnected); tidal stage (flooding = connected, ebbing = disconnected), and water depth (>10 cm = connected, <10 cm = disconnected). |
100 | No | No | T.Ave | NUMBER | Average water temperature as measured during a two week period that includes the sampling date. Units for values are Celsius. |
100 | No | No | T.SD | NUMBER | Standard deviation of water temperature as measured during a two week period that includes the sampling date. Units for values are Celsius. |
100 | No | No | T.CV | NUMBER | Coefficient of variance of water temperature as measured during a two week period that includes the sampling date. |
100 | No | No | S.Ave | NUMBER | Average water salinity as measured during a two week period that includes the sampling date. Units for values are parts per thousand. |
100 | No | No | S.SD | NUMBER | Standard deviation of water salinity as measured during a two week period that includes the sampling date. Units for values are parts per thousand. |
100 | No | No | S.CV | NUMBER | Coefficient of variance of water salinity as measured during a two week period that includes the sampling date. |
100 | No | No | E.Ave | NUMBER | Average surface water elevation as measured during a two week period that includes the sampling date. Units for values are NAVD88 meters. |
100 | No | No | E.SD | NUMBER | Standard deviation of surface water elevation as measured during a two week period that includes the sampling date. Units for values are NAVD88 meters. |
100 | No | No | E.CV | NUMBER | Coefficient of variance of surface water elevation as measured during a two week period that includes the sampling date. |
100 | No | No | V.Ave | NUMBER | Average water velocity as measured during a two day period in June or July. Units for values are meters per second. |
100 | No | No | V.SD | NUMBER | Standard deviation of water velocity as measured during a two day period in June or July. Units for values are meters per second. |
100 | No | No | V.DS.CV | NUMBER | Coefficient of variance of water velocity as measured during a two day period in June or July. |
100 | No | No | Beach Seine Area m2 | NUMBER | Area of beach seine used to sample fish. This can be used to convert fish counts to density based on surface area. Units for values are square meters. |
100 | No | No | stickleback | NUMBER | Three-spine stickleback (Gasterosteus aculeatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | coho | NUMBER | Coho salmon (Oncorhynchus kisutch) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | chinook | NUMBER | Chinook salmon (O. tshawytscha) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | chum | NUMBER | Chum salmon (O. keta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | rainbow trout | NUMBER | Rainbow trout/steelhead (O. mykiss) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | cutthrout | NUMBER | Cutthrout trout (O. clarkia) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | peamouth | NUMBER | Peamouth chub (Mylocheilus caurinus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | staghorn sculpin | NUMBER | Staghorn sculpin (Leptocottus armatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | prickly sculpin | NUMBER | Prickly sculpin (Cottus asper) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | sucker | NUMBER | Largescale sucker (Catostomus macrocheilus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | whitefish | NUMBER | mountain whitefish(Prosopium williamsoni) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | smelt | NUMBER | Surf smelt (Hypomesus pretiosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | post-larval smelt | NUMBER | Surf smelt (Hypomesus pretiosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | starry flounder | NUMBER | Starry flounder (Platichthys stellatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | larval sandlance | NUMBER | Pacific sand lance (Ammodytes hexapterus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | sandlance | NUMBER | Pacific sand lance (Ammodytes hexapterus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | herring | NUMBER | Pacific herring (Clupea pallasii) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | shiner | NUMBER | Shiner perch (Cymatogaster aggregate) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | snake prickleback | NUMBER | Snake prickleback (Lumpenus sagitta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | crescent gunnel | NUMBER | Crescent gunnel (Pholis laeta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | unk gadid | NUMBER | Unknown gadoid (Gadidae spp.) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | cancer crab | NUMBER | Crab (Cancer spp.) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | shrimp | NUMBER | Shrimp counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | speckled dace | NUMBER | speckled dace(Rhinichthys osculus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | shad | NUMBER | American shad (Alosa sapidissima) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | smallmouth | NUMBER | Smallmouth bass (Micropterus dolmieui) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | bluegill | NUMBER | Bluegill (Lepomis gulosis) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | largemouth | NUMBER | largemouthbass(Micropterus salmoides) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | pumpkin | NUMBER | Pumpkinseed (Lepomis gibbosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | pickerel | NUMBER | Grass pickerel (Esox americanus vermiculatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | Y perch | NUMBER | Yellow perch (Perca flavescens) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | crayfish | NUMBER | Crayfish species counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | bullfrog tadpole | NUMBER | Bullfrog tadpole (Rana catesbeiana) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
100 | No | No | newt | NUMBER | Rough-skin newt (Taricha granulosa) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
Attribute Details
Attribute Name | Site |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Site name used to link data in the data table to the site details table. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Visit |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The sequential visit number to that site. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Date |
---|---|
Seq. Order | 3 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date of the visit to that site. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Location |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Location of sample, with DS indicating downstream of structures and US indicating upstream of structures. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PropDis |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Proportion of time upstream and downstream habitat are disconnected to fish passage based on the position of tide gates (open = connected, closed = disconnected); whether or not the upstream inlet is perched above the upstream water elevation (not perched = connected, perched = disconnected); water velocity (< 0.4 m/s = connected, > 0.4 m/s = disconnected); tidal stage (flooding = connected, ebbing = disconnected), and water depth (>10 cm = connected, <10 cm = disconnected). |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | T.Ave |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average water temperature as measured during a two week period that includes the sampling date. Units for values are Celsius. |
General Data Type | NUMBER |
Unit of Measure | Celsius |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | T.SD |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Standard deviation of water temperature as measured during a two week period that includes the sampling date. Units for values are Celsius. |
General Data Type | NUMBER |
Unit of Measure | Celsius |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | T.CV |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coefficient of variance of water temperature as measured during a two week period that includes the sampling date. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | S.Ave |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average water salinity as measured during a two week period that includes the sampling date. Units for values are parts per thousand. |
General Data Type | NUMBER |
Unit of Measure | parts per thousand |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | S.SD |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Standard deviation of water salinity as measured during a two week period that includes the sampling date. Units for values are parts per thousand. |
General Data Type | NUMBER |
Unit of Measure | parts per thousand |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | S.CV |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coefficient of variance of water salinity as measured during a two week period that includes the sampling date. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | E.Ave |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average surface water elevation as measured during a two week period that includes the sampling date. Units for values are NAVD88 meters. |
General Data Type | NUMBER |
Unit of Measure | NAVD88 meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | E.SD |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Standard deviation of surface water elevation as measured during a two week period that includes the sampling date. Units for values are NAVD88 meters. |
General Data Type | NUMBER |
Unit of Measure | NAVD88 meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | E.CV |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coefficient of variance of surface water elevation as measured during a two week period that includes the sampling date. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | V.Ave |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average water velocity as measured during a two day period in June or July. Units for values are meters per second. |
General Data Type | NUMBER |
Unit of Measure | meters per second |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | V.SD |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Standard deviation of water velocity as measured during a two day period in June or July. Units for values are meters per second. |
General Data Type | NUMBER |
Unit of Measure | meters per second |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | V.DS.CV |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coefficient of variance of water velocity as measured during a two day period in June or July. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Beach Seine Area m2 |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area of beach seine used to sample fish. This can be used to convert fish counts to density based on surface area. Units for values are square meters. |
General Data Type | NUMBER |
Unit of Measure | square meters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | stickleback |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Three-spine stickleback (Gasterosteus aculeatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | coho |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coho salmon (Oncorhynchus kisutch) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | chinook |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Chinook salmon (O. tshawytscha) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | chum |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Chum salmon (O. keta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | rainbow trout |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Rainbow trout/steelhead (O. mykiss) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | cutthrout |
---|---|
Seq. Order | 24 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cutthrout trout (O. clarkia) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | peamouth |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Peamouth chub (Mylocheilus caurinus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | staghorn sculpin |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Staghorn sculpin (Leptocottus armatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | prickly sculpin |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Prickly sculpin (Cottus asper) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sucker |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Largescale sucker (Catostomus macrocheilus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | whitefish |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
mountain whitefish(Prosopium williamsoni) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | smelt |
---|---|
Seq. Order | 30 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Surf smelt (Hypomesus pretiosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | post-larval smelt |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Surf smelt (Hypomesus pretiosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | starry flounder |
---|---|
Seq. Order | 32 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Starry flounder (Platichthys stellatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | larval sandlance |
---|---|
Seq. Order | 33 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Pacific sand lance (Ammodytes hexapterus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sandlance |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Pacific sand lance (Ammodytes hexapterus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | herring |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Pacific herring (Clupea pallasii) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | shiner |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Shiner perch (Cymatogaster aggregate) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | snake prickleback |
---|---|
Seq. Order | 37 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Snake prickleback (Lumpenus sagitta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crescent gunnel |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Crescent gunnel (Pholis laeta) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | unk gadid |
---|---|
Seq. Order | 39 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unknown gadoid (Gadidae spp.) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | cancer crab |
---|---|
Seq. Order | 40 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Crab (Cancer spp.) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | shrimp |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Shrimp counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | speckled dace |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
speckled dace(Rhinichthys osculus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | shad |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
American shad (Alosa sapidissima) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | smallmouth |
---|---|
Seq. Order | 44 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Smallmouth bass (Micropterus dolmieui) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | bluegill |
---|---|
Seq. Order | 45 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bluegill (Lepomis gulosis) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | largemouth |
---|---|
Seq. Order | 46 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
largemouthbass(Micropterus salmoides) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | pumpkin |
---|---|
Seq. Order | 47 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Pumpkinseed (Lepomis gibbosus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | pickerel |
---|---|
Seq. Order | 48 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Grass pickerel (Esox americanus vermiculatus) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Y perch |
---|---|
Seq. Order | 49 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Yellow perch (Perca flavescens) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crayfish |
---|---|
Seq. Order | 50 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Crayfish species counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | bullfrog tadpole |
---|---|
Seq. Order | 51 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Bullfrog tadpole (Rana catesbeiana) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | newt |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Rough-skin newt (Taricha granulosa) counts from beach seine, expanded from subsamples where applicable. Missing values indicate that the species was not present. Units for values are count. |
General Data Type | NUMBER |
Unit of Measure | count |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 36585 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-01-31 18:06+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 Workflow State | Published / External |
Metadata Last Review Date | 2018-02-27 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-02-27 |
Tags |
---|