DOI QR코드

DOI QR Code

Development of Database Management System for Agriculture Facilities Using Geographic Information System

GIS를 이용한 농업시설물 데이터베이스관리시스템 개발

  • An, Won-Tae (Department of Civil Engineering, Chungbuk National University) ;
  • Choi, Seok-Keun (Department of Civil Engineering, Chungbuk National University)
  • Received : 2021.02.26
  • Accepted : 2021.04.02
  • Published : 2021.04.30

Abstract

The environments in current farming and fishing communities have been exacerbated by the shortage of personnel caused by aging, the deficiency of equipment, and the decrease in produce prices. To help solve these issues, this study examined the history, such as inspections, failures, and repairs, by constructing a database for underground water wells, pumping stations, and irrigation, which are critical for management among agriculture production infrastructures. In particular, in the case of underground water wells, their optimal locations were determined using spatial information, such as a geological map of water resources, a water vein map, and underwater depth, because indiscreet installations and an absence of spatial information resulted in economic losses and environmental pollution. Therefore, this study could efficiently manage many facilities scattered in rural areas by developing a system. An analysis of the status of 14 underground water wells using spatial information showed that the location information at six points was specified incorrectly. On the other hand, a site investigation showed that the water vein map analysis at one point was inaccurate.

현재의 농어촌은 고령화로 인한 인력 및 장비부족, 농산물 가격하락 등 여러 환경이 갈수록 열악해지고 있는 실정이다. 본 연구는 이러한 문제를 해결하기 위하여 수 많은 농업기반시설물 중 중요 관리대상인 관정, 양수장, 취입보 등을 대상으로 데이터베이스 구축하여 점검, 고장 및 수리 등의 이력사항을 관리하기 위하여 수행되었다. 특히, 관정의 경우에는 무분별한 설치와 공간정보 부재로 인하여 경제적 손실 및 환경오염 등의 문제를 야기시키기 때문에 수문지질도, 수맥도, 지하수 심도 등의 공간정보를 이용하여 관정의 최적위치를 결정하였다. 따라서, 본 연구는 시스템 개발을 통하여 농촌지역에 산재되어 있는 수 많은 시설물들을 효율적으로 관리할 수 있었고, 공간정보를 이용하여 14개 관정에 대한 현황을 분석한 결과 6개 지점에서의 위치정보가 잘못된 것으로 나타났으나, 현장조사결과 1개 지점에서는 수맥도 분석이 잘못된 것으로 분석되었다.

Keywords

References

  1. Ministry for food, agriculture, forestry and fisheries, Farming and fishing villages a set(athing) in good condition law, Vol. 3, No. 18. 2019. http://Lawnb.com/info/ContentView?sid=L000006989
  2. S. Y. Park, J. S. Kim, "A GIS-Based Comparative Study of Frequency Ratio and Dempster-Shafer Theory for Groundwater Potential Mapping in Busan Metropolitan City", Journal of the Korean Society for Geospatial Information Science, pp. 49-59. 2018. DOI: https://dx.doi.org/10.7319/kogsis.2018.26.1.049
  3. S. K. Choi, U. H. Jo, B. Y. Lee, "Facilities Management Using Multi-Dimension Spatial Information", Journal of Korean Society for Geospatial Information Science, Vol.18, No.1, pp.41-46. 2010. http://e.kogsis.or.kr/_common/do.php?a=full&b=12
  4. G. H. Kim, H. Choi, Topographical Analysis of Landslide in Mt. Woomyeon Using DSM, Journal of the Korea Academia-Industrial Cooperation Society, Vol. 21, No. 12, pp. 60-66, 2020. DOI: https://doi.org/10.5762/KAIS.2020.21.12.60
  5. C. Y. Oh, K. W. Jun, "Disaster risk predicted by the Topographic Position and Landforms Analysis of Mountainous Watersheds", Journal of Korean Society of Disaster & Security Vol. 11, No. 2, pp 1-8. 2018. DOI: https://doi.org/10.21729/ksds.2018.11.2.1
  6. I. S. Kim, J. Y. Lee, S. I. Choi, "A Study on the Characteristic of the Groundwater Quality in Seoul", Journal of Soil and Groundwater Environ. Vol. 9(2), pp. 54-63, 2004. http://www.jsge.or.kr/journal/archive/view/136
  7. E. Y. Kim, D. C. Koh, K. S. Ko, I. W. Yeo, "Prediction of Nitrarte Contamination of Groundwater in the Northern Nonsan Area Using Multiple Regression Analysis", Journal of Soil and Groundwater Environ. Vol. 13(5), pp. 57-73, 2008. http://www.jsge.or.kr/journal/archive/view/355
  8. K. Y. Lee, K. S. Choi, "Development of Clean Water Supplying System for Greenhouse Cultivation and Convenience Water(I) - Development of the FDA System", JOURNAL OF THE KOREAN SOCIETY OF AGRICULTURAL ENGINEERS, Vol. 51, No. 5, pp. 95-100, 2009. http://www.ksae.re.kr/html/sub04-01.asp https://doi.org/10.5389/KSAE.2009.51.5.095
  9. https://www.yd21.go.kr/kr/
  10. http://www.alimi.or.kr/dataview/a/totalSaleSearchList.do
  11. http://Lawnb.com/Info/ContentView?sid=L000000262_9#P9×5