STORET Database Views
STORET User Assistance is pleased to release scripts for
the creation of STORET Database "views" representing key
objects 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. Views
created by these scripts define Stations, Station Visits,
Monitoring Activities, and Results. Within these views,
internal codes and references are translated into their plain
English values, and concepts like latitude and longitude are
converted to proper forms which may be easily interpreted by
your analytical software.
Through the capabilities of Open Data Base 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®.
This download is in the form of a compressed, self-extracting
52K file, named MK_VIEWS.EXE. You should place it in a temporary
folder, and double-click it to allow it to expand.
In its extracted form, it will consist of a subdirectory
named "Setup", which will contain 15 files, named
- Readme.txt (3K)
- Setup.bat (2K)
- Create_Views.bat (1K)
- Create_Views.sql (3K)
- Create_Views.log (1K)
- f_estry.sql (2K)
- f_lbrmk.sql (2K)
- f_station_visited.sql (1K)
- station_details_view.sql (10K)
- stvst_view.sql (2K)
- activity_dtls_view.sql (13K)
- result_view.sql (10K)
- rv_r.sql (11K)
- rv_h.sql (11K)
- rv_b.sql (23K)
Be sure to read and follow the instructions in the "Readme.txt" file.
The "Readme.txt" file contains complete instructions for installation
of this file following its download. The "Setup.bat" file can be
used to automatically install this fix, provided your
installation of STORET is the stand-alone PC version using
Personal Oracle ®. Detailed instructions for the DBA to upgrade
a server copy of STORET are also included in this "Readme.txt" file.
Installation of this fix takes less than two minutes, once the file
has been downloaded and expanded.
To download this file, click the "Download Now" button at your left.
To quit without downloading, click the "CANCEL" button.
Need Help? If you have a question, or are uncertain about this
download, please call STORET User Assistance at 1-800-424-9067, or
send us an email at