Geospatial Data Type

Geospatial data type

The geospatial data type can store various geometry objects. For more information, see Geospatial Data.

Exasol type (ANSI type) Possible Elements Note

Exasol type (ANSI type)	Possible Elements	Note
`GEOMETRY [(srid)]`	POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION	srid defines the coordinate system. The default value is 0 (none) For more information, see EXA_SPATIAL_REF_SYS.

GEOMETRY [(srid)]

POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION

srid defines the coordinate system. The default value is 0 (none)

For more information, see EXA_SPATIAL_REF_SYS.