Top 5 Recent Articles
- Algorithms (15)
- All (401)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (3)
- Open Source (18)
- Oracle Spatial and Locator (191)
- PostGIS (34)
- Published Articles (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (104)
- Spatial DB comparison (1)
- Spatial XML Processing (10)
- SQL Server Spatial (General) (83)
- SQL Server Spatial (LRS) (38)
- Standards (1)
- Stored Procedure (15)
- Tessellation or Gridding (9)
- Tools (2)
- Training (2)
STAddMeasure is a TSQL function that adds measures to the supplied linestring.
TSQL Call Signature
Function [lrs].[STAddMeasure] ( @p_linestring geometry, @p_start_measure float, @p_end_measure float, @p_round_xy int = 3, @p_round_zm int = 2 ) Returns geometry;
Function that add measure ordinates to the supplied @p_linestring.
The function supports LineString, CircularString, CompoundCurve geometries
If geometry is already measured it is returned unchanged.
Start Point is assigned @p_start_measure and End Point is assigned @p_end_measure.
Intermediate Points’ measure values are calculated based on length calculations.
If a 2D linestring is supplied its Z ordinates are set to NULL.
The updated coordinate’s XY ordinates are rounded to @p_round_xy number of decimal digits of precision.
The updated coordinate’s ZM ordinates are rounded to @p_round_ZM number of decimal digits of precision.
measured linestring (geometry) – Input linestring with measures applied.
@p_linestring (geometry) - Supplied Linestring geometry. @p_start_measure (float) - New Start M easurevalue. @p_end_measure (float) - New End Measure value. @p_round_xy (int) - Decimal degrees of precision to which calculated XY ordinates are rounded. @p_round_zm (int) - Decimal degrees of precision to which calculated ZM ordinates are rounded.
The following query adds a measures to the supplied line. The start measure 1 is added to the first vertex of the linestring and an end measure of 2.141 is added to the last vertex of the linestring. Any intermediate vertices have measures added by distance interpolation.
use DEVDB -- change to your database go SELECT [lrs].[STAddMeasure] ( geometry::STGeomFromText( 'LINESTRING(0 0,0.5 0.5,1 1)',0), 1, 2.414, 3, 2 ).AsTextZM() as MeasureLine; MeasureLine LINESTRING (0 0 NULL 1, 0.5 0.5 NULL 1.71, 1 1 NULL 2.41)