Team List Script - pjdohertygis/SARCOP GitHub Wiki
This script allows us to update the Team List on all SARCOP layers using the US&R Catalog.
Where to Access Script?
SARGeo Org (Deployment)
Go to Notebooks > Shared Notebooks (if logged in as other than admin_sargeo) > Open
NAPSG Org (Sandbox)
Go to Notebooks > Shared Notebooks (if logged in as other than nsargc_napsg) > Open
How does the script work?
In both instances, the notebook:
- Connects to the US&R Catalog External View
- Connects to the Deployment or Sandbox Master
- Connects to Waypoints, Worksites, Logistics Points, and Tracklogs
- Connects to Structural Hazards Evaluation Form
- Queries, sorts, de-duplicates, and makes a list of de-duplicated Team Names
- Cleans the data: reformats names, updates the LastEditDate, sets the coded value, sorts them alphabetically, updates the JSON
- Prints either a successful result or an error
If successful, you should see 'The layer's definition was updated successfully!" for each layer
How to Run
Run Notebook x2
Select Run > Run All Cells
You must run both the Sandbox Notebook (NAPSG) and the Deployment Notebook (SARGeo)
'Save' Each QC Project
Go to QuickCapture > Open QC project > Click 'Save'
This will push an update to the project. This must be done for both projects!