 |
||
| |
STORET |  |
|
||
| |
|
|
|
|||||||||
|
| |
| Application | Description |
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. |
|
| NPSTORET v.1.74 is a complete water quality database management system 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 that can be imported into STORET v2.0 by the STORET Import Module (SIM). WQX export will be forthcoming. Tutorials, context-sensitive help, and demonstration videos are included. Contact Dean Tucker for more information. |
|
| 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 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 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. |
|
| 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 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 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. |
|
|
|
|
|
||
|
|
STORET User Created Tools 