I would like to geocode addresses in a SQL table using a ArcGIS geocoding service. The service is located here: http://gis.hennepin.us/arcgis/rest/services/Locators/HC_COMPOSITE/GeocodeServer
I found a great example of what I am trying to do here:
https://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/
but this example is using Bing maps and XML. I would like to use ArcGIS service and JSON. Any help would be greatly appreciated. Thanks
You should really have a look at PowerShell (Microsoft PowerShell) - you can interface with the geocoding API through PowerShell, and then call a SQL stored proc to update your records with the geocoded values.