ST_GEOMETRYFROMWKB
更新时间：2025-10-17
描述
将一个标准图形 WKB（Well-known binary）转化为对应的内存的几何形式
别名
- ST_GEOMFROMWKB
语法
SQL
1ST_GEOMETRYFROMWKB( <wkb>)参数
| 参数 | 说明 |
|---|---|
<wkb> |
图形的内存形式 |
返回值
WKB 的对应的几何存储形式
举例
SQL
1select ST_AsText(ST_GeometryFromWKB(ST_AsBinary(ST_Point(24.7, 56.7))));
Text
1+------------------------------------------------------------------+
2| st_astext(st_geometryfromwkb(st_asbinary(st_point(24.7, 56.7)))) |
3+------------------------------------------------------------------+
4| POINT (24.7 56.7) |
5+------------------------------------------------------------------+
SQL
1select ST_AsText(ST_GeomFromWKB(ST_AsBinary(ST_Point(24.7, 56.7))));
Text
1+--------------------------------------------------------------+
2| st_astext(st_geomfromwkb(st_asbinary(st_point(24.7, 56.7)))) |
3+--------------------------------------------------------------+
4| POINT (24.7 56.7) |
5+--------------------------------------------------------------+
SQL
1select ST_AsText(ST_GeometryFromWKB(ST_AsBinary(ST_GeometryFromText("LINESTRING (1 1, 2 2)"))));
Text
1+------------------------------------------------------------------------------------------+
2| st_astext(st_geometryfromwkb(st_asbinary(st_geometryfromtext('LINESTRING (1 1, 2 2)')))) |
3+------------------------------------------------------------------------------------------+
4| LINESTRING (1 1, 2 2) |
5+------------------------------------------------------------------------------------------+
SQL
1select ST_AsText(ST_GeometryFromWKB(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))"))));
Text
1+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2| st_astext(st_geometryfromwkb(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))')))) |
3+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4| POLYGON ((114.104486 22.547119, 114.093758 22.547753, 114.096504 22.532057, 114.104229 22.539826, 114.106203 22.54268, 114.104486 22.547119)) |
5+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SQL
1select ST_AsText(ST_GeomFromWKB(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))"))));
Text
1+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2| st_astext(st_geomfromwkb(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))')))) |
3+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4| POLYGON ((114.104486 22.547119, 114.093758 22.547753, 114.096504 22.532057, 114.104229 22.539826, 114.106203 22.54268, 114.104486 22.547119)) |
5+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+