[postgis-users] Size of geometry issue

[Shaozhong SHI]

Best option is to add a check on column sizes.

Regards,

David

On Wed, 9 Aug 2023 at 21:39, Shaozhong SHI <shishaozhong at gmail.com> wrote:

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