Latest Contributions by MitchHolley1

Do a Select By Attributes on the table in ArcMap, then copy that SQL syntax to your Python code.  ... View more

#Variables feature = r'...path to feature...' field = "field" field_set = set() count = 0 with arcpy.da.UpdateCursor(feature, ['ACCT','group_code']) as cursor:         for row in cursor:             if row[0] not in field_set:                   if str(row[1]) != "01":                       field_set.add(row[0])             else:                 count+=1                 cursor.deleteRow() arcpy.AddMessage('\n'+str(count) + ' duplicates removed from the ' + str(field) + ' field.\n') This script will delete a duplicated record of the 'ACCT' field, ONLY WHERE 'group_code' does not equal "01". Is this what you're looking to do?  Also, I'm not sure about the highest value thing... that's tricky.  ... View more

I built a similar tool that deletes duplicate geometries. It looks a little like this:  #Variables feature = r'...path to feature...' field = "field" field_set = set() count = 0 with arcpy.da.UpdateCursor(feature, [field]) as cursor:         for row in cursor:             if row[0] not in field_set:                 field_set.add(row[0])             else:                 count+=1                 cursor.deleteRow()‍‍‍‍‍‍‍ arcpy.AddMessage('\n'+str(count) + ' duplicates removed from the ' + str(field) + ' field.\n')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I haven't tested it on a field duplicate, only the 'SHAPE@XY' token.  But, I successfully got it to work with the geometries.  ... View more

For 2, if by template you mean schema, there is a way to do this in a geodatabase.  See here : Exporting a geodatabase schema to an XML workspace document—ArcGIS Help | ArcGIS for Desktop. Then, you can import the XML document to a database and load data into it.  ... View more

Did you try searching through the Geoprocessing > Result window? ... View more

Wow!  Amazing answer, Brad.  Thank you so much! ... View more

So, the source feature and the target feature do not share any unique IDs?  The only relationship that these have are spatial? ... View more

So, are you trying to read through the CSV and get the date from different fields?  Can you show the fields? ... View more

Shouldn't this:  cursor = arcpy.da.InsertCursor (fc...)   Be this:  cursor = arcpy.InsertCursor (fc...)   Drop the 'da'?  brittney.white.ucf‌ ... View more

Jay,  Don't forget the '@' in the SHAPE@XY.  Please format it like this: ... (csv, ["SHAPE@XY", "Date", "Field_1", "Field_2"]) as cursor Each field is exasperated by quotations, not brackets.  ArcPy reads the geometries stored in the feature without them being an actual attribute.  Please read Brittany White's response above for a more in depth look into the InserCursor function and the SHAPE@XY token.  ... View more

This may get you started... ... View more

All,  I finally got the script to successfully run thanks to all the kind people in this community.  Below is the final code.   Dan Patterson‌ is there a way to mark several people's replies as the correct answer?  This seems like it was a team effort since everyone contributed to the overall answer.  import arcpy #Get input from user feederID = arcpy.GetParameterAsText(0) ischecked = arcpy.GetParameterAsText(1) #Variables mxd = arcpy.mapping.MapDocument("CURRENT") field = "FEEDERID" for lyr in arcpy.mapping.ListLayers(mxd):     if lyr.isFeatureLayer:         fields = arcpy.Describe(lyr).fields         for f in fields:             if f.Name == field:                 delim = arcpy.AddFieldDelimiters(lyr,field)                 lyr.definitionQuery = delim + "='" + feederID + "'"             #Clear definition query           if ischecked == 'true':     for lyr in arcpy.mapping.ListLayers(mxd):         if lyr.isFeatureLayer:             lyr.definitionQuery = ""             arcpy.RefreshActiveView()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I actually figured out the issue.  I believe it was because I had layers in the MXD with broken data sources.  Thank you!! ... View more