AnsweredAssumed Answered

Geocoding in ArcGIS Pro

Question asked by nasser.sharareh@hsc.utah.edu on Sep 4, 2018
Latest reply on Sep 4, 2018 by EAnderson-esristaff

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:

 

IDAddressCityCountyStateZipcode
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

Outcomes