Aggregate Min/Max Geometry

Calculates and returns the minimum and maximum x- and y-coordinates of a particular geospatial geometry column in a table.

Input Parameter Description

Name Type Description
table_name string Name of the table on which the operation will be performed. Must be an existing table, in [schema_name.]table_name format, using standard name resolution rules.
column_name string Name of a geospatial geometry column on which the min-max will be calculated.
options map of string to strings Optional parameters. The default value is an empty map ( {} ).

Output Parameter Description

Name Type Description
min_x double Minimum x-coordinate value of the input parameter column_name.
max_x double Maximum x-coordinate value of the input parameter column_name.
min_y double Minimum y-coordinate value of the input parameter column_name.
max_y double Maximum y-coordinate value of the input parameter column_name.
info map of string to strings Additional information.