Data Package Metadata View Summary

Fish Facilities Salvage Data from 1993-2021

General Information

Data Package:

Local Identifier:

edi.1290.6

Title:

Fish Facilities Salvage Data from 1993-2021

Alternate Identifier:

DOI PLACE HOLDER

Abstract:

The Bureau of Reclamation’s (Reclamation) Central Valley Project (CVP) delivers up to over three million acre-feet of water annually for agricultural, municipal, industrial, and environmental needs in California from the Sacramento-San Joaquin River Delta (Delta) through the C.W. “Bill” Jones Pumping Plant (JPP; Figure 1). A Reclamation operated fish salvage facility, the Tracy Fish Collection Facility (TFCF), is located upstream of the JPP and functions to salvage fish entrained in exported water (Bates and Vinsonhaler 1957). Additionally, the John E. Skinner Delta Fish Protective Facility (SDFPF) added by the department of water resources in 1968 to salvage fishes diverted by the State water Project (SWP). Salvage process involves fish collection, counting, handling and transportation back to Delta. To prevent fish loss, a fish facility was constructed at Old river, where fish were diverted to the fish facility for counting and reporting. Currently, after counting, the fish are collected in storage tanks and taken to several release locations in the Delta via fish-haul tank trucks. Around 19,024,323 fishes from 31 species were salvaged through this process from 1993-2021 by the two fish facilities. The top five species salvaged by both the facilities in 2021 were Threadfin Shad (31%), Bluegill (25%), Largemouth Bass (6%), Inland Silverside (6%), and Striped Bass (5%). Fishes listed (ESA or CESA) or fish species salvaged under special study salvaged from 1993-2021 were Chinook Salmon [1,122,436 (76%)], Delta Smelt [201,408 (14%)], steelhead trout [110,720 (7%)], Longfin Smelt [41,173 (3%)], and Green Sturgeon [654 (0.04%)] respectively (Fig.2). There are 5 comma-separated values (csv) files with all variables required for salvage calculations and each individual file for total salvage by month, year, and species from 1993-2021.

Publication Date:

2023-08-24

For more information:
Visit:	DOI PLACE HOLDER

Time Period

Begin:

1993

End:

2021

People and Organizations
Contact:	Siddiqui, Samreen (California department of Fish and Wildlife, Environmental Scientist) [ email ]
Creator:	Siddiqui, Samreen (California department of Fish and Wildlife, Environmental Scientist)
Creator:	Assen, Geir (California department of Fish and Wildlife, Environmental Scientist)
Creator:	Afentoulis, Virginia (California department of Fish and Wildlife, Sr Env Scientist (Specialist))
Creator:	Griffiths, Walter (California department of Fish and Wildlife, Environmental Scientist)
Creator:	Damon, Lauren (California department of Fish and Wildlife, Native Fish and Fish Facilities Supervisor)
Associate:	Rene(Bureau of Reclamation, Supervisory Fish Biologist/Biological Resources Section, Tracy Fish Collection Facility daily salvage data management)
Associate:	Keopadubsy, Tim (California department of Fish and Wildlife, Key Data Operator, Key Data Operator)

Data Entities
Data Table Name:	Annual_Salvage_Combined_1993_2021
Description:	Annual Salvage data from 1993-2021
Data Table Name:	MonthlySalvage_Combined_1993_2021
Description:	Salvage data from 1993-2021 by month
Data Table Name:	SpeciesSalvage_Combined_1993_2021
Description:	Salvage data by species
Data Table Name:	Salvage_Combined_1993_2000
Description:	Daily Salvage from 1993-2000
Data Table Name:	Salvage_Combined_2001_2005
Description:	Daily Salvage from 2001-2005
Data Table Name:	Salvage_Combined_2006_2010
Description:	Daily Salvage from 2006-2010
Data Table Name:	Salvage_Combined_2011_2015
Description:	Daily Salvage from 2011-2015
Data Table Name:	Salvage_Combined_2016_2021
Description:	Daily Salvage from 2016-2021
Data Table Name:	Salvage_with_all_Variables_2022
Description:	Annual Salvage for year 2022
Data Table Name:	Salvage_by_Month_2022
Description:	Salvage data for year 2022 by Month

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/41fbb3ea601dc9c1efd8d26f06094fb1
Name:	Annual_Salvage_Combined_1993_2021
Description:	Annual Salvage data from 1993-2021
Number of Records:	29
Number of Columns:	2

