• Title/Summary/Keyword: Spatial Database Management System

Search Result 281, Processing Time 0.021 seconds

Developing a Web-based System for Computing Pre-Harvest Residue Limits (PHRLs)

  • Chang, Han Sub;Bae, Hey Ree;Son, Young Bae;Song, In Ho;Lee, Cheol Ho;Choi, Nam Geun;Cho, Kyoung Kyu;Lee, Young Gu
    • Agribusiness and Information Management
    • /
    • v.3 no.1
    • /
    • pp.11-22
    • /
    • 2011
  • This study describes the development of a web-based system that collects all data generated in the research conducted to set pre-harvest residue limits (PHRLs) for agricultural product safety control. These data, including concentrations of pesticide residues, limit of detection, limit of quantitation, recoveries, weather charts, and growth rates, are incorporated into a database, a regression analysis of the data is performed using statistical techniques, and the PHRL for an agricultural product is automatically computed. The development and establishment of this system increased the efficiency and improved the reliability of the research in this area by standardizing the data and maintaining its accuracy without temporal or spatial limitations. The system permits automatic computation of the PHRL and a quick review of the goodness of fit of the regression model. By building and analyzing a database, it also allows data accumulated over the last 10 years to be utilized.

  • PDF

Storage Manager Considering Spatial Data Characteristics (공간 데이터의 특성을 고려한 저장 관리자)

  • 김종훈;정현민;장성인;정미영
    • Journal of Korea Multimedia Society
    • /
    • v.4 no.6
    • /
    • pp.477-488
    • /
    • 2001
  • As total system performance depends on spatial dta management in spatial database system, low cost method is required. However, spatial data have many characters that are different from multimedia data, data size is almost similar by layer and variable from few bytes to tera bytes. So large data manager of EXODUS and Starburst and BLOB etc, make problems that is many Disk I/O and Disk space waste. This paper proposes new storage method for spatial data considering spatial dta characteristics.

  • PDF

Formal Semantics of Relational Algebra/Calculus for Spatiotemporal Operator in Spatiotemporal Data Model (시공간 데이터 모델에서 시공간 연산자의 관계 수식적 정형의미)

  • Jo, Yeong-So;Kim, Dong-Ho;Ryu, Geun-Ho
    • The Transactions of the Korea Information Processing Society
    • /
    • v.6 no.1
    • /
    • pp.11-20
    • /
    • 1999
  • Because conventional spatial databases process the spatial information that is valid at current time, it is difficult to manage historical information efficiently which has been changed from the past to current. Recently, there are rapid increasing of interest to solve this problem so that makes databases to support historical information as well as spatial management at the same time. It can be eventually used in a various application areas. The formal semantics in a database is used to represent database structures and operations in order to prove the correctiveness of them in terms or mathematics. It also plays an important role in database to design a database and database management system. So in this paper, we suggest spatiotemporal domain, object, data, and spatiotemporal geometric/topological operations. And we not only formalize relational algebra/calculus using formal semantics for a spatiotemporal data model, but also show the example of real orld with them.

  • PDF

A Study on the Architecture Design of Road and Facility Operation Management System for 3D Spatial Data Processing (3차원 공간데이터 처리를 위한 차로 및 시설물 운영 관리 시스템 아키텍처 설계 연구)

  • KIM, Duck-Ho;KIM, Sung-Jin;LEE, Jung-Uck
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.24 no.4
    • /
    • pp.136-147
    • /
    • 2021
  • Autonomous driving-related technologies are developing step by step by applying the degree of driving. It is essential that operational management technology for roads where autonomous vehicles move should also develop in line with autonomous driving technology. However, in the case of road operation management, it is currently managed using only two-dimensional information, showing limitations in the systematic operation management of lane and facility information and maintenance. This study proposed a plan to construct an operation management system architecture capable of 3D spatial information-based operation management by designing a convergence database that can process real-time big data with high-definition road map data. Through this study, when using a high-definition road map based operation management system for lane and facility maintenance in the future, it is possible to visualize and manage facilities, edit and analyze data of multiple users, link various GIS S/W and efficiently process large scale of real-time data.

APPLICATION OF LOGISTIC REGRESS10N A MODEL FOR LANDSLIDE SUSCEPTIBILITY MAPPING USING GIS AT JANGHUNG, KOREA

  • Saro, Lee;Choi, Jae-Won;Yu, Young-Tae
    • Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
    • /
    • 2003.04a
    • /
    • pp.64-64
    • /
    • 2003
  • The aim of this study is to apply and verify of logistic regression at Janghung, Korea, using a Geographic Information System (GIS). Landslide locations were identified in the study area from interpretation of IRS satellite images, field surveys, and maps of the topography, soil type, forest cover, geology and land use were constructed to spatial database. The factors that influence landslide occurrence, such as slope, aspect and curvature of topography were calculated from the topographic database.13${\times}$1ure, material, drainage and effective soil thickness were extracted from the soil database, and type, diameter and density of forest were extracted from the forest database. Land use was classified from the Landsat TM image satellite image. As each factor's ratings, the logistic regression coefficient were overlaid for landslide susceptibility mapping. Then the landslide susceptibility map was verified and compared using the existing landslide location. The results can be used to reduce hazards associated with landslides management and to plan land use and construction.

  • PDF

