Changes between Version 1 and Version 2 of Ticket #4747, comment 6


Ignore:
Timestamp:
Aug 26, 2020, 1:17:20 AM (4 years ago)
Author:
ezimanyi

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4747, comment 6

    v1 v2  
    1818* call 4K times the function ST_SetSRID to specify that the input data is in 4326 SRID
    1919* call 4K times the function ST_Transform to put the data in the 25832 SRID.
    20 And all this only to load the data of a single day before analyzing every couple of trips in the data set, synchronizing the two trips to obtain 2 trips of 4K + 4K synchronized points and
     20And all this only to load the data of a single day before analyzing every couple of trips in the data set, synchronizing (with linear interpolation) the two trips to obtain 2 trips of 4K + 4K synchronized points and
    2121* call  4K + 4K times the function ST_Distance for each couple of trips.
    2222As you can imagine, for such kind of manipulations we really need to access directly the liblwgeom library. The situation is much more challenging for analyzing aviation data obtained from, e.g.,