Table Structure

Object Name:

Annual_Salvage_Combined_1993_2021.csv

Size:

486 byte

Authentication:

4328e36aae762e3662ac1b9364c13db7 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

year

Annualsalvage

Column Name:

year

Annualsalvage

Definition:

Sample collection Year

Calculated Salvage for that year

Storage Type:

float

Measurement Type:

ratio

Measurement Values Domain:

Unit	nominalYear
Type	integer

Unit	nominalYear
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/8a169f5db12b5b0b848a486e9ba2a49c
Name:	MonthlySalvage_Combined_1993_2021
Description:	Salvage data from 1993-2021 by month
Number of Records:	332
Number of Columns:	3

Table Structure

Object Name:

MonthlySalvage_Combined_1993_2021.csv

Size:

5182 byte

Authentication:

7d790c18359b7962ed1751ed094281e6 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

year

month

MonthlySalvage

Column Name:

year

month

MonthlySalvage

Definition:

Sample collection Year

Sample collection month for each year

Calculated Salvage for a particular month

Storage Type:

float

Measurement Type:

ratio

Measurement Values Domain:

Unit	nominalYear
Type	integer

Unit	number
Type	integer

Unit	none
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/59a2e97d474081c26d917c5b885cd446
Name:	SpeciesSalvage_Combined_1993_2021
Description:	Salvage data by species
Number of Records:	1209
Number of Columns:	2

Table Structure

Object Name:

SpeciesSalvage_Combined_1993_2021.csv

Size:

10995 byte

Authentication:

c315eb0117b8f499108c0d43a68fa845 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

OrganismCode

Salvage

Column Name:

OrganismCode

Salvage

Definition:

Organism Code

Calculated Salvage

Storage Type:

float

Measurement Type:

ratio

Measurement Values Domain:

Unit	None
Type	integer

Unit	none
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/7cdda91f850a263c2951c5ec83ee4bd6
Name:	Salvage_Combined_1993_2000
Description:	Daily Salvage from 1993-2000
Number of Records:	506828
Number of Columns:	22

Table Structure

Object Name:

Salvage_Combined_1993_2000_V1.csv

Size:

54561739 byte

Authentication:

47a46ac286fb35e9bccbb63ae81ef3c8 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

FacilityCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Column Name:

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

FacilityCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Definition:

Date of Sample

Unique code to identify row

Minutes the pumping plant exported water

Minutes of count

Primary Channel depth (feet)

Primary Channel flow (cfs)

Unique code to identify row from Sample table in Access database

Unique code to identify row from Building table in Access databse

Species code from Organismlookup Table in Access and organism list excel file in this publication

Number of fish per count from catch table in Access database

Common name of fish from catch table in Access database

NS for new building and OS is for old building at Skinner Fish Facility; F is federal building referring to Tracy Fish Facility

1 is for Tracy Fish facility and 2 is for Skinner fish facility

Unique code to identify row

Lengths for each species at each count time

Length frequency for each length at each count time

21 feet for both *SWP and *CVP

43 feet for both *SWP and *CVP

21 feet for both SWP only (CVP only has 4 bays)

Calculated number of fish captured by the fish facility at a particular time (expanded by pumping minutes and length count).

Storage Type:

dateTime

string

float

string

float

string

float

Measurement Type:

dateTime

nominal

ratio

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	Regular Salvage
Source

Code Definition

Code	9999
Definition	Predator removal
Source

Unit	minutes
Type	real

Unit	minutes
Type	real

Unit	foot
Type	real

