<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Joseph,<br>
<br>
With St_Relate (<a class="moz-txt-link-freetext" href="http://postgis.net/docs/ST_Relate.html">http://postgis.net/docs/ST_Relate.html</a>) we can get
all kind of relations between geometries. <br>
You can get boundary intersections, interior intersections, interior
intersections without boundary intersections.... all possibilities
are supported.<br>
<br>
St_Relate uses the DE-91M model to define this relations between
geometries.<br>
To know more about DE-91M: <a class="moz-txt-link-freetext" href="http://en.wikipedia.org/wiki/DE-9IM">http://en.wikipedia.org/wiki/DE-9IM</a><br>
<br>
<br>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.net/docs/using_postgis_dbmanagement.html#DE-9IM">http://postgis.net/docs/using_postgis_dbmanagement.html#DE-9IM</a><br>
<br>
<div class="moz-cite-prefix">On 21/01/2015 22:22, Joseph Spenner
wrote:<br>
</div>
<blockquote
cite="mid:651397983.4751045.1421875346201.JavaMail.yahoo@jws106123.mail.bf1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff;
font-family:garamond, new york, times, serif;font-size:14px"><span
id="yui_3_16_0_1_1421843595215_194968">I have a polygon as an
input, and I'm trying to find all polygons which share points,
but not the perimiter points themselves. Is this possible?</span>
<div id="yui_3_16_0_1_1421843595215_194991" dir="ltr"><br>
<span id="yui_3_16_0_1_1421843595215_194968"></span></div>
<div id="yui_3_16_0_1_1421843595215_194992" dir="ltr"><span
id="yui_3_16_0_1_1421843595215_194968">Real application:</span></div>
<div id="yui_3_16_0_1_1421843595215_194993" dir="ltr"><span
id="yui_3_16_0_1_1421843595215_194968"> I have NWS polygons
describing Thunderstorm Warnings, which are made up of
counties within the state. Some of those counties might be
on the edge of the state. I want to query my database to
show me all Warnings which are in a supplied state.
However, if I query the <i>adjacent</i> state which borders
the counties from the first state, I get those Warnings
because they share the same parimeter points.</span></div>
<div id="yui_3_16_0_1_1421843595215_195026" dir="ltr"><br>
<span id="yui_3_16_0_1_1421843595215_194968"></span></div>
<div id="yui_3_16_0_1_1421843595215_195032" dir="ltr"><span
id="yui_3_16_0_1_1421843595215_194968">Is there a way to
construct a query which will not return anything if the only
points in common are the perimeter values themselves?</span></div>
<div id="yui_3_16_0_1_1421843595215_195033" dir="ltr"><br>
<span id="yui_3_16_0_1_1421843595215_194968"></span></div>
<div id="yui_3_16_0_1_1421843595215_195034" dir="ltr"><span
id="yui_3_16_0_1_1421843595215_194968">I tried a few
variations on
ST_Intersects/ST_Covers/ST_Contains/ST_Overlaps, supplying
various AND/OR and TRUE/FALSE combinatins, but I can't seem
to get the right combo to accomplish my task.</span></div>
<div id="yui_3_16_0_1_1421843595215_195087" dir="ltr"><br>
<span id="yui_3_16_0_1_1421843595215_194968"></span></div>
<div id="yui_3_16_0_1_1421843595215_195088" dir="ltr"><span
id="yui_3_16_0_1_1421843595215_194968">Any help would be
great.</span></div>
<div id="yui_3_16_0_1_1421843595215_195107" dir="ltr"><br>
<span id="yui_3_16_0_1_1421843595215_194968"></span></div>
<div id="yui_3_16_0_1_1421843595215_195106" dir="ltr"><span
id="yui_3_16_0_1_1421843595215_194968">Thanks!</span></div>
<div id="yui_3_16_0_1_1421843595215_195091" dir="ltr"><br>
<span id="yui_3_16_0_1_1421843595215_194968"></span></div>
<div id="yui_3_16_0_1_1421843595215_195090" dir="ltr"><span
id="yui_3_16_0_1_1421843595215_194968">Regards,</span></div>
<div id="yui_3_16_0_1_1421843595215_195089" dir="ltr"><span
id="yui_3_16_0_1_1421843595215_194968">Joseph Spenner</span><br>
</div>
<div id="yui_3_16_0_1_1421843595215_194841"><br>
<div id="yui_3_16_0_1_1421843595215_195015">
<br>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>