[postgis-tickets] [PostGIS] #2422: geography regression difference

PostGIS trac at osgeo.org
Sun Aug 11 19:25:20 PDT 2013


#2422: geography regression difference
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  2.1.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Let me try that once more -- my memory buffer is giving me problems:


 {{{
 SELECT COUNT(*) FROM face
 WHERE _ST_DWithin(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography, 1609.344,true );

 }}}


 yields this:


 {{{
 count
 -------
    395
 (1 row)


 Time: 110076.840 ms
 }}}

 thus conclusion _ST_DWithin(geography, geography,dist, use_sphere)  has
 got some issues.

 I vaguely remember having this issue with geometry _ST_DWithin/ST_Distance
 you fixed.  I'll try to dig up the ticket for that one.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2422#comment:8>
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