Skip common site navigation and headers
United States Environmental Protection Agency
Begin Hierarchical Links EPA Home > Water > Wetlands, Oceans, & Watersheds > Monitoring and Assessing Water Quality > STORET > Data Owner's Corner > System Updates > Database Views End Hierarchical Links


STORET logo 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 analytical software.
Examples include MS Access®, MS Excel®, Lotus 123®, ESRI ArcView®, and SAS®.


Download MK_VIEWS.EXE (52K) Now

Quit Without Downloading File

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


Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us