I've been struggling to geocode the following addresses from an Excel table both in ArcMap and ArcPro:
As you can imagine, I'm trying to geocode the addresses in the "StreetAddress" field.
When I try to just simply add the table to my document and geocode it, I'm prompted to use an "address locator", of which none of the defaults work. So I believe I have to create an address locator. I'm uncertain of the style that I should use. I've tried streets, home address, and several others and I continue to get error messages.
Can anyone identify what style I need just by looking at the above example of the table? Is there something else that I'm not doing correctly? e.g. are commas invalid characters? Should I be using a different table type that isn't Excel? Are there address locators that I can just download and use this dataset for (instead of having to create one)? I can tell I'm missing something fundamental here.
