{ "name": "NripController", "displayName": "NRIP Controller", "description": "NRIPControllerVersion: 1.0.1NRIPController executes the NRIP data refresh workflow by orchestrating a series of automated extraction, validation, transformation, and loading (ETL) processes. The tool invokes an external Salesforce extraction console application to retrieve the latest NRIP submission data, validates and stages the resulting data extract, performs GIS data normalization, applies metadata from template XML files, and refreshes the NRIP geodatabase snapshot used by downstream applications and services.The controller manages workflow execution, error handling, and process coordination between the Salesforce extraction component and ArcGIS geoprocessing tools. Execution details and processing results are recorded through system logs to support monitoring, troubleshooting, and operational auditing.The NRIPController workflow is implemented through supporting Python package modules:controller.pyCoordinates the end-to-end NRIP refresh processLaunches the Salesforce extraction console applicationValidates and stages the generated data extractCreates required workspace resourcesInvokes the GIS normalization processLoads metadata templates for normalized geodatabase and datasetsHandles workflow status reporting, error handling, and loggingdata_normalization.pyTransforms the staged Salesforce extract into the NRIP normalized GIS data modelCreates and refreshes the following datasets:SUBMISSIONSNon-spatial tableOne record per unique Submission_Record_IDSITESSpatial point feature classOne record per unique Site_Record_IDGeometry stored in Web MercatorSUBMISSION_SITEJunction tableLinks submissions to sitesSupports many-to-many relationshipsmetadata.pySince NRIP_Data.gdb is re-created during each execution of NRIPController, metadata must be reapplied.Grabs XML templates from reference directory and applies matching metadata to dataset", "category": "", "helpUrl": "https://ws.services.geospatial.gov.on.ca/arcgis1/rest/directories/arcgisoutput/NRIP/NRIP_BOT_GP_GPServer/NRIP_NRIP_BOT_GP/NripController.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "outputSummary", "dataType": "GPString", "displayName": "outputSummary", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": "", "parameterType": "esriGPParameterTypeDerived", "category": "" } ] }