关于ArcSDE Transformation函数的使用

又拿起了曾经用过的东西，在一条线上取距离多远的点的坐标。

记得曾经搞过，重新整理一下。

 

 

ArcSDE Transformation函数中包含函数SE_LocateAlong。

 

 

For geometries that have measures, the location of a particular measure can be found with the SE_LocateAlong function. SE_LocateAlong returns the location as a multipoint. If the source geometry’s dimension is 0 (i.e., point and multipoint), only points with a matching measure value are returned as a multipoint. However, for source geometries whose dimension is greater than 0, the location is interpolated. For example, if the requested measure value is 5.5 and a linestring’s vertices have measures of 3, 4, 5, 6, and 7, an interpolated point that falls exactly halfway between the vertices with measure values 5 and 6 is returned. ST_LocateAlong locates a point on a linestring by interpolating the given measure value, if necessary. In this case, a point with measure 5.5 is interpolated halfway between the vertices of the linestring with measures 5 and 6. For multipoints, an exact match is required. In the case of the above multipoint geometry, locatealong returns the point that has measure 5.5.

具体文档可参考：
http://edndoc.esri.com/arcsde/9. ... transformations.htm

开头还有段很重要的说明

Transformation functions generate new geometry using existing geometry and a formula.
Note: Function references are for the SQL API.

important info:　“are for the SQL API”

 

主要是使用SE_LocateAlong这个特性，可以把这个方法放在SQL的where里，来成批的获取shap，对于单一shape完全可以用SE_shape_find_along来获取，当然这个要依靠图层里的M_value，也就是通过Shape with Measures提供的方法来判断一下shape是否有measures。

 

引用于论坛讨论：

http://bbs.esrichina-bj.cn/ESRI/viewthread.php?tid=50277&highlight=%2Bcnhome