<div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace">Hey, if you want to do it the robust way,<br></div><div class="gmail_default" style="font-family:monospace,monospace">you can use a shared surface distance : <br></div><div class="gmail_default" style="font-family:monospace,monospace">for instance, ST_area(ST_Intersection(A,B)) / ST_Area(A)<br></div><div class="gmail_default" style="font-family:monospace,monospace">where A is you polygon, and B  your zoning information.<br><br></div><div class="gmail_default" style="font-family:monospace,monospace">If everything is snapped, you could also use topology.<br><br></div><div class="gmail_default" style="font-family:monospace,monospace">Cheers,<br><br></div><div class="gmail_default" style="font-family:monospace,monospace">Rémi-C<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-05-25 3:45 GMT+02:00 Paul Norman <span dir="ltr"><<a href="mailto:penorman@mac.com" target="_blank">penorman@mac.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 5/24/2016 6:31 PM, Timothy Asquith wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
    - I’m experimenting with ST_Snap and filtering out ST_Touches, but it still returning the same 3 results <br>
</blockquote>
<br></span>
You may want to use the dimensionally extended 9 intersection model (<a href="http://postgis.net/docs/manual-2.2/using_postgis_dbmanagement.html#DE-9IM" rel="noreferrer" target="_blank">http://postgis.net/docs/manual-2.2/using_postgis_dbmanagement.html#DE-9IM</a>) if there isn't a function that expresses what you want.<br>
<br>
Be sure to add a geom1 && geom2 condition if applicable so you get index usage.<div class="HOEnZb"><div class="h5"><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="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></div></div></blockquote></div><br></div>