TransWikia.com

Creating tracks for moving points (while discarding records without movement)

Geographic Information Systems Asked on April 18, 2021

I have a csv with columns:

id latitude longitude timestamp

Many of the points (or "id"s) do not change "latitude"/"longitude" over time, others do.

How do I filter out those "id"s and "lat"/"long"s for the ones that did not move?

For the "id"s that do move, there’s a path. How do I export or select only the paths or the "lat"/"long"s of those ids that moved?

Is this possible with MMQGIS or another time-series Plugin?

One Answer

Use Menu Processing / Toolbox / Aggregate. In the field Group by expression (NULL to group all features) set this expression "id" || "latitude" || "longitude" (replace id latitude and longitude with the exact names of your fields) and decide for each of the fields how they should be aggregated. For id, latitude and longitude, you can select first value, for timestamp (and other fields, if you have) you should decide which one you want to keep: all others will be deleted.

In fact you create one feature from several features each time the combination (concatenated text string) of id, latitude and longitue is the same, thus when the same item is in the same place.

enter image description here

Answered by Babel on April 18, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP