Hello,<br> I am attempting to determine the distance from a point inside a polygon to the edge of the polygon. How can I achieve this? I am currently using the following SQL statement to determine the distance from a point to other polygons in my database:
<br><br>select gid, "FIRM_PAN","PANEL_TYP","COUNTYNAME",distance(transform(the_geom,utmzone(GeomFromText( 'POINT(-81.0571731786471 28.0183613937886)', 4326 ))),transform(GeomFromText( 'POINT(-
81.0571731786471 28.0183613937886)', 4326 ),utmzone(GeomFromText( 'POINT(-81.0571731786471 28.0183613937886)', 4326 ))))<br>from "S_FIRM_PAN" where distance(transform(the_geom,utmzone(GeomFromText( 'POINT(-
81.0571731786471 28.0183613937886)', 4326 ))), transform(GeomFromText( 'POINT(-81.0571731786471 28.0183613937886 )', 4326 ),utmzone(GeomFromText( 'POINT(-81.0571731786471 28.0183613937886 )', 4326 ))))<200 ORDER BY DISTANCE ASC
<br clear="all"><br>I have tried doing a distance(box2d(the_geom), GeomFromText( 'POINT(-81.0571731786471 28.0183613937886)', 4326 ) but it doesn't seem to be working. Any takers?<br><br><br><br><br>-- <br>Thank you,
<br>Chris Story<br><br>