I've been using ArcMap 10.8.2 the last few weeks in order to create a tool to streamline the creation of an Excel sheet used by a city's wastewater engineering technicians to list stormwater assets owned by the city (within a project area) by nearest street intersection. The tool works almost completely as intended, but for some reason the reverse geocode tool has been assigning some assets' intersection names in reverse order (e.g. Main & 1st vs 1st & Main) and I cannot figure out why. The issue is seemingly minor, but the goal of the tool is to output a layer with an attribute table that's formatted correctly to run a report on, and any required editing after the tool is run counteracts its usefulness severely. The tool's ModelBuilder workflow is here:
(tried to make it readable without making it immensely small) and a sample output table is here:
As you can see, Objects 1, 2, and 7 are geographically located at the same intersection but for some reason #2 has had the title reversed. When the report doc is run on those features, the assets are separated despite being in the same geographical location. Is there a way for me to force the program to geocode intersections in a certain order? Alternately, is there a field editing tool or report formatting operation I can utilize to standardize the address field? Note: I don't have permissions to directly edit the source data for the locator or layers which are the source for the original inputs of the tool.
Update 4/5/23: A workaround has been established by creating an "intersections" feature class using the "Feature vertices to points" tool and geocoding those features. This removes any mishaps from running the reverse geocoding tool multiple times and allows use of the "Spatial Join" tool to add the intended address field to the project assets. Still confused as to why the address would be reversed at all.