[postgis-tickets] [PostGIS] #2953: Unable to compute stats for some features

PostGIS trac at osgeo.org
Thu Oct 2 10:08:03 PDT 2014


#2953: Unable to compute stats for some features
---------------------+------------------------------------------------------
 Reporter:  pramsey  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.1.5
Component:  postgis  |     Version:  2.1.x        
 Keywords:  stats    |  
---------------------+------------------------------------------------------
 It looks like some input data might include extremely small M values as a
 default value

 {{{
  POINT ZM (-124.22007 41.75967 0 -1.79769313486232e+308)
 }}}
 A table of these things will result in the following when ANALYZE is run
 {{{
 NOTICE: no non-null/empty features, unable to compute statistics
 }}}
 The problem is that the large M value is so large that when it's converted
 to a float for storage in gserialized, it actually goes to Inf, so that
 when the box is retrieved from the serialization, the result is this:
 {{{
 (GBOX) $7 = (flags = '\x03',
  xmin = -124.22007751464844, xmax = -124.22006988525391,
  ymin = 41.759666442871094, ymax = 41.759670257568359,
  zmin = 0, zmax = 0,
  mmin = -Inf, mmax = -Inf)
 }}}

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


More information about the postgis-tickets mailing list