Environmental Information System Framework for Pantex Plant

1
Environmental Information System Framework for
Pantex Plant

• Presented by
• Ye Maggie Ruan
• (http//www.ce.utexas.edu/stu/ruanym/homepage/Rese
  arch.htm)

2
Acknowledgement
Dr. David Maidment Dr. Randy Charbeneau Dr.
Maidments Research Group
3
Outline

• Background and Objectives
• Environmental Information System Framework
• Pantex Spatial Database Development and
  Management
• Additional EIS Components and Technologies
• Conclusion
• Future Works
• Demo

4
Background

• Americas only nuclear weapon assembly and
  disassembly site
• Environmental Issues
• Risk to Workers and the Publics
• Air and Water Quality
• Effect on agriculture
• Public Concerns
• Safety
• Environment

5
Current Pantex Database

• Sybase and Intergraph MGE
• Contains Environmental samples, Regulatory
  limits, Facility management, Map information
• 6,657 Sampling Locations
• 2.6GB, 197 Tables and 3,566,104 Data Records
• Updated Daily

6
Objectives
To construct Environmental Information System
Framework for the Pantex Facility so that
environmental information is provided for both
professional environmental engineers and general
publics
7
EIS Framework
Information Source (Types, Sites, Methods)
Administration (Storage, update, back)
Implementation
GIS
Spatial Database Management
Spatial Database Development
Training
Data Process (Procedure, Quality Control)
Distribution (Online, CD-ROM, Internet)
8
Spatial Database Development
Regional Description Environmental
Sampling Regulatory limits
Information Source (Types, Sites, Methods)
User Needs
Spatial Database Development
Gathering and processing the information into a
consistent format
Data Process (Procedure, Quality Control)
Study Region Coordinates and Projection
Consistent
9
Spatial Database Management
Easy to Maintain Secure Accurate
Storage Update Backup
Administration
Spatial Database Management
Keep the database secure, widely accessible and
easy to use
Distribution
Wide Range Multi-Format Easy to Use
Online CD-ROM Internet
10
Data Storage Two-Server Architecture
11
Data Storage One-Server Architecture
Spatial query allowed
12
Database Storage CD-ROM Approach
Advantage

• Wide Distribution Range
• Client-end Operation
• Simple Customized Structure
• Fast Access Speed

13
ArcView Internet Map Server
Web Browser
ArcView Internet Map Server
Map Café
Internet
Custom Application
TCP/IP
SDE
esrimap.dll
ArcView IMS
Web server extension
ArcView IMS extension
ArcView
Web Server
GIS DBMS
14
MapObjects Internet Map Server
MapObjects Internet Map Server
Web Browser (e.g, NetScape or Internet Explore)
Internet
Custom Application
TCP/IP
SDE
esrimap.dll
webLink.ocx
Web server extension
MapObjects
Web Server
GIS DBMS
15
ArcView vs. MapObject Internet Map Server
16
Pantex Spatial Database - Objectives
To develop a spatial database framework for
assisting in characterization of environmental
risks of Pantex Plutonium MOX fuel processing
facility, and to develop and analyze potential
pathways for human and ecological exposures
17
Data Types

• Raster Image of the Pantex Site and Surrounding
  Region
• Census description of population
• Stream Transportation Digital Line Graph
• Land Use Land Cover Description
• Statsgo Soil Description
• Vegetation Description
• Aquifer Description
• Facility Layout

18
Study region Projection
Study Region
19
Basic Process Procedure

• Retrieve the raw data from the source (e.g.,
  Internet)
• Reformat the data file to be compatible with
  Arc/Info
• Merge the data sets to form a larger continuous
  seamless data set
• Customize the attributes information to meet the
  user needs
• Project the merged data set to the desired
  projection
• Clip the data sets for the defined study region

20
Regional Description Data
Raster Image
Census
Stream
Land Use
Site Layout
Aquifer
Soil
Vegetation
21
Additional Components of EIS

• Integrate Microsoft Access with ArcView
• Research Intranet for Risk Characterization of
  Pantex Plutonium MOX Processing Facility

22
Integrate Access with ArcView - Why?
Attribute Information
Spatial Information
Why?

• RDBMS
• Query
• Form Input
• Report output
• Active X

• Display
• Analysis

23
Integrate Access with ArcView - How?


How?
Site
Data
1. Export Site location 2. Create Points 3.
Spatially Select 4. Query Data of Interest 5.
Return Data of Interest 6. Display and Analysis
Access
ArcView
24
Integrate Access with ArcView - Example!
Example
Nitrate distribution in the Groundwater of Pantex
25
Research Intranet - Framework Teams
Risk Characterization Framework
Teams

• ANRCP
• CRWR
• Texas AM
• Pantex

26
Research Intranet - Objectives

• Define the objective and scope of the project
• Clarify the individual function of each team in
  the project
• Set up a channel for easy communication
• Provide the online resources for each technical
  subject
• Update the progress report
• Preview the public information

27
Research Intranet - Demo
Demo
Lets Go!
28
Conclusions

• EIS can be beneficial for Environmental projects.
• Retrieving environmental information from the
  Internet is efficient and cost-effective.
• A CD-ROM database management system provides wide
  distribution range, simple structure and fast
  access speed.
• Microsoft Access can be integrated to ArcView as
  external relational database management system.
• Internet Map Servers provides environmental
  information to general publics.

29
Future Work

• Complete the Spatial Database by Providing More
  Types of Data
• Improve the Connection between ArcView and Access
• Set Up the Internet Map Server
• Polish the Intranet and Public Window