Add SQL Table, Convert to Shapefile and export to ArcGIS Server

deleted-user-Pi5x1UjkS2PY — Wed, 22 Oct 2014 17:59:03 GMT

I am very new to Python and very excited. Moving from VBA. The first mini project is to update my ArcGIS Server files. I've heard you can do this with Python Scripting. It would be great if I could automate this process.

Here is what I need to do:

Open up new project

Import a table from an SQL DB called "GISWEB.VW_MCYWEB" using an ODBC connection called "AR"

Make sure this file is webmercator because it is used in a JavaScript application

Convert this file to a shapefile called MCYWEB.shp

Then open up an MXD and Publish that MXD to the server. The layers in the map are linked to the shapefile created earlier and already have symbology.

If possible have this run once a week.

So is python this powerful?

Re: Add SQL Table, Convert to Shapefile and export to ArcGIS Server

deleted-user-Pi5x1UjkS2PY — Fri, 24 Oct 2014 11:08:19 GMT

So it seems that I can upload the mxd to the server using this so my last part is completed. That is very cool

# create service definition draft

analysis = arcpy.mapping.CreateMapSDDraft(mapDoc, sddraft, service, 'ARCGIS_SERVER',

con, True, folder, None, None)

Still need to import the SQL View, check the projection and save it as a shapefile.

topic Re: Add SQL Table, Convert to Shapefile and export to ArcGIS Server in Python Questions

Add SQL Table, Convert to Shapefile and export to ArcGIS Server

Re: Add SQL Table, Convert to Shapefile and export to ArcGIS Server