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.
Problem:
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?
