- Water Quality Monitoring
- Permit Tracking
- Vegetation Monitoring
- Customer/Product Tracking
- Geologic Exploration
- Municipal Planning
Database Solutions
Relational databases provide a powerful tool for organizing, analyzing, and reporting diverse types of information. A relational database relies on defined links between numerous tables in the database. These relationships allow consistent and efficient data storage, management, and analysis. Relational databases are routinely used to manage large scientific and business data sets.
DTM utilizes both desktop and enterprise databases to manage both spatial and non-spatial information. These databases are often integrated with either GIS or web-based applications to provide flexible and intuitive user access to data.
Examples of Completed Database Projects
Yellowstone River Cummulative Effects Atlas. Yellowstone River Conservation Districts Council. In this current project, DTM is developing a prototype database structure to store existing reach-based information for existing reach-based information on the Yellowstone River. Summarized information from the Hydrology, Hydraulics, Riparian, Fisheries, Avian, and Wetlands scopes will be integrated into the database as data allow. This database will be used to drive the creation of a Cummulative Effects Atlas, providing reach narratives for the river from Gardiner, MT to its confluence with the Missouri River in North Dakota.
- Marias River Corridor Database. Pondera County Coservation District, Montana. This database was developed to track water quality and corridor condition monitoring within the Marias River watershed. It includes sections for water quality, photo points, vegetation transects and cross sections. Custom queries and reports allow the user to explore and report on the available data, as well as link the information to a Geographic Information System (GIS).
Water Sentinel. Cascade Earth Sciences. DTM developed a robust Internet-based database application to assist farmers and food processors track process water application to agricultural fields. The application has a secure interface allowing managers to input, track, report and graph water application rates, chemistry, water quality and compliance with regulatory requirements. On-line reports are formatted to meet state reporting requirements. The system is flexible and can be adapted to numerous scenarios.
GPS Animal Location Tracking Database. USGS. DTM has been involved in an ongoing project for tracking and analyzing GPS derived locations of animals. The database has modules for importing and processing raw GPS location files and formatting them for incorporation in a Geographic Information System. The associated GIS application is linked to the database and has modules for importing, displaying and analyzing animal locations.
