Skip to main content
It works the same as ST_ExtentBasedSubDivide but returns new rows with geometries instead of list. ST_ExtentBasedSubDivideExplode

​
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)                                                |
+-----------------------------------------------------------------------------------------------------+