Hi Guys, I've been on this problem for a while and I can't think of a way to make this work. I am no programmer, I have learned what I know on this forum (Thank you all for that). I am recieving NMEA AIS data. I calculate the distance and the bearing from me to the vessel. Now besides displaying…

It is a very clean and a smaller solution to what I had first. It took me some time to figure out I needed a function node infront of the append, to convert my incoming messages. But I got it all working. [{"id":"c7bd3578c3bc7062","type":"link in","z":"f3da98203cbc6de3","name":"To Temp Storage","l…

Influx certainly not the tool to use for this I don't think. The first thing to understand is how many vessels you need to hold data for? Then, how long do you keep the data - or rather, how do you know when you no longer need the data? If the number of vessels is a manageable number (no more tha…

There was a similar post, maybe this may help. [image] UI with selectable AIS ship target list Dashboard Hello, I am trying to create a Dashboard, where I can pick a ship/target from a drop-down list and display it's data... So far I set up a tcp:port where I receive AIS…

I guess it depends if you need just the most recent position for each vessel or historical data. Either way, my instinct would be to use a "proper" SQL database such as Mariadb. Create a VESSEL record whenever a new vessel enters your area of interest, and a VESSEL_LOCATION record whenever you rece…

Glad it helped. If the data grows to big you could do similar in a db, just update existing entries rather than insert if the mmsi already exists

I got a question. The AIS messages have "Message Types" 1 - 27. If an array comes in with mmsi, lon, lat, sog and later another comes in with the mmsi, lon, lat, cog, name Is everything overwritten (example sog is removed), or only the ones that change or added?

I think every thing is overwritten, The original AIS post all the info was delivered in one go. You could merge the incoming object with the stored object and then append it, to preserve all the data.

Node-RED

Node-RED Forum

How to store & update NMEA-AIS data?

General

E1cid 26 November 2021 19:33 3

There was a similar post, maybe this may help.

Topic		Replies	Views
UI with selectable AIS ship target list Dashboard	31	1514	15 June 2021
Store data on a database General	17	10788	13 March 2020
Storing of data, CSV, Sqlite? General	6	2474	9 September 2018
Store data in InfluxDB show in Chronograf General database	33	1025	27 July 2022
Save values on a table / multidimensional array General	11	2639	17 December 2018

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How to store & update NMEA-AIS data?

Related topics