CDFG Fish Screen and Fish Passage Database

Shapefile

Thumbnail Not Available

Tags
structure, inlandWaters, barrier, dam, culvert, road crossing, stream, fish migration, obstacle, impediment, passage, inventory, in-stream structure, anadromy, diversion, salmonid, anadromous, fish screen, entrainment, California


Summary

The FSFP Project and its ever-growing database were developed to support the enhancement and improvement of the anadromous fishery resources of California. This is accomplished by first identifying any potential barrier to fish migration, then prioritizing them for passage improvement. This ultimately optimizes fish passage for both upstream and downstream migration of anadromous fishes, thereby contributing to higher numbers of adult salmon and steelhead returning to rivers in subsequent years.

Description

This California Department of Fish and Game (CDFG) Fish Screen and Fish Passage (FSFP) Project, funded by the federal Sport Fish Restoration Act, was initiated in 1991 as part of the Salmon, Steelhead Trout and Anadromous Fishes Restoration and Enhancement Program. Efforts are focused on identifying potential fish passage barriers in all anadromous waters. Impediments to fish passage can include both natural and man-made structures. Man-made barriers may include impassable culverts, road crossings and dams, as well as unscreened water diversions. Installing a fish screen on the intake of a water diversion has been known to help prevent juvenile fishes from being entrained (removed from the river) thereby contributing to higher numbers of adults returning to the rivers in subsequent years. Providing technical guidance on such fish passage improvement projects is also a part of the FSFP Project. Fish passage assessment inventories on rivers and streams are conducted by boat, inflatable kayak, truck, or on foot, whichever is appropriate for the area. Depending on flows and available daylight, survey crews can inventory between six to 18 miles per day. A Geographic Positioning System (GPS) point is collected for each water diversion and potential fish passage barrier. ArcView Geographic Information System (GIS) mapping software and Microsoft Access are then used to create and maintain a comprehensive spatial database. Each data point has an associated record of information and photograph. This information is then used to identify and prioritize potential fish passage improvement sites thereby improving fish migrations. Additionally, records are compared with those maintained by the State Water Resources Control Board, the Department of Water Resources, the U.S Bureau of Reclamation, as well as with other agencies for additional information and to fill data gaps.

Credits

Use limitations

Extent

West  -124.271153    East  -118.080065
North  41.917016    South  36.387585

Scale Range

ArcGIS Metadata 

Topics and Keywords 

Themes or categories of the resource  inlandWaters, structure


*Content type  Downloadable Data


Place keywords  California

Theme keywords  structure, inlandWaters

Thesaurus
Title ISO 19115 Topic Category




Theme keywords  barrier, dam, culvert, road crossing, stream, fish migration, obstacle, impediment, passage, inventory, in-stream structure, anadromy, diversion, salmonid, anadromous, fish screen, entrainment

Citation 

Title CDFG Fish Screen and Fish Passage Database
Publication date 2005-12-15


Presentation formats* digital map


Citation Contacts 

Responsible party
Organization's name California Department of Fish and Game
Contact's role  originator


Resource Details 

Dataset languages  English (UNITED STATES)


Spatial representation type* vector


*Processing environment Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.4.1.5686


ArcGIS item properties
*Name CDFG_FSFP
*Size 0.146
*Location file://\\geodata.ad.dfg.ca.gov\GIS\OSPR_GIS\OSPR_Data\Ospr_GIS_Lib\ERMA\Bathymetry_Hydrology\Hydrology_Hydrography\Passage_Barriers_Diversions\CDFG_Fish_Screen_and_Fish_Passage_Database\CDFG_FSFP.shp
*Access protocol Local Area Network

Extents 

Extent
Description
publication date

Extent
Geographic extent
Bounding rectangle
Extent type  Extent used for searching
*West longitude -124.271153
*East longitude -118.080065
*North latitude 41.917016
*South latitude 36.387585
*Extent contains the resource Yes

Extent in the item's coordinate system
*West longitude -124.271153
*East longitude -118.080065
*South latitude 36.387585
*North latitude 41.917016
*Extent contains the resource Yes

Resource Points of Contact 

Point of contact
Individual's name Jonathan Nelson
Organization's name California Department of Fish and Game
Contact's role  point of contact


Contact information
Phone
Voice (916)227-2333

Address
e-mail addressJONELSON@dfg.ca.gov

