I have overlapping WO points in Spatial 7.6.1.

Is there a way to cluster points in maps so that users can tell that there are multiple points at a given position?

Thank you.


#MaximoSpatial
#AssetandFacilitiesManagement
#Maximo

Something like this might work:

1. Create a spatial view in GIS on the WO feature class to highlight WOs with duplicate coordinates.
2. Register the view with the geodatabase.
3. Serve it up to the Maximo map.
4. Use it to show WOs that overlap.

create or replace view wo_overlap_vw as (
select
    cast(min(objectid) as number(38,0)) as min_objectid,
    longitudex,
    latitudey,
    count(1) as count,
    min(shape) as min_shape
from
    wo
group by
    longitudex,
    latitudey
having
    count(1) > 1
)

For those that don't have X and Y columns like I do, using spatial functions in the view to get the X and Y from the SHAPE column should work. Or use a trigger to insert the X and Y into columns in the feature class.