v_cruises - View
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

Namev_cruises
SQL
SELECT
    gc.coll_id,
    gc.platform_id,
    gc.cruise_name,
    c.long_name AS cruise_lname,
    gc.cruise_date,
    gc.dtime_start,
    gc.dtime_end,
    st_astext(gc.geom_ln) AS cruise_linestr
FROM geo_cruise gc,
    collection c
WHERE gc.coll_id = c.row_id
ORDER BY gc.cruise_date