[postgis-tickets] [PostGIS] #4911: Capturing coordinate epoch in database

[PostGIS]

#4911: Capturing coordinate epoch in database
--------------------------+---------------------------
  Reporter:  rouault      |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 3.1.2
 Component:  postgis      |    Version:
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by mdavis):

 Another option:

 * Store the epoch as a column beside the geometry column.  This could be
 an epoch number, or a Postgres timestamp.  Add an option to the
 `ST_Transform` function to accept an epoch modifier for each CRS.

 This is a low-bar option, which might be a good first step to providing
 more "baked-in" support for epochs.  It also aligns with existing models
 for storing temporal information about spatial data.

 The modification to `ST_Transform` seems like a good idea regardless.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4911#comment:7>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.