Latest Contributions by Brian_McLeer

Researching to see if there is a way to use Python to export multiple tables in a File Geodatabase to a single Excel file. I would like for each sheet name to have the same name as the table. My current situation is that I ran a Python script to take all the domains a GDB and create a table within the GDB.  The article referenced from: https://community.esri.com/thread/163889  def main(): import arcpy, os gdb = r"Z:\GIS_Projects\zUpdatesBrian\Scripts\ListDomains\ListDomains.gdb" arcpy.env.overwriteOutput = True for dom in arcpy.da.ListDomains(gdb): if dom.domainType == 'CodedValue': arcpy.DomainToTable_management(in_workspace=gdb, domain_name=dom.name, out_table=os.path.join(gdb, dom.name), code_field="item", description_field="descrip", configuration_keyword="") print " - domain '{0}' of type '{1}' exported to table".format(dom.name, dom.domainType) else: print " - domain '{0}' of type '{1}' skipped".format(dom.name, dom.domainType) if __name__ == '__main__': main()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

From a prior posting here, I was looking for a solution on how to turn the relative path on in batch. The solution generated will grab any MXD in a root folder and enable the relative paths to be turned on in any sub folder using this code: import os from glob import glob import arcpy PATH = r'C:\Users\mclbr\Desktop\GIS_Maintenance' arcpy.env.workspace = PATH result = [y for x in os.walk(PATH) for y in glob(os.path.join(x[0], '*.mxd'))] for map in result:  # map will be complete path to map file     print "Processing: {}".format(map) # keep track of what's happening     mxd = arcpy.mapping.MapDocument(map)     #set relative paths property     mxd.relativePaths = True     #save map document change     mxd.save() One issue that I have come across is that we have users on 10.2.2 and users on 10.3.1. The code above works on 10.3.1, but when run it updates all 10.2.2 MXDs to 10.3.1. The other issue is that when run on a 10.2.2 machine, the script will fail once it reaches an MXD that was last saved in 10.3.1. I am taking a shot in the dark, but would anyone know of a way to create code that will only select versions of ArcGIS Desktop for version 10.2.x, then one for 10.3.x?  If that is possible, I would run the routine on a 10.3.1 machine and insert the code to only update MXDs that are a 10.3.1 document, and do the same for the 10.2.2 machine and documents.  ... View more

I am using Model Builder to route water meter shut offs and services for a daily route. The output is an HMTL document with the directions. I have not found a way to add the map at each stop for the GP Tool located at Network Analyst Tools \ Analysis \ Directions. I know that you can add maps from the Directions tool on the Network Analyst toolbar, however I am trying to find this option on a more automated approach in Model Builder or Python. ... View more