ST_GeomFromText

This section contains reference documentation for the ST_GeomFromText function.

Returns a geometry type object from Well-Known Text representation or extended (WKT) representation, with the optional spatial system reference

Signature

ST_GeomFromText(wkt)

Usage Examples

select ST_GeomFromText('POINT (30 10)') AS value
from ignoreMe 

value
80403e0000000000004024000000000000

select ST_GeomFromText('LINESTRING (30 10, 10 30, 40 40)') AS value
from ignoreMe 

value
02000000010000000300000000403e00000000000040240000000000004024000000000000403e00000000000040440000000000004044000000000000

select ST_GeomFromText('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))') AS value
from ignoreMe 

value
04000000010000000500000000403e0000000000004024000000000000402400000000000040340000000000004034000000000000404400000000000040440000000000004044000000000000403e0000000000004024000000000000