290 likes | 386 Views
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. Background and Objectives
E N D
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 • Background and Objectives • Environmental Information System Framework • Pantex Spatial Database Development and Management • Additional EIS Components and Technologies • Conclusion • Future Works • Demo
Background • America’s 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
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
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) Administration (Storage, update, back) Implementation GIS Spatial Database Management Spatial Database Development Training Data Process (Procedure, Quality Control) Distribution (Online, CD-ROM, Internet)
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
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*
Arc/Info Librarian ArcStorm Oracle Sybase Microsoft SQL Server Ethernet NFS or File Sharing Ethernet TCP/IP DBMS Network Client Spatial Data Server Attributes Data Server Clients: ArcView & Arc/Info MapOjbects Other mapping applications Data Storage: Two-Server Architecture
RDBMS Oracle Sybase Microsoft SQL Server SDE DBMS NW Server Ethernet NFS or File Sharing Ethernet TCP/IP DBMS NW Client Clients ArcView & Arc/Info MapOjbects Other mapping applications Data Storage: One-Server Architecture Spatial query allowed
CD-ROM ArcView Arc/Info MapOjbects Other mapping applications Microsoft Access Regional data Coverages Shape files Grids Images Sampling data MS Access Tables Queries Database Storage: CD-ROM Approach Advantage • Wide Distribution Range • Client-end Operation • Simple & Customized Structure • Fast Access Speed
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
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
Pantex Spatial Database - Objectives: To develop a spatial database framework for assisting in characterization of environmental risks of Pantex Plutonium MOX fuelprocessing facility, and to develop and analyze potential pathways for human and ecological exposures
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
Projection: State Plane Coordinates Study region & Projection Study Region:
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
Regional Description Data Raster Image Census Stream Land Use Site Layout Aquifer Vegetation Soil
Additional Components of EIS • Integrate Microsoft Access with ArcView • Research Intranet for Risk Characterization of Pantex Plutonium MOX Processing Facility
ArcView Microsoft Access Integrate Access with ArcView - Why? Attribute Information Spatial Information Why? • RDBMS • Query • Form Input • Report output • Active X • Display • Analysis
1 2 3 6 4 Data of Interest 5 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
Integrate Access with ArcView - Example! 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 • 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 Demo: Let’s Go!
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.
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