topic Re: Geocoding in ArcGIS Pro in ArcGIS Pro Questions

Geocoding in ArcGIS Pro

NasserSharareh1 — Tue, 04 Sep 2018 17:19:49 GMT

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:

ID	Address	City	County	State	Zipcode
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

Re: Geocoding in ArcGIS Pro

Robert_LeClair — Tue, 04 Sep 2018 17:42:57 GMT

In your Catalog Pane under Project->Locators, do you see ArcGIS World Geocoding Service first followed by XY Provider second? If not, then you can add the ArcGIS World Geocoding Service to the list. Keep in mind this will consume Esri credits. If you want to create your own address locator, please visit the following URL: http://pro.arcgis.com/en/pro-app/tool-reference/geocoding/create-address-locator.htm

Re: Geocoding in ArcGIS Pro

NasserSharareh1 — Tue, 04 Sep 2018 19:18:28 GMT

Right now, I have World Geocoding Service and US Addresses. In the Geocode Table Pane, There is no drop-down list so I search for these terms again and I choose them. But, it doesn't work again.

Re: Geocoding in ArcGIS Pro

Robert_LeClair — Tue, 04 Sep 2018 19:23:34 GMT

Are you using the Geocode Addresses GP tool or the Geocode Addresses from Table GP tool?

Re: Geocoding in ArcGIS Pro

NasserSharareh1 — Tue, 04 Sep 2018 19:31:00 GMT

When I search Geocoding in the Tools Pane, The first option is Geocode Addresses. That is the one I am using. I don't see any other options.

Re: Geocoding in ArcGIS Pro

EricAnderson17 — Tue, 04 Sep 2018 19:42:30 GMT

Hi Nasser,

The fact that you are using a portal locator named "US Address" tells me you are not using a locator service provided by Esri. Most likely, this is a user-created geocode service published to ArcGIS Server and then hosted in your Portal for ArcGIS or ArcGIS Online account. Are you not the one who published this geocode service? Do you have access to the geocode service URL you can provide me to test with?

What happens when you use the World Geocode Service? (although as Robert noted, this consumes ArcGIS Online credits at a rate of 40 credits per 1,000 addresses).

Let me know!

Eric

Re: Geocoding in ArcGIS Pro

NasserSharareh1 — Tue, 04 Sep 2018 19:50:02 GMT

You are right. "US Address" owner is :LoudounCounty". I didn't notice that. I didn't create that and don't have access to its URL.

Now, I tried "World Geocoding" provided by ESRI, and got the same error.

==> Start executing of geocoding.GeocodeAddresses
Start Time: Tuesday, September 4, 2018 1:49:38 PM
Executing Geocode Addresses...
ERROR 000010: Geocode addresses failed.
Failed to execute (GeocodeAddresses).
Failed at Tuesday, September 4, 2018 1:49:39 PM (Elapsed Time: 0.92 seconds)
Error: 10 - Geocode addresses failed.
Error: -2147467259 - Failed to execute (GeocodeAddresses).

Re: Geocoding in ArcGIS Pro

EricAnderson17 — Tue, 04 Sep 2018 20:04:38 GMT

Hi Nasser,

Using some of the sample addresses you provided put into a CSV file, they geocode fine on my end using ArcGIS Pro 2.1.1 and the ArcGIS World Geocoding Service (6/6 matches, no error).

Some follow up questions to maybe narrow this down:

Can you test with the same sample table I did and let me know if its successful? If the sample table is successful, we can turn our focus more towards your actual input table (and I'd maybe need a copy of that). If not, we can focus on other things
- NasserTest.csv - Google Drive
Are you connected to ArcGIS Pro using ArcGIS Online or Portal for ArcGIS?
- Are other usernames in your organization able to successfully geocode from ArcGIS Pro using the World Geocode Service?
- Do you have enough credits in your organization to geocode all the addresses (again, 40 credits per 1,000 addresses)?
Where are you saving the output to? Try switching it up and see if anythings successful (network drive vs local drive, shapefile vs file geodatabase).

Also including a screenshot of my tool parameters just in case something jumps out at you (output location is the default ArcGIS Pro project file geodatabase):

-Eric

Re: Geocoding in ArcGIS Pro

NasserSharareh1 — Tue, 04 Sep 2018 20:16:56 GMT

Thank you Eric. I used the same table you sent me (Also I used table-to-table tool to first import this table to my geodatabase) but I get the same problem. I checked other output locations as well but didn't help

The only difference between the image you attached and my screen is the "Input Locator". I can't find any locator with "ArcGIS World Geocoding Services" from ESRI. I look it up in the "All Portal" tab, and there is only one with this name but the owner is "gisinschools".

Is it possible to share this locator with me?

Maybe the problem is with my institute.

I am logged in ArcGIS Pro using my institute email address. I don't know if this answers your question.

Re: Geocoding in ArcGIS Pro

Robert_LeClair — Tue, 04 Sep 2018 20:27:18 GMT

It sounds like ArcGIS.com is not your active Portal in AGP. Go to the Project core tab, click Portals on the left side and is https://www.arcgis.com available, signed in via your credentials and set as the Active Portal? If not, right click on https://www.arcgis.com and Set as the active portal. Then attempt the geocode process again.

Re: Geocoding in ArcGIS Pro

EricAnderson17 — Tue, 04 Sep 2018 20:28:59 GMT

Thanks Nasser, so just to confirm, when you right-click the table > Geocode Table, and it opens the Geocode Table pane, you don't see an option for the "ArcGIS World Geocode Service" in the Input Locator drop-down?

Can you confirm what Active Portal you are using in ArcGIS Pro? If you go the blue "Project" button in the very top-left corner of ArcGIS Pro and hit the "Portals" tab, ensure that "https://www.arcgis.com/" is set as the active portal and this is the one you are signed in with. If you needed to switch to this portal from something else, it'd be good to restart Pro after changing it to re-load the locators.

-Eric

Re: Geocoding in ArcGIS Pro

NasserSharareh1 — Tue, 04 Sep 2018 20:31:53 GMT

Actually, it is available and I just tested it again.

Re: Geocoding in ArcGIS Pro

NasserSharareh1 — Tue, 04 Sep 2018 20:33:40 GMT

No, Eric, it is not there. I should click on the folder and search that term in the "All Portal", and still I don't find it.

I double checked that. ArcGIS.com is my only available portal and it is active.

Re: Geocoding in ArcGIS Pro

EricAnderson17 — Tue, 04 Sep 2018 20:41:48 GMT

At this point it would probably be good to get in contact with one of the Administrators of the ArcGIS Online account you are using to sign into ArcGIS Pro with and ensure:

You have a role with the "Geocoding" permission (most of the default roles will have this permission turned on, really only applies if your organization is utilizing custom roles)
The ArcGIS World Geocode Service has been added to your organization settings
1. Log into arcgis.com with Administrator credentials
2. Organization tab > Settings > Utility Services
3. If you don't see ArcGIS World Geocode Service listed, add it via "Add Locator"

Re: Geocoding in ArcGIS Pro

JordanFrost — Wed, 27 Nov 2019 16:42:33 GMT

Nasser Sharareh‌ Make sure to remove special characters from the Date on the CSV file. For instance, your file name should read Nasser CSV 112719 rather than Nasser CSV 11-27-19. I had this same error until I realized there were special characters in the file name making it invalid.