GFT: update wpaa source and logic

[sf-dcp]

Per this comment, logic for wpaa variable needed additional twists. This PR addresses both "todo" bullet points in the comment.

The following has been implemented:

• [x] update wpaa template with correct source
• [x] update wpaa staging table with correct columns
• [x] filter wpaa for status in buffer intermediate table
• [x] update export geometry for wpaa dataset (previously it was point geom, the new dataset is in polygon)

Note

1. Old and new wpaa datasets have different geometry types. If I updated latest version with new data in recipes, it would yield issues in other ongoing PRs related to GFT. Therefore, I pulled new wpaa data without updating latest and fixed the wpaa version in GFT recipe file to work on this PR. Once PR is done:

   • [x] run data library to update latest version for wpaa dataset in recipes
   • [x] remove commit that fixes wpaa version in GFT recipe

2. There is one failing pytest in dcpy/library. I didn't touch dcpy in this PR, so not sure what it is. The failure should be addressed in a different PR.

Successful run here

[fvankrieken]

Sorry for the flaky test - for testing live endpoints for ingest, should probably move that to the "nightly build" action instead of PRs

Hopefully rerunning clears it up for now though

[sf-dcp]

Sorry for the flaky test - for testing live endpoints for ingest, should probably move that to the "nightly build" action instead of PRs

Hopefully rerunning clears it up for now though

Yep, passes now!

[sf-dcp]

Re-ran data library for wpaa to update latest version in recipes, removed commit for wpaa version in GFT recipe, re-ran build with these changes (it passes here).