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 <[email protected]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
