If you have synced a track to the server, it has been saved in two datasets: tracking_list and tracking.
tracking_list contains a list of all the tracks.
tracking contains all the points saved in the tracks and their associated meta.
Step 1: Identify your track's ID.
To do this you can use the following instructions to find the list of tracks.
Look at the name field to identify the track, and the amigo_id to identify the track id:
Once you have identified the amigo_id of the track that you want, you can select all the points related to that track in the tracking dataset.
Use the advance queries suggestions to find the tracking dataset:
In order to assist you to create a query that follows: select * from dataset_XXXX where track_id = '<amigo_id of the track you previously identified>'
For example:
Once you've been able to identify the points related for a specific track you can do interesting things like convert them into a line:
select st_makeline( dataset_71698.position order by timestamp) from dataset_71698 where track_id = '79177f8eddf046378062fc4cf50da8cf'
Or using a subquery:
select st_makeline( ARRAY(select position from dataset_71698 where track_id = '79177f8eddf046378062fc4cf50da8cf' order by timestamp) ) as geometry;
You can then save the line to a new dataset using the "Create Permanent Dataset" Function:
Or save it to an existing dataset using an insert like:
INSERT into dataset_92402 (wkb_geometry) VALUES (
ST_MULTI(
ST_MAKELINE(
ARRAY(
select position
from dataset_71698
where track_id = '79177f8eddf046378062fc4cf50da8cf'
order by timestamp)
)
)
)
Comments
0 comments
Please sign in to leave a comment.