5. Geospatial Functions : Function Argument Data Types
 
Share this page                  
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
All
AsText
All
AsTextRaw
All
AsTextRound
All
GeomCollFromText
 
GeomCollFromWKB
 
GeometryFromText
 
GeometryFromWKB
 
LineFromText
 
LineFromWKB
 
MLineFromText
 
MLineFromWKB
 
MPointFromText
 
MPointFromWKB
 
MPolyFromText
 
MPolyFromWKB
 
PointFromText
 
PointFromWKB
 
PolyFromText
 
PolyFromWKB
 
Functions for geometry operations:
Function
Data Type of Argument
Area
Polygon, MultiPolygon
Boundary
All
Buffer
All
Centroid
All
Contains
All
ConvextHull
All
Crosses
Linestring, Polygon, MultiLine, MultiPolygon
Difference
Polygon, MultiPolygon
Dimension
All
Disjoint
All
Distance
All
Envelope
All
Endpoint
Linestring, MultiLinestring
Equals
All
ExteriorRing
Polygon
GeometryN
GeometryCollection
GeometryType
All
Inside
All
InteriorRingN
Polygon
Intersection
All
Intersects
All
IsClosed
Linestring
IsEmpty
All
IsRing
Linestring
IsSimple
All
Length
Linestring, MultiLinestring
NumGeometries
GeometryCollection
NumInteriorRing
Polygon
NumPoints
Linestring, MultiLinestring
Overlaps
All
Perimeter
Polygon, MultiPolygon
PointN
Linestring, MultiLinestring
PointOnSurface
All
Relate
All
SRID
All
StartPoint
Linestring, MultiLinestring
SymDifference
All
Touches
All
Transform
All
Union
All
Within
All
X
Point
Y
Point