xan [xan_PRISM_DW.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
nvs.v_cruises | (View) |
Name | v_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 |