[postgis-users] Trigger on PostGIS line layer occurs twice

Using this tutorial, I've established a SQL trigger in order to track changes on a PostGIS layer. It works great for a point layer. However, using the script below, it causes problems with line layer, as all of the t

Re: [postgis-users] PostGIS new geometry type with defined precision?

We're still at least a month out from having PostGIS code to release, but once it's out feedback will be appreciated. On Wed, Jul 3, 2019, 8:21 AM Giunta Igor wrote: > Thanx Martin > > it sounds promising.. can we somehow give any help at this conceptual > stage? > > > > > > *Von:* postgis-users

Re: [postgis-users] PostGIS new geometry type with defined precision?

Thanx Martin it sounds promising.. can we somehow give any help at this conceptual stage? Von: postgis-users Im Auftrag von Martin Davis Gesendet: Mittwoch, 3. Juli 2019 16:54 An: PostGIS Users Discussion Betreff: Re: [postgis-users] PostGIS new geometry type with defined precision? JTS alrea

Re: [postgis-users] PostGIS new geometry type with defined precision?

Hi Darafei and Paul thanx for your feedback. I see your points for those "clinical cases", but let me answer like this: 1) concernig bugous intersection: the result will always be uncertain beyond resolution. Consider the same situation with 10 digit resolution. you won't be able to say w

Re: [postgis-users] PostGIS new geometry type with defined precision?

JTS already provided a mechanism to specify a precision for geometry, and this is respected by a number of operations as well (notably the overlay operations intersection et al and buffer - but not the spatial predicates, yet). GEOS should provide this as well, or is close to doing so. And I'm cu

Re: [postgis-users] PostGIS new geometry type with defined precision?

Also, what are the results of ST_Distance() when the distance is < tolerance? Zero? Tolerance? Basically tolerance is a cross-cutting concern that affects almost every function in the system, sometimes in ways that ordinary users might consider “surprising” or “counter intuitive”. Our current “a

Re: [postgis-users] PostGIS new geometry type with defined precision?

Hi, Can you describe how the operations like Intersection should behave in such type? E.g. if you have a type with 0 decimals (say), and have a line going from (0,0) to (1,1) intersect with a line going from (1, 0) to (0, 1) - what is the intersection point that is going to be reported? Will that

[postgis-users] PostGIS new geometry type with defined precision?

How can a precision be assigned to a geometry, e.g. a point/line/polygon to 3 decimals, in order that any input/output will be given in that precision (without usage of rounding functions like snap2grid) How can the problem be tackeld? Shall we request to include new types? Or shall we rather le