12.15.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.15.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_GeomCollFromWKB() and ST_GeometryCollectionFromWKB() were added in MySQL 5.6.1.

• 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_GeomFromWKB() and ST_GeometryFromWKB() were added in MySQL 5.6.1.

• 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_LineFromWKB() and ST_LineStringFromWKB() were added in MySQL 5.6.1.

• 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_PointFromWKB() was added in MySQL 5.6.1.

• 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.

  ST_PolyFromWKB() and ST_PolygonFromWKB() were added in MySQL 5.6.1.