Convert geometries

The following geometry conversion functions are available:

Function	Description
ST_AsBinary	Geometry → Well Known Binary
ST_AsEWKB	Geometry → Extended Well Known Binary
ST_AsGML	Geometry → GML
ST_AsText	Alias for ST_AsWKT
ST_AsWKT	Geometry → Well Known Text
ST_Force2D	3D or 4D Geometry → 2D Geometry
ST_GeomFromGML	GML → Geometry
ST_GeomFromText	Well Known Text → Geometry
ST_GeomFromWKB	Well Known Binary → Geometry
ST_GeometryTypeCode	Return the OGC SFS type code of a Geometry
ST_GoogleMapLink	Geometry → Google map link
ST_Holes	Return a Geometry’s holes
ST_LineFromText	Well Known Text → LINESTRING
ST_LineFromWKB	Well Known Binary → LINESTRING
ST_MLineFromText	Well Known Text → MULTILINESTRING
ST_MPointFromText	Well Known Text → MULTIPOINT
ST_MPolyFromText	Well Known Text → MULTIPOLYGON
ST_Multi	SIMPLE → MULTI geometry
ST_OSMMapLink	Geometry → OSM map link
ST_PointFromText	Well Known Text → POINT
ST_PointFromWKB	Well Known Binary → POINT
ST_PolyFromText	Well Known Text → POLYGON
ST_PolyFromWKB	Well Known Binary → POLYGON
ST_ToMultiLine	Geometry’s coordinates → MULTILINESTRING
ST_ToMultiPoint	Geometry’s coordinates → MULTIPOINT
ST_ToMultiSegments	GEOMETRY(COLLECTION) → MULTILINESTRING

• ST_AsBinary
• ST_AsEWKB
• ST_AsGML
• ST_AsWKT
• ST_AsText
• ST_Force2D
• ST_GeomFromGML
• ST_GeomFromText
• ST_GeomFromWKB
• ST_GeometryTypeCode
• ST_GoogleMapLink
• ST_Holes
• ST_LineFromText
• ST_LineFromWKB
• ST_MLineFromText
• ST_MPointFromText
• ST_MPolyFromText
• ST_Multi
• ST_OSMMapLink
• ST_PointFromText
• ST_PointFromWKB
• ST_PolyFromText
• ST_PolyFromWKB
• ST_ToMultiLine
• ST_ToMultiPoint
• ST_ToMultiSegments