AIS visualization TASK - Revision history

Mol: /* Vessel data */

2026-07-02T14:49:20Z

Vessel data

← Older revision		Revision as of 17:49, 2 July 2026
Line 83:		Line 83:

	=== Vessel data ===		=== Vessel data ===

			Create one simple database to include some more static data. However, the name might change but this will not take that into account.

	AIS Type 5 (Ship Static and Voyage Related Data) provides the core vessel identity and voyage information. The data items typically included are:		AIS Type 5 (Ship Static and Voyage Related Data) provides the core vessel identity and voyage information. The data items typically included are:
Line 110:		Line 112:
	shiptype INTEGER,		shiptype INTEGER,
	shiptype_name TEXT,		shiptype_name TEXT,
	~~nav_status TEXT,~~
	~~imo TEXT,~~
	callsign TEXT,		callsign TEXT,
	length REAL,		length REAL,
Line 117:		Line 117:
	gt REAL,		gt REAL,
	nt REAL,		nt REAL,
	~~destination TEXT,~~		draught REAL,
	~~eta TEXT,~~
	~~voyage_id TEXT~~,
	timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,		timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (mmsi)		PRIMARY KEY (mmsi)

Mol: /* Vessel data */

2026-07-02T14:36:33Z

Vessel data

← Older revision		Revision as of 17:36, 2 July 2026
Line 87:		Line 87:
	*MMSI -> mmsi		*MMSI -> mmsi
	*Vessel name -> name (sometimes vessel_name depending on dataset)		*Vessel name -> name (sometimes vessel_name depending on dataset)
	*IMO number -> imo		*IMO number -> imo (The permanent, unchanging identifier for vessels worldwide)
	*Call sign -> callsign (sometimes call_sign)		*Call sign -> callsign (sometimes call_sign)
	*Vessel type (ship type code) -> shiptype (sometimes type_id)		*Vessel type (ship type code) -> shiptype (sometimes type_id)

Mol: /* Vessel data */

2026-07-02T14:07:30Z

Vessel data

← Older revision		Revision as of 17:07, 2 July 2026
Line 104:		Line 104:

	<syntaxhighlight lang="SQL">		<syntaxhighlight lang="SQL">
	CREATE TABLE IF NOT EXISTS vessels(		CREATE TABLE IF NOT EXISTS vessels (
	id INTEGER ~~PRIMARY KEY AUTOINCREMENT~~,		mmsi INTEGER NOT NULL,
	~~vessel_name~~ TEXT ~~NOT NULL~~,		name TEXT,
	~~vessel_type~~ TEXT ~~NOT NULL~~,		flag TEXT,
	length REAL,		shiptype INTEGER,
	~~breadth~~ REAL,		shiptype_name TEXT,
	~~draft~~ REAL,		nav_status TEXT,
	~~tonnage~~ REAL,		imo TEXT,
	~~registration_number~~ TEXT,		callsign TEXT,
	mmsi ~~INTEGER UNIQUE~~		length REAL,
			width REAL,
			gt REAL,
			nt REAL,
			destination TEXT,
			eta TEXT,
			voyage_id TEXT,
			timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
			PRIMARY KEY (mmsi)
	);		);
	</syntaxhighlight>		</syntaxhighlight>

Mol: /* Vessel data */

2026-07-02T14:03:35Z

Vessel data

