[postgis-users] Nearest neighbor spatial join

[MarkW]

Sheara,

Although it's a bit involved,  here are two articles on this topic in
PostGIS:
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_nearest_neighbor_generic

and
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_nearest_neighbor

Mark

On Mon, Jun 20, 2011 at 8:20 PM, Sheara Cohen <Sheara at calthorpe.com> wrote:

> Hi – I’m wondering if anyone knows a process for finding the nearest point
> from one file to each point in another. I have a point file with several
> hundred thousand records (file A, let’s say) and I need to add a field to it
> that has, for every single record, the ID of the nearest point located in
> another file (file B).****
>
> ** **
>
> Does anyone know of a script or a series of commands that can be used to
> perform this operation?****
>
> ** **
>
> Thank you!****
>
> ** **
>
> ~ Sheara****
>
> ** **
>
> *Sheara Cohen*
> Planner****
>
> *C A L T H O R P E**  A S S O C I A T E S*
> 2095 ROSE STREET, SUITE 201, BERKELEY, CALIFORNIA, 94709 USA****
>
> ** **
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110620/2d9375be/attachment.html>