Skip to main content

ST_GeomFromText

Parses a Well-Known Text (WKT) string and returns a geometry.

Syntax​

ST_GeomFromText(wkt)

Parameters​

ParameterTypeDescription
wktUtf8Well-Known Text representation of a geometry

Returns​

TypeDescription
Binary (WKB)Geometry as WKB with geoarrow.wkb metadata

Examples​

Create a Point​

SELECT ST_GeomFromText('POINT(0 0)');

Create a Polygon​

SELECT ST_GeomFromText('POLYGON((0 0, 4 0, 4 4, 0 4, 0 0))');

Parse WKT Column​

SELECT id, ST_GeomFromText(wkt_column) as geom FROM raw_data;

Create Complex Geometries​

-- MultiPolygon
SELECT ST_GeomFromText('MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((2 2, 3 2, 3 3, 2 3, 2 2)))');

-- LineString
SELECT ST_GeomFromText('LINESTRING(0 0, 1 1, 2 0)');

-- GeometryCollection
SELECT ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0, 1 1))');

Notes​

  • Uses GEOS library for WKT parsing
  • Supports all OGC geometry types: Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, GeometryCollection
  • Invalid WKT will result in an error
  • Case-insensitive geometry type names

See Also​