Changes between Initial Version and Version 1 of UsersWikiDistanceInteriorPoint


Ignore:
Timestamp:
07/17/09 09:52:27 (15 years ago)
Author:
darkblueb
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiDistanceInteriorPoint

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