1 / 19

Yurok Tribe Environmental Data Storage System:

kara
Download Presentation

Yurok Tribe Environmental Data Storage System:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. Yurok Tribe Environmental Data Storage System: A Tribal model for data handling and regulatory reporting compliance

    2. Yurok Tribe Located in Northwestern California Largest Tribe in California (over 5,000 members) Reservation spans 1 mile on each side of the lowest 46 miles of the Klamath River Majority of Reservation is in private ownership (Green Diamond Resource Company)

    3. Primary Issues of Concern Water Quality – Klamath River Basin spans 2 states and multiple jurisdictions Water Quantity – 2002 Salmon Kill resulted in more than 40,000 adult salmon dead Toxics – Recent Microcystis outbreaks

    4. Yurok Tribe Environmental Program Team of 9 full-time staff and 2 temporary staff Conduct quality-assured environmental monitoring Collect over 500,000 data points per year LEAD PROVIDER of environmental data within the Klamath River Basin

    5. Environmental Monitoring Water Quality: Grab Sampling (bacteria, nutrients, algae, chemical composition), continuous sampling (temperature, basic parameters), macroinvertebrates, fish disease sampling, fish tissue sampling Water Quantity: Flows in both mainstem Klamath and Trinity Rivers and major tributaries Groundwater: LUST Mitigation sampling – depth to groundwater and chemical composition Air Quality: meteorological monitoring and particulate matter (PM2.5) Photomonitoring Pesticides Sampling in active forest practice areas Special Sampling – Enforcement, Spill Response, and other special monitoring efforts

    6. Data Storage & Analysis Old System: Excel-Based Required extensive work each year to analyze data and compose reports Resulted in numerous duplicate files and no security on unvalidated or validated data Data transfer to STORET or AQS extremely cumbersome YEDSS: Automates data validation Raw and validated data are segregated and protected Automates data summaries and charts for reports Pushes data automatically to AQS and STORET Also stores metadata, QA data, photos, and

    7. Data Push The Yurok Tribe has been uploading data to AQS using YEDSS since March of 2007 The Yurok Tribe was the first Tribe in Region 9 to upload data to STORET/WQX with our first package delivered in August of 2007

    8. Monitoring – Element One Enabled equipment purchase and establishment of Real-Time Water Quality Monitoring Network

    9. Real-Time Data Delivery Half-hourly water and air quality and water quantity data available to the public via yuroktribe.org Used to monitor equipment status, used by members of the Klamath River Basin team to monitor current conditions

    10. Water Data – Element Two YEDSS Water Quality Modules Grab Data (Bacteria, Nutrient, Algae) collection, validation, storage, analysis, and “push” to STORET Continuous Data collection, validation, storage, and analysis Flow Data collection, validation, storage, and analysis

    11. YEDSS WQ Screenshots

    12. Air Data – Element Three YEDSS Air Quality Modules Meteorological Data collection, validation, storage, analysis, and “push” to AQS Particulate Data collection, validation, storage, analysis, and “push” to AQS

    13. YEDSS AQ Screenshots

    14. Other Functions Photo Database

    15. Planned/In Development Functions Mercury Monitoring Data Module (AQ) STORET push of Continuous Data Facility Registry System module and push UST Tracking Module and push Georeferenced Graphical Interface Web-enabled queries of validated data and photos

    16. Advantages for Tribes STORET and AQS “common” upload interfaces are cumbersome, time-consuming, and nearly impossible for a small program to utilize – YEDSS or a similar XML-encoded file transfer is seamless and automated YEDSS or similar program is useful for the Tribal program (validation, storage, analysis) as well as fulfilling the data upload requirements of EPA YEDSS is built using a common programming language (SQL) – can be copied or modified by any programmer YEDSS has extensive quality-assurance and validation mechanisms automated – saves staff time; also has cutting-edge security measures to preserve data and protect system

    17. Tribal Suggestions Small-capacity programs need data management systems as well as streamlined data push products Develop guidance on data management, improve QMP guidance, promote open-source management templates/tools Quality Assurance for data management is not well defined

    18. More Tribal suggestions Without participation of outside agencies or entities, data in regulatory databases may be useless in some basins to describe the state of the environment Each Region should have a EN “Champion,” as well as an identified, knowledgeable point person for each regulatory flow Data security resolution Open-source toolkits (SQL, not oracle)

    19. Contacts Laura Mayo, Assistant Director – Cross-Media Division, Interim QA Officer lmayo@yuroktribe.nsn.us www.yuroktribe.org/departments/ytep/ytep.htm

More Related