Baselight

Global Transshipment Behaviour

This dataset includes data on transshipment from Frontiers in Marine Science

@kaggle.sayansh001_global_transshipment_behaviour

Encounter Events
@kaggle.sayansh001_global_transshipment_behaviour.encounter_events

  • 693.09 KB
  • 11681 rows
  • 9 columns
fishing_vessel_mmsi

Fishing Vessel Mmsi

transshipment_vessel_mmsi

Transshipment Vessel Mmsi

start_time

Start Time

end_time

End Time

mean_latitude

Mean Latitude

mean_longitude

Mean Longitude

duration_hr

Duration Hr

median_distance_km

Median Distance Km

median_speed_knots

Median Speed Knots

4165650003542400002016-11-18T14:30:00Z2016-11-19T01:50:00Z-17.0390854214-79.063724603911.3333333333333340.03818823080.5854019161
4126791903542400002016-12-11T14:50:00Z2016-12-11T19:50:00Z-20.26960835264285-79.2449525440428650.020033308750.57566267235
4408630003542400002017-06-13T12:50:00Z2017-06-15T01:20:00Z-62.640767187979215-60.69024019292556536.50.054992305250.01977473045
4165630003542400002016-11-15T11:30:00Z2016-11-16T04:00:00Z-17.04658591501366-79.061923455367716.50.03642717041.0239170614
4413090003542400002017-05-19T00:40:00Z2017-05-19T20:50:00Z-46.62787804705882-60.5549218369647120.1666666666666680.034052996150.5440311111
4165620003542400002016-11-17T13:30:00Z2016-11-18T02:30:00Z-17.220085674306922-79.07317367317691130.04640634880.463292461
4123310913542400002016-12-12T13:20:00Z2016-12-13T10:00:00Z-19.6777824652-79.6855565332999920.6666666666666680.02257461950.6894348540999999
4124201963542400002016-11-29T07:10:00Z2016-11-29T10:00:00Z-17.7692122372-80.21585652832.8333333333333330.04186873721.0876430475
4402610003542400002015-05-18T11:20:00Z2015-05-19T03:40:00Z-45.5028999467-60.501213526516.3333333333333320.02948561640.0332998295
4122179993542400002017-05-27T20:40:00Z2017-05-28T11:40:00Z-62.48032780154166-59.68579309160119150.05375117310.0601873423

CREATE TABLE encounter_events (
  "fishing_vessel_mmsi" BIGINT,
  "transshipment_vessel_mmsi" BIGINT,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "mean_latitude" DOUBLE,
  "mean_longitude" DOUBLE,
  "duration_hr" DOUBLE,
  "median_distance_km" DOUBLE,
  "median_speed_knots" DOUBLE
);

Share link

Anyone who has the link will be able to view this.