Mysql uses the WKB function to create Geometry (ry) Values

Mysql uses the WKB function to create Geometry (ry) Values

MySQL provides many functions that use BLOB containing WKT expressions or optional Spatial Reference System ID (SRID) as input parameters. They return corresponding geometric objects.

GeomFromWKB () accepts WKB of any geometric type as its 1st parameter. Type-related constructors are also provided in the implementation scheme to construct the geometric values of each geometric type.

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

Use its WKB representation and SRID to construct the GEOMETRYCOLLECTION value.

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

WKB and SRID are used to construct geometric values of any type.

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

Use its WKB representation and SRID to construct the LINESTRING value.

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

Use its WKB representation and SRID to construct the MULTILINESTRING value.

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

Use its WKB representation and SRID to construct the MULTIPOINT value.

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

Use its WKB representation and SRID to construct the MULTIPOLYGON value.

PointFromWKB (wkb [, srid])

Use its WKB representation and SRID to construct the POINT value.

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

Use its WKB representation and SRID to construct the POLYGON value.

OpenGIS specifications also introduce the optional functions used to construct Polygon or MultiPolygon values. These values are based on the WKB expressions of the ring and closed LineString value sets. These values can be intersection. MySQL has not implemented the following functions:

BdMPolyFromWKB (wkb, srid)

Construct the MultiPolygon value from the MultiLineString value in the WKB format that contains any set of closed LineString values.

BdPolyFromWKB (wkb, srid)

The Polygon value is constructed from the MultiLineString value in the WKB format that contains any set of closed LineString values.

Note: For more exciting articles, please follow the help houseProgramming TutorialTopic.