Join to closest matching attribute

[OlofOlsson]

Hi!

I need to join polygons with points. For each shapefile I have attributes that represent the same information (area), but the problem is that these attributes do not perfectly match. Since I have multiple points per polygon, I don't want to do a spatial join, and the distance from the point to the polygon is not relevant here. So my question is if there is any way to join points with polygons by their closest matching values (area)?

Regards,

[DanPatterson_Retired]

so is it kind of like a Select Layer By Location​ and a Summary Statistics​ that you want?

[OlofOlsson]

Well right now I'm doing it manually. I'm running Identity to connect the points with the polygons and then calculate their respective match as a percentage between the area attributes. Since I will do this for quite many features I am really looking for a more automatic way...

[DanPatterson_Retired]

So you didn't try the options I suggested then and you are trying to do it point by point?

[OlofOlsson]

I am using Summary statistics to calculate a new attribute based on the previously calculated Match attribute, gropued by the polygon id's (there are multiple points with the same id). This allows me to select the closest match and is the best solution I can think of right now. Thank you for your help.

Edit: rather than to extract the MIN or MAX values, I used the square root of the Match attribute since the best match often lies somewhere between the Min and Max values. Seems to work for my material anyway