Latest Contributions by 2Quiker

I removed the try block. I get the following error, ERROR 000055: Cannot create a Query Table for this workspace Failed to execute (MakeQueryTable). ... View more

Ha ha your right, I guess I was over thinking it. ... View more

I did try the following.   workspace = r"C:\Users\***\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog\***_***_***.sde" fc1 = os.path.join("***.***.TEST","***.***.Test") & workspace = r"C:\Users\***\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog\***_***_***.sde" fc1 = "***.***.TEST","***.***.Test"    But adding the workspace to the os.path.join is what allowed me to edit.   workspace = r"C:\Users\***\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog\***_***_***.sde" fc1 = os.path.join(workspace,"***.***.TEST","***.***.Test") #adding workspace worked.   ... View more

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