# DOCUMENTATION TEMPLATE - doc_temp_long.doc # # Dataset_Name: GLAC_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: Glacial 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/gapt/index.html # # Citation: # Originator: Terri Arnold # Title: Glacial Aquifer field parameters, major ions, # trace elements, and nutrients data # Edition: 3 # Publication_Information: # Publication_Date: original 06/02/2004. updated 09162005 # 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/gapt/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 Glacial 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: Glacial Regional Princial Aquifer # Ground-Water Trends # Theme_Keywords: Ground water # Theme_Keywords: Glacial 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: # In the Excel file of the originally distributed data set, the 2 data columns # for copper were inadvertently switched (the A_01040 column (treated censored # values) and the P01040 column (original data)), so that when you look at the P column, # 27 sites appear to have no data (censored values ge 10) . This edition # of the data set (from Sept 16, 2005) was corrected by switching the labels # for the A_01040 column and the P01040. # # For all the data sets (Excel format), the remark columns have a '<' for censored # data, an 'E' for estimated data, and a '-' for all the other sites--this means # there is a "-" for all missing data as well as for data with a measured value. # If you count the "<'s" and/or the "E's", that will give the correct answer for number of # censored or estimated; however, simply counting all the "-'s" is NOT the number of detects. # # # 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 glacial 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 Glacial Aquifer (based on lithology and # knowledge of NAWQA study unit teams) # # Su Code IN 'almnsus2', 'ccptlusag2a', 'ccptlusag2b', 'ccptlusor1a', # 'ccptlusor1b', 'cnbrluscr1', 'cnbrrefcr1','cnbrrefpa1', 'conndwgs1', # 'connfpsur1', 'connlusag1', 'connlusfo1', 'connlusrc1', 'connlusur1', # 'connreffo1','connsus2', 'cooksus1a', 'cooksus1b', 'delrsus3', # 'eiwaluscr1', 'eiwalusrc1', 'eiwaspcg1', 'eiwasus2', 'hdsnfpsag1', # 'hdsnlusag1', 'hdsnlusag2', 'hdsnlusur1', 'hdsnsus1', 'hdsnsus2', # 'hpgwdwgs1','hpgwlusag3','hpgwsus4', 'leriluscr1', 'lerilusrc1', # 'lerispcg1', 'lerisus1', 'linjsus1','lirbluscr1', 'lirbluscr2', # 'lirbsus1', 'lirbsus2', 'miamluscr1', 'miamluscr1a', 'miamlusrc1', # 'miamrefot1', 'miamspcb1', 'miamsus1', 'necblusrc1', 'necbsus3', # 'pugtfpscr1', 'pugtluscr1', 'pugtlusrs1', 'pugtsus1', 'rednfpsag1', # 'rednfpsag2', 'rednlusag1', 'rednlusag2', 'rednsus1', 'rednsus2', # 'rednsus3', 'rednsus4', 'rednsus5', 'uirbluscr1', 'uirblusrc1', # 'uirbsus1', 'uirbsus2', 'umisfpsur1', 'umisluscr1', 'umislusfo1', # 'umislusrc1', 'whitfpsag1', 'whitfpsag2', 'whitluscr1', 'whitluscr2', # 'whitluscr3a', 'whitluscr3b', 'whitlusur1a', 'whitlusur1b', # 'whitrefcr1','whmidwgs1', 'whmilusrc1','wmicfpsag1a', 'wmicfpsag1b', # 'wmicfpsag1c', 'wmicfpsag1d', 'wmicfss', 'wmiclusag1a', 'wmiclusag1b', # 'wmiclusag2', 'wmicrefcr1','wmicreffo1','wmicsus2' # # DECODE(Geographic Places.Staid,'462038118595001','NOT GLACIAL', # '462643119044001','NOT GLACIAL','462734119020801','NOT GLACIAL', # '463258119133801','NOT GLACIAL','463627119031801','NOT GLACIAL', # '464108119103801','NOT GLACIAL','464857119040701','NOT GLACIAL', # '465648119353901','NOT GLACIAL','465736119262701','NOT GLACIAL', # '470233119490501','NOT GLACIAL','470515119025801','NOT GLACIAL', # '470803119362401','NOT GLACIAL','470820119480201','NOT GLACIAL', # '470848119125501','NOT GLACIAL','470940119443901','NOT GLACIAL', # '470947119392901','NOT GLACIAL','471225119362501','NOT GLACIAL', # '462943119152201','NOT GLACIAL','463321119121501','NOT GLACIAL', # '463342119101501','NOT GLACIAL','465305119333701','NOT GLACIAL', # '465349119200401','NOT GLACIAL','465441119331701','NOT GLACIAL', # '465448119322601','NOT GLACIAL','465527119184601','NOT GLACIAL', # '465649119513901','NOT GLACIAL','425027074393701','NOT GLACIAL', # '425056074381501','NOT GLACIAL','425428073542501','NOT GLACIAL', # '411631074284201','NOT GLACIAL','411728074100001','NOT GLACIAL', # '411748074195601','NOT GLACIAL','411938073595201','NOT GLACIAL', # '411939073595301','NOT GLACIAL','412536074324301','NOT GLACIAL', # '413016074282101','NOT GLACIAL','413050074084101','NOT GLACIAL', # '413205074145101','NOT GLACIAL','413400074212701','NOT GLACIAL', # '421130073412001','NOT GLACIAL','421150073353001','NOT GLACIAL', # '421909073382001','NOT GLACIAL','422415073251001','NOT GLACIAL', # '422554073415601','NOT GLACIAL','422753073240501','NOT GLACIAL', # '422846073593501','NOT GLACIAL','422950073591201','NOT GLACIAL', # '423241074064901','NOT GLACIAL','423416073553201','NOT GLACIAL', # '423847074043701','NOT GLACIAL','423851073545201','NOT GLACIAL', # '424051073414501','NOT GLACIAL','424354073532101','NOT GLACIAL', # '424429073585801','NOT GLACIAL','425129074303501','NOT GLACIAL', # '425217074061401','NOT GLACIAL','425235074204401','NOT GLACIAL', # '425454074322101','NOT GLACIAL','425502074260601','NOT GLACIAL', # '425515074254201','NOT GLACIAL','425535074341501','NOT GLACIAL', # '425545074185601','NOT GLACIAL','425545074185602','NOT GLACIAL', # '425657074174101','NOT GLACIAL','425716074294901','NOT GLACIAL', # '425731074172901','NOT GLACIAL','425813074304201','NOT GLACIAL', # '425837074475101','NOT GLACIAL','425851074085801','NOT GLACIAL', # '430302074462601','NOT GLACIAL','430532075281101','NOT GLACIAL', # '430536075034501','NOT GLACIAL','430549075031701','NOT GLACIAL', # '431157075015601','NOT GLACIAL','431212075191501','NOT GLACIAL', # '425659075013001','NOT GLACIAL','430328074461501','NOT GLACIAL', # '421222083450501','NOT GLACIAL','423209083431301','NOT GLACIAL', # '420049084235000','NOT GLACIAL','474247097401301','NOT GLACIAL', # '474859097572201','NOT GLACIAL','474926098141901','NOT GLACIAL', # '475846097141501','NOT GLACIAL','480606097101901','NOT GLACIAL', # '480816097592701','NOT GLACIAL','481001098584701','NOT GLACIAL', # '482033099594901','NOT GLACIAL','394523085523302','NOT GLACIAL', # '385533086582801','NOT GLACIAL','390722087054501','NOT GLACIAL', # '425033074403401','NOT GLACIAL','403902074595601','NOT GLACIAL', # '404126074482501','NOT GLACIAL','404251074354101','NOT GLACIAL', # '404347074473901','NOT GLACIAL','404453074473501','NOT GLACIAL', # '404543074401101','NOT GLACIAL','404625074334401','NOT GLACIAL', # '404700074411201','NOT GLACIAL','404717074340201','NOT GLACIAL', # '404944074443101','NOT GLACIAL','405003074480101','NOT GLACIAL', # '405555074352001','NOT GLACIAL','405557074280701','NOT GLACIAL', # '405605074241101','NOT GLACIAL','405650074243601','NOT GLACIAL', # '405725074292801','NOT GLACIAL','405833074205801','NOT GLACIAL', # '410115074313101','NOT GLACIAL','410208074233501','NOT GLACIAL', # '410320074273801','NOT GLACIAL','410404074192801','NOT GLACIAL', # '410507074222901','NOT GLACIAL','410546074153001','NOT GLACIAL', # '410744074213101','NOT GLACIAL','410930074235901','NOT GLACIAL', # '411022074103201','NOT GLACIAL','411432074094101','NOT GLACIAL', # '411631074064301','NOT GLACIAL','405103074344701','NOT GLACIAL', # 'GLACIAL') # # 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. # # The wells that occured in more than one network are as follows (the # first number is the number of networks and the second number is # the STAID) # 2 383525087175001 # 2 413427072355501 # 2 415545073000601 # 2 415856072263101 # 2 433720088014901 # 2 452726088434401 # 2 454350088560301 # 2 460122096535203 # 2 460727096561702 # 2 461620097081101 # 2 462157097245801 # 2 462448097184101 # 2 462724097204601 # 2 462748097053301 # 2 463029097283401 # 2 463053097081201 # 2 463140095344601 # 2 463221097140101 # 2 463355097030701 # 2 463415097215502 # 2 463618095353301 # 2 463859095371201 # 2 463928095362501 # 2 463956095352601 # 2 464113095341901 # 2 471240095390101 # 2 471415096260701 # 2 471421097304601 # 2 471809097534401 # 2 472958097392101 # 2 473247097092401 # 2 473422095241901 # 2 473512095163201 # 2 473931097272101 # 2 474116098071701 # 2 474443098585701 # 2 474532097344901 # 2 475234097333601 # 2 475308098424801 # 2 475658098571901 # 2 480357099481901 # 2 484502097462301 # 2 485444097533601 # 3 462907097214201 # 3 475043097344401 # 3 475928097395701 # 3 480625097450801 # 3 481749097481501 # # 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. # # 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 retrieved Station IDs (STAID) were compared to a complete list of # STAIDs to determine if any wells were missing fromt he data retrieval # (due to no data for the requested PCODEs). The following STAIDs were # missing: # 414448096412701 # 422831073100101 # 424610083223201 # 433708088020801 # 433715088015804 # 433715088015805 # 433715088015806 # 433720088014904 # 433720088014905 # # Lines were added to the data file for these missing wells with a # '-' for all columns of data. # # # Process_Step: # Corrected site 484502097462301 to have 'su code' = 'rednsus3' and # 'sucode alt 1' = 'rednsus1' to make the data sort correctly # Revisions: # Reviews_Applied_to_Data: This data has not been reviewed # Related_Spatial_and_Tabular_Data_Sets: # GLAC_fieldmajortenuts_raw.txt (the raw data as retrieved from # NAWQA data warehouse bfore editing) # GLAC_staids.txt (list of staids in the Glacial Aquifer # including information about well depth, primary water use, 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) # NYNE_fieldmajortenuts.xls and NYNE_fieldmajortenuts_raw.txt (field # parameter, major ions, trace element, and nutrient data for the # New York-New England Crystalline 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. GLAC=glacial 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