Latest Contributions by MitchHolley1

Like Dan said, you should use = instead of ==.  import arcpy mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd)[0] for lyr in arcpy.mapping.ListLayers(mxd):      if lyr.name == "waste":          lyr.definitionQuery = "Code = 'IT1300021'" arcpy.RefreshActiveView()‍‍‍‍‍‍‍‍ ... View more

What's the error you get? ... View more

You could have a script write a comment to a text field that are duplicates, then append records that do not have a comment.  import arcpy shp1 = r'...path to shapefile1...' shp2 = r'...path to shapefile2...' shp1keys = [] #Field arguments is the common field between both datasets with arcpy.da.SearchCursor(shp1, ['field_with_dups']) as cursor:     for row in cursor:         shp1keys.append(row[0]) del cursor #Field arguments with common field plus 'Comment' field to write duplicates with arcpy.da.UpdateCursor(shp2, ['field_with_dups', 'Comment']) as cursor:     for row in cursor:         if row[0] in shp1keys:             row[1] = 'DUPLICATE'             cursor.updateRow(row) del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Can you please post your Python code in the code syntax highlighter. ... View more

Arcpy has a cool function that does this called replaceDataSource.  Check here:  Layer—Help | ArcGIS for Desktop  ... View more

Great link!  Thanks Mike.  ... View more

This could be done in Python.  Try running this before you run the merge.  import arcpy import os SHPfolder = r'...path to folder where .shps are kept...' for x in os.listdir(SHPfolder):     with arcpy.da.UpdateCursor(SHPfolder + '/' + x, ['shpName']) as cursor: #Change field name if necessary         for row in cursor:             row[0] = str(x)             cursor.updateRow(row)     del cursor‍‍‍‍‍‍‍‍‍‍‍ ... View more

Can you duplicate that selection in the Python GUI in that MXD without error? ... View more

Is there a reason you're using "SUBSET_SELECTION" selection method on that table?  Does the user select records prior to running this tool? Also, I would make that layer a single variable in the tool.  Right now the variable 'lyr' is assigned to an arcpy function of ListTableViews. ... View more

Is the "ArcGIDSDE.SDE.Detention_Basic_Inspection" a single layer in the MXD? ... View more

I would create an X and Y field in the featureclass. Then calculate geometry for those fields.  From there, you can get an address.  ... View more

Then what is your goal?  It seems like Map3 is what you're looking for.  ... View more

So, do you want to show the '0' values as well? ... View more

Sounds like you want to build an Add-In. What is a Python add-in?—Help | ArcGIS Desktop  You can import a Python script and control functions based on user mouse clicks or keyboard commands.  ... View more