Unit	footPerSecond
Type	real

Unit	none
Type	integer

Unit	None
Type	integer

Unit	None
Type	integer

Unit	None
Type	real

Definition

text

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	F
Definition	F is federal building referring to Tracy Fish Facility
Source

Code Definition

Code	NS
Definition	NS for new building at Skinner Fish Facility
Source

Code Definition

Code	OS
Definition	OS is for old building at Skinner Fish Facility
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	1 is for Tracy Fish facility
Source

Code Definition

Code	2
Definition	2 is for Skinner fish facility
Source

Unit	none
Type	real

Unit	millimeter
Type	integer

Unit	none
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Unit	none
Type	real

Missing Value Code:

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/b8f6df5d10b2feb7cca01aff143ea8f4
Name:	Salvage_Combined_2001_2005
Description:	Daily Salvage from 2001-2005
Number of Records:	326104
Number of Columns:	21

Table Structure

Object Name:

Salvage_Combined_2001_2005.csv

Size:

34414629 byte

Authentication:

9bce423bdaa25d1b58cba03d0d91cc65 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Column Name:

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Definition:

Date of Sample

Unique code to identify row

Minutes the pumping plant exported water

Minutes of count

Primary Channel depth (feet)

Primary Channel flow (cfs)

Unique code to identify row from Sample table in Access database

Unique code to identify row from Building table in Access databse

Species code from Organismlookup Table in Access and organism list excel file in this publication

Number of fish per count from catch table in Access database

Common name of fish from catch table in Access database

NS for new building and OS is for old building at Skinner Fish Facility; F is federal building referring to Tracy Fish Facility

Unique code to identify row

Lengths for each species at each count time

Length frequency for each length at each count time

21 feet for both *SWP and *CVP

43 feet for both *SWP and *CVP

21 feet for both SWP only (CVP only has 4 bays)

Calculated number of fish captured by the fish facility at a particular time (expanded by pumping minutes and length count).

Storage Type:

dateTime

string

float

string

float

string

float

Measurement Type:

dateTime

nominal

ratio

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	Regular Salvage
Source

Code Definition

Code	9999
Definition	Predator removal
Source

Unit	minutes
Type	real

Unit	minutes
Type	real

Unit	foot
Type	real

Unit	footPerSecond
Type	real

Unit	none
Type	integer

Unit	None
Type	integer

Unit	None
Type	integer

Unit	None
Type	real

Definition

text

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	F
Definition	F is federal building referring to Tracy Fish Facility
Source

Code Definition

Code	NS
Definition	NS for new building at Skinner Fish Facility
Source

Code Definition

Code	OS
Definition	OS is for old building at Skinner Fish Facility
Source

Unit	none
Type	real

Unit	millimeter
Type	integer

Unit	none
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Unit	none
Type	real

Missing Value Code:

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/2b69c9a5839388f4ffa0389fca291db9
Name:	Salvage_Combined_2006_2010
Description:	Daily Salvage from 2006-2010
Number of Records:	264580
Number of Columns:	22

Table Structure

Object Name:

Salvage_Combined_2006_2010.csv

Size:

28332433 byte

Authentication:

a2886bf61a600b0dab29c225033242f7 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

FacilityCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Column Name:

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

FacilityCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Definition:

Date of Sample

Unique code to identify row

Minutes the pumping plant exported water

Minutes of count

Primary Channel depth (feet)

Primary Channel flow (cfs)

Unique code to identify row from Sample table in Access database

Unique code to identify row from Building table in Access databse

Species code from Organismlookup Table in Access and organism list excel file in this publication

Number of fish per count from catch table in Access database

Common name of fish from catch table in Access database

NS for new building and OS is for old building at Skinner Fish Facility; F is federal building referring to Tracy Fish Facility

1 is for Tracy Fish facility and 2 is for Skinner fish facility

Unique code to identify row

Lengths for each species at each count time

Length frequency for each length at each count time

21 feet for both *SWP and *CVP

