Latest Contributions by 2Quiker

I get "False" when I added the print(arcpy.Exists(workspace)). ... View more

Thanks for the replay. I have being trying different workspace formats, with r and \\, / etc. Thanks for the recommendations. I made changes based on your recommendations and I still get the darn 'cannot open workspace' error. I am trying to see if inserCursor is faster then Append. In my current code the Append process just take to long so I thought I would try insertCursor. ... View more

I have tried to implement some field mapping to change some field names and it works on the first one but then errors. I am  assuming that it is because it's is trying to change the field again? How can I by pass this on the second go around?   Error line 33. FieldMappings: Error in getting field map from field mapping for GetFieldMap   import arcpy, os from arcpy import env from datetime import datetime as d startTime = d.now() ###Working 7/2/2021 arcpy.env.overwriteOutput = True arcpy.env.workspace = r"C:\Temp\Default.gdb" fc1 = r"C:\Temp\fc1.shp" fcs = arcpy.ListFeatureClasses() #gets the feature class from database counter = 1 for fc in fcs: ###Field Mapping fieldmappings = arcpy.FieldMappings() # Add all fields from inputs. fieldmappings.addTable(fc1) fieldmappings.addTable(fc) # Name fields you want. Could get these names programmatically too. keepers = ["Field1", "Field2", "Field3", "Field4","Field5", "Field6"] # etc. # Remove all output fields you don't want. for field in fieldmappings.fields: if field.name not in keepers: fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex(field.name)) # Rename fields fieldmap = fieldmappings.getFieldMap(fieldmappings.findFieldMapIndex("DXF_LAYER")) field.name = "Field1A" field.type = 'Text' #field.aliasName = "mean_city_pop" fieldmap.outputField = field #fieldmap.mergeRule = "Count" fieldmappings.replaceFieldMap(fieldmappings.findFieldMapIndex("Field1"),fieldmap) #### #### #print(fc) out_fc = "SP_Test" + str(counter) spjoin= arcpy.SpatialJoin_analysis(fc1,fc, out_fc, "JOIN_ONE_TO_ONE", "KEEP_ALL", fieldmappings, "INTERSECT", "", "") counter += 1 fc1 = out_fc print ('(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')')   ... View more

Where are you defining 'altfields', 'updateAddress' and 'subdivisions'? ... View more

To have one feature class with certain fields and rename some fields. I can keep certain fields with the following but I need to change some fields names and just the whole fieldmappings gives me a headache.   fieldmappings = arcpy.FieldMappings() # Add all fields from inputs. fieldmappings.addTable(fc1) fieldmappings.addTable(fc) # Name fields you want. Could get these names programmatically too. keepers = ["Field1", "Field2", "Field3", "Field4","Field5", "Field6"] # etc. # Remove all output fields you don't want. for field in fieldmappings.fields: if field.name not in keepers: fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex(field.name))     I need to be able to rename  "Field1", "Field2", "Field3", "Field4","Field5", "Field6" to something else, "AFieldA", "BFieldB", "CFieldC", "DFieldD","EFieldE", "FFieldF". No specifically these names but to something else. I also need to use a merge rule and join delimiter to one layer in the database. ... View more

I guess I am confused about the who process. I was thinking./hoping I could do a spatial join all at once and spatial join would add the new fields from every feature class to the end of fc1. But it sounds like it will create a new feature class for every feature class in the database, maybe I am better off just doing individual spatial joins so I can do the field mapping.   import arcpy, os from arcpy import env import traceback from datetime import datetime as d startTime = d.now() arcpy.env.workspace = r"C:\Temp\Default2.gdb" fc1 = r"C:\Temp\Taxparcels1.shp" arcpy.env.overwriteOutput = True fcs = arcpy.ListFeatureClasses() #gets the feature class names # Creating a for loop to iterate over featureclasses for i in range(0,len(fcs)): fcs_s = fcs[i] print (fcs_s) arcpy.SpatialJoin_analysis(fc1,fcs_s, "SP_Test", "JOIN_ONE_TO_ONE", "KEEP_ALL", "", "INTERSECT", "", "")   ... View more

ok, I see what the "Counter" is doing (SP_Test1, SP_Test2, SP_Test3). The Fc1 layer has 95K features after merging all there is 361,320k features in the merged layer. I must be missing something? ... View more

When you say 'all joins' do you meaning making 20+ separate spatial joins or arcpy.SpatialJoin_analysis(fc1,fc, "memory\SP_Test" + str(counter), "JOIN_ONE_TO_ONE", "KEEP_ALL", "", "INTERSECT", "", "")   ... View more

If you don't mind sharing that would be great. I hate and think the way ESRI's traditional field mapping is so counterintuitive. ... View more

Thank you for the replies, after looking at the data a little I was wrong, I was working with the wrong data sorry about that. So the Source table has OBJECTID_1(not sure way but this is how I get the data) and the target has OBJECTID. So the InsurtCur 'Cannot find field 'OBJECTID_1'. The Source OBJECTID_1 should go into the targets OBJECTID but as I said it can't find it. Maybe I am still over thinking it... If I use append  would the ObjectID vs ObjectID_1 be an issue? I was trying use understand  search and insert cursors to understand them better. ... View more

I guess I was completely over thinking it. dsc = arcpy.Describe(Source) fields = dsc.fields #out_fields = [dsc.OIDFieldName] fieldnames = [field.name for field in fields] lstFields = [field.name for field in fields] with arcpy.da.SearchCursor(Source,fieldnames) as sCur: with arcpy.da.InsertCursor(Target,lstFields) as iCur: for row in sCur: iCur.insertRow(row)   ... View more

So can Field1A be skipped/not included when you pass the InsertCurosr, if so how? ... View more

The field Field1A doesn't exist in the source table only in the target. I guess I was thinking that line 12& 13 would take care of that issue for both the Source SearchCuror and the Target InsertCursor. ... View more