Long Term Resource Monitoring Program Component Database Spatial Query Tool User's Guide

The Environmental Management Technical Center stores point-sampled data for fisheries, water quality, and invertebrates in a relational database management system. These component data are collected at fixed and random sites in each of the key Long Term Resource Monitoring Program (LTRMP) study Pools: 4, 8, 13, 26, and the open river reach on the Mississippi River; and the La Grange Pool on the Illinois River. While the geographic locations of these data are also collected and stored, the tools to automate the integration of these data with spatial data had not previously been developed. A need existed for an application that would facilitate spatial subsetting and visualization of the distribution of sites meeting certain query criteria. [...]