Component Database Spatial Query Tool User's Guide


Olsen, D. A.  1997.  Long Term Resource Monitoring Program Component Database
Spatial Query Tool User's Guide.  U.S. Geological Survey, Environmental
Management Technical Center, Onalaska, Wisconsin, August 1997.  LTRMP 97-P010. 
12 pp. + Appendix  (NTIS #PB97-208847)


ABSTRACT

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
LTRMP 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.

KEYWORDS

Component database, GIS, spatial query, visualization