arcgis sde sql函数找线要素shape(含M或Z值)的起终止坐标,翻了官方文档和网上没有相关的东西,琢磨了一个:
SELECT
to_number(SUBSTR(sde.st_astext(p.shape), INSTR(sde.st_astext(p.shape), ' ', 1, 3)+ 1,
INSTR(sde.st_astext(p.shape), ' ', 1, 1)+ 1)) BEGINX,
to_number(SUBSTR(sde.st_astext(p.shape), INSTR(sde.st_astext(p.shape), ' ', 1, 4)+ 1,
INSTR(sde.st_astext(p.shape), ' ', 1, 1)+ 1)) BEGINY,
to_number(SUBSTR(sde.st_astext(p.shape), INSTR(sde.st_astext(p.shape), ' ',-1, 3)+ 1,
INSTR(sde.st_astext(p.shape), ' ', 1, 1)+ 1)) ENDX,
to_number(SUBSTR(sde.st_astext(p.shape), INSTR(sde.st_astext(p.shape), ' ',-1, 2)+ 1,
INSTR(sde.st_astext(p.shape), ' ', 1, 1)+ 1)) ENDY
from your_table