Using M 'Measure' value in SQL Server 2008

المشرف العام

Administrator
طاقم الإدارة
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?



أكثر...
 
أعلى