• Title/Summary/Keyword: PostGIS

Search Result 131, Processing Time 0.025 seconds

Development of Distributed Hydrological Analysis Tool for Future Climate Change Impacts Assessment of South Korea (전국 기후변화 영향평가를 위한 분포형 수문분석 툴 개발)

  • Kim, Seong Joon;Kim, Sang Ho;Joh, Hyung Kyung;Ahn, So Ra
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.57 no.2
    • /
    • pp.15-26
    • /
    • 2015
  • The purpose of this paper is to develop a software tool, PGA-CC (Projection of hydrology via Grid-based Assessment for Climate Change) to evaluate the present hydrologic cycle and the future watershed hydrology by climate change. PGA-CC is composed of grid-based input data pre-processing module, hydrologic cycle calculation module, output analysis module, and output data post-processing module. The grid-based hydrological model was coded by Fortran and compiled using Compaq Fortran 6.6c, and the Graphic User Interface was developed by using Visual C#. Other most elements viz. Table and Graph, and GIS functions were implemented by MapWindow. The applicability of PGA-CC was tested by assessing the future hydrology of South Korea by HadCM3 SRES B1 and A2 climate change scenarios. For the whole country, the tool successfully assessed the future hydrological components including input data and evapotranspiration, soil moisture, surface runoff, lateral flow, base flow etc. From the spatial outputs, we could understand the hydrological changes both seasonally and regionally.

Case Study of Wind Farm Design Using OpenWind - Youngdeok Wind Farm (OpenWind를 이용한 풍력단지설계 사례연구 -영덕풍력단지)

  • Kim, Hyun-Goo;Hwang, Hyo-Jeong;Kim, Ju-Hyun;Ko, Soo-Hee;Jung, Woo-Sik
    • Journal of Environmental Science International
    • /
    • v.19 no.9
    • /
    • pp.1169-1175
    • /
    • 2010
  • A case study for the design of a wind farm in complex terrain was carried out using the wind farm site analysis software OpenWind, which has an open-source platform and is free to use. The Youngdeok Wind Farm, constructed on mountainous terrain in Korea, was chosen as a model site; the design process reproduced using OpenWind. A comparison of the positions of the wind turbine derived from the OpenWind optimization process and the current positions were in good agreement. The annual energy production predicted by OpenWind compared with the prediction by the micrositing software, WindSim, were also validated to within 1%. Therefore, it was confirmed that OpenWind can be used for a practical wind farm design project. It is also anticipating that this paper will provide a prototype process for the design of a wind farm site and offer a database for the post-evaluation of a constructed wind farm in Korea.

Development of Topological Correction Algorithms for ADCP Multibeam Bathymetry Measurements (ADCP 다중빔 수심계측자료의 위상학적 보정 알고리즘 개발)

  • Kim, Dong-Su;Yang, Sung-Kee;Kim, Soo-Jeong;Jung, Woo-Yul
    • Journal of Environmental Science International
    • /
    • v.22 no.5
    • /
    • pp.543-554
    • /
    • 2013
  • Acoustic Doppler Current Profilers (ADCPs) are increasingly popular in the river research and management communities being primarily used for estimation of stream flows. ADCPs capabilities, however, entail additional features that are not fully explored, such as morphological representation of river or reservoir bed based upon multi-beam depth measurements. In addition to flow velocity, ADCP measurements include river bathymetry information through the depth measurements acquired in individual 4 or 5 beams with a given oblique angle. Such sounding capability indicates that multi-beam ADCPs can be utilized as an efficient depth-sounder to be more capable than the conventional single-beam eco-sounders. The paper introduces the post-processing algorithms required to deal with raw ADCP bathymetry measurements including the following aspects: a) correcting the individual beam depths for tilt (pitch and roll); b) filtering outliers using SMART filters; d) transforming the corrected depths into geographical coordinates by UTM conversion; and, e) tag the beam detecting locations with the concurrent GPS information; f) spatial representation in a GIS package. The developed algorithms are applied for the ADCP bathymetric dataset acquired from Han-Cheon in Jeju Island to validate themselves applicability.

