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 > User Created Applications End Hierarchical Links


STORET logo STORET User Created Tools

Below is a list of third-party tools and applications developed by members of the STORET user community. These links are provided as a service to users of the STORET System. The U.S. EPA and the HQ STORET Team is not associated with or responsible for the content of these items. The Standards of Ethical Conduct do not permit the U.S. EPA to endorse any private sector Web site, product, or service. The U.S. EPA does not exercise any editorial control over the information you may find.

Your tool or a link to your application can be posted here!!

If you would like to see your tool posted here or a link to your web site, send us your application or URL with a description of your product using the "Contact Us" link at the top or bottom this page. If we agree that your tool is of general interest to the STORET community, we will add it to our list.



US Storet Layer (November 2004)

US Storet Layer (GIS) is GIS station layer from the data warehouse as of November 1, 2004. The GIS station layer was converted to a shape file. An Environmental Systems Research Institute, Inc. (ESRI) shapefile stores nontopological geometry and attribute information for the spatial features in a data set. The geometry for a feature is stored as a shape comprising a set of vector coordinates. An ESRI shapefile consists of a main file, an index file, and a dBASE table.
Contact Sue McCarthy/R10/USEPA/US for more information.  

NPSCol2Row v.2.11 Exit EPA Disclaimer

NPSCol2Row is a general purpose Access-VBA utility that converts 'column-major' tables to 'row-major' tables. The 'column-major' input tables can be in Microsoft Access or Excel formats and the 'row-major' output tables can be opened in Access, Excel, and/or ASCII formats. NPSCol2Row also includes a myriad of options allowing the user to customize this general 'column-major' to 'row-major' transformation, particulary insofar as creating an output file compatible with the Environmental Protection Agency's (EPA) STORET Import Module. This includes providing supporting fields of metadata directly in the table prior to transforming to 'row-major' format. NPSCol2Row does not require a connection to Oracle or SIM. Works with MS Access 2002 or 2003. Contact Dean Tucker for more information.  

Datastor v3.0

Datastor takes the burden and guesswork out of entering data from hardcopy into STORET. It directly access a user's STORET data tables to help ensure supporting information such as sampling gear, activity descriptors, and monitoring projects are accurate for the data being entered. All characteristics for a selected Characteristic Group are displayed on a single form to make entering the results quick and easy. All entries are accurately converted to the user's choice of STORET Batch File or SIM 2.0 format. In addition, Datastor takes advantage of STORET's ability to create Trips in batch file and now allows entry of lab information such as detection and quantification limits. Datastor 3.0 only works with STORET 2.0 and SIM 2.0, it will not work with earlier versions. Contact Eric Wilson for more information.  

Dataconvert v1.1

Dataconvert assists converting data entered into Excel and other spreadsheet programs into a format that can be easily read by SIM. Most spreadsheet data use a separate column for each characteristic followed by the results. However, SIM requires all characteristics to be in the same column with the corresponding results in a second column. Dataconvert reformats the spreadsheet so the data are in SIM format. In addition, Dataconvert allows creation of Configuration files that add information such as Medium, Activity Category, Sampling Gear, etc. to the spreadsheet data. This information is generated directly from the user's copy of STORET. There is also a translation capability between the Characteristic names used in the spreadsheet and the names used by STORET. Users can also select analytical methods, units of measure, detection limits and most other Characteristic descriptors. These are all saved in the Dataconvert Configuration file for use when converting additional data. Version 1.1 can handle much larger spreadsheet files, up to 50 columns by 7000 rows. The interface has been streamlined and a number of bug fixes have been made. Contact Eric Wilson for more information.  

Minnesota EDA Exit EPA Disclaimer

The Minnesota Pollution Control Agency's Environmental Data Access (EDA) Website allows users to find Minnesota surface water monitoring sites, and view or download monitoring data from those sites. The website provides both a GIS interface and a text-based query tool to allow the user to locate monitoring sites. Once a STORET monitoring site is selected, the user can see data from both legacy and modernized STORET. The system also contains non-STORET data such as Minnesota biological monitoring data and NPDES permitted discharge summaries. Contact John Seaberg for more information.  

Alaska Web-GIS Exit EPA Disclaimer

The Alaska and EPA Regions 4, 9, & 10 Legacy STORET and FLOW Data Mapping Application. The STORET mapping application has been developed in ArcIMS and is available for Alaska only. The non-map interface will query Legacy STORET data for EPA Regions 4, 9, & 10. Contact Russell Kunibe for more information.  

Alaska SIM-DE (SIM Data Entry)

This MS Access application & database was created to enable easier data entry for water quality data. The original application was developed by Gold Systems, Inc. for Alaska DEC and produces a SIM v1.2 compatible export. Alaska DEC has recently initiated a project to enhance the existing application and to make it compatible with STORET/SIM v2.0. Some enhancements include: additional configurable data entry forms, the ability to track and export project information, the ability to track and export station information. This project is being done in cooperation with the National Park Service and Alaska DEC would welcome other cooperators in this development. Contact Dianne Denson for more information.  


Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us