ST_eventTimes

Syntax

timestamp[] ST_eventTimes(trajectory traj)

Parameters

Example

The following example constructs a trajectory with two events and retrieves their timestamps. The events array maps each event index to its timestamp — ST_eventTimes returns these timestamps as an array.

WITH traj AS (
  SELECT '{
    "trajectory": {
      "version": 1,
      "type": "STPOINT",
      "leafcount": 2,
      "start_time": "2010-01-01 11:30:00",
      "end_time": "2010-01-01 12:30:00",
      "spatial": "SRID=4326;LINESTRING(1 1,3 5)",
      "timeline": ["2010-01-01 11:30:00", "2010-01-01 12:30:00"],
      "attributes": {
        "leafcount": 2,
        "velocity": {"type": "integer", "length": 4, "nullable": true, "value": [1, null]},
        "speed":    {"type": "float",   "length": 8, "nullable": true, "value": [null, 1.0]},
        "angle":    {"type": "string",  "length": 64,"nullable": true, "value": ["test", null]},
        "tngel2":   {"type": "timestamp","length": 8,"nullable": true, "value": ["2010-01-01 12:30:00", null]},
        "bearing":  {"type": "bool",    "length": 1, "nullable": true, "value": [null, true]}
      },
      "events": [
        {"1": "Fri Jan 01 14:30:00 2010"},
        {"2": "Fri Jan 01 14:30:00 2010"}
      ]
    }
  }'::trajectory a
)
SELECT ST_eventTimes(a) FROM traj;

Output:

              st_eventtimes
---------------------------------------------
 {"2010-01-01 14:30:00","2010-01-01 14:30:00"}
(1 row)