An Analytical Tool for Georeferenced Sensor Data based on ELK Stack

Thi Thu Trang Ngo, David Sarramia, Myoung-Ah Kang, François Pinet

Abstract

In the context of the French CAP 2025 I-Site project, an environmental data lake called CEBA is built at an Auvergne regional level. Its goal is to integrate data from heterogeneous sensors, provide end users tools to query and analyse georeferenced environmental data, and open data. The sensors collect different environmental measures according to their location (air and soil temperature, water quality, etc.). The measures are used by different research laboratories to analyse the environment. The main component for data shipping and storing is the ELK stack. Data are collected from sensors through Beats and streamed by Logstash to Elasticsearch. Scientists can query the data through Kibana. In this paper, we propose a data warehouse frontend to CEBA based on the ELK stack. We as well propose an additional component to the ELK stack that operates streaming ETL which allows integrating and aggregating streaming data from different sensors and sources given the user configuration in order to provide end users more analytical capabilities on the data. We show the architecture of this system, we present the functionalities of the data lake through examples, and finally, we present an example dashboard of the data on Kibana.

Download


Paper Citation


in Harvard Style

Ngo T., Sarramia D., Kang M. and Pinet F. (2021). An Analytical Tool for Georeferenced Sensor Data based on ELK Stack. In Proceedings of the 7th International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM, ISBN 978-989-758-503-6, pages 82-89. DOI: 10.5220/0010439200820089


in Bibtex Style

@conference{gistam21,
author={Thi Thu Trang Ngo and David Sarramia and Myoung-Ah Kang and François Pinet},
title={An Analytical Tool for Georeferenced Sensor Data based on ELK Stack},
booktitle={Proceedings of the 7th International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,},
year={2021},
pages={82-89},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0010439200820089},
isbn={978-989-758-503-6},
}


in EndNote Style

TY - CONF

JO - Proceedings of the 7th International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,
TI - An Analytical Tool for Georeferenced Sensor Data based on ELK Stack
SN - 978-989-758-503-6
AU - Ngo T.
AU - Sarramia D.
AU - Kang M.
AU - Pinet F.
PY - 2021
SP - 82
EP - 89
DO - 10.5220/0010439200820089