Spatial Solutions Architect and Database Expert
The knowledgeable Bryan Hall made a post over on the Oracle Technology Network’s Oracle Spatial Forum reminding users of the “hidden” issues that inform the way Oracle compare’s two geometries when using a secondary filter Here is the relevant section of the post. With relationship operators such as sdo_anyinteract that take two parameters for theRead More
A colleague wrote to me today asking: I’m looking for a way to improve a query to detect all line geometries which are shorter then 10 mm. … It takes days to check all our lines (full tabel scans on millions of rows); … Can’t I use the domain index to filter out the desiredRead More
A function that have found use in Oracle and PostGIS is one that allows a user to filter out the rings of a polygon or multipolygon based on area. Here is presented a function to do this in SQL Server Spatial. This function requires Denali (2012) as it uses unionAggregate. In addition, the function requiresRead More