Skip to main content
aggregate_min_max_geometry(table_name=None, column_name=None, options=)[source]

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

Parameters

table_name (str) –

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 (str) –

Name of a geospatial geometry column on which the min-max will be calculated.

options (dict of str to str) –

Optional parameters. The default value is an empty dict ( ).

Returns

A dict with the following entries–

min_x (float) –

Minimum x-coordinate value of the input parameter column_name.

max_x (float) –

Maximum x-coordinate value of the input parameter column_name.

min_y (float) –

Minimum y-coordinate value of the input parameter column_name.

max_y (float) –

Maximum y-coordinate value of the input parameter column_name.

info (dict of str to str) –

Additional information.