[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:
 Keywords:               |
-------------------------+---------------------------
 Background: https://github.com/OSGeo/gdal/pull/3810 and conversation at
 https://twitter.com/pwramsey/status/1390403943969169408

 How should PostGIS capture the coordinate epoch of geometries referenced
 against a dynamic CRS (that is a non-plate-fixed CRS, such as WGS 84
 (G1762), ITRF2014, etc), for which it is required to store the coordinate
 epoch to have centimer-level precision during coordinate transformation ?

 Potential ideas:
 - add a coordinate_epoch column to geometry_columns / geography_columns
 - add a coordinate_epoch column to spatial_ref_sys
 - add a SRTEXT2 column to spatial_ref_sys that could contain WKT:2019
 content and the COORDINATEMETADATA[] construct of
 http://docs.opengeospatial.org/is/18-010r7/18-010r7.html#130
 - but GeoPackage did something similar as the SRTEXT2 solution
 (http://www.geopackage.org/spec121/#extension_crs_wkt) and are now
 considering just having the column that contains WKT to allow WKT:2019
 (https://github.com/opengeospatial/geopackage/issues/508)
 - add the coordinate epoch in EWKT / EWKB

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