measurements.csv

measurements.csv is a tabular data resource from a GeoLocator Data Package containing raw data from sensors on all tags.

Note that data from all sensors and all tags are contained in a single table!

Measurements

Source: measurements-table-schema.json

  • Foreign key: tag_id → tags.tag_id
  • Missing values: an empty cell, NA.
  • Other columns: only the columns listed below are allowed. Any column may be left out.
  • Required columns: those marked * must be present and must hold a value in every row, whatever the rule above allows.
Name Definition Type
tag_id*

Unique identifier of the tag. Foreign key to tags.tag_id.

Example: 18LX

 string
sensor*

Sensor type.

  • light: Light-level values measured by a solar geolocator. Range and units may vary by provider and tag settings.
  • pressure: Atmospheric pressure in hPa (or mbar).
  • activity: Measure of movement performed by the bird, computed from acceleration sensors. Range and computation method may vary by tag provider, model, settings, and placement on the animal. In general, higher values indicate more activity. Typically computed as the cumulative sum of the absolute difference of acceleration along the z-axis. See doi:10.1186/s40462-018-0137-1 (SOI), doi:10.1111/jav.01068 (Lund), and the migratetech report for more details.
  • mean_acceleration_z: Mean acceleration along the z-axis, computed from acceleration sensors. Mainly used by SOI devices. This metric is sometimes used as a proxy for pitch and was named pitch in GeoLocator DP versions earlier than v1.0.
  • temperature_external: Temperature measured by the tag sensor pointing outward from the animal (air temperature). This typically corresponds to the main external temperature sensor. Units: degrees Celsius.
  • temperature_internal: Temperature measured by the tag sensor located between the tag and the animal (body temperature). Units: degrees Celsius.
  • acceleration_x: Raw acceleration values provided by the tag for the X axis. Units: m/s^2.
  • acceleration_y: Raw acceleration values provided by the tag for the Y axis. Units: m/s^2.
  • acceleration_z: Raw acceleration values provided by the tag for the Z axis. Units: m/s^2.
  • magnetic_x: Magnetic field strength measured by the magnetometer for the X axis. Units: microtesla.
  • magnetic_y: Magnetic field strength measured by the magnetometer for the Y axis. Units: microtesla.
  • magnetic_z: Magnetic field strength measured by the magnetometer for the Z axis. Units: microtesla.
  • wet_count: Wet count during a measurement interval from the wet-dry sensor. Units are usually device-specific.
  • conductivity: Conductivity measured by the wet-dry sensor. Unit varies by model.
Categories
  • light — Light (same as MVB000139)
  • pressure — Pressure (same as MVB000055)
  • activity — Activity (same as MVB000114)
  • mean_acceleration_z — Mean acceleration (z-axis)
  • temperature_internal — Internal temperature (same as MVB000256)
  • temperature_external — External temperature (same as MVB000104)
  • acceleration_x — Acceleration (x-axis) (same as MVB000006)
  • acceleration_y — Acceleration (y-axis) (same as MVB000007)
  • acceleration_z — Acceleration (z-axis) (same as MVB000008)
  • magnetic_x — Magnetic field (x-axis) (same as MVB000258)
  • magnetic_y — Magnetic field (y-axis) (same as MVB000259)
  • magnetic_z — Magnetic field (z-axis) (same as MVB000260)
  • wet_count — Wet count (same as MVB000213)
  • conductivity — Conductivity (same as MVB000071)

Example: pressure

 string
datetime*

Date and time of the measurement. Accepts any valid ISO 8601 datetime string, including datetime in local time (YYYY-MM-DDThh:mm), in UTC (YYYY-MM-DDThh:mmZ) or any specific timezone (YYYY-MM-DDThh:mm+hh:mm).

Example: 2020-04-01T22:00:00Z

 datetime
value*

Value of the measurement taken by the sensor.

Example: 12.3

 number
label

Labeling of pressure and acceleration data according to the labeling chapter of the GeoPressureManual.

Constraints
  • pattern: ^(flight|discard|elev_\d+|)$

Example: elev_23

 string