Determine Incident Proximity to Surface Water

stdavis commented 1 week ago

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.

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 commented 1 week ago

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 commented 1 week ago

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

steveoh commented 1 week ago

I think that operator is only available in pg directly.

stdavis commented 2 days ago

Maybe this is already supported via the web api.

agrc / deq-spills

Determine Incident Proximity to Surface Water #127

Tasks