Skip to main content

ST_Point

Creates a Point geometry from X and Y coordinate values.

Syntax​

ST_Point(x, y)

Parameters​

ParameterTypeDescription
xFloat64X coordinate (longitude in geographic CRS)
yFloat64Y coordinate (latitude in geographic CRS)

Returns​

TypeDescription
FixedSizeList[2]Point as GeoArrow Point with geoarrow.point metadata

Examples​

Create a Point​

SELECT ST_Point(0, 0);

Create Points from Columns​

SELECT id, ST_Point(longitude, latitude) as geom FROM locations;

Use in Spatial Analysis​

SELECT * FROM buildings
WHERE ST_Distance(geom, ST_Point(-122.4194, 37.7749)) < 1000;

Chain with Other Functions​

SELECT ST_Buffer(ST_Point(x, y), 100) as buffer FROM coordinates;

Notes​

  • Returns GeoArrow Point format (FixedSizeList[Float64, 2]) for optimal performance
  • More efficient than ST_GeomFromText for creating simple points
  • Coordinates are stored as-is without validation
  • For 3D points with Z coordinate, use ST_GeomFromText

See Also​