• Title/Summary/Keyword: Spatial Database Management System

Search Result 283, Processing Time 0.025 seconds

A prediction and distribution of Moors Applying to Environment Assesment Based on E-GIS (환경지리정보 기반의 환경평가 적용시 습지분포 및 규모예측)

  • Kwak, Young-Joo;Park, Sang-Yong;Kang, In-Joon
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.13 no.3 s.33
    • /
    • pp.53-57
    • /
    • 2005
  • The moors ecosystem is sensitive environment change and weak in artificial interference. These nature property are very important to people. It is necessary to preservation and protection the moors with a countermeasure. We really need to Environment-GIS(E-GIS) using Geographical Information System(GIS) and digital map including range, correct position and attribute data of moors. In this study, we take priority of making a database of moors management. Taking effect an environment assesment, we concentrate on a standard method of digital map production and a preservation of moors in our research using GIS. Especially, we have to preserve our important national heritage using GIS when Environment Assesment is conducting under construction. We suggest to pre-estimated model of hidden moors as analysing terrain, geological feature, a geographical distribution of plants and animals using GIS.

  • PDF

Risk Evaluation of a Road Slope on Hazard Using 3D Scanner (사면재해 평가의 3차원 스캐닝 기법적용)

  • Kwak, Young-Joo;Jang, Yong-Gu;Kang, In-Joon
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.13 no.2 s.32
    • /
    • pp.45-50
    • /
    • 2005
  • Recently, slope failures are disastrous when they occur in mountainous area adjoining highways. The accidents associated with Slope failures have increased due to rapid urbanization of mountainous area. Therefore, the inspection of slope is conducted to maintain road safety as well as road function. In this study, we apply to the remedy which is comparing existent description to advanced technology using GIS. we utilize a 3D scanner, one of the advanced method, to generate precise and complete road slope model from expert point of view. In result, we are transferred practical data from external slope stability to hazard slope information. We suggest not only the database but also the method of road risk evaluation based on GIS.

  • PDF

Measurement of Joint-Orientation and Monitoring of Displacement in Tunnel using 3D Laser Scanning System (3차원 레이저 스캐닝 시스템을 이용한 불연속면의 방향성 측정과 터널 변위 모니터링)

  • Shon, Ho-Woong;Oh, Seok-Hoon;Kim, Young-Kyung
    • Journal of the Korean Geophysical Society
    • /
    • v.9 no.1
    • /
    • pp.47-62
    • /
    • 2006
  • More than 70% of Korean Peninsula is consisted of mountains, so that lots of roads, rail-roads and tunnel,which play a pivotal role in the industry activity, are existed along the rock-slope and in the rock-mass. Thus,it is urgent that tegration of management system through the optimum survey and design of rock-slope excavation, proper stabilization method and database of rock-slope. However, conventional methods have shortcoming with the economy of survey time and human resources, and the overcome of difficulties of approach to the in-situ rock-slope. To overcome the limitation of conventional method, this paper proposed the development of remote measurement system using Terrestrial Laser Scanning System. The method using Terrestrial 3D Laser Scanning System, which can get 3D spatial information on the rock-slope and2)Dept. Geosystem Engineering, Kangwon National University, Korea tunnel, has an advantage of reduction of measurement time and the overcome of difficulties of approach to the in-situ rock-slope/dam/tunnel. In the case of rock-slope, through the analysis of 3D modeling of point-cloud by Terrestrial Laser Scanning System, orientation of discontinuity, roughness of joint surface, failure shape and volume were successively achieved. in the case of tunnel face, through reverse-engineering, monitoring of displacement was possible.

  • PDF

