Latest Contributions by 2Quiker

I have the following code that was provided by bixb0012 , thank you for the merge code. I need to be able to keep a certain fields attributes/ or transfer them once the merge is done. With the following code some merged features have info in the Field2 but some doesn't.  I would like to merge the features that have the same attribute from Field1 but keep/add what is in Field 2 to the new merged Field2. Original features                                       Merged Features ObjectID   Field1   Field 2            -->      ObjectID   Field1      Field2 01            CP0001   Conditional    -->            1         CP0001   Conditional 02            CP0001   'Blank'             03            CP0001   'Blank'           04            CP0001   'Blank'             01            CP0014   Relocation    -->            2         CP0014   Relocation 02            CP0014   'Blank'             03            CP0014   'Blank'             04            CP0014   'Blank'          from arcpy import da from itertools import groupby from operator import itemgetter from functools import reduce fc = # path to feature class or table case_fields = ["field1", "field2"] # field(s) to group records for merging sort_field, sort_order = "OBJECTID", "ASC" shape_field = "SHAPE@" fields = case_fields + [sort_field, shape_field] sql_orderby = "ORDER BY {}, {} {}".format(", ".join(case_fields), sort_field, sort_order) kwargs = {"in_table":fc, "field_names":fields, "sql_clause":(None, sql_orderby)} with da.UpdateCursor(**kwargs) as ucur, da.SearchCursor(**kwargs) as scur: case_func = itemgetter(*range(len(case_fields))) ugroupby, sgroupby = groupby(ucur, case_func), groupby(scur, case_func) for (ukey,ugroup),(skey,sgroup) in zip(ugroupby,sgroupby): poly = reduce(arcpy.Geometry.union, (row[-1] for row in sgroup)) row = next(ugroup) ucur.updateRow(row[:-1] + [poly]) for row in ugroup: ucur.deleteRow()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Trying to update some well data from another layer. I am trying to do this in Arcmap (10.6) with a tool/script (3.6.10 Python). I need to transfer attributes from WellParcels to WellsPoints. I would like to do this with out starting a Edit session in python if possible as this tends to slow down the process...? I would manual start an edit session in ArcMap then run the tool/script when I have points selected, I currently have the following but error out on line 44. I am not sure this is the best/fastest way of doing it, so if someone has a different idea please share how I would do this with my data. import arcpy,os arcpy.env.overwriteOutput = True arcpy.env.workspace = r'Database Connections\Connection to blah.sde' ptSelection = "WellPoints" pointLayer = arcpy.env.workspace + os.sep + "WellPoints" parcel = 'WellParcels' sjpoints = "In_memory\sjpoints" try: ptCount = int(arcpy.GetCount_management(ptSelection).getOutput(0)) dsc = arcpy.Describe(ptSelection) selection_set = dsc.FIDSet if len(selection_set) == 0: print "There are no features selected" elif ptCount >= 1: arcpy.SelectLayerByLocation_management(parcel,"INTERSECT",ptSelection) arcpy.MakeFeatureLayer_management(parcel,"parcel_lyr") arcpy.SpatialJoin_analysis(ptSelection, "parcel_lyr" , sjpoints) #sourceFieldsList = 'WellID', 'dept', 'type', ' Geothermal' 'GeoWaterUs', 'Temp', 'TempDate' #valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)} fldList = ['WellID', 'dept', 'type', ' Geothermal' 'GeoWaterUs', 'Temp', 'TempDate'] fldDict ={} print (fldDict) targetFields = ['W_ID', 'dept', 'type', ' Geothermal' 'GeoWaterUs', 'Temp', 'TempDate'] with arcpy.da.UpdateCursor(ptSelection, targetFields) as cursor: for row in cursor row[0] = ['W_ID'] row[1] = ['dep'] row[2] = ['type'] row[3] = ['Geothermal'] row[4] = ['GeoWaterUs'] row[5] = ['Temp'] row[6] = ['TempDate'] #Attributes from Wellparcels curosr.append(fldDict['Account', 'dept', 'type', ' Geothermal' 'GeoWaterUs', 'Temp', 'TempDate']) except Exception, e: # If an error occurred, print line number and error message import traceback, sys tb = sys.exc_info()[2] print("Line %i" % tb.tb_lineno) arcpy.AddMessage("Line %i" % tb.tb_lineno) print(e.message) arcpy.AddMessage(e.message) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more