Development timeframe
  Current IIMS datasets
  Current IIMS features
  Future datasets and feature enhancements
  Meeting minutes and reports
  Organizational roles
  Contacts

Integrated Information Management System (IIMS)

The IIMS is a multi-disciplinary warehouse for centralizing the disparate data required to support the management of river systems. The IIMS vision is to build a modular information management system by combining the common needs of several river systems into a central tool that is scalable in two dimensions.

 

Modular and scalable approach to the Integrated Information Management System (IIMS)

This approach exploits the high degree of similarity of data and tools required for river system management. Essentially, the IIMS will use this economy of scale to repeat the IIMS for multiple river systems, each time benefiting from the existing implementation and therefore reducing the overall development effort.

The IIMS vision is to build the default "go-to" tool to meet scientists' data requirements for doing research into river systems; if you want the latest data — you go to the IIMS; if you want to share your modeling results — you go to the IIMS; if you want to produce a report evaluating the success of an individual restoration action or a suite of actions — the IIMS has all the information readily available. Contrasting this, TRRP scientists currently have to put in considerable effort and go to several sources to collect together the data for common types of analyses.

The IIMS will be developed for the Trinity River Restoration Program (TRRP) over three years. IIMS will be housed on Bureau of Reclamation computer servers with public access portals to facilitate data sharing and transparency with program partners, stakeholders, and the public. Other Reclamation offices will be able to easily implement and modify IIMS modules developed on the Trinity to meet basin specific data and analysis needs in other rivers basins.

 

Development timeframe

The IIMS will be developed between 2006 and 2009. A working version of the IIMS exists at the TRRP offices in Weaverville, CA. Over the next three years, additional datasets and functionality will be added, with a selection being made available to program partners and the general public.

IIMS Development Timeframe

 

Current IIMS datasets (as of 09-10-07)

Note this list of current datasets will continue to be expanded throughout the IIMS development timeframe.

Variable Features Dates Locations Records
Streamflow
Daily mean   Oct 1907 to April 2007 24 locations on Trinity and lower Klamath rivers 314,560
Instantaneous
(15 minutes)
  Oct 1981 to July 2006 15 locations 1,375,724
     
Total records:
1,690,284
Sediment Transport
Bedload samples Bedload Particle Size Analyses Dec 1996 to present 14 locations 89,536
     
Total records:
89,536
Water Temperature
El Nino Index Annual measurements Jan 1950 to Jan 2006 Pacific Ocean 57
Ocean Buoy Hourly temperature measurements Jan 1982 to Dec 2005 Eel River Buoy 182,095
River Hourly and daily values
 - Mike Deas
 - CDEC
Jan 2000 to April 2006 29 locations 517,926
     
Total records:
700,078
Lake Temperature Profiles
N/A 2,000 ft from dams at 25 ft elevations Jan 1972 to Sept 2006 Trinity and Lewiston Lakes 10,046
     
Total records:
10,046
Reservoir Inflow
Daily Mean Inflow Daily inflows Nov 1962 to present Trinity and Lewiston dams and Carr Power Generation Facility 47,269
     
Total records:
47,269
Dam Releases
Total Release to River Daily outflows Nov 1962 to present Trinity and Lewiston dams 31,563
Diversion through Carr Tunnel Daily outflows Oct 1963 to present Lewiston Dam 15,706
     
Total records:
47,269
Reservoir Elevation
Elevation Daily values Nov 1962 to present Trinity and Lewiston dams and Carr Power Generation Facility 47,269
     
Total records:
47,269
Dam Storage
Storage Daily values Nov 1962 to present Trinity and Lewiston dams and Carr Power Generation Facility 47,269
24 Hour Change Daily values Nov 1962 to present Trinity and Lewiston dams and Carr Power Generation Facility 47,269
     
Total records:
94,538
Fish Population
Out-migrants Rotary screw traps USFWS March 1999 to Sept 2005 Trinity River at Willow Creek USFWS (HPA) 85,239
Run size estimates   1991 to 2005 Trinity River at Junction City Weir and Willow Creek Weir 58
Redds USFWS Oct 2001 to Jan 2006 Locations not incorporated 11,040
     
Total records:
96,337
Realty
N/A Trinity County Assessor Parcels (Ownership, address, ROE)   Trinity County 17,097
      Total records: 17,097

 

Current IIMS features

Quick Data Query - enables users to select a dataset and quickly retrieve data based on different criteria: date range, locations, species etc. The query results are shown in a tabular format and can be exported into any Microsoft Office format.

Document Library - a repository of electronic files in any format. These may be documents, reports, permits, images etc. Each document is tracked with metadata and the repository can be searched by keyword, title or description. Users can quickly and easily retrieve and open the associated documents or save them to their computer.

Flow Scheduler - enables users to create candidate water year flow release schedules from a dam into the Trinity River. This powerful tool allows users to start from any existing schedule: either a Record of Decision (ROD) schedule, or another candidate generated by another user. The flow scheduler incorporates automated graphs and a compressed schedule view for printing the entire water year on one page.

Realty and ROE - tracks ownership information associated with assessor parcels together with the status of rights of entry and access permits.

Reports - There are over a dozen standard IIMS reports that format the data and contain frequently used graphs and summary layouts. The IIMS reporting features are customizable making it straightforward to add new reports.

 

Future datasets and feature enhancements

The following document captures the additional datasets and feature enhancements identified by the IIMS team.

Future Datasets and Enhancements [PDF - 40kb]

 

Meeting minutes and reports

Date Description
31 March 2007 Quarterly Report – 1st and 2nd Quarter FY06-07[PDF - 90kb]
2 November 2006 IIMS Team Meeting, Weaverville, CA
Minutes and summary [PDF - 50kb]

 

Organizational roles

The IIMS will be developed for Reclamation by the Utah State University (USU) and ESSA Technologies (ESSA), with additional organizations providing smaller support roles for specific tasks. USU personnel have considerable expertise in the domain of hydrological decision analysis tools and the intention is to leverage much of their existing expertise in developing GIS-based data analysis and model integration tools for the IIMS. These preexisting modules bring critical value to the IIMS and avoid the need to build the entire application from the ground up.

ESSA will be responsible for conducting the user requirements gathering, high level design, and coordination with the TRRP Integrated Assessment Plan — the framework that defines how the TRRP will monitor the Trinity River during restoration activities.

 

Contacts

Andreas Krause David Stevens Philip Bailey
Trinity River Restoration Program
Ph. (530) 623-1807
akrause@mp.usbr.gov
Utah State University
Ph. (435) 797-3229
david.stevens@usu.edu
ESSA Technologies
Ph. (604) 733-2996
pbailey@essa.com