topic Re: arcgis world geocoding service in ArcGIS Pro Questions

arcgis world geocoding service

potomacGIS — Mon, 15 May 2023 23:33:59 GMT

I'm not having success with the ArcGIS World geocoding service. Here is the error:

Error: -2147467259 - Failed to execute (GeocodeAddresses).

Does anyone know of address locator for Pennsylvania? thx s

Re: arcgis world geocoding service

MichaelVolz — Tue, 16 May 2023 02:28:03 GMT

Are you trying to genocide a table of addresses in PA?

Can you share a small sample of the data you are trying to geocode?

Re: arcgis world geocoding service

potomacGIS — Tue, 16 May 2023 02:58:18 GMT

hi Michael. Thank you for responding so quickly. This effing me up because I have ADD and can't let it go until I resolve this. Here is jpg snip, it's all text format if use multiple fields:

street, city, zip2, country

I've also made a calculated field called address. I've done it ways and it fails.

At first I saw a permissions issue, but my professor let me update my permissions. After the change to the permissions, then the geocode table error. Some other community members said it may be a utility issue (organizational configuration) so I have support ticket to find out about that.

Re: arcgis world geocoding service

MichaelVolz — Tue, 16 May 2023 23:34:26 GMT

Here is a screenshot of what the parameters looked like for an Excel table I created where I reformatted some of your data. I added the Street field to a field I called Address 1, City to a City field, State to a State field and Zip to a Zip Code field.

I had 3 addresses from my area in southeast PA plus 2 records from your data in Pittsburgh. I was able to successfully geocode all the addresses with the ArcGIS World Geocode Service in ArcMap.

Re: arcgis world geocoding service

potomacGIS — Tue, 16 May 2023 23:49:26 GMT

Is your output feature class or shape file hosted?

Re: arcgis world geocoding service

MichaelVolz — Wed, 17 May 2023 00:11:47 GMT

I was just saving the output to a shapefile, but I was normally save it to a file gdb on a network drive (Not hosted).

I tried geocoding the same simple data excel file in Pro, but it threw errors there (Ole reliable ArcMap).

Re: arcgis world geocoding service

potomacGIS — Wed, 17 May 2023 17:30:01 GMT

Stephanie Faulkner <stephanie.faulkner@student.potomac.edu>

Tue, May 16, 8:50 PM (16 hours ago)

Hi Michael. I'm using PRO. I appreciate what you did with using a small sample. Good programmers do this. I exported the bakeries from my 3000+ set of Pittsburgh food sources to 20 records. I had two duplicates that I deleted. ESRI tech support said it would bomb if I had dups.

I ran it again and it generated this message:

==> Start executing of geocoding.GeocodeAddresses
Start Time: Tuesday, May 16, 2023 8:35:03 PM
Executing Geocode Addresses...
ERROR 000600: Cannot delete C:\EsriPress\GISTHealth\Data\Assignment10_sFaulkner\Assignment10_sFaulkner.gdb\PGHfoodSources_BakeryGeocoded. It is being edited by the application.
ERROR 000010: Geocode addresses failed.
Failed to execute (GeocodeAddresses).
Failed at Tuesday, May 16, 2023 8:35:04 PM (Elapsed Time: 0.38 seconds)
Error: 600 - Cannot delete C:\EsriPress\GISTHealth\Data\Assignment10_sFaulkner\Assignment10_sFaulkner.gdb\PGHfoodSources_BakeryGeocoded. It is being edited by the application.
Error: 10 - Geocode addresses failed.
Error: -2147467259 - Failed to execute (GeocodeAddresses).

So, now I think I have a permissions issue on my database. I shared the project. Same error. Those files are not opened (attribute columns) when I run the geocode table.

I spending way too much time on this!!! I am talking to ESRI about the editor tracking today. I'll let you know. Thanks!!!!!! stephanie

Re: arcgis world geocoding service

MichaelVolz — Wed, 17 May 2023 17:39:24 GMT

Can you try to save the results to a local drive just to see if that will remove database permissions as a variable here?

Re: arcgis world geocoding service

potomacGIS — Wed, 17 May 2023 17:54:30 GMT

Yes. It’s local. I like way you think—eliminating variables. I’ll share my screen with an ESRI tech today at 2:30est. I’m aware of setting up an editor tracking but it’s tracking here. This feature is for people in the field (using collector) to track who, when and where the data is changed. This is just an old dataset from an outdated book is not formatted like the current open streets for center lines, otherwise I would have created an address locator. Also centerlines are really inaccurate at times. A lot of what we are assigned is using ArcMap which nobody is using.

Re: arcgis world geocoding service

potomacGIS — Wed, 17 May 2023 17:56:59 GMT

Not tracking here.

Re: arcgis world geocoding service

potomacGIS — Thu, 18 May 2023 06:07:14 GMT

Hey Michael. Guess what? I created an address locator from Allegheny county ( Pittsburg). I don’t need to rely on the ArcGIS world geocoding service. Using the centerline data and matching up fields solves my problem. I needed that point feature class to breakdown the x, y point from the addresses of food sources. My textbook uses the arcMap way. Arc GIS Pro uses the open street format for creating an address locator. Unfortunately, everyone knows the inaccuracy of the centerline method. Think about it… it’s using a method that creates a point from let’s say middle of Main Street for 500 Main Street. But Putting the address in the middle of its span is not necessarily where it’s located.
Using ArcGIS world geocoding services is the better method. Just haven’t figured out why it’s not working. ESRI tech support thinks it may be organizational issue. University of the Potomac has really stretched me as far as getting down to the core issues.
i soooooooo appreciate your help. Thanks again. -s

Re: arcgis world geocoding service

potomacGIS — Fri, 19 May 2023 12:41:28 GMT

ESRI said I’m using a public account under the organizational account. Only the organizational can batch geocoding. Everyone can use the ArcGIS world geocoding service with a single query. My solution was to build a locator using the create locator tool. I used the centerline data from the county of Allegheny ( Pittsburgh).

Re: arcgis world geocoding service

MichaelVolz — Fri, 19 May 2023 12:49:58 GMT

How large is your table of records to geocode? I know you are unable to use batch geocoding because of your use of a public account, but that process does use credits and if it's a large table you can use up a lot of credits. Also if it's a process that needs to occur on a regular basis, you would use even more credits up, so creating your own address locator/geocode service would save you credits (money) there as well. I'm glad you were able to find data to be able to create your own locator.

ESRI's World geocode service is very good though.

Re: arcgis world geocoding service

potomacGIS — Sat, 20 May 2023 02:27:13 GMT

----------excerpt from ESRI Tech Support----------

Thank you for the quick response.

Members of the organization can utilize the credits allotted to them by the organization. Public accounts do not possess credits and hence cannot geocode, perform analysis or host feature layers.
- It may be not possible to state the truth, however, it is more than likely that students from other colleges and universities use organizational accounts. Using an organizational account enables them to work (share content) with the organization and collaborate with other organizations.
- We may assume that other schools use this hierarchical structure too, as Public accounts work in such a way by design.
If this is related to using a Custom Geocoding service in ArcGIS Online:
- You may create a custom geocoding service for batch geocoding in Enterprise as well.
- Or it may require setting up a utility in ArcGIS Enterprise to link the Custom Geocoding service prepared in ArcGIS Online.

----------------------------------------------------------------------

-----------------------