Contact instructions
Alternate Contact: Martina Koller, PSMFC, mkoller@dfg.ca.gov



Resource Maintenance 

Resource maintenance
Update frequency  continual


Resource Constraints 

Security constraints
Classification  unclassified


Spatial Reference 

ArcGIS coordinate system
*Type Geographic
*Geographic coordinate reference GCS_WGS_1984
*Coordinate reference details
Geographic coordinate system
Well-known identifier 4326
X origin -400
Y origin -400
XY scale 11258999068426.238
Z origin -100000
Z scale 10000
M origin -100000
M scale 10000
XY tolerance 8.983152841195215e-009
Z tolerance 0.001
M tolerance 0.001
High precision true
Left longitude -180
Latest well-known identifier 4326
Well-known text GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",4326]]

Reference system identifier
*Value 4326
*Codespace EPSG
*Version 6.14(3.0.1)


Spatial Data Properties 

Vector
*Level of topology for this dataset  geometry only


Geometric objects
Feature class name CDFG_FSFP
*Object type  point
*Object count 5460



ArcGIS Feature Class Properties
Feature class name CDFG_FSFP
*Feature type Simple
*Geometry type Point
*Has topology FALSE
*Feature count 5460
*Spatial index TRUE
*Linear referencing FALSE



Data Quality 

Scope of quality information
Resource level  dataset




Data quality report - Conceptual consistency
Measure description
The Fish Screen and Fish Passage Database was compiled using field data about fish passage from CDFG's FSFP Project as well as from other sources such as DWR, USBR, NOAA/NMFS, SWRCB. This database was originally created to inform natural resource decision-makers of magnitude of fish passage problems in California and to aid in improving passage for threatened and endangered anadromous fish. The quality of the data in the FSFP database will vary depending on the data source, including different amounts of detail and varying degrees of accuracy in location descriptions.





Data quality report - Completeness omission
Measure description
The FSFP Database is continually managed for quality assurance and quality control and is updated on a daily basis. Any potential errors should be reported to the database contact person.





Lineage 

Process step
When the process occurred 2006-10-01
Description
Received data from Martina Koller PSMFC (working on-site at DFG). Original metadata drafted by DFG's Katie Witts. Metadata later adjusted/edited by Will Patterson, DFG GIS Service Center (geodata@dfg.ca.gov).



Process contact
Individual's name Will Patterson
Organization's name California Department of Fish and Game
Contact's role  processor


Contact information




Process step
When the process occurred 2006-11-16
Description
Data research and assessment. It appears the data were originally provided to the DFG GIS Service Center in California Teale Albers (CTA) NAD27 but documented as CTA NAD83. Did a (true) re-projection of the dataset to CTA NAD83. In comparing the points visually, the newly re-projected CTA NAD83 version appears to be more correctly located than the old version, so it is now the current version. However, some of the coordinate values in the fields LATD, LATM, LATS, LOND, LONM, LONS appear to be off. They may be in a different datum (NAD27) than the dataset (NAD83), or may have a unknown processing history with a combination of datums. Have inquired to the data source contacts to try and decipher the processing history.



Process contact
Individual's name Will Patterson
Organization's name California Department of Fish and Game
Contact's role  processor


Contact information




Distribution 

Distributor
Contact information
Individual's name Jonathan Nelson
Organization's name California Department of Fish and Game
Contact's role  distributor


Contact information
Phone
Voice (916)227-2333

Address
e-mail addressJONELSON@dfg.ca.gov

Contact instructions
Alternate Contacts: Martina Koller, PSMFC (mkoller@dfg.ca.gov), DFG GIS Service Center (geodata@dfg.ca.gov).



Available format
Specification Can supply data in following formats as requested: shp, dbf, xls, mdb
Format information content Tailored to request


Ordering process
Terms and fees None
Instructions
Call or email Contact Person to request data.


Transfer options
Medium of distribution
Medium name  CD-ROM




Distribution format
*Name Shapefile


Transfer options
*Transfer size 0.146


Fields 

Details for object CDFG_FSFP 
*Type Feature Class
*Row count 5460
Definition
CDFG Fish Screen and Fish Passage Database



Field FID
 
*Alias FID
*Data type OID
*Width 4
*Precision 0
*Scale 0
Field description
Internal feature number.  Auto generated.

