This repository is for Nature Forward to convert their Salesforce data into usable data for ArcGis.
Old Map: https://natureforward.my.salesforce-sites.com/enterWQMSession/displaymapmostrecentwqm
Note: Do NOT save the notebooks after running. If this pop-up displays after running a notebook, click LEAVE.
After running a notebook, you can check the Modified column on the ArcGIS Online Content page, to see if the notebooks updated to today's date.
Quick Links:
Updating Sites Feature Layer
Updating Critters Table
Updating IBI Scores Table
This report only needs to be run when a new site is added or site details are changed (coordinates, name, etc).
Navigate to the Reports tab on Salesforce. Under the LimnoTech folder there is a report titled LimnoTech Sites.
Click Run Report and then click Export Details.
Change to the following export settings and then click Export.
- Export File Encoding =
Unicode (UTF-8) - Export File Format =
Comma Delimited .csv
Your file will then download to your browser. The file name will be similar to report1719589800854.csv, but with different numbers.
Under the Notebook tab in ArcGIS online, open the Update Sites FeatureLayer notebook.
Click on cell with code (Cell 2) and then click Run. While the cell is running, it will have this symbol In [*], once finished it will change to In [1].
Scroll to the bottom of the notebook and click the Upload button. Upload the report you downloaded in Step 1, then click Update Layer.
A progress bar will appear and update while the code is running. The layer is successfully updated when the progress bar reaches 100% and Sites layer updated is displayed.
This notebook should be run every time a map refresh occurs along with the IBI Scores Notebook.
Navigate to the Reports tab on Salesforce. Under the LimnoTech folder there is a report titled LimnoTech Session/Critter.
In the Time Frame box, change the From date to 3 years prior (ex: 1/1/2022 -> 1/1/2019). This change will capture the last 5 years of critter data.
Click Run Report and then click Export Details.
Change to the following export settings and then click Export.
- Export File Encoding =
Unicode (UTF-8) - Export File Format =
Comma Delimited .csv
Your file will then download to your browser. The file name will be similar to report1719589800854.csv, but with different numbers.
Under the Notebook tab in ArcGIS online, open the Update Critters Table notebook.
Click on the cell with code (Cell 2) and then click Run. While the cell is running, it will have this symbol In [*], once finished it will change to In [1].
Scroll to the bottom of the notebook and click the Upload button. Upload the report you downloaded in Step 1, then click Update Table.
A progress bar will appear and update while the code is running. The layer is successfully updated when the progress bar reaches 100% and Critters table updated is displayed.
This notebook should be run every time a map refresh occurs along with the Critters Notebook.
Navigate back to the Reports tab on Salesforce. Under the LimnoTech folder there is a report titled LimnoTech IBI Over Time.
Click Run Report and then click Export Details.
Change to the following export settings and then click Export.
- Export File Encoding =
Unicode (UTF-8) - Export File Format =
Comma Delimited .csv
Your file will then download to your browser. The file name will be similar to report1719589800854.csv, but with different numbers.
Under the Notebook tab in ArcGIS online, open the Update IBI Scores Table notebook.
Click on the cell with code (Cell 2) and then click Run. While the cell is running, it will have this symbol In [*], once finished it will change to In [1].
Scroll to the bottom of the notebook and click the Upload button. Upload the report you downloaded in Step 1, then click Update Table.
A progress bar will appear and update while the code is running. The layer is successfully updated when the progress bar reaches 100% and IBI Scores table updated is displayed.