APPLICATION OF LIKELIHOOD RATIO A MODEL FOR LANDSLIDE SUSCEPTIBILITY MAPPING USING GIS AT JANGHUNG, KOREA

  • Choi, Jae-Won;Lee, Saro;Yu, Young-Tae
    • Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
    • /
    • 2003.04a
    • /
    • pp.63-63
    • /
    • 2003
  • The aim of this study is to apply and verify of Bayesian probability model, the likelihood ratio and statistical model, at Janghung, Korea, using a Geographic Information System (GIS). Landslide locations were identified in the study area from interpretation of IRS satellite images, field surveys, and maps of the topography, soil type, forest cover, geology and land use were constructed to spatial database. The factors that influence landslide occurrence, such as slope, aspect and curvature of topography were calculated from the topographic database. Texture, material, drainage and effective soil thickness were extracted from the soil database, and type, diameter and density of forest were extracted from the forest database. Land use was classified from the Landsat TM image satellite image. As each factor's ratings, the likelihood ratio coefficient were overlaid for landslide susceptibility mapping, Then the landslide susceptibility map was verified and compared using the existing landslide location. The results can be used to reduce hazards associated with landslides management and to plan land use and construction.

  • PDF

Development of a Web-based Geovisualization System using Google Earth and Spatial DBMS (구글어스와 공간데이터베이스를 이용한 웹기반 지리정보 표출시스템 개발)

  • Im, Woo-Hyuk;Lee, Yang-Won;Suh, Yong-Cheol
    • Spatial Information Research
    • /
    • v.18 no.4
    • /
    • pp.141-149
    • /
    • 2010
  • One of recent trends in Web-based GIS is the system development using FOSS (Free and Open Source Software). Open Source software is independent from the technologies of commercial software and can increase the reusability and extensibility of existing systems. In this study, we developed a Web-based GIS for interactive visualization of geographic information using Google Earth and spatial DBMS(database management system). Google Earth Plug-in and Google Earth API(application programming interface) were used to embed a geo-browser in the Web browser. In order to integrate the Google Earth with a spatial DBMS, we implemented a KML(Keyhole Markup Language) generator for transmitting server-side data according to user's query and converting the data to a variety of KML for geovisualization on the Web. Our prototype system was tested using time-series of LAI(leaf area index), forest map, and crop yield statistics. The demonstration included the geovisualization of raster and vector data in the form of an animated map and a 3-D choropleth map. We anticipate our KML generator and system framework will be extended to a more comprehensive geospatial analysis system on the Web.

A Prototype of the Map Viewer based Spatial DB for the Integrated Urban Flooded Area Management System (도시침수 통합관리 시스템 구축을 위한 공간DB기반 Map Viewer 프로토타입 설계)

  • Kim, Ki-Uk;Seo, Tae-Woong;Kim, Chang-Soo
    • 한국방재학회:학술대회논문집
    • /
    • 2008.02a
    • /
    • pp.339-342
    • /
    • 2008
  • Recently the life and property damage caused by urban inundation have increased. In order to prevent the damage by inundation the researches for displaying the flooded areas through integrating SWMM and GIS have been progressed. However most of flood analysis systems only have used the GIS to display the flooded areas, and don't provide the integration disaster information to prevent the inundation. In this paper, we design a prototype for the Map Viewer based Spatial DB for the integrated urban floooded area management system. And we implement the spatial DB conversion module.

  • PDF

Slope Navigation based on the Cut Slope Data Management System (내비게이션 기반 절토사면 데이터 관리시스템)

  • Bae, Sang-Woo;Kim, Seung-Hyun;Lee, Jong-Hyun;Koo, Ho-Bon;Lee, Yun-Rae
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.18 no.4
    • /
    • pp.71-77
    • /
    • 2010
  • Cut Slope Management System(CSMS) is a systematic maintenance and management system designed to prevent the collapse of cut slopes located along national roads. In order to implement safe road operation system, KICT has started the inventory of cut slopes and developed a cut slope database since 2006. Cut slope database management system using GIS technology and navigation system was developed as a Information Technology application. Through the Cut Slope Navigation System(SLOPE-Navi.), the previously developed database was checked and verified. The converted cut slope inventory data and field investigation data of 28,707 cut slopes were loaded on the navigation map. We consider that the Cut Slope Navigation Management System can be useful as in-situ system, which can be systematic and effective DB management and operation to prevent cut slope collapses and establish a remedial countermeasure as mitigation concerning disasters.

3D GSIS Application for Managing Flood Disaster (홍수재해관리를 위한 3차원 GSIS적용)

  • Yoo, Hwan-Hee;Kim, Uk-Nam;Kim, Seong-Sam;Chung, Dong-Ki
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.12 no.1 s.28
    • /
    • pp.21-29
    • /
    • 2004
  • Floods are disastrous natural phenomena which result in numerous losses of life and property. It is possible to minimize the potential risk by adopting a disaster management system. Nowadays, Geo-Spatial Information System(GSIS) and computer-modelling techniques have assisted scientists and engineers with determining flood disaster assessments, GIS technologies especially have the advantage of performing spatial analysis as well as generating the model for a flood hazard. Therefore, this paper presents the flood management system based on 3D GSIS that can cope with natural disasters actively and manage flood hazard systematically by constructing the database using hydrological data, digital map, DEM, and high-resolution satellite images.

  • PDF