STORET version 2.0.1 Database Views
STORET User Assistance is pleased to release scripts for
the creation of STORET version 2.0.1 Database "views" representing key
concepts associated with the business of water quality monitoring.
A database view is a preformatted SQL instruction which
defines a concept by relating it to many fields in the
database, drawn from many different database tables. These views
define Stations, Station Visits,
Monitoring Activities, and Results. Within these views,
internal codes and references are translated into their plain
English values, and data like latitude and longitude are
converted to proper forms which may be easily interpreted by
your analytical software.
Through the capabilities of Open Database Connectivity (ODBC),
these views make your STORET data appear as formatted tables
or worksheets in ODBC compliant spread-sheets, databases, or
Examples include MS Access®,
MS Excel®, Lotus 123®,
ESRI ArcView®, and SAS®.