I'm working with TIGER data, looking at the relationships among incorporated places and counties. Not all places are completely contained by counties; some do span multiple counties.
In the final output I'm preparing, I need to have a "location reference memo" for each place; for a city like Cleveland that is completely contained, this might say something like
"Incorporated Place in Cuyahoga County"
for a city like Birmingham, AL, this would instead need to say something like
"Incorporated Place in Jefferson County, Shelby County"
"Incorporated Place in Jefferson, Shelby Counties"
-- or something like that.
I know that I can do a spatial join to get a multirow output like
- Birmingham | Jefferson
- Birmingham | Shelby
- [city in AL] | [County in AL]
Is there any facility, perhaps after the fact, for generating a single row equivalent of this? E.g.,
- Birmingham | Jefferson; Shelby
Thanks in advance for any ideas you may have!