[postgis-users] get parts of polygons with less than 0.5 meters of free width

[Lito Macieira]

Hi guys,

I have two tables of simple polygons that are sidewalks and furniture.
I want find the regions where the sidewalks have less than 0.5 meters of
free width like in image [ss2].
I don't want when at least one side have more than 0.5 meters [ss1].
I've tried many things with ST_LINE_INTERPOLATE_POINT,converting
polygons to lines, but i can't detect this parts of sidewalks.
Can anybody help me with that?

thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130708/a07919c0/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ss1.png
Type: image/png
Size: 37518 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130708/a07919c0/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ss2.png
Type: image/png
Size: 28910 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130708/a07919c0/attachment-0001.png>