Abstract:
This report contains water chemistry data, and provides additional context for the posted dataset, including information about the collection, analysis, and organization of the data. This data posting differs from other recently published datasets relating to the Gulf of Mexico in several respects: This Water Chemistry dataset focuses only on information related to petroleum-related chemical constituents in water samples. Chemical compounds that are not present in oil (such as polychlorinated biphenyls, pesticides, and halogenated volatiles) are not included in this dataset. This dataset includes data from independent studies performed by BP consultants. BP has been working to produce and organize these independent data, and has engaged outside consultants to perform quality assurance and quality control (QA/QC) checks. These data were initially made publically accessible in November 2013 and are updated with additional results in this publication to reflect the results of further QA/QC. This dataset combines results from fifty-four NRDA studies and thirteen Response studies to create a unified data file. Certain Response data have been reprocessed with lower analytical method detection limits (MDLs) than originally reported, and other data have been adjusted for surrogate recoveries as described in the documentation. The focus of this data posting is chemistry data associated with water column samples collected in both federal and state jurisdictional waters in the Gulf of Mexico from May 2010 through July 2012. More than 20,000 water samples with associated chemistry analyses collected at more than 6,300 sampling stations are included in this posting. These samples were collected during 67 studies, using more than 100 sampling cruises and surveys. These studies can be classified into four general categories: NRDA Cooperative—Studies conducted as part of the NRDA which were agreed to and executed cooperatively by the National Oceanic and Atmospheric Administration (NOAA), U.S. Department of Interior (DOI), and/or other Trustees, and BP. BP NRDA Independent—Studies conducted by BP independently to develop data to support and inform the NRDA. Trustee Independent—Studies conducted by NOAA, DOI, and/or other Trustees independently to develop data to support and inform the NRDA. Response (non-NRDA)—Studies conducted by BP and/or government representatives under the direction of the Unified Area Command and in association with activities performed in response to the DWH accident (the Response). The chemical parameters provided in this data posting include: Parent and alkylated polycyclic aromatic hydrocarbons (PAHs) Saturated hydrocarbons (SHC) Total petroleum hydrocarbons (TPH), including parameters reported as total extractable material (TEM) and total extractable hydrocarbon (TEH) Benzene, toluene, ethyl benzene, and xylenes (BTEX) and other volatile hydrocarbons classified as paraffins, isoparaffins, aromatics, naphthenes, and olefins (PIANO) Geochemical biomarkers (sterane and triterpane), where available. The chemical analyte lists are generally consistent between studies for the standard PAH, SHC, and BTEX compounds. However, portions of the dataset also include analysis of the extended PIANO volatile hydrocarbon list, TPH, or geochemical biomarkers. Additionally, NRDA PAH analyses include an extended list of parent and alkylated decalins, benzothiophenes, naphthobenzothiophenes, and several other PAHs and related chemicals that were not included in Response analyses. This dataset includes data associated with natural field samples for whole water and for Payne filter and filtrate pairs (Payne et al. 1999), along with the associated field-collected quality control samples, such as field replicates, equipment blanks, field blanks, and trip blanks. Laboratory duplicate sample data are provided, where available. Mississippi Canyon lease block 252 (MC252) control oils analyses associated with water chemistry analyses are provided separately from this data posting (see Version History). No other laboratory quality control samples (e.g., laboratory blanks and spike samples) are included in this data posting. Before posting, extensive work was done to verify some aspects of the posted information (e.g., positional coordinates and field data).
Suggested Citation:
BP Gulf Science Data. 2019. Chemistry data associated with water column samples collected in the Gulf of Mexico from May 2010 through July 2012. Distributed by: GRIIDC, Harte Research Institute, Texas A&M University–Corpus Christi. doi:10.7266/N747489X
Data Parameters and Units:
Data Publication Date = Date associated with the current data posting date (MM/DD/YYYY); Data Publication Reference = A general description of data provided in the data posting and a version control number; Study Reference Number = Study reference number (SRN) assigned by BP to provide a link between the data provided in the data file and the associated work plans and study descriptions; Study Name = The study name used by the original investigator or by NOAA. Related studies are also grouped together under a single harmonized group study name (the next column).Some independent BP studies have only a single harmonized study name. This study name may be referenced by some documentation and other data systems; Harmonized Study Name = A BP assigned name to a group of related sample collection efforts to aid with organization of the data. This name is part of the primary key of this table and is used within other documents provided by BP; Harmonized Cruise ID = A BP assigned name to a sampling cruise and coded as the name of the vessel, cruise sequence number, and date range of sample collection activities. This information is provided to aid with organization of the data and association of the chemistry data with other data types collected during each cruise; ASR Number = Analytical Request Form or Analytical Service Request number associated with dataset Not all samples have an ASR or related number; Location or Station ID = A name given to the location where samples were collected. Many samples were collected opportunistically in the field, targeting observed or suspected oil presence, and the locations were not assigned a name. Therefore, not all samples have a location ID; Interpretive = The identifier given to represent a unique combination of location, date (and time) and depth; Sample ID = This identifier is part of the primary key of this table; Sample Date = The date on which the sample was collected (MM/DD/YYYY); Sample Time = The time at which the sample was collected. Times were not recorded for all samples (HH:MM military time); Spatial Zone = Short coded descriptor to indicate general location of the samples. Seven zones have been assigned. Five zones are coded to capture water samples located within the state jurisdictional boundaries of Louisiana (LA), Alabama (AL), Mississippi (MS),Texas (TX) and Florida (FL). Two zones are coded to capture water sample located within the federal waters outside of the state jurisdictions. The code "Wellhead" is assigned to samples collected within a 10 nautical miles (nmi) radius of the DWH wellhead and the code "Federal" is assigned to samples collected beyond the 10 nmi radius; Latitude = The north latitude, in decimal degrees, where the sample was collected. This coordinate (with the corresponding longitude) may be either the specific location of the sample or the location assigned to the station where sampling was conducted. See the text for a discussion of sample coordinates and the selection of data from either the BP or Query Manager database systems; Longitude = The west longitude, in decimal degrees, where the sample was collected. See the description of the latitude column; Upper Depth = The upper depth of the sample in the water column (meters); Lower Depth = The lower depth of the sample in the water column (meters); Depth Unit = The units for sample upper and lower depths. Depth values for water samples are converted to meters as a rule; Field Fraction = Indicates whether the dissolved fraction, the particulate fraction, or the total sample was collected and submitted for analysis; Sample Type = Indicates whether the sample is a natural environmental sample, a field QC sample (i.e., a blank}, or a lab QC sample; Field Matrix = The most general description of the substance collected and submitted for analysis; Field Sample Material = The most specific description of the substance collected and submitted for analysis.Only the matrix is reported for samples with attributes taken from Query Manager; Analytical Sample ID = The client sample identifier given to a portion of the interpretive sample, or to the whole interpretive sample, when submitted to a laboratory for analysis. There may be one or several analytical sample IDs for each interpretive sample ID; Lab = The laboratory generating analytical chemistry data for the sample; Laboratory Sample ID = The internal laboratory sample identifier for the sample; SDG = The Sample Delivery Group: an identifier for a batch of samples (typically 20 samples) that are simultaneously prepared, analyzed, and reported by the laboratory; Lab Matrix = The most general description of the substance, or fraction thereof that is analyzed; Lab Material = The most specific description of the substance, or fraction thereof that is analyzed; Parameter Type = The basic group to which the chemical belongs: PAH, SHC, TPH, PIANO, biomarkers, and others; Chemical Name = The name of the chemical analyzed. An effort has been made to harmonize the chemical naming conventions, where possible. (Biomarkers (94 compounds); BTEX/PIANO (92 compounds); Other polynuclear aromatic hydrocarbons (PAH) (13 compounds); polynuclear aromatic hydrocarbons (PAH)/alkylated polynuclear aromatic hydrocarbons (aPAH) (68 compounds); saturated hydrocarbons (SHC) (37 compounds); total petroleum hydrocarbons (TPH) (5 types); total suspended solids (TSS) (1 analyte); benzene; toluene; ethylbenzene; xylene; paraffins; isoparaffins; aromatics; naphthenes; olefins;) Chemical Code = A standardized system-specific code to uniquely identify each chemical. Chemical codes are one-to-one homologous with chemical names; Chemical Type = Indicates whether the chemical is a target analyte or an added standard (e.g.,surrogate); Concentration - NDs at MDLs = The reported concentration of the chemical in the sample,or the detection limit for non-detect results (pct, ug/l, ug/sample); Concentration - NDs at Zero = The reported concentration of the chemical in the sample,or a zero value for non-detect results (pct, ug/l, ug/sample); Unit = The units of the associated concentration value; Final Qualifiers = The data qualifiers that should be used with the concentration value for data analysis and interpretation. This column may contain a packed string of the qualifiers "U", "J", "R", T', and "F", which are defined in the AQAP; Validation Qualifiers = Qualifiers applied by the data validation firm; Lab Qualifiers = The data qualifiers originally applied by the analytical laboratory; Nondetect Flag = Indicates whether or not the analyte was detected in a sample. This is equivalent to a final qualifier that includes "U"; Field Data Verification Status = Summary of the field data verification process status described in Appendix B. Valid entries - Not started, Underway,and Complete; Field Data Verification Result = Summary of the field data verification process results as described in Appendix B for samples which have a field data verification status of "Complete"; Validation Level = The type and amount of data validation performed; see the AQAP for a description of the validation levels used; Reporting Limit = The laboratory determined reporting limit associated with each chemical result; Method Detection Limit = The laboratory determined method detection limit associated with each chemical result; Measurement Basis = Indicates whether a concentration value is expressed in terms of the wet weight or dry weight of the environmental medium; Lab Fraction = Indicates whether the sample was filtered in the laboratory prior to analysis to obtain the dissolved fraction. This field does not capture information related to field filtration; Preparation Method = Method used to prepare the sample for analysis and as reported by the laboratory; Analytical Method = Method used to produce the measured concentration and as reported by the laboratory; Base Analytical Method = A generalization of the analytical method,standardized across laboratory-specific variations in the specific analytical method to aid the data user with categorizing samples by analysis type; Lab Replicate = Code to distinguish multiple measurements when all other identifying attributes are identical; Dilution Factor = The factor by which the sample was diluted for analysis; Date Extracted = The date that the sample was extracted at the laboratory (MM/DD/YYYY); Date Analyzed = The date that the sample was analyzed to produce the reported concentration (MM/DD/YYYY);
Methods:
EPA SW 8015B - Nonhalogenated Organics Using GC/FID; EPA SW 8015M - Total Saturated Hydrocarbons; EPA SW 8260B - Volatile Organic Compounds by GC/MS; EPA SW 8260M - PIANO Volatile Hydrocarbons; EPA SW 8270C SIM - Extended PAH (Parent and Alkyl Homologs) and Related Compounds by GC/MS-SIM; EPA SW 8270M - Alkylated PAH and Petroleum Biomarkers; SM 2540D - Total Suspended Solids; EPA SW 8260; EPA SW 8260B; Steranes and Triterpanes EPA SW 8270M SOP. 2247 Rev. 2; Steranes and Triterpanes EPA SW 8270M SOP. 2247 Rev. 4; Alkylated Polynuclear Aromatic Hydrocarbons EPA SW 8270M SOP. 2247 Rev. 4; Battelle SOP 5-157; Battelle SOP 5-202; EPA SW 8015; EPA SW 8270_SIM; EPA SW 8015B_MOD; EPA SW 8015C; EPA SW 8270C_MOD; EPA SW 8015B; EPA SW 3510C - Separatory funnel liquid-liquid extraction; EPA SW 3520C - Continuous liquid-liquid extraction; EPA SW 3541 - Automated Soxhlet extraction; EPA SW 5030B - Purge and trap for aqueous samples; EPA SW 8260M - PIANO volatile hydrocarbons; Alpha Analytical lab SOP 0P-013 - Shaker table extraction; B&B SOP1011 - Extraction of Water for Aliphatic, Aromatic, and Chlorinated Hydrocarbons; Battelle SOP 5-200; Battelle BDO 5-200; Battelle BDO 5-245; CAS (Columbia Analytical Services now ALS) -specific SOP; Alpha Analytical lab SOP 0P-013 - Shaker table extraction; EPA SW 3510C; EPA SW 3546; EPA SW 5030B; The quality guidance documents relevant to this study are the Analytical Quality Assurance Plan (U.S. Department of Commerce National Oceanic and Atmospheric Administration. 2014. Analytical Quality Assurance Plan Mississippi Canyon 252 (Deepwater Horizon) Natural Resource Damage Assessment Version 4.0. https://pub-dwhdatadiver.orr.noaa.gov/dwh-ar-documents/945/DWH-AR0101767.pdf) and the Deepwater Horizon Quality Assurance Project Plan (Gulf Coast Incident Management Team. 2011. Deepwater Horizon Quality Assurance Project Plan for the BP MC252 Incident Sample Management Group BP-MC252-QAPP.)
View Metadata