PostGIS Spatial Adapter

List recent spatial query logs (admin/audit use)

{
  "data": [
    {
      "query_id": "spq_001a2b",
      "function_name": "get_mentors_in_bounds",
      "params": {
        "sw_lat": 59.89,
        "sw_lng": 10.7,
        "ne_lat": 59.95,
        "ne_lng": 10.8
      },
      "row_count": 7,
      "executed_at": "2026-03-26T08:00:00Z",
      "duration_ms": 12
    }
  ],
  "pagination": {
    "page": 1,
    "limit": 20,
    "total": 1
  }
}

Get a specific spatial query log entry

{
  "query_id": "spq_001a2b",
  "function_name": "get_mentors_in_bounds",
  "params": {
    "sw_lat": 59.89,
    "sw_lng": 10.7,
    "ne_lat": 59.95,
    "ne_lng": 10.8
  },
  "envelope_wkt": "POLYGON((10.70 59.89, 10.80 59.89, 10.80 59.95, 10.70 59.95, 10.70 59.89))",
  "row_count": 7,
  "executed_at": "2026-03-26T08:00:00Z",
  "duration_ms": 12
}

Convert a LatLngBounds object to PostGIS envelope parameters

{
  "sw_lat": 59.89,
  "sw_lng": 10.7,
  "ne_lat": 59.95,
  "ne_lng": 10.8
}

{
  "xmin": 10.7,
  "ymin": 59.89,
  "xmax": 10.8,
  "ymax": 59.95,
  "srid": 4326,
  "envelope_wkt": "ST_MakeEnvelope(10.70, 59.89, 10.80, 59.95, 4326)"
}

Convert a lat/lng coordinate to a WKT GEOGRAPHY POINT string

{
  "lat": 59.9139,
  "lng": 10.7522
}

{
  "wkt": "POINT(10.7522 59.9139)",
  "geography_expression": "ST_GeogFromText('POINT(10.7522 59.9139)')",
  "srid": 4326
}

Parse a WKT GEOGRAPHY POINT string back to a lat/lng coordinate

{
  "wkt": "POINT(10.7522 59.9139)"
}

{
  "lat": 59.9139,
  "lng": 10.7522
}

Annotate or tag a spatial query log entry (admin use)

{
  "note": "Suspicious high-frequency query — investigate",
  "flagged": true
}

{
  "query_id": "spq_001a2b",
  "note": "Suspicious high-frequency query — investigate",
  "flagged": true,
  "updated_at": "2026-03-26T10:00:00Z"
}

Delete a spatial query log entry (GDPR/audit purge)

{
  "query_id": "spq_001a2b",
  "deleted": true,
  "deleted_at": "2026-03-26T10:05:00Z"
}

{
  "contract_summary": {
    "total_contracts": 410,
    "total_endpoints": 2416,
    "api_styles_used": [
      "rest"
    ]
  },
  "generated_at": "2026-03-26T06:55:53.316Z"
}