20260910 10243100 1.0 TRUE 20260914 093156 150000000 5000 ItemDescription withheld

<DIV STYLE="text-align:Left;"><DIV><DIV>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.py<UL><LI>Coordinates the end-to-end NRIP refresh process</LI><LI>Launches the Salesforce extraction console application</LI><LI>Validates and stages the generated data extract</LI><LI>Creates required workspace resources</LI><LI>Invokes the GIS normalization process</LI><LI>Loads metadata templates for normalized geodatabase and datasets</LI><LI>Handles workflow status reporting, error handling, and logging</LI></UL>data_normalization.py<UL><LI>Transforms the staged Salesforce extract into the NRIP normalized GIS data model</LI><LI>Creates and refreshes the following datasets:<UL><LI>SUBMISSIONS<UL><LI>Non-spatial table</LI><LI>One record per unique Submission_Record_ID</LI></UL></LI><LI>SITES<UL><LI>Spatial point feature class</LI><LI>One record per unique Site_Record_ID</LI><LI>Geometry stored in Web Mercator</LI></UL></LI><LI>SUBMISSION_SITE<UL><LI>Junction table</LI><LI>Links submissions to sites</LI><LI>Supports many-to-many relationships</LI></UL></LI></UL></LI></UL>metadata.py<UL><LI>Since NRIP_Data.gdb is re-created during each execution of NRIPController, metadata must be reapplied.</LI><LI>Grabs XML templates from reference directory and applies matching metadata to dataset</LI></UL></DIV></DIV></DIV>

<DIV STYLE="text-align:Left;"><DIV><DIV>Run this tool to refresh the NRIP_BOT GIS datasets (i.e. NRIP_Data.gd) from the latest Salesforce source data. The tool is executed on a scheduled nightly basis, or on-demand through the Geocortex viewer application (NRIP Back Office Tool).</DIV></DIV></DIV> NRIP Controller NRIP NRIP_BOT Back Office Tool Salesforce ETL ArcToolbox Tool 20260910