# Presentation: 335028

## Progress Report2004 National STORET Users ConferenceNovember 15-17, 2004

- Lee Manning

## Growth in Data Warehouse

|  | 2001 | 2004 | % Change |
| --- | --- | --- | --- |
| States | 16 | 36 | 225 % |
| Organizations | 45 | 164 | 365 % |
| Stations | 59,000 | 180,000 | 305 % |
| Site Visits | 245,000 | 1,700,000 | 700 % |
| Results | 5,100,000 | 26,600,000 | 520 % |

## 2001

**Pacific Territories (Guam, American Samoa, Northern Marianas) – Not Shown**

## 2004

**Pacific Territories (Guam, American Samoa, Northern Marianas) – 210 Stations Not Shown**

## 2004

**Pacific Territories (Guam, American Samoa, Northern Marianas) – 210 Stations Not Shown**

## Slide 6

## Growth of Software

**Data Entry Forms Module**
**From Version 1.2 to Version 2.0**
**Added support for Graphics, PDF, and Text Documents**
**Station**
**Project**
**Station Visit**
**Result**
**Citation**
**Enhanced Unit of Measure Selection**
**Text Descriptions Increased to 4000 Characters**

## Growth of Software

**Data Entry Forms Module (continued)**
**Station Descriptions**
**Changes to Station Type Permitted**
**Lat/Long Decimal Degrees Support**
**Lat/Long Point Name Support**
**Characteristic Screens support Viewing :**
**Alias Type Names **
**Permitted Values for Selected Characteristic**
**Procedure and Sample Fraction Requirements**
**Taxonomic Hierarchy**
**Row ID in Characteristic Group increased to 20 characters to better support LIMS data**

## Growth of Software

**Data Entry Forms Module (continued)**
**Time Formats now ‘HHMM’**
**Hand Held Data Logger Support**
**Detection Condition “Not Reported”**
**Station–Trip Assignment Eliminated**
**Project Descriptions as PDFs**
**Probabilistic Survey Design Support**
**Station Weights**

## Growth of Software

**STORET Report Module**
**From version 1.2 to version 2.0.4**
**Improved Performance**
**Faster Reports**
**More Data in Each Report**
**Enhanced Content, over 45 new fields**
**Improved Installation**
**Improved Documentation**
**Quick Reference Guide**

## Growth of Software

**STORET Report Module (continued)**
**New Reports**
**Inventory Reports**
**Summary by Station**
**Overall Summary**
**Report Export Sizing**
** ****Physical/Chemical/Biological**
- Small export
- Medium export
- Large export
- Giant export

## Growth of Software

**STORET Report Module (continued)**
**New Reports**
**Export Biological Population Data**
**Export Habitat Data**
**Reference Table Reports**
**Characteristics with Permitted Values**
**Other Permitted Value Lists**
**Display Chemical Names**
**Export Chemical Names**
**Details in Wednesday Presentation**

## Growth of Software

**STORET Interface Module (SIM)**
**From version 1.0 to version 2.0.1**
**Support for Biological Data**
**Support for Portable Data Loggers**
**Export and Import of Configurations**
**Configuration Editing Improvements**
**Web enabled product, Web-SIM (in limited use)**
**XML Support**
**Details in Wednesday Presentation**

## Growth in Training

**Six to Eight Training Sessions per Year**
**Several EPA Regional STORET Coordinators Now Holding Training Sessions**
**All Published Training Materials Available on our Web Site**
**Work in Progress on Computer Based Training Modules**

## Growth on the Internet

**True Data Warehouse Technology**
**Modified Star Schema**
**Speed Enhanced by 200 to 1**
**Customization of Download Formats**
**User-Friendly Interfaces**
**Window to My Environment**
**Map Based**
**Portal to both STORET and USGS NWIS**
**Direct Link from Map to Station Home Page**
**Direct Link from Station Home Page to Data**

## Growth on the Internet

**User Friendly Interface (continued)**
**Enviromapper for Water**
**Portal to Modern STORET and Legacy STORET**
**Direct Link to Station Home Page**
**Direct Link from Station to Data**
**Download limits raised to 60,000 rows**
**Downloads offer standardized units**
**85,000 Hits per Month**
**75 Download Requests per Day**
**Web Services Support Available this Year**

## Slide 17

## Slide 18

## Spread Sheet to Graphic

## Points to Remember

**Bigger**
**More Users (Doing More Work)**
**More Data**
**More Comprehensive coverage**
**Better**
**More Features**
**Better Access**
**Always Room to Improve**
**1-800-424-9067  -or-   **_**[storet@epa.gov](mailto:storet@epa.gov)**_
**http://www.epa.gov/storet**