Meeting Minute #8

Date: 22 June 2024

Time: 4pm to 5pm

Location: Physical, after class meeting.

Attendees: Arya Siahaan, Seng Jing Yi, Thet Myat Noe

Agenda:

1. Discussion on existing Shiny R plots
2. Discussion on areas of abnormalities
3. Discussion on final deliverables (Shiny Plot, User Guide, Poster)

Meeting Notes:

Discussion on the functionality and areas for improvement for the r Shiny Plots:

• Shiny Plot 1: Interactive Map of Oceanus

Purpose & Functionality

Purpose: Help users understand the location in relation to each other on a map.

1. Allows users to select type of area that they are interested in (e.g., Fishing Ground).
2. Allows users to select type of fish species they are interested in to see location of origin.
3. Allows users to select activities that they are interested in to see the authorized areas to conduct these activities.

Review Decision:

Exclude this plot from the final dashboard as although it provides contextual information, the guide on relative proximity of areas will be more meaningful when including vessel trajectory or dwell time for vessels.

To highlight where certain fish species are found in certain location, this can be done with a simple matrix to map the possible fish species (rows) to location (columns), focusing on fishing grounds and ecological preserves.

• Shiny Plot 2: Quantity of cargoes received per month

Purpose & Functionality

Purpose: Help users understand the quantity of cargo caught per month for the various species.

1. Allows users to zoom into their “Port of Interest”
2. Trend line of month on month change to identify the pattern (increase/ decrease)

Areas for Improvement

1. Color of “Salmon” to be shifted to a darker yellow for greater visibility
2. Include mapping of possible vessels that delivered these cargo & association with the companies that delivered these cargo.
3. Introduce trend line of “Median” across the year to show the relative catch amount difference for the respective months.
4. Calculation for trend line below should not be “Percentage Change” and instead should be based on absolute amount in the form of Sparklines, to highlight the min and max values.

• Shiny Plot 3: Network Graph of Vessel ID to Cargo ID mapping

Purpose & Functionality

Purpose: Helps users to identify the cargo associated with the vessel of interest.

1. Allows users to filter to identify the cargo mapping and vessel mapping per company.
2. Allows user to see the summary of cargo and vessels mapped for each port.
3. Size of the nodes for cargo is dependent on the cargo quantity in tons.
4. Color of the cargo node reflects if the fish species caught is legal or illegal. (Red: Illegal, Orange: Legal).

Area for Improvement

1. Include reference on what is the selected fish species for user’s readability.
2. Include details on which port are these cargo delivered to and which months these cargo are delivered on a summary plot.
3. Include dotted line where the match between vessel and cargo is poor (e.g., >7 days difference between vessel arrival date and cargo transaction date)

• Shiny Plot 4: Vessel dwell time & relative dwell time to other vessels

Purpose & Functionality

Purpose: Helps users have a quick view of vessel’s dwell time at various locations (on Oceanus geographical map) and in relation to other vessels.

1. Allows users to filter based on interested time period to compare dwell across selected periods (e.g., before SSEC was caught, after SSEC was caught).
2. Colors on boxplot background allows users to quickly identify the type of geographical region in relation to Oceanus map. (e.g., Beige for cities, light blue for fishing grounds and light green for ecological preserves).

Areas for Improvement

1. Make box plot interactive with plotly such that when hovering on the specific point, users are able to identify the underlying vessel associated with it.
2. Also, to additional details (e.g., Vessel Company, Dwell Time) can be added to provide context on the vessel of interest.
3. To zoom in to key areas of interest, namely fishing grounds and ecological preserve, the other non-critical areas such as “Cities, Navigation Buoy, Deep Sea fishing buoys” should be excluded to minimise distraction.

• Shiny Plot 5: Interactive Calendar Heatmap

Purpose & Functionality

Purpose: Helps user see the seasonality of when cargo reaches the respective ports based on a calendar map

1. Allows users to compare the cargo count across various port at specific dates.

Area for Improvement

1. Include filter to allow users to zoom into selected dates of interest.
2. Relabel of the y axis to make it reasonable instead of using count of weeks.
3. To include reference to other data set (e.g., Count of vessels that is at the port, return the breakdown of fish species caught)

• Shiny Plot 6: Summary of the most frequent route taken by vessels.

Purpose & Functionality

Purpose: Identifies the most travelled distinct routes by vessel.

1. Allow users to select areas of interest that they are looking at and count the number of vessel for these top routes.
2. Allow users to zoom into specific companies to identify the distinct locations visited.

Area for Improvement

1. Highlight routes that have trespass illegal fishing route in “Red”
2. Highlight routes that have visited fishing grounds and deep sea fishing navigation buoy in “Dark blue”
3. Include reference to map to plot the geographical route taken on the map.

