Development of Two-tier Database Application with Commercial Satellite Image under Secure Firewall

Year
2002
Author(s)
Park Wan Sou - Korea Atomic Energy Research Institute
Park Seung Sik - Korea Atomic Energy Research Institute
Kim Hyun TAE - Korea Atomic Energy Research Institute
Abstract
To meet the requirements of the Additional Protocols to Safeguards Agreement (INFCIRC/540(Corrected)), the fusion of geospatial information with the traditional table oriented information is required. With the rapid development of internet related technology and the availability of high resolution commercial satellite images it is possible to integrate the traditional table-centered database and geospatial information. But the full scale GIS (Geospatial Information System) development is not fit for the small size information system and can hardly meet the time constraint under the limited budget and manpower. In this paper a modified approach suitable to the workgroup level database application on the intranet web site is described. Satellite images taken by IKONOS-2 satellite of 1 meter resolution from e-HD.com Korea and Space Imaging U.S.A. and satellite images taken by Arirang 1 satellite of 6.6 meter resolution from the KARI (Korea Aerospace Research Institute) were used. From the satellite image in .geotif format two kinds of raster images in .jpg format were exported, full area and interested area. The satellite image also was used to extract the vector image with feature types of point, line, and polygon by means of the heads-up digitizing using ArcView 8.1 of ESRI (Environmental Systems Research Institute Inc. U.S.A.). These images are geo-referenced in the wide sense with corresponding satellite images and maintained as layers in the .mdb geodatabase of ArcView 8.1. The .mdb database is one of database file types which Microsoft Access 2002 supports. As a back-end database of the two-tier database application the .mdb database also is used and as a front-end the Data Access Page (DAP), one of objects of Access 2002, in .htm file type is used. The intranet web site is managed by FrontPage 2002 and accesscontrolled by the IP address filtering of the Internet Information Server (IIS) 5 web server running on Windows 2000 Server and protected by the KAERI (Korea Atomic Energy Research Institute) firewall.