Re: Help with a query
Erik Wienhold <[email protected]>
| Newsgroups | gmane.comp.gis.postgis |
|---|---|
| Message-ID | <[email protected]> |
On 2024-12-22 15:44 +0100, Luca Bertoncello wrote: > > I suppose, in the last versions of PostGIS the Function ST_Makevalid > > will return something other than in the previous one. > > Some information more... > > It seems, in some cases, the function ST_Makevalid returns > ST_GeometryCollection instead of ST_MultiPolygon... > Why?!? See "dimensional collapse" on https://postgis.net/docs/ST_MakeValid.html ST_MakeValid creates (multi)linestring and/or (multi)point geometries in your case. You can also try the structure algorithm with params 'method=structure keepcollapsed=false' and avoid ST_CollectionExtract. But the linework and structure algorithms do not necessarily return the same geometries, see the examples in the ST_MakeValid docs. -- Erik Wienhold
signature.asc
(application/pgp-signature, 228 B)
-----BEGIN PGP SIGNATURE----- iHUEABYKAB0WIQTrpgM9YmnkeLyXPT5a1S8BOxjdPAUCZ2iv0QAKCRBa1S8BOxjd PFZmAP9Tb+nl0e3aMLo/4oAxl30wQJRHvNuvEG4vSd2YTiQtAQD/ef1sggtMXHJq eVjWz2s9Pm1W/w8agkfSeLEkKSNHxgQ= =LxUF -----END PGP SIGNATURE-----