Hello,
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:
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 ))))
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
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?
--
Thank you,
Chris Story
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
