topic Re: Geocode using ArcGIS Geocoding service in SQL in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/geocode-using-arcgis-geocoding-service-in-sql/m-p/549829#M2623 <HTML><HEAD></HEAD><BODY><P>You should really have a look at PowerShell (<A href="https://msdn.microsoft.com/en-us/mt173057.aspx" title="https://msdn.microsoft.com/en-us/mt173057.aspx">Microsoft PowerShell</A>) - you can interface with the geocoding API through PowerShell, and then call a SQL stored proc to update your records with the geocoded values.</P></BODY></HTML> Mon, 23 Nov 2015 21:21:40 GMT ChrisSmith7 2015-11-23T21:21:40Z Geocode using ArcGIS Geocoding service in SQL https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/geocode-using-arcgis-geocoding-service-in-sql/m-p/549828#M2622 <HTML><HEAD></HEAD><BODY><P>I would like to geocode addresses in a SQL table using a ArcGIS geocoding service.&nbsp; The service is located here: <A href="http://gis.hennepin.us/arcgis/rest/services/Locators/HC_COMPOSITE/GeocodeServer">http://gis.hennepin.us/arcgis/rest/services/Locators/HC_COMPOSITE/GeocodeServer</A></P><P>I found a great example of what I am trying to do here:</P><P><A href="https://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/">https://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/</A></P><P>but this example is using Bing maps and XML.&nbsp; I would like to use ArcGIS service and JSON.&nbsp; Any help would be greatly appreciated.&nbsp; Thanks</P></BODY></HTML> Mon, 23 Nov 2015 17:35:56 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/geocode-using-arcgis-geocoding-service-in-sql/m-p/549828#M2622 BrianPaulson 2015-11-23T17:35:56Z Re: Geocode using ArcGIS Geocoding service in SQL https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/geocode-using-arcgis-geocoding-service-in-sql/m-p/549829#M2623 <HTML><HEAD></HEAD><BODY><P>You should really have a look at PowerShell (<A href="https://msdn.microsoft.com/en-us/mt173057.aspx" title="https://msdn.microsoft.com/en-us/mt173057.aspx">Microsoft PowerShell</A>) - you can interface with the geocoding API through PowerShell, and then call a SQL stored proc to update your records with the geocoded values.</P></BODY></HTML> Mon, 23 Nov 2015 21:21:40 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/geocode-using-arcgis-geocoding-service-in-sql/m-p/549829#M2623 ChrisSmith7 2015-11-23T21:21:40Z