On-demand geoprocessing

Question

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!

FlorentinoBernalJr · Answer

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.

DavidPike · Answer

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.