[postgis-users] Size of geometry issue

[Shaozhong SHI]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230808/8b631912/attachment.htm>