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

2016-09-27 Thread Matthew Baker
All, Thanks to Russel Mercer who corrected my logic - this works great, and we'll be implementing this for several sets of map label placement! (see response below). Regarding Richard Greenwood's suggestion that we use geometry to store the label placement - in theory and a bit of practice,

Re: [postgis-users] "non intersecting node" error when using st_node ?!

2016-09-27 Thread Sandro Santilli
On Tue, Sep 27, 2016 at 07:55:46AM -0500, Mathias Versichele wrote: > Hi all, > > I've been struggling with "non intersecting node" issues when trying to run > st_node, which seems weird to me as st_node is supposed to fix these issues > in the first place, right ? > > The following table dump

[postgis-users] "non intersecting node" error when using st_node ?!

2016-09-27 Thread Mathias Versichele
Hi all, I've been struggling with "non intersecting node" issues when trying to run st_node, which seems weird to me as st_node is supposed to fix these issues in the first place, right ? The following table dump illustrates the problem: https://we.tl/d3WwOv2AFv When running the following

Re: [postgis-users] help with a query

2016-09-27 Thread Birgit Laggner
Hi Jonatan, I am glad I could help. Have success with the tweaking! Regards, Birgit Am 26.09.2016 um 14:24 schrieb Jonatan Malaver: Hi Birgit, thank you so much!! your code put me on the right track. I'm still tweaking it a bit since your code assumes only 1 line is attached to the endpoint.