(Edit: Part 2 is here.)

I have a script in a Work Order Management System (Maximo) that performs a spatial query.

Part 1: General Cleanup

I have a script in a Work Order Management System (Maximo) that performs a spatial query.

1. Takes the X&Y coordinates of a work order in Maximo
2. Generates a URL from the coordinates (including other spatial query information)
3. Executes the URL via a separate script/library (LIB_HTTPCLIENT)
4. Performs a spatial query in an ESRI REST feature service (in a separate GIS system)
5. JSON text is returned to Maximo with the attributes of the zone that the work order intersected
6. The zone number is parsed from the JSON text via a separate script/library (LIB_PARSE_JSON)
7. Inserts the zone number into the work order record

1. Takes the X&Y coordinates of a work order in Maximo
2. Generates a URL from the coordinates (including other spatial query information)
3. Executes the URL via a separate script/library (LIB_HTTPCLIENT)
4. Performs a spatial query in an ESRI REST feature service (a separate GIS system)
5. JSON text is returned to Maximo with the attributes of the zone that the work order intersected
6. The zone number is parsed from the JSON text via a separate script/library (LIB_PARSE_JSON)
7. Inserts the zone number into the work order record