I have an SDE.ST_GEOEMTRY point feature class.
I want to create an SQL query from the points. The query would perform a spatial join/intersection with an SDE.ST_GEOMETRY polygon feature class. An attribute would be returned from the polygon that the points intersect.
- The polygons don't overlap, so a point would never intersect multiple polygons.
- The query would be output to a static table on a schedule. So performance is not a major concern.
Is there a way to do this with SDE.ST_GEOMETRY functions? I've looked at the function list, but I don't see any spatial operations that return an attribute.