<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">Hi,</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">I am trying to create an inner buffer of a polygon geometry table.</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">Unfortunately this is the only way I can think of which will enable me to make a certain symbol for a polyon layer. The SLD Filter "difference" might do it, but it needs to be nested and i´m not sure if this is possible.</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">anyway....My polygons need to be symbolized with a thin outline AND an inside
Buffer of 3 mm(<span style="font-size: 10pt; ">150m</span><span style="font-size: 10pt; "> </span><span style="font-size: 10pt; ">at a scale of 1:50 000)....in essence just an inside ring.</span></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><span style="font-size: 10pt; "><br></span></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">This means I need to first buffer my polygon geometry and then substract the buffer from the original polygon. = ST_Difference (i think!?!)</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">my attempt created some geometries but not what I was expecting...</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div><div><font face="arial, helvetica, sans-serif" size="2">create view
rrop08.rrop_01_13_innerbuffer AS</font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2">SELECT ST_Difference(a.st_buffer, b.the_geom)</font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2">FROM rrop08.rrop_01_13_buffer a, rrop08.rrop_01_f b;</font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2">rrop08.rrop_01_f = the original polyon<br></font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2">rrop08.rrop_01_13_buffer = the inner buffer <br></font></div><div><font face="arial, helvetica, sans-serif"
size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div></div></div></body></html>