[postgis-users] linked point and polygon tables
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:
> 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