ST_IsMeasured() method

Determines if the geometry value has associated measure values.

Syntax

geometry-expression.ST_IsMeasured()

BIT Returns 1 if the geometry value has measure values, otherwise 0.

Example 1 – The following example returns the result 1.

SELECT ST_Geometry::ST_GeomFromText( 'LineString M( 1 2 4, 5 7 3 )' ).ST_IsMeasured()

The following example returns the result 0.

SELECT count(*) FROM SpatialShapes WHERE Shape.ST_IsMeasured() = 1

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.11