# DOCUMENTATION TEMPLATE - doc_temp_long.doc # # Dataset_Name: NYNE_fieldmajortenuts.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: New York- # New England 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 # field parameters, major ions, # trace elements, and nutrients 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/nyne/index.html # Online_Linkage: ftp://ftpdilurb.er.usgs.gov/pub/arnold/fieldmajortenuts.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 field parameter, # major ion, trace element, and nutrient 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 New York-New England Crystalline 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 England Crystalline # Regional Princial Aquifer # Ground-Water Trends # Theme_Keywords: Ground water # Theme_Keywords: New York-New England Crystalline Aquifer # Theme_Keywords: Field Parameters # Theme_Keywords: Major Ions # Theme_Keywords: Trace Elements # Theme_Keywords: Nutrients # 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 Crystalline 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 field parameter, major ion, trace elements # and nutrients data (These are PCODES from schedules 2752, 2702, 2755, # 2750, 2703, and 2710): # field parameters and nutrients schedules 2752, 2702, 2755 # PCODE IN ('00010','00090','00095','00300','00400','72019','00608', # '00613','00623','00625','00631','00665','00666','00671','62854') # # major ions and trace element schedules 2750, 2703, 2710 # PCODE IN ('00000','00915','00925','00930','00935','00940','00945', # '00950','00955','01046','70300','71870','90410','00403','01056', # '90095','01000','01005','01010','01020','01025','01030','01035', # '01040','01049','01057','01060','01065','01075','01080','01085', # '01090','01095','01106','01130','01145','22703' # # 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: # Some wells still had multiple entries because they occured as samples # in different ground-water networks (SUCODES). Duplicate lines were # deleted and the SUCODE information was retained in two additonal # columns ('Su Code Alt 1' and 'Su Code Alt 2'). The most networks # any well was included in was 3 networks. # # PCODE censored value # 90410 -- # 01106 1 # 00623 0.2 # 00608 0.04 # 01095 1 # 01000 1 # 01005 1 # 01010 1 # 01020 12 # 71870 0.01 # 01025 1 # 00915 -- # 00940 0.1 # 01030 0.8 # 01035 1 # 01040 1 # 72019 -- # 00300 0.1 # 00950 0.1 # 01046 10 # 01049 1 # 01130 6 # 00925 0.01 # 01056 1 # 01060 1 # 01065 1 # 00631 0.05 # 00613 0.01 # 00671 0.01 # 0090 -- # 00666 0.01 # 00935 0.1 # 70300 -- # 01145 1 # 00955 -- # 01075 1 # 00930 0.2 # 90095 -- # 00095 -- # 01080 0.2 # 00945 0.1 # 00010 -- # 01057 0.04 # 22703 1 # 01085 10 # 01090 1 # 00400 -- # 00403 -- # # 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.) Glacial # data will be compared with data for the Cambrian-Ordovician and # New York-New England aquifers so when dealing with censored values, # data for these aquifers was also considered. For analysis, censored # values were handled similar to the method employed by the NAWQA Trace # Elements National Synthesis Team as follows (original data prior to # handling censored values is stored in columns with a title begining # with a 'P'. Post handling of censored values is stored in columns # whose titles begin with a 'A_'): # 1) For any constituent that has censored values, insert an # additional column to the right of the value column (titled with # the PCODE prefixed by 'P') and label the new column with the # PCODE number prefixed by a 'A_'. # 2) Look at all the censored values for each constituent. Identify # the most common detection or reporting. # i) Values that are censored above the most common detection or # reporting limit: delete them and place a '-' in the 'A_' column. # ii) Censored values including the E-marked values below the # common detection or reporting limit: convert them to the # most common detection or reporting limit in the # 'A_' column. # iii) E-remarked values that are above the common reporting limit: # keep that E-remarked value in the 'A_' column. # # Lines were added to the data file for these missing wells with a # '-' for all columns of data. # # # Revisions: # Reviews_Applied_to_Data: This data has not been reviewed # Related_Spatial_and_Tabular_Data_Sets: # NYNE_fieldmajortenuts_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_fieldmajortenuts.xls and CO_fieldmajortenuts_raw.txt (field # parameter, major ions, trace element, and nutrient data for the # Cambrian-Ordovician Aquifer) # GLAC_fieldmajortenuts.xls and GLAC_fieldmajortenuts_raw.txt (field # parameter, major ions, trace element, and nutrient 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. # A_PCODE, Columns whose title begins with an 'A_' prefixed to the PCODE # (example column title A_01106) contain data after censored # values were treated (see process steps detailed above). Use # the 'A_' column for data analysis. If there is no 'A_' column # then there were no censored values in the 'P' original value # column; in that case, use the P column for analysis. # # List of parameter codes and their descriptions: # Parameter Code Parameter Name # 90410 Acid neutralizing capacity_ water_ unfiltered_ fixed # endpoint (pH 4.5) titration_ laboratory_ milligrams # per liter as calcium carbonate # 01106 Aluminum_ water_ filtered_ micrograms per liter # 00623 Ammonia plus organic nitrogen_ water_ filtered_ milligrams # per liter as nitrogen # 00608 Ammonia_ water_ filtered_ milligrams per liter as nitrogen # 01095 Antimony_ water_ filtered_ micrograms per liter # 01000 Arsenic_ water_ filtered_ micrograms per liter # 01005 Barium_ water_ filtered_ micrograms per liter # 01010 Beryllium_ water_ filtered_ micrograms per liter # 01020 Boron_ water_ filtered_ micrograms per liter # 71870 Bromide_ water_ filtered_ milligrams per liter # 01025 Cadmium_ water_ filtered_ micrograms per liter # 00915 Calcium_ water_ filtered_ milligrams per liter # 00940 Chloride_ water_ filtered_ milligrams per liter # 01030 Chromium_ water_ filtered_ micrograms per liter # 01035 Cobalt_ water_ filtered_ micrograms per liter # 01040 Copper_ water_ filtered_ micrograms per liter # 72019 Depth to water level_ feet below land surface # 00300 Dissolved oxygen_ water_ unfiltered_ milligrams per liter # 00950 Fluoride_ water_ filtered_ milligrams per liter # 01046 Iron_ water_ filtered_ micrograms per liter # 01049 Lead_ water_ filtered_ micrograms per liter # 01130 Lithium_ water_ filtered_ micrograms per liter # 00925 Magnesium_ water_ filtered_ milligrams per liter # 01056 Manganese_ water_ filtered_ micrograms per liter # 01060 Molybdenum_ water_ filtered_ micrograms per liter # 01065 Nickel_ water_ filtered_ micrograms per liter # 00631 Nitrite plus nitrate_ water_ filtered_ milligrams # per liter as nitrogen # 00613 Nitrite_ water_ filtered_ milligrams per liter as nitrogen # 00671 Orthophosphate_ water_ filtered_ milligrams per # liter as phosphorus # 00090 Oxidation reduction potential_ millivolts # 00666 Phosphorus_ water_ filtered_ milligrams per liter # 00935 Potassium_ water_ filtered_ milligrams per liter # 70300 Residue on evaporation_ dried at 180 degrees # Celsius_ water_ filtered_ milligrams per liter # 01145 Selenium_ water_ filtered_ micrograms per liter # 00955 Silica_ water_ filtered_ milligrams per liter # 01075 Silver_ water_ filtered_ micrograms per liter # 00930 Sodium_ water_ filtered_ milligrams per liter # 90095 Specific conductance_ water_ unfiltered_ laboratory_ # microsiemens per centimeter at 25 degrees Celsius # 00095 Specific conductance_ water_ unfiltered_ microsiemens # per centimeter at 25 degrees Celsius # 01080 Strontium_ water_ filtered_ micrograms per liter # 00945 Sulfate_ water_ filtered_ milligrams per liter # 00010 Temperature_ water_ degrees Celsius # 01057 Thallium_ water_ filtered_ micrograms per liter # 22703 Uranium (natural)_ water_ filtered_ micrograms per liter # 01085 Vanadium_ water_ filtered_ micrograms per liter # 01090 Zinc_ water_ filtered_ micrograms per liter # 00400 pH_ water_ unfiltered_ field_ standard units # 00403 pH_ water_ unfiltered_ laboratory_ standard units # # # Metadata_Reference_Information: # Metadata_Date: 06/02/2004 # Metadata_Contact: Terri Arnold, tlarnold@usgs.gov # # END_OF_METADATA