[postgis-users] Size of geometry issue

[Shaozhong SHI]

Regina,

What is the robust way to do the following?

If exists (select * from t) then
    insert into a_table select * from t
End if;


This is trying to not to insert with no content.

Regards,

David

On Wed, 9 Aug 2023 at 15:04, Regina Obe <lr at pcorp.us> wrote:

> 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> 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
>
> _______________________________________________
> 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/ead84114/attachment.htm>