[postgis-users] Size of geometry issue

[Regina Obe]

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/747710bf/attachment.htm>