A Study on Damage factor Analysis of Slope Anchor based on 3D Numerical Model Combining UAS Image and Terrestrial LiDAR (UAS 영상 및 지상 LiDAR 조합한 3D 수치모형 기반 비탈면 앵커의 손상인자 분석에 관한 연구)

  • Lee, Chul-Hee;Lee, Jong-Hyun;Kim, Dal-Joo;Kang, Joon-Oh;Kwon, Young-Hun
    • Journal of the Korean Geotechnical Society
    • /
    • v.38 no.7
    • /
    • pp.5-24
    • /
    • 2022
  • The current performance evaluation of slope anchors qualitatively determines the physical bonding between the anchor head and ground as well as cracks or breakage of the anchor head. However, such performance evaluation does not measure these primary factors quantitatively. Therefore, the time-dependent management of the anchors is almost impossible. This study is an evaluation of the 3D numerical model by SfM which combines UAS images with terrestrial LiDAR to collect numerical data on the damage factors. It also utilizes the data for the quantitative maintenance of the anchor system once it is installed on slopes. The UAS 3D model, which often shows relatively low precision in the z-coordinate for vertical objects such as slopes, is combined with terrestrial LiDAR scan data to improve the accuracy of the z-coordinate measurement. After validating the system, a field test is conducted with ten anchors installed on a slope with arbitrarily damaged heads. The damages (such as cracks, breakages, and rotational displacements) are detected and numerically evaluated through the orthogonal projection of the measurement system. The results show that the introduced system at the resolution of 8K can detect cracks less than 0.3 mm in any aperture with an error range of 0.05 mm. Also, the system can successfully detect the volume of the damaged part, showing that the maximum damage area of the anchor head was within 3% of the original design guideline. Originally, the ground adhesion to the anchor head, where the z-coordinate is highly relevant, was almost impossible to measure with the UAS 3D numerical model alone because of its blind spots. However, by applying the combined system, elevation differences between the anchor bottom and the irregular ground surface was identified so that the average value at 20 various locations was calculated for the ground adhesion. Additionally, rotation angle and displacement of the anchor head less than 1" were detected. From the observations, the validity of the 3D numerical model can obtain quantitative data on anchor damage. Such data collection can potentially create a database that could be used as a fundamental resource for quantitative anchor damage evaluation in the future.

Application of UML(Unified Modeling Language) Towards Object-oriented Analysis and Design of Geo-based Data Model (지질 데이터 모델의 객체지향 분석 및 설계를 위한 UML의 적용)

  • Lee, Ki-Won
    • Journal of the Korean earth science society
    • /
    • v.21 no.6
    • /
    • pp.719-733
    • /
    • 2000
  • Normally, a digital geologic map can be defined as mappable one whose spatial information with geographic information details and geologic database attribute, recorded in a digital format that is readable by computer. It shows fundamentally two different conceptual perspectives: cartography for digital mapping and analysis for geo-data processing. While, as both aspects basically relate to natural entities and their interpretation of complex features fused with multi-sources, digital geo-data mapping or geologic mapping, it should be distinguished from digital mapping in engineering such as UIS(Urban Infomation System) and AM/FM(Automated Mapping/Facilities Management). Furthermore, according to short-cycled development of GIS(Geographic Information System) software architecture based on IT(Information Technology) and wide expansion of GIS applications' fields, the importance of domain analysis and application model is emphasized at digital geologic informatizaion. In this paper, first terms and concepts of geo-data model with general data modeling aspects are addressed, and then case histories for geo-data modeling and several approaches for data modeling in GIS application fields are discussed. Lastly, tentative conceptual geo-data modeling by using UML(Unified Modeling Language) of OO(Object-oriented) concepts with respect to USGS/AASG geo-data mode is attempted. Through this approach, the main benefits for standardization and implementation lineage with conceptual model in consideration to reusability are expected. Conclusively, it is expected that geo-information system and its architecture by UML is the new coming key approach for the GIS application in geo-sciences.

  • PDF