Development of a Cell-based Long-term Hydrologic Model Using Geographic Information System(I) -Cell-based Long-term Hydrologic Modeling- (지리정보시스템을 이용한 장기유출모형의 개발(I) -장기유출의 격자 모형화-)

  • 최진용;정하우
    • Magazine of the Korean Society of Agricultural Engineers
    • /
    • v.39 no.1
    • /
    • pp.64-74
    • /
    • 1997
  • A CELTHYM(CEll-based Long-term HYdrologic Model), a pre-processor and a post-processor that can be integrated with geographic information system(GIS) were developed to predict the stream flow from the small agricultural watershed on the daily basis. The CELTHYM calculates the direct runoff from a grid using SCS curve number method and then sum up all of cells with respect to a sub-catchment area belonged to a stream grid and integrated to an outlet. Base flow of a watershed outlet was computed by integrating of the base flow of each stream grid that was averaged the sub-catchment deep-percolation and calculated with the release rate. Two kind of water budget equation were used to compute the water balance in a grid that was classified into not paddy field and paddy field. One of the two equation is a soil water balance equation to account the soil moisture of the upland, forest and excluding paddy field grid. The other is a paddy water balance equation for the paddy field, calculating the ponding depth, the effective rainfall, the deep percolation and the evapotranspiration.

  • PDF

Development of an Agricultural Data Middleware to Integrate Multiple Sensor Networks for an Farm Environment Monitoring System

  • Kim, Joonyong;Lee, Chungu;Kwon, Tae-Hyung;Park, Geonhwan;Rhee, Joong-Yong
    • Journal of Biosystems Engineering
    • /
    • v.38 no.1
    • /
    • pp.25-32
    • /
    • 2013
  • Purpose: The objective of this study is to develop a data middleware for u-IT convergence in agricultural environment monitoring, which can support non-standard data interfaces and solve the compatibility problems of heterogenous sensor networks. Methods: Six factors with three different interfaces were chosen as target data among the environmental monitoring factors for crop cultivation. PostgresSQL and PostGIS were used for database and the data middleware was implemented by Python programming language. Based on hierarchical model design and key-value type table design, the data middleware was developed. For evaluation, 2,000 records of each data access interface were prepared. Results: Their execution times of File I/O interface, SQL interface and HTTP interface were 0.00951 s/record, 0.01967 s/record and 0.0401 s/record respectively. And there was no data loss. Conclusions: The data middleware integrated three heterogenous sensor networks with different data access interfaces.

Implementation of CNN-based Masking Algorithm for Post Processing of Aerial Image

  • CHOI, Eunsoo;QUAN, Zhixuan;JUNG, Sangwoo
    • Korean Journal of Artificial Intelligence
    • /
    • v.9 no.2
    • /
    • pp.7-14
    • /
    • 2021
  • Purpose: To solve urban problems, empirical research is being actively conducted to implement a smart city based on various ICT technologies, and digital twin technology is needed to effectively implement a smart city. A digital twin is essential for the realization of a smart city. A digital twin is a virtual environment that intuitively visualizes multidimensional data in the real world based on 3D. Digital twin is implemented on the premise of the convergence of GIS and BIM, and in particular, a lot of time is invested in data pre-processing and labeling in the data construction process. In digital twin, data quality is prioritized for consistency with reality, but there is a limit to data inspection with the naked eye. Therefore, in order to improve the required time and quality of digital twin construction, it was attempted to detect a building using Mask R-CNN, a deep learning-based masking algorithm for aerial images. If the results of this study are advanced and used to build digital twin data, it is thought that a high-quality smart city can be realized.

Analysis of Terrain Change Caused by Mining Development using GIS (GIS를 이용한 광산개발지역의 추이 현황 분석)

  • Lee Hyung-Seok
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.24 no.3
    • /
    • pp.261-269
    • /
    • 2006
  • There is a need to restore the terrain back its natural environment after mining development. It is necessary to compare the original and developing surfaces for post-management and to analyze the terrain change to develop a process for efficient restoration plan. This study analyzes and compares change to the terrain by annual mining development using GIS. Contours digitized with CAD based on photogrammetry are classified into annual data and created by Triangulated Irregular Network (TIN). By producing profiles and cross sections using TIN, many stations are distinguished. As a result of the terrain changes caused by mining development from 2000 to 2003 by operating elevation values each cell converted to raster from TIN, $11,094,460m^3$ are cut and $5,127,968m^3$ are filled up to 46% of cut volume, and annual surface changes of cut and fill area to mining are analyzed to visual and quantitative data. This study is used for the restoration plan and additional mining. And it is expected that this annual change, caused by mining development, can be used to return the terrain close to its original condition for finished mining area.

