Data Trawler - Latest ship position

O&A Information and Data Centre  »  Applications  »  Data Trawler
Please login if you have access to particular applications.
Username: Password:
Query
Template: /srv/www/htdocs/data/common/cfc/underway.cfc
Execution Time: 1.39 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select * from (select upper(vp.voyagename) as survey_name, latitude, longitude, vp.date_time as utc
from
voyage_entry ve,
voyage_position vp
WHERE ve.voyage_entry_id = vp.voyage_entry_id and
vp.bad_position = 0 and vp.deleted = 0 and
vessel_id = 1
ORDER BY vp.date_time DESC)
where rownum = 1
SURVEY_NAMELATITUDELONGITUDEUTC
1IN2020_E01-42.959855147.383434{ts '2020-08-06 05:00:00'}

Latest ship position is retrieved from Near Real-time Underway Data (NRUD) from the ship and is also available on the AODN website

Ship: RV Investigator [details]

Voyage: IN2015_E01 [details]
56° 00.1' S     145° 48.9' E
11-Feb-2015 23:00 UTC. (2003 days ago)

Ship speed: 10.02 knots
Direction: 1.67 deg
Sea measurements

Sea temperature: 3.60 deg C
Salinity: 34.020 PSU
Water depth: 0.0 m
Air measurements

Atmospheric Pressure: 1,005.54 hPa
Air temperature: 4.60 degC
Wind speed: 26.19 knot
Wind direction: 310.56 deg
Relative Humidity: 0.00 %

Click here if you wish to see a version using Openlayers.

Cannot create image - invalid source https://www.cmar.csiro.au/geoserver/wms?bgcolor=0xf2AAAFF&bbox=95,-50,180,0&SLD=https://www.marine.csiro.au//data/temp/symbology/sld/tmp_112641iihq.sld&Format=image/png&request=GetMap&width=800&height=519&SRS=EPSG:4326&format_options=layout:scalebar or view sld