kissmygritts

WITH points AS (
  SELECT 
    ST_SetSRID(ST_Point(-118.9205, 39.5590), 4326) AS geom
)

SELECT 
  points.geom,
  hunt_units_stagin.huntunit
FROM points
  INNER JOIN hunt_units_stagin ON ST_Contains(hunt_units_stagin.geom, points.geom);

kissmygritts

-- number of rows for device 19751 = 1833
SELECT count(*)
FROM gps
WHERE serial_num = '19751';

-- count of rows with join = 1833
WITH relocs AS (
  SELECT
    gps.id AS gps_id,
    deployments.device_id,

kissmygritts

kissmygritts

kissmygritts

kissmygritts

kissmygritts

kissmygritts

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

kissmygritts

var rq = {
		"mark_type": [
			"Ear Tag",
			"Ear Tag",
			"Pit Tag"
		],
		"mark_id": [
			"123",
			"567",
			"12348981723"

kissmygritts

[
  {
    "CommonName": "Cooper's hawk",
    "SpeciesName": "Accipiter cooperii"
  },
  {
    "CommonName": "northern goshawk",
    "SpeciesName": "Accipiter gentilis"
  },
  {