CREATE TABLE public.vesselpositionslijn (
  id bigint NOT NULL DEFAULT nextval('vesselpositionslijn_id_seq'::regclass),
  name character varying COLLATE pg_catalog."default",
  mmsi bigint,
  "position" geometry(LineString,32634),
  CONSTRAINT vesselpositionslijn_pkey PRIMARY KEY (id)) WITH (
  OIDS = FALSE)
TABLESPACE pg_default;

ALTER TABLE public.vesselpositionslijn
OWNER to postgres;

name = str(response.json()[i]['AIS']['NAME'])
mmsi = int(response.json()[i]['AIS']['MMSI'])
latitude = float(response.json()[i]['AIS']['LATITUDE'])
longitude = float(response.json()[i]['AIS']['LONGITUDE'])
timestamp = datetime.datetime.strptime(str(response.json()[i]['AIS']['TIMESTAMP'][:-4]), '%Y-%m-%d %H:%M:%S')
insert_stmt = 'insert into vesselpositions ( name, mmsi, "position", "timestamp" ) values ( %s, %s, ST_SetSRID(ST_MakePoint(%s, %s),4326), %s )'
cur.execute ( insert_stmt, ( name, mmsi, longitude, latitude, timestamp ) )
update_stmt = 'update vesselpositionslijn set position = ST_AddPoint(position, ST_MakePoint(%s, %s)) where name = %s'
cur.execute ( update_stmt, ( longitude, latitude, name) )

SELECT
   ais.mmsi,
   ST_MakeLine(ais.geom ORDER BY utc) As track
FROM ais_points as ais
GROUP BY mmsi;

SELECT
        ais.mmsi,
        ST_MakeLine(ais.geom ORDER BY datetime) As track
      FROM ais_points as ais
     WHERE ST_Intersects(ST_SetSRID(
             ST_MakeBox2D(St_MakePoint(-50, 1), ST_MakePoint(-51, 2)), 4326), ais.geom)
       AND datetime BETWEEN startdate AND enddate
     GROUP BY mmsi;