60 likes | 180 Views
Relational Databases for CORIE. Telemetry Forecasts Verified Data Verified External Data. 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. Forecasts.
E N D
Relational Databases for CORIE • Telemetry • Forecasts • Verified Data • Verified External Data
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.
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.
Verified • TBD
Verified External Data • COOP data for Tongue Point. • BUOY data for station 46029. Work in progress.
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.