| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
Column Name: | Year
| qry_AMC_EDI_01.Survey.Survey
| SampleDate
| TowTime
| qry_AMC_EDI_01.Station.Station
| Latitude
| Longitude
| Duration
| TowNum
| GearCode
| Volume
| Tide
| BottomDepth
| Temp
| TopEC
| BottomEC
| Secchi
| Turbidity
| Comments
| American Shad
| Arrow Goby
| Bay Goby
| Bay Pipefish
| Bigscale Logperch
| Black Bullhead
| Black Crappie
| Bluegill Sunfish
| Brown Bullhead
| Brown Rockfish
| California Tonguefish
| Carp
| Catfish (Unid)
| Centrarchids (Unid)
| Chameleon Goby
| Channel Catfish
| Cheekspot Goby
| Chinook Salmon
| Cyprinids (Unid)
| Delta Smelt
| English Sole
| Gobies (Unid)
| Golden Shiner
| Goldfish
| Hitch
| Inland Silverside
| Jacksmelt
| Lampreys (Unid)
| Largemouth Bass
| Longfin Smelt
| Longjaw Mudsucker
| Mosquitofish
| Northern Anchovy
| Pacific Herring
| Pacific Lamprey
| Pacific Staghorn Sculpin
| Plainfin Midshipman
| Prickly Sculpin
| Rainwater Killifish
| Redear Sunfish
| River Lamprey
| Sacramento Blackfish
| Sacramento Pikeminnow
| Sacramento Sucker
| Sculpins (Unid)
| Shimofuri Goby
| Shiner Perch
| Shokihaze Goby
| Silversides (Unid)
| Smallmouth Bass
| Smelt (Unid)
| Speckled Sanddab
| Splittail
| Spotted Bass
| Starry Flounder
| Striped Bass
| Sturgeon (Unid)
| Threadfin Shad
| Threespine Stickleback
| Topsmelt
| Tridentiger spp_
| Tule Perch
| Unknown
| Wakasagi
| White Catfish
| White Crappie
| White Croaker
| White Sturgeon
| Yellowfin Goby
|
Definition: | Year when sampling occurred | A sequential number indicating the completion of all or most stations in the study area on a bi-weekly basis | Date when sampling occurred | Time of day when sampling started | Project station number | Station latitude in WGS 1984 Coordinate in degree minute second | Station longitude WGS 1984 Coordinate in degree minute second | Time of an individual tow | Number of the tow, first second or third | GearCode | Volume of water sampled | Tide | Water depth at station | Surface water temperature of a station | Surface electro-conductivity | Bottom electro-conductivity | Water transparency | Surface water turbidity | Comments | Catch of American Shard (Alosa sapidissima) | Catch of Arrow Goby (Clevelandia ios) | Catch of Bay Goby (Lepidogobius lepidus) | Catch of Bay Pipefish (Syngnathus leptorhynchus) | Catch of Bigscale Logperch (Percina macrolepida) | Catch of Black Bullhead (Ictalurus melas) | Catch of Black Crappie (Pomoxis nigromaxulatus) | Catch of Bluegill Sunfish (Lepomis macrochirus) | Catch of Brown Bullhead (Ictalurus nebulosus) | Catch of Brown Rockfish (Sebastes auriculatus) | Catch of California Tonguefish (Symphurus atricaudus) | Catch of Carp (Cyprinus carpio) | Catch of iunidentified catfish | Catch of unidentifiable fish in the family Centrarchidae | Catch of Chameleon Gody (Tridentiger trigonocephalus) | Catch of Channel Catfish (Ictalurus punctatus) | Catch of Cheekspot Goby (Ilypnus gilberti) | Catch of Chinook Salmon (Oncorhynchus tshawytscha) | Catch of unidentifiable fish in the family Cyprinidae | Catch of Delta Smelt (Hypomesus transpacificus) | Catch of English Cole (Parophrys vetulus) | Catch of unidentified gobies | Catch of Golden Shiner (Notemigonus crysoleucas) | Catch of Goldfish (Carassius auratus) | Catch of Hitch (Lavinia exilicauda) | Catch of Inland Silverside (Menidia beryllina) | Catch of Jacksmelt (Atherinopsis californiensis) | Catch of unidentifiable Lamprey | Catch of Largemouth Bass (Micropterus salmoides) | Catch of Longfin Smelt (Spirinchus thaleichthys) | Catch of Longjaw Mudsucker (Gillichthys mirabilis) | Catch of Mosquitofish (Gambusia affinis) | Catch of Northern Anchovy (Engraulis mordax) | Catch of Pacific Herring (Clupea pallasii) | Catch of Pacific Lamprey (Lampetra tridentata) | Catch of Pacific Staghorn Sculpin (Leptocottus armatus) | Catch of Plainfin Midshipman (Porichthys notatus) | Catch of Prickly Sculpin (Cottus asper) | Catch of Rainwater Killifish (Lucania parva) | Catch of Redear Sunfish (Lepomis microlophus) | Catch of River Lamprey (Lampetra ayresi) | Catch of Sacramento Blackfish (Orthodon microlepidotus) | Catch of Sacramento Pikeminnow (Ptychocheilus grandis) | Catch of Sacramento Sucker (Catostomus occidentalis) | Catch of unidentified Sculpin | Catch of Shimofuri Goby (Tridentiger bifasciatus) | Catch of Shiner Surfperch (Cymatogaster aggregata) | Catch of Shokihaze Goby (Tridentiger barbatus) | Catch of unidentifiable fish in the family Osmeridae | Catch of Smallmouth Bass (Micropterus dolomieui) | Catch of unidentified Smelt | Catch of Speckled Sanddab (Citharichthys stigmaeus) | Catch of Splittail (Pogonichthys macrolepidotus) | Catch of Spotted Bass (Micropterus punctulatus) | Catch of Starry Flounder (Platichthys stellatus) | Catch of Striped Bass (Morone saxatilis) | Catch of unidentified Sturgeon | Catch of Threadfin Shad (Dorosoma petenense) | Catch of Threespine Stickleback (Gasterosteus aculeatus) | Catch of Topsmelt (Atherinops affinis) | Catch of unidentifiable fish of the genus Tridentiger | Catch of Tule Perch (Hysterocarpus traski) | Catch of unidentifiable fish of unknown classification | Catch of Wakasagi (Hypomesus nipponensis) | Catch of White Catfish (Ameiurus catus) | Catch of White Crappie (Pomoxis annularis) | Catch of White Croaker (Genyonemus lineatus) | Catch of White Sturgeon (Acipenser transmontanus) | Catch of Yellowfin Goby (Acanthogobius flavimanus) |
Storage Type: | float
| string
| date
| date
| string
| string
| string
| float
| string
| string
| float
| string
| float
| float
| float
| float
| float
| float
| string
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
| float
|
Measurement Type: | ratio | nominal | dateTime | dateTime | nominal | nominal | nominal | ratio | nominal | nominal | ratio | nominal | ratio | ratio | ratio | ratio | ratio | ratio | nominal | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio | ratio |
Measurement Values Domain: | Unit | nominalYear | Type | natural | Min | 1995 | Max | 2021 |
| Definition | A sequential number indicating the completion of all or most stations in the study area on a bi-weekly basis |
| Format | YYYY-MM-DD | Precision | |
| | Definition | Project station number |
| Definition | Station latitude in WGS 1984 Coordinate in degree minute second |
| Definition | Station longitude WGS 1984 Coordinate in degree minute second |
| Unit | minute | Type | real | Min | 1 | Max | 13 |
| Definition | Number of the tow, first second or third |
| | Unit | cubicMeter | Type | real | Min | 62.53111526 | Max | 1552.159435 |
| | Unit | foot | Type | natural | Min | 2 | Max | 71 |
| Unit | celsius | Type | real | Min | 9.3 | Max | 28.1 |
| Unit | microSiemensPerCentimeter | Type | natural | Min | 5 | Max | 44280 |
| Unit | microSiemensPerCentimeter | Type | natural | Min | 5 | Max | 44310 |
| Unit | centimeter | Type | natural | Min | 5 | Max | 210 |
| Unit | nephelometricTurbidityUnits | Type | real | Min | 1 | Max | 607.7 |
| | Unit | number | Type | natural | Min | 1 | Max | 172 |
| Unit | number | Type | natural | Min | 1 | Max | 152 |
| Unit | number | Type | natural | Min | 1 | Max | 1130 |
| Unit | number | Type | natural | Min | 1 | Max | 4 |
| Unit | number | Type | natural | Min | 1 | Max | 18 |
| Unit | number | Type | natural | Min | 1 | Max | 2 |
| Unit | number | Type | natural | Min | 1 | Max | 3 |
| Unit | number | Type | natural | Min | 1 | Max | 4 |
| Unit | number | Type | natural | Min | 1 | Max | 2 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 49 |
| Unit | number | Type | natural | Min | 1 | Max | 72 |
| Unit | number | Type | natural | Min | 1 | Max | 26 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 543 |
| Unit | number | Type | natural | Min | 1 | Max | 90 |
| Unit | number | Type | natural | Min | 1 | Max | 6 |
| Unit | number | Type | natural | Min | 1 | Max | 13 |
| Unit | number | Type | natural | Min | 1 | Max | 788 |
| Unit | number | Type | natural | Min | 1 | Max | 9 |
| Unit | number | Type | natural | Min | 1 | Max | 4 |
| Unit | number | Type | natural | Min | 1 | Max | 6 |
| Unit | number | Type | natural | Min | 1 | Max | 7 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 809 |
| Unit | number | Type | natural | Min | 1 | Max | 71 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 4 |
| Unit | number | Type | natural | Min | 1 | Max | 7240 |
| Unit | number | Type | natural | Min | 1 | Max | 30 |
| Unit | number | Type | natural | Min | 1 | Max | 2 |
| Unit | number | Type | natural | Min | 1 | Max | 472 |
| Unit | number | Type | natural | Min | 1 | Max | 4261 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 12 |
| Unit | number | Type | natural | Min | 1 | Max | 17 |
| Unit | number | Type | natural | Min | 1 | Max | 613 |
| Unit | number | Type | natural | Min | 1 | Max | 93 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 15 |
| Unit | number | Type | natural | Min | 1 | Max | 5 |
| Unit | number | Type | natural | Min | 1 | Max | 1496 |
| Unit | number | Type | natural | Min | 1 | Max | 2 |
| Unit | number | Type | natural | Min | 1 | Max | 100 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 58 |
| Unit | number | Type | natural | Min | 1 | Max | 15 |
| Unit | number | Type | natural | Min | 1 | Max | 159 |
| Unit | number | Type | natural | Min | 1 | Max | 1 |
| Unit | number | Type | natural | Min | 1 | Max | 22 |
| Unit | number | Type | natural | Min | 1 | Max | 1360 |
| Unit | number | Type | natural | Min | 1 | Max | 4 |
| Unit | number | Type | natural | Min | 1 | Max | 15209 |
| Unit | number | Type | natural | Min | 1 | Max | 174 |
| Unit | number | Type | natural | Min | 1 | Max | 227 |
| Unit | number | Type | natural | Min | 1 | Max | 12511 |
| Unit | number | Type | natural | Min | 1 | Max | 3 |
| Unit | number | Type | natural | Min | 1 | Max | 15 |
| Unit | number | Type | natural | Min | 1 | Max | 15 |
| Unit | number | Type | natural | Min | 1 | Max | 876 |
| Unit | number | Type | natural | Min | 1 | Max | 3 |
| Unit | number | Type | natural | Min | 1 | Max | 15 |
| Unit | number | Type | natural | Min | 1 | Max | 28 |
| Unit | number | Type | natural | Min | 1 | Max | 2165 |
|
Missing Value Code: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Accuracy Report: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Accuracy Assessment: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Coverage: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Methods: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |