DATA COLUMNS

From Anitra Support
Jump to: navigation, search


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