*Description source
ESRI

*Description of values
Sequential unique whole numbers that are automatically generated.





Field Shape
 
*Alias Shape
*Data type Geometry
*Width 0
*Precision 0
*Scale 0
Field description
Feature geometry (i.e. point, line polygon).

*Description source
ESRI

*Description of values
Coordinates defining the features.





Field DIVER_ID
 
*Alias DIVER_ID
*Data type String
*Width 9
*Precision 0
*Scale 0
Field description
Unique FSFP database record identification number. Primary key for relating diversion/barrier locations to their records in the FSFP database

Description source
FSFP Database



Field OWNER_ID
 
*Alias OWNER_ID
*Data type Double
*Width 19
*Precision 0
*Scale 0
Field description
Unique identification number assigned to owner of each site.  Relates directly to Primary key in FSFP Ownership Database

Description source
FSFP Ownership Database



Field WRIMS_ID
 
*Alias WRIMS_ID
*Data type String
*Width 10
*Precision 0
*Scale 0
Field description
Water Right Application Number.  Assigned by SWRCB to water user of each diversion.  Also relates to FSFP Ownership Database.  A "+" indicates more than one application.

Description source
State Water Resources Control Board, Division of Water Rights, WRIMS



Field SDATE
 
*Alias SDATE
*Data type String
*Width 50
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Date of field survey



Field NTIME
 
*Alias NTIME
*Data type Double
*Width 19
*Precision 0
*Scale 0
Field description
Time of field survey

Description source
FSFP Database



Field DIVER_NAME
 
*Alias DIVER_NAME
*Data type String
*Width 36
*Precision 0
*Scale 0
Field description
Name of diversion/barrier when known.

Description source
FSFP Database



Field LATD
 
*Alias LATD
*Data type Double
*Width 19
*Precision 0
*Scale 0
Field description
Latitude Degrees

Description source
ESRI



Field LATM
 
*Alias LATM
*Data type Double
*Width 19
*Precision 0
*Scale 0
Field description
Latitude Minutes

Description source
ESRI



Field LATS
 
*Alias LATS
*Data type Double
*Width 19
*Precision 0
*Scale 0
Field description
Latitude Seconds

Description source
ESRI



Field LOND
 
*Alias LOND
*Data type Double
*Width 19
*Precision 0
*Scale 0
Field description
Longitude Degrees

Description source
ESRI



Field LONM
 
*Alias LONM
*Data type Double
*Width 19
*Precision 0
*Scale 0
Field description
Longitude Minutes

Description source
ESRI



Field LONS
 
*Alias LONS
*Data type Double
*Width 19
*Precision 0
*Scale 0
Field description
Longitude Seconds

Description source
ESRI



Field QUAD7_5
 
*Alias QUAD7_5
*Data type String
*Width 24
*Precision 0
*Scale 0
Field description
Name of USGS 7.5min Topo Quad where diversion/barrier is located.

Description source
Calquad.dbf



Field LLID
 
*Alias LLID
*Data type String
*Width 50
*Precision 0
*Scale 0
Field description
Unique stream identification number; Obtained by snapping to the CDFG routed 1:100K California hydrography

Description source
cdfg_100k_2003_6.dbf, shydropp.dbf



Field RIVER_SYS
 
*Alias RIVER_SYS
*Data type String
*Width 24
*Precision 0
*Scale 0
Description source
cdfg_100k_2003_6.dbf, shydrop.dbf

Field description
Body of water the diversion/barrier is located on



Field RIVER_MILE
 
*Alias RIVER_MILE
*Data type Double
*Width 19
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
River mile location of diversion/barrier.



Field DIVER_POS
 
*Alias DIVER_POS
*Data type String
*Width 12
*Precision 0
*Scale 0
Field description
Position in relation to the river (straight, backwater, outside bend, inside bend, behind berm)

Description source
FSFP Database



Field BANK_LOC
 
*Alias BANK_LOC
*Data type String
*Width 5
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Bank location (as looking downstream) of site (left, right, both if dam, weir, etc.).



Field DIVER_TYPE
 
*Alias DIVER_TYPE
*Data type String
*Width 20
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Diversion/Barrier Type (siphon, pump, vertical, slant, centrifugal, floodgate, turnout, drain, culvert, flashboard, AC/DC flapgate, dam, weir, natural)