An Introduction of Korean Soil Information System (한국 토양정보시스템 소개)

  • Hong, S. Young;Zhang, Yong-Seon;Hyun, Byung-Keun;Sonn, Yeon-Kyu;Kim, Yi-Hyun;Jung, Sug-Jae;Park, Chan-Won;Song, Kwan-Cheol;Jang, Byoung-Choon;Choe, Eun-Young;Lee, Ye-Jin;Ha, Sang-Keun;Kim, Myung-Suk;Lee, Jong-Sik;Jung, Goo-Bok;Ko, Byong-Gu;Kim, Gun-Yeob
    • Korean Journal of Soil Science and Fertilizer
    • /
    • v.42 no.1
    • /
    • pp.21-28
    • /
    • 2009
  • Detailed information on soil characteristics is of great importance for the use and conservation of soil resources that are essential for human welfare and ecosystem sustainability. This paper introduces soil inventory of Korea focusing on national soil database establishment, information systems, use, and future direction for natural resources management. Different scales of soil maps surveyed and soil test data collected by RDA (Rural Development Administration) were computerized to construct digital soil maps and database. Soil chemical properties and heavy metal concentrations in agricultural soils including vulnerable agricultural soils were investigated regularly at fixed sampling points. Internet-based information systems for soil and agro-environmental resources were developed based on 'National Soil Survey Projects' for managing soil resources and for providing soil information to the public, and 'Agroenvironmental Change Monitoring Project' to monitor spatial and temporal changes of agricultural environment will be opened soon. Soils data has a great potential of further application in estimation of soil carbon storage, water capacity, and soil loss. Digital mapping of soil and environment using state-of-the-art and emerging technologies with a pedometrics concept will lead to future direction.

3-Dimensional Terrain Model of Ruins Distribution Using GIS (GIS를 이용한 유적분포 3차원 지형모델)

  • Kwak, Young-Joo;Kang, In-Joon;Jang, Yong-Gu;Kang, Young-Shin;Kim, Sang-Seok
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.12 no.4 s.31
    • /
    • pp.27-33
    • /
    • 2004
  • Recently, as a part of NGIS project, cultural-assets digital map is produced by cultural properties administration and local autonomous entities. Cultural-assets unified GIS(Geographic Information System) is essential to cultural properties managers md other organizations which are executing land related business for appling it at planning stage. With explosive national land developments, it has been obligated to implement surface survey by the cultural properties protection Art. In this paper, the authors used the district of Sachon city and made 3D terrain model using digital map which is made of 1/5000 stale. Moreover, the authors improved to RDBMS(Relational Database Management System) structure and remodeled the existing DB design in detail, and also tried recovery of past sea level, based on researches about the water level of southern area. By recover past sea level. the shell mound, apart from lever is actually near lever at past, and it make sure its nature. The authors suggested to realize shape and kind of remains which have 3D information of accuracy and actualization from surface-surveying to excavation.

  • PDF

Establishment of A WebGIS-based Information System for Continuous Observation during Ocean Research Vessel Operation (WebGIS 기반 해양 연구선 상시관측 정보 체계 구축)

  • HAN, Hyeon-Gyeong;LEE, Cholyoung;KIM, Tae-Hoon;HAN, Jae-Rim;CHOI, Hyun-Woo
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.24 no.1
    • /
    • pp.40-53
    • /
    • 2021
  • Research vessels(R/Vs) used for ocean research move to the planned research area and perform ocean observations suitable for the research purpose. The five research vessels of the Korea Institute of Ocean Science & Technology(KIOST) are equipped with global positioning system(GPS), water depth, weather, sea surface layer temperature and salinity measurement equipment that can be observed at all times during cruise. An information platform is required to systematically manage and utilize the data produced through such continuous observation equipment. Therefore, the data flow was defined through a series of business analysis ranging from the research vessel operation plan to observation during the operation of the research vessel, data collection, data processing, data storage, display and service. After creating a functional design for each stage of the business process, KIOST Underway Meteorological & Oceanographic Information System(KUMOS), a Web-Geographic information system (Web-GIS) based information platform, was built. Since the data produced during the cruise of the R/Vs have characteristics of temporal and spatial variability, a quality management system was developed that considered these variabilities. For the systematic management and service of data, the KUMOS integrated Database(DB) was established, and functions such as R/V tracking, data display, search and provision were implemented. The dataset provided by KUMOS consists of cruise report, raw data, Quality Control(QC) flagged data, filtered data, cruise track line data, and data report for each cruise of the R/V. The business processing procedure and system of KUMOS for each function developed through this study are expected to serve as a benchmark for domestic ocean-related institutions and universities that have research vessels capable of continuous observations during cruise.

