Global Transshipment Behaviour
This dataset includes data on transshipment from Frontiers in Marine Science
@kaggle.sayansh001_global_transshipment_behaviour
This dataset includes data on transshipment from Frontiers in Marine Science
@kaggle.sayansh001_global_transshipment_behaviour
Vessels meet at sea for multiple reasons, such as refueling and exchanging crew, but in the commercial fishing industry, they also meet to transfer catch, or transship. Using machine learning, we processed more than 32 billion Automatic Identification System (AIS) signals broadcast from ships at sea to identify vessels capable of receiving transshipments and analyze their movements. Those vessels include fish tenders, live fish carriers, factory/processors and refrigerated cargo vessels. Verifying our results with confirmed fishery registries and open source online resources, we identified vessels capable of transshipping fish at sea between 2012 and December 2017, and incidents in which one of these vessels exhibited telltale transshipment behavior patterns such as drifting slowly enough and long enough to receive a transfer of catch.
This dataset includes data on transshipment. Included are data on the following:
List of vessels involved in transshipment - Includes transshipment capable vessels (fish tenders, live fish carriers, factory/processors and refrigerated cargo vessels).
Loitering events - Occurrences of transshipment-capable vessels drifting slowly enough and long enough to receive a transfer of catch, but during which time no fishing vessels are observed on AIS meeting with the vessel.
Potential transshipment events (encounters) - Occurrences of transshipment-capable vessels drifting slowly enough and long enough to receive a transfer of catch and meeting with one or more fishing vessel that is actively broadcasting AIS.
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
);CREATE TABLE loitering_events (
"transshipment_mmsi" BIGINT,
"starting_latitude" DOUBLE,
"starting_longitude" DOUBLE,
"ending_latitude" DOUBLE,
"ending_longitude" DOUBLE,
"starting_timestamp" VARCHAR,
"ending_timestamp" VARCHAR,
"median_speed_knots" DOUBLE,
"total_event_duration" DOUBLE
);CREATE TABLE transshipment_vessels (
"mmsi" DOUBLE,
"shipname" VARCHAR,
"callsign" VARCHAR,
"flag" VARCHAR,
"imo" DOUBLE,
"first_timestamp" VARCHAR,
"last_timestamp" VARCHAR
);Anyone who has the link will be able to view this.