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

[Tim Sutton]

Hi Denis


> Are you looking for st_force3d?
> https://postgis.net/docs/ST_Force_3D.html <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 <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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190420/23fff224/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/23fff224/attachment.jpg>