CREATE VIEW vessel_view AS (
 WITH latest_position AS (
         SELECT metrics.vessel_id,
            metrics."time",
            metrics.courseovergroundtrue,
            metrics.speedoverground,
            metrics.anglespeedapparent,
            metrics.longitude,
            metrics.latitude,
            st_makepoint(metrics.longitude, metrics.latitude) AS geo_point
           FROM api.metrics
          WHERE ((metrics.latitude IS NOT NULL) AND (metrics.longitude IS NOT NULL) AND (metrics.vessel_id = current_setting('vessel.id'::text, false)))
          ORDER BY metrics."time" DESC
         LIMIT 1
        )
 SELECT m.vessel_id,
    m.name,
    m.mmsi,
    v.created_at,
    m.created_at AS first_contact,
    m."time" AS last_contact,
    ((((now() AT TIME ZONE 'UTC'::text))::timestamp with time zone - m."time") > 'PT1H10M'::interval) AS offline,
    ais.description AS ship_type,
    mid.country,
    iso.alpha_2,
    m.length,
    m.beam,
    m.height,
    m.plugin_version,
    m.platform,
    (m.configuration IS NOT NULL) AS has_config,
    (m.user_data -> 'make_model'::text) AS make_model,
    ((m.user_data -> 'polar'::text) IS NOT NULL) AS has_polar,
    (jsonb_array_length(COALESCE((m.user_data -> 'images'::text), '[]'::jsonb)) > 0) AS has_images,
    (((m.user_data -> 'images'::text) -> 0) ->> 'url'::text) AS image_url,
    (((m.user_data -> 'images'::text) -> 0) ->> 'updated_at'::text) AS image_updated_at,
    (m.user_data -> 'images'::text) AS images,
    (m.user_data -> 'specs'::text) AS specs,
    jsonb_build_object('type', 'Feature', 'geometry', (st_asgeojson(st_makepoint(p.longitude, p.latitude)))::jsonb, 'properties', jsonb_build_object('name', m.name, 'time', p."time", 'longitude', p.longitude, 'latitude', p.latitude, 'make_model', (m.user_data -> 'make_model'::text), 'image_url', (((m.user_data -> 'images'::text) -> 0) ->> 'url'::text))) AS geojson
   FROM (((((auth.vessels v
     JOIN api.metadata m ON ((m.vessel_id = v.vessel_id)))
     LEFT JOIN aistypes ais ON ((ais.id = m.ship_type)))
     LEFT JOIN mid ON ((("left"(m.mmsi, 3))::numeric = mid.id)))
     LEFT JOIN iso3166 iso ON ((iso.id = mid.country_id)))
     LEFT JOIN latest_position p ON ((p.vessel_id = m.vessel_id)))
  WHERE (m.vessel_id = current_setting('vessel.id'::text, false))
)