Geospatial User Guide
>
Geospatial User Guide
>
Geospatial Functions
Was this helpful?
Geospatial Functions
Using Geospatial Functions
Function Alias
Function Argument Data Types
Spatial SQL Function Details
Functions That Do Not Support 3D
Area
AsBinary
AsText
AsTextRaw
AsTextRound
Boundary
Buffer
Centroid
Contains
ConvexHull
Crosses
Difference
Dimension
Disjoint
Distance
Envelope
Endpoint
Equals
Extent
ExteriorRing
GeomCollFromText
GeomCollFromWKB
GeometryFromText
GeometryFromWKB
GeometryMFromText GeometryZFromText
GeometryMFromWKB GeometryZFromWKB
GeometryN
GeometryType
GeometryMFromText GeometryZFromText
GeometryMFromWKB GeometryZFromWKB
GeometryZMFromText
GeometryZMFromWKB
Inside
InteriorRingN
Intersection
Intersects
IsClosed
IsEmpty
IsRing
IsSimple
IsValid
IsValidReason
LineFromText
LineFromWKB
M
MLineFromText
MLineFromWKB
MPointFromText
MPointFromWKB
MPolyFromText
MPolyFromWKB
NumGeometries
NumInteriorRing
NumPoints
Overlaps
Perimeter
PointFromText
PointFromWKB
PointN
PointOnSurface
PolyFromText
PolyFromWKB
Relate
Simplify
SRID
ST_Length
StartPoint
SymDifference
Touches
Transform
Union
Within
X
Y
Z
LRS-related Functions
Using Geospatial Functions
Spatial functions can be used in the following SQL statements:
•
SELECT
•
INSERT
•
UPDATE
•
DELETE
•
WHILE
•
IF
Last modified date: 01/30/2023
This site works best with JavaScript enabled