[postgis-tickets] [PostGIS] #2162: ST_Intersects yields null where I see a clear intersection on quantum gis

PostGIS trac at osgeo.org
Sun Jan 20 19:33:19 PST 2013


#2162: ST_Intersects yields null where I see a clear intersection on quantum gis
--------------------------+-------------------------------------------------
 Reporter:  sgottipamula  |       Owner:  pramsey      
     Type:  defect        |      Status:  new          
 Priority:  medium        |   Milestone:  PostGIS 1.5.9
Component:  postgis       |     Version:  1.5.X        
 Keywords:                |  
--------------------------+-------------------------------------------------

Comment(by sgottipamula):

 I was actually in process of attaching the script to create a dummy table
 with just that geography record for easy repro. Interestingly, the query
 works fine on this table with just one record.

 Does the number of records in the original table (83924) have anything to
 do with this anomaly? All I did was use st_astext(geog) to extract that
 particular record from base table and use a insert script with
 st_geographyfromtext()

 I've sent you both the script to create this geography if that helps.

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