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

Name Definition Type
tag_id*

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

Example: 18LX

string
sensor*

Sensor type.

Categories
  • light — Light-level values measured by a solar geolocator. Range and units may vary by provider and tag settings. (same as MVB000139)
  • pressure — Atmospheric pressure in hPa (or mbar). (same as MVB000055)
  • 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. (same as MVB000114)
  • 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_internal — Temperature measured by the tag sensor located between the tag and the animal (body temperature). Units: degrees Celsius. (same as MVB000256)
  • 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. (same as MVB000104)
  • acceleration_x — Acceleration measured by the tag along the X axis of the forward-right-down frame. Units: g (standard gravity, 1 g = 9.80665 m/s^2). (same as MVB000006)
  • acceleration_y — Acceleration measured by the tag along the Y axis of the forward-right-down frame. Units: g (standard gravity, 1 g = 9.80665 m/s^2). (same as MVB000007)
  • acceleration_z — Acceleration measured by the tag along the Z axis of the forward-right-down frame. Units: g (standard gravity, 1 g = 9.80665 m/s^2). (same as MVB000008)
  • magnetic_x — Magnetic field strength measured by the magnetometer along the X axis of the forward-right-down frame. Units: gauss (1 G = 100 microtesla). (same as MVB000258)
  • magnetic_y — Magnetic field strength measured by the magnetometer along the Y axis of the forward-right-down frame. Units: gauss (1 G = 100 microtesla). (same as MVB000259)
  • magnetic_z — Magnetic field strength measured by the magnetometer along the Z axis of the forward-right-down frame. Units: gauss (1 G = 100 microtesla). (same as MVB000260)
  • wet_count — Wet count during a measurement interval from the wet-dry sensor. Units are usually device-specific. (same as MVB000213)
  • conductivity — Conductivity measured by the wet-dry sensor. Unit varies by model. (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

Table rules

  • Foreign key: tag_id → tags.tag_id
  • Missing values: an empty cell, NA.
  • Columns: optional columns listed above may be omitted. Additional columns are not allowed.
  • Required columns: those marked * must be present and must hold a value in every row.