[postgis-users] Size of geometry issue

[Regina Obe]

What is output of your

 

SELECT postgis_full_version();

 

 

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 <mailto: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 <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 <mailto: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/0ca7931b/attachment.htm>