INSTITUTE FOR FISHERIES RESOURCES GIS TECHNICAL WORK GROUP -- GIS METADATA LIBRARY: Garcia/Navarro/Russian/WMarinSonoma/NorthBay COVERAGE NAME: coho_pres_abs.shp METADATA FILE: coho_pres_abs.shp.txt METADATA FILE DATE: April 8, 2002 METADATA PREPARER: Eli Asarian Institute for Fisheries Resources (IFR) 791 Eighth Street Ste. N Arcata, CA 95521 (707) 822-9428 COVERAGE DESCRIPTION: This shapefile contains coho presence / absence data for historical coho streams between Wages Creek (northern Mendocino County) to the Corte Madera Creek (Southern Marin County). The streams listed in this database are those known historically to harbor coho salmon juveniles in a draft California Department of Fish and Game database, but there are almost certainly other historical coho streams that are not included in this database. Some rows from the CDFG database are not included in this shapefile because I did not have GIS hydrography layers for all areas (including the Eel River drainage, the coast north of Wages Creek, the thin strip of coastline south of the Gualala River) and streams south of the Golden Gate (San Francisco) were clipped from the database at Scott Harris's request due to concerns over data accuracy in that area. This database contains only data on the presence / absence of coho salmon young-of-the-year, not any other life-stages. Methods: This shapefile was assembled from 3 sources: California Department of Forestry (CDF) 1:24,000 scale hydrography (from Northern Mendocino to the mouth of the Russian River), U.S. Environmental Protection Agency (EPA) 1:100,000 scale (mouth of the Russian River to Corte Madera Creek), and a California Department of Fish and Game (CDFG) Microsoft Excel database of coho presence absence, contributed to KRIS by Scott Harris of CDFG. The CDFG database had fields partially filled in for LLID (the unique stream reach identifier field in the CDF 1:24k hydrography layer). Eli Asarian (KRIS-IFR staff) filled in the rest of the LLIDs (a few could not be determined because they were un-named streams). The CDFG database was reformatted to meet DBASEIV conventions, and some summary statistics were calculated using Excel, and the CDFG database was converted to a .dbf files. An ArcView Join, and then a Convert to Shapefile command was used to join the CDFG database to 1:24k CDF Hydrography using the LLID field as the common field. The CDF 1:24k routed hydrography with LLID does not exist south of the Russian River, but there is an EPA 1:100k hydrography layer with a unique ID column PNMCD. PNMCDs were manually added (copy/paste) to the CDFG database from the EPA 1:100k hydrography. Then, an ArcView Join and then a Convert to Shapefile command was used to join the CDFG database to 1:100k EPA hydrography using the PNMCD field as the common field. One stream (Easkoot Creek near Stinson Beach in Marin County) was added from the CDF 1:24 hydrography using a field that was manually added to both the CDFG database and CDF 1:24k hydrography. VITAL STATISTICS: Datum: NAD 27 Projection: UTM Units: Meters 1st Std. Parallel: 34 00 00 (34.0 degrees N) 2nd Std. Parallel: 40 30 00 (40.5 degrees N) Longitude of Origin: -120 00 00 (120.0 degrees W) Latitude of Origin: 00 00 00 (0.0 degrees) False Easting (X shift): 0 False Northing (Y shift): 0 Source: see notes above Data Structure: Vector (line) DATA DICTIONARY: NOTE: Items common to all ARC/INFO coverages: LENGTH, AREA, PERIMETER COVER_ (#), and COVER _ID (-ID) are not described here. Structure for attribute table Column Column Name 5 NAME 6 LLID 7 PNMCD 8 Arbit_ID 9 NOAA 10 Stream_Nam 11 Geo_region 12 Watershed1 13 Watershed2 14 Watershed3 15 Watershed4 16 PA_1988 17 PA_1989 18 PA_1990 19 PA_1991 20 PA_1992 21 PA_1993 22 PA_1994 23 PA_1995 24 PA_1996 25 PA_1997 26 PA_1998 27 PA_1999 28 PA_2000 29 PA_2001 30 PA_2002 31 Num_Sample 32 Num_Pres 33 Num_Abs 34 Pct_Pres 35 Pct_Abs 36 Pres_8802 37 NSamp_8899 38 Npres_8899 39 Nabs_8899 40 Ppres_8899 41 Pabs_8899 42 Pres_8899 43 NSamp_0002 44 Npres_0002 45 Nabs_0002 46 Ppres_0002 47 Pabs_0002 48 Pres_0022 49 GNIS 50 Brwn_Moyle 51 HAS 52 RBUAS 53 LLID 2 Column Name Description ----------- --------------------------------------------------------- NAME =Name of a stream, as it appears in the CDF 1:24,000 streams layer LLID =Unique ID stream code that links data to CDF 1:24,000 scale hydrography PNMCD =Unique ID stream code that links data to EPA 1:100,000 scale hydrography Arbit_ID =Arbitrary unique ID stream code that links the data for Easkoot Creek to CDF 1:24,000 scale hydrography NOAA =Unique ID in the CDFG database that links data to the NOAA Fisheries Database. This database is listed in north-south, upstream order Stream_Nam =Name of a stream, as it appears in the CDFG database Geo_region =Regions chosen to make KRIS charts Watershed1 =Largest watershed (other than Pacific Ocean) to which the stream drains Watershed2 =Tributary to which the stream drains before entering Watershed1 Watershed3 =Tributary to which the stream drains before entering Watershed2 Watershed4 =Tributary to which the stream drains before entering Watershed3 PA_1988 =For all surveys (vast majority of streams have only 1 survey per year) in the year 1988, were coho young-of-the-year found (P = presence) or were observed or collected (A = Absence). PA_1989 =Same as PA_1988, but for the year 1989 PA_1990 =Same as PA_1988, but for the year 1990 PA_1991 =Same as PA_1988, but for the year 1991 PA_1992 =Same as PA_1988, but for the year 1992 PA_1993 =Same as PA_1988, but for the year 1993 PA_1994 =Same as PA_1988, but for the year 1994 PA_1995 =Same as PA_1988, but for the year 1995 PA_1996 =Same as PA_1988, but for the year 1996 PA_1997 =Same as PA_1988, but for the year 1997 PA_1998 =Same as PA_1988, but for the year 1998 PA_1999 =Same as PA_1988, but for the year 1999 PA_2000 =Same as PA_1988, but for the year 2000 PA_2001 =Same as PA_1988, but for the year 2001 PA_2002 =Same as PA_1988, but for the year 2002 Num_Sample =Number of years between 1988-2002 have a P or A in the fields PA_1998 to PA_2002 Num_Pres =Number of years between 1988-2002 in which Coho YOY were present Num_Abs =Number of years between 1988-2002 in which Coho YOY were absent Pct_Pres =Percent of years surveyed in which Coho YOY were present Pct_Abs =Percent of years surveyed in which Coho YOY were absent Pres_8802 =For the years between 1988-2002 in which surveys were conducted, this whether coho YOY were present in some years ("Sometimes"), all years ("Always"), or never present ("Never") NSamp_8899 =Number of years between 1988-1999 have a P or A in the fields PA_1998 to PA_1999 Npres_8899 =Number of years between 1988-1999 in which Coho YOY were present Nabs_8899 =Number of years between 1988-1999 in which Coho YOY were absent Ppres_8899 =Percent of years surveyed in which Coho YOY were present Pabs_8899 =Percent of years surveyed in which Coho YOY were absent Pres_8899 =For the years between 1988-1999 in which surveys were conducted, this whether coho YOY were present in some years ("Sometimes"), all years ("Always"), or never present ("Never") NSamp_0002 =Number of years between 2000-2002 have a P or A in the fields PA_2000 to PA_2002 Npres_0002 =Number of years between 2000-2002 in which Coho YOY were present Nabs_0002 =Number of years between 2000-2002 in which Coho YOY were absent Ppres_0002 =Percent of years surveyed in which Coho YOY were present Pabs_0002 =Percent of years surveyed in which Coho YOY were absent Pres_0022 =For the years between 2000-2002 in which surveys were conducted, were coho YOY present in some years ("Sometimes"), all years ("Always"), or never present ("Never") GNIS =Geographic Names Information System code, an ID linking the data to the national GNIS register Brwn_Moyle =Indicates (Y/N) if a stream was on the list of Brown and Moyle streams HAS =Hydrologic Sub Area RBUAS =Code for the Hydrologic Sub Area LLID 2 =Unique ID stream code that links data to CDF 1:24,000 scale hydrography DATA QUALITY ASSESSMENT: This shapefile combines several sources (see coverage description). For accuracy about the spatial accuracy of the hydrography, see the metadata records for the hydrography layers (streams24, streams100). DFG's Harris told me that he knows of errors in the CDFG database that he has not yet been able to fix and requested that I inform people to treat this data cautiously because it is still in draft form (in will be updated later this year). Another error that could be present it that incorrect PNMCD and LLID be incorrect, causing the data for a stream to be attached to the wrong spatial feature.