I have a polygon shapefile of land plots with their corresponding cadaster number and a point shapefile with a water meters for each lot.
What I'm trying to do is to join the cadaster number from the polygon shapefile to its corresponding water meter. For this I'm using a spatial join with the point file (water meters) as my target feature and the polygon file (land plots) as the join feature and CLOSEST as the match method.
The problem is that the water meters and the land plots do not allign correctly as shown in the figure below and it's adding the same cadaster number to two different water meters.
Is there a way I can tell the program to assign a cadaster number only once and if a second point has this same polygon as the closest one to move on to the second closest?
I have some experience with python so if there is a way to do it this way it won't be a problem.
The drawing attached is just a simple example, what I actually have is this problem for a whole city so I can't just move the water meters manually.