• Title/Summary/Keyword: Integrated DB Management System

Search Result 114, Processing Time 0.017 seconds

Development of GIS based Water Quality Simulation System for Han River and Kyeonggi Bay Area (한강과 경기만 지역 GIS 기반 통합수질모의 시스템 개발)

  • Lee, Chol-Young;Kim, Kye-Hyun
    • Journal of Korea Spatial Information System Society
    • /
    • v.10 no.4
    • /
    • pp.77-88
    • /
    • 2008
  • There has been growing demands to manage the water quality of west coastal region due to the large scale urbanization along the coastal zone, the possibility of application of TMDL(Total Maximum Daily Loadings) to Han river, and the natural disaster such as oil spill incident in Taean, Chungnam. However, no system has been developed for such purposes. In this background, the demand of GIS based effective water quality management has been increased to monitor water quality environment and propose best management alternatives for Han river and Kyeonggi bay. This study mainly focused on the development of integrated water quality management system for Han river bas in and its estuary are a connected to Kyeonggi bay to support integrated water quality management and its plan. Integration was made based on GIS by spatial linking between water quality attributes and location information. A GIS DB was built to estimate the amount of generated and discharged water pollutants according to TMDL technical guide and it included input data to use two different water quality models--W ASP7 for Han river and EFDC for coastal area--to forecast water quality and to suggest BMP(Best management Practices). The results of BOD, TN, and TP from WASP7 were used as the input to run EFDC. Based on the study results, some critical areas which have relatively higher pollutant loadings were identified, and it was also identified that the locations discharging water pollutant loadings to river and seasonal factor affected water quality. And the relationship of water quality between river and its estuary area was quantitatively verified. The results showed that GIS based integrated system could be used as a tool for estimating status-quo of water quality and proposing economically effective BMPs to mitigate water pollution. Further studies need to be made for improving system's capabilities such as adding decision making function as well as cost-benefit analysis, etc. Also, the concrete methodology for water quality management using the system need to be developed.

  • PDF

A State-of-the-Practice Review on the Management of the Domestic Geotechnical and Geological Information Data (국내 지질 및 지반조사 자료 관리 현황에 대한 실용적 고찰)

  • Jang, Yonggu;Jeon, Heungsoo;Chae, Deokho;Cho, Wanjei
    • Journal of the Korean GEO-environmental Society
    • /
    • v.14 no.4
    • /
    • pp.39-46
    • /
    • 2013
  • Recently, there have been various researches on the cost reduction and savings during the construction activities with the development of automation and computerized information system. Considering the cost savings during the construction, the development of the geological and geotechnical information system with high practical use becomes very important since the geologic and geotechnical data are required for the design of the various structures. Currently, the geological and geotechnical data are collected and distributed as a geological/geotechnical map or engineering geology map and map with other specific purpose through geoinfo system at Korea Institute of Geoscience and Mineral Resources, Korea Mineral Resources GIS at Korea Mineral Resources Corporation, Geotechnical Information Portal System at Korea Institute of Construction Technology, Geotechnical Information System at the City of Seoul and the Ocean Data Integration Material System at Korea Hydrographic and Oceanographic Administration. Furthermore, the information on the groundwater is monitored and collected via Integrated Ground Water Information Service at Korea Water Resources Corporation and Rural Groundwater net at Korea Rural Community Corporation. Therefore, in this study, the contents of the geological and geotechnical data collected from the above mentioned government organization are compared and the DB and distribution system with higher utilization are suggested based on the comparisons with those from other countries such as United States of America, Japan and Germany.

