Analytics Toolbox for BigQuery

Analytics Toolbox for BigQuery

accessors

This module contains functions that provide information or transform internal geometries.

ST_ENVELOPE

Description

Takes any number of features and returns a rectangular Polygon that encompasses all vertices.

  • geog: ARRAY<GEOGRAPHY> input features.

Return type

GEOGRAPHY

Example

1
2
SELECT `carto-os`.carto.ST_ENVELOPE([ST_GEOGPOINT(-75.833, 39.284), ST_GEOGPOINT(-75.6, 39.984), ST_GEOGPOINT(-75.221, 39.125)]);
-- POLYGON((-75.833 39.125, -75.68 39.125 ...
EU flag

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.