← Older revision		Revision as of 17:03, 2 July 2026
Line 85:		Line 85:

	AIS Type 5 (Ship Static and Voyage Related Data) provides the core vessel identity and voyage information. The data items typically included are:		AIS Type 5 (Ship Static and Voyage Related Data) provides the core vessel identity and voyage information. The data items typically included are:
	* MMSI (~~Mobile Maritime Service Identity~~) ~~and AIS version~~		*MMSI -> mmsi
	* ~~Vessel name~~		*Vessel name -> name (sometimes vessel_name depending on dataset)
	* Vessel type (ship type code) ~~and, if available, cargo type~~		*IMO number -> imo
	* IMO number (~~where the vessel has one~~)		*Call sign -> callsign (sometimes call_sign)
	* ~~Call sign~~		*Vessel type (ship type code) -> shiptype (sometimes type_id)
	* ~~Dimensions: length~~ overall (LOA) ~~and beam (and sometimes~~ length ~~between perpendiculars)~~		*Cargo type -> cargo_type
	* ~~Ship’s flag (nation) and owner (where available in the data set)~~		*Length overall (LOA) -> length
	* Gross tonnage ~~(GT) and net~~ tonnage ~~(NT)~~		*Beam -> width
	* Destination ~~(voyage~~ destination)		*Gross tonnage -> gt
	* Estimated Time of Arrival (ETA) ~~at destination~~		*Net tonnage -> nt
	* Draft (~~summer draft~~ or ~~latest reported~~ draft)		*Destination -> destination
	* Vessel status or navigational status (~~for example underway using engine, at anchor, etc~~)		*Estimated Time of Arrival (ETA) -> eta
			*Draft -> draught (or draft)
			*Vessel status / navigational status -> nav_status (or navig_status)
			'Flag state (nation) -> flag
			*Owner -> owner
			*Route / voyage number -> voyage_id or voyage (depends on dataset)

	<syntaxhighlight lang="SQL">		<syntaxhighlight lang="SQL">

Mol: /* Vessel data */

2026-07-02T14:01:00Z

Vessel data

← Older revision		Revision as of 17:01, 2 July 2026
Line 83:		Line 83:

	=== Vessel data ===		=== Vessel data ===

			AIS Type 5 (Ship Static and Voyage Related Data) provides the core vessel identity and voyage information. The data items typically included are:
			* MMSI (Mobile Maritime Service Identity) and AIS version
			* Vessel name
			* Vessel type (ship type code) and, if available, cargo type
			* IMO number (where the vessel has one)
			* Call sign
			* Dimensions: length overall (LOA) and beam (and sometimes length between perpendiculars)
			* Ship’s flag (nation) and owner (where available in the data set)
			* Gross tonnage (GT) and net tonnage (NT)
			* Destination (voyage destination)
			* Estimated Time of Arrival (ETA) at destination
			* Draft (summer draft or latest reported draft)
			* Vessel status or navigational status (for example underway using engine, at anchor, etc)

	<syntaxhighlight lang="SQL">		<syntaxhighlight lang="SQL">

Mol: /* rtl_ais */

2026-07-02T13:58:41Z

rtl_ais

