Return the temporal H3 cell at the given resolution that contains each point in a temporal geodetic or planar point (SRID must be 4326 for the tgeompoint overload)

tgeogpoint_to_th3(tgeogpoint,integer) → th3index

tgeompoint_to_th3(tgeompoint,integer) → th3index

SELECT th3GetResolution(tgeogpoint_to_th3(
  tgeogpoint 'POINT(-73.96 40.78)@2001-01-01', 9));
-- 9@2001-01-01

Return the temporal geodetic centroid of each cell in a trajectory. A planar (SRID 4326) overload is available under the name th3CellToLatlngTgeompoint.

th3CellToLatlng(th3index) → tgeogpoint

th3CellToLatlngTgeompoint(th3index) → tgeompoint

Return the temporal polygon boundary of each cell in a trajectory, as a temporal geography

th3CellToBoundary(th3index) → tgeography