• Shiny Plot 7: Box Plot of Cargo Weight by Fish Species by Month

Purpose & Functionality

Purpose: Helps users to identify which vessel contributes to which cargo and the relative position within the month.

1. Allows users to drill down into desired fish species
2. Allows users to drill down into specific port of interest.

Area for Improvement

1. Handling error where there is no record for that fish species for the given port, to properly return “No Available Record”.
2. Introduce option for user to select color for highlighted vessels (Multiple) to contrast

• Shiny Plot 8: Median Dwell Time of vessel by Area

Purpose & Functionality

Purpose: Helps users identify the monthly median dwell time of the vessel at the respective area of interest.

1. Allows users to identify area that they want to contrast to see the median dwell time spent
2. Allows users to zoom into specific vessels of interest
3. By hovering on the plot, users are able to see the name of the vessel id contributing to this median dwell time at the area of interest.

Area for Improvement

1. Introduce filter to identify vessel by company
2. Introduce option for user to select color for highlighted vessels (Multiple) to contrast
3. Introduce reference line that maps the % increase / decrease for month on month median dwell time changes for all vessels & selected vessels.
4. Introduce data table that returns the vessels and their details for those that are included in the “Highlighted Vessel ID”

• Shiny Plot 9: Route taken by vessels

Purpose & Functionality

Purpose: Helps users zoom into the trajectory of vessels of interest to see the route taken and locations visited sequentially.

1. Allows users to select vessel of interest to plot route taken.
2. Allows users to select vessel of interest to plot dwell time at each area.

Areas for Improvement

1. Include selection of multiple vessels such that users are able to include up to 3 vessels to compare their trajectory.
2. Update the input selection field such that it is filtered by “Vessel Name” for readability and also returns the associated “Vessel Company” for user’s reference.
3. Include a filter on the time frame such that users are able to drill down into specific pocket of time of interest for temporal analysis. (e.g., Before SSEC was caught, immediately after, and months after SSEC was caught for any new suspicious trajectories).

• Shiny Plot 10: Comparison of dwell time by vessel company at the areas visited across time

Purpose & Functionality

Purpose: Help users visualise the changes in dwell time spent by various vessel of the same company over the months at each location.

1. Helps users identify which vessels in the company are active at which location in which months. (e.g., For Bernett, Jones and Millet company, only Perch Plunderer was active in Wrasse Bed, while Brine Bucaneer is active in Cod Table).
2. Comparison with median dwell time helps users identify the cause of long dwell time at each area (e.g., High frequency of short visits or few visits but long stays).

Areas for Improvement

1. Return summary text on the most visited location for each vessel ID for the selected vessel company.
2. Include filter option to allow users to filter and zoom into areas of interest for side-by-side comparison of key regions (e.g., Fishing grounds, Ecological Preserve) that vessel has entered into.

Discussion on how to combine the r Shiny Plots to address the sub-questions

Integrating all the charts above, the sketch below illustrates the possible navigation tabs in our Shiny application.

Menu	Plots and layout
Q1a - Mapping of Cargo Delivered by Vessels	Network graph that links cargo to vessel (Plot 3) Quantity of cargoes received per month (Plot 2)
Q1b - Seasonality of Oceanus Catch	Calendar heat map on the count of cargo at each port over the months, with filter on fish species for the cargo displayed. (Plot 5)
Q2 - Geographical mapping & dwell time	Geographical Map of Vessel Trajectory (Plot 9) Geographical Map of Dwell time in circle with box plot on relative dwell time vis-a-vis other vessels. (Plot 4)
Q3 - Visual analytics workflow to identify other vessels engaging in behaviour similar to SSEC.	This will be based on qualitative assessment by exploring the outputs of interactive visualisations in Q1 & Q2 (e.g., vessel of similar trajectories, prolonged dwell time in Ghoti, Cod Table and Wrasse Beds)
Q4 - Changes in fishing behaviour after SSEC was caught and new suspicious behaviour.	Line graph of dwell time over months and facet over various locations. (Plot 10) Bar chart on the most traveled route by vessels in various months and selected location. (Plot 6)

Action Items:

Action items	Owner(s)	Deadline
Refine the r Shiny Plots and document a “User Guide”	Arya, Jing Yi, Myat	24 June 2024
Combine the r Shiny Plots and introduce links between various plots for coordinated linked view.	Arya, Jing Yi, Myat	24 June 2024
Investigate the possible suspicious behaviours with the r Shiny plots and document down findings in “Observations”	Arya, Jing Yi, Myat	24 June 2024
Summarise the methodology and findings in the poster.	Arya, Jing Yi, Myat	24 June 2024

Agenda for Next Meeting:

1. Review the refined r Shiny plots & test for instance where there is any errors

2. Review the observations and potential finding for concurrence and reasonableness check.