Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License
Abstract
In this paper, we propose a system model for querying and indexing the GPS trajectory of moving objects on PostGIS/PostgreSQL. We developed moving object data types including MPoint(moving point), MDouble(moving double) for GPS trajectories. Also, various moving objects UDFs(user-defined functions) are implemented for moving objects queries. For efficient query processing, r-tree index is extended for trajectory, and pre-materialization techniques are proposed for fast UDF processing. Experimental results show that the pre-materialization techniques are about 1.2 times faster than naïve query processing using r-tree index.
DOI
https://doi.org/10.7275/R57W69D2
Recommended Citation
Yang, Pyoung Woo and Nam, Kwang Woo
(2017)
"Supporting Trajectory UDF Queries and Indexes on PostGIS,"
Free and Open Source Software for Geospatial (FOSS4G) Conference Proceedings: Vol. 17, Article 26.
DOI: https://doi.org/10.7275/R57W69D2
Available at:
https://scholarworks.umass.edu/foss4g/vol17/iss1/26