CALIFORNIA STATE MUSSEL WATCH MARINE BIOACCUMULATION MONITORING PROGRAM DATA BASE DESCRIPTION Revised MAY 1996 Revised By: DEL RASMUSSEN Monitoring and Assessment Unit Division of Water Quality State Water Resources Control Board 901 P Street, Sacramento 95814 TABLE OF CONTENTS I. INTENT 1 II. OVERVIEW 1 III. DESCRIPTION OF THE DATA BASE AND COMPUTER FILES 3 IV. COLUMNS (VARIABLES) IN THE DATA BASES 4 Supplementary Information 4 Additional Information on Analytical Variables 6 Address for Data Corrections 8 LIST OF TABLES Table 1. Contents of the Mussel Watch Data Bases 10 Table 2. Trace Element Tables in SMW 11 Table 3. Synthetic Organic Pesticide Tables in SMW 12 Table 4. PAH Tables in PCBSMW 13 Table 5. PCB Tables in PCBSMW 14 Table 6. Trace Element Replicate Table in METREP 16 Table 7. Supplementary Information Tables in SMW and PCBSMW 17 Table 8. Sample and Sample Species Types 18 Table 9. Conversion Formulae 19 Table 10. Codes for Regional Boards 19 DATA BASE DESCRIPTION CALIFORNIA STATE MUSSEL WATCH MARINE WATER QUALITY MONITORING PROGRAM I. INTENT The State Water Resources Control Board (State Board) has used the State Mussel Watch Program (Mussel Watch) since 1977 to help monitor California's coastal water quality. A large body of analytical information has been gathered and is available for review. While most users may prefer to review Mussel Watch results in written form, those with personal computer (PC) and data base program experience may wish to access a copy of the Mussel Watch data base directly. The goal of this document is to provide interested parties with background information on the structure of the data base used to store and manage Mussel Watch bioaccumulation results. For information on acquiring Mussel Watch results, use the address provided on Page 8. II. OVERVIEW Mussel Watch is an annual monitoring program run in cooperation with the Regional Water Quality Control Boards (Regional Boards). California Department of Fish and Game (DFG) staff perform field and laboratory work under contract with the State Board. Bivalve mollusk samples are transplanted and later collected (or collected directly using resident stock) from near-shore bay, harbor, estuary, and open coastal waters. Soft tissues from samples are analyzed for various trace element and synthetic organic pollutants which mollusks filter from surrounding waters. Resulting tissue concentrations indicate the presence or absence of those pollutants which tend to bioaccumulate in marine organisms, and provide a preliminary indication of the relative abundance of these substances in the marine environment. Mussel Watch is a sentinel program; it provides the State Board, other agencies, and the public with an early warning of higher than expected concentrations of pollutants at specific sites. Mussel Watch findings often lead to more intensive local follow-up studies for identifying sources of pollutants, and to cleanup and abatement orders and enforcement actions by the Regional Boards. Mussels and other bivalves are used in the Mussel Watch program because they are hardy, sessile, and because they accumulate certain pollutants in their tissues to levels higher than concentrations of the same substances in surrounding waters. This makes laboratory detection of these substances easier in mollusk tissues than in the water these animals originate in. Mussels are the most commonly used bivalve, as the name of the program suggests. Normally, California mussels (Mytilus californianus) are first collected from a relatively "clean" control area and then transplanted into the areas to be monitored. The mussels are suspended in nylon-mesh bags in shallow water (10-25 ft) at the monitoring site for several months, collected without contamination, and analyzed. Separate bags are used hold animals intended for trace element or for synthetic organic analyses. Mussels transplanted throughout most of the State are first collected at Bodega Head. However, mussels are also collected from Trinidad Head for use in monitoring Humboldt Bay, and from Montana de Oro State Park for use in the Diablo Canyon area. Mussels from either a trace element or organic sample bag are removed from their shells, blended into three conglomerates (for element samples) or one conglomerate (for organic samples), and prepared for analysis. For trace element samples, three separate sets of approximately 15 animals each are collected at each sample site or "station". For synthetic organic samples, one set of approximately 45 mussels is collected at each sample station. Shells and byssal threads are not included in any Mussel Watch analyses. For trace element samples, internal body parts, minus the gonads, are analyzed. For synthetic organic samples, all internal body parts are included for analysis. Tissue concentrations of trace elements are reported in parts per million (ppm), while concentrations of synthetic organic pollutants are reported in parts per billion (ppb). Results are determined on a dry weight basis (i.e., parts of pollutant per million/billion parts of all soft tissues, including moisture and lipids). These values are mathematically converted to concentrations in wet weight (parts of pollutant per million/billion parts of dried soft tissues) and lipid weight (parts of pollutant per billion parts of lipid [fat] tissue) bases using percent moisture and percent lipid values determined for each sample conglomerate. Lipid weight results are calculated only for samples analyzed for synthetic organic substances, because these substances tend to accumulate more readily in fatty tissues than trace elements. Tissue concentrations for a specific pollutant in a specific sample increase as results are converted from wet to dry and from wet to lipid weight bases. Freshwater clams (Corbicula fluminea) measuring 20-30 mm in length are collected at clean freshwater control areas, and transplanted to sample sites in estuaries where salinity is low and mussels cannot survive. Collection, processing, and analysis of clams are the same as with mussels, except that for trace elements analyses all internal parts of clams (including gonads) are included for analysis and for organic analyses 100 clams per sample are used. When transplantation is impossible or when transplanted samples are lost, an effort is made to collect resident animals at sample sites. Resident Bay mussels (Mytilus edulis) or resident California mussels are used. III. DESCRIPTION OF THE DATA BASE AND COMPUTER FILES The Mussel Watch data base is presently maintained using the commercial PC software R:Base (current version: R:Base 4.0). R:Base maintains the contents and supplemental information of a data base in just three PC files. File names for each data base file set have the form: "______1.rbf", "______2.rbf", or "______3.rbf" ("_______" stands for an exclusive name given the data base; e.g., "smw"). The second data base file ("______2.rbf") contains all of the actual alpha-numeric information for the data base, and can grow quite large. As structured by R:Base, each data base contains individual "tables" made up of columns (variables) and rows (cases) for organizing and displaying stored information. In the PC software dBASE data base tables would occupy linked but separate PC files. In R:Base, all tables in a data base are stored in a single, large file. Mussel Watch data base columns are repeated in various tables to organize results and for ease of data comparison. The primary data base tables containing Mussel Watch bioaccumulation results and important supplementary information are listed in Table 1. Column variables in each primary data table are listed in Tables 2 to 6. The "SMW" data base contains the synthetic organic pesticide (in wet [ORGWET], dry [ORGDRY], and lipid [ORGLIP] weight basis concentrations) (see Table 3) and the average (of three replicates) trace element (METWET, METDRY) results (Table 2). Two supplementary information tables, STATION and SAMPINFO, are also present (Table 7). The "PCBSMW" data base contains polychlorinated biphenyl (PCB) congener tissue concentrations (PCBWET2, PCBDRY2, PCBLIP2) (see Table 5), polynuclear aromatic hydrocarbon (PAH) concentrations (PAHWET, PAHDRY, PAHLIP) (Table 4), and the supplementary information tables (Table 7). The individual replicate results (dry wt.) for trace element analyses are stored in the "METREP" data base (table: METREP) (see Table 6). IV. COLUMNS (VARIABLES) IN THE DATA BASES Column names and descriptions for each primary data base table are listed in Tables 2 through 6. The type of R:Base variable (column name) is categorized as either TEXT (alpha-numeric characters, including spaces), REAL (decimal equivalents of real numbers only; the program may round off values), INTEGER (integers only), or DATE (e.g., 12/27/86 for December 27, 1986). The length for TEXT variables is the maximum number of characters allowed for the variable in the assigned field. REAL variables are automatically assigned a field length of 8; INTEGER variables a length of 10; DATE variables a length of 8. Supplementary Information The following column variables are used to list supplementary information about each sample. Variables numbered 1 through 9 are found in all data base tables containing analytical results. Variables labeled 10 through 14 are found in the special supplementary information tables SAMPINFO or STATION. 1. ID (Identification Number) - Each individual sample that is analyzed is given a unique I.D. number to identify it. Samples taken from the same station, but at different times, are given different I.D. numbers. Organic and element samples from the same location and time receive the same ID, unless the type of animal used differs, in which case separate ID numbers are assigned. ID provides the exclusive means to conclusively identify an individual sample for a particular site on a particular date for a particular sample species. For this reason, ID is used in all tables where analytical results are located. 2. STANUM (Sample Station Number) - Each station location where samples are collected is given a unique station number. Station numbers may be repeated within and among years, if more than one sample has been taken at a particular site. Station numbers generally run sequentially from north to south, but do not necessarily correspond to Region number. 3. STANAME (Sample Station Name) - Each station site is given a unique station name, usually based on a local landmark. Some station names are abbreviated to fit a 34 space field. Each Station Name is exclusively assigned to only one Station Number. 4. CDATE (Date Sample Collected) - The date that each sample was collected in the field is listed, as month, day year (MM/DD/YY). 5. YEAR (Year of Sample Collection) - A two digit code for the year (i.e., State Fiscal Year: July 1 to June 30) of collection is included. Fiscal Year 1977-78, for example, is YEAR 78. For archive ssamples, YEAR indicates the fiscal year analysis was performed. 6. SPECTYPE (Sample or Species Type) - Table 8 lists the types of sample species or sample types and the abbreviations used in the data base tables. SPECTYPE followed by "-a" indicate an archive sample. A small number of 1982-83 transplanted California mussel samples were experimentally depurated prior to analysis; SPECTYPE for these samples is identified by "TCM-d". Likewise, a small number of 1983-84 resident mussel samples were identified by "RCM-l", "RCM-s", or "RBM-s" when large or small shell sizes were experimentally used in those particular samples. 7. DURATION (Duration of Sample Transplantation) - For transplanted animals, the time in months between the date when the sample was deployed at the sampling site and the date when the sample was collected is listed. 8. PWATER_E, PWATER_O (Percent Moisture in Samples) - The percent of moisture in samples analyzed for trace elements or synthetic organic substances is listed. These values are useful for converting dry weight results to wet weight-based concentrations, using the formulae in Table 9 9. LENGTH_E, LENGTH_O (Average Shell Length) - The average length, in millimeters, is listed for the shells in each (trace element or synthetic organic) bivalve sample. LENGTH_O is calculated by measuring the lengths of 15 randomly selected animals in each sample. LENGTH_E is calculated by measuring the length of 15 randomly selected animals that are pooled from the first replicate value of each set of three values of each element sample. 10. PLIPID (Percent of Lipid [Fat] Materials in Sample Tissues) - For samples analyzed for synthetic organic pollutants the percent of lipid in the sample is listed. This value is used to calculate synthetic organic substance tissue concentrations on a lipid weight basis, using formulae contained in Table 9. Lipid weight values are calculated using wet weight data. 11. REGION (Regional Water Resources Control Board Code) - The number of the Regional Board in whose region a sample resides. Only regions whose boundaries include marine or estuarine areas are included. Table 10 lists the codes used. 12. COUNTY - The California coastal county where the station is located is listed. 13. LAT, LONG (Sample Latitude and Longitude) - The latitude and longitude of each station is listed. 14. YEAR78 - YEAR93 (Analytical Type by Year of Collection) - An indication of whether a trace element ("TE ") or synthetic organic substance (" SO") (or both (["TESO"]) analysis was performed in a particular sampling year is given in these columns. "ns" = Not Sampled. Additional Information on Analytical Variables Analytical variables are listed in Tables 2 to 6. Negative numbers are used as entries for analytical results under the following special circumstances: - 8.0 = Not Detected (The pollutant concentration was below the detection limit of the analytical test and instrumentation used). - 9.0 = Not Analyzed (An analysis for a particular substance was not performed for a particular sample.) Detection limits for each chemical may vary from year to year, and are listed in Mussel Watch reports. Four of the analytical variables are totals, and are defined here: Total of DDT Substances: TDDT = DDDOP + DDDPP + DDEOP + DDEPP + DDMSPP + DDMUPP + DDTOP + DDTPP Total of Chlordane Substances: TOTCL = ACDEN + GCDEN + CCDAN + TCDAN + CNONA + OCDAN + TNONA Total of PCB Arochlor Compounds: TPCB = PCB48 + PCB54 + PCB60 (sum of PCB aroclor concentrations) Total of Endosulfan Substances: TENDO = ENDO1 + ENDO2 + ENDOS Totals are calculated as follows: 1. When all compounds in a total listed above are present at levels above the detection limit, they are summed to calculate the total. 2. When some compounds in a total listed above are reported as less than the detection limit, the total is composed of only those compound values above the detection limit. 3. If all compounds in a total listed above are reported as less than the detection limit, the total is reported as not detected (-8.0). 4. If any of the compounds in a total listed above are reported as not analyzed, the total is reported as not analyzed (-9.0). Variable names for wet weight, dry weight, and lipid weight organic chemicals are distinguished by the suffices "_W", "_D", or "_L". Three trace element replicate samples are analyzed at each station and all three values are listed in the separate METREP data base. The mean value for each replicate triplet, which is the value actually reported in Mussel Watch reports, is calculated, as follows: 1. When all three replicate values exist, the arithmetic mean is calculated and reported. 2. When one or two replicate values are missing or not analyzed, the arithmetic mean of the two or one remaining values is calculated and reported. 3. When all three values are missing or not analyzed, the value is reported as not analyzed (-9.0). 4. When one or two replicate values are less than the detection limit, these values are set to zero, and the arithmetic mean of the three values, including the zero values, is calculated and reported. 5. When all three replicate values are less than the detection limit of the analytical test, the value is reported as not detected (-8.0). Address for Data Corrections The State Board staff would appreciate being notified of any errors in the Mussel Watch data base or resulting publications. Please address corrections to the: State Mussel Watch Program Manager Division of Water Quality State Water Resources Control Board P. O. Box 944213 Sacramento, CA 94244-2130. TABLE 1. CONTENTS OF THE MUSSEL WATCH DATA BASES. Data Tables in the Data Base SMW (trace elements and organic pesticides): Table Contents METWET average trace element (ppm, wet wgt) METDRY average trace element (ppm, dry wgt) ORGWET synthetic organic (ppb, wet wgt) ORGDRY synthetic organic (ppb, dry wgt) ORGLIP synthetic organic (ppb, lipid wgt) SAMPINFO supplemental sample information STATION sample station history Data Tables in the Data Base SMWPCB (PAHs and PCBs): Table Contents PAHWET PAH (ppb, wet wgt) PAHDRY PAH (ppb, dry wgt) PAHLIP PAH (ppb, lipid wgt) PCBWET2 PCB congeners (ppb, wet wgt) PCBDRY2 PCB congeners (ppb, dry wgt) PCBLIP2 PCB congeners (ppb, lipid wgt) SAMPINFO supplemental sample information STATION sample station history Data Tables in the Data Base METREP (Trace Element Analysis Replicant Results): Table Contents METREP individual trace element replicates (ppm, dry wgt) TABLE 2. CONTENTS OF TRACE ELEMENT AND TRIBUTYLTIN TABLES IN SMW DATA BASE. Tables: METWET, METDRY (trace element tissue concentrations) METWET METDRY Column Column # Name Name Type Length Contents 1. ID ID REAL 9 char sample ID number 2. STANUM STANUM REAL 9 char sample station number 3. STANAME STANAME TEXT 34 char sample station name 4. CDATE CDATE DATE 8 char date of collection 5. YEAR YEAR INTEGER 10 char sample year 6. SPECTYPE SPECTYPE TEXT 5 char type of sample 7. DURATION DURATION REAL 9 char transplant duration 8. PWATER_E PWATER_E REAL 9 char percent moisture 9. LENGTH_E LENGTH_E REAL 9 char average shell length (mm) 10. AG_W AG_D REAL 9 char silver (ppm) 11. AL_W AL_D REAL 9 char aluminum (ppm) 12. AS_W AS_D REAL 9 char arsenic (ppm) 13. CD_W CD_W REAL 9 char cadmium (ppm) 14. CR_W CR_D REAL 9 char chromium (ppm) 15. CU_W CU_D REAL 9 char copper (ppm) 16. HG_W HG_D REAL 9 char mercury (ppm) 17. MN_W MN_D REAL 9 char manganese (ppm) 18. NI_W NI_D REAL 9 char nickel (ppm) 19. PB_W PB_D REAL 9 char lead (ppm) 20. SE_W SE_D REAL 9 char selenium (ppm) 21. TI_W TI_D REAL 9 char titanium (ppm) 22. ZN_W ZN_D REAL 9 char zinc (ppm) TABLE 3. CONTENTS OF SYNTHETIC ORGANIC PESTICIDE TABLES IN SMW DATA BASE. Tables: ORGWET, ORGDRY, ORGLIP (pesticide tissue concentrations) ORGWET ORGDRY ORGLIP Column Column Column # Name Name Name Type Length Contents 1. ID ID ID REAL 9 char sample ID number 2. STANUM STANUM STANUM REAL 9 char sample station number 3. STANAME STANAME STANAME TEXT 34 char sample station name 4. CDATE CDATE CDATE DATE 8 char collection date 5. YEAR YEAR YEAR INTEGER 10 char sampling year 6. SPECTYPE SPECTYPE SPECTYPE TEXT 5 char sample type 7. DURATION DURATION DURATION REAL 9 char transplant duration 8. PWATER_O PWATER_O PWATER_O REAL 9 char percent moisture 9. LENGTH_O LENGTH_O LENGTH_O REAL 9 char average shell length (mm) 10. PLIPID PLIPID PLIPID REAL 9 char percent lipid 11. ALDRN_W ALDRN_D ALDRN_L REAL 9 char aldrin 12. CLBNS_W CLBNS_D CLBNS_L REAL 9 char chlorbenside 13. ACDEN_W ACDEN_D ACDEN_L REAL 9 char alpha-chlordene 14. CCDAN_W CCDAN_D CCDAN_L REAL 9 char cis-chlordane 15. GCDEN_W GCDEN_D GCDEN_L REAL 9 char gamma-chlordene 16. TCDAN_W TCDAN_D TCDAN_L REAL 9 char trans-chlordane 17. CNONA_W CNONA_D CNONA_L REAL 9 char cis-nonachlor 18. TNONA_W TNONA_D TNONA_L REAL 9 char trans-nonachlor 19. OCDAN_W OCDAN_D OCDAN_L REAL 9 char oxychlordane 20. TOTCL_W TOTCL_D TOTCL_L REAL 9 char total chlordane 21. CLPYR_W CLPYR_D CLPYR_L REAL 9 char chlorpyrifos 22. DACTH_W DACTH_D DACTH_L REAL 9 char dacthal 23. DDDOP_W DDDOP_D DDDOP_L REAL 9 char o,p'-DDD 24. DDDPP_W DDDPP_D DDDPP_L REAL 9 char p,p'-DDD 25. DDEOP_W DDEOP_D DDEOP_L REAL 9 char o,p'-DDE 26. DDEPP_W DDEPP_D DDEPP_L REAL 9 char p,p'-DDE 27. DDMSPP_W DDMSPP_D DDMSPP_L REAL 9 char p,p'-DDMS 28. DDMUPP_W DDMUPP_D DDMUPP_L REAL 9 char p,p'-DDMU 29. DDTOP_W DDTOP_D DDTOP_L REAL 9 char o,p'-DDT 30. DDTPP_W DDTPP_D DDTPP_L REAL 9 char p,p'-DDT 31. TDDT_W TDDT_D TDDT_L REAL 9 char total DDT 32. DIAZN_W DIAZN_D DIAZN_L REAL 9 char diazinon 33. DICLB_W DICLB_D DICLB_L REAL 9 char dichlorobenzide 34. DICOF_W DICOF_D DICOF_L REAL 9 char dicofol 35. DIELD_W DIELD_D DIELD_L REAL 9 char dieldrin 36. ENDO1_W ENDO1_D ENDO1_L REAL 9 char endosulfan I 37. ENDO2_W ENDO2_D ENDO2_L REAL 9 char endosulfan II 38. ENDOS_W ENDOS_D ENDOS_L REAL 9 char endosulfan sulfate 39. TENDO_W TENDO_D TENDO_L REAL 9 char total endosulfan 40. ENDRN_W ENDRN_D ENDRN_L REAL 9 char endrin 41. ETHION_W ETHION_D ETHION_L REAL 9 char ethion 42. HCHA_W HCHA_D HCHA_L REAL 9 char alpha HCH 43. HCHB_W HCHB_D HCHB_L REAL 9 char beta HCH 44. HCHD_W HCHD_D HCHD_L REAL 9 char delta HCH 45. HCHG_W HCHG_D HCHG_L REAL 9 char gamma HCH 46. HEP_W HEP_D HEP_L REAL 9 char heptachlor 47. HEPOX_W HEPOX_D HEPOX_L REAL 9 char heptachlor epoxide 48. HCB_W HCB_D HCB_L REAL 9 char hexachlorobenzene 49. MTHOX_W MTHOX_D MTHOX_L REAL 9 char methoxychlor 50. EPARA_W EPARA_D EPARA_L REAL 9 char ethylparathion 51. MPARA_W MPARA_D MPARA_L REAL 9 char methylparathion 52. PCP_W PCP_D PCP_L REAL 9 char pentachlorophenol 53. TCP_W TCP_D TCP_L REAL 9 char tetrachlorophenol 54. PHENOL_W PHENOL_D PHENOL_L REAL 9 char phenol 55. RONEL_W RONEL_D RONEL_L REAL 9 char ronel 56. TETRA_W TETRA_D TETRA_L REAL 9 char tetradifon TABLE 3 (cont'd). ORGWET ORGDRY ORGLIP Column Column Column # Name Name Name Type Length Contents 57. TOXAP_W TOXAP_D TOXAP_L REAL 9 char toxaphene 58. CHDEN_W CHDEN_D CHDEN_L REAL 9 char chlordene 59. OXADZN_W OXADZN_D OXADZN_L REAL 9 char oxadiazon 60. PCB48_W PCB48_D PCB48_L REAL 9 char PCB arochlor 1248 61. PCB54_W PCB54_D PCB54_L REAL 9 char PCB arochlor 1254 62. PCB60_W PCB60_D PCB60_L REAL 9 char PCB arochlor 1260 63. TPCB_W TPCB_D TPCB_L REAL 9 char total of PCB arochlors 64. PCT546_W PCT546_D PCT546_L REAL 9 char Polychlorinated Terphenyl 65. TBT_W TBT_D TBT_L REAL 9 char tributyltin TABLE 4. CONTENTS OF PAH TABLES IN PCBSMW DATA BASE. Tables: PAHWET, PAHDRY, PAHLIP (polynuclear aromatic hydrocarbon tissue concentrations) PAHWET PAHDRY PAHLIP Column Column Column # Name Name Name Type Length Contents 1. ID ID ID REAL 9 char sample ID number 2. STANUM STANUN STANUM REAL 9 char sample station number 3. STANAME STANAME STANAME TEXT 34 char sample station name 4. CDATE CDATE CDATE DATE 8 char collection date 5. YEAR YEAR YEAR INTEGER 10 char sampling year 6. SPECTYPE SPECTYPE SPECTYPE TEXT 5 char sample type 7. DURATION DURATION DURATION REAL 9 char transplant duration 8. PWATER_O PWATER_O PWATER_O REAL 9 char percent moisture 9. LENGTH_O LENGTH_O LENGTH_O REAL 9 char average shell length (mm) 10. PLIPID PLIPID PLIPID REAL 9 char percent lipid 11. TPAH_W TPAH_D TPAH_L REAL 9 char total PAHs 12. ANTH_W ANTH_D ANTH_L REAL 9 char anathracene 13. ANTHA_W ANTHA_D ANTHA_L REAL 9 char benzo [a] anathracene 14. ANTHAH_W ANTHAH_D ANTHAH_L REAL 9 char dibenz [a,h] anthracene 15. BIPHEN_W BIPHEN_D BIPHEN_L REAL 9 char biphenyl 16. CHRYSN_W CHRYSN_D CHRYSN_L REAL 9 char chrysene 17. FLRA_W FLRA_D FLRA_L REAL 9 char fluoranthene 18. FLRABB_W FLRABB_D FLRABB_L REAL 9 char benzo [b] fluoranthene 19. FLRABK_W FLRABK_D FLRABK_L REAL 9 char benzo [k] fluoranthane 20. FLUORE_W FLUORE_D FLUORE_L REAL 9 char fluorene 21. NAP_W NAP_D NAP_L REAL 9 char naphthalene 22. NAP1_W NAP1_D NAP1_L REAL 9 char 1-methylnaphthalene 23. NAP2_W NAP2_D NAP2_L REAL 9 char 2-methylnaphthalene 24. NAP26_W NAP26_D NAP26_L REAL 9 char 2,6-dimethylnaphthalene 25. NAP235_W NAP235_D NAP235_L REAL 9 char 2,3,5-trimethylnaphthalene 26. NAPHEN_W NAPHEN_D NAPHEN_L REAL 9 char acenaphthene 27. NAPHYL_W NAPHYL_D NAPHYL_L REAL 9 char acenaphthylene 28. PERY_W PERY_D PERY_L REAL 9 char perylene 29 PERYGH_W PERYGH_D PERYGH_L REAL 9 char benzo [g,h,i] perylene 30. PHENA_W PHENA_D PHENA_L REAL 9 char phenanthrene 31. PHENA1_W PHENA1_D PHENA1_L REAL 9 char 1-methylphenanthrene 32. PYRE_W PYRE_D PYRE_L REAL 9 char pyrene 33. PYREBA_W PYREBA_D PYREBA_L REAL 9 char benzo [a] pyrene 34. PYREBE_W PYREBE_D PYREBE_L REAL 9 char benzo [e] pyrene 35. PYREIN_W PYREIN_D PYREIN_L REAL 9 char indeno [1,2,3-c,d] pyrene 36. NOTE: NOTE: NOTE: TEXT 40 char notes concerning analyses TABLE 5. CONTENTS OF PCB TABLES IN PCBSMW DATA BASE. Tables: PCBWET2, PCBDRY2, PCBLIP2 (polychlorinated biphenyl congener tissue concentrations) PCBWET2 PCBDRY2 PCBLIP2 Column Column Column # Name Name Name Type Length Contents 1. ID ID ID REAL 9 char sample ID number 2. STANUM STANUM STANUM REAL 9 char sample station number 3. STANAME STANAME STANAME TEXT 34 char sample station name 4. CDATE CDATE CDATE DATE 8 char collection date 5. YEAR YEAR YEAR INTEGER 10 char sample year 6. SPECTYPE SPECTYPE SPECTYPE TEXT 5 char sample type 7. DURATION DURATION DURATION REAL 9 char transplant duration 8. PWATER_O PWATER_O PWATER_O REAL 9 char percent moisture (organic) 9. LENGTH_O LENGTH_O LENGTH_O REAL 9 char average shell length (mm) 10. PLIPID PLIPID PLIPID REAL 9 char percent lipid 11. PCB5_W PCB5_D PCB5_L REAL 9 char PCB congener # 5 12. PCB6_W PCB6_D PCB6_L REAL 9 char PCB congener # 6 13. PCB7_W PCB7_D PCB7_L REAL 9 char PCB congener # 7 14. PCB8_W PCB8_D PCB8_L REAL 9 char PCB congener # 8 15. PCB15_W PCB15_D PCB15_L REAL 9 char PCB congener # 15 16. PCB16_W PCB16_D PCB16_L REAL 9 char PCB congener # 16 17. PCB18_W PCB18_D PCB18_L REAL 9 char PCB congener # 18 18. PCB19_W PCB19_D PCB19_L REAL 9 char PCB congener # 19 19. PCB22_W PCB22_D PCB22_L REAL 9 char PCB congener # 22 20. PCB25_W PCB25_D PCB25_L REAL 9 char PCB congener # 25 21. PCB26_W PCB26_D PCB26_L REAL 9 char PCB congener # 26 22. PCB27_W PCB27_D PCB27_L REAL 9 char PCB congener # 27 23. PCB28_W PCB28_D PCB28_L REAL 9 char PCB congener # 28 24. PCB29_W PCB29_D PCB29_L REAL 9 char PCB congener # 29 25. PCB31_W PCB31_D PCB31_L REAL 9 char PCB congener # 31 26. PCB33_W PCB33_D PCB33_L REAL 9 char PCB congener # 33 27. PCB40_W PCB40_D PCB40_L REAL 9 char PCB congener # 40 28. PCB41_W PCB41_D PCB41_L REAL 9 char PCB congener # 41 29. PCB44_W PCB44_D PCB44_L REAL 9 char PCB congener # 44 30. PCB45_W PCB45_D PCB45_L REAL 9 char PCB congener # 45 31. PCB46_W PCB46_D PCB46_L REAL 9 char PCB congener # 46 32. PCB47_W PCB47_D PCB47_L REAL 9 char PCB congener # 47 33. PCB49_W PCB49_D PCB49_L REAL 9 char PCB congener # 49 34. PCB52_W PCB52_D PCB52_L REAL 9 char PCB congener # 52 35. PCB56_W PCB56_D PCB56_L REAL 9 char PCB congener # 56 36. PCB59_W PCB59_D PCB59_L REAL 9 char PCB congener # 59 37. PCB63_W PCB63_D PCB63_L REAL 9 char PCB congener # 63 38. PCB66_W PCB66_D PCB66_L REAL 9 char PCB congener # 66 39. PCB67_W PCB67_D PCB67_L REAL 9 char PCB congener # 67 40. PCB70_W PCB70_D PCB70_L REAL 9 char PCB congener # 70 41. PCB74_W PCB74_D PCB74_L REAL 9 char PCB congener # 74 42. PCB77_W PCB77_D PCB77_L REAL 9 char PCB congener # 77 43. PCB82_W PCB82_D PCB82_L REAL 9 char PCB congener # 82 44. PCB83_W PCB83_D PCB83_L REAL 9 char PCB congener # 83 45. PCB84_W PCB84_D PCB84_L REAL 9 char PCB congener # 84 46. PCB87_W PCB87_D PCB87_L REAL 9 char PCB congener # 87 47. PCB89_W PCB89_D PCB89_L REAL 9 char PCB congener # 89 48. PCB91_W PCB91_D PCB91_L REAL 9 char PCB congener # 91 49. PCB96_W PCB96_D PCB96_L REAL 9 char PCB congener # 96 50. PCB97_W PCB97_D PCB97_L REAL 9 char PCB congener # 97 51. PCB99_W PCB99_D PCB99_L REAL 9 char PCB congener # 99 52. PCB101_W PCB101_D PCB101_L REAL 9 char PCB congener # 101 53. PCB105_W PCB105_D PCB105_L REAL 9 char PCB congener # 105 54. PCB107_W PCB107_D PCB107_L REAL 9 char PCB congener # 107 55. PCB110_W PCB110_D PCB110_L REAL 9 char PCB congener # 110 56. PCB114_W PCB114_D PCB114_L REAL 9 char PCB congener # 114 57. PCB118_W PCB118_D PCB118_L REAL 9 char PCB congener # 118 58. PCB122_W PCB122_D PCB122_L REAL 9 char PCB congener # 122 59. PCB126_W PCB126_D PCB126_L REAL 9 char PCB congener # 126 TABLE 5 (cont'd). PCBWET2 PCBDRY2 PCBLIP2 Column Column Column # Name Name Name Type Length Contents 60. PCB128_W PCB128_D PCB128_L REAL 9 char PCB congener # 128 61. PCB129_W PCB129_D PCB129_L REAL 9 char PCB congener # 129 62. PCB134_W PCB134_D PCB134_L REAL 9 char PCB congener # 134 63. PCB135_W PCB135_D PCB135_L REAL 9 char PCB congener # 135 64. PCB136_W PCB136_D PCB136_L REAL 9 char PCB congener # 136 65. PCB137_W PCB137_D PCB137_L REAL 9 char PCB congener # 137 66. PCB138_W PCB138_D PCB138_L REAL 9 char PCB congener # 138 67. PCB141_W PCB141_D PCB141_L REAL 9 char PCB congener # 141 68. PCB146_W PCB146_D PCB146_L REAL 9 char PCB congener # 146 69. PCB149_W PCB149_D PCB149_L REAL 9 char PCB congener # 149 70. PCB151_W PCB151_D PCB151_L REAL 9 char PCB congener # 151 71. PCB153_W PCB153_D PCB153_L REAL 9 char PCB congener # 153 72. PCB156_W PCB156_D PCB156_L REAL 9 char PCB congener # 156 73. PCB158_W PCB158_D PCB158_L REAL 9 char PCB congener # 158 74. PCB170_W PCB170_D PCB170_L REAL 9 char PCB congener # 170 75. PCB172_W PCB172_D PCB172_L REAL 9 char PCB congener # 172 76. PCB173_W PCB173_D PCB173_L REAL 9 char PCB congener # 173 77. PCB174_W PCB174_D PCB174_L REAL 9 char PCB congener # 174 78. PCB176_W PCB176_D PCB176_L REAL 9 char PCB congener # 176 79. PCB177_W PCB177_D PCB177_L REAL 9 char PCB congener # 177 80. PCB179_W PCB179_D PCB179_L REAL 9 char PCB congener # 179 81. PCB180_W PCB180_D PCB180_L REAL 9 char PCB congener # 180 82. PCB183_W PCB183_D PCB183_L REAL 9 char PCB congener # 183 83. PCB185_W PCB185_D PCB185_L REAL 9 char PCB congener # 185 84. PCB187_W PCB187_D PCB187_L REAL 9 char PCB congener # 187 85. PCB189_W PCB189_D PCB189_L REAL 9 char PCB congener # 189 86. PCB191_W PCB191_D PCB191_L REAL 9 char PCB congener # 191 87. PCB193_W PCB193_D PCB193_L REAL 9 char PCB congener # 193 88. PCB194_W PCB194_D PCB194_L REAL 9 char PCB congener # 194 89. PCB195_W PCB195_D PCB195_L REAL 9 char PCB congener # 195 90. PCB196_W PCB196_D PCB196_L REAL 9 char PCB congener # 196 91. PCB197_W PCB197_D PCB197_L REAL 9 char PCB congener # 197 92. PCB198_W PCB198_D PCB198_L REAL 9 char PCB congener # 198 93. PCB199_W PCB199_D PCB199_L REAL 9 char PCB congener # 199 94. PCB201_W PCB201_D PCB201_L REAL 9 char PCB congener # 201 95. PCB205_W PCB205_D PCB205_L REAL 9 char PCB congener # 205 96. PCB206_W PCB206_D PCB206_L REAL 9 char PCB congener # 206 97. PCB207_W PCB207_D PCB207_L REAL 9 char PCB congener # 207 TABLE 6. CONTENTS OF TRACE ELEMENT REPLICATE TABLE IN METREP DATA BASE. Table: METREP (replicate data for trace element samples) Replicate 2 Replicate 3 Column Column Column # Name Name Name Type Length Contents 1. ID REAL 9 char sample ID number 2. STANUM REAL 9 char sample station number 3. STANAME TEXT 34 char sample station name 4. CDATE DATE 8 char collection date 5. YEAR INTEGER 10 char sample year 6. SPECTYPE TEXT 5 char sample type 7. AG1 AG2 AG3 REAL 9 char silver (ppm, dry wgt) 10. AL1 AL2 AL3 REAL 9 char aluminum (ppm, dry wgt) 13. AS1 AS2 AS3 REAL 9 char arsenic (ppm, dry wgt) 16. CD1 CD2 CD3 REAL 9 char cadmium (ppm. dry wgt) 19. CR1 CR2 CR3 REAL 9 char chromium (ppm, dry wgt) 22. CU1 CU2 CU3 REAL 9 char copper (ppm, dry wgt) 25. HG1 HG2 HG3 REAL 9 char mercury (ppm, dry wgt) 28. MN1 MN2 MN3 REAL 9 char manganese (ppm, dry wgt) 31. NI1 NI2 NI3 REAL 9 char nickel (ppm, dry wgt) 34. PB1 PB2 PB3 REAL 9 char lead (ppm, dry wgt) 37. SE1 SE2 SE3 REAL 9 char selenium (ppm, dry wgt) 40. TI1 TI2 TI3 REAL 9 char titanium (ppm, dry wgt) 43. ZN1 ZN2 ZN3 REAL 9 char zinc (ppm, dry wgt) TABLE 7. CONTENTS OF SUPPLEMENTARY INFORMATION TABLES IN THE SMW AND PCBSMW DATA BASES. Table: STATION (sample station information and analyses types by year) Column # Name Type Length Contents 1. STANUM REAL 9 char sample station number 2. STANAME TEXT 34 char sample station name 3. STANAM_O TEXT 31 char orginal sample station name 4. REGION INTEGER 10 char sample region 5. COUNTY TEXT 20 char sample county 6. LAT TEXT 8 char sample latitude 7. LONG TEXT 9 char sample longitude 8. year78 TEXT 5 char 1977-78 analysis type(s) 9. year79 TEXT 5 char 1978-79 analysis type(s) 10. year80 TEXT 5 char 1979-80 analysis type(s) 11. year81 TEXT 5 char 1980-81 analysis type(s) 12. year82 TEXT 5 char 1981-82 analysis type(s) 13. year83 TEXT 5 char 1982-83 analysis type(s) 14. year84 TEXT 5 char 1983-84 analysis type(s) 15. year85 TEXT 5 char 1984-85 analysis type(s) 16. year86 TEXT 5 char 1985-86 analysis type(s) 17. year87 TEXT 5 char 1986-87 analysis type(s) 18. year88 TEXT 5 char 1987-88 analysis type(s) 19. year89 TEXT 5 char 1988-89 analysis type(s) 20. year90 TEXT 5 char 1989-90 analysis type(s) 21. year91 TEXT 5 char 1990-91 analysis type(s) 22. year92 TEXT 5 char 1991-92 analysis type(s) 23. year93 TEXT 5 char 1992-93 analysis type(s) Table: SAMPINFO (individual sample information) Column # Name Type Length Contents 1. ID REAL 9 char sample identification number 2. STANUM REAL 9 char sample station number 3. STANAME TEXT 34 char sample station name 4. REGION INTEGER 10 char sample region 5. COUNTY TEXT 20 char sample county 6. ANALYSES TEXT 4 char analysis type(s) 7. CDATE DATE 8 char sample date 8. YEAR INTEGER 10 char sample year 9. SPECTYPE TEXT 5 char sample type 10. DURATION REAL 9 char sample duration 11. PWATER_E REAL 9 char percent moisture (element) 12. PWATER_O REAL 9 char percent moisture (organic) 13. LENGTH_E REAL 9 char average shell length (element) (mm) 14. LENGTH_O REAL 9 char average shell length (organic) (mm) 15. PLIPID REAL 9 char percent lipid TABLE 8. SAMPLE AND SAMPLE SPECIES TYPES COLLECTED BY MUSSEL WATCH PROGRAM Type Description Commonly Collected: RCM Resident California mussel (Mytilus californianus) TCM Transplanted California mussel RBM Resident Bay mussel (Mytilus edulis) TFC Transplanted freshwater clam (Corbicula fluminea) RFC Resident freshwater clam Rarely Collected: BNC Bentnose clam (Macoma nasuta) (1983-84 only) H2O water sample LNC Littleneck clam (Protothaca sp.) (1983-84 only) OYS Oyster (Crassostrea gigas) (1983-85 only) SED sediment sample TABLE 9. CONVERSION FORMULAE FOR WET, DRY, ANDLIPID WEIGHT-BASED POLLUTANT CONCENTRATIONS. Conversion: Formula: wet to dry W * 100 = D 100 - PWATER* wet to lipid* W * 100 = L PLIPID dry to wet D * 100 - PWATER* = W 100 dry to lipid D * 100 - PWATER* = L PLIPID - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Key: D = tissue concentration on a dry-weight basis W = tissue concentration on a wet-weight basis L = tissue concentration on a lipid-weight basis PWATER = percent of moisture in sample PLIPID = percent of lipid in sample * This formula is used to calculate lipid weight data TABLE 10. CODES FOR REGIONAL BOARDS 1 = North Coast Regional Board 2 = San Francisco Bay Regional Board 3 = Central Coast Regional Board 4 = Los Angeles Regional Board 5 = Central Valley Regional Board 8 = Santa Ana Regional Board 9 = San Diego Regional Board ?? State Mussel Watch Program Data Base Description - Page 19 of 19 - Page 1 of 19