On Wed, 9 Aug 2023 at 04:30, Regina Obe <[email protected]> wrote: > What is output of your > > > > SELECT postgis_full_version(); >
It is: POSTGIS="3.1.9 95a641b" [EXTENSION] PGSQL="130" GEOS="3.10.3-CAPI-1.16.1" SFCGAL="1.3.1" PROJ="7.2.1" LIBXML="2.9.1" LIBJSON="0.11" (core procs from "3.1.4 ded6c34" need upgrade) (sfcgal procs from "3.1.4 ded6c34" need upgrade) Regards, David > > > > > *From:* postgis-users [mailto:[email protected]] *On > Behalf Of *Shaozhong SHI > *Sent:* Tuesday, August 8, 2023 6:49 PM > *To:* PostGIS Users Discussion <[email protected]> > *Subject:* Re: [postgis-users] Size of geometry issue > > > > Hi, Regina, > > It did not work. > > Regards, David > > On Tuesday, 8 August 2023, Regina Obe <[email protected]> wrote: > > Are you running GEOS > 3.9. > > > > If so maybe ST_Union with a gridsize might work better for you needs over > ST_Collect > > > > https://postgis.net/docs/ST_Union.html > > > > There are also a number of precision reduction functions > > > > https://postgis.net/docs/ST_SimplifyPreserveTopology.html > > https://postgis.net/docs/ST_SnapToGrid.html > > > > come to mind > > > > > > > > *From:* postgis-users [mailto:[email protected]] *On > Behalf Of *Shaozhong SHI > *Sent:* Tuesday, August 8, 2023 5:46 PM > *To:* PostGIS Users Discussion <[email protected]> > *Subject:* [postgis-users] Size of geometry issue > > > > St_collect is used and size issue may cause the problem. > > > > If just their relationship needs to be depicted, how can the size of > geometry be reduced? > > > > Regards, > > > > David > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
