Changes between Initial Version and Version 1 of UsersWikiDistanceInteriorPoint

Timestamp:

Jul 17, 2009, 9:52:27 AM (15 years ago)

Author:

darkblueb

Comment:

—

UsersWikiDistanceInteriorPoint

@@ +1 @@
+
+an IRC discussion began regarding "How to find the distance from an interior point to the nearest edge of a POLYGON or MULTIPOLYGON"
+
+pramsey replies:
+
+SELECT name, ST_Distance( ST_ExteriorRing( (ST_DumpRings( ST_GeometryN( the_geom, 1) ) ).geom),
+  ST_Transform(( ST_SetSRID( makepoint(-85.64777, 42.9323 ), 4326), 2898 ) )
+FROM table WHERE sta = 'XYTown';
+
+