[PostGIS] #5734: Wrong ST_EstimatedExtent result for geography column

[PostGIS]

#5734: Wrong ST_EstimatedExtent result for geography column
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.4.3
 Component:  postgis  |    Version:  3.4.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by strk):

 So next problem is how to tell, from just reading the stats, whether the
 ND_BOX is geocentric or not, because that seems dependent on whether the
 column being analyzed is of type geography or geometry, but there's no
 such indication in the ND_STATS structure to read, am I right ? Also,
 there doesn't seem to be a Z value for the geodetic ones, isn't that
 mandatory to convert between geocentric and not ?

 {{{
 strk=# select jsonb_pretty(_postgis_stats('qgis_issue_30294_geom',
 'g')::jsonb -> 'extent');
 {
     "max": [
         20.15,
         30.2
     ],
     "min": [
         -10.15,
         -10.2
     ]
 }
 strk=# select jsonb_pretty(_postgis_stats('qgis_issue_30294', 'g')::jsonb
 -> 'extent');
 {
     "max": [
         0.970627,
         0.298534
     ],
     "min": [
         0.813017,
         -0.173346
     ]
 }
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5734#comment:11>
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.