# DOCUMENTATION TEMPLATE - doc_temp_long.doc # # Dataset_Name: CO_voc_radchem.xls # Dataset_Description: # This dataset is a product of the U.S. Geological Survey's # National Water-Quality Assessment (NAWQA) program. # # Identification_Information: # # Point_of_Contact: # Name: Terri Arnold # NAWQA_Study: Regional Ground-Water Trends: Cambrian-Ordovician # Aquifer # Office_Name: USGS-WRD, Illinois District # IL_Office Address: 221 North Broadway Avenue, Urbana, IL 61801 # IL_Telephone_Number:(217) 344-0037 # IL_FAX_Number: (217) 344-0082 # Email_Address: tlarnold@usgs.gov # World_Wide_Web_URL: http://il.water.usgs.gov/nawqa/uirb/camord/index.html # # Citation: # Originator: Terri Arnold # Title: Cambrian-Ordovician Aquifer # VOCs, radionuclides, # stable isotopes, and dissolved organic carbon # data # Edition: 1 # Publication_Information: # Publication_Date: 06/02/2004 # Other_Citation_Details: Data retrieved from NAWQA Internal Data # Warehouse 05/20/2004 # # Data_Format: (give references for all that apply) # World_Wide_Web_URL: http://il.water.usgs.gov/nawqa/uirb/camord/index.html # Online_Linkage: ftp://ftpdilurb.er.usgs.gov/pub/arnold/vocradchem.zip # # # Native_Data_Set_Environment: # Operating_System: Windows 2000 # Source_Software: ASCII text and Microsoft Excel 2000 # # Description_of_dataset: # # Abstract: This data set contains ground-water VOC, radionuclides, # stable isotopes, and dissolved organic carbon data retrieved # from the NAWQA Internal Data Warehouse on May 20, 2004. # The data will be used in a series of reports to characterize # the Cambrian-Ordovician Principal Aquifer as part # of the U.S. Geological Survey, National Water-Quality Assessment # Program. # # # Spatial_Domain_Descriptor: # Bounding_Coordinates: # West_Bounding_Coordinate: -166.27384949 # East_Bounding_Coordinate: -51.99280167 # North_Bounding_Coordinate: 83.55232239 # South_Bounding_Coordinate: 37.61368942 # # Time_Period_of_content: # Currentness_Reference: May 20, 2004 # # Keywords: # NAWQA_Program_Component: Cambrian-Ordovician # Regional Princial Aquifer # Ground-Water Trends # Theme_Keywords: Ground water # Theme_Keywords: Cambrian-Ordovician Aquifer # Theme_Keywords: VOCs # Theme_Keywords: Volatile Organic Compounds # Theme_Keywords: Radionuclides # Theme_Keywords: Stable Isotopes # Theme_Keywords: Dissolved Organic Carbon # Place_Keywords: Northern United States # # Supplemental_Information: # # Procedures_Used: # Process_Step: # The data was retrieved from the NAWQA Internal Data Warehouse # May 20, 2004. The Conditions used to retrieve the data are as follows: # # Pre-set Data Warehouse conditions used for retrieving data: # 1) Eliminate 'V' Coded data # 2) Groundwater Chemical Environmental Data # 3) Groundwater Sites Only # 4) GW POSV Patch Last Value of Day # 5) Remove 'Set Number' and 'Surrogate' from the search # # Additional Conditions for Cambrian-Ordovician aquifer wells: # Select SUCODES and create DECODE calculation to only select # wells that were determined by the Glacial Aquifer Planning Team to # be sampling from the Cambrian-Ordovician Aquifer # (based on lithology and knowledge of NAWQA study unit teams) # # Su Code IN ('umissus3', 'umissus4', 'wmicsus1') # # Select PCODES to retrieve Volatile organic compound, radionuclide, # and stable isotope data (These are PCODES from schedules 2090, 2020, # sch 82082, 82085, 01262, 01263, 09511, 82303), DOC (sch. 00681) # # vocs schedules 2090, 2020 # PCODE IN ('30217','32101','32102','32103','32104','32105','32106', # '34010','34030','34215','34301','34311','34371','34396','34413', # '34418','34423','34475','34488','34496','34501','34506','34511', # '34516','34536','34541','34546','34551','34566','34571','34668', # '34696','34699','34704','39175','39180','39702','49991','49999', # '50000','50002','73547','73570','77041','77093','77103','77128', # '77135','77168','77170','77173','77220','77221','77222','77223', # '77224','77226','77275','77277','77297','77342','77350','77353', # '77356','77424','77443','77562','77613','77651','77652','78109', # '78133','81551','81555','81576','81593','81595','81597','81607', # '82625','85795','99871') # # radchem, stable isotopes (sch 82082, 82085, 01262, 01263, 09511, # 82303), DOC (sch. 00681) # PCODE IN ('50004','50005','78032','81552','81577','99827','99832', # '99833','99834','62835','77032','77035','77073','00681','82082', # '82085','01262','01263','09511','82303') # # Create DECODE calculation to assign REGIONs according to the Glacial # Aquifer stratification: # DECODE(SUID,'LERI','CENTRAL','LIRB','CENTRAL','MIAM','CENTRAL', # 'UIRB','CENTRAL','WHIT','CENTRAL','WHMI','CENTRAL','WMIC','CENTRAL', # 'ALMN','EAST','CONN','EAST','DELR','EAST','HDSN','EAST','NECB','EAST', # 'LINJ','EAST','EIWA','WEST','HPGW','WEST','REDN','WEST','UMIS','WEST', # 'PUGT','FAR WEST','COOK','FAR WEST','CCYK','FAR WEST','CNBR','WEST') # # Selected items for display: # Net Sites # Su Code # Geographic Places # Suid # Staid # Samples # Sample Id # Results # Result Datetime # Remrk (Detail) # Value (Detail) # Parameters # Parameter Code # Parameter Code Nmae # Report Units # # Process_Step: # Some wells had more than one line of data - some on the same date. # The 'GW POSV Patch Last Value of Day' condition took care of most of # these situations; however, some still remained. For statistical # analysis, only one line of data per well was desired. To get one line # of data per well, multiple lines of data for the same well were # combined into one line as follows: # 1) Select most recent sample or sample with most data on one line to # keep # 2) If data is missing in the sample you chose to keep but is available # from another sample for the same well, copy it from the other # sample and paste it in the sample you chose to keep. # # After the lines were combined, then the un-needed line was deleted. # After all wells only had one line of data then the sample data and # sample number columns were deleted. These lines were no longer # accurate since the samples were combined into one line. # # Process_Step: # The data retrieved had muliple censoring levels for most constituents. # Censored data is indicated by a '<' or '>' in the remark column # (remark columns begin with a 'R_' in the final data set.) Due to # the large number of censored values, it was determined by those # team members that would use the VOC data that the censored values # would not be treated in this data set. # Individual studies will be responsible for treating the censored # values or for using them to indicate percent detection. # # Revisions: # Reviews_Applied_to_Data: This data has not been reviewed # Related_Spatial_and_Tabular_Data_Sets: # CO_voc_radchem_raw.txt (the raw data as retrieved from # NAWQA data warehouse bfore editing) # CO_staids.txt (list of staids in Cambrian-Ordovician Aquifer # including information about well depth, # primary aquifer, lithology, and region) # NYNE_voc_radchem.xls and NYNE_voc_radchem.txt (VOC, radionuclide, # stable isotope, and dissolved organic carbon data for the # New York-New England Crystalline Aquifer) # GLAC_voc_radchem.xls and GLAC_voc_radchem_raw.txt (VOC, # radionuclide, stable isotope, and dissolved organic carbon # data for the Glacial Aquifer) # Other_References_Cited: # Notes: # # Status: # Progress: Complete # Maintenance_and_Update_Frequency: none planned # # Cross_Reference: None # # Data_Quality_Information: # Completeness_Report: Complete as of date when data was pulled # from NAWQA data warehouse # # Basic documentation of dataset elements and history # # Entity_and_Attribute_Overview: # # Attributes: # Column head, description # principal_aq, Principal Aquifer abbreviation. CO=Cambrian-Ordovician # aquifer # Regions, region designation from Glacial aquifer stratification # Suid, NAWQA study unit ID # Su Code, NAWQA study unit code indicating with ground-water network # the well is part of. # Su Code Alt 1, NAWQA study unit code indicating with ground-water network # the well is part of. Will only be filled in if well is in more than one # network. # Su Code Alt 2, NAWQA study unit code indicating with ground-water network # the well is part of. Will only be filled in if well is in more than two # networks. # Staid, USGS well identification number (station ID) # R_PCODE, Columns whose title begins with an 'R_' prefixed to the PCODE # contain the remarks about the sample value (example column # title R_01106). # '<' indicates 'less than' the detextion limit (a censored value) # '>' indicates 'greater than', # 'E' indicates an estimated value # '-' indicates no remark # PPCODE, Columns whose title begins with a 'P' prefixed to the PCODE # (example column title P90410) contain the original sample value # before censored values were treated. # # List of parameter codes and their descriptions: # Parameter Code Parameter Name # 34496 1_1-Dichloroethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 34501 1_1-Dichloroethene_ water_ unfiltered_ recoverable_ # micrograms per liter # 77168 1_1-Dichloropropene_ water_ unfiltered_ recoverable_ # micrograms per liter # 34506 1_1_1-Trichloroethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 77562 1_1_1_2-Tetrachloroethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 77652 1_1_2-Trichloro-1_2_2-trifluoroethane_ water_ unfiltered_ # recoverable_ micrograms per liter # 34511 1_1_2-Trichloroethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 34516 1_1_2_2-Tetrachloroethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 82625 1_2-Dibromo-3-chloropropane_ water_ unfiltered_ recoverable_ # micrograms per liter # 77651 1_2-Dibromoethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 34536 1_2-Dichlorobenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 32103 1_2-Dichloroethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 34541 1_2-Dichloropropane_ water_ unfiltered_ recoverable_ # micrograms per liter # 77613 1_2_3-Trichlorobenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 77443 1_2_3-Trichloropropane_ water_ unfiltered_ recoverable_ # micrograms per liter # 77221 1_2_3-Trimethylbenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 49999 1_2_3_4-Tetramethylbenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 50000 1_2_3_5-Tetramethylbenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 34551 1_2_4-Trichlorobenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 77222 1_2_4-Trimethylbenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 34566 1_3-Dichlorobenzene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77173 1_3-Dichloropropane_ water_ unfiltered_ recoverable_ micrograms # per liter # 77226 1_3_5-Trimethylbenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 34571 1_4-Dichlorobenzene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77275 2-Chlorotoluene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77220 2-Ethyltoluene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77170 2_2-Dichloropropane_ water_ unfiltered_ recoverable_ micrograms # per liter # 78109 3-Chloropropene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77277 4-Chlorotoluene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77356 4-Isopropyltoluene_ water_ unfiltered_ recoverable_ micrograms # per liter # 81552 Acetone_ water_ unfiltered_ recoverable_ micrograms per liter # 34215 Acrylonitrile_ water_ unfiltered_ recoverable_ micrograms # per liter # 34030 Benzene_ water_ unfiltered_ recoverable_ micrograms per liter # 81555 Bromobenzene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77297 Bromochloromethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 32101 Bromodichloromethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 50002 Bromoethene_ water_ unfiltered_ recoverable_ micrograms # per liter # 34413 Bromomethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 77041 Carbon disulfide_ water_ unfiltered_ micrograms per liter # 34301 Chlorobenzene_ water_ unfiltered_ recoverable_ micrograms # per liter # 34311 Chloroethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 34418 Chloromethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 82082 Deuterium/Protium ratio_ water_ unfiltered_ per mil # 32105 Dibromochloromethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 30217 Dibromomethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 34668 Dichlorodifluoromethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 34423 Dichloromethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 81576 Diethyl ether_ water_ unfiltered_ recoverable_ micrograms per # liter # 81577 Diisopropyl ether_ water_ unfiltered_ recoverable_ micrograms # per liter # 73570 Ethyl methacrylate_ water_ unfiltered_ recoverable_ micrograms # per liter # 81595 Ethyl methyl ketone_ water_ unfiltered_ recoverable_ micrograms # per liter # 34371 Ethylbenzene_ water_ unfiltered_ recoverable_ micrograms # per liter # 39702 Hexachlorobutadiene_ water_ unfiltered_ recoverable_ micrograms # per liter # 34396 Hexachloroethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 77424 Iodomethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 62835 Isobutyl alcohol-d6_ surrogate_ water_ unfiltered_ percent # recovery # 78133 Isobutyl methyl ketone_ water_ unfiltered_ recoverable_ # micrograms per liter # 77223 Isopropylbenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 81593 Methacrylonitrile_ water_ unfiltered_ recoverable_ # micrograms per liter # 77032 Methyl acetate_ water_ unfiltered_ recoverable_ # micrograms per liter # 49991 Methyl acrylate_ water_ unfiltered_ recoverable_ # micrograms per liter # 81597 Methyl methacrylate_ water_ unfiltered_ recoverable_ # micrograms per liter # 78032 Methyl tert-butyl ether_ water_ unfiltered_ recoverable_ # micrograms per liter # 50005 Methyl tert-pentyl ether_ water_ unfiltered_ recoverable_ # micrograms per liter # 34696 Naphthalene_ water_ unfiltered_ recoverable_ micrograms # per liter # 99871 Number of tentatively identified compounds (TICS) from # VOC analysis by GCMS_ number # 60081 Organic carbon_ water_ filtered_ milligrams per liter # 82085 Oxygen-18/Oxygen-16 ratio_ water_ unfiltered_ per mil # 09511 Radium-226_ water_ filtered_ radon method_ picocuries per liter # 82303 Radon-222_ water_ unfiltered_ picocuries per liter # 77128 Styrene_ water_ unfiltered_ recoverable_ micrograms per liter # 34475 Tetrachloroethene_ water_ unfiltered_ recoverable_ # micrograms per liter # 32102 Tetrachloromethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 81607 Tetrahydrofuran_ water_ unfiltered_ recoverable_ # micrograms per liter # 34010 Toluene_ water_ unfiltered_ recoverable_ micrograms per liter # 32104 Tribromomethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 39180 Trichloroethene_ water_ unfiltered_ recoverable_ # micrograms per liter # 34488 Trichlorofluoromethane_ water_ unfiltered_ recoverable_ # micrograms per liter # 32106 Trichloromethane_ water_ unfiltered_ recoverable_ micrograms # per liter # 39175 Vinyl chloride_ water_ unfiltered_ recoverable_ micrograms # per liter # 81551 Xylenes_ water_ unfiltered_ recoverable_ micrograms per liter # 77093 cis-1_2-Dichloroethene_ water_ unfiltered_ recoverable_ # micrograms per liter # 34704 cis-1_3-Dichloropropene_ water_ unfiltered_ recoverable_ # micrograms per liter # 85795 m-Xylene plus p-xylene_ water_ unfiltered_ recoverable_ # micrograms per liter # 77103 n-Butyl methyl ketone_ water_ unfiltered_ recoverable_ # micrograms per liter # 77342 n-Butylbenzene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77224 n-Propylbenzene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77135 o-Xylene_ water_ unfiltered_ recoverable_ micrograms per liter # 77350 sec-Butylbenzene_ water_ unfiltered_ recoverable_ micrograms # per liter # 77073 tert-Amyl alcohol_ water_ unfiltered_ recoverable_ # micrograms per liter # 77035 tert-Butyl alcohol_ water_ unfiltered_ recoverable_ # micrograms per liter # 50004 tert-Butyl ethyl ether_ water_ unfiltered_ # recoverable_ micrograms per liter # 77353 tert-Butylbenzene_ water_ unfiltered_ recoverable_ # micrograms per liter # 34546 trans-1_2-Dichloroethene_ water_ unfiltered_ # recoverable_ micrograms per liter # 34699 trans-1_3-Dichloropropene_ water_ unfiltered_ # recoverable_ micrograms per liter # 73547 trans-1_4-Dichloro-2-butene_ water_ unfiltered_ # recoverable_ micrograms per liter # # Metadata_Reference_Information: # Metadata_Date: 06/02/2004 # Metadata_Contact: Terri Arnold, tlarnold@usgs.gov # # END_OF_METADATA