CSV file

From the dataset abstract

The dataset includes monitoring data collected during the FinEst Smart Mobility project (5th April 2018 – 15th March 2019) on the passenger ships Finlandia, Star, Megastar and Silja Europa operating between Helsinki’s West Harbour and the Tallinn Harbour.

The dataset includes the ships’ position, speed, direction, scheduled departure and arrival times, actual departure and arrival times and estimated departure and arrival times.

The dataset is based on the data from the Digitraffic AIS service of the then Finnish Transport Agency, and it has been combined with the scheduling data of Eckerö Line and Tallink-Silja and the schedule monitoring and forecasting data developed by Fleetrange Oy in the project. The data includes a total of 4,388 trips between Helsinki and Tallinn and approximately 14 million data points over 339 days.

The spatial data is in the WGS84 format (dd.ddddd). All times are UTC. The coding set for the CSV file is UTF-8.

The dataset contains the following information:

• id: database table row identifier
• updated: update time of the row in question
• ship: name of the ship
• imo: IMO number of the ship
• lat: latitude (dd.dddd)
• long: longitude (ddd.dddd)
• sog: Speed Over Ground
• cog: Course Over Ground
• hdg: Heading
• depPort: UNLOCODE of the port of departure: EETLL or FIHEL
• etdSchedule: scheduled departure time given by the shipping company
• etd: departure time estimated by FinEstAPI
• atd: actual departure time of the ship
• arrPort: UNLOCODE of the port of arrival: EETLL or FIHEL
• etaSchedule: scheduled arrival time
• eta: estimated arrival time
• ata: actual arrival time

Source: Matkustaja-alusten aikataulu-, liikennöinti-, ja sijaintitietoja Helsingin ja Tallinnan välillä