Environmental Characteristics of Wind-Hole and Phytogeographical Values (풍혈의 환경 특성과 식물지리적 가치)

  • Kong, Woo-Seok;Lee, Slegee;Yoon, Kwanghee;Park, Heena
    • Journal of Environmental Impact Assessment
    • /
    • v.20 no.3
    • /
    • pp.381-395
    • /
    • 2011
  • Present work aims to establish an integrated management system of environmental data base for nine typical wind holes or air holes in Korea. It basically deals with definition, geographical distribution, morphological pattern, physical characteristics and anthropogenic environments of wind hole to propose systematic preservation strategy of their periglacial landscape and flora, which are known to be sensitive to global warming. Wind hole, in which cool air blows out during the summer, but mild air comes out during the winter from a cave or hole, is frequently found on northwest- and north-facing slopes on the terminal point of steep talus, block field, and block stream, and can be categorized into three types, i.e., talus, cave and sink types. Environmental characteristics of nine wind holes are analyzed on the basis of their geology, landform, climate, soil, hydrology, vegetation, road, footpath, land-use, and management system, and relevant DB are prepared. Wind hole areas with unique landscape and ecological values need to be designated as a nature reserve, and zoning of core, buffer, and transitional zones are required for the multi-dimensional preservation of periglacial landscape and ecosystem. Phytogeographical values of glacial relict plants, including mountain cranberry(Vaccinium vitis-idaea) at its global southernmost limit at Bangnaeri wind hole, Hongchon County, Gangwon Province of Korea are discussed in detail as a floristic refugia in connection with climate change during the Pleistocene Epoch and potential in-situ and ex-situ preservation sites in the future.

A Study on the Improvement of RIMGIS for an Efficient River Information Service (효율적인 하천정보 서비스를 위한 RIMGIS 개선방안 연구)

  • Shin, Hyung-Jin;Chae, Hyo-Sok;Hwang, Eui-Ho;Lim, Kwang-Suop
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.16 no.1
    • /
    • pp.15-25
    • /
    • 2013
  • The RIMGIS(River Information Management GIS) has been developed since 2000 for public service and practical applications of related works after the standardization of national river data such as the river facility register report, river survey map, attached map, and etc. The RIMGIS has been improved in order to respond proactively to change in the information environment. Recently, Smart River-based river information services and related data have become so large as to be overwhelming, making necessary improvements in managing big data. In this study a plan was suggested both to respond to these changes in the information environment and to provide a future Smart River-based river information service by understanding the current state of RIMGIS, improving RIMGIS itself, redesigning the database, developing distribution, and integrating river information systems. Therefore, primary and foreign key, which can distinguish attribute information and entity linkages, were redefined to increase the usability of RIMGIS. Database construction of attribute information and entity relationship diagram have been newly redefined to redesign linkages among tables from the perspective of a river standard database. In addition, this study was undertaken to expand the current supplier-oriented operating system to a demand-oriented operating system by establishing an efficient management of river-related information and a utilization system capable of adapting to the changes of a river management paradigm.

Design and Implementation of Integrated GIS-T System for Transportation Database (교통DB구축을 위한 GIS-T 통합시스템의 설계와 구현)

  • Joo Yong-Jin;Choi Jung-Min;Park Soo-Hong
    • Spatial Information Research
    • /
    • v.13 no.3 s.34
    • /
    • pp.309-321
    • /
    • 2005
  • To analyze travel demand fur transportation policy and transportation planning, it is important to construct realistic and reliable traffic data. And it needs a user friendly system to demonstrate transportation problems in the transportation planning and transportation management aspect. Generally, to construct network for analysis and collection about social and economical data is a core of transportation planning model. However, it takes a lot of time and effect. To overcome this problem GIS is more effective and efficient in data processing, such as selecting, editing and visualizing, etc. However, it is an early stage to use CIS in the transportation problems. This paper shows a new GIS-T system. The system can give traffic information and plan transportation planning using GIS which has ability as spatial representation and spatial analysis. To build this system, we design interfaces that are able to communicate transportation package for analysis with GIS and manage network efficiently, such as editing and examination. And we also develop a module for traffic information processing to handle spatial data and add it on the system. The proposed system shows more realistic transportation network modeling because the system presents more effective conditions to analyze network. And it can be a tool that can analyze various transportation problems.

  • PDF

