Working together

for a safer world

M&O AIS Solution - Proposal

James Norris

Lloyd's Register

 

19.02.2020

Requirement

M&O, have recently acquired global historical vessel AIS data from Spire and require a service that includes:

  • Data cleansing and Maintenance
  • Hosting Infrastructure
  • Suitable data access methods

 

Current Access requirements:

  • Access by attribute, e.g. IMO, MMSI
  • Cleaned, down-sampled, hourly
  • Area query or polygon shape lookup

Proposed Infrastructure Design

5000 gzipped csv files.

Annually or when new data available

Remove spurious points e.g. on land

 

Partitioned tables on Postgresql database.

or

TImescaleDB (fast performance very expensive)

Timescale DB (optional)

Advanced

User

Standard User

Or

API commands calling geospatial functions to extract data by area, attribute and time frame, downsampled based on requirement.

Access through existing apps e.g. VesMet but potentially create a stripped down standalone tool for data extraction.

With AWS, we can build a scalable environment which incorporate the ability to perform big data analytics machine learning behind the API.

RoadMap

Currently in the process of switching to AWS.

 

Environment has been set up and tested.

 

Transition will commence following approval.

 

Up and running within the next 2 months.

 

AIS data warehouse with API calls within next 3 months.

Maintenance & Costs

Maintenance

- Annual or semi-annual data processing.

- Data backup and restore.

- Monthly server checks/maintenance.

- Prompt Response Times and SLA.

- Additional ad-hoc hours for tweaks/improvements

 

Costs

- AWS RDS - Price varies based on monthly usage/amount stored.

- Initial set up - Up to 4 weeks depending on use cases.

- Hourly rate for monthly maintenance, ad-hoc requests.

Working together

for a safer world

James Norris

Lloyd's Register Survey & GeoEngineering

+44 (0)1225 485800

James.Norris@lr.org

Lloyd’s Register and variants of it are trading names of Lloyd’s Register Group Limited, its subsidiaries and affiliates.
Copyright © Lloyd’s Register. 2016. A member of the Lloyd’s Register group.

M&O AIS Database Solution

By Lloyd's Register

M&O AIS Database Solution

Presentation by James Norris of Lloyd's Register

  • 696