Re: [postgis-users] Creating an 'editable' view in PostGIS

Why not just have two geometry columns in one table? One column for the actual geometry and another for the label. On Fri, Sep 16, 2016 at 2:36 PM, Matthew Baker wrote: > Hi all, > > I've asked this on GIS.SE, to no avail: > > I'd like to store label placement properties in

Re: [postgis-users] Creating an 'editable' view in PostGIS

Matt, It looks like you are on the right track with your view and rules setup. I think your primary issue may be that each of the rules is trying to act on the view to do the insert, update, delete, as opposed to acting on the underlying table. For example, instead of this: --delete rulecreate

[postgis-users] Creating an 'editable' view in PostGIS

Hi all, I've asked this on GIS.SE, to no avail: I'd like to store label placement properties in a separate table, build a view of the data I want to use for my map, and use QGIS to move the labels manually. The idea is when the labels are updated, the placement coordinates would go into the