AnsweredAssumed Answered

Geocoding in ArcGIS Pro

Question asked by on Sep 4, 2018
Latest reply on Nov 27, 2019 by jfrost_hrretail

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:


1922 North Main StreetBrigham CityBOX ELDERUtah84302
2780 East 100 NorthPaysonUtahUtah84651
31510 North 800 EastLoganCACHEUtah84322
45600 South Redwood RoadTaylorsvilleSALT LAKEUtah84123
574 East Main StreetAmerican ForkUtahUtah84003
6289 South State StreetClearfieldDAVISUtah84015