Hi Regina, I think I found the answer. It is not because it is too big. It is it returned nothing to be inserted. The message is rather miss-leading. I put on test run. Hopefully I get confirmation tomorrow. Regards, David
On Wednesday, 9 August 2023, Regina Obe <[email protected]> wrote: > Your version should have those functions available since these functions > came in PostGIS 3.1 and your GEOS is newer than 3.9 > > > > https://postgis.net/docs/manual-3.2/ST_Union.html > > > > Do you get an error when you run ST_Union with a gridsize? If so maybe > your GEOS might be newer but you compiled with a lower version of GEOS. > > > > *From:* postgis-users [mailto:[email protected]] *On > Behalf Of *Shaozhong SHI > *Sent:* Wednesday, August 9, 2023 1:40 AM > *To:* PostGIS Users Discussion <[email protected]> > *Subject:* Re: [postgis-users] Size of geometry issue > > > > > > > > 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
