Syntax - Analytics Database - Teradata Vantage

Geospatial Data Types

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-30
dita:mapPath
qgk1628112272483.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ghz1472251264557
lifecycle
latest
Product Category
point
`POINT point_spec`
linestring
`LINESTRING linestring_spec`
polygon
`POLYGON polygon_spec`
multipoint
`MULTIPOINT { EMPTY | ( point_spec [,...] ) }`
multilinestring
`MULTILINESTRING { EMPTY | ( linestring_spec [,...] ) }`
multipolygon
`MULTIPOLYGON { EMPTY | ( polygon_spec [,...] ) }`
geometrycollection
`GEOMETRYCOLLECTION { EMPTY | ( geometry_collection_item [,...] ) }`
geosequence
```GEOSEQUENCE {
EMPTY |
( ( x-y_pair [,...] ),
( ts [,...] ),
( count, uf [,...] )
)
}```
point_spec
`{ EMPTY | ( x-y_pair_opt_z ) }`
linestring_spec
`{ EMPTY | ( x-y_pair_opt_z [,...] ) }`
polygon_spec
`{ EMPTY | ( linestring_spec [,...] ) }`
geometry_collection_item
```{ point |
linestring |
polygon |
multipoint |
multilinestring |
multipolygon |
geometry_collection |
geosequence
}```
x-y_pair
`x y`
x-y_pair_opt_z
`x y [ z ]`

Syntax Elements

EMPTY
The empty set.
x
A numeric value that represents the x coordinate of a point.
y
A numeric value that represents the y coordinate of a point.
z
A numeric value that represents the z coordinate of a point in 3D space.
ts
A timestamp value with the following format:
`   yyyy-mm-dd hh:mi:ss.ms`
The first timestamp value is associated with the first point, the second timestamp value is associated with the second point, and so forth.
You must specify n timestamp values, where n is the number of points in the geosequence.