Determine Incident Proximity to Surface Water

[stdavis]

From client:

When a spill location is created or updated for an incident, the map widget should automatically find the nearest waterbody (using NHD data from SGID within a reasonable distance) and update Salesforce fields with the waterbody name and distance.

This could possibly be accomplished by querying the relevant NHD data within the search radius and then looping through each returned geometry to find the one that is closest.

Clarifications from Sarah:
Reasonable distance is 1 mile.

Here are the layers that they want searched:
https://opendata.gis.utah.gov/datasets/utah::utah-major-streams-statewide/about
https://opendata.gis.utah.gov/datasets/utah::utah-major-rivers-polygons/about

Tasks

• Determine which NHD layers, specifically, they would like searched (submitted this question to Sarah on 10/15)
• Determine what a "reasonable distance" is
• Determine what salesforce field should hold this data
• Create a trigger for any time a spill location is created or updated
• Query NDH layer(s)
• Write value to Salesforce

[steveoh]

I've used this before with postgis to find the closest record.

https://github.com/steveoh/Presentations/blob/6d5236441a1d6ff3e2ef034ea8bb404fb55327d7/2020/DowntownCodingSLC/2-command-line-with-parameters/main.py#L56-L61

[stdavis]

Could we use that with a feature service or would we have to query open sgid?

[steveoh]

I think that operator is only available in pg directly.

[stdavis]

Maybe this is already supported via the web api.