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 version 2.0.1 Database Views

STORET User Assistance is pleased to release scripts for the creation of STORET version 2.0.1.A 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 analytical software. Examples include MS Access®, MS Excel®, Lotus 123®, ESRI ArcView®, and SAS®.

Several new fields have been added to the views to enable the handling of STORET Date-Time fields as valid Oracle Date format. All field definitions from older view definitions remain unaffected.


Download STORET_VIEWS_v201_A.exe (168K) Now

Quit Without Downloading File

This download is in the form of a compressed, self-extracting 168K file, named STORET_VIEWS_v201_A.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 directory named "Storet_views", and subdirectories "Install" and "Docs".

Be sure to read and follow the instructions in the "Database_Views_Quick_Reference_Guide.pdf" file located in the "Docs" directory.

The "v2_view_install_notes.pdf" file contains complete instructions for installation of this file following its download. Detailed instructions for the DBA to upgrade a server copy of STORET are also included in this "v2_view_install_notes.pdf" file.

Installation of the views takes about 5 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