Ornitela acc data

[peterdesmet]

Ornitela has 2 versions of sensor data: SENSORS and SENSORS_V2:

Here is the comparison

SENSORS (23 cols)	SENSORS_V2 (30 cols)	remark
23 cols	30 cols	-
2749620 records	2750636 records	diff of 1016 ??
device_id	device_id	193969
UTC_datetime	UTC_datetime	2020-07-10 13:24:06
UTC_date	UTC_date	2020-07-10
UTC_time	UTC_time	13:24:06
datatype	datatype	SENSORS vs SEN_ACC_20Hz, SEN_ACC_20Hz_END, SEN_ACC_20Hz_START, SEN_ACC_20Hz_START_END
satcount	satcount	-
U_bat_mV	U_bat_mV	-
bat_soc_pct	bat_soc_pct	-
solar_I_mA	solar_I_mA	-
hdop	hdop	-
Latitude	Latitude	-
Longitude	Longitude	-
Altitude_m	MSL_altitude_m	-
-	Reserved	-
speed_km_h	speed_km/h	-
direction_deg	direction_deg	-
temperature_C	int_temperature_C	-
mag_x	mag_x	-
mag_y	mag_y	-
mag_z	mag_z	-
acc_x	acc_x	-2,023 to 2,023
acc_y	acc_y	-1,970 to 2,015
acc_z	acc_z	-2,033 to 2,047
X23	-	-
-	UTC_timestamp	2020-07-10 13:24:06.050
-	milliseconds	050
-	light	-
-	altimeter_m	-
-	depth_m	-
-	conductivity_mS/cm	-
-	ext_temperature_C	-