topic Re: STIntersect returns nothing in Data Management Questions

STIntersect returns nothing

ArnonTsairi — Sun, 12 Dec 2021 00:15:55 GMT

Hi all,
I'm experimenting with spatial queries in SQL Server 2008. Created an SDE DB with GEOMETRY storage type and loaded several feature classes.
I'm trying to select features from a FC intersecting a polygon:

DECLARE @LandUse geometry 
        ='POLYGON ((169394.70008075237 1068417.1000268459 <more coordinates>))'
SELECT SOIL_ID
FROM soils
WHERE Shape.STIntersects(@LandUse)=1

The statement returns no records, although the polygon declared does intersect several features in the soils FC.
What am I doing wrong?
Thanks, Arnon

Re: STIntersect returns nothing

VinceAngelo — Tue, 05 Apr 2011 11:03:37 GMT

Microsoft's documentation states:
This method always returns null if the spatial reference IDs (SRIDs) of the geometry instances do not match.

You didn't show the SRIDs involved, but that's the most likely cause.

- V

Re: STIntersect returns nothing

ArnonTsairi — Tue, 05 Apr 2011 11:18:15 GMT

The SDE_geometry_columns table shows the same SRID for both feature classes (1).
I grabbed the declared polygon by a previous select statement, but in the declaration no SRID explicitly defined. Could that be the problem? Can I specify an SRID?
Thanks!

Re: STIntersect returns nothing

VinceAngelo — Tue, 05 Apr 2011 11:34:29 GMT

The POLYGON constructor accepts an SRID, but the ArcSDE SRID and Microsoft SRID might
be different values. You need to use the Microsoft SRID in the native OGC operators.
The ArcSDE sequence-generated SRID is a link to a row in the spatial reference table,
where the native SRID resides.

- V

Re: STIntersect returns nothing

ArnonTsairi — Wed, 06 Apr 2011 10:18:02 GMT

Thank you Vince, indeed adding the SRID to the declared polygon fixed the problem.