I am using ArcGIS Pro.
I have a bunch of line features with unique ids and a bunch of polygons with unique ids. I want to know how many and which polygons each line interacts with. The only way I know how to do this is to Spatial Join and get the join count. But this wouldnt give me the unique ids of all the polygons the lines intersect with.
I am not a GIS expert, this is something I learned for my job and to me it feels like I want to flip the way database table's x and y axis. I often encounter this problem where I want to have a series of information in a cell. I feel like there must be a way to do this that I have not learned yet.