<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>