• Proceedings of the KSRS Conference
• /
• 2009.03a
• /
• pp.134-138
• /
• 2009

최근 GIS 포털에 대한 수요자 요구 사항이 증가하고 있고 기존의 웹 GIS 응용 프로그램 개발 기법과의 연계와 통합이 중요한 연구 주제로 부각되고 있다. 본 연구에서는 공개 소스인 PostgreSQL - PostGIS를 이용하여 GIS 포털 구축을 위한 응용 설계 연구를 수행하였다. PostgreSQL를 데이터베이스 시스템으로 하여 공간 질의 및 분석 기능 등 GIS 기능을 연동시키는 PostGIS는 서버 GIS 엔진으로 점점 활용 가치가 증가하고 있으나 GIS 포털에서 이를 적용한 사례는 현재까지 보고된 바가 거의 없다. 본 응용 설계는 전체 시스템 설계 보다는 주로 포털에서의 인터페이스 부분을 주로 다루고자 하며 시험 구현 프로그램의 라이브러리는 PostGIS의 C Language Interface(LIBPQ)와 OGC library를 이용하여 공간 데이터에 대한 기본 기능을 구현하였다. 본 연구를 통하여 구글, 다음, 네이버 등과 같은 일반 검색 엔진에서 경쟁적으로 제공하는 웹 맵핑 수준에서 위성영상정보와 지도정보 서비스가 보다 체계적으로 웹 GIS 기술과 연계될 수 있는 기반을 마련하고자 한다.

• Spatial Information Research
• /
• v.19 no.2
• /
• pp.57-64
• /
• 2011

This paper describes how to storing and querying trajectory information on PostgreSQL/PostGIS. Recently as technology of mobile devices is advancing, many researches for location-based services and moving object's trajectory have been studied. Trajectory is the set of information of the location by the time, and is one of the most im portant information for location-based services. Traditional spatial database systems do not support trajectory data types and functions. In this paper, we propose a trajectory data type and query functions for moving objects on PostgreSQL/PostGIS.

• Journal of Environmental Impact Assessment
• /
• v.19 no.3
• /
• pp.315-321
• /
• 2010

ArcView and water network models have been integrated to develop the water network modeling system based upon GIS. To develop this system, pre, main, and post processing systems are required. GIS programming technique was adopted by using the ArcView's script language Avenue. The input data of models have been prepared by using the AutoCAD Map3D through the conversion of modeling input data to GIS data for A city. The modeling has been implemented by using EPANET, WaterCAD, InfoWorks. To develop the post processing system, the modeling results of the water network models have been analyzed by using GIS. During the application process of the developed system to B city with 300,000 population, main problems were found in the constructed GIS DB of that city. Thus, pilot study area of B city has been constructed, and pre-, main, and post-processing techniques were invented based upon GIS. Finally, the problems related to waterworks GIS projects in Korea were discussed and solutions were suggested.

• Korean Journal of Remote Sensing
• /
• v.25 no.2
• /
• pp.185-192
• /
• 2009

Recently, open sources for geo-spatial information processing and analysis are being developed, and they are widely adopted for the various application development projects. Open sources in the geo-spatial communities consist in several levels or types: viewer, API-level, engine sources of SDK-level, or toolkits. Among them, spatial database engine of PostgreSQL-PostGIS is used in this study for the portable multi-geospatial information processing toolkit. This work can be extended to target-based applications with domain-specific spatial queries and analyses. Design and implementation are based on C Language Interface (LIBPQ) to PostGIS and OGC library on PostgreSQL database. Conclusively, PostGIS according to this approach is an important alternative to develop most applications dealing with multi-geospatial information due to its availability, extensibility, scalability, and stability.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.6 no.2
• /
• pp.65-79
• /
• 2003

In this study GIS based pre- and post-processing tool for the Visual MODFLOW that is specific software to model groundwater flow is developed. This tool not only makes input data scientifically but also manages input and output data in terms of the groundwater flow analysis. In addition it can storage project products systematically into Oracle database. The most characteristic figure of this processing tool is to provide the module, which automatically or semi automatically develops various grid cell sizes using GIS ArcView and also produces DXF files reflecting various boundary conditions in the modeling zone. In particular, eminences of this research are to create 3 dimensional hydrogeological structures with 2 dimensional GIS ArcView and to conduct pre- and post- processing along with same topology and data format of the MODFLOW.

• Magazine of the Korean Society of Agricultural Engineers
• /
• v.39 no.2
• /
• pp.103-112
• /
• 1997