43 feet for both *SWP and *CVP

21 feet for both SWP only (CVP only has 4 bays)

Calculated number of fish captured by the fish facility at a particular time (expanded by pumping minutes and length count).

Storage Type:

dateTime

string

float

string

float

string

float

Measurement Type:

dateTime

nominal

ratio

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	Regular Salvage
Source

Code Definition

Code	9999
Definition	Predator removal
Source

Unit	minutes
Type	real

Unit	minutes
Type	real

Unit	foot
Type	real

Unit	footPerSecond
Type	real

Unit	none
Type	integer

Unit	None
Type	integer

Unit	None
Type	integer

Unit	None
Type	real

Definition

text

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	F
Definition	F is federal building referring to Tracy Fish Facility
Source

Code Definition

Code	NS
Definition	NS for new building at Skinner Fish Facility
Source

Code Definition

Code	OS
Definition	OS is for old building at Skinner Fish Facility
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	1 is for Tracy Fish facility
Source

Code Definition

Code	2
Definition	2 is for Skinner fish facility
Source

Unit	none
Type	real

Unit	millimeter
Type	integer

Unit	none
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Unit	none
Type	real

Missing Value Code:

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/0854feedae21e01de8a066ac53b4d7a7
Name:	Salvage_Combined_2011_2015
Description:	Daily Salvage from 2011-2015
Number of Records:	184789
Number of Columns:	22

Table Structure

Object Name:

Salvage_Combined_2011_2015.csv

Size:

19979568 byte

Authentication:

ea550d6e0e2afa9277033b7ab666daff Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

FacilityCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Column Name:

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

FacilityCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Definition:

Date of Sample

Unique code to identify row

Minutes the pumping plant exported water

Minutes of count

Primary Channel depth (feet)

Primary Channel flow (cfs)

Unique code to identify row from Sample table in Access database

Unique code to identify row from Building table in Access databse

Species code from Organismlookup Table in Access and organism list excel file in this publication

Number of fish per count from catch table in Access database

Common name of fish from catch table in Access database

NS for new building and OS is for old building at Skinner Fish Facility; F is federal building referring to Tracy Fish Facility

1 is for Tracy Fish facility and 2 is for Skinner fish facility

Unique code to identify row

Lengths for each species at each count time

Length frequency for each length at each count time

21 feet for both *SWP and *CVP

43 feet for both *SWP and *CVP

21 feet for both SWP only (CVP only has 4 bays)

Calculated number of fish captured by the fish facility at a particular time (expanded by pumping minutes and length count).

Storage Type:

dateTime

string

float

string

float

string

float

Measurement Type:

dateTime

nominal

ratio

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	Regular Salvage
Source

Code Definition

Code	9999
Definition	Predator removal
Source

Unit	minutes
Type	real

Unit	minutes
Type	real

Unit	foot
Type	real

Unit	footPerSecond
Type	real

Unit	none
Type	integer

Unit	None
Type	integer

Unit	None
Type	integer

Unit	None
Type	real

Definition

text

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	F
Definition	F is federal building referring to Tracy Fish Facility
Source

Code Definition

Code	NS
Definition	NS for new building at Skinner Fish Facility
Source

Code Definition

Code	OS
Definition	OS is for old building at Skinner Fish Facility
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	1 is for Tracy Fish facility
Source

Code Definition

Code	2
Definition	2 is for Skinner fish facility
Source

Unit	none
Type	real

Unit	millimeter
Type	integer

Unit	none
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Unit	none
Type	real

Missing Value Code:

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/218aab8614d887c71cfc3d35402e6c16
Name:	Salvage_Combined_2016_2021
Description:	Daily Salvage from 2016-2021
Number of Records:	267245
Number of Columns:	22

Table Structure

Object Name:

Salvage_Combined_2016_2021.csv

Size:

29152566 byte

Authentication:

f74857f9142eebeb1e6476474c79314c Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

FacilityCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Column Name:

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

OrganismCode

Count

CommonName

