[postgis-users] MakeLine into new layer

2018-10-22 Thread Shane Carey
Hi, I am trying to find the longest line of a polygon and insert it into a new line. I can create the makeline as in the code below but cannot create a new layer out of it using the INTO keyword. Any help would be appreciated. Thanks SELECT ST_MakeLine(St_LongestLine( (SELECT geom FROM floo

Re: [postgis-users] geom

2018-10-22 Thread Shane Carey
Super - thanks a lot Hugues. That helped me a lot - thanks :) Le gach dea ghui, *Shane Carey* *GIS and Data Solutions Consultant* On Thu, Oct 18, 2018 at 10:43 PM Hugues François wrote: > Hello, > > It looks like an st_dump output composed of ({path},{geom}). If you want > to retrieve the geome

Re: [postgis-users] PostGIS - Migration case from 9.3/2.1 to 10.5/2.5

2018-10-22 Thread Komяpa
Hi, I keep a gist with upgrading tldr: https://gist.github.com/Komzpa/994d5aaf340067ccec0e You can notice most upgrades are similar and can be done by analogy. Versions 2.1 and 2.5 have 5 years between them, so there are quite a lot of small changes. However, if you weren't using weird tricks, th

[postgis-users] PostGIS - Migration case from 9.3/2.1 to 10.5/2.5

2018-10-22 Thread Daniel Boulerice
Is there a document highlighting the caveats of migrating * From Postgres 9.3 + PostGIS 2.1 * To Postgres 10.5 + PostGIS 2.5 I guess the best way is to migrate the data only because the functions included in the dump cause errors. Caterpillar: Confidential Green __