When I geocode large files in ArcGIS 10.3, I receive the following error, “There was an error trying to process this table.” In researching this issue, it says that one cause may be because the file is corrupt. However, this error goes away when I just cut down the number of cases I’m geocoding. Is there an easier fix for this issue?
Hi Alese. Which file format are you using? I find that ArcGIS still likes DBF files, (ArcView days) and tends to get cranky with XLSX.
Cheers,
Martin
some installations may have limits on the number of records that can be geocoded --- simply divide the file and do this (large file) in smaller batches?
I am using CSV because you're right that ArcGIS gets cranky with XLSX. It appears that is also the case with CSV haha. I don't get that error with DBFs but I am trying to avoid using that format because it cannot support a combined date/time variable. With DBFs, I also have the problem when geocoding using zip codes... I have cases missing zip code and the DBF format is automatically putting a zero, causing it to be unmatched rather than matching without using the zip code field.
I am trying to avoid dividing up the files into batches since it is becoming quite time consuming and it is more of a hassle keeping track of cases. I can't find any hard limit to the number of cases you can geocode at any given time, and the memory/RAM on my computer shouldn't be the culprit...
I bet you'd better double check your field names. For example, if more than one filed has similar field name (e.g. crime vs. crime~), ArcGIS cannot geocode. Another possibility is that you are already using a filed name that is assigned to the system's default. These field names are, for example, X, Y, length, area. Whenever you geocode, then these field names should be created by ArcGIS, but not by the user. If you have one of these fields in your data, change it to, for example, X->Xcor, Y->Ycor, etc. Hope this helps.
here is the beautiful link where the solution to your beautiful problem has been discussed.
http://gis.stackexchange.com/questions/82535/arcgis-10-1-geocoding-problems-creature-feature-class-error-processing-the-tab
here is also information
https://geonet.esri.com/thread/77600
https://www.reddit.com/r/gis/comments/1hkpon/help_cant_geocode_anything_in_arcmap_101_sp1/
here is the video which fix this problem
https://www.youtube.com/watch?v=HW-1utzu4nI
Thanks so much for the help everyone.. The only solution that worked for me was to convert the .xlsx to .txt and then geocode the text file. Initially, geocoding would stop after the first handful of cases but after I cut the majority of fields in the my file, it worked!
- Badges
- Science topic
- Similar topics
- Geoscience
- Cartography
- Mapping