Need Help Storing Complete AIS Data in a Database

[Parabellum123]

Hello everyone,

I am currently working on a project involving the collection of AIS (Automatic Identification System) data using a receiver and storing it in a PostgreSQL database. The data I receive includes various information about ships, such as MMSI, location, speed, and more.

The problem I’m facing is that currently, only the last information received from each ship (based on MMSI) is stored in the database. I want every signal received, even if it’s from the same ship within a short time span, to be stored as a new entry in the database. The goal is to ensure that I have a complete record of all the data received, including multiple signals from the same ship within close time intervals.

Could anyone advise on what changes I need to make, either in my Python code or in the PostgreSQL database configuration, to allow this?

Thank you for your help!

my postgresql

i want like this

[jvde-github]

Hello!

If you are using the built-in PSQL functionality (i.e. with the -D) you can use 'VP on` which essentially populates the table ais_vessel_pos with lat/lon with some additional fields including timestamp, mmsi and speed.

If you want to use a custom script in Python, then you need to read in NMEA lines (the messages) (e.g. by implementing a UDP listener), decoding them in python (e.g. with pyais to get the lat and lon) and then writing this to the table. All together, not rocket science but requires a bit of work.

[jvde-github]

Sorry, the VP on is part of the -D command (it is an option for the database functionality activated with -D). So these options need to be after the -D but before the next "-"

Hence,

-D postgressql://.... VP on

Also, -V -> -v. Does that help?

[jvde-github]

So, I suspect that at the end of the "-D" line in your python, you add: ,"VP on" as an extra argument

[jvde-github]

well, probably add it as: ,"VP","ON"

[Parabellum123]

OMG It work, thank you very much

[jvde-github]

Have fun with it and thanks for sharing feed.