Εμπλουτισμός βάσης δεδομένων με AIS μηνύματα και στατιστικά κίνησης λιμένα
Vessel AIS database enrichment and port traffic statistics
KeywordsAIS μηνύματα ; Βάσεις δεδομένων ; Στατιστική ανάλυση ; Automatic Identification Systems (AIS) ; Ναυτιλία ; Πλοία
An interesting field of research in marine information systems, is the management, processing and analysis of the spatiotemporal datasets, which AIS systems provide through their messages. This current thesis deals with the processing, analysis and storage of these data in an appropriately designed database. More specifically, this field of research, is restricted to the AIS messages which are collected from the antenna based at the University of Piraeus. The provided data refer to the four months, from May 2016 to August 2016, and the vessels which are within a radius of 25km from the antenna. The data management is conducted with the aid of PostgreSQL and PostGIS which is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. The analysis and processing of the data starts after the creation of the tables in the database and the data insertion. The data storytelling follows, where various scenarios are created, as far as the vessel traffic in the port of Piraeus is concerned. In these scenarios the data are classified in three categories, which are the static information, the geographical information and the time. According to this classification, the processing of the data and the conclusions drawn concerning the vessel’s traffic in the port of Piraeus, is possible. Last but not least, the visualization of the results, which concerns the scenarios is presented in QGIS followed by the statistical analysis of the data accompanied with the right figures.