Cleaning Up Bad Data from Service Appointment

[MrPaulAR]

Long story short, tesla replaced the computer. However, during the appointment the car showed up in San Jose for some time. There were no trips or charges with this location so the methods defined in the docs didn't help me much.

I tried searching the positions table for a longigude that I could delete but no joy there either. Anyone have any other suggestions?

[cwanja]

Assume this is the visited dashboard? If so, the query is from the positions table, cannot think where else it would source a location from.

Try scoping the dashboard down in terms of timescale. Then use that to narrow your SQL query and see if you can pin-point the data. I imagine there is a single data point that is causing that.

[MrPaulAR]

Yup, just one bad entry. I was missing a - in the longitude query which is why I couldn't find it.

teslamate=# select id, date,latitude,longitude from positions where date >= '2024-12-28' AND date <= '2024-12-31' and longitude>100;
 id | date | latitude | longitude 
----+------+----------+-----------
(0 rows)

teslamate=# select id, date,latitude,longitude from positions where date >= '2024-12-28' AND date <= '2024-12-31' and longitude<-100;
    id    |          date           | latitude  |  longitude  
----------+-------------------------+-----------+-------------
 24932205 | 2024-12-30 21:58:14.704 | 37.394287 | -122.150604
(1 row)

teslamate=# delete from positions where id = 24932205;
DELETE 1

Now the map is all good again.