Description
The ST_Point function constructs a point geometry from the provided X and
Y, and an optional CRS.
Syntax
ST_Point(String|Number X, String|Number Y, [SpatialInfo CRS])
Parameters
| Parameter |
Type |
Description |
|
X
|
String or Number |
The X ordinate. |
|
Y
|
String or Number |
The Y ordinate. |
|
CRS
|
String |
Optional. The coordinate system for the geometry. Default = EPSG:4326 |
Return Values
| Return Type |
Description |
| WritableGeometry |
The geometry of the specified X/Y coordinates. If any of the argument values
are invalid, then an empty geometry will be returned in the output. |
Examples
SELECT ST_Point(-73.750333 , 42.736103, 'epsg:4326');
SELECT ST_Point('-73.750333' , '42.736103', 'epsg:4326');
SELECT ST_Point(-73.750333 , 42.736103);
SELECT ST_Point('-73.750333' , 42.736103);
SELECT ST_Point(p.x, p.y, p.crs) FROM points p;