Re: [postgis-users] a question about post gis

2018-12-05 Thread James Keener
Are you asking how to fill a polygon with circles of a fixed radius? I'm not sure there is in general a unique solution for that or that PostGIS is the best tool for the job. I'm sure someone could make postgis figure it out, but I can't imagine a clean way of doing it (in an optimal) fashion, and

[postgis-users] a question about post gis

2018-12-05 Thread Mahdi Kalhor
Hello. I have read the documentation of post gis and i could not find the answer of my question. I want to pass a polygon to post gis and get the list of circles with radius=500 meters which can fill that polygon. I need to find the center of those circles. I need this for educational purpose for o

Re: [postgis-users] Improvement suggestion

2018-12-05 Thread Paul Ramsey
Forgot to include my reference [1] https://commitfest.postgresql.org/21/1868/ On Wed, Dec 5, 2018 at 11:19 AM Paul Ramsey wrote: > > > On Tue, Dec 4, 2018 at 2:27 AM Darafei "Komяpa" Praliaskouski < > m...@komzpa.net> wrote: > >> If you are managing large geometries, splitting them off into "geo

Re: [postgis-users] Improvement suggestion

2018-12-05 Thread Paul Ramsey
On Tue, Dec 4, 2018 at 2:27 AM Darafei "Komяpa" Praliaskouski wrote: > If you are managing large geometries, splitting them off into "geometry > table" with non-uniquie ID and subdivided parts sometimes helps. > You want to build a tree on top of your geometry internals to make it all > fast, one

Re: [postgis-users] Postgis upgrade from 2.4.6 to 2.5

2018-12-05 Thread Ahsan Hadi
On Wed, Dec 5, 2018 at 3:55 PM Darafei "Komяpa" Praliaskouski wrote: > Hi Ashan, > > PostGIS 2.4.6 was released after PostGIS 2.5.0. You need to upgrade to > 2.5.1 that was released after 2.4.6. > Okay so they will upgrade to postgis 2.5.1 from postgis 2.4.6? > On Wed, Dec 5, 2018 at 1:50 PM A

Re: [postgis-users] Postgis upgrade from 2.4.6 to 2.5

2018-12-05 Thread Ahsan Hadi
Thanks Darafei. On Wed, Dec 5, 2018 at 3:55 PM Darafei "Komяpa" Praliaskouski wrote: > Hi Ashan, > > PostGIS 2.4.6 was released after PostGIS 2.5.0. You need to upgrade to > 2.5.1 that was released after 2.4.6. > > On Wed, Dec 5, 2018 at 1:50 PM Ahsan Hadi > wrote: > >> Hi Regina, >> >> Do you

Re: [postgis-users] Postgis upgrade from 2.4.6 to 2.5

2018-12-05 Thread Komяpa
Hi Ashan, PostGIS 2.4.6 was released after PostGIS 2.5.0. You need to upgrade to 2.5.1 that was released after 2.4.6. On Wed, Dec 5, 2018 at 1:50 PM Ahsan Hadi wrote: > Hi Regina, > > Do you know if a user running postgis 2.4.6 with PG 11 can upgrade to > postgis 2.5 with v11 using the alter ex

[postgis-users] Postgis upgrade from 2.4.6 to 2.5

2018-12-05 Thread Ahsan Hadi
Hi Regina, Do you know if a user running postgis 2.4.6 with PG 11 can upgrade to postgis 2.5 with v11 using the alter extension command? We are currently seeing the error below, this could be a setup issue but i wanted to confirm whether this upgrade path is officially supported. db1=# ALTER EXTE