Was this helpful?
Function Argument Data Types
The following table lists the data types that are operated upon by each function.
Functions for building queries:
Function
Data Type of Argument
AsBinary
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
AsText
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
AsTextRaw
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
AsTextRound
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
GeomCollFromText
Long Varchar
GeomCollFromWKB
Long Byte
GeometryFromText
Long Varchar
GeometryFromWKB
Long Byte
GeomZFromText
Long Varchar
GeomZFromWKB
Long Byte
GeomMFromText
Long Varchar
GeomMFromWKB
Long Byte
GeomZMFromText
Long Varchar
GeomZMFromWKB
Long Byte
LineFromText
Long Varchar
LineFromWKB
Long Byte
MLineFromText
Long Varchar
MLineFromWKB
Long Byte
MPointFromText
Long Varchar
MPointFromWKB
Long Byte
MPolyFromText
Long Varchar
MPolyFromWKB
Long Byte
PointFromText
Long Varchar
PointFromWKB
Long Byte
PolyFromText
Long Varchar
PolyFromWKB
Long Byte
Functions for geometry operations:
Function
Data Type of Argument
Add_Measure
Linestring, LinestringZ, LinestringM, LinestringZM, MultiLinestring, MultiLinestringZ, MultiLinestringM, MultiLinestringZM
Area
Polygon, MultiPolygon
Boundary
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Buffer
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Centroid
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Contains
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
ConvextHull
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Crosses
Linestring, Polygon, MultiLine, MultiPolygon
Difference
Polygon, MultiPolygon
Dimension
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Disjoint
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Distance
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Envelope
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Endpoint
Linestring, MultiLinestring
Equals
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
ExteriorRing
Polygon
GeometryN
GeometryCollection
GeometryType
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Inside
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
InteriorRingN
Polygon
Interp_Point
First argument: Linestring, LinestringZ, LinestringM, LinestringZM
Second argument: Point, PointZ, PointM, PointZM
Intersection
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Intersects
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
IsClosed
Linestring
IsEmpty
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
IsRing
Linestring
IsSimple
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Length
Linestring, MultiLinestring
Line_Interp_Point
Linestring, LinestringZ, LinestringM, LinestringZM
Line_Locate_Point
First argument: Linestring, LinestringZ, LinestringM, LinestringZM
Second argument: Point, PointZ, PointM, PointZM
Line_Substring
Linestring, LinestringZ, LinestringM, LinestringZM, MultiLinestring, MultiLinestringZ, MultiLinestringM, MultiLinestringZM
Locate_Along
Point, PointZ, PointM, PointZM, MultiPoint, MultiPointZ, MultiPointM, MultiPointZM, Linestring, LinestringZ, LinestringM, LinestringZM, MultiLinestring, MultiLinestringZ, MultiLinestringM, MultiLinestringZM
Locate_Between
PointM, PointZM, MultiPointM, MultiPointZM, LinestringM, LinestringZM, MultiLinestringM, MultiLinestringZM
Locate_Between_Elevations
PointZ, PointZM, MultiPointZ, MultiPointZM, LinestringZ, LinestringZM, MultiLinestringZ, MultiLinestringZM
NumGeometries
GeometryCollection
NumInteriorRing
Polygon
NumPoints
Linestring, MultiLinestring
Overlaps
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Perimeter
Polygon, MultiPolygon
PointN
Linestring, MultiLinestring
PointOnSurface
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Relate
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
SRID
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
StartPoint
Linestring, MultiLinestring
SymDifference
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Touches
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Transform
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Union
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
Within
Point, Linestring, Polygon, GeometryCollection, Multipoint, MultiLinestring, MultiPolygon
X
Point
Y
Point
Last modified date: 11/09/2022