Problem adding ID to Generate Near Table (or next nearest)

Discussion created by richardgreaney on Apr 8, 2011
Latest reply on Apr 8, 2011 by dkwiens
Hello, I don't know if anyone can help me, but I'm running out of ideas as to how I can solve a problem:

In modelbuilder (version 10)
Using the 'Generate Near Table' tool
         I can successfully find the nearest three 'sites' to a set of features,
however, the resulting table does not have a field that specifies this is the nearest (1) this is the second nearest (2) this is the third nearest (3).

I require this because I want to seperate out the nearest and second/third nearest into seperate tables.

So my question:

Does anyone know if there is a way to either:

   - add an id to the generate near table (1 for nearest 2 for next nearest feature etc.)
   - or is there a tool where I can calculate the second (or third) nearest feature, but not the first

I have searched far and wide for a solution, but have had no luck so far,
so any suggestions would be greatly appreciated......

Of course this would all be easy if the 'generate near tool' could add an ID for second nearest etc.
Which I really expected it to do.

Thanks, Richard