I have workorder points in a SDE.ST_GEOMETRY feature class (Oracle 18c/10.7.1. geodatabase).

I serve up the point feature class to an external system via a Map Service.


The workorder points in the feature class often overlap. So, in the external system, users are having issues where they don't realize there are multiple points at a given position.

To solve this issue, I want to create a trigger in the feature class that would automatically move features as they are created. The trigger would reposition a point so that it does not overlap with other points (possibly into a cluster pattern).

What would it take to do this?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.