Data columns

The data model covered by Anitra is rather wide. It primarilly covers all the data colected by Anitra tags but as Anitra can also host imported data from other sources (including Movenbank data), there are many more columns for this purpose in the data model.

Wherever posible columns of general meaning are used to accomodate sematicaly similar data.

Still, note particular datasets carry only some of the metrics depending on their origin brand/tag (some columns areused by all the tags aut some are used only by some tags).

Following table list the most important metrics with explanations and comments.

column name	datatype	mandatory	sample value	description	note
device_code	text	yes	22155	original tag code or serial number to identify data
timestamp	datetime	yes	2001-01-01 00:00:07.000	UTC time stamp of data (e.g. GPS fix timestamp yyyy-mm-dd hh:mm:ss)
measurement_start	datetime	(yes)	2001-01-01 00:00:01.000		used as a fallback for some imported datasets. E.g. When original data distinguish between measurement start timestamp and GPS fix timestamp the GPS timestamp for records without fix can be empty (e.g. eOBS data structure). measurement_start is transformed into timestamp column while importing data
latitude	decimal		-11.123456	decimal degrees, WGS84 reference system	imported values are rounded to 6 decimal points
longitude	decimal		5.123456789	decimal degrees, WGS84 reference system	imported values are rounded to 6 decimal points
device_type	text	optional	dt_basic	identifies record type and origin of the data	to be used while importing data dt_basic is used automatically when value not provided by user other available values to be used to merge imported data with already existing devices in Anitra: dt_ecotone to append data to devices linked to Ecotone data integration dt_ornitela to append data to devices linked to Ornitela data integration dt_movebank_import to append data to devices plugged to Movebank data flow
acc_raw_x				acceleration axis X raw
acc_raw_y				acceleration axis Y raw
acc_raw_z				acceleration axis Z raw
acceleration_x_ms2				acceleration axis X [ms2]
acceleration_y_ms2				acceleration axis Y [ms2]
acceleration_z_ms2				acceleration axis Z [ms2]
activity_count				Activity	Ecotone data only
angular_velocity_x				raw gyroscope data X (angular velocity)
angular_velocity_y				raw gyroscope data X (angular velocity)
angular_velocity_z				raw gyroscope data X (angular velocity)
baro_altitude_m				Altitude [m] (barometer)	data transformed from Atm.pressure
baro_pressure_hpa'				Atm. Pressure [hPa] (barometer)	uncalibrated
battery_percent				battery level	transformed from battery voltage
battery_voltage_loaded_mv'				Loaded Battery voltage [mV] A detailed battery voltage while under workload	available for Anitra and oObs tags
battery_voltage_mv				Battery voltage [mV]	masks temporary drops in battery due to batery load
cpu_temperature_c				CPU Temperature	only for some tags (from Movebank)
gnss_altitude_elipsoid				Altitude [m] (provided by GNSS module)	above elipsoid
gnss_altitude_msl				Altitude msl [m] (provided by GNSS module)	above the mean see level
gnss_direction_deg'				Direction [deg] (provided by GNSS module)	get stabilised while in the movememnt
gnss_fix_number				number of GPS fixes taken to stabilise position	Anitra functionality, this behavior can be activated in configuration
gnss_fix_type				Fix Quality (0=not fixed, 2=2D, 3=3D)	numeric values 0, 2, 3
gnss_gdop				GDOP	provided for some Movebank records, alternatively calculation GDOP = mag(PDOP+TDOP)
gnss_hdop				HDOP
gnss_pdop				PDOP
gnss_satellite_count				No of tracked satelites (NSAT)
gnss_speed_kmh				Ground Speed [km/h] (provided by GNSS module)	original value or transformed from other speed units (m/s or knots/s)
gnss_speed_ms				Ground Speed [m/s] (provided by GNSS module)	original value or transformed from other speed units (km/h or knots/s)
gnss_time_to_fix				Time to succesful 3D fix [sec]
gnss_time_to_fix_total				total time of GNSS module activity	Anitra functionality, relevant when GPS drift suppressing functionality activated, also shows time spent by unsuccesful fixing attemtps.
gnss_vdop				VDOP
charging_current_ma					Ornitela data only
import_marked_outlier				marks data labelled as outliers imported to Movebnak	for data from Movebank only
light				Light [lx]	only available for some data from Movebank
mag_raw_x				raw magnetometer data X	uncalibrated data
mag_raw_y				raw magnetometer data X	uncalibrated data
mag_raw_z				raw magnetometer data X	uncalibrated data
manually_marked_outlier				a record manualy marked as outlier / wrong GPS	for data from Movebank, transformed to ANitra "wrong GPS" flag
measurement_duration				time needed to create particular record	in most case same as TTF (time to fix),
mortality_onboard				marks records taken while in mortality status	Flag produces by the anique Anitra onboard mortality detection functionality
mw_activity_count				Activity indicator	only for some tags from Movebank
note				Record note/comment	can be added manualy by a user or automaticaly
pitch				Pitch [deg]	from calibrated accelerometer data
roll				Roll [deg]	from calibrated accelerometer data
solar_cell_percent				Solar panel usage percentage	this metric reflects sunshine availability, values over 80% are good to activate battery solar charging efficiently.
temperature_c				Temperature [°C]
transmission_timestamp				Data received timestamp (latest update)	Available only for some tags such as Anitra
wrong_gps				records with missing or wrong Latitude/Longitude information	flagged (1/true) when GPS position is wrong (automatic filtering or user maked outliers)
wrong_time				records with wrong time information (e.g. invalid date format or date in future)	flagged (1/true) when record time is wrong (automatic or user), damaged records = to be excluded from any analyses