Field NUM_PUMPS
 
*Alias NUM_PUMPS
*Data type Double
*Width 19
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Number of pumps/pipes (multiples may occur on a single platform); where more than 4 pumps/pipes occur at the same site, only 1 GPS position is collected.



Field INTAKE_SIZ
 
*Alias INTAKE_SIZ
*Data type Double
*Width 19
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Outside diameter of intake (inches);  --99 value indicates unknown size; 999 value indicates a weir, dam, ladder or pump platform with multiple intakes that total over 60 inches.



Field HPRATINGS
 
*Alias HPRATINGS
*Data type String
*Width 20
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Horsepower rating of diversion pumps (if known).



Field MAX_CAP
 
*Alias MAX_CAP
*Data type Double
*Width 19
*Precision 0
*Scale 0
Description source
State Water Resources Control Board, Division of Water Rights, WRIMS

Field description
Maximum diversion/barrier capacity (cfs); -99 value indicates unknown cfs designation; this info is obtained via the State Water Board files, districts' meters, or word-of-mouth.



Field BYPASS
 
*Alias BYPASS
*Data type String
*Width 3
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
The site has a flow bypass (yes, no).



Field FLOWMETER
 
*Alias FLOWMETER
*Data type String
*Width 3
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
The site has a flowmeter (yes, no)



Field PORTABLE
 
*Alias PORTABLE
*Data type String
*Width 1
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Whether the point of diversion is movable (yes, no)



Field DISCHARG_T
 
*Alias DISCHARG_T
*Data type String
*Width 30
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Type of discharge where the diverted water is taken (i.e. ditch, field, pond, vertical concrete pipe, distribution pipe, underground, sprinklers, etc.). This information is used for possible future entrainment sampling.



Field SCREEN_TYP
 
*Alias SCREEN_TYP
*Data type String
*Width 20
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Type of fish screen (none, flat plate, cylindrical, conical, etc.)



Field SCREEN_CRI
 
*Alias SCREEN_CRI
*Data type String
*Width 14
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
The fish screen met DFG and/or NMFS screeing criteria for salmon, steelhead, or delta smelt on date of survey.  "Not Applicable" is listed if site does not pertain to fish screening (i.e. rd culvert, natural barrier, etc.).



Field SCREEN_MEM
 
*Alias SCREEN_MEM
*Data type String
*Width 254
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Additional screen information regarding specific details about the screen (installation date, company, type, funding, mesh size, material)



Field PER_OPER
 
*Alias PER_OPER
*Data type String
*Width 14
*Precision 0
*Scale 0
Description source
State Water Resources Control Board, Division of Water Rights, WRIMS

Field description
Period of operation during the year (if a diversion, as allowed by water right).



Field PRIM_USE
 
*Alias PRIM_USE
*Data type String
*Width 14
*Precision 0
*Scale 0
Description source
State Water Resources Control Board, Division of Water Rights, WRIMS

Field description
Primary use of site (ag, industrial, municipal, domestic, fish & wildlife enhancement, recreation, road crossing, etc.)



Field ENTR_MON
 
*Alias ENTR_MON
*Data type String
*Width 24
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
If any entrainment monitoring has been conducted at the site (yes, no).



Field ENTRN_MEMO
 
*Alias ENTRN_MEMO
*Data type String
*Width 254
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Entrainment monitoring information regarding specific details about who, when, gear, target species



Field INTAKE_PIC
 
*Alias INTAKE_PIC
*Data type String
*Width 1
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Picture of intake (or barrier) was taken (yes, no).



Field DISCHR_PIC
 
*Alias DISCHR_PIC
*Data type String
*Width 1
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Picture of discharge was taken (yes, no)



Field SCREEN_PIC
 
*Alias SCREEN_PIC
*Data type String
*Width 1
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Picture of screen (or ladder) was taken (yes, no)



Field PHOTO_CDID
 
*Alias PHOTO_CDID
*Data type String
*Width 14
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Identification number of CD-ROM where the photos are archived.



Field INTAKE_PCD
 
*Alias INTAKE_PCD
*Data type String
*Width 16
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Identification number of site/intake photo (pcd, jpeg, etc.)



Field DISCHR_PCD
 
