Timeline for Tally of sequences of points within point-specific buffer, rolling over timestamps, in PostGIS?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 15, 2019 at 16:35 | comment | added | whitney vogel | This is perfect, thank you! | |
| Oct 14, 2019 at 7:38 | comment | added | robin loche | For example: An Improved DBSCAN Algorithm to Detect Stops in Individual Trajectories (researchgate.net/publication/…) | |
| Oct 14, 2019 at 7:36 | comment | added | robin loche | You can try to run it with 20 as eps and your X as minpoints. You will have an id for your points, each new stop will have a different id (one by stop, the same id for all the points in this stop) and the points that are not in a stop will not have any ID. That just an id, you can also couple it with the distance between 2 consecutive GPS points or others things like that, there is actually a lot of science paper on stop detection in GPS track maybe you can take a look at it. | |
| Oct 11, 2019 at 19:05 | comment | added | whitney vogel | Thank you for your reply! I think you're right that the ST_ClusterDBScan might be what I'm looking for- it looks like this function gives an identification value to points which fall within a certain area? How could I use this scan function to go through each point in the sequence, and "scan" for which points following it are within a 20meter cluster of that point? | |
| Oct 11, 2019 at 15:01 | history | answered | robin loche | CC BY-SA 4.0 |