Re: [postgis-users] generate a geometry column of random point, line and polygon

2023-09-12 Thread Imre Samu
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

Re: [postgis-users] generate a geometry column of random point, line and polygon

2023-09-11 Thread Regina Obe
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

Re: [postgis-users] generate a geometry column of random point, line and polygon

2023-09-11 Thread Shaozhong SHI
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

Re: [postgis-users] generate a geometry column of random point, line and polygon

2023-09-11 Thread Regina Obe
(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

Re: [postgis-users] generate a geometry column of random point, line and polygon

2023-09-11 Thread Shaozhong SHI
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

Re: [postgis-users] generate a geometry column of random point, line and polygon

2023-09-08 Thread Regina Obe
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

Re: [postgis-users] generate a geometry column of random point, line and polygon

2023-09-08 Thread Shaozhong SHI
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 > *

Re: [postgis-users] generate a geometry column of random point, line and polygon

2023-09-08 Thread Regina Obe
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

[postgis-users] generate a geometry column of random point, line and polygon

2023-09-08 Thread Shaozhong SHI
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