I know this could be a duplicate (Merging attributes from point with containing polygon?), but the answer in the link is not clear. I have a very similar task where I want to add district information in a shapefile to a table with attributes of schools in Shanghai area.
This table has information on more than 2000 schools and XY coordinates, but no information on district. I want the polygon information of the district to be added to the school attributes table, so that I can identify the districts each school is located.
As the link directs, I tried spatial join, but the information of the shapefile were not added appropriately to the school attributes table. As in the picture, all shapefile information was added as .
I set the target feature as school attributes table with XY coordinates (sh_np2_Layer) and the join features as the district polygon shapefile (shang_dis_merged), and join operation as join one to many, because I want to join district information to each school point.
I'm bit lost on the parameters part, how should I set it correctly so that I can join the layer and the shapefile correctly? I am especially lost on setting the 'output field' , 'merge source', and 'match option'.