A CELTHYM(CEll-based Long-term HYdrologic Model), a pre-processor and a post-processor that can he integrated with geographic information system(GIS) were developed to predict the stream flow of a small agricultural watershed. Three kinds of routines, that are watershed boundary extraction routine(WBER), curve number calculation routine(CNR) and maximum available soil moisture calculation routine(MASR) composed pre-processor that was nicely interfaced with CELTRYM and GIS. Two kinds of routines, grapher and map composer composed post-processor that was well adapted CELTHYM output to chart making and GIS map making. The developed pre-post processor was useful for the GIS integration and spatial comprehension of the CELTHYM output.

• Spatial Information Research
• /
• v.22 no.4
• /
• pp.39-47
• /
• 2014

The Yeongsan river estuary has a serious water quality problem due to the water stagnation and it is imperative to predict the changes of water quality for mitigating water pollution. EFDC(Environmental Fluid Dynamics Code) model was mainly utilized to predict the changes of water quality for the estuary. The EFDC modeling normally accompanies the large volume of modeling output. For checking the spatial distribution of the modeling results, post-processing for converting of the output is prerequisite and mainly post-processing program is EFDC_Explorer. However, EFDC_Explorer only shows the spatial distribution of the time series and this doesn't support overlay function with other thematic maps. This means the impossible to the connection analysis with a various GIS data and high dimensional analysis. Therefore, this study aims to develop a post-processing system of a EFDC output to use them as GIS layers. For achieving this purpose, a editing module for main input files, and a module for converting binary format into an ASCII format, and a module for converting it into a layer format to use in a GIS based environment, and a module for visualizing the reconfigured model result efficiently were developed. Using the developed system, result file is possible to automatically convert the GIS based layer and it is possible to utilize for water quality management.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.40 no.5
• /
• pp.393-402
• /
• 2022

Effective data management of underground facilities is very important in terms of human life. For this, input of up-to-date and high-accuracy data should be preceded. Therefore, it is important to have an efficient data input method. In this study, by developing a sewage facility site survey program using open source software, paper drawings could be replaced with tablet PCs. By using a tablet PC, figures and property information acquired from the field are transmitted in real time through a database server. PostGIS query is developed to automate structured editing to minimize manual work in constructing a GIS (Geographic Information System) database for sewage facilities. did. In addition, the database was built using the sewage facility GIS database building program. As a result of comparing and analyzing the existing sewage facility database construction, work process, and work time, the work process was simplified and work time was shortened. In addition, through simple customization of open source software, it will be able to be used for field surveys and database construction in other fields.

• Korean Management Science Review
• /
• v.21 no.3
• /
• pp.115-127
• /
• 2004

In this paper, we describe an intelligent monitoring and control system for pick-up/delivery service. This system applies geographical information system(GIS), global positioning system(GPS) and wireless communication technologies for managing pick-up/delivery operations more effectively. It consists of three subsystems, pick-up/delivery sequence planning system, pick-up/delivery monitoring system, and PDA execution system. Pick-up/delivery sequence planning system generates routes and schedules for pick-up/delivery using GIS and optimization techniques. Pick-up/delivery monitoring system monitors current positions of vehicles and actual pick-up/delivery results as compared with planned routes and visit times, while PDA execution system transmits information for vehicles positions and actual pick-up/delivery results using GPS and wireless communication technologies. The intelligent monitoring and control system is currently being used for the pick-up parcel service in a local post office of Korea Post.

• Journal of Distribution Science
• /
• v.18 no.4
• /
• pp.39-50
• /
• 2020

Purpose: This paper aimed to study the current locations of post offices to analyze service coverage area for parcel delivery in the Eastern Economics Corridor (EEC), which must be considered in the last mile to extend delivery service for e-commerce growth. Thailand Post was the case study in this paper. Research design, data and methodology: To involve solving the delivery service area under the last mile condition, the authors proposed a network analysis to determine service radius by employing a Geographic Information System (GIS). Furthermore, this paper applied Dijkstra's algorithm as a network analysis tool from GIS for analyzing the last mile service coverage area in a new economics zone. At the same time, the authors suggested an approach as a solution to locate last mile delivery center in EEC. Results: The results of the study pointed out that Thailand Post should consider more last mile delivery centers in EEC to support its express service in urban areas as well as improve the efficiency of service coverage for parcel delivery and create more advantages against competitors. Conclusions: This paper proposes a network analysis to extend the last mile service for parcel delivery by following Dijkstra's algorithm from GIS and a solution approach to add more last mile delivery centers. The results of the research will contribute to boosting customer satisfaction for last mile delivery service and enabling easy accessibility to a service center in EEC.