topic Geocoding over 1M records in ArcGIS Enterprise Questions

Geocoding over 1M records

BrandonPowell1 — Tue, 29 Nov 2016 17:25:36 GMT

Hi all,

I have 1,609,214 records in a .csv file that I'm trying to geocode in one fell swoop, but I'm getting an error during the process "there was an error trying to process this table." I assumed that meant the file was too large, so I split it into two files and both geocoded fine.

Now I have two sets of geocode results in my table of contents, so I have two questions.

1. Is there a way to geocode all of my 1,609,214 records without splitting the file?

2. If not can I join my two geocode results together via arcmap into 1 set of results after I have geocoded the two split files?

I hope this all makes sense. Thanks for any guidance. I'm using the USA_ZIP4_LocalComposite locator that comes with business analyst.

Re: Geocoding over 1M records

XanderBakker — Tue, 29 Nov 2016 18:11:36 GMT

I'm not sure if there is a limit on the amount of records that can be geocoded at once. You can however, do this in batches, as you did and "join" the files together using for instance Merge—Help | ArcGIS for Desktop , Append—Help | ArcGIS for Desktop or loading the data About loading data into existing feature classes and tables—ArcGIS Help | ArcGIS for Desktop

Re: Geocoding over 1M records

BrandonPowell1 — Wed, 30 Nov 2016 20:06:19 GMT

Thank you Xander, I used the Append tool and it worked just like I wanted it to.