I have a point layer and a streets layer that I want to do a spatial join on. Because the points can fall on street intersections, I want to join one-to-many such that I get a record for each street it touches. This works, but the output is a point layer, with one point for each street it touches. What I really want is line geometry with the streets duplicated. The tool supports one-to-one joins or one-to-many joins (with the target features on the left and the join features on the right), but not many-to-one, which is what I need.
I tried fiddling with the field map to see if I could include the shape field from the join features (streets), rather than the target features (points). I don't see either layer's shape field, so I think that's hard-coded from the tool's interface.
To recap, what I have now is a one-to-many with the join features duplicated. What I want is a many-to-one with the target features duplicated. Is there something obvious I'm overlooking?
My work-around for now is to create a view in my enterprise database from the streets to the output of the spatial join. It uses a left join to duplicate the street features, but this is more moving parts than I want.