[postgis-users] linked point and polygon tables

Sandro Santilli strk at keybit.net
Wed Apr 11 23:48:36 PDT 2012

On Wed, Apr 11, 2012 at 10:03:43PM +0200, Piotr Pachół wrote:
> Hello,
> Suppose we have in PostGIS  table with point geometry, ID column and
> some other attributes.
> Is it possible to create table with polygon/polyline geometry which
> is linked to table with point geometry ?
> I mean such a link where:
> - geometry of polygon/polyline is not created by set of coordinates
> but is created by (refering to) set of ID's from point table,
> - when some point object (from point geometry table) is removed it
> should automatically influence the shape of polygon/polyline.

You could make your referee a view using ST_MakePolygon/ST_MakeLine


  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com

More information about the postgis-users mailing list