
Analytics Toolbox for BigQuery
constructors
This module contains functions that create geographies from coordinates or already existing geographies.
ST_BEZIERSPLINE
Description
Takes a line and returns a curved version by applying a Bezier spline algorithm.
geog
:GEOGRAPHY
input LineString.resolution
:INT64
|NULL
time in milliseconds between points. IfNULL
the default value10000
is used.sharpness
:FLOAT64
|NULL
a measure of how curvy the path should be between splines. IfNULL
the default value0.85
is used.
Example
|
|
ST_MAKEELLIPSE
Description
Takes a Point and calculates the ellipse polygon given two semi-axes expressed in variable units and steps for precision.
center
:GEOGRAPHY
center point.xSemiAxis
:FLOAT64
semi (major) axis of the ellipse along the x-axis.ySemiAxis
:FLOAT64
semi (minor) axis of the ellipse along the y-axis.angle
:FLOAT64
|NULL
angle of rotation (along the vertical axis), from North in decimal degrees, negative clockwise. IfNULL
the default value0
is used.units
:STRING
|NULL
units of length, the supported options are: miles, kilometers, and degrees. IfNULL
the default valuekilometers
is used.steps
:INT64
|NULL
number of steps. IfNULL
the default value64
is used.
Example
|
|
ST_MAKEENVELOPE
Description Creates a rectangular Polygon from the minimum and maximum values for X and Y.
xmin
:FLOAT64
minimum value for X.ymin
:FLOAT64
minimum value for Y.xmax
:FLOAT64
maximum value for X.ymax
:FLOAT64
maximum value for Y.
Return type
GEOGRAPHY
Example
|
|
ST_TILEENVELOPE
Description Returns the boundary polygon of a tile given its zoom level and its X and Y indices.
zoomLevel
:INT64
zoom level of the tile.xTile
:INT64
X index of the tile.yTile
:INT64
Y index of the tile.
Return type
GEOGRAPHY
Example
|
|

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