Rework active hotbeds calculation

[SanderDevisscher]

The active hotbeds map should display a hot map of recent (last 2 weeks) observations independent of management status of nearby nests. This should occur at a high update frequency to allow for rapid response.

these are the steps that are needed to achieve this according to me:

• Create a new workflow¹
• fix https://github.com/inbo/vespaR/issues/173
• write script to get recent observations² from waarnemingenAPI - gsheet
• export directly to the uat-bucket³ & in longer term to the prd bucket⁴

¹ this workflow should have the following elements:

• daily CRON trigger: '0 2 * * *'
• gsheet_token: ${{ secrets.gsheet_token }}
• GITHUB_TOKEN: ${{ secrets.AUTOMATISATION }}
• a Assume Role step

² if I understand correctly this can be achieved by reversing the activity filter ea filter(!activity %in% c(3240,3036)). @jrhillae is this correct ?

³ @mvarewyck given the high frequency (daily) I would like to bypass the review step. What should be the filename of the file on the bucket ? I assume there are some changes required on the app side as well they should be listed at #219.

⁴ @TheJenne18 is it possible in current setup to bypass the UAT bucket step and update files on the PRD bucket directly ? Given the high frequency of updates (daily) I don't think going through 2 validation steps is viable 🤔

[SanderDevisscher]

3 @mvarewyck given the high frequency (daily) I would like to bypass the review step. What should be the filename of the file on the bucket ? I assume there are some changes required on the app side as well they should be listed at #219.

The file should be named actieve_haarden.geojson => current actieve_haarden.geojson should be removed.

[SanderDevisscher]

4 @TheJenne18 is it possible in current setup to bypass the UAT bucket step and update files on the PRD bucket directly ? Given the high frequency of updates (daily) I don't think going through 2 validation steps is viable 🤔

@TheJenne18 can you confirm the PRD bucket exists ?

[mvarewyck]

@TheJenne18 can you confirm the PRD bucket exists ?

Yes I have access to it.