CWQMC Data Swaps - ACWI

CWQMC Data Swaps - ACWI

CWQMC Data Swaps Dr. Holly L.O. Huyck CWQMC Coordinator [email protected] CWQMC Data Swaps January 2001: Clear Creek Watershed and Henderson site metadata March 2002: South Platte Basin data needs swap May 2002: South Platte Basing metadata swap Portion of the Clear Creek Metadata Table on the Website AGENCY

# SITES 1 Black Hawk/Central City Sanitation District Lynn Venters [email protected] 2 City of Black Hawk Ron Reeves [email protected] g 3--Plant Effluent, Segment 13b (above W W TP effluent), and new Plant site

1--Segment 13a (above infiltration gallery). (W ill test stream segment near near new plant effluent.) 3 City of Thornton Vic Lucero 5 ([email protected], [email protected] [email protected], [email protected], [email protected], [email protected] SP 4 Clear Creek W atershed Includes 15 Clear Creek Monitoring Group UCCW AG- sites and 7 wastewater R.L.Jones / City of Golden - treatment plant Vicki Coppage / Standley monitoring sites in the

Lake - Mary Fabisiah upper watershed. [email protected] 5 CDPHE Bob McConnell/Joni Nuttle [email protected] us or [email protected] 6--#131 lat 39:45:33 long 105:39:37/#132 lat 39:44:47 long 105:27:36/#133 lat 39:44:54 long 105:23:55/#034 lat 39:49:42 long

104:57:30/#035 lat 39:45:11 long 105:14:05/ #089 lat 39:46:00 long 105:05:00 6 CGS Matt Sares [email protected] Location -- 3 sites only FREQUENCY W Q Testing 1st W ed. of each month, plus monthly START/END DATE since 12/00 for first 2 sites

FORMAT Excel W Q Testing 1st W ed. of each month since 12/00 Excel monthly 1993 to Present ACCESS (Aspen LIMS) 8x/year for 11 chemical & nutrient parameters. Concurrent samples

taken & analysed by EPA for 23 trace metals (total recoverable & diss.). Flow data recorded at 9 USGS recording gages & 9 staff gages. average 6-10x/year Started in 1994 to address water quality issues for all participating agencies. Excel each site varies old STORET & Excel (eventually

new STORET) one-time, grab samples summer 1991, 1995 Access Fields on CC Metadata Table

Agency and email contact Number of sites Frequency of sampling Start/end dates Data storage format Parameters (listed individually) Additional information May 2002 Swap Meet Metadata Requested 1. Sampling locations and formats (e.g. dot-on-a-map, Lat/Long, UTM, address, all-of-the-above); 2. Period-of-record for the sampling, from what date to what date (or present); 3. Frequency of samplingboth number of times per

year and specific months; 4. Parameters (SPECIFIC lists may include physical parameters, DO, organics, metals, pesticides, major ions, nutrients, hardness, biological, habitat, physical); May 2002 Swap Meet Metadata Requested (continued) 5. Data Quality Objectives (indicate whether for research project, permit compliance, trend analysis, reconnaissance, or other-please specify); 6. Database format (EXCEL, ACCESS, STORET, NWIS, hand-written, combination); 7. Contact information for someone who works with the database; 8. Note whether SOP (sample/lab protocols) are written; 9. Lat/long. for plotting on a map of the South Platte

Basinsent to USGS electronically. Advantages of Metadata Swaps List requested is simple and allows for different monitoring styles and objectives. Providing metadata is much less onerous. Data remain property of monitoring group that still controls access. E-mail contact is much easier for data managers to handle. Disadvantages of Metadata Swaps Information provided on the website is limited. Definitions vary among groups (e.g. major

vs. minor cations) Still need to contact each group to obtain the actual data. Data remain in different formats. South Platte Basin Map Format Uses web-based mapping technology for on-the-fly map enlargements. Sites are listed by group/agency. Click on site to obtain a table of metadata. Table has a link to variables list for definitions of parameter groups. Map Directory of Selected Data-Collection Sites in Colorado Map Zoom-in on Denver Water Sampling

Sites Roberts Tunnel of DWB Selected Fields for Each Site Selected Group name and email contact Site:Stream Name or Description Period of Record & Number of Samples Chemical: Field Parameters,Hardness, Major ions, Nutrients, Organics, Minor and Trace Elements, Pesticides, Chemistry of Sediments

Biological: Fish Assemblages, Macro-invertebrates, Microinvertebrates, E.coli or Fecal Colliform, Aquatic Vegetation, Other Physical: Flow, Temperature, Secchi Depth, Turbidity, Sediments, Instream Habitat, Riparian or Wetland Habitat, Upland Habitat Lists of Variables That Occur under the Current Fields (via hot link at bottom of main table) Chemical Variables Field parameters: pH, DO, conductivity, etc. Major ions: major cations and anions, including Fe, Mn, but NOT nutrient-related ions. Nutrients: all forms of nitrogen and phosphorous (including iron). Organics: TOC, TOD. Minor and Trace elements: minor elements, and metal (EXCEPT for Fe and Mn).

Chemistry of Sediments: analyses of the sediments themselves, as opposed to water chemistry. Variables Continued Biological Variables Fish Assemblages: includes all types of fish, also analyses of fish tissues. E. coli or Fecal Coliform: any analysis of all forms of E. coli or fecal colliform. Physical Habitat Sediments: amount of sediment - bedload or suspended sediments. Results of Swaps Clear Creek: 21 groups/projects reporting ~130 sites excluding Superfund

109 sites related to Superfund (sampled 1-5x) Include nutrients, metals, sediments, fish, flow South Platte: additional 10 groups ~900 sites (past and current) Clear Creek Monitoring (2001) Ongoing Monitoring Completed Monitoring Number of Sample Events 250 200

150 100 50 0 0 10 20 30

40 50 60 70 Number of Sample Sites 80 90 Metadata Swap Process Iterative process (Clear Creek added 5 groups over

12 months.) Groups range from federal agencies to local volunteer watershed coalitions. Best response from established groups and agencies; also better if paid people are involved. (All-volunteer groups are less responsive.) Best response is to one-page request; 3-page data needs request received very few responses. Metadata Swap Process (continued) Try three contacts per new group.

Personal acquaintance improves responses. Cold calls 45% response on S. Platte. ~1/2 of electronic responses occur after the swap; used in addition to swap minutes. Swap is a round-robin, with each group presenting its metadata and comments. Recommended CWQMC Shared Database Information General comments. This simplification of STORET and the NWQMC recommended fields is considered to be the MINIMUM amount of information to make the databases useable for comparisons among databases. Fields focus on chemical data, and should be modified to accommodate biological data by the

Aquatic Life Committee. This list does not specify the design of the database. Recommended Minimum Data Fields (MDEs) Project Name: character field. Project agency name: unique name for each agency or group. Project Description: memo-type field that can include whatever comments are desired. Project Purpose: character field with ,e.g. basic screening, regulatory compliance, site trends. Project QA/QC: memo-type field with # of field duplicates, field blanks, analytical lab name, and corrective actions for problemse.g. bad blanks. ProjectContact: Name, address, telephone, email. Person who supplied data. (These may differ.)

MDEs (continued) Station ID: character field, no duplicates allowed. Station Name: character field. If no name exists, can just repeat the station ID. Station Type: stream, well, lake, canal, etc. Station Latitude: standardize this as Degree-Minute-Second or decimal degree. Station Longitude: standardize this as Degree-Minute-Second or decimal degree. Location Datum: NAD27 or NAD83. Define which datum was used for lat./long. (e.g. pre-1983 USGS maps would be NAD27; GPS systems should tell users which datum was used.) Location Description: memo-type field with local permanent landmarks or other descriptive commentse.g. sample in the thalweg, upstream of bridge.

MDEs (continued) Sample ID: character field, must be a unique identifier. Sample Date: representative date or date that sample collection was started. Sample Time: representative time or time that sample collection was started (military time). Sample Type: grab, composite; if composite, code for duration of composite (hours, days, etc). SampleMedium: water, sediment, fish tissue, etc. SampleDepth: character field that contains depth, or range in depth. SampleDepth Units: meters, feet, etc. MDEs (continued) Result Name: e.g. pH, Temp., Calcium, Nitrate, etc.

Result Value: measured characteristic. Prefer numeric field, but could be character field. Result Units: degrees, mg/l, ppm, ppb, ug/l, etc. Result Fraction: total, total recoverable, dissolved (filter size?), etc. Result Detection Limit: Result Detection Limit Units: mg/l, ppb, etc. Result Comments: memo-type field to include user-defined information, e.g. whether the result is an estimate, average, less than (for below detection limit), how user made an average, sample preparation, analytical method, etc. Responses to MDEs Even one page of MDEs is onerous to some people, including state agencies. NWQMCs MDEs are overwhelming to all

but a few swap participants. Common MDEs are a major challenge, much less finding a common format! Tradeoff between participation and complexity of swaps. ($$$ and time issues)

Recently Viewed Presentations

  • Kuliah Teknologi Penangkapan Ikan Iii

    Kuliah Teknologi Penangkapan Ikan Iii

    Kapal dalam KNOT 1 KNOT = 1 mil / jam Untuk mengejar gerombolan ikan, kec. Kapal yg perlu tenaga tarik HP besar, RPM kecil While catcher 12 KNOT kapal purse seine HP besar krn melingkari gerombolan ikan GT (Gross Tonage)...
  • Strong Angel II: Designing the Edge Design and

    Strong Angel II: Designing the Edge Design and

    As seen here, we were able to generate video over more than 1000 yards, with vehicles interposed. Here in the upper center you see a $30 webcam showing the road ahead to the last vehicle in the convoy, and, on...
  • The Sounds of language - Los Angeles Mission College

    The Sounds of language - Los Angeles Mission College

    THE SOUNDS OF LANGUAGE ... Supralaryngeal vocal tract Above vocal cords Where sound waves become recognizable speech sounds LARYNX As air moves through larynx, it passes through vocal cords If cords are relaxed and open, the sound is voiceless If...
  • Introduction to Geography

    Introduction to Geography

    Cities and Urban Geography Historic Cities and City Functions Geographic Observations of City Location and Size The World's Largest Cities ... Brazil European Cities: result of very long histories Complex street patterns - prior to automobile, weird angles Plazas and...
  • Regeneration - Enquiry Question 2  Why might regeneration

    Regeneration - Enquiry Question 2 Why might regeneration

    New industrial development, for example, requires construction workers who themselves require housing, and services such as schools and shops. An increased demand for food will benefit local farmers who may increase their spending on fertiliser. ... Area functions as a...
  • Outline Introduction Methodology Results Implications Introduction Methodology Results

    Outline Introduction Methodology Results Implications Introduction Methodology Results

    Testable Specific Direct/Mediated Design of Study A two-study approach (quasi-experimental) Compare attitudes during SARS and non-SARS periods SARS Period Survey data collected at peak of SARS Wide area online survey with self-selected respondents Survey Instrument House and Rizzo's (1972) job...
  • Thermodynamics II Chapter 2 Gas Turbines Mohsin Mohd

    Thermodynamics II Chapter 2 Gas Turbines Mohsin Mohd

    As the number of compression and expansion stages increases, the gas-turbine cycle with intercooling, reheating, and regeneration approaches the Ericsson cycle. Intercooling and reheating always . decreases. thermal efficiency unless accompanied by . regeneration. Why? Therefore, in gas turbine power...
  • Chemical Kinetics - Warren County Public Schools

    Chemical Kinetics - Warren County Public Schools

    Chemical Kinetics. Kinetics - the area of chemistry concerned with the rate (or speed) of a reaction. ... Slope of the tangent line at any point along the curve is the instantaneous rate. ... Beer-Lambert Law.