ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

ST_Point

  • Definition
  • Syntax
  • Return type
  • Example

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 clob, 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)

SQLite

st_point (wkt text, srid int32)
st_point (x float64, y float64, srid int32)
st_point (x float64, y float64, z float64, m float64, srid int32)

Return type

ST_Point

Example

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

The ST_Point function converts the point coordinates into an ST_Point geometry before it is inserted into the pt1 column.

Oracle

CREATE TABLE point_test (pt1 sde.st_geometry);
INSERT INTO point_test VALUES (
 sde.st_point (10.01, 20.03, 4326)
);

PostgreSQL

CREATE TABLE point_test (pt1 sde.st_geometry);
INSERT INTO point_test VALUES (
 sde.st_point (10.01, 20.03, 4326)
);

SQLite

CREATE TABLE point_test (id integer);

SELECT AddGeometryColumn(
 NULL,
 'point_test',
 'pt1',
 4326,
 'point',
 'xy',
 'null'
);
INSERT INTO point_test VALUES (
 1,
 st_point (10.01, 20.03, 4326)
);

Related topics

  • Load the SQLite ST_Geometry library

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal