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

[PostGIS]

#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:                |  
--------------------------+-------------------------------------------------
 I have a base_table with a bunch of geographies and each geography has an
 attributes associated with it.

 I have a reference table which just contains a single point geography
 (lat/long)

 When I render these two on quantum gis I clearly see the point inside a
 layer along with its attributes. However, when I try to use the
 ST_Intersects function in postgis on these geographies I don't get
 anything back. This query works for most of our lat-longs but I have a
 handful of cases where this behavior is observed. I am not sure why this
 is happening?

 I have attached the quantum gis screenshot for the two geographies and
 below is the query that I used:

 SELECT value
 from base_table bt, san_ref_point srp
 where ST_Intersects(bt.geog, srp.geog)

 If it helps these are the coordinates for the point:(-122.15023 37.905731)

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