mew-nsc commented 3 years ago

🐞 Overview

We've received the attached CSV file detailing three track updates generated by an aircraft. Tracks_UC.csv

This task is to review the format provided and identify an approach to import into Pepys.

Some initial thoughts that are likely to require MWC confirmation (but would appreciate thoughts first):

Remote looks like it might be a boolean field (but could be a count)
ClassfType probably maps onto a value - enum (unclear what possible values if so)
Classf looks like it might be a boolean field
Subclass probably maps onto a value - enum (unclear what possible values if so)
RecognitionTyp format is unclear (some binary format?)

Related: #933

🔗 Feature

IanMayo commented 3 years ago

Date(Uk)	Time(Z)	NoTrks	PreFix-SysTrkNo	Lat(degN)	Long(degE)	Course(rad)	Spd(m/s)	Id	ClassfType	Classf	SubClass	RecognitionTyp	tov(DD:HH:MM:SS)
21/05/2020	10:22:00	3	M0065	58.68575	22.29	0	64	36	7	1	9	J 000	31:00:00:00
21/05/2020	10:22:00	3	M0001	54.41647	18.88333	0	0	0	0	0	0	000	31:00:00:00
21/05/2020	10:22:00	3	M0888	50.3166	28.17778	2.05708	64	69	5	1	8	??000	31:00:00:00

Name	Sample 1	Sample 2	Sample 3	Exploit	Meaning	Units	Processing	Target-Table	Target-Field
Date(Uk)	21/05/2020	21/05/2020	21/05/2020	✓	Date	n/a	Combine date/time	Contacts	time
Time(Z)	10:22:00	10:22:00	10:22:00	✓	Time	n/a	Combine date/time	Contacts	time
NoTrks	3	3	3
NoFeeds	0	0	0
PreFix-SysTrkNo	M0065	M0001	M0888	✓	Track number	n/a	n/a	Contacts	trackNumber
FTN	0	0	0
Remote	0	0	0
Lat(degN)	58.68575	54.41647	50.3166	✓	Lat	Degs	Combine Lat/Long	Contacts	location
Long(degE)	22.29	18.88333	28.17778	✓	Long	Degs	Combine Lat/Long	Contacts	location
Course(rad)	0	0	2.05708	✓	Tgt Course	Rads	nil	Contacts	course
Spd(m/s)	64	0	64	✓	Tgt Speed	m/sec	nil	Contacts	speed
Id	36	0	69
ClassfType	7	0	5
Classf	1	0	1
SubClass	9	0	8
RecognitionTyp	J 000	0	??000
tov(DD:HH:MM:SS)	31:00:00:00	31:00:00:00	31:00:00:00

IanMayo commented 2 years ago

Closed in #971