Development of Risk Analysis Structure for Large-scale Underground Construction in Urban Areas (도심지 대규모 지하공사의 리스크 분석 체계 개발)

  • Seo, Jong-Won;Yoon, Ji-Hyeok;Kim, Jeong-Hwan;Jee, Sung-Hyun
    • Journal of the Korean Geotechnical Society
    • /
    • v.26 no.3
    • /
    • pp.59-68
    • /
    • 2010
  • Systematic risk management is necessary in grand scaled urban construction because of the existence of complicated and various risk factors. Problems of obstructions, adjacent structures, safety, environment, traffic and geotechnical properties need to be solved because urban construction is progressed in limited space not as general earthwork. Therefore the establishment of special risk management system is necessary to manage not only geotechnical properties but also social and cultural uncertainties. This research presents the technique analysis by the current state of risk management technique. Risk factors were noticed and the importance of each factor was estimated through survey. The systemically categorized database was established. Risk extraction module, matrix and score module were developed based on the database. Expected construction budget and time distribution can be computed by Monte Carlo analysis of probabilities and influences. Construction budgets and time distributions of before and after response can be compared and analyzed 80 the risks are manageable for entire whole construction time. This system will be the foundation of standardization and integration. Procurement, efficiency improvement, effective time and resource management are available through integrated management technique development and application. Conclusively decrease in cost and time is expected by systemization of project management.

Development of Basic Research for Establishing the Apple IPM System in Korea: Dr. Lee Soon-Won's Research Case (한국형 사과 병해충종합관리(IPM) 체계 수립을 위한 기초연구의 전개: 이순원 박사의 연구 사례)

  • Ahn, Jeong Joon;Oh, Hyeonseok;Choi, Kyung San;Choi, Kyung-Hee;Do, Yun-Su;Lee, Sun-Young;Lee, Dong-Hyuk
    • Korean journal of applied entomology
    • /
    • v.60 no.1
    • /
    • pp.1-13
    • /
    • 2021
  • The concept of integrated pest management (IPM) first developed in the 1950s, and the concept of economic control via pest management was established in the 1960s. Research on IPM began in the United States and Europe, and IPM studies in Korea started with citrus insects and paddy field pests following the distribution of high-yield varieties of rice. Apple IPM in Korea began with research on pest control using chemical pesticides and pesticides resistant to insect pests, studies on the ecology of insect pests and their natural enemies, and the exploitation of sex pheromones on insect pests. Since the 1990s, IPM research and field projects have been carried out simultaneously for farming households. In the 2000s, the development of pest monitoring and forecasting models centered on mating disturbances, database programs for pests, and networks for sharing information. IPM technology has expanded via the development of unmanned forecasting systems and automation technologies in the 2010s.

Establishment of A WebGIS-based Information System for Continuous Observation during Ocean Research Vessel Operation (WebGIS 기반 해양 연구선 상시관측 정보 체계 구축)

  • HAN, Hyeon-Gyeong;LEE, Cholyoung;KIM, Tae-Hoon;HAN, Jae-Rim;CHOI, Hyun-Woo
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.24 no.1
    • /
    • pp.40-53
    • /
    • 2021
  • Research vessels(R/Vs) used for ocean research move to the planned research area and perform ocean observations suitable for the research purpose. The five research vessels of the Korea Institute of Ocean Science & Technology(KIOST) are equipped with global positioning system(GPS), water depth, weather, sea surface layer temperature and salinity measurement equipment that can be observed at all times during cruise. An information platform is required to systematically manage and utilize the data produced through such continuous observation equipment. Therefore, the data flow was defined through a series of business analysis ranging from the research vessel operation plan to observation during the operation of the research vessel, data collection, data processing, data storage, display and service. After creating a functional design for each stage of the business process, KIOST Underway Meteorological & Oceanographic Information System(KUMOS), a Web-Geographic information system (Web-GIS) based information platform, was built. Since the data produced during the cruise of the R/Vs have characteristics of temporal and spatial variability, a quality management system was developed that considered these variabilities. For the systematic management and service of data, the KUMOS integrated Database(DB) was established, and functions such as R/V tracking, data display, search and provision were implemented. The dataset provided by KUMOS consists of cruise report, raw data, Quality Control(QC) flagged data, filtered data, cruise track line data, and data report for each cruise of the R/V. The business processing procedure and system of KUMOS for each function developed through this study are expected to serve as a benchmark for domestic ocean-related institutions and universities that have research vessels capable of continuous observations during cruise.

