17.10 - PolygonSplit Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)
[TD_SYSFNLIB.] PolygonSplit (
  ON { [ database_name.. ] table_name |

       ( SELECT polygon_ID, geom [, max_vertices ]
         FROM [ database_name.. ] table_name 
       )
     }
) [AS] correlation_name [ ( column_list ) 

Syntax Elements

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 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 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.