Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two point shapefiles and I want for each point in the 1st shapefile to get the 3 closest (based on air distance) points from the 2nd shapefile.

If possible, it would be great to have each of the three as a new column (as if a variable name) and the value is the distance.

Thanks a lot!


share|improve this question
What software are you using? – Fezter Feb 1 '13 at 2:43
ARCMAP 10.1 Thanks – Mohamed Feb 1 '13 at 2:58
anyone can help please? – Mohamed Feb 4 '13 at 23:46
Here's some rather old VBA code. – Kirk Kuykendall Feb 5 '13 at 17:56
up vote 2 down vote accepted

Depending on how many points you have and your extensions, you can generate a near table. You can use this parameter to limit it to the nearest three:

closest_count (Optional) Dialog Reference Find only the specified number of closest features. This parameter will not be used if the Find only closest feature option is checked.

share|improve this answer
Good idea! Thanks :) – Mohamed Feb 27 '13 at 4:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.