获取Y坐标ST_Y(geometry) 和X坐标ST_X(geometry)
select dmgeo2.ST_X(geom),dmgeo2.ST_Y(geom) ,to_char(dmgeo2.ST_AsText(geom)) from dmpoint;
ST_Equals(geometry)——判断两个几何对象是否相同
SELECT dmgeo2.ST_Equals(dmgeo2.ST_GeomFromText('POINT(1 1)', 4326),dmgeo2.ST_GeomFromText('POINT(2 2)', 4326));
SELECT dmgeo2.ST_Distance(dmgeo2.ST_GeometryFromText('POINT(1 1)', 4326), dmgeo2.ST_GeometryFromText('POINT(2 2)', 4326) );
SELECT dmgeo2.ST_Length(geom) 线长度,to_char(dmgeo2.ST_AsText(dmgeo2.ST_StartPoint(geom))) 线串初始坐标,to_char(dmgeo2.ST_AsText(dmgeo2.ST_EndPoint(geom)))线串结束坐标,dmgeo2.ST_NumPoints(geom) 线串坐标数量,to_char(dmgeo2.ST_AsText(geom)) FROM dmLine;
标签:学习,char,dmgeo2,ST,空间数据,geometry,geom,坐标,达梦 From: https://www.cnblogs.com/fangzpa/p/17759913.html