Abstract

# Extended summary

## Project identity

• Title: Open groundwater data system for Bandung area
• PI: Dr. Dasapta Erwin Irawan
• Fiscal year: 2016
• Funding source: Ministry of Research and Higher Education

## Location

The location of this project is Bandung Basin area.

## Team

The core team of the research is:

• Dr. Rusmawan Suwarman (hydrology)
• Dr. Nur Ulfa (IT)
• M. Irsyad, ST (Geodesy)
• M. Fadli, ST (Map engineer)

Contributors:

• Dr. Bambang Sunarwan
• Ahmad Darul Rochman, ST., MT.
• Aditya Pratama, ST
• Anggita Agustin, ST., MT.

## Project summary

This document describes our final progress in the project. This research was funded by The Directorate General of Higher Education, Ministry of of Research and Higher Education Grant 2016. In this community service research, we try to apply some open source GIS implementation to provide the Government of Bandung City, in this case is Office for Built Environment Management, a spatial groundwater open data system.

We propose the QGIS cloud platform for the system because it's: free, open source, easy use, and stable. It's a free and open source since it was born in 2002 and it was just developing a cloud-based map system offering limited-free services for QGIS users to upload their maps and dataset online. Another plus is that QGIS is part of Opengeo Suite, a group of GIS implementation system that can be used freely. Using the suite, the open data system can be developed as a dynamic map with more visualizations.

Our training dataset are: 200 well data points with water quality, consists of: major ions (Ca, Na, Mg, K, Cl, CO3-HCO3, SO4), temperature, total dissolved solids, conductivity, pH, and groundwater level. The data was taken from various reports that had been accumulated from 2000. More dataset were also compiled but we're not including them in this project. We stored all data and maps in an open repository hosted by Center for Open Science Foundation/COS. We put CC-BY license in order to invite more participation from public to improve this work.

To date the outputs of this project are:

Keywords: open data, open science, Bandung, QGIS, Bandung, Indonesia

# Project description and some visuals

## Background

This document describes our final progress in the project. This research was funded by The Directorate General of Higher Education, Ministry of of Research and Higher Education Grant 2016. In this community service research, we try to apply some open source GIS implementation to provide the Government of Bandung City, in this case is Office for Built Environment Management, a spatial groundwater open data system.

## Objectives

The objectives of this project are to:

• design a proper low cost open data platform
• design a data formatting system for the open data platform
• design a proper map visualization

## Data management

Dataset is the most important part in this research. It affects how we see the data and what it says about the controlling hydrogeological process. Therefore we also write a detail description on how we set up the dataset.

### Data sources

The preliminary result is a dataset with 200 rows and 20 columns. 200 well data points with water quality, consists of: major ions (Ca, Na, Mg, K, Cl, CO3-HCO3, SO4), temperature, total dissolved solids, conductivity, pH, and groundwater level. The data was taken from various reports that had been accumulated from 2000.

We identified each report that we had in the library, as follows:

• Geology ITB
• Center of Geological Research and Development
• Other sources and own testing for verification (specifically for dataset from West Java Province)
• Krahmer, M. S. (1995)
• Puradimaja et al. (1997)
• Sunarwan et al. (1997)
• Suparman, dkk. (1999)
• Lubis et al. (2000)
• Kusnadi, D. (2002)
• Dirasutisna, S. (2004)
• Nukman (2009)
• Emianto dan Aribowo (2011)
• Nurohman dan Aribowo (2012)
• Sunarwan et al. (2014)
• Iqbal et al. (2016)
• Dedi K (2016)
• Euis (2016)
• Fauziyyah et al. (2016)
• Haq et al. (2016)
• Prabowo et al. (2016)
• Alfiandy et al. (2016)
• Wahyudi et al. (2016)

However, not all of the samples have all the measurements, therefore we curated the dataset very carefully. Many blank cells will be labeled with NA . The complete dataset is attached in the dataset folder . However we had several drawbacks in collecting the coordinates of the points.

### Data consolidation and treatment

The final dataset was consolidated from various sources. Each source contained different kind of measurements. Thus we had a various size of data matrix. Therefore we appended the matrix size piece by piece to incorporate all data matrices. The final dataset and variable descriptor can be seen in the repository Google Drive.

### Data repository

Every data set is accessible from the OSF repository. Final link may be changed and doi will be added as soon as it is registered) and can be searched by title, topic and field location. Interactive map will be available soon using QGIS Cloud System, and also we have to deal with the coordinates problem. We tried to set the points based on the geographical indications written in the original reports.

### Data use/sharing policy

All resources are released to the public in CC-BY license. It may be freely copied, distributed, edited, remixed, and built upon under the condition that you give acknowledgment as described below:

• Give proper acknowledgement. Publications, models and data products that make use of these datasets must include proper acknowledgement, including citing datasets in a similar way to citing a journal article (i.e. author, title, year of publication, edition or version, and URL or DOI access information. (See Why cite data).
• Let us know how you will use the data. The dataset creators would appreciate hearing of any plans to use the dataset. Consider consultation or collaboration with dataset creators.

### Software

We used the following open source software for the analysis:

# Testimony from the community

The following testimonies and notes were gathered from two meetings with the groundwater resources authorities from Bandung city.

Sistem ini bagus harus terus dikembangkan dan ditambah datanya.

Publik sangat ingin mengetahui kondisi air tanah di Bandung, sistem open data ini bisa jadi salah satu caranya.

Air tanah adalah salah satu berkah Allah SWT harus jelas pengelolaannya. Dengan sistem data terbuka diharapkan semua pihak dapat memantau, sehingga air tanah lebih terjaga.

# Self evaluation

Most of the problems and drawbacks in this research were derived from data availability. The existing data authorities have not been very keen in managing dataset. We commonly found data based on no ID and no location precise location.

## Outputs

• objectives in proposal
• objectives in report

## Products (table)

To date the outputs of this project are:

## Synergy with another project

We integrated the funding with previous funding from the Office for Built Environment of Bandung. They also offered small fund for us to collect more groundwater well data. One of our future plan is to collaborate in the Portal Data Indonesia, which is one of the initiatives of open data movement in Indonesia.

## Value of the research

The following is the value of the research:

• It is a nation-wide overview of geothermal dataset. Being aggregated from multiple sources with various settings, this dataset is a model of aggregation process,
• It is a model of low budget research in terms of software costs, because it uses open source tools (software, file formats, and data repository infrastructure)
• It endorses open science concept with: easy access on all resources, transparency of the process, and rapid dissemination through open source repository and publication media.

## Positive results and drawbacks

We believe this project could be one of the starting movement to provide open data for public use. However we also should be very careful with the data re-use for economic and commercial reasons, eg: the building of more malls, apartments, in certain areas. Therefore the monitoring steps should be taken prominently.

## Future plans

We're planning to work on the following plan:

• add the system with more thematic maps;
• add some socio-economic maps to overlay the physical maps;
• add more dynamic data;
• add some analysis in form of contours and zones;
• add some multimedia materials.

One of our reference for the development is to apply WebGIS in the process, following these examples of webGIS for: