[BACKEND] create_update_segments_excursions: filter segments with average_speed over > XX knots

[marthevienne]

Discuss max speed

[marthevienne]

Exemple de vitesse aberrante pour le vessel n°79 :

average_speed	start_position	timestamp_start	timestamp_end
1 064,6555770521	POINT (-74.46243333 -22.69915667)	2024-05-10 00:29:56.430 +0200	2024-05-10 00:30:28.000 +0200
604,1670653088	POINT (-74.42964667 -24.41214833)	2024-06-19 00:35:52.444 +0200	2024-06-19 00:36:48.000 +0200

@rv2931
=> Explication : positions communiquées dans le mauvais ordre ?

[marthevienne]

Autre cas :
9 miles (non marins...) en 2 secondes mais explication plus difficile à discerner. Voir avec Lilian.

[marthevienne]

J'ai regardé les données brutes et les vessel positions pour y comprendre quelque chose mais je n'y comprends rien : les vitesses n'ont rien à voir entre les deux. Et la position du 16/11/2024 18:22:57 UTC n'existe pas !

spire_ais_data :

id	spire_update_statement	vessel_ais_class	vessel_flag	vessel_name	vessel_callsign	vessel_timestamp	vessel_update_timestamp	vessel_ship_type	vessel_sub_ship_type	vessel_mmsi	vessel_imo	vessel_width	vessel_length	position_accuracy	position_collection_type	position_course	position_heading	position_latitude	position_longitude	position_maneuver	position_navigational_status	position_rot	position_speed	position_timestamp	position_update_timestamp	voyage_destination	voyage_draught	voyage_eta	voyage_timestamp	voyage_update_timestamp	created_at
29 236 884	2024-11-16 16:31:08.374 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	291	297	58,96564333	-7,08405833	NOT_AVAILABLE	UNDER_WAY_SAILING	0	5,6	2024-11-16 16:00:05.054 +0100	2024-11-16 16:31:08.374 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 16:45:02.278 +0100
29 238 343	2024-11-16 16:31:08.374 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	291	297	58,96564333	-7,08405833	NOT_AVAILABLE	UNDER_WAY_SAILING	0	5,6	2024-11-16 16:00:05.054 +0100	2024-11-16 16:31:08.374 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 17:00:03.047 +0100
29 239 803	2024-11-16 17:09:06.469 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	297	298	58,97833333	-7,145	NOT_AVAILABLE	UNDER_WAY_SAILING	0	6	2024-11-16 16:22:59.000 +0100	2024-11-16 17:09:06.469 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 17:15:03.003 +0100
29 241 263	2024-11-16 17:27:03.012 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	304	298	58,99	-7,19666667	NOT_AVAILABLE	UNDER_WAY_SAILING	0	6	2024-11-16 16:41:02.000 +0100	2024-11-16 17:27:03.012 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 17:30:02.605 +0100
29 242 723	2024-11-16 17:27:03.012 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	304	298	58,99	-7,19666667	NOT_AVAILABLE	UNDER_WAY_SAILING	0	6	2024-11-16 16:41:02.000 +0100	2024-11-16 17:27:03.012 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 17:45:02.467 +0100
29 244 183	2024-11-16 17:48:03.477 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	287	298	59,00333333	-7,25833333	NOT_AVAILABLE	UNDER_WAY_SAILING	0	5	2024-11-16 17:02:00.000 +0100	2024-11-16 17:48:03.477 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 18:00:03.234 +0100
29 245 643	2024-11-16 18:14:04.367 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	286,9	296	59,01963	-7,328665	NOT_AVAILABLE	UNDER_WAY_SAILING	0	5,5	2024-11-16 17:28:17.000 +0100	2024-11-16 18:14:04.367 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 18:15:03.144 +0100
29 247 103	2024-11-16 18:26:59.052 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	299	296	59,02833333	-7,36333333	NOT_AVAILABLE	UNDER_WAY_SAILING	0	5	2024-11-16 17:41:00.000 +0100	2024-11-16 18:26:59.052 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 18:30:03.333 +0100
29 248 563	2024-11-16 18:26:59.052 +0100	A	PL	ANNELIES ILENA	SPG4839	2024-11-15 10:54:59.000 +0100	2024-11-15 10:55:08.560 +0100	FISHING	FISHING	261 084 090	9 204 556	24	145	LOW	SATELLITE	299	296	59,02833333	-7,36333333	NOT_AVAILABLE	UNDER_WAY_SAILING	0	5	2024-11-16 17:41:00.000 +0100	2024-11-16 18:26:59.052 +0100	IJMUIDEN	7	2024-11-10 18:00:00.000 +0100	2024-11-15 05:01:00.000 +0100	2024-11-15 05:01:07.527 +0100	2024-11-16 18:45:03.161 +0100

vessel_positions :

id	timestamp	accuracy	collection_type	course	heading	position	latitude	longitude	maneuver	navigational_status	rot	speed	vessel_id	created_at
24 157 891	2024-11-16 16:00:05.054 +0100	LOW	SATELLITE	291	297	POINT (-7.08405833 58.96564333)	58,96564333	-7,08405833	NOT_AVAILABLE	UNDER_WAY_SAILING	0	981,7257182162	79	2024-11-18 09:47:21.601 +0100
24 158 976	2024-11-16 16:00:05.054 +0100	LOW	SATELLITE	291	297	POINT (-7.08405833 58.96564333)	58,96564333	-7,08405833	NOT_AVAILABLE	UNDER_WAY_SAILING	0	981,7257182162	79	2024-11-18 09:47:21.601 +0100
24 160 063	2024-11-16 16:22:59.000 +0100	LOW	SATELLITE	297	298	POINT (-7.145 58.97833333)	58,97833333	-7,145	NOT_AVAILABLE	UNDER_WAY_SAILING	0	480,3090297299	79	2024-11-18 09:47:21.601 +0100
24 161 147	2024-11-16 16:41:02.000 +0100	LOW	SATELLITE	304	298	POINT (-7.19666667 58.99)	58,99	-7,19666667	NOT_AVAILABLE	UNDER_WAY_SAILING	0	343,5610117625	79	2024-11-18 09:47:21.601 +0100
24 162 231	2024-11-16 16:41:02.000 +0100	LOW	SATELLITE	304	298	POINT (-7.19666667 58.99)	58,99	-7,19666667	NOT_AVAILABLE	UNDER_WAY_SAILING	0	343,5610117625	79	2024-11-18 09:47:21.601 +0100
24 163 317	2024-11-16 17:02:00.000 +0100	LOW	SATELLITE	287	298	POINT (-7.25833333 59.00333333)	59,00333333	-7,25833333	NOT_AVAILABLE	UNDER_WAY_SAILING	0	258,8594875025	79	2024-11-18 09:47:21.601 +0100
24 164 406	2024-11-16 17:28:17.000 +0100	LOW	SATELLITE	286,9	296	POINT (-7.328665 59.01963)	59,01963	-7,328665	NOT_AVAILABLE	UNDER_WAY_SAILING	0	198,2274422324	79	2024-11-18 09:47:21.601 +0100
24 165 496	2024-11-16 17:41:00.000 +0100	LOW	SATELLITE	299	296	POINT (-7.36333333 59.02833333)	59,02833333	-7,36333333	NOT_AVAILABLE	UNDER_WAY_SAILING	0	178,2446198079	79	2024-11-18 09:47:21.601 +0100
24 166 588	2024-11-16 17:41:00.000 +0100	LOW	SATELLITE	299	296	POINT (-7.36333333 59.02833333)	59,02833333	-7,36333333	NOT_AVAILABLE	UNDER_WAY_SAILING	0	178,2446198079	79	2024-11-18 09:47:21.601 +0100