ST_AsBinary

Syntax

VARCHAR ST_AsBinary(GEOMETRY geo)

Description

Converting a geometric figure into a standard WKB (Well-known binary) representation

Currently supported geometric figures are: Point, LineString, Polygon.

example

  1. mysql> select ST_AsBinary(st_point(24.7, 56.7));
  2. +----------------------------------------------+
  3. | st_asbinary(st_point(24.7, 56.7))            |
  4. +----------------------------------------------+
  5. | \x01010000003333333333b338409a99999999594c40 |
  6. +----------------------------------------------+
  7. 1 row in set (0.01 sec)
  9. mysql> select ST_AsBinary(ST_GeometryFromText("LINESTRING (1 1, 2 2)"));
  10. +--------------------------------------------------------------------------------------+
  11. | st_asbinary(st_geometryfromtext('LINESTRING (1 1, 2 2)'))                            |
  12. +--------------------------------------------------------------------------------------+
  13. | \x010200000002000000000000000000f03f000000000000f03f00000000000000400000000000000040 |
  14. +--------------------------------------------------------------------------------------+
  15. 1 row in set (0.04 sec)
  17. mysql> select ST_AsBinary(ST_Polygon("POLYGON ((114.104486 22.547119,114.093758 22.547753,114.096504 22.532057,114.104229 22.539826,114.106203 22.542680,114.104486 22.547119))"));
  18. +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  19. | st_asbinary(st_polygon('POLYGON ((114.104486 22.547119,114.093758 22.547753,114.096504 22.532057,114.104229 22.539826,114.106203 22.542680,114.104486 22.547119))'))                                                         |
  20. +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  21. | \x01030000000100000006000000f3380ce6af865c402d05a4fd0f8c364041ef8d2100865c403049658a398c3640b9fb1c1f2d865c409d9b36e334883640de921cb0ab865c40cf876709328a36402cefaa07cc865c407b319413ed8a3640f3380ce6af865c402d05a4fd0f8c3640 |
  22. +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  23. 1 row in set (0.02 sec)

keywords

ST_ASBINARY,ST,ASBINARY