BuildingCode

FacilityCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Definition:

Date of Sample

Unique code to identify row

Minutes the pumping plant exported water

Minutes of count

Primary Channel depth (feet)

Primary Channel flow (cfs)

Unique code to identify row from Sample table in Access database

Unique code to identify row from Building table in Access databse

Species code from Organismlookup Table in Access and organism list excel file in this publication

Number of fish per count from catch table in Access database

Common name of fish from catch table in Access database

NS for new building and OS is for old building at Skinner Fish Facility; F is federal building referring to Tracy Fish Facility

1 is for Tracy Fish facility and 2 is for Skinner fish facility

Unique code to identify row

Lengths for each species at each count time

Length frequency for each length at each count time

21 feet for both *SWP and *CVP

43 feet for both *SWP and *CVP

21 feet for both SWP only (CVP only has 4 bays)

Calculated number of fish captured by the fish facility at a particular time (expanded by pumping minutes and length count).

Storage Type:

dateTime

string

float

string

float

string

float

Measurement Type:

dateTime

nominal

ratio

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	Regular Salvage
Source

Code Definition

Code	9999
Definition	Predator removal
Source

Unit	minutes
Type	real

Unit	minutes
Type	real

Unit	foot
Type	real

Unit	footPerSecond
Type	real

Unit	none
Type	integer

Unit	None
Type	integer

Unit	None
Type	integer

Unit	None
Type	real

Definition

text

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	F
Definition	F is federal building referring to Tracy Fish Facility
Source

Code Definition

Code	NS
Definition	NS for new building at Skinner Fish Facility
Source

Code Definition

Code	OS
Definition	OS is for old building at Skinner Fish Facility
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	1 is for Tracy Fish facility
Source

Code Definition

Code	2
Definition	2 is for Skinner fish facility
Source

Unit	none
Type	real

Unit	millimeter
Type	integer

Unit	none
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Unit	none
Type	real

Missing Value Code:

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/5f4a97b2a14665c99ea99a42451e47c3
Name:	Salvage_with_all_Variables_2022
Description:	Annual Salvage for year 2022
Number of Records:	2056
Number of Columns:	22

Table Structure

Object Name:

Salvage_with_all_Variables_2022.csv

Size:

225696 byte

Authentication:

dc08dfe728bdf75aa711ffc08f8ca2be Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

Catch.OrganismCode

Count

luOrganisms.OrganismCode

CommonName

BuildingCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Column Name:

SampleDate

StudyRowID

MinutesPumping

SampleTimeLength

PrimaryDepth

PrimaryFlow

SampleRowID

BuildingRowID

Catch.OrganismCode

Count

luOrganisms.OrganismCode

CommonName

BuildingCode

CatchRowID

ForkLength

LengthFrequency

BayPump1

BayPump2

BayPump3

BayPump4

BayPump5

Salvage

Definition:

Date of Sample

Unique code to identify row

Minutes the pumping plant exported water

Minutes of count

Primary Channel depth (feet)

Primary Channel flow (cfs)

Unique code to identify row from Sample table in Access database

Unique code to identify row from Building table in Access databse

Unique code to identify row

Number of fish per count from catch table in Access database

Organism scientific Name

Common name of fish from catch table in Access database

NS for new building and OS is for old building at Skinner Fish Facility; F is federal building referring to Tracy Fish Facility

Unique code to identify row

Lengths for each species at each count time

Length frequency for each length at each count time

21 feet for both *SWP and *CVP

43 feet for both *SWP and *CVP

21 feet for both SWP only (CVP only has 4 bays)

Calculated number of fish captured by the fish facility at a particular time (expanded by pumping minutes and length count).

Storage Type:

dateTime

string

float

string

float

string

float

string

float

Measurement Type:

dateTime

nominal

ratio

nominal

ratio

nominal

ratio

nominal

ratio

Measurement Values Domain:

Format	YYYY-MM-DD
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	Regular Salvage
Source

Code Definition

Code	9999
Definition	Predator removal
Source

