Environmental Information System Framework for Pantex Plant Presented

Environmental Information System Framework for Pantex Plant Presented by Ye Maggie Ruan (http: //www. ce. utexas. edu/stu/ruanym/homepage/Research. htm)

Acknowledgement Dr. David Maidment Dr. Randy Charbeneau Dr. Maidment’s Research Group

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

Background u u America’s only nuclear weapon assembly and disassembly site Environmental Issues – Risk to Workers and the Publics – Air and Water Quality – Effect on agriculture u Public Concerns – Safety – Environment

Current Pantex Database u Sybase and Intergraph MGE u Contains Environmental samples, Regulatory limits, Facility management, Map information u 6, 657 Sampling Locations u 2. 6 GB, 197 Tables and 3, 566, 104 Data Records u Updated Daily

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

EIS Framework Information Source (Types, Sites, Methods) Spatial Database Development Data Process (Procedure, Quality Control) Administration (Storage, update, back) GIS Spatial Database Management Distribution (Online, CD-ROM, Internet)

Spatial Database Development Information Source (Types, Sites, Methods) Spatial Database Development Data Process (Procedure, Quality Control) Regional Description Environmental Sampling Regulatory limits Gathering and processing the information into a consistent format Study Region Coordinates and Projection

Spatial Database Management Administration Spatial Database Management Distribution Storage* Update Backup Keep the database secure, widely accessible and easy to use Online CD-ROM Internet*

Data Storage: Two-Server Architecture Arc/Info Librarian Arc. Storm Ethernet NFS or File Sharing Spatial Data Server Oracle Sybase Microsoft SQL Server Attributes Data Server Clients: Arc. View & Arc/Info Map. Ojbects Other mapping applications Ethernet TCP/IP DBMS Network Client

Data Storage: One-Server Architecture RDBMS SDE Ethernet NFS or File Sharing Oracle Sybase Microsoft SQL Server DBMS NW Server Spatial query allowed Clients Arc. View & Arc/Info Map. Ojbects Other mapping applications Ethernet TCP/IP DBMS NW Client

Database Storage: CD-ROM Approach Advantage Regional data Coverages Shape files Grids Images Arc. View Arc/Info Map. Ojbects Other mapping applications Sampling data • Wide Distribution MS Access Tables Queries Range • Client-end Operation Microsoft Access • Simple & Customized Structure • Fast Access Speed

Arc. View Internet Map Server Web Browser Arc. View Internet Map Server Map Café Internet Custom Application TCP/IP esrimap. dll Web server extension Web Server Arc. View IMS SDE Arc. View IMS extension Arc. View GIS DBMS

Map. Objects Internet Map Server Web Browser (e. g, Net. Scape or Internet Explore) Internet Custom Application TCP/IP esrimap. dll web. Link. ocx SDE Web server extension Web Server Map. Objects GIS DBMS

Arc. View vs. Map. Object Internet Map Server

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

Data Types: u u u u 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

Study region & Projection Study Region: Projection: State Plane Coordinates

Basic Process Procedure u u u 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

Regional Description Data Raster Image Soil Census Stream Land Use Aquifer Vegetation Site Layout

Additional Components of EIS u Integrate Microsoft Access with Arc. View u Research Intranet for Risk Characterization of Pantex Plutonium MOX Processing Facility

Integrate Access with Arc. View - Why? Spatial Information Arc. View • Display • Analysis Attribute Information Microsoft Access • RDBMS • Query • Form Input • Report output • Active X

Integrate Access with Arc. View - How? 1 2 Site 6 1. Export Site location 2. Create Points 3. Spatially Select 4. Query Data of Interest 5. Return Data of Interest 6. Display and Analysis 3 Data of Interest Arc. View 4 5 Data Access

Integrate Access with Arc. View - Example! Nitrate distribution in the Groundwater of Pantex

Research Intranet - Framework & Teams Risk Characterization Framework Teams • ANRCP • CRWR • Texas A&M • Pantex

Research Intranet - Objectives u u u 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

Research Intranet - Demo:

Conclusions u u u 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 Arc. View as external relational database management system. Internet Map Servers provides environmental information to general publics.

Future Work u u Complete the Spatial Database by Providing More Types of Data Improve the Connection between Arc. View and Access Set Up the Internet Map Server Polish the Intranet and Public Window