All Products
Search
Document Center

ApsaraDB RDS:ST_boundingDiagonalGeometry

Last Updated:Sep 08, 2023

This function returns the diagonal of the bounding box of a pcpatch object as a geometry object.

Syntax

geometry ST_boundingDiagonalGeometry(pcpatch pc);

Parameters

Parameter

Description

pc

The pcpatch object.

Description

The diagonal of a bounding box is a 2D linestring object of Ganos Geometry. This function can be used to create an index on a pcpatch object column.

Examples

SELECT ST_AsText(ST_BoundingDiagonalGeometry(pa)) FROM patches;
                          st_astext
--------------------------------------------------------------
 LINESTRING Z (-126.60000000000001 45.4 40,-126.51 45.49 49)
 LINESTRING Z (-126.99000000000001 45.01 1,-126.91 45.09 9)
 LINESTRING Z (-126 46 100,-126 46 100)
 LINESTRING Z (-126.4 45.6 60,-126.31 45.69 69)
 LINESTRING Z (-126.8 45.2 20,-126.71000000000001 45.29 29)
 LINESTRING Z (-126.10000000000001 45.9 90,-126.01 45.99 99)
 LINESTRING Z (-126.3 45.7 70,-126.21000000000001 45.79 79)
 LINESTRING Z (-126.7 45.300000000000004 30,-126.61 45.39 39)
 LINESTRING Z (-126.9 45.1 10,-126.81 45.19 19)
 LINESTRING Z (-126.5 45.5 50,-126.41 45.59 59)
 LINESTRING Z (-126.2 45.800000000000004 80,-126.11 45.89 89)
(11 rows)

CREATE INDEX ON patches USING GIST(ST_BoundingDiagonalGeometry(pa) gist_geometry_ops_nd);