Unit	minutes
Type	real

Unit	minutes
Type	real

Unit	foot
Type	real

Unit	footPerSecond
Type	real

Unit	none
Type	integer

Unit	None
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Organism Code
Source

Code Definition

Code	2
Definition	Organism Code
Source

Code Definition

Code	3
Definition	Organism Code
Source

Unit	None
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Organism scientific Name Code
Source

Code Definition

Code	2
Definition	Organism scientific Name Code
Source

Code Definition

Code	3
Definition	Organism scientific Name Code
Source

Definition

text

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	F
Definition	F is federal building referring to Tracy Fish Facility
Source

Code Definition

Code	NS
Definition	NS for new building at Skinner Fish Facility
Source

Code Definition

Code	OS
Definition	OS is for old building at Skinner Fish Facility
Source

Unit	none
Type	real

Unit	millimeter
Type	integer

Unit	none
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	False
Definition	Closed
Source

Code Definition

Code	True
Definition	Open
Source

Unit	none
Type	real

Missing Value Code:

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Code	NA
Expl	Not Applicable

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1290/6/3e42a7c1238fb5b4275ed45ef807efb9
Name:	Salvage_by_Month_2022
Description:	Salvage data for year 2022 by Month
Number of Records:	7
Number of Columns:	2

Table Structure

Object Name:

Salvage_by_Month_2022.csv

Size:

83 byte

Authentication:

cdbb782189458c1b47ff82ae986a0144 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

month

monthlysalvage

Column Name:

month

monthlysalvage

Definition:

Month

Monthly Salvage

Storage Type:

float

Measurement Type:

ratio

Measurement Values Domain:

Unit	Month
Type	integer

Unit	Month
Type	real

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Package Usage Rights

