Skip to main content

ST_MakePoint

Creates a Point geometry from X and Y coordinate values. This is an alias for ST_Point.

Syntax​

ST_MakePoint(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_MakePoint(-122.4194, 37.7749);

Create Points from Columns​

SELECT id, ST_MakePoint(lon, lat) as geom FROM gps_tracks;

Use in Spatial Join​

SELECT a.id, b.name
FROM points a, regions b
WHERE ST_Contains(b.geom, ST_MakePoint(a.x, a.y));

Notes​

  • Identical to ST_Point - provided for PostGIS compatibility
  • Returns GeoArrow Point format for optimal performance

See Also​