Re: [postgis-users] ST_SimplifyPreserveTopology creates invalid geometry

On Tue, Mar 10, 2020 at 10:19 AM Paul van der Linden < paul.doskabou...@gmail.com> wrote: > > And what about ST_MakeValid converting that hole into an outerring instead > of just discarding it? > Is that something that's worth a discussion? > Yes, that's a hard call. In this case it seems "obvio

Re: [postgis-users] ST_SimplifyPreserveTopology creates invalid geometry

ST_MakeValid by definition does anything it likes, the only thing that should happen: output is valid and no vertices are lost. The "no vertices are lost" forbids to discard the hole. If MakeValid will change behavior there it will stop being useful for "inners and outers are marked incorrectly" ca

Re: [postgis-users] ST_SimplifyPreserveTopology creates invalid geometry

> This is a known bug in the Topology-Preserving Simplfier. For instance see > https://github.com/locationtech/jts/issues/428 > > I'll add your example to the ticket. Hopefully this can be fixed sometime > soon. Thanks! And what about ST_MakeValid converting that hole into an outerring instead o

Re: [postgis-users] gdal version for Postgis 2.4

Markus, How many PostgreSQL versions do you have installed? And do you use gdal for anything besides PostgreSQL? > -Original Message- > From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On > Behalf Of Zwettler Markus (OIZ) > Sent: Tuesday, March 10, 2020 5:23 AM > To:

Re: [postgis-users] Help with SQL

Thanks Felix! Från: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] För Felix Kunde Skickat: den 9 mars 2020 10:33 Till: postgis-users@lists.osgeo.org Kopia: postgis-users@lists.osgeo.org Ämne: Re: [postgis-users] Help with SQL Hi Paul, no need for subqueries here. Do a spatial joi

Re: [postgis-users] Help with SQL

Thanks Martin! Från: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] För Martin Davis Skickat: den 9 mars 2020 18:39 Till: PostGIS Users Discussion Ämne: Re: [postgis-users] Help with SQL A slight correction to the SQL (JOINs need an ON condition, which in this case is simply TRUE)

Re: [postgis-users] gdal version for Postgis 2.4

[root@tstm49003 lib]# rpm -aq | grep postgis postgis24_96-2.4.8-7.rhel7.x86_64 postgis24_96-client-2.4.8-7.rhel7.x86_64 [root@tstm49003 lib]# rpm -aq | grep gdal gdal-libs-1.11.4-12.rhel7.x86_64 gdal23-libs-2.3.2-8.rhel7.x86_64 gdal30-libs-3.0.4-2.rhel7.x86_64 [root@tstm49003 lib]# rpm -e gdal30-li