Name
ST_Summary — 返回几何图形内容的文本摘要。
Synopsis
text ST_Summary(geometry g);
text ST_Summary(geography g);
描述
返回几何图形内容的文本摘要。
几何图形类型后面的方括号显示的标志具有以下含义：
M：有M坐标
Z：具有Z坐标
B：具有缓存的边界框
G：是大地(地理)的吗？
S：有空间参照系
This method supports Circular Strings and Curves
This function supports Polyhedral surfaces.
This function supports Triangles and Triangulated Irregular Network Surfaces (TIN).
可用性：1.2.2
增强：2.0.0添加了对地理位置的支持
增强：2.1.0 S标志，表示是否具有已知的空间参考系统
增强：2.2.0添加了对三角网和曲线的支持
示例
=# SELECT ST_Summary(ST_GeomFromText('LINESTRING(0 0, 1 1)')) as geom,
ST_Summary(ST_GeogFromText('POLYGON((0 0, 1 1, 1 2, 1 1, 0 0))')) geog;
geom | geog
-----------------------------+--------------------------
LineString[B] with 2 points | Polygon[BGS] with 1 rings
| ring 0 has 5 points
:
(1 row)
=# SELECT ST_Summary(ST_GeogFromText('LINESTRING(0 0 1, 1 1 1)')) As geog_line,
ST_Summary(ST_GeomFromText('SRID=4326;POLYGON((0 0 1, 1 1 2, 1 2 3, 1 1 1, 0 0 1))')) As geom_poly;
;
geog_line | geom_poly
-------------------------------- +--------------------------
LineString[ZBGS] with 2 points | Polygon[ZBS] with 1 rings
: ring 0 has 5 points
:
(1 row)