I'm trying to append the attributes of the lines (0 or 1) to all the polygons that they intersect (take the mean if multiple lines exist), as shown below. The polygons, lines and the DataFrame are all in the same Geographic coordinate system.
Then I ran a spatial join (see below) with the polygon as target feature, and the line graph as join feature.
The resulting attribute table, however, gives all Null values for all appended attributes ("Test_1" is the field where I put 1 and 0 for the lines).
I saw there's a bug related to the spatial join tool which should be fixed in version 10.5, and the coordinate systems I used for both feature classes are the same.
It worked when I use the "Join and Relate" - "Join" - "Join based on spatial location", however, the spatial join tool in the toolbox still couldn't solve the problem. Would love to know why or the difference between these two tools.