<html><body><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></body></html>