Abstract
When position data are received from GPS sensors, they are not explicitly associated with any animal. Linking GPS data to animals is a key step in the data management process. This can be achieved using the information on the deployments of GPS sensors on animals (when sensors started and ceased to be deployed on the animals). In the case of a continuous data flow, the transformation of GPS positions into animal locations must be automated in order to have GPS data imported and processed in real-time. In the exercise for this chapter, you extend the database built in Chaps. 2 and 3 with two new tables, gps_sensors_animals and gps_data_animals, and a set of dedicated database triggers and functions that add the necessary tools to properly manage the association of GPS positions with animals.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Sometimes raw data from GPS sensors (e.g. .txt or .csv files produced by the software that manages data acquisition on the client side) have no explicit information on the sensor code itself inside the file. In these cases, the sensor code can be usually derived from the data source (e.g. from the name of the file). In this exercise, it is assumed that the sensor code is already in the raw data file.
- 2.
When the sensor is still deployed on the animal, the end of deployment can be set to null.
- 3.
The file with the test data set trackingDB_datasets.zip is part of the Extra Material of the book available at http://extras.springer.com.
- 4.
For those who are interested in creating their own functions, many resources are available on the Internet, e.g.:
http://www.postgresql.org/docs/9.2/static/sql-createfunction.html
- 5.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this chapter
Cite this chapter
Urbano, F. (2014). From Data to Information: Associating GPS Positions with Animals. In: Urbano, F., Cagnacci, F. (eds) Spatial Database for GPS Wildlife Tracking Data. Springer, Cham. https://doi.org/10.1007/978-3-319-03743-1_4
Download citation
DOI: https://doi.org/10.1007/978-3-319-03743-1_4
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-03742-4
Online ISBN: 978-3-319-03743-1
eBook Packages: Biomedical and Life SciencesBiomedical and Life Sciences (R0)