12.17.4 Functions That Create Geometry Values from WKB Values

These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier (SRID). They return the corresponding geometry.

GeomFromWKB() and ST_GeomFromWKB() accept a WKB value of any geometry type as their first argument. Other functions provide type-specific construction functions for construction of geometry values of each geometry type.

These functions also accept geometry objects as returned by the functions in Section 12.17.5, “MySQL-Specific Functions That Create Geometry Values”. Thus, those functions may be used to provide the first argument to the functions in this section.

For a description of WKB format, see Well-Known Binary (WKB) Format.

• GeomCollFromWKB(wkb [, srid]), GeometryCollectionFromWKB(wkb [, srid])

  ST_GeomCollFromWKB(), ST_GeometryCollectionFromWKB(), GeomCollFromWKB(), and GeometryCollectionFromWKB() are synonyms. For more information, see the description of ST_GeomCollFromWKB().

• GeomFromWKB(wkb [, srid]), GeometryFromWKB(wkb [, srid])

  ST_GeomFromWKB(), ST_GeometryFromWKB(), GeomFromWKB(), and GeometryFromWKB() are synonyms. For more information, see the description of ST_GeomFromWKB().

• LineFromWKB(wkb [, srid]), LineStringFromWKB(wkb [, srid])

  ST_LineFromWKB(), ST_LineStringFromWKB(), LineFromWKB(), and LineStringFromWKB() are synonyms. For more information, see the description of ST_LineFromWKB().

• MLineFromWKB(wkb [, srid]), MultiLineStringFromWKB(wkb [, srid])

  Constructs a MultiLineString value using its WKB representation and SRID.

  The result is NULL if the WKB or SRID argument is NULL.

• MPointFromWKB(wkb [, srid]), MultiPointFromWKB(wkb [, srid])

  Constructs a MultiPoint value using its WKB representation and SRID.

  The result is NULL if the WKB or SRID argument is NULL.

• MPolyFromWKB(wkb [, srid]), MultiPolygonFromWKB(wkb [, srid])

  Constructs a MultiPolygon value using its WKB representation and SRID.

  The result is NULL if the WKB or SRID argument is NULL.

• PointFromWKB(wkb [, srid])

  ST_PointFromWKB() and PointFromWKB() are synonyms. For more information, see the description of ST_PointFromWKB().

• PolyFromWKB(wkb [, srid]), PolygonFromWKB(wkb [, srid])

  ST_PolyFromWKB(), ST_PolygonFromWKB(), PolyFromWKB(), and PolygonFromWKB() are synonyms. For more information, see the description of ST_PolyFromWKB().

• ST_GeomCollFromWKB(wkb [, srid]), ST_GeometryCollectionFromWKB(wkb [, srid])

  Constructs a GeometryCollection value using its WKB representation and SRID.

  The result is NULL if the WKB or SRID argument is NULL.

  ST_GeomCollFromWKB(), ST_GeometryCollectionFromWKB(), GeomCollFromWKB(), and GeometryCollectionFromWKB() are synonyms.

• ST_GeomFromWKB(wkb [, srid]), ST_GeometryFromWKB(wkb [, srid])

  Constructs a geometry value of any type using its WKB representation and SRID.

  The result is NULL if the WKB or SRID argument is NULL.

  ST_GeomFromWKB(), ST_GeometryFromWKB(), GeomFromWKB(), and GeometryFromWKB() are synonyms.

• ST_LineFromWKB(wkb [, srid]), ST_LineStringFromWKB(wkb [, srid])

  Constructs a LineString value using its WKB representation and SRID.

  The result is NULL if the WKB or SRID argument is NULL.

  ST_LineFromWKB(), ST_LineStringFromWKB(), LineFromWKB(), and LineStringFromWKB() are synonyms.

• ST_PointFromWKB(wkb [, srid])

  Constructs a Point value using its WKB representation and SRID.

  The result is NULL if the WKB or SRID argument is NULL.

  ST_PointFromWKB() and PointFromWKB() are synonyms.

• ST_PolyFromWKB(wkb [, srid]), ST_PolygonFromWKB(wkb [, srid])

  Constructs a Polygon value using its WKB representation and SRID.

  The result is NULL if the WKB or SRID argument is NULL.

  ST_PolyFromWKB(), ST_PolygonFromWKB(), PolyFromWKB(), and PolygonFromWKB() are synonyms.