ArcGIS Server Banner

ST_Curve

ST_Curve

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note: This topic was updated for 9.3.1.

NOTE: Spatial type for Oracle only

Definition

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

Syntax

sde.st_curve (wkt clob, srid integer)

Return type

ST_LineString

Example

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

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)', 0)
); 

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)

See Also

  • An overview of SQL functions used with ST_Geometry types