Name
ST_Summary — Returns a summary of a Geometry object characteristics.
Synopsis
varchar ST_Summary(bytea
Geometry);
Description
Returns a summary of a geometry object characteristics. This includes kind of Geometry, coordinate dimensions ([B],[ZB],[ZMB]), constituent elements and SRID.
Coordinate Dimensions
| 2D | 3D | M |
|---|---|---|
 | | |
Spatial Standards Support
| OGC SFS for SQL. 1.1 (1999) | OGC SFS for SQL. 1.1.0 (2005) | OGC SFS for SQL. 1.2.0 (2006)) | SQL-MM Part 3 |
|---|---|---|---|
| - | - | - | - |
Examples
SELECT ST_Summary(ST_GeomFromText('POINT(0 0 15 -2)',25830));
--Result
Point [ZMB] [SRID=25830]
SELECT ST_Summary(ST_GeomFromText('MULTILINESTRING ((0 0, 10 10, 20 10),(30 30, 50 40))'));
--Result
MultiLineString [B] with 2 element/s [SRID=-1]
Line [B] with 3 points [SRID=-1]
Line [B] with 2 points [SRID=-1]
SELECT ST_Summary(ST_GeomFromText('POLYGON ((0 0, 0 10, 10 10, 10 0, 0 0),(5 0, 0 5, 5 5, 5 0))',4326));
--Result
Polygon [B] with 2 ring/s [SRID=4326]
ring 0 has 5 points [SRID=4326]
ring 1 has 4 points [SRID=4326]