Loads the GPS trajectory points from the database.

match-trips_load_trajectory_points.py

def load_trajectory_points(traj_id):
    db = EVedDb()

    sql = f"""
    select     distinct
               s.latitude as lat
    ,          s.longitude as lon
    ,          min(s.time_stamp) / 1000 as time
    from       signal s
    inner join trajectory t on s.vehicle_id = t.vehicle_id and s.trip_id = t.trip_id
    where      t.traj_id = ?
    group by   s.latitude, s.longitude
    order by   s.time_stamp;
    """
    return db.query_df(sql, [traj_id])