# DOCUMENTATION TEMPLATE - doc_temp_long.doc # # Dataset_Name: NYNE_pest2010_50_60.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: NYNE Crystalline # 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/nyne/index.html # # Citation: # Originator: Terri Arnold # Title: New York-New England Crystalline Aquifer # pesticide data # (PCODES from schedules 2010, 2050, and 2060) # 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/nyne/index.html # Online_Linkage: ftp://ftpdilurb.er.usgs.gov/pub/arnold/pesticides.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 pesticide data # (PCODES from shedules 2010, 2050, and 2060) retrieved # from the NAWQA Internal Data Warehouse on May 20, 2004. # The data will be used in a series of reports to characterize # the New York-New England Cyrstalline 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: New York-New EnglandCrystalline # Regional Princial Aquifer # Ground-Water Trends # Theme_Keywords: Ground water # Theme_Keywords: New York-New England Crystalline Aquifer # Theme_Keywords: Pesticides # 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 New York-New England 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 New York-New England Crystalline Aquifer # (based on lithology and knowledge of NAWQA study unit teams) # # Su Code IN ('connsus1', 'linjsus1', 'necbsus1', 'necbsus2') # # DECODE(Geographic Places.Staid,'410104074284101','NOT NYNE','NYNE') # # Select PCODES to retrieve pesticide data (These are PCODES from # schedules 2010, 2050, and 2060). # # Pest sch 2010, 2050, 2060 # PCODE IN ('99857','99819','91064','91063','82687','82686','82685', # '82684','82683','82682','82681','82680','82679','82678', # '82677','82676','82675','82674','82673','82672','82671', # '82669','82668','82667','82666','82665','82664','82663', # '82661','82660','82630','49260','46342','39572','39542', # '39532','39415','39381','39341','38933','34653','34253', # '4095','4041','4037','4035','4028','4024','99848', # '99835','99820','49314','49312','49310','49309','49308', # '49307','49306','49305','49304','49303','49301','49299', # '49298','49296','49295','49236','49235','39762','39742', # '38866','38811','38746','38711','38538','38501','38487', # '38482','38478','4029','99959','99958','99840','99750', # '90640','82670','61697','61695','61694','61693','61692', # '61188','61159','50471','50470','50407','50364','50359', # '50356','50355','50337','50306','50305','50300','50299', # '50295','49315','49313','49311','49302','49300','49297', # '49294','49293','49292','49291','39732','39632','38548', # '38442','4040','4039','4038','4033','4032','4031') # # 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 Pesticide 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: # NYNE_pest2010_50_60_raw.txt (the raw data as retrieved from # NAWQA data warehouse bfore editing) # NYNE_staids.txt (list of staids in New York-New England # Crystalline Aquifer including information about well depth, # primary aquifer, lithology, and region) # CO_pest2010_50_60.xls and CO_pest2010_50_60_raw_raw.txt # (pesticide data for the Cambrian-Ordovician Aquifer) # GLAC_pest2010_50_60.xls and GLAC_pest2010_50_60_raw.txt # (pesticide 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. NYNE=New York-New England # Crystalline 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 # 34253 alpha-HCH_ water_ filtered_ recoverable_ micrograms per liter # 34653 p_p'-DDE_ water_ filtered_ recoverable_ micrograms per liter # 38442 Dicamba_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38478 Linuron_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38482 MCPA_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38487 MCPB_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38501 Methiocarb_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38538 Propoxur_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38548 Siduron_ water_ filtered_ recoverable_ micrograms per liter # 38711 Bentazon_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38746 2_4-DB_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38811 Fluometuron_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38866 Oxamyl_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 38933 Chlorpyrifos_ water_ filtered_ recoverable_ micrograms per liter # 39341 Lindane_ water_ filtered_ recoverable_ micrograms per liter # 39381 Dieldrin_ water_ filtered_ recoverable_ micrograms per liter # 39415 Metolachlor_ water_ filtered_ recoverable_ micrograms per liter # 39532 Malathion_ water_ filtered_ recoverable_ micrograms per liter # 39542 Parathion_ water_ filtered_ recoverable_ micrograms per liter # 39572 Diazinon_ water_ filtered_ recoverable_ micrograms per liter # 39632 Atrazine_ water_ filtered_ recoverable_ micrograms per liter # 39732 2_4-D_ water_ filtered_ recoverable_ micrograms per liter # 39742 2_4_5-T_ water_ filtered_ recoverable_ micrograms per liter # 39762 Silvex_ water_ filtered_ recoverable_ micrograms per liter # 46342 Alachlor_ water_ filtered_ recoverable_ micrograms per liter # 49235 Triclopyr_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49236 Propham_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49260 Acetochlor_ water_ filtered_ recoverable_ micrograms per liter # 49291 Picloram_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49292 Oryzalin_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49293 Norflurazon_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49294 Neburon_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49295 1-Naphthol_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49296 Methomyl_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49297 Fenuron_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49298 Esfenvalerate_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49299 2-Methyl-4_6-dinitrophenol_ water_ filtered (0.7 micron glass # fiber filter)_ recoverable_ micrograms per liter # 49300 Diuron_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49301 Dinoseb_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49302 Dichlorprop_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49303 Dichlobenil_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49304 Dacthal monoacid_ water_ filtered (0.7 micron glass fiber # filter)_ recoverable_ micrograms per liter # 49305 Clopyralid_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49306 Chlorothalonil_ water_ filtered (0.7 micron glass fiber # filter)_ recoverable_ micrograms per liter # 49308 3-Hydroxy carbofuran_ water_ filtered (0.7 micron glass # fiber filter)_ recoverable_ micrograms per liter # 49309 Carbofuran_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49310 Carbaryl_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49311 Bromoxynil_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49312 Aldicarb_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 49313 Aldicarb sulfone_ water_ filtered (0.7 micron glass fiber # filter)_ recoverable_ micrograms per liter # 49314 Aldicarb sulfoxide_ water_ filtered (0.7 micron glass fiber # filter)_ recoverable_ micrograms per liter # 49315 Acifluorfen_ water_ filtered (0.7 micron glass fiber # filter)_ recoverable_ micrograms per liter # 50295 3-Ketocarbofuran_ water_ filtered_ recoverable_ micrograms # per liter # 50299 Bendiocarb_ water_ filtered_ recoverable_ micrograms per liter # 50300 Benomyl_ water_ filtered_ recoverable_ micrograms per liter # 50305 Caffeine_ water_ filtered_ recoverable_ micrograms per liter # 50306 Chlorimuron_ water_ filtered_ recoverable_ micrograms per liter # 50337 Sulfometuron_ water_ filtered_ recoverable_ micrograms per liter # 50355 2-Hydroxy-4-isopropylamino-6-ethylamino-s-triazine_ water_ # filtered_ recoverable_ micrograms per liter # 50356 Imazaquin_ water_ filtered_ recoverable_ micrograms per liter # 50359 Metalaxyl_ water_ filtered_ recoverable_ micrograms per liter # 50364 Nicosulfuron_ water_ filtered_ recoverable_ micrograms per liter # 50407 Imazethapyr_ water_ filtered_ recoverable_ micrograms per liter # 50470 2_4-D methyl ester_ water_ filtered_ recoverable_ micrograms # per liter # 50471 Propiconazole_ water_ filtered_ recoverable_ micrograms per liter # 61159 Tribenuron_ water_ filtered_ recovereable_ micrograms per liter # 61188 Chloramben methyl ester_ water_ filtered_ recoverable_ micrograms # per liter # 61692 N-(4-Chlorophenyl)-N'-methylurea_ water_ filtered_ recoverable_ # micrograms per liter # 61693 Bensulfuron_ water_ filtered_ recoverable_ micrograms per liter # 61694 Flumetsulam_ water_ filtered_ recoverable_ micrograms per liter # 61695 Imidacloprid_ water_ filtered_ recoverable_ micrograms per liter # 61697 Metsulfuron_ water_ filtered_ recoverable_ micrograms per liter # 82630 Metribuzin_ water_ filtered_ recoverable_ micrograms per liter # 82660 2_6-Diethylaniline_ water_ filtered (0.7 micron glass fiber # filter)_ recoverable_ micrograms per liter # 82661 Trifluralin_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82663 Ethalfluralin_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82664 Phorate_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82665 Terbacil_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82666 Linuron_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82667 Methyl parathion_ water_ filtered (0.7 micron glass fiber # filter)_ recoverable_ micrograms per liter # 82668 EPTC_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82669 Pebulate_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82670 Tebuthiuron_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82671 Molinate_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82672 Ethoprop_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82673 Benfluralin_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82674 Carbofuran_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82675 Terbufos_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82676 Pronamide_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82677 Disulfoton_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82678 Triallate_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82679 Propanil_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82680 Carbaryl_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82681 Thiobencarb_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82682 DCPA_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82683 Pendimethalin_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82684 Napropamide_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82685 Propargite_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82686 Azinphos-methyl_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # 82687 cis-Permethrin_ water_ filtered (0.7 micron glass fiber filter)_ # recoverable_ micrograms per liter # # Metadata_Reference_Information: # Metadata_Date: 06/02/2004 # Metadata_Contact: Terri Arnold, tlarnold@usgs.gov # # END_OF_METADATA