Posted on

STValidLrsPoint

STValidLrsPoint — Checks if supplied @p_point is a valid LRS point.

Function Specification.

Function STValidLrsPoint (
           @p_point geometry
    )
Returns bit

Description.

Function returns 1 (true) if point is measured, and 0 (false) if point is not measured.

A valid LRS point has measure information.

The function checks for the Point geometry type and has a measured ordinate.

Parameters.

    @p_point (geometry) - Measured Point.

Result.

The function returns 1 (true) if measured point, 0 (false) otherwise.

Example.

select [lrs].[STValidLrsPoint](geometry::STGeomFromText('POINT(0 0)',0)) as is_measured_point
GO

is_measured_point
0

select [lrs].[STValidLrsPoint](geometry::STGeomFromText('POINT(0 0 NULL 1)',0)) as is_measured_point
GO

is_measured_point
1
Leave a Reply

Your email address will not be published. Required fields are marked *