This project aims to design a dashboard using shiny.semantics of the marine dataset

Marine dataset has 3102887 rows and 20 variables with the following structure:

The data is a log of the AIS signal that renders each vessel position under a frequency of time.

1. There were found cases of conflict between SHIP_ID and SHIPNAME, in theory SHIP_ID is unique and therefore should have a unique name as well as for SHIPNAME having a single SHIP_ID

The same happens under SHIPNAME:

These inconsistencies were not treated and should be kept on track for deployment.

1. Relationship between IS_PARKED and SPEED hold beyond the speed of 3 knots. It is safe then to assume that IS_PARKED can be used to filter out cases of vessels that are not in movement.

In order to run into shiny, the data was cleaned based out of the cases:

1. Removed the cases of vessels in movement IS_PARKED = 0 leading to 333.188 observations, a reduction of 90% under the raw data.
2. Removed 6 cases of vessels that had only one signal despite being in movement that would cause issues to the max distance calculation.
3. Calculated the max distance beforehand, returning to the app only the data needed for the dashboard, leading to 2.020 observations. A reduction of 99% under the silver data (Parked data)