<div dir="ltr">Yes, the plan is to port the new overlay code to GEOS, and then expose it in PostGIS. The function design suggested in Dan's previous work seems reasonable, so the new PostGIS overlay functions will probably look like that.<div><br></div><div>I'm making good progress on the code. Still hoping for an early fall arrival in GEOS and PostGIS.</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jul 15, 2019 at 12:21 AM Giunta Igor <<a href="mailto:Igor.Giunta@tg.ch">Igor.Giunta@tg.ch</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="DE-CH">
<div class="gmail-m_-4817165288048246853WordSection1">
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Hi Martin<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I just found some exchanges here:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="http://osgeo-org.1560.x6.nabble.com/Fixed-precision-for-ST-Intersection-ST-Union-etc-td5255487.html" target="_blank">http://osgeo-org.1560.x6.nabble.com/Fixed-precision-for-ST-Intersection-ST-Union-etc-td5255487.html</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">In the meanwhile GEOS3.6 has been sent out with GEOSGeom_{set,get}Precision according to
<u></u><u></u></span></p>
<p class="MsoNormal" style="text-align:justify"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="http://osgeo-org.1560.x6.nabble.com/GEOS-3-6-0-released-td5292606.html" target="_blank">http://osgeo-org.1560.x6.nabble.com/GEOS-3-6-0-released-td5292606.html</a><u></u><u></u></span></p>
<p class="MsoNormal" style="text-align:justify"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-align:justify"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">On the PostGIS side I don't find any correspndance.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Is your work going to integrate this GEOS functions into PosGIS or your approach is independent?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="DE" style="font-size:11pt;font-family:Calibri,sans-serif">Von:</span></b><span lang="DE" style="font-size:11pt;font-family:Calibri,sans-serif"> postgis-users <<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Martin Davis<br>
<b>Gesendet:</b> Mittwoch, 3. Juli 2019 18:02<br>
<b>An:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
<b>Betreff:</b> Re: [postgis-users] PostGIS new geometry type with defined precision?<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">We're still at least a month out from having PostGIS code to release, but once it's out feedback will be appreciated. <u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Jul 3, 2019, 8:21 AM Giunta Igor <<a href="mailto:Igor.Giunta@tg.ch" target="_blank">Igor.Giunta@tg.ch</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Thanx Martin</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">it sounds promising.. can we somehow give any help at this conceptual stage?</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="FR-CH" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span lang="DE" style="font-size:11pt;font-family:Calibri,sans-serif">Von:</span></b><span lang="DE" style="font-size:11pt;font-family:Calibri,sans-serif"> postgis-users
<<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Martin Davis<br>
<b>Gesendet:</b> Mittwoch, 3. Juli 2019 16:54<br>
<b>An:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
<b>Betreff:</b> Re: [postgis-users] PostGIS new geometry type with defined precision?</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal">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 currently working on a new implementation of overlay to improve robustness, which will improve fixed precision computation as well. <u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">The issue of handling fixed precision for predicates is a good question. I have an algorithm in the conceptual stages for this. But it may be difficult to make it consistent with
the overlay operations on a performant way. I intend to write up a survey of the options soon.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">My current thinking is that precision will be specified as a parameter to geometry operations. No new type will be required. It might be nice to have precision specified in column
metadata somehow, but not sure how this could work <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Jul 3, 2019, 5:48 AM Darafei "Komяpa" Praliaskouski <<a href="mailto:me@komzpa.net" target="_blank">me@komzpa.net</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt">
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">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 ST_Intersection in turn ST_Intersects=true with original point?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">There are a number of such requests across the years but nobody seems to propose a working algebra for such type, and without it it's not going to get implemented.<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Jul 3, 2019 at 2:43 PM Giunta Igor <<a href="mailto:Igor.Giunta@tg.ch" target="_blank">Igor.Giunta@tg.ch</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt">
<p class="MsoNormal">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)<br>
How can the problem be tackeld? Shall we request to include new types? Or shall we rather let develop a new feature?<br>
<br>
I guess we are not the first users facing this problem.<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<p class="MsoNormal">--
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Darafei Praliaskouski<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Support me:
<a href="http://patreon.com/komzpa" target="_blank">http://patreon.com/komzpa</a><u></u><u></u></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>