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.