MS Sql Server 2008 geometry type supports adding Z and M values to geometry objects, including linestrings. However, I cannot find any way to make use of these values, since methods such as
.STIntersection() return a 2D point.
My end goal is to find where a given point intersects with a linestring and then find the equivalent Z and M values.
Googling and scouring Technet has yielded no useful information other than to make me wish I was using PostgreSql instead, which seems to include the functionality I require (unfortunately I am constrained to Sql Server).
Does anyone know how to actually make use of the Z and M values within linestrings, or of any toolsets that provide this functionality?