AWS 2-8: Global Watershed Delineation Back-end

[rajadain]

Overview

Adds development data for TDX Basins, used for global watershed delineation. This subset is 200 miles around Philadelphia.

This also adds URLs, Views, Tasks, and Calcs to allow for delineation. The actual algorithm uses the nested set index developed in https://github.com/WikiWatershed/global-hydrography/?tab=readme-ov-file#modified-nested-set-index.

Even though this is highly performant, enough to be a synchronous response, we still use the async job workflow for two reasons:

1. To maintain conformity with the rest of the API
2. To log requests in the back-end, so that we have a record of them

Closes #3658

Demo

When the watershed resulting from the default point is loaded in QGIS, it looks like this:

Testing Instructions

• Check out this branch
• Bring up the VMS

  vagrant up

• Load the development subset of TDX Basins data:

  vagrant ssh app -c 'cd /vagrant && ./scripts/aws/setupdb.sh -B'

  • [ ] Ensure it succeeds in a reasonable time
• Go to http://localhost:8000/ and log in (create an account if you don't have one)
• Go to http://localhost:8000/api/docs/
• Exercise the global-watersheds API endpoint, using the default values
• Query the returned job id
  • [ ] Ensure it has a successful result

[rajadain]

Thanks for reviewing! I added some documentation to the global-watershed endpoint in c6231c5. Will merge once green.