Browse > Article
http://dx.doi.org/10.7848/ksgpc.2022.40.5.393

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)
Publication Information
Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography / v.40, no.5, 2022 , pp. 393-402 More about this Journal
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.
Keywords
Open Source; Sewage Facilities; PostGIS; User Interface/User eXperience;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Osterman, A. (2014), Map visualization in ArcGIS, QGIS and MapInfo, KTH, School of Architecture and the Built Environment (ABE), Stockholm, Sweden, 14p
2 Vworld (2021), Ministry of Land, Infrastructure and Transport, Korea, https://map.vworld.kr/map (last date accessed: 27 December 2021).
3 Kim, N.H. (2019), Development of Web GIS Spatial Analysis System Using PostGIS, Master's thesis, Kangwon National University, Samcheog, Korea, 32p.
4 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   DOI
5 PostGIS (2021), Open Geospatial Consortium (OGC), https://www.postgis.net (last date accessed: 27 December 2021).
6 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.
7 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.   DOI
8 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.
9 Kim, H.T. (2004), The Improvement of the Road Facility Database Creation Using a Mobile GIS, Master's thesis, Sangji University, Wonju, Korea, 72p.
10 Ko, J. (2022), Development of sewage facility GIS DB construction system using open source, Master's thesis, Chungnam National University, Daejeon, Korea, 68p.
11 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.
12 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.   DOI
13 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.
14 Ra, Y.W. (2009), Application of Mobile System for Urban Facility Management, Ph.D. dissertation, University of Incheon, Incheon, Korea, 155p.