Safe way to mass-delete or mass-update wrong GPS data

[kamaeff]

Hi!

After importing Google Timeline data, I found out that the data quality was poor for some locations and date intervals.

E.g. I have thousands of points spread across years with exactly the same incorrect coordinates. I guess Google was sticking to coordinates of the nearest mobile base station and collected these points alongside the correct ones.

I want to either delete them all or try to update them to point to last known location.

Doing that manually via current web ui is slow.

Is it safe to do something like this? Won't it break the data relations?

1. Look inside postgresql database
2. Locate the raw gps data table
3. Run query like thisDELETE FROM … WHERE "source" = 'GOOGLE_TIMELINE' AND "latitude" = … AND "longitude" = … AND "datetime" BETWEEN … AND …
4. Start geopulse and rebuild timeline and coverage via web ui

[kamaeff]

Oh I see another option and it is to delete all Google timeline points, update the original Google timeline export with jq and then reimport it.

[tess1o]

You can delete the data via "GPS Data" page or directly via SQL. Removal of data from gps_points table is safe.