Development of Integrated Process Management System for Pump Dredge (펌프식 준설선의 통합공정관리시스템 개발)

  • Jeong, Dae-Deuk;Lee, Joong-Woo;Cho, Jeung-Eon
    • Journal of Navigation and Port Research
    • /
    • v.26 no.1
    • /
    • pp.146-151
    • /
    • 2002
  • Efficiency of dredging work depends on the types of equipment used, the sediments encountered, whether the work to be performed is new or for maintenance, pre and/or post hydrographic surveying and so forth. Among those, surveying accuracy which is directly determined by the control of the dredge's position and depth surveying accuracy being surveyed at the dredging point are important factors. The purpose of this study is to develop an integrated process management system for pump dredge. The system is composed of 4 sub-systems such as LADGPS for dredge positioning dredging point determination, tidal gauge and angular depth sensor for depth determination, and GIS and ENC process management. The process management system for pump dredge developed was installed on the pump dredge "EUNJIN PD-2" but is now producing work data for comparison with performance of the existing dredge. The data retrieved from the pump dredge process management system up to now shows similar result from the grab dredge management system which was developed previously. It is easy to operate, achieves good accuracy with only 45cm unevenness, reduces working perioa by 20 percint,. More precise evaluation of the system comes later after the dredging work is completed.completed.

Proposed Methodological Framework of Assessing LID (Low Impact Development) Impact on Soil-Groundwater Environmental Quality (저영향개발(Low Impact Development) 기법 적용 지역 토양·지하수 환경 영향 평가 방법론 제안 연구)

  • Kim, Jongmo;Kim, Seonghoon;Lee, Yunkyu;Choi, Hanna;Park, Joonhong
    • Journal of the Korean GEO-environmental Society
    • /
    • v.15 no.7
    • /
    • pp.39-50
    • /
    • 2014
  • The goal of this work is to develop a framework of methods to entirely evaluate effects of LID (Low Impact Development) on soil-groundwater environmental quality as well as land-scape and ecological factors. For this study, we conducted an extensive literature review. As outcomes, soil-groundwater environmental quality is newly conceptualized as a comprehensive index reflecting (i) groundwater pollution sensitivity (hydrogeological factor), (ii) biochemical contamination, and (iii) biodegradability. The methods of classifying and indexing is shown by combining selection of the items to be measured for soil-groundwater environmental quality and integrating the resulted items comprehensively. In addition, from soil-groundwater environmental quality, land-scape and ecological factors in existing environmental impact assessment a method was developed an overall index which can evaluate effects to environment by using GIS (Geographic Information System) and AHP (Analytic Hierachy Process). For optimizing LID planning, designing and post-evaluation, LCIA (Life Cycle Impact Assessment) was regarded as an appropriate method.

A Modified grid-based KIneMatic wave STOrm Runoff Model (ModKIMSTORM) (I) - Theory and Model - (격자기반 운동파 강우유출모형 KIMSTORM의 개선(I) - 이론 및 모형 -)

  • Jung, In Kyun;Lee, Mi Seon;Park, Jong Yoon;Kim, Seong Joon
    • KSCE Journal of Civil and Environmental Engineering Research
    • /
    • v.28 no.6B
    • /
    • pp.697-707
    • /
    • 2008
  • The grid-based KIneMatic wave STOrm Runoff Model (KIMSTORM) by Kim (1998) predicts the temporal variation and spatial distribution of overland flow, subsurface flow and stream flow in a watershed. The model programmed with C++ language on Unix operating system adopts single flowpath algorithm for water balance simulation of flow at each grid element. In this study, we attempted to improve the model by converting the code into FORTRAN 90 on MS Windows operating system and named as ModKIMSTORM. The improved functions are the addition of GAML (Green-Ampt & Mein-Larson) infiltration model, control of paddy runoff rate by flow depth and Manning's roughness coefficient, addition of baseflow layer, treatment of both spatial and point rainfall data, development of the pre- and post-processor, and development of automatic model evaluation function using five evaluation criteria (Pearson's coefficient of determination, Nash and Sutcliffe model efficiency, the deviation of runoff volume, relative error of the peak runoff rate, and absolute error of the time to peak runoff). The modified model adopts Shell Sort algorithm to enhance the computational performance. Input data formats are accepted as raster and MS Excel, and model outputs viz. soil moisture, discharge, flow depth and velocity are generated as BSQ, ASCII grid, binary grid and raster formats.