GeomFromGeoJSON JSON Function Syntax | Teradata Vantage - GeomFromGeoJSON Syntax - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
gzn1554761068186.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantageā„¢
[TD_SYSFNLIB.] GeomFromGeoJSON ( geojson_expr, asrid )

Syntax Elements

TD_SYSFNLIB
The name of the database where the function is located.
geojson_expr
An expression which evaluates to a JSON document conforming to the GeoJSON standards as specified in https://tools.ietf.org/html/rfc7946 . The GeoJSON text string can be represented as a VARCHAR, CLOB, or JSON instance in the LATIN or UNICODE character set.
This GeoJSON text string must represent a geometry object. The value of the type member must be one of these strings: "Point", "MultiPoint", "LineString", "MultiLineString", "Polygon", "MultiPolygon", or "GeometryCollection".
asrid
An integer which specifies the Spatial Reference System (SRS) identifier assigned to the returned ST_Geometry object.