Analysis of Applicability by Filter Technique for Water Level Correction of Agricultural Canal (농업용 수로부의 수위 보정을 위한 필터기법별 적용성 분석)

  • Joo, Donghyuk;Na, Ra;Kim, Ha-Young;Choi, Gyu-hoon;Yun, Hyung Chang;Park, Sang-Bin;Yoo, Seung-Hwan
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.65 no.5
    • /
    • pp.51-68
    • /
    • 2023
  • Due to the recent integrated water management policy, it is important to identify a reliable supply amount for establishing an agricultural water supply plan. In order to identify the amount of agricultural water supply, it is essential to calculate the discharge by measuring the water level and flow velocity of reservoirs and canal agricultural water, and quality control to ensure reliability must be preceded. Unlike agricultural reservoirs, canal agricultural water are more sensitive to the surrounding environment and reservoir irrigation methods (continuous, intermittent irrigation, etc.), making it difficult to estimate general water level patterns and at the same time a lot of erroneous data. The Korea Rural Community Corporation is applying a filter technique as a quality control method capable of processing large quantities and real-time processing of canal agricultural water level data, and applicability evaluation is needed. In this study, the types of errors generated by the automatic water level measurement system were first determined. In addition, by using the manual quality control data, a technique with high applicability is derived by comparing and analyzing data calibrated with Gaussian, Savitzky-Golay, Hampel, and Median filter techniques, RMSE, and NSE, and the optimal parameters of the technique range was derived. As a result, the applicability of the Median filter was evaluated the highest, and the optimal parameters were derived in the range of 120min to 240min. Through the results of this study, it is judged that it can be used for quantitative evaluation to establish an agricultural water supply plan.

Development of Freeway Incident Duration Prediction Models (고속도로 돌발상황 지속시간 예측모형 개발)

  • 신치현;김정훈
    • Journal of Korean Society of Transportation
    • /
    • v.20 no.3
    • /
    • pp.17-30
    • /
    • 2002
  • Incident duration prediction is one of the most important steps of the overall incident management process. An accurate and reliable estimate of the incident duration can be the main difference between an effective incident management operation and an unacceptable one since, without the knowledge of such time durations, traffic impact can not be estimated or calculated. This research presents several multiple linear regression models for incident duration prediction using data consisting of 384 incident cases. The main source of various incident cases was the Traffic Incident Reports filled out by the Motorist Assistant Units of the Korea Highway Corporation. The models were proposed separately according to the time of day(daytime vs. nighttime) and the fatality/injury incurred (fatality/injury vs. property damage only). Two models using an integrated dataset, one with an intercept and the other without it, were also calibrated and proposed for the generality of model application. Some findings are as follows ; ?Variables such as vehicle turnover, load spills, the number of heavy vehicles involved and the number of blocked lanes were found to significantly affect incident duration times. ?Models, however, tend to overestimate the duration times when a dummy variable, load spill, is used. It was simply because several of load spill incidents had excessively long clearance times. The precision was improved when load spills were further categorized into "small spills" and "large spills" based on the size of vehicles involved. ?Variables such as the number of vehicles involved and the number of blocked lanes found not significant when a regression model was calibrated with an intercept. whereas excluding the intercept from the model structure signifies those variables in a statistical sense.