Client: Wyoming Department of Environmental Quality / Abandoned Mine Lands Division
Project Overview: In 2000 and 2001, AML undertook an effort to modernize their internal inventory database of abandoned mine sites throughout Wyoming . This effort culminated with the development of database and GIS information management applications. AML contracted with Trihydro to help maintain and to update the applications. Between 2001 and 2004, Trihydro assisted AML with maintenance of these applications. Maintenance activities during the period ranged from creating an AML/GIS Quick Reference Guide, to registering and loading historic mine maps, to updating background layers (e.g. aerial, topographic and geologic mapping). Maintenance also involved assisting AML with the cleanup or addition of data for specific sites.

In 2003, AML undertook an effort to update and complete their existing inventory. As part of this effort, AML contracted with Trihydro to coordinate eight other consultants and manage data collection from more than 1,500 site inventories. This project also involved conducting significant upgrades to the GIS and database applications. These upgrades were primarily associated with increasing usability of the applications and allowing for management of feature-specific, rather than simply site-specific information. To meet AML's technology objectives, Trihydro completed the following tasks:

• Restructured the existing AML MS Access database and converting the database to a SQL Server platform. This database includes custom programming to import field data from the AML-specific field databases that were developed by Trihydro as part of a separate contract.
• Provided access to the SQL Server database through both an Access front-end (for the AML Database Administrator) and a website that allows the information to be served to remote offices or consultants.
• Restructured the existing GIS application to allow for detailed site and feature searching and querying and user-friendly map generation/plotting. The upgraded application, which was moved to ArcMap 9.1, also provides a number of AML specific tools, and allows the user to view landownership, individual features, mine maps and digital photos.
• Developed two custom ArcIMS (Internet Map Server) website applications to serve AML inventory information remotely. One application serves controlled information to the public, and a second, secured site serves more detailed information remotely to AML personnel and consultants.
• Assisted AML personnel with the setup, installation and trouble-shooting of software and applications.

The upgraded GIS, database, and web applications were successfully installed on the AML system in December 2005. In finalizing this project, Trihydro made two presentations at the National AML Conference in September 2005 and have provided training on the application to more than 50 WDEQ/AML and contractor personnel.

Client: Wyoming-based Engineering Firm
Project Overview: Trihydro created a new application designed to streamline and enhance a number of data entry and reporting processes utilized by a Wyoming-based engineering firm on their AML drilling and grouting projects. First, the application provides a single data entry point, which is an advantage over the past six data entry points. Second, the application has a survey data upload feature that allows the user to easily input survey data. This improves the integration of technologies and provides the engineers data access to produce the drilling figures. The application also imbeds the ability to run reports on stored data such that the user now has quicker and more efficient access to project business data. Finally, the Trihydro Drilling and Grouting Management Application provides a data export function for CADD/GIS import, thus allowing project maps and schematic diagrams to be created with greater ease.

Using portal technology, securing this information is very easy. The security model provided by Trihydro allows users to use their current network login to access this system eliminating the need for users to remember multiple usernames and passwords. These tools also come with an administration application that has an intuitive design that allows you to modify user security quickly and effectively.

Trihydro’s Drilling and Grouting Management Application leverages several technologies to allow for Rapid Application Development (RAD). This allows us to customize to this application quickly. The application is developed in C# as a Microsoft .NET Framework web application. The Microsoft .NET Framework allows the application to be easily modified or enhanced. On the back end it uses an organizational style relational database as the data store. This provides users the ability to query the data in an ad-hoc manner as well as provide standard reporting. Trihydro was responsible for delivering the following:

• Drilling and Grouting Data Model – Stores project information, drilling data, grouting data, pay quantities and contractors.
• Web based application on intranet for entry, editing and reporting.
• Reporting capabilities for eight standard reports, exportable to many formats.
• Ability to export coordinates and data to CADD/GIS.