← Older revision		Revision as of 16:58, 2 July 2026
Line 62:		Line 62:
	Sqlite3 database		Sqlite3 database

	<syntaxhighlight lang="C">		<syntaxhighlight lang="SQL">
	CREATE TABLE ais_data (		CREATE TABLE ais_data (
	id INTEGER PRIMARY KEY AUTOINCREMENT,		id INTEGER PRIMARY KEY AUTOINCREMENT,

Mol: /* rtl_ais */

2026-07-02T13:58:28Z

rtl_ais

← Older revision		Revision as of 16:58, 2 July 2026
Line 81:		Line 81:

	The following code [[AIS Save to database using Python]] will save the data.		The following code [[AIS Save to database using Python]] will save the data.

			=== Vessel data ===

			<syntaxhighlight lang="SQL">
			CREATE TABLE IF NOT EXISTS vessels(
			id INTEGER PRIMARY KEY AUTOINCREMENT,
			vessel_name TEXT NOT NULL,
			vessel_type TEXT NOT NULL,
			length REAL,
			breadth REAL,
			draft REAL,
			tonnage REAL,
			registration_number TEXT,
			mmsi INTEGER UNIQUE
			);
			</syntaxhighlight>

	== Transform ==		== Transform ==

Mol: /* AIS Data format */

2026-06-30T17:14:56Z

AIS Data format

← Older revision		Revision as of 20:14, 30 June 2026
Line 31:		Line 31:
	AISSentence<!AIVDM,1,1,,A,402`m?1vaT36WQieB8R3TQ?02L5V,0*53>		AISSentence<!AIVDM,1,1,,A,402`m?1vaT36WQieB8R3TQ?02L5V,0*53>
	</syntaxhighlight>		</syntaxhighlight>
	so there are extra texts, like <code>AISSentence<</code> which needs to be removed. The multipart message is partly combined already. The cleaned AIS data looks like:		so there are extra texts, like <code>AISSentence<</code> which needs to be removed. The multipart message is partly combined already. The first 1 or 2 describe how many parts the message is divided into, A and B describe the channel, and the last part is the message.

			The cleaned AIS data looks like:
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	!AIVDM,1,1,,A,147MT`00011i6jpR1JV@97nj0D1v,0*1E		!AIVDM,1,1,,A,147MT`00011i6jpR1JV@97nj0D1v,0*1E

Mol: /* AIS Data format */

2026-06-30T17:12:57Z

AIS Data format

Mol: /* AIS Data format */

2026-06-30T17:12:27Z

AIS Data format

@@ Line 32: / Line 32: @@
 </syntaxhighlight>
 so there are extra texts, like <code>AISSentence<</code> which needs to be removed. The multipart message is partly combined already. The cleaned AIS data looks like:
+<syntaxhighlight lang="bash">
 https://open-ais.org/docs/Data-Architecture/

← Older revision		Revision as of 20:12, 30 June 2026
Line 33:		Line 33:
	so there are extra texts, like <code>AISSentence<</code> which needs to be removed. The multipart message is partly combined already. The cleaned AIS data looks like:		so there are extra texts, like <code>AISSentence<</code> which needs to be removed. The multipart message is partly combined already. The cleaned AIS data looks like:
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	!AIVDM,1,1,,A,147MT`00011i6jpR1JV@97nj0D1v,0*1E>		!AIVDM,1,1,,A,147MT`00011i6jpR1JV@97nj0D1v,0*1E
	!AIVDM,1,1,,A,147>aD0P?w<tSF0l4Q@>4?wp0UrD,0*62>		!AIVDM,1,1,,A,147>aD0P?w<tSF0l4Q@>4?wp0UrD,0*62
	!AIVDM,1,1,,B,347eHF5000QiHiHR0u;ooiFj2000,0*41>		!AIVDM,1,1,,B,347eHF5000QiHiHR0u;ooiFj2000,0*41
	!AIVDM,2,1,3,A,547GF<81AcKHE=`4001@58lt000000000000001J5@c;;uGa0@25CQ2D,0*50		!AIVDM,2,1,3,A,547GF<81AcKHE=`4001@58lt000000000000001J5@c;;uGa0@25CQ2D,0*50
	!AIVDM,2,2,3,A,1@@000000000000,2*26>		!AIVDM,2,2,3,A,1@@000000000000,2*26
	!AIVDM,1,1,,A,147sn80000Qi9N4R1JV=r16n04HH,0*17>		!AIVDM,1,1,,A,147sn80000Qi9N4R1JV=r16n04HH,0*17
	!AIVDM,2,1,4,B,5482L002;29tE<iR221HDM@TpB2222222222220`1P>3540003l0E0DQ,0*35		!AIVDM,2,1,4,B,5482L002;29tE<iR221HDM@TpB2222222222220`1P>3540003l0E0DQ,0*35
	!AIVDM,2,2,4,B,BO@AAkPH8888880,2*1D>		!AIVDM,2,2,4,B,BO@AAkPH8888880,2*1D
	!AIVDM,1,1,,B,1480bf0P001i5A`R1IRP>gvt0d1t,0*62>		!AIVDM,1,1,,B,1480bf0P001i5A`R1IRP>gvt0d1t,0*62
	!AIVDM,1,1,,B,33ni`v5P00Qi5BpR1I1@6wwj0000,0*69>		!AIVDM,1,1,,B,33ni`v5P00Qi5BpR1I1@6wwj0000,0*69
	!AIVDM,1,1,,A,402`m?1vaT36WQieB8R3TQ?02L5V,0*53>		!AIVDM,1,1,,A,402`m?1vaT36WQieB8R3TQ?02L5V,0*53
	</syntaxhighlight>		</syntaxhighlight>