t; SELECT min(gs) , max(gs),
> st_optimalalphashape(st_collect(ST_MakePoint(random()*10,random()*10)) )
>
> from generate_series(1,100) gs;
>
>
>
> *From:* postgis-users *On Behalf
> Of *Shaozhong SHI
> *Sent:* Monday, September 11, 2023 3:21 AM
> *To:* PostGIS Users
Behalf Of
Shaozhong SHI
Sent: Monday, September 11, 2023 3:36 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] generate a geometry column of random point, line
and polygon
Hi, Regina,
It did not work.
ERROR: function st_optimalalphashape(geometry) does not exist LINE 1: SELECT
nt:* Monday, September 11, 2023 3:21 AM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] generate a geometry column of random
> point, line and polygon
>
>
>
> I tested St_optimalphashape and it does not work.
>
>
>
> select gs,
> st_optimalalphashape
(st_collect(ST_MakePoint(random()*10,random()*10)) )
from generate_series(1,100) gs;
From: postgis-users On Behalf Of
Shaozhong SHI
Sent: Monday, September 11, 2023 3:21 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] generate a geometry column of random point, line
and polygon
1000);
>
>
>
>
>
> If you want to generate random polygons, you could use ST_ConcaveHull or
> ST_AlphaShape around the section of a polygon you did a ST_GeneratePoints on
>
>
>
> And then use something like https://postgis.net/docs/en/ST_Subdivide.html
> to chop up t
ong SHI
Sent: Friday, September 8, 2023 10:54 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] generate a geometry column of random point, line
and polygon
The simplicity is beautiful. Any simple script to do so? I think that will be
an useful addition.
Regards,
David
On Frid
et a linestring out of that (It will be closed), you can take the
> boundary of any of the above
>
>
>
> https://postgis.net/docs/ST_Boundary.html
>
>
>
> Hope that helps,
>
> Regina
>
>
>
> *From:* postgis-users *On Behalf
> Of *Shaozhong SHI
> *
of any of the above
https://postgis.net/docs/ST_Boundary.html
Hope that helps,
Regina
From: postgis-users On Behalf Of
Shaozhong SHI
Sent: Friday, September 8, 2023 7:56 AM
To: PostGIS Users Discussion
Subject: [postgis-users] generate a geometry column of random point, line and
polygon
Is a simple way to do this?
Regards,
David
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users