tap into the value of data

Bring a dataset such as...

...clean it up...

SELECT
  regexp_replace("Postcode", '\s*(.3$)', ' \1', 'g') AS "Postcode",
  trim("AddressLine1") AS "AddressLine1",
  trim("AddressLine2") AS "AddressLine2"
FROM data.example

...join it with another dataset...

SELECT model.example_cleaned.*,
  data.uk_postcode_lookup.latitude AS "Latitude",
  data.uk_postcode_lookup.longitude AS "Longitude"
FROM model.example_cleaned
JOIN data.uk_postcode_lookup ON "Postcode" = postcode

...enrich with H3 indexing...

SELECT
  model.example_joined.*,
  h3_latlng_to_cell("Latitude", "Longitude", 15::INT) AS "H3Res15"
FROM model.example_joined

...and download or serve this data via an API:

https://example.com/test?Within=[-5.205964198095899,55.50214416203221,-5.079052659295115,55.57395814779818]

{
  "data": [
    {
      "Postcode": "KA27 8LF",
      "H3Res15": "8f19569a8c5c648",
      "Latitude": 55.54312,
      "Longitude": -5.115521,
      "AddressLine1": "Lamlash",
      "AddressLine2": "Isle of Arran"
    }
  ],
  "_meta": {
    "cursor": null,
    "elapsed": 35
  }
}