topic On-demand geoprocessing in Geoprocessing Questions

On-demand geoprocessing

FlorentinoBernalJr — Wed, 15 Feb 2023 02:07:44 GMT

Hello everyone,

I wanted to check if anyone has had experience running any geoprocessing tool on-demand using Oracle and ArcGIS Pro. So my scenario is this (this is the simplified and most relevant version):

A user enters data (which includes an address component) into a front-facing application
User clicks a "Submit" button
Data ends up going to an Oracle table
Data is supposed to be processed with a geoprocessing tool
Geoprocessing tool then stores the result back into another Oracle table
User is able to see the result within the front-facing application

I already built the geoprocessing tool needed to process the spatial data using a model and can run it manually and it behaves as expected. But my question is, is there a way for the tool to automatically detect new records in the Oracle table in step 3 so that it can run by itself without my direct intervention?

I'm open to ideas and would very much appreciate your input!

Re: On-demand geoprocessing

DavidPike — Wed, 15 Feb 2023 17:26:07 GMT

Look into database 'triggers'. What's the geoprocessing tool doing? If the GP tool functionality can be done using Oracle spatial methods you could just create a database view which would be relatively simpler.

Re: On-demand geoprocessing

FlorentinoBernalJr — Thu, 16 Feb 2023 00:43:39 GMT

Hi David,

The tool calculates different types of district areas in which an address falls, and the 5 nearest service locations for said address. In addition to that, it also performs a join to capture other attributes from a different table before storing the result back into Oracle.