ST_Curve

NoteNote:

Oracle and SQLite only

Definition

ST_Curve constructs a curve feature from a well-known text representation.

Syntax

Oracle

sde.st_curve (wkt clob, srid integer)

SQLite

st_curve (wkt text, srid int32)

Return type

ST_LineString

Example

This example creates a table with a curve geometry, inserts values into it, then selects one feature.

Oracle

CREATE TABLE curve_test (
 id integer,
 geometry sde.st_curve
);

INSERT INTO CURVE_TEST VALUES (
 1910,
 sde.st_curve ('linestring (33 2, 34 3, 35 6)', 4326)
); 

SELECT id, sde.st_astext (geometry) CURVE
 FROM CURVE_TEST;

ID     CURVE

1110   LINESTRING (33.00000000 2.00000000, 34.00000000 3.00000000,
              35.00000000 6.00000000)

SQLite

CREATE TABLE curve_test (
 id integer primary key autoincrement not null
);

SELECT AddGeometryColumn(
 NULL,
 'curve_test',
 'geometry',
 4326,
 'linestring',
 'xy',
 'null'
);

INSERT INTO CURVE_TEST (geometry) VALUES (
 st_curve ('linestring (33 2, 34 3, 35 6)', 4326)
); 

SELECT id, st_astext (geometry) 
 AS curve
 FROM curve_test;

id     curve

1   LINESTRING (33.00000000 2.00000000, 34.00000000 3.00000000,
       35.00000000 6.00000000)

Related Topics

6/19/2015