I am trying to geocode an excel sheet imported in ArcGIS Pro 2.2.1. It has the following columns: ID, Address, State, Zipcode, and County. I even removed the other fields like "Description" and etc. cause I thought they might create problems because they contained special characters.
I have tried different formats like CSV, XLS, and XLSX. None of them worked.
I have the following licensing as well: 3D Analyst, Geostatistical Analyst, Spatial Analyst, etc. Also, I am already logged in.
I followed the requirements for the excel sheet formatting and how to import them into ArcGIS pro; i.e. no spacing in the header row.
I right click on the table and choose Geocode Table. The Input Table is choosen by default. I choose "US Address" from All Portal as Input Locator (I had no idea how to work with this because in ArcMap everything was set as default, so in ArcPro, I just looked it up and figure out that US address might work). After that, I set every other parameter and Routing Location as Preferred Location Type, and click RUN. But I keep getting this error:
ERROR 000010: Geocode addresses failed.
Failed to execute (GeocodeAddresses).
Failed at Tuesday, September 4, 2018 11:15:51 AM (Elapsed Time: 1.07 seconds)
Error: 10 - Geocode addresses failed.
Error: -2147467259 - Failed to execute (GeocodeAddresses).
Do you have any suggestions?
Here, is a snapshot of the data:
|1||922 North Main Street||Brigham City||BOX ELDER||Utah||84302|
|2||780 East 100 North||Payson||Utah||Utah||84651|
|3||1510 North 800 East||Logan||CACHE||Utah||84322|
|4||5600 South Redwood Road||Taylorsville||SALT LAKE||Utah||84123|
|5||74 East Main Street||American Fork||Utah||Utah||84003|
|6||289 South State Street||Clearfield||DAVIS||Utah||84015|