Latest Contributions by Brian_McLeer

Any ideas on how to list unused domain values from within a coded domain? An example is we had PKWY EAST in a domain for street suffixes. I would like to generate a list of domain values that are not being used in a feature class.  ... View more

Currently, we have our water system mains in a geometric network but they are not split at valves. I would like to batch split the water main complex edges at the valves while maintaining the attributes. I looked at the split line at points tool, but it wants a separate output. I am trying to do this operation from within an edit session to maintain current attributes. After the split, my plan is to assign a unique ID.  I am looking at within an edit session or a Python script to accomplish this. Below is an image of our current geometry.  ... View more

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