ArcGIS Server Banner

ST_Point

ST_Point

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

Definition

ST_Point returns an ST_Point, given an x-coordinate, y-coordinate, and spatial reference ID.

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

st_point (wkt, srid integer)
st_point (esri_shape bytea, srid integer)
st_point (x double precision, y double precision, srid integer)
st_point (x double precision, y double precision, m double precision, srid integer)
st_point (x double precision, y double precision, z double precision, srid integer)
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.

Oracle

CREATE TABLE POINT_TEST (pt1 sde.st_geometry);

PostgreSQL

CREATE TABLE POINT_TEST (pt1 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.

Oracle

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

PostgreSQL

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

See Also

  • An overview of SQL functions used with ST_Geometry types