Functions that return coordinate and measure information
You can use certain functions to return information about the coordinates and measures within a geometry.
For example, ST_X can return the X coordinate within a specified point, ST_MaxX returns the highest X coordinate within a geometry, and ST_MinX returns the lowest X coordinate within a geometry.
ST_Is3D
ST_Is3D takes a geometry as an input parameter and returns 1 if the given geometry has Z coordinates. Otherwise, 0 (zero) is returned.
ST_IsMeasured
ST_IsMeasured takes a geometry as an input parameter and returns 1 if the given geometry has M coordinates (measures). Otherwise 0 (zero) is returned.
ST_IsValid
ST_IsValid takes a geometry as an input parameter and returns 1 if it is valid. Otherwise 0 (zero) is returned.
A geometry is valid only if all of the attributes in the structured type are consistent with the internal representation of geometry data, and if the internal representation is not corrupted.
ST_M
If a measure is stored with a given point, ST_M can take the point as an input parameter and return the measure.
ST_MaxM
ST_MaxM takes a geometry as an input parameter and returns its maximum measure.
ST_MaxX
ST_MaxX takes a geometry as an input parameter and returns its maximum X coordinate.
ST_MaxY
ST_MaxY takes a geometry as an input parameter and returns its maximum Y coordinate.
ST_MaxZ
ST_MaxZ takes a geometry as an input parameter and returns its maximum Z coordinate.
ST_MinM
ST_MinM takes a geometry as an input parameter and returns its minimum measure.
ST_MinX
ST_MinX takes a geometry as an input parameter and returns its minimum X coordinate.
ST_MinY
ST_MinY takes a geometry as an input parameter and returns its minimum Y coordinate.
ST_MinZ
ST_MinY takes a geometry as an input parameter and returns its minimum Z coordinate.
ST_X
ST_X can take a point as an input parameter and return the point's X coordinate.
ST_Y
ST_Y can take a point as an input parameter and return the point's Y coordinate.
ST_Z
If a Z coordinate is stored with a given point, ST_Z can take the point as an input parameter and return the Z coordinate.