[postgis-users] geometry type issue

Shaozhong SHI shishaozhong at gmail.com
Mon Apr 27 03:29:23 PDT 2020

I added a new column.

alter table a_table add column geom geometry(Polygon, 27700);


update a_table set geom = (select ST_ConcaveHull(ST_Collect(geom), 0.99)
from b_table where name = _name) where name = _name;

It kept throwing up an error message saying: "geometry type point does not
match polygon".

I thought that a concavehyll is a polygon.  That is why I created a polygon
column for it.

Can anyone help?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200427/fcee4ba5/attachment.html>

More information about the postgis-users mailing list