[postgis-users] Nearest Neighbour on a polygon gemeotry to a given point

David Potts dave.potts at pinan.co.uk
Tue Sep 7 04:55:49 PDT 2010


I have a series of x/y values that represent towns and a coastline that
that is encoded as a Polygon.

I want to return the nearest point on the polygon to a town.  I have seen
the item
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_nearest_neighbor_generic

Which seems to be fine if you both objects that your are searching  are
point data or have a centroid of some type.

What is the best solution, turn my coastal outline polygon in to a series
of x/y values and use the solution from postgis_nearest_neighbor_generic,
or is there some better way?

regards


Dave.

-- 
Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of the
Pinan Software





More information about the postgis-users mailing list