ST_ExtentBasedSubDivideExplode

It works the same as ST_ExtentBasedSubDivide but returns new rows with geometries instead of list.

Signatures

ST_ExtentBasedSubDivideExplode(geom: Geometry, maxWidth: Double, maxHeight: Double)

ST_ExtentBasedSubDivideExplode(geom: Geometry, maxWidth: Double, maxHeight: Double, algorithms: String)

ST_ExtentBasedSubDivideExplode(geom: Geometry, maxWidth: Double, maxHeight: Double, maxVertices: Integer, maxDepths, algorithms: String)

Parameters

geom

Geometry

required

The input geometry.

maxWidth

Double

required

The max width value.

maxHeight

Double

required

The max height value.

maxVertices

Integer

The maximum number of vertices.

maxDepths

Integer

The maximum recursion depth for subdivision.

algorithms

String

The algorithms value.

Example

SELECT ST_ExtentBasedSubDivideExplode(ST_GeomFromText("LINESTRING(0 0, 85 85, 100 100, 120 120, 21 21, 10 10, 5 5)"), 30, 30)

+-----------------------------------------------------------------------------------------------------+
|geom                                                                                                 |
+-----------------------------------------------------------------------------------------------------+
|LINESTRING (0 0, 21.213203435596427 21.213203435596427)                                              |
|LINESTRING (21.213203435596427 21.213203435596427, 42.42640687119285 42.42640687119285)              |
|LINESTRING (42.42640687119285 42.42640687119285, 63.63961030678928 63.63961030678928)                |
|LINESTRING (63.63961030678928 63.63961030678928, 84.8528137423857 84.8528137423857)                  |
|LINESTRING (84.8528137423857 84.8528137423857, 85 85, 100 100, 106.06601717798213 106.06601717798213)|
|LINESTRING (106.06601717798213 106.06601717798213, 120 120, 112.72077938642144 112.72077938642144)   |
|LINESTRING (112.72077938642144 112.72077938642144, 91.50757595082501 91.50757595082501)              |
|LINESTRING (91.50757595082501 91.50757595082501, 70.29437251522859 70.29437251522859)                |
|LINESTRING (70.29437251522859 70.29437251522859, 49.08116907963216 49.08116907963216)                |
|LINESTRING (49.08116907963216 49.08116907963216, 27.86796564403574 27.86796564403574)                |
|LINESTRING (27.86796564403574 27.86796564403574, 21 21, 10 10, 6.654762208439314 6.654762208439314)  |
|LINESTRING (6.654762208439314 6.654762208439314, 5 5)                                                |
+-----------------------------------------------------------------------------------------------------+

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

ST_ExtentBasedSubDivideExplode

Signatures

Parameters

Example

​Signatures

​Parameters

​Example

Signatures

Parameters

Example