I have these two SQL Server 2008 R2 queries:
SELECT COUNT(*) FROM OIS_NOA_Buffers WHERE geog.STIntersects(geography:
oint(35.25934, -120.64432, 4326))=1;SELECT COUNT(*) FROM OIS_NOA_Buffers WHERE geom.STIntersects(geometry:oint(35.25934, -120.64432, 4326))=1;The first returns a 1 and the second a 0. Both geog and geom are SRID 4326.
Geog geometry was derived from Set geog = Geom.STAsText()
Why wouldn't they both return 1? (The point is under the polygons.)
أكثر...
SELECT COUNT(*) FROM OIS_NOA_Buffers WHERE geog.STIntersects(geography:
oint(35.25934, -120.64432, 4326))=1;SELECT COUNT(*) FROM OIS_NOA_Buffers WHERE geom.STIntersects(geometry:oint(35.25934, -120.64432, 4326))=1;The first returns a 1 and the second a 0. Both geog and geom are SRID 4326.Geog geometry was derived from Set geog = Geom.STAsText()
Why wouldn't they both return 1? (The point is under the polygons.)
أكثر...