[postgis-users] Converting a Polygon geometry column to PolygonZ

[Denis Rouzaud]

Hi Tim,
I don't think this is possible
https://www.postgresql.org/message-id/CAB7nPqTLmMn1LTb5WE0v0dO57iP0U73yKwzbZytAXDF1CAWLZg@mail.gmail.com

I hope you can count the dependent views with your fingers of the 2 hands ;)

Denis

Le sam. 20 avr. 2019 à 17:33, Tim Sutton <tim at kartoza.com> a écrit :

> Hi Denis
>
>
> Are you looking for st_force3d?
> https://postgis.net/docs/ST_Force_3D.html
>
>
>
> Thanks for your reply.  Yeah I have a process working like this:
>
> DROP VIEW vw_aoi;
> DROP VIEW vw_boundary;
> ALTER TABLE camps
>     ALTER COLUMN geom TYPE geometry(PolygonZ,20790) USING
> ST_Force3D(geom);
> CREATE VIEW vw_boundary AS  SELECT 1,
>     st_union(camps.geom) AS geom
>    FROM camps;
> CREATE VIEW vw_aoi AS  SELECT 1 AS id,
>     st_buffer(st_envelope(vw_boundary.geom), 50::double precision) AS geom
>    FROM vw_boundary;
>
> I was more wondering if there is a way to do the update of the geometry
> type without having to drop all related views etc. and restore them again?
>
> Regards
>
> Tim
> —
>
>
>
>
>
>
>
>
> *Tim Sutton*
>
> *Co-founder:* Kartoza
> *Ex Project chair:* QGIS.org
>
> Visit http://kartoza.com to find out about open source:
>
> Desktop GIS programming services
> Geospatial web development
> GIS Training
> Consulting Services
>
> *Skype*: timlinux
> *IRC:* timlinux on #qgis at freenode.net
>
> I'd love to connect. Here's my calendar link
> <https://calendly.com/timlinux> to make finding time easy.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Denis Rouzaud
denis at opengis.ch  <denis at opengis.ch>
+41 76 370 21 22 <+41763702122>
[image: OPENGIS.ch Logo] <https://www.opengis.ch>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190420/21ec0319/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: KartozaNewLogoThumbnail.jpg
Type: image/jpeg
Size: 6122 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190420/21ec0319/attachment.jpg>