*Alias DISCHR_PCD
*Data type String
*Width 16
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Identification number of discharge photo in pcd or jpeg format (a "d" will follow the id# to indicate "discharge")



Field SCREEN_PCD
 
*Alias SCREEN_PCD
*Data type String
*Width 16
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Identification number of screen photo in pcd or jpeg format (usually a "s" will follow the id# to indicate "screen", and "l" indicates photo of "fish ladder")



Field COMMENTS
 
*Alias COMMENTS
*Data type String
*Width 60
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Additional comments to further describe the potential barrier or any other pertinent info.



Field MONTH
 
*Alias MONTH
*Data type Double
*Width 19
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Month of survey



Field DAY
 
*Alias DAY
*Data type Double
*Width 19
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Day of survey



Field YEAR
 
*Alias YEAR
*Data type Double
*Width 19
*Precision 0
*Scale 0
Description source
FSFP Database

Field description
Year of survey





Metadata Details 

Metadata language English (UNITED STATES)
Metadata character set  utf8 - 8 bit UCS Transfer Format


Scope of the data described by the metadata  dataset
Scope name* dataset


*Last update 2017-01-05


ArcGIS metadata properties
Metadata format ArcGIS 1.0
Metadata style FGDC CSDGM Metadata


Created in ArcGIS for the item 2016-09-19 15:05:35
Last modified in ArcGIS for the item 2017-01-05 13:14:05


Automatic updates
Have been performed Yes
Last update 2017-01-05 13:14:05

Published to an ArcIMS Metadata Service Published



Metadata Contacts 

Metadata contact
Individual's name GIS Service Center
Organization's name California Department of Fish and Game
Contact's role  point of contact


Contact information


Metadata Maintenance 

Maintenance
Update frequency  unknown


Other maintenance requirements
Last metadata review date: 20051215



Metadata Constraints 

Security constraints
Classification  unclassified


Thumbnail and Enclosures 

Thumbnail

Enclosure
Enclosure type  File
Description of enclosure original metadata
Original metadata document, which was translated yes
Source metadata format fgdc

FGDC Metadata (read-only) 

Identification 

Citation
Citation Information
OriginatorCalifornia Department of Fish and Game
Publication Date2005-12-15
Title
CDFG Fish Screen and Fish Passage Database
Geospatial Data Presentation Formvector digital data
Online Linkage\\Molib01\GIS_Library\Hydrography\Passage_Barriers_Diversions\CDFG_Fish_Screen_and_Fish_Passage_Database\CDFG_FSFP.shp

Description
Abstract
                            This California Department of Fish and Game (CDFG) Fish Screen and Fish Passage (FSFP) Project, funded by the federal Sport Fish Restoration Act, was initiated in 1991 as part of the Salmon, Steelhead Trout and Anadromous Fishes Restoration and Enhancement Program.  Efforts are focused on identifying potential fish passage barriers in all anadromous waters.  Impediments to fish passage can include both natural and man-made structures.  Man-made barriers may include impassable culverts, road crossings and dams, as well as unscreened water diversions.  Installing a fish screen on the intake of a water diversion has been known to help prevent juvenile fishes from being entrained (removed from the river) thereby contributing to higher numbers of adults returning to the rivers in subsequent years.  Providing technical guidance on such fish passage improvement projects is also a part of the FSFP Project.

Fish passage assessment inventories on rivers and streams are conducted by boat, inflatable kayak, truck, or on foot, whichever is appropriate for the area.  Depending on flows and available daylight, survey crews can inventory between six to 18 miles per day.  A Geographic Positioning System (GPS) point is collected for each water diversion and potential fish passage barrier.  ArcView Geographic Information System (GIS) mapping software and Microsoft Access are then used to create and maintain a comprehensive spatial database.  Each data point has an associated record of information and photograph.  This information is then used to identify and prioritize potential fish passage improvement sites thereby improving fish migrations.  Additionally, records are compared with those maintained by the State Water Resources Control Board, the Department of Water Resources, the U.S Bureau of Reclamation, as well as with other agencies for additional information and to fill data gaps.
                          
Purpose
                            The FSFP Project and its ever-growing database were developed to support the enhancement and improvement of the anadromous fishery resources of California.  This is accomplished by first identifying any potential barrier to fish migration, then prioritizing them for passage improvement.  This ultimately optimizes fish passage for both upstream and downstream migration of anadromous fishes, thereby contributing to higher numbers of adult salmon and steelhead returning to rivers in subsequent years.
                          
Time Period of Content
Time Period Information
Range of Dates/Times
Beginning Date1991
Ending Time20:05:12
Currentness Reference
                            publication date
                          
Status
ProgressProgress: In work
Maintenance and Update FrequencyContinually

Spatial Domain
Bounding Coordinates
West Bounding Coordinate-124.367144
East Bounding Coordinate-117.930343
North Bounding Coordinate41.982355
South Bounding Coordinate36.329675

Keywords
Theme
Theme Keyword Thesaurusnone
Theme Keywordbarrier, dam, culvert, road crossing, stream, fish migration, obstacle, impediment, passage, inventory, in-stream structure, anadromy, diversion, salmonid, anadromous, fish screen, entrainment

Theme
Theme Keyword ThesaurusISO 19115 Topic Category
Theme KeywordinlandWaters
Theme Keywordstructure

Place
Place Keyword Thesaurusnone
Place KeywordCalifornia

Access Constraints
                        None
                      
Use Constraints
                        None
                      
Point of Contact
Contact Information
Contact Organization Primary
Contact OrganizationCalifornia Department of Fish and Game
Contact PersonJonathan Nelson
Contact Address

Contact Voice Telephone(916)227-2333
Contact Electronic Mail AddressJONELSON@dfg.ca.gov
Contact Instructions
                                Alternate Contact:  Martina Koller, PSMFC, mkoller@dfg.ca.gov
                              

Security Information
Security ClassificationUnclassified

Native Data Set Environment
Microsoft Windows 2000 Version 5.2 (Build 3790) Service Pack 1; ESRI ArcCatalog 9.1.0.722

Data Quality 

Logical Consistency Report
                        The Fish Screen and Fish Passage Database was compiled using field data about fish passage from CDFG's FSFP Project as well as from other sources such as DWR, USBR, NOAA/NMFS, SWRCB. This database was originally created to inform natural resource decision-makers of magnitude of fish passage problems in California and to aid in improving passage for threatened and endangered anadromous fish.  The quality of the data in the FSFP database will vary depending on the data source, including different amounts of detail and varying degrees of accuracy in location descriptions.
                      
Completeness Report
                        The FSFP Database is continually managed for quality assurance and quality control and is updated on a daily basis.  Any potential errors should be reported to the database contact person.
                      
Lineage
Process Step
Process Description
                                Received data from Martina Koller PSMFC (working on-site at DFG).  Original metadata drafted by DFG's Katie Witts.  Metadata later adjusted/edited by Will Patterson, DFG GIS Service Center (geodata@dfg.ca.gov).
                              
Process Date2006-10


Process Contact
Contact Information
Contact Person Primary
Contact PersonWill Patterson
Contact OrganizationCalifornia Department of Fish and Game
Contact Electronic Mail Addressgeodata@dfg.ca.gov

Process Step
Process Description
                                Data research and assessment.  It appears the data were originally provided to the DFG GIS Service Center in California Teale Albers (CTA) NAD27 but documented as CTA NAD83.  Did a (true) re-projection of the dataset to CTA NAD83.  In comparing the points visually, the newly re-projected CTA NAD83 version appears to be more correctly located than the old version, so it is now the current version.  However, some of the coordinate values in the fields LATD, LATM, LATS, LOND, LONM, LONS appear to be off.  They may be in a different datum (NAD27) than the dataset (NAD83), or may have a unknown processing history with a combination of datums.  Have inquired to the data source contacts to try and decipher the processing history.
                              
Process Date2006-11-16


Process Contact
Contact Information
Contact Person Primary
Contact PersonWill Patterson
Contact OrganizationCalifornia Department of Fish and Game
Contact Electronic Mail Addressgeodata@dfg.ca.gov

Spatial Reference 

Horizontal Coordinate System Definition
Geodetic Model
Horizontal Datum NameNorth American Datum of 1983
Ellipsoid NameGeodetic Reference System 80
Semi-major Axis6378137.000000
Denominator of Flattening Ratio298.257222

Entities and Attributes 

Detailed Description
Entity Type
Entity Type LabelCDFG_FSFP
Entity Type Definition
CDFG Fish Screen and Fish Passage Database

Attribute
Attribute LabelFID
Attribute Definition
Internal feature number. Auto generated.
Attribute Definition SourceESRI
Attribute Domain Values
Unrepresentable Domain
Sequential unique whole numbers that are automatically generated.

Attribute
Attribute LabelShape
Attribute Definition
Feature geometry (i.e. point, line polygon).
Attribute Definition SourceESRI
Attribute Domain Values
Unrepresentable Domain
Coordinates defining the features.

Attribute
Attribute LabelDIVER_ID
Attribute Definition
Unique FSFP database record identification number. Primary key for relating diversion/barrier locations to their records in the FSFP database
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelOWNER_ID
Attribute Definition
Unique identification number assigned to owner of each site. Relates directly to Primary key in FSFP Ownership Database
Attribute Definition SourceFSFP Ownership Database

Attribute
Attribute LabelWRIMS_ID
Attribute Definition
Water Right Application Number. Assigned by SWRCB to water user of each diversion. Also relates to FSFP Ownership Database. A "+" indicates more than one application.
Attribute Definition SourceState Water Resources Control Board, Division of Water Rights, WRIMS

Attribute
Attribute LabelSDATE
Attribute Definition
Date of field survey
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelNTIME
Attribute Definition
Time of field survey
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelDIVER_NAME
Attribute Definition
Name of diversion/barrier when known.
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelLATD
Attribute Definition
Latitude Degrees
Attribute Definition SourceESRI

Attribute
Attribute LabelLATM
Attribute Definition
Latitude Minutes
Attribute Definition SourceESRI

Attribute
Attribute LabelLATS
Attribute Definition
Latitude Seconds
Attribute Definition SourceESRI

Attribute
Attribute LabelLOND
Attribute Definition
Longitude Degrees
Attribute Definition SourceESRI

Attribute
Attribute LabelLONM
Attribute Definition
Longitude Minutes
Attribute Definition SourceESRI

Attribute
Attribute LabelLONS
Attribute Definition
Longitude Seconds
Attribute Definition SourceESRI

Attribute
Attribute LabelQUAD7_5
Attribute Definition
Name of USGS 7.5min Topo Quad where diversion/barrier is located.
Attribute Definition SourceCalquad.dbf

Attribute
Attribute LabelLLID
Attribute Definition
Unique stream identification number; Obtained by snapping to the CDFG routed 1:100K California hydrography
Attribute Definition Sourcecdfg_100k_2003_6.dbf, shydropp.dbf

Attribute
Attribute LabelRIVER_SYS
Attribute Definition
Body of water the diversion/barrier is located on
Attribute Definition Sourcecdfg_100k_2003_6.dbf, shydrop.dbf

Attribute
Attribute LabelRIVER_MILE
Attribute Definition
River mile location of diversion/barrier.
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelDIVER_POS
Attribute Definition
Position in relation to the river (straight, backwater, outside bend, inside bend, behind berm)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelBANK_LOC
Attribute Definition
Bank location (as looking downstream) of site (left, right, both if dam, weir, etc.).
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelDIVER_TYPE
Attribute Definition
Diversion/Barrier Type (siphon, pump, vertical, slant, centrifugal, floodgate, turnout, drain, culvert, flashboard, AC/DC flapgate, dam, weir, natural)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelNUM_PUMPS
Attribute Definition
Number of pumps/pipes (multiples may occur on a single platform); where more than 4 pumps/pipes occur at the same site, only 1 GPS position is collected.
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelINTAKE_SIZ
Attribute Definition
Outside diameter of intake (inches); --99 value indicates unknown size; 999 value indicates a weir, dam, ladder or pump platform with multiple intakes that total over 60 inches.
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelHPRATINGS
Attribute Definition
Horsepower rating of diversion pumps (if known).
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelMAX_CAP
Attribute Definition
Maximum diversion/barrier capacity (cfs); -99 value indicates unknown cfs designation; this info is obtained via the State Water Board files, districts' meters, or word-of-mouth.
Attribute Definition SourceState Water Resources Control Board, Division of Water Rights, WRIMS

Attribute
Attribute LabelBYPASS
Attribute Definition
The site has a flow bypass (yes, no).
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelFLOWMETER
Attribute Definition
The site has a flowmeter (yes, no)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelPORTABLE
Attribute Definition
Whether the point of diversion is movable (yes, no)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelDISCHARG_T
Attribute Definition
Type of discharge where the diverted water is taken (i.e. ditch, field, pond, vertical concrete pipe, distribution pipe, underground, sprinklers, etc.). This information is used for possible future entrainment sampling.
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelSCREEN_TYP
Attribute Definition
Type of fish screen (none, flat plate, cylindrical, conical, etc.)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelSCREEN_CRI
Attribute Definition
The fish screen met DFG and/or NMFS screeing criteria for salmon, steelhead, or delta smelt on date of survey. "Not Applicable" is listed if site does not pertain to fish screening (i.e. rd culvert, natural barrier, etc.).
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelSCREEN_MEM
Attribute Definition
Additional screen information regarding specific details about the screen (installation date, company, type, funding, mesh size, material)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelPER_OPER
Attribute Definition
Period of operation during the year (if a diversion, as allowed by water right).
Attribute Definition SourceState Water Resources Control Board, Division of Water Rights, WRIMS

Attribute
Attribute LabelPRIM_USE
Attribute Definition
Primary use of site (ag, industrial, municipal, domestic, fish & wildlife enhancement, recreation, road crossing, etc.)
Attribute Definition SourceState Water Resources Control Board, Division of Water Rights, WRIMS

Attribute
Attribute LabelENTR_MON
Attribute Definition
If any entrainment monitoring has been conducted at the site (yes, no).
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelENTRN_MEMO
Attribute Definition
Entrainment monitoring information regarding specific details about who, when, gear, target species
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelINTAKE_PIC
Attribute Definition
Picture of intake (or barrier) was taken (yes, no).
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelDISCHR_PIC
Attribute Definition
Picture of discharge was taken (yes, no)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelSCREEN_PIC
Attribute Definition
Picture of screen (or ladder) was taken (yes, no)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelPHOTO_CDID
Attribute Definition
Identification number of CD-ROM where the photos are archived.
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelINTAKE_PCD
Attribute Definition
Identification number of site/intake photo (pcd, jpeg, etc.)
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelDISCHR_PCD
Attribute Definition
Identification number of discharge photo in pcd or jpeg format (a "d" will follow the id# to indicate "discharge")
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelSCREEN_PCD
Attribute Definition
Identification number of screen photo in pcd or jpeg format (usually a "s" will follow the id# to indicate "screen", and "l" indicates photo of "fish ladder")
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelCOMMENTS
Attribute Definition
Additional comments to further describe the potential barrier or any other pertinent info.
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelMONTH
Attribute Definition
Month of survey
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelDAY
Attribute Definition
Day of survey
Attribute Definition SourceFSFP Database

Attribute
Attribute LabelYEAR
Attribute Definition
Year of survey
Attribute Definition SourceFSFP Database

Distribution Information 

Distributor
Contact Information
Contact Organization Primary
Contact OrganizationCalifornia Department of Fish and Game
Contact PersonJonathan Nelson
Contact Address

Contact Voice Telephone(916)227-2333
Contact Electronic Mail AddressJONELSON@dfg.ca.gov
Contact Instructions
                                Alternate Contacts:  Martina Koller, PSMFC (mkoller@dfg.ca.gov), DFG GIS Service Center (geodata@dfg.ca.gov).
                              

Resource DescriptionDownloadable Data
Standard Order Process
Digital Form
Digital Transfer Information
Format Specification
Can supply data in following formats as requested: shp, dbf, xls, mdb
Format Information Content
Tailored to request
Transfer Size0.146

Digital Transfer Option
Offline Option
Offline MediaAs requested, but usually email (if size allows) or CD-ROM

FeesNone
Ordering Instructions
                            Call or email Contact Person to request data.
                          


Metadata Reference 

Metadata Date2006-11-16
Metadata Review Date2005-12-15
Metadata Contact
Contact Information
Contact Organization Primary
Contact OrganizationCalifornia Department of Fish and Game
Contact PersonGIS Service Center
Contact Address

Contact Electronic Mail Addressgeodata@dfg.ca.gov

Metadata Standard NameFGDC Content Standards for Digital Geospatial Metadata
Metadata Standard VersionFGDC-STD-001-1998
Metadata Time Conventionlocal time


Metadata Access ConstraintsNone
Metadata Use Constraints
None
Metadata Security Information
Metadata Security ClassificationUnclassified