Author: Douglas A. Olsen

Publisher:

Published: 1997

Total Pages: 32

ISBN-13:

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. The LTRMF Component Database Spatial Query Tool is a Unix based ARC/INFO ARC Macro Language application that integrates the component data with spatial data by taking advantage of the graphical display and query capabilities of ARC/INFO. The application features an easy to use graphical user interface and requires only very basic knowledge of Geographic Information Systems (GIS) to use effectively.