Select to view content in your preferred language

arcgis world geocoding service

2497
13
Jump to solution
05-15-2023 04:33 PM
potomacGIS
Occasional Contributor

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

0 Kudos
1 Solution

Accepted Solutions
potomacGIS
Occasional Contributor

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).  

View solution in original post

0 Kudos
13 Replies
MichaelVolz
Esteemed Contributor

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?

0 Kudos
potomacGIS
Occasional Contributor

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.

0 Kudos
MichaelVolz
Esteemed Contributor

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.

MichaelVolz_0-1684279677084.png

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.

0 Kudos
potomacGIS
Occasional Contributor

Is your output feature class or shape file hosted?

0 Kudos
MichaelVolz
Esteemed Contributor

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).

0 Kudos
potomacGIS
Occasional Contributor
 

 

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
 

 

0 Kudos
MichaelVolz
Esteemed Contributor

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

0 Kudos
potomacGIS
Occasional Contributor

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.  

0 Kudos
potomacGIS
Occasional Contributor

Not tracking here.  

0 Kudos