Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography (한국측량학회지)

Korean Society of Surveying, Geodesy, Photogrammetry and Cartography (한국측량학회)
권호 표지
DOI QR코드

DOI QR Code

Efficient Construction of Open Source-based Sewage Facility Database

오픈소스 기반의 하수 시설물 데이터베이스의 효율적 구축

  • Ko, Jeongsang (Dept. of Civil Engineering, Chungnam National University) ;
  • Xu, Chunxu (Dept. of Surveying and Mapping Science and Engineering, Shandong Agricultural University) ;
  • Yun, Heecheon (Dept. of Civil Engineering, Chungnam National University)
  • Received : 2022.09.20
  • Accepted : 2022.10.18
  • Published : 2022.10.31
Download PDF
⟨ Previous Next ⟩

Abstract

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.

지하시설물의 효과적인 데이터의 관리는 인간 삶 측면에서 매우 중요하다. 여기에는 최신성의 정확도 높은 데이터의 입력이 선행되어야 한다. 그래서 효율적인 데이터를 입력을 위한 방법이 중요하다. 본 연구에서는 오픈소스(open source) 소프트웨어를 활용하여 하수 시설물 현장조사 프로그램을 개발함으로써 종이도면을 태블릿PC로 대체할 수 있도록 하였다. 태블릿PC를 활용하여 현장에서 취득하는 도형 및 속성정보를 데이터베이스 서버를 통해 실시간으로 전송하도록 하였으며, PostGIS 쿼리(query)를 개발하여 구조화편집 자동화로 하수 시설물 GIS (Geographic Information System) 데이터베이스 구축에 수작업을 최소화하였다. 또한, 하수 시설물 GIS 데이터베이스 구축 프로그램을 활용하여 데이터베이스 구축을 하였고, 이를 기존방식의 하수 시설물 데이터베이스 구축과 작업공정, 작업시간을 비교·분석한 결과 작업공정이 단순화되었고 작업시간이 단축되었다. 아울러 오픈소스 소프트웨어의 간단한 커스터마이징을 통해 타 분야의 현장조사 및 데이터베이스 구축에 활용할 수 있을 것이다.

Keywords

Acknowledgement

이 연구는 충남대학교 학술연구비에 의해 지원되었음

References

  1. Chang, Y.K., Kang I.J., Kim, N.S., and Kang M.S. (2003), Development of underground facilities management system based on field using GIS programming, Conference for Korean Society of Civil Engineers 2003, 24-25 October, Daegu, Korea, pp. 4561-4565.
  2. Doner, F. and Yomralioglu (2013), Examination and comparison of mobile GIS technology for real time Geodata acquisition in the field, Survey Review, Vol. 40, No. 309, pp. 221-234. http://dx.doi.org/10.1179/003962608X291013.
  3. Jeon, J.Y., Choi, N.I., Ko, J.W., and Cho, G.S. (2007), The mobile GIS system development for geographic information database update, Conference for Korean Society of Civil Engineers 2007, 10-12 October, Daegu, Korea, pp. 2915-2918.
  4. Kim, H.T. (2004), The Improvement of the Road Facility Database Creation Using a Mobile GIS, Master's thesis, Sangji University, Wonju, Korea, 72p.
  5. Kim, N.H. (2019), Development of Web GIS Spatial Analysis System Using PostGIS, Master's thesis, Kangwon National University, Samcheog, Korea, 32p.
  6. Ko, J. (2022), Development of sewage facility GIS DB construction system using open source, Master's thesis, Chungnam National University, Daejeon, Korea, 68p.
  7. Lwin, K.K. and Murayama, Y. (2011), Web-based GIS system for real-time field data collection using personal mobile phone, Journal of Geographic Information System, Vol. 3, No. 4, pp. 382-389. http:dx.doi.org/10.4236/jgis.2011.34037
  8. Park, J.K. (2008), Development of Automatic Extraction System of the Sediment Amount in the Dam Using GIS, Ph.D. dissertation, Chungnam National University, Daejeon, Korea, 202p.
  9. Um, D.Y. (2004), The Development of 3D Digital Image Generation System for Construction of GIS Database, Ph.D. dissertation, Chungnam National University, Daejeon, Korea, 158p.
  10. Osterman, A. (2014), Map visualization in ArcGIS, QGIS and MapInfo, KTH, School of Architecture and the Built Environment (ABE), Stockholm, Sweden, 14p
  11. PostGIS (2021), Open Geospatial Consortium (OGC), https://www.postgis.net (last date accessed: 27 December 2021).
  12. Ra, Y.W. (2009), Application of Mobile System for Urban Facility Management, Ph.D. dissertation, University of Incheon, Incheon, Korea, 155p.
  13. Vworld (2021), Ministry of Land, Infrastructure and Transport, Korea, https://map.vworld.kr/map (last date accessed: 27 December 2021).
  14. Wang, S., Qi, Y., and Li, M. (2018), Design of mobile terminal software of the intelligent street lamp management system based on GIS, International Conference on Mechanical, Electronic, Control and Automation Engineering, Vol. 149, No. 2, pp. 713-716. http:dx.doi.org/10.2991/mecae-18.2018.127.