This information is released under the Creative Commons license - Attribution - CC BY (https://creativecommons.org/licenses/by/4.0/). The consumer of these data ("Data User" herein) is required to cite it appropriately in any publication that results from its use. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplicate publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. Where appropriate, the Data User is encouraged to consider collaboration or co-authorship with the authors. The Data User should realize that misinterpretation of data may occur if used out of context of the original study. While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data. Thank you.

Keywords

By Thesaurus:
(No thesaurus)	Fish Salvage, Tracy Fish Collection Facility , Skinner Delta Fish Protective Facility (SDFPF), Sacramento-San Joaquin Delta , Fish

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Methods and protocols used in the collection of this data package

Description:

Salvage reporting is required by contract with the California Department of Water Resources and the United States Bureau of Reclamation to export water and report to stakeholders such as the Smelt Monitoring Team and the Salmon Monitoring Team for near real time management of listed species. Both facilities use louver-bypass systems to divert fish from the exported water. The salvaged fish are periodically loaded into tanker trucks and transported to fixed release sites in the western Delta. Export and salvage operations began in 1957 at the TFCF and in 1968 at the SDFPF. The salvage database consists of 4 major components: the original data sheets, the master Access salvage database (main database) that contains all salvage data from January 1st, 1993, to the present (or copies of this database), dBase and Access salvage files files containing summary salvage information prior to 1993, and other database products. Data entry accuracy is checked by comparing listings of entered data against the data sheet entries twice immediately after their entry into the local database. Project environmental scientists perform reasonability checks by running computer queries that flag outliers or erroneous entries.

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@edirepository.org

Web Address:

https://edirepository.org

Id:

https://ror.org/0330j0z60

Creators:

Individual:

Dr Samreen Siddiqui

Organization:

California department of Fish and Wildlife

Position:

Environmental Scientist

Email Address:

samreen.siddiqui@wildlife.ca.gov

Id:

https://orcid.org/0000-0001-8238-384X

Individual:

Geir Assen

Organization:

California department of Fish and Wildlife

Position:

Environmental Scientist

Email Address:

Geir.Aasen@wildlife.ca.gov

Individual:

Virginia Afentoulis

Organization:

California department of Fish and Wildlife

Position:

Sr Env Scientist (Specialist)

Email Address:

Virginia.Afentoulis@Wildlife.ca.gov

Individual:

Walter Griffiths

Organization:

California department of Fish and Wildlife

Position:

Environmental Scientist

Email Address:

Walter.Griffiths@Wildlife.ca.gov

Individual:

Lauren Damon

Organization:

California department of Fish and Wildlife

Position:

Native Fish and Fish Facilities Supervisor

Email Address:

Lauren.Damon@wildlife.ca.gov

Contacts:

Individual:

Dr Samreen Siddiqui

Organization:

California department of Fish and Wildlife

Position:

Environmental Scientist

Email Address:

samreen.siddiqui@wildlife.ca.gov

Id:

https://orcid.org/0000-0001-8238-384X

Associated Parties:

Individual:

Reyes Rene

Organization:

Bureau of Reclamation

Position:

Supervisory Fish Biologist/Biological Resources Section

Email Address:

RReyes@usbr.gov

Role:

Tracy Fish Collection Facility daily salvage data management

Individual:	Tim Keopadubsy
Organization:	California department of Fish and Wildlife
Position:	Key Data Operator
Role:	Key Data Operator

Metadata Providers:

Individual:

Dr Samreen Siddiqui

Organization:

California department of Fish and Wildlife

Position:

Environmental Scientist

Email Address:

samreen.siddiqui@wildlife.ca.gov

Id:

https://orcid.org/0000-0001-8238-384X

Temporal, Geographic and Taxonomic Coverage

Temporal, Geographic and/or Taxonomic information that applies to all data in this dataset:

Time Period

Begin:

1993

End:

2021

Geographic Region:

Description:

Sacramento-San Joaquin Delta

Bounding Coordinates:

Northern:	38.068	Southern:	36.57075
Western:	-124.00826	Eastern:	-120.85988

Project

Parent Project Information:

Title:

Fish Facility Salvage Data

Personnel:

Individual:

Dr Samreen Siddiqui

Organization:

California department of Fish and Wildlife

Position:

Environmental Scientist

Email Address:

samreen.siddiqui@wildlife.ca.gov

Id:

https://orcid.org/0000-0001-8238-384X

Role:

Environmental Scientist

Maintenance

Maintenance:

Description:	This is an update for 2022
Frequency:	asNeeded

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'none'
        |     |     |     |  \___attribute 'name' = 'none'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Salvage= Observed number of fish x (Total minutes pumping ÷ Count length)\nUnit= Number of fish (min/min)= Count number '
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'None'
        |     |     |     |  \___attribute 'name' = 'None'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'minutes'
        |     |     |     |  \___attribute 'name' = 'minutes'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'Month'
        |     |     |     |  \___attribute 'name' = 'Month'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___text '\n    '
        |___text '\n  '

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'emlEditor'
        |     |        \___attribute 'app' = 'ezEML'
        |     |        \___attribute 'release' = '2023.08.08'
        |     |___text '\n    '
        |___text '\n  '

Copyright 2024 Environmental Data Initiative. This material is based upon work supported by the National Science Foundation under grants #2223103 and #2223104. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation. Please contact us with questions, comments, or for technical assistance regarding this web site or the Environmental Data Initiative. Please read our privacy policy to know what information we collect about you and to understand your privacy rights.

EDI is a collaboration between the University of New Mexico and the University of Wisconsin – Madison, Center for Limnology:

Data Package Metadata View Summary

Fish Facilities Salvage Data from 1993-2021

Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Package Usage Rights

Keywords

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Parent Project Information:

Maintenance

Additional Metadata

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Fish Facilities Salvage Data from 1993-2021

+/- Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

+/- Data Package Usage Rights

+/- Keywords

+/- Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

+/- People and Organizations

+/- Temporal, Geographic and Taxonomic Coverage

+/- Project

Parent Project Information:

+/- Maintenance

+/- Additional Metadata

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Maintenance

Additional Metadata

Additional Metadata