Spatial functions according to input type
List of spatial functions according to the type of input that they can accept.
Important: As noted elsewhere, the spatial data types form a hierarchy, with ST_Geometry as the root. When the spatial documentation indicates that a value of a super type in this hierarchy can be used as input to a function, alternatively, a value of any subtype of this super type can also be used as input to the function.
For example, the first entries in Table 1 indicate that ST_Area and
a number of other functions can take values of the ST_Geometry data
type as input. Therefore, input to these functions can also be values
of any subtype of ST_Geometry: ST_Point, ST_Curve, ST_LineString,
and so on.
| Data type of input parameter | Function |
|---|---|
| ST_Geometry | |
| ST_Geometry, continued | ST_Intersection
ST_Intersects ST_Is3D ST_IsEmpty ST_IsMeasured ST_IsSimple ST_IsValid ST_MaxM ST_MaxX ST_MaxY ST_MaxZ ST_MBR ST_MBRIntersects ST_MeasureBetween or ST_LocateBetween ST_MinM ST_MinX ST_MinY ST_MinZ ST_NumPoints ST_Overlaps ST_Relate ST_SRID or ST_SrsId ST_SrsName ST_SymDifference ST_ToGeomColl ST_ToLineString ST_ToMultiLine ST_ToMultiPoint ST_ToMultiPolygon ST_ToPoint ST_ToPolygon ST_Touches ST_Transform ST_Union ST_Within |
| ST_Point | |
| ST_Curve | |
| ST_LineString | |
| ST_Surface | |
| ST_GeomCollection | |
| ST_MultiPoint | ST_PointN |
| ST_MultiCurve | |
| ST_MultiLineString | |
| ST_MultiSurface | |
| ST_MultiPolygon |