Re: [postgis-users] Issue with ST_Intersection seems related to lines crossing themself

2022-10-28 Thread Paul Ramsey
I'd be interested in a list of Timescale (and mobilitydb) functions that would be useful inside postgis to power up the trajectory functionality. P > On Oct 28, 2022, at 2:22 AM, Rory Meyer wrote: > > Hi Juergen, > > I wrote a quick blog post about how I grouped up AIS points into lines, but

Re: [postgis-users] Issue with ST_Intersection seems related to lines crossing themself

2022-10-28 Thread Rory Meyer
Hi Juergen, I wrote a quick blog post about how I grouped up AIS points into lines, but broken up on steps in time, distance, and calculated speed. It's very short but contains some thinking and some code. https://openais.xyz/post/2022-10-28-ais-traj/ You could add an additional spatial