Application

Description

iTouchMap.com Latitude and Longitude of a Point Browser

(**New Latitude/Longitude Bounding Box Tool) This iTouchMap.com Latitude and Longitude of a Point Browser, will assist users to locate and box an area of interest. The "Rectangle Tool" allows users to display the rectangle coordinates for a given latitude/longitude bounding box. First drag the "Red" marker over the desired area. Then, drag the rectangle corners to the exact points of interest. Click Get Coordinates to display the rectangle coordinates.
Two diagonal points can be used to populate bounding box limits (north,south,east,west). Detail Instructions for plotting two diagonal reference points can be found via the warehouse application help file Click Here. Contact STORET@EPA.GOV for more information.  

STORET Watershed Webservice Browserv v1.3.1.zip

(**New SOAP Based Services) This EPA STORET Watershed Webservice Browser (214 KB) available for download, contains a Microsoft Excel workbook that allows users to query data and summary information available within a given watershed (8-digit Hydrologic Unit Code (HUC)). Macros must be enabled in MS Excel in order for the tool to function. Contact STORET@EPA.GOV for more information.  

STORET Station Catalog Webservice Browserv v2.9.1.zip

(**New SOAP Based Services) This EPA Station Catalog Webservice Browser (604 KB) available for download, contains a Microsoft Excel workbook that allows users to query STORET data by Project, Station and Result, utilizing multiple STORET web services. Macros must be enabled in Microsoft Excel in order for the tool to function. Contact STORET@EPA.GOV for more information.  

Open Water

What is Open Waters?   Open Waters is a free, open source web-based water quality data management system that allows you to manage water quality monitoring locations, samples, results, and projects. The intended audience is tribal, state, or local volunteer water quality data managers, who collect and manage water quality data, and have the need to submit this data to EPA's WQX program. Open Waters is unique in that people can manage their data locally, but submission to EPA is completely automated and handled behind-the-scenes, thus eliminating the burden of separate data submission to EPA. Contact Doug Timms, open-environment.org, 609-556-0531 doug.timms@open-environment.org for more information.  

STORET-NWIS Mini_Portal_Browser_v1.3.zip

The STORET-NWIS Mini_Portal_Browser_v1.2.zip (546 KB) available for download, contains a Microsoft Excel workbook that allows users to interact dynamically with the STORET-NWIS Mini-Portal web services. Macros must be enabled in Microsoft Excel in order for the tool to function. Contact STORET@EPA.GOV for more information.  

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.  

NPSTORET v1.86

NPSTORET v.1.86 is a complete water quality database management system based on STORET/WQX that allows users to enter information about their water quality monitoring Projects, Stations, Metadata, and Results in a Microsoft Access database. Users can generate reports, statistics, and graphics describing entered data. Data can be imported from a variety of data sources and formats, including the three major national water quality databases: EPA Legacy STORET, EPA Modern STORET, and USGS National Water Information System. NPSTORET can produce export files in WQX format, text format for import via WQX-Web or the STORET Import Module (SIM), and a variety of other formats. Tutorials, context-sensitive help, and demonstration videos are included. Contact Dean Tucker for more information or visit URL: http://nature.nps.gov/water/vitalsigns/vitalsignsmgt.cfm#downloads.  

NPSCol2Row v.2.21

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.2

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.2 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 Pollution Control EDA

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.  

Datastorlite v1.1

Datastorlite is comprehensive yet easy to use data entry program for users who do not have direct access to STORET. It will convert all entries to SIM compatible files that can be either sent to an organization's STORET Coordinator for loading into STORET or loaded directly by the organization through WebSIM. SIM configurations are built in along with a template of the required data elements from the Tribal 106 Guidance. Projects, station information, water quality data, macroinvertebrate and fish counts can be entered through spreadsheet like forms. The essential data elements from STORET are included as either defaults or pick lists. Contact Eric Wilson for more information.  

DatastorWQX v1.1

DatastorWQX v1.1 is a comprehensive data entry program for STORET/WQX. Projects, stations, and field and sample results files can be quickly generated in the XML format used by STORET/WQX. These files can then be uploaded to a user’s Organization in the warehouse. Configuration files of sample collection procedures and characteristic descriptions can be created to further reduce data entry effort and improve accuracy. Version 1.1 allows creation of Microsoft Excel files from data entries so a local database can be created. In addition station location files can be imported and translated to XML, Activities can be associated with multiple Projects, and Data Logger results entry has been enhanced. Contact Eric Wilson for more information.