Overview

One step towards offline map caching

This PR includes the following proposed change(s):

New API endpoint /v2/activities/bbox:

Using the same filter rules applied to a recordset, this endpoint can be targetted to make a bounding box for all the records contained within it.
Uses the existing sanitizeActivityFilterObject() and getActivitiesSQLv2() functionality, reducing maintenance and providing same level of security.

Testing

Copied Filter payloads from recordset network requests and used them against this new endpoint, Rendered the response objects in an external tool. Results came out as expected, given how bounding boxes function

[!NOTE] This Endpoint is not wired up to anything, I tested manually using the ThunderClient extension in VSC

Example Details

Payload example (Every record made by me):

{
    "filterObjects": [
        {
            "limit": 200000,
            "recordSetType": "Activity",
            "selectColumns": [
                "activity_id"
            ],
            "tableFilters": [
                {
                    "field": "created_by",
                    "filter": "EXAMPLE_ID",
                    "filterType": "tableFilter",
                    "id": "FILTER_ID_EXAMPLE",
                    "operator": "CONTAINS",
                    "operator2": "AND"
                }
            ]
        }
    ]
}

API Response:

{
  "bbox": "POLYGON((-127.03320312500054 48.42276700740098,-127.03320312500054 55.69957876911636,-118.78194475016757 55.69957876911636,-118.78194475016757 48.42276700740098,-127.03320312500054 48.42276700740098))"
}

bcgov / invasivesbc

[INV-3497] Get bounding box given a filter parameter #3514

Overview

Testing

Example Details

Payload example (Every record made by me):

API Response:

Response displayed using a MapViewer:

Quality Gate failed