ST_LineString
定义
ST_LineString 是一个通过熟知文本表示构造线串的存取函数。
注:
创建将用于 ArcGIS 的空间表时,最好将列创建为 ST_Geometry,而不要指定一个 ST_Geometry 子类型,如 ST_LineString。
语法
Oracle
sde.st_linestring (wkt clob, srid integer)
PostgreSQL
sde.st_linestring (wkt, srid integer) sde.st_linestring (esri_shape bytea, srid integer)
返回类型
ST_LineString
示例
Oracle
CREATE TABLE lines_test (id smallint, geometry sde.st_geometry);
INSERT INTO LINES_TEST (id, geometry) VALUES (
1901,
sde.st_linestring ('linestring (750 150, 750 750)', 0)
);
SELECT id, sde.st_astext (geometry) Linestring
FROM LINES_TEST;
ID LINESTRING
1901 LINESTRING (750.00000000 150.00000000,
750.00000000 750.00000000)
PostgreSQL
CREATE TABLE lines_test (id integer, geometry st_geometry);
INSERT INTO lines_test (id, geometry) VALUES (
1901,
sde.st_linestring ('linestring (750 150, 750 750)', 0)
);
SELECT id, sde.st_astext (geometry) AS Linestring
FROM lines_test;
id linestring
1901 LINESTRING (750 150, 750 750)
9/15/2013