Syntax - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Geospatial Data Types

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K


polygon_ID
A numeric or character value that uniquely identifies the polygon or multipolygon to be split. This same value is returned for each of the sub-polygons that is returned as a result of the splitting, and can be used to associate the sub-polygons with the original polygon

polygon_ID can be any valid Teradata Database numeric or character data type except CLOB.

If polygon_ID is NULL for a given polygon, the results will show corresponding NULLs for the IDs of the unchanged polygon or for the sub-polygons that are generated.

geom
The polygon or multipolygon geometry to be split.

PolygonSplit accepts all types of ST_Geometry, but only 2D polygons and 2D multipolygons are split. Other geometries are returned unchanged.

If geom is NULL, PolygonSplit returns NULL for that geometry.

max_vertices
The maximum number of vertices that a returned sub-polygon can include. If the original polygon or multipolygon has fewer than this number of vertices, it is returned unchanged.

max_vertices must be greater than or equal to 10. The default is 300.

If max_vertices is NULL, PolygonSplit defaults to 300.

[database_name.]
table_name
The name and optional database location of the table that contains the polygon and multipolygon geometries to be split.
correlation_name
A name to be assigned to the table returned by the table operator.
column_list

Optional list of custom names for the columns returned by the table operator.

These names override the column names that would be otherwise generated by the operator. If you specify any column names, you must provide names for all columns returned. If more than one column is returned by the operator, separate the names with commas.