[postgis-users] Size of geometry issue

[Shaozhong SHI]

On Wed, 9 Aug 2023 at 04:30, Regina Obe <lr at pcorp.us> 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:postgis-users-bounces at lists.osgeo.org] *On
> Behalf Of *Shaozhong SHI
> *Sent:* Tuesday, August 8, 2023 6:49 PM
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *Subject:* Re: [postgis-users] Size of geometry issue
>
>
>
> Hi, Regina,
>
> It did not work.
>
> Regards, David
>
> On Tuesday, 8 August 2023, Regina Obe <lr at pcorp.us> 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:postgis-users-bounces at lists.osgeo.org] *On
> Behalf Of *Shaozhong SHI
> *Sent:* Tuesday, August 8, 2023 5:46 PM
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *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
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230809/12c731ae/attachment.htm>