insert telemetry.sql

insertTelemetry.sql

INSERT INTO telemetry (raw_gps_id, animal_id, device_id, acq_time, longitude, latitude)
SELECT
  raw_gps.id AS raw_gps_id,
  deployments.device_id,
  deployments.animal_id,
  raw_gps.acq_time,
  raw_gps.longitude,
  raw_gps.latitude
FROM
  deployments, raw_gps, devices
WHERE
  raw_gps.serial_num = devices.serial_num AND
  devices.id = deployments.device_id AND
    (
      (raw_gps.acq_time >= deployments.inservice AND
       raw_gps.acq_time <= deployments.outservice)
      OR
      (raw_gps.acq_time >= deployments.inservice AND
       deployments.outservice IS NULL)
    );