json - Maximo/GIS spatial query

Question

I have a work order in Maximo 7.6.1.1:

• The WO has LatitudeY and LongitudeX coordinates in the Service Address tab.
• The WO has a custom zone field.

And there is a feature class (polygons) in a separate GIS database.

---

I want to do spatial query to return an attribute from the polygon record that the WO intersects and use it to populate zone in the WO.

How can I do this?

^{Related keyword: Maximo Spatial}

Answer 1

To do this live in Maximo using an automation script is possible or by writing custom code into Spatial (more challenging). You want to use the /MapServer/identify tool and post the geometry xy, coordinate system, and the layer you want to query. identify window

You will have to format the geometry object correctly and test your post from the window. I usually grab the post from the network section of developer tools once I get it to work and change the output format to json and use it in my code.