290 likes | 314 Views
This proposal outlines a comprehensive approach to managing water pollution sources with Open Source GIS, focusing on the analysis methods, target basin, and data generation processes. The document covers the investigation of various systems contributing to water pollution, such as livestock, aquaculture, industrial, and landfill systems. By utilizing Geographic Information Systems (GIS) data and Water Emission Management System (WEMS) data, the aim is to create accurate and detailed reports to improve water quality monitoring and regulatory compliance. The proposed methodology involves collecting, editing, and integrating data from multiple sources to create a comprehensive analysis of pollution sources. Additionally, the use of Open Source GIS (QGIS) is highlighted for its role in providing more precise investigation results and reducing uncertainties in identifying pollution areas. The document also outlines the future plans for implementing the proposed water pollution management strategy.
E N D
Proposal of Water Pollution Sources Management based on Open Source GIS September 17, Thursday NIER(National Institute of Environmental Research) Han-Kang(karamhan@korea.kr)
Contents • Introduction • NIER(National Institute of Environmental Research) • WEMS(Water Emission Management System) • Classified investigaion and Content • Why use Open Source GIS(QGIS) • Analysis Methods • Target Basin • Create&Use GIS Data • Data generated process • Analysis • Analysis Verification • Future Plan
1. Introduction 1) NIER(National Institute of Environmental Research) <www.nier.go.kr>
1. Introduction 1) NIER(National Institute of Environmental Research) • Organization • Vision Department Name
1. Introduction 2) WEMS(Water Emission Management System)
1. Introduction 3) Investigation items and Content • Life-System • Collection of basic data, Calculation using basic data • Livestock-System • Processing Status investigaionby species and livestock farmers in farm based on Regulatory burden which is less than permit employments, types of reports and Found • Cattle manure generated and data collection of processing status • Data collection of livestock-related concessionaires Status • Industrial-system • Investigaionbased on operating waste water discharge sites of 1~5 type on the year • Investigation for general satatusof wastewater discharge establishments • Current management status of wastewater discharge establishments • Land-system • Survey of land use area of the regal land category of 28 parts(Utilize data of the Ministry of Land)
1. Introduction 3) Classified investigaion and Content • Aquaculture-system • Survey of Aquaculture facilities of other water pollution source and similar facilities • General status data collection • Landfill-system • The investigaionof landfill facilities that landfill leachate is discharged • The current situation and operational status data collection • Current situation of environmental infrastructure • The current situation and operational status data collection of public sewage treatment facilities, Wastewater treatment facilities, etc. • The current situation and operational status data collection of excreta treatment facilities • The current situation and operational status data collection of livestock treatment facilities • Current situation of other water pollution source • Target : Country club, Transportation equipment maintenance or junkyard facilities, The simple processing of livestock and fisheries facilities, Film processing, X-ray facilities, workmanship facilities of jewellery shop, optical store
1. Introduction 4) Why use Open Source GIS(QGIS) • Investigation Data published (Book, Text, ETC)
1. Introduction 4) Why use Open Source GIS(QGIS) • Open Source GIS use for more accurate result of investigation • Eliminate the uncertainty of occupation areas through the spatial data construction of pollution sources Text, Excel Survey Data Open Source GIS Software
2. Analysis Methods 1) Target Basin TMS Korea daumsatellite Area Custom EPSG 2097 Incheon and Gyeonggi-do
2. Analysis Methods 2) Create&Use GIS Data
2. Analysis Methods 3) Data generated process • STEP 1 : Collect GIS Data and WEMS basic data • STEP 2 : Edit GIS Data • STEP 3 : Create KEY Value Each region • STEP 4 : Edit WEMS basic data • STEP 5 : Create KEY Value of WEMS data • STEP 6 : Join GIS and WEMS data • STEP 7 : Create Result file
2. Analysis Methods 3) Data generated process • STEP 1 : Collect GIS Data and WEMS basic data • STEP 2 : Edit GIS Data • STEP 3 : Create KEY Value Each region • STEP 4 : Edit WEMS basic data • STEP 5 : Create KEY Value of WEMS data • STEP 6 : Join GIS and WEMS data • STEP 7 : Create Result file • Region Layer Attribute tablePNUCode verification • PNU Code Separation -> New Column Create, Data Insert
2. Analysis Methods 3) Data generated process • STEP 1 : Collect GIS Data and WEMS basic data • STEP 2 : Edit GIS Data • STEP 3 : Create KEY Value Each region • STEP 4 : Edit WEMS basic data • STEP 5 : Create KEY Value of WEMS data • STEP 6 : Join GIS and WEMS data • STEP 7 : Create Result file Region Layer Attribute tablePNUCode verification PNU Code Separation -> New Column Create, Data Insert Create KEY Value and Verification <Create KEY Value> <KEY Value Verification>
2. Analysis Methods 3) Data generated process • STEP 1 : Collect GIS Data and WEMS basic data • STEP 2 : Edit GIS Data • STEP 3 : Create KEY Value Each region • STEP 4 : Edit WEMS basic data • STEP 5 : Create KEY Value of WEMS data • STEP 6 : Join GIS and WEMS data • STEP 7 : Create Result file Edit WEMS data Delete unneeded columns
2. Analysis Methods 3) Data generated process • STEP 1 : Collect GIS Data and WEMS basic data • STEP 2 : Edit GIS Data • STEP 3 : Create KEY Value Each region • STEP 4 : Edit WEMS basic data • STEP 5 : Create KEY Value of WEMS data • STEP 6 : Join GIS and WEMS data • STEP 7 : Create Result file • Using CONCATENA Fuction – Create KEY Value • ‘=CONCARENATE(‘행정구역코드’-’본번’-’부번’) • Ex) 서울 종로구 내자동 167-2: ‘1111011100-167-2’
2. Analysis Methods 3) Data generated process • STEP 1 : Collect GIS Data and WEMS basic data • STEP 2 : Edit GIS Data • STEP 3 : Create KEY Value Each region • STEP 4 : Edit WEMS basic data • STEP 5 : Create KEY Value of WEMS data • STEP 6 : Join GIS and WEMS data • STEP 7 : Create Result file Using QGIS Analysis “Join Function” GIS Data and WEMS data JOIN
2. Analysis Methods 3) Data generated process • STEP 1 : Collect GIS Data and WEMS basic data • STEP 2 : Edit GIS Data • STEP 3 : Create KEY Value Each region • STEP 4 : Edit WEMS basic data • STEP 5 : Create KEY Value of WEMS data • STEP 6 : STEP 6 : Join GIS and WEMS data • STEP 7 : Create Result file Save New Layer Create WEMS Layer
2. Analysis Methods 4) Analysis (Urban Area/Suburban Area) • Using ‘Clip’ Methods • Inputlayer: • land use area of the regal land category of 28 parts(Land value) feature Select • Clip layer: • Code : housing, Commerce, Industry feature Select LEGEND Urban Area Target Area
2. Analysis Methods 4) Analysis (Sewage treatment areas Layer) LEGEND A Sewer within 50m Area B Meet local sewer within 50m C Target Area A layer: C layer Sewer pipe network Buffer distance50m B layer: Research tools → Select by location Use - Select feature: C layer - Intersect feature: A layer ☞ B layer: final target area Define
2. Analysis Methods 4) Analysis (Life-system : Population) LEGEND A: Urban Area Sewage Area - Pop B: C: Non-Sewage Area - Pop • B layer: • Geoprocessing tools • →Clip Select • - Input: Populationlayer • - Clip: Sewage Arealayer • C layer: • Geoprocessing tools • →Difference Select
2. Analysis Methods 4) Analysis (Life-system : Water Use) LEGEND A: Urban Area Sewage Area - WU B: C: Non-Sewage Area - WU B layer: Geoprocessing tools →Clip Select - Input: Water Uselayer - Clip: Sewage Arealayer C layer: Geoprocessing tools →Difference Select
2. Analysis Methods 4) Analysis (Livestock and Industrial-system, Environmental infrastructure) LEGEND Industrial-system Livestock-system Current situation of Environmental infrastructure Sewage Area Target Area
2. Analysis Methods 4) Analysis (Land-system) LEGEND Acre field Forest land Building site Paddy field ETC
2. Analysis Methods 5) Analysis Verification • Verify error data Industrial-system Same address Life-system
2. Analysis Methods 5) Analysis Verification • Verify error data Error data Sewage Area
3. Future Plan Using WEMS Data Analysis Development Development of analysis process How to build a simplified GIS Data QGIS often used Analysis Plug-in Development
감사합니다. Thank you E-mail karamhan@korea.kr