|
Track: Environmental Management
Bob Farnes
PRC Environmental Management, Inc.
1099 18th Street Suite 1960
Denver, CO 80003
Telephone: 303-312-8837
Fax: 303-295-2818
E-mail: farnesb@prcemi.com
Anne Leibold, Michael Blaskowski
Environmental Data Management and GIS
The management of environmental sampling data for use in a GIS is a complex task. Large amounts of data, sometimes including over one million rows of analytical results, must be entered, maintained, and analyzed using GIS in a timely manner. At PRC Environmental Management, Inc., an Oracle RDBMS serves as a repository for field and laboratory data at sites under investigation. Before data are accepted in the database, they are processed through stored procedures such as constraints and triggers to ensure data integrity and completeness. Using the database integrator, this quality checked data may be accessed by ArcInfo and ArcView for attribute display, spatial analysis, and data modeling. This presentation describes the database management techniques and procedural quality checks as well as the GIS analysis of the environmental data such as risk assessment, site characterization, and desktop access to the analytical data.
|
|
