Baselight

Inland Fisheries - Length/Weight [ds195]

State of California

@usgov.ca_gov_inland_fisheries_length_weight_ds195_b5636

Loading...
Loading...

About this Dataset

Inland Fisheries - Length/Weight [ds195]

This dataset is a subset of the Tuolumne Aquatic Resources Relational Inventory (TARRI) compiled by Brian Quelvog, California Department of Fish and Game. This includes fork lengths and weights for species such as rainbow and brown trout, centrachids such as bluegill and green sunfish, cyprinids such as roach and hitch, as well as other groups (e.g., mosquitofish and catfish). Over seventy-five sources of information were used in making the data set including aquatic surveys by several agencies, although most of the information is contained in file reports from the California Department of Fish and Game. The area of interest includes Tuolumne County and the six surrounding counties: Calaveras, Stanislaus, Merced, Mariposa, Mono, and Alpine. Collection dates range from 1979 to 2003. What each record represents Each record represents the collection, identification, weight, and fork length of each individual of a given species of fish along with the zone, water, site, UTM coordinates, date, and person or organization responsible for the survey.
Organization: State of California
Last updated: 2024-03-30T02:46:56.746231
Tags: abundance, authcdfw, california-department-of-fish-and-wildlife, california-natural-resources-agency, caopendata, cdfw, distribution, ds019520140925wm, fish, inventory, multi-species, planning, special-status-species

Tables

Table 1

@usgov.ca_gov_inland_fisheries_length_weight_ds195_b5636.table_1
  • 190.64 KB
  • 19445 rows
  • 23 columns
Loading...

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "photo" VARCHAR,
  "sname" VARCHAR,
  "cname" VARCHAR,
  "family" VARCHAR,
  "lwdate" TIMESTAMP,
  "length" BIGINT,
  "weight" DOUBLE,
  "temp" BIGINT,
  "ph" DOUBLE,
  "hardness" BIGINT,
  "conductiv" BIGINT,
  "flow" DOUBLE,
  "siteid" BIGINT,
  "site" VARCHAR,
  "elevation" BIGINT,
  "county" VARCHAR,
  "mapquad" VARCHAR,
  "utmzone" BIGINT,
  "utmeast27" BIGINT,
  "utmnorth27" BIGINT,
  "objectid" BIGINT
);

Share link

Anyone who has the link will be able to view this.