Latest Contributions by Brian_McLeer

I have several features that I have queried out in my RBJ files that are returned from an invalid geometry data reviewer check. These features do have invalid geometry, but it is intentional and I want them filtered out of the reviewer results table.  When I run the RBJ files inside of a review session in ArcMap 10.3.1, 0 results are returned which is expected. This is after I turn off the Invalid Geometry Check in the Default Checks tab in the Reviewer Session Manager. I cannot find any documentation on how to turn this off when creating a python file from it, as the same RBJ file is referenced in my script but it still returns invalid geometry that I do not want to be returned.  # Comments arcpy.AddMessage("Checkout DR Extension..." +'\n') txtFile.write("Checkout DR Extension..." +'\n') # Process: Checkout DR Extension arcpy.CheckOutExtension("datareviewer") # Comments arcpy.AddMessage("Checkout DR Extension Complete..." +'\n') txtFile.write("Checkout DR Extension Complete..." +'\n') txtFile.write("..." + '\n') # Comments arcpy.AddMessage("Enable Data Reviewer in GDB..." +'\n') txtFile.write("Enable Data Reviewer in GDB..." +'\n') # Process: Enable Data Reviewer arcpy.EnableDataReviewer_Reviewer("Z:\\GIS_Maintenance\\DataReviewer\\Data\\Server\\DataReviewerParks.gdb", "PROJCS['NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601',GEOGCS['GCS_North_American_1983_HARN',DATUM['D_North_American_1983_HARN',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',8202099.737532808],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-120.5],PARAMETER['Standard_Parallel_1',44.33333333333334],PARAMETER['Standard_Parallel_2',46.0],PARAMETER['Latitude_Of_Origin',43.66666666666666],UNIT['Foot',0.3048]];-111333600 -98152500 3048;-100000 10000;-100000 10000;3.28083989501312E-03;0.001;0.001;IsHighPrecision", "", "") # Comments arcpy.AddMessage("Enable Data Reviewer in GDB complete..." +'\n') txtFile.write("Enable Data Reviewer in GDB complete..." +'\n') txtFile.write("..." + '\n') # Comments arcpy.AddMessage("Creating Reviewer Session..." +'\n') txtFile.write("Creating Reviewer Session..." +'\n') # Process: Create Reviewer Session arcpy.CreateReviewerSession_Reviewer("Z:\\GIS_Maintenance\\DataReviewer\\Data\\Server\\DataReviewerParks.gdb", "ParksReviewChecks", "") # Comments arcpy.AddMessage("Creating Reviewer Session Complete..." +'\n') txtFile.write("Creating Reviewer Session Complete..." +'\n') txtFile.write("..." + '\n') # Comments arcpy.AddMessage("Executing Parks Reviewer Batch Job Files..." +'\n') txtFile.write("Executing Parks Reviewer Batch Job Files..." +'\n') # Process: Execute Reviewer Batch Job arcpy.AddMessage("Executing Parks Review Checks.rbj..." +'\n') txtFile.write("Executing Parks Review Checks.rbj..." +'\n') arcpy.ExecuteReviewerBatchJob_Reviewer("Z:\\GIS_Maintenance\\DataReviewer\\Data\\Server\\DataReviewerParks.gdb", "Session 1 : ParksReviewChecks", "Z:\\GIS_Maintenance\\DataReviewer\\RBJ\\Parks Review Checks\\Parks Review Checks.rbj", "Database Connections\\Server Production gis_reader.sde", "", "ALL_FEATURES", "") # Comments arcpy.AddMessage("Executing Parks Reviewer Batch Job Files Complete..." +'\n') txtFile.write("Executing Parks Reviewer Batch Job Files Complete..." +'\n') txtFile.write("..." + '\n')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I have about 30 feature classes in an FGDB. I am looking for a script to remove all attribute indexes, as I will need to do this for multiple FGDBs eventually.  My file path is: "M:\\GIS_Data\\FileGeoDBs\Parks.gdb" I started with this article Remove all attribute indexes using arcpy  But got stuck at line 02 dsc = arcpy.Describe("sap")   ... View more

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