PostGIS-T: towards a spatiotemporal PostgreSQL database extension.
Rolf Ezequiel de Oliveira Simões, Gilberto Ribeiro de Queiroz, Karine Reis Ferreira, Lúbia Vinhas, Gilberto Câmara · Biblioteca Digital da Memória Científica do INPE (National Institute for Space Research) · 2016
The temporal dimension of spatial data has been the subject of discussion in the literature for a long time. While there are numerous Database Management System (DBMS) solutions only for spatial dimension, we did not observe the same situation for spatiotemporal data. Considering this gap, our purpose is to design and implement an extension to the DBMS PostgreSQL that is based on a formal spatiotemporal algebra in order to incorporate representations of spatiotemporal data within the DBMS. The proposed extension can be used in a large range of applications. We intend that this extension be a reasonable framework to store and handling observational remote sensing data usually present in applications like animal migration researches, wildfires monitoring, vessel tracking for monitoring fishing, and the like. In this work, we show how to apply it in a case study based on spatiotemporal data collected from drifting buoys belonging to the NOOAs Global Drifter Program.