ST_Point

Definition

ST_Point takes a well-known text object or coordinates and an spatial reference ID and returns an ST_Point.

Syntax

Oracle

sde.st_point (wkt clob, srid integer) 
sde.st_point (x number, y number, srid integer) 
sde.st_point (x number, y number, m number, srid integer) 
sde.st_point (x number, y number, z number, srid integer) 
sde.st_point (x number, y number, z number, m number, srid integer)

PostgreSQL

sde.st_point (wkt, srid integer)
sde.st_point (esri_shape bytea, srid integer)sde.
sde.st_point (x double precision, y double precision, srid integer)
sde.st_point (x double precision, y double precision, m double precision, srid integer)
sde.st_point (x double precision, y double precision, z double precision, srid integer)
sde.st_point (x double precision, y double precision, z double precision, m double precision, srid integer)

Return type

ST_Point

Example

The following CREATE TABLE statement creates the point_test table, which has a single point column, PT1.

CREATE TABLE point_test (pt1 sde.st_geometry);

The ST_Point function converts the point coordinates into an ST_Point geometry before the INSERT statement inserts it into the pt1 column.

INSERT INTO point_test VALUES (
sde.st_point (10.01, 20.03, 0)
);

2/5/2013