About this Dataset

Fish Restoration Program Monitoring - San Joaquin Delta [ds2802]

Fish catch, invertebrate catch, and water quality data from the Sacramento-San Joaquin Delta collected by the Fish Restoration Monitoring Program, 2015-2017. The Fish Restoration Program Monitoring Team is tasked with monitoring fish and food web resources in restored tidal wetland sites. These restored sites are located in the Sacramento-San Joaquin Delta and Suisun Marsh pursuant to requirements in the 2008/2009 Biological Opinions for state and federal water project operations. Data on fish and invertebrate abundance on or near these sites was collected as baseline monitoring data and to determine the most efficient methods for monitoring wetlands.
Organization: State of California
Last updated: 2024-03-30T02:12:50.457197
Tags: aquatic-ecosystems, authcdfw, california-department-of-fish-and-wildlife, california-natural-resources-agency, caopendata, cdfw, conductance, dissolved-oxygen, ds280220181004wm, ecology, estuary, fishes, grizzly-bay, iep, interagency-ecological-program-for-the-san-francisco-bay-delta-estuary, invertebrates, monitoring, sacramento-river, sacramento-san-joaquin-delta, san-francisco-estuary, suisun-bay, temperature, turbidity, water-quality, wetlands

Tables

Table 1

@usgov.ca_gov_fish_restoration_program_monitoring_san_joaquin_7c282aaf.table_1

312.04 KB
13937 rows
35 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "commonname" VARCHAR,
  "scientificname" VARCHAR,
  "sampletype" VARCHAR,
  "type" VARCHAR,
  "temp" DOUBLE,
  "sc" DOUBLE,
  "ph" DOUBLE,
  "do" DOUBLE,
  "secchi" DOUBLE,
  "turbidity" DOUBLE,
  "tide" VARCHAR,
  "microcystis" VARCHAR,
  "volume" DOUBLE,
  "length" VARCHAR,
  "count" DOUBLE,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "lifestage" VARCHAR,
  "zsampleid" VARCHAR,
  "subsample" DOUBLE,
  "adjcount" DOUBLE,
  "cpue" DOUBLE,
  "vegweight" VARCHAR,
  "sampleid" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);