A Study on the Improvement of Guideline in Digital Forest Type Map (수치임상도 작업매뉴얼의 개선방안에 관한 연구)

  • PARK, Jeong-Mook;DO, Mi-Ryung;SIM, Woo-Dam;LEE, Jung-Soo
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.22 no.1
    • /
    • pp.168-182
    • /
    • 2019
  • The objectives of this study were to examine the production processes and methods of "Forest Type Map Actualization Production (Database (DB) Construction Work Manual)" (Work Manual) identify issues associated with the production processes and methods, and suggest solutions for them by applying evaluation items to a 1:5k digital forest type map. The evaluation items applied to a forest type map were divided into zoning and attributes, and the issues associated with the production processes and methods of Work Manual were derived through analyzing the characteristics of the stand structure and fragmentation by administrative districts. Korea is divided into five divisions, where one is set as the area changed naturally and the other four areas set as the area changed artificially. The area changed naturally has been updated every five years, and those changed artificially have been updated annually. The fragmentation of South Korea was analyzed in order to examine the consistency of the DB established for each region. The results showed that, in South Korea, the number of patches increased and the mean patch size decreased. As a result, the degree of fragmentation and the complexity of shapes increased. The degree of fragmentation and the complexity of shapes decreased in four regions out of 17 regions (metropolitan cities and provinces). The results indicated that there were spatial variations. The "Forest Classification" defines the minimum area of a zoning as 0.1ha. This study examined the criteria for the minimum area of a zoning by estimating the divided object (polygon unit) in a forest type map. The results of this study revealed that approximately 26% of objects were smaller than the minimum area of a zoning. The results implied that it would be necessary to establish the definition and the regeneration interval of "Areas Changed Artificially and Areas Changed Naturally", and improve the standard for the minimum area of a zoning. Among the attributes of Work Manual, "Species Change" item classifies terrain features into 52 types, and 43 types of them belong to stocking land. This study examined distribution ratios by extracting species information from the forest type map. It was found that each of 23 species, approximately 53% of species, occupied less than 0.1% of Forested land. The top three species were pine and other species. Although undergrowth on unstocked forest land are classified in the terrain feature system, their definition and classification criteria are not established in the "Forest Classification" item. Therefore, it will be needed to reestablish the terrain feature system and set the definitions of undergrowth.

Index-based Searching on Timestamped Event Sequences (타임스탬프를 갖는 이벤트 시퀀스의 인덱스 기반 검색)

  • 박상현;원정임;윤지희;김상욱
    • Journal of KIISE:Databases
    • /
    • v.31 no.5
    • /
    • pp.468-478
    • /
    • 2004
  • It is essential in various application areas of data mining and bioinformatics to effectively retrieve the occurrences of interesting patterns from sequence databases. For example, let's consider a network event management system that records the types and timestamp values of events occurred in a specific network component(ex. router). The typical query to find out the temporal casual relationships among the network events is as fellows: 'Find all occurrences of CiscoDCDLinkUp that are fellowed by MLMStatusUP that are subsequently followed by TCPConnectionClose, under the constraint that the interval between the first two events is not larger than 20 seconds, and the interval between the first and third events is not larger than 40 secondsTCPConnectionClose. This paper proposes an indexing method that enables to efficiently answer such a query. Unlike the previous methods that rely on inefficient sequential scan methods or data structures not easily supported by DBMSs, the proposed method uses a multi-dimensional spatial index, which is proven to be efficient both in storage and search, to find the answers quickly without false dismissals. Given a sliding window W, the input to a multi-dimensional spatial index is a n-dimensional vector whose i-th element is the interval between the first event of W and the first occurrence of the event type Ei in W. Here, n is the number of event types that can be occurred in the system of interest. The problem of‘dimensionality curse’may happen when n is large. Therefore, we use the dimension selection or event type grouping to avoid this problem. The experimental results reveal that our proposed technique can be a few orders of magnitude faster than the sequential scan and ISO-Depth index methods.hods.