I am currently attempting to batch geocode 1.5 million points that are stored in a sql database. The points are not very specific (ie only city, state points). I have used ArcGIS in the past but due to the new ArcGIS online credit system, it is restrictively expensive to geocode with their database. For that reason, I was able to access a composite geocoder that I attempted to connect to ArcGIS via the Create a geocoder feature, however, this system is not working as well (either it freezes with my database, or if I use a test dataset, it cannot match any addresses).
I am seeking suggestions on:
- How to best setup the geocoder I have to run in ArcGIS or
- Other methods that may work better (I am really open to anything!)
Let me know if there is more helpful information that I can provide.