[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 Algunenano):

 I understand that the epoch of a coordinate is a property of the
 coordinate or at most of the geometry, not the whole table (since that can
 have mixed geometries and srid/CRSs) so I wouldn't store it in
 geometry_columns.

 I see 2 options that could complement each other:
 * Have SRIDs with associated epochs, which mean you might get N SRIDs per
 CRS.
 * Have the epoch as part of the geometry metadata/header.

 So if the source or target SRSs require an epoch you would read it from
 the geometry header (if available) or from the SRID (if available). Would
 that make sense?

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4911#comment:1>
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.