1 / 6

Relational Databases for CORIE

This project focuses on the development and improvement of relational databases that manage telemetry and forecast data from various sites. Key components include verified and unverified data related to environmental metrics such as flux and temperature from locations such as Bonneville and Willamette. Work is ongoing to integrate real-time data access and enhance metadata management while implementing web applications for data delivery. Current efforts emphasize reducing ad-hoc table creation and training users for effective data access and management.

fathia
Télécharger la présentation

Relational Databases for CORIE

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. Relational Databases for CORIE • Telemetry • Forecasts • Verified Data • Verified External Data

  2. Telemetry • Sites table • Site data tables • CTD • CT • ADP • MET data nearly there. • Depth Reference Table for CTs and ADPs. Realtime unverified data. Work in progress. Mostly 2003.

  3. Forecasts • USGS, USACE data • Bonneville flux, temperature • Willamette flux, temperature • Newburg flux, temperature • Warrendaleflux, temperature • Buoy data from NBC • 40629 • Realtime unverified data. • Work in progress. • Mostly 2003 • TODO Add real time, unverified COOP elevation data for relevant stations.

  4. Verified • TBD

  5. Verified External Data • COOP data for Tongue Point. • BUOY data for station 46029. Work in progress.

  6. Going forward • Currently, too much ad hoc table creation. • Charles to play major role in database implementation. • Need design and tables for metadata. • Training for data access. • Web apps for data delivery. • Web apps for meta data creation.

More Related