MsSqlSpatial Intersects problem

Topics: Data Access, SharpMap v0.9 / v1.x
Mar 27, 2012 at 10:01 AM

 MsSqlSpatial Intersection uses ST.RelateQuery to do Intersection. But when the geom is Points, the intersection seems not effective. 

I wrote SQL in my Microsoft SQLserver Management Sudio, one:

    SELECT * FROM dbo.AnGeoPoint where ST.[Intersects](the_geom,ST.PointFromText('Point(5 5)',4326)) = 1 

 it can get the right results.

 

the other one :

    SELECT * FROM [ST].[RelateQuery]('AnGeoPoint ', 'the_geom', [ST].[PointFromText]('Point(5 5)',4326), 'Intersects') AS ST_q INNER JOIN [dbo].[AnGeoPoint] AS ST_t ON ST_q.[oid] = ST_t.[oid]

this cannot get any result.

 

does anyone know this problem? Thanks