PostGIS-T: towards a spatiotemporal PostgreSQL database extension

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 NOOA’s Global Drifter Program.

[1]  Martha C. Anderson,et al.  Landsat-8: Science and Product Vision for Terrestrial Global Change Research , 2014 .

[2]  Ralf Hartmut Güting,et al.  Spatio-Temporal Data Types: An Approach to Modeling and Querying Moving Objects in Databases , 1999, GeoInformatica.

[3]  Ute Beyer,et al.  Remote Sensing And Image Interpretation , 2016 .

[4]  Michael F. Worboys,et al.  Event‐oriented approaches to geographic phenomena , 2005, Int. J. Geogr. Inf. Sci..

[5]  J. Campbell Introduction to remote sensing , 1987 .

[6]  M. Netto,et al.  An unsupervised method of classifying remotely sensed images using Kohonen self‐organizing maps and agglomerative hierarchical clustering methods , 2008 .

[7]  James J. Horning,et al.  The algebraic specification of abstract data types , 1978, Acta Informatica.

[8]  J. Early,et al.  A global surface drifter data set at hourly resolution , 2016 .

[9]  Paulo J Ribeiro,et al.  An entomological surveillance system based on open spatial information for participative dengue control. , 2009, Anais da Academia Brasileira de Ciencias.

[10]  Jim Melton,et al.  SQL multimedia and application packages (SQL/MM) , 2001, SGMD.

[11]  Gilberto Câmara,et al.  An Algebra for Spatiotemporal Data: From Observations to Events , 2014, Trans. GIS.

[12]  Karen K. Kemp Fields as a framework for integrating GIS and environmental process models. Part 1: Representing spatial continuity , 1996, Trans. GIS.

[13]  Wolfgang Kresse,et al.  ISO Standards for Geographic Information , 2010 .

[14]  John A. Richards,et al.  Remote Sensing Digital Image Analysis , 1986 .

[15]  R. Lumpkin,et al.  Measuring surface currents with Surface Velocity Program drifters : the instrument , its data , and some recent results , 2022 .

[16]  Karen K. Kemp Fields as a framework for integrating GIS and environmental process models. Part 2: Specifying field variables , 1996, Trans. GIS.

[17]  R. Lumpkin,et al.  Lagrangian Analysis and Prediction of Coastal and Ocean Dynamics: Measuring surface currents with Surface Velocity Program drifters: the instrument, its data, and some recent results , 2007 .

[18]  Antony Galton,et al.  Fields and Objects in Space, Time, and Space-time , 2004, Spatial Cogn. Comput..

[19]  Max J. Egenhofer,et al.  Fields as a Generic Data Type for Big Spatial Data , 2014, GIScience.