Spatial Extension for BigQuery

Spatial Extension 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. https://turfjs.org/docs/#envelope

  • geog: ARRAY<GEOGRAPHY> input features.

Return type

GEOGRAPHY

Example

1
2
SELECT carto-os.accessors.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 ...

VERSION

Description

Returns the current version of the accessors module.

Return type

STRING

Example

1
2
SELECT carto-os.accessors.VERSION();
-- 1.0.0