[postgis-users] Size of geometry issue

[Regina Obe]

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:postgis-users-bounces at lists.osgeo.org] On Behalf Of Shaozhong SHI
Sent: Wednesday, August 9, 2023 1:40 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] Size of geometry issue

 

 

 

On Wed, 9 Aug 2023 at 04:30, Regina Obe <lr at pcorp.us <mailto: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 <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 <mailto: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

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto: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/8d116c51/attachment.htm>