Latest Contributions by CCWeedcontrol

Where is your "NEW" pointing to? Also why do you have line 9 commented out? ... View more

Great info, thanks for sharing Cort! ... View more

I have set the section grid as the iterate but it appears i am getting an error.  I recreated the model and got to work, i guess the first model got corrupted or something. ... View more

Are you running this tool in ArcMap or Pro? I believe once you close out of the program the In_memory is deleted. Do you have a arcpy.Delete_management("in_memory\MN__Table") at the end of you script? Your best bet is to write\export the report out then the next time you run the script overwrite it. ... View more

Yes i am good, but still wondering why having arcpy.env.preserveGlobalIds = True would cause an empty feature class. ... View more

After some further investigating i found the issue was with arcpy.env.preserveGlobalIDs. I had this at the top of my script :arcpy.env.preserveGlobalIds = True: I am not sure why it worked after removing this line. Why would this create  an empty feature class? The original feature class did not have GlobalIds. ... View more

I modified the code to this but i am still getting empty features... Taxparcels = "C:/Temp/Scratchworkspace.gdb/TaxParcels1" mem_fc = arcpy.CopyFeatures_management(Taxparcels, r"in_memory\TaxPar") fl = arcpy.MakeFeatureLayer_management(mem_fc, "TaxPar") query = "PIN LIKE 'Q%'" arcpy.SelectLayerByAttribute_management(fl, "NEW_SELECTION", query) if int(arcpy.GetCount_management(fl).getOutput(0)) > 0: arcpy.DeleteFeatures_management(fl) arcpy.FeatureClassToFeatureClass_conversion(fl, "C:/Temp/Scratchworkspace.gdb", "TEST") ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I am not sure what all of it means but these are the ones i believe to know and i could be wrong. Maybe and hopefully someone else can answer what i am missing. Dan Patterson helped me update my field mapping, i had an older version of it. Maybe he can shine some light... Name = DXF_TEXT Alias = DXF_TEXT True = Editable True = Non Editable False = required Length = 11 scale = 0 Precision = 0 Merge rule = First join Delimiter = # (meaning ' ' , Null string) ? = {0} Data source field = DXF_TEXT ? = -1 ? = -1 ... View more

I had a hard time understanding field mapping until someone posted a code. I use the code below and works great. import arcpy,sys from datetime import datetime as d startTime = d.now() start_time = time.time() PT1 = "C:/Temp/Scratchworkspace.gdb/Drain" FieldMapString = ''' DXF_TEXT "DXF_TEXT" true true false 11 Text 0 0 ,First,#, {0}, DXF_TEXT,-1,-1; ACCOUNT "ACCOUNT" true true false 11 Text 0 0 ,First,#, {0}, ACCOUNT,-1,-1; PIN "PIN" true true false 13 Text 0 0 ,First,#, {0}, PIN,-1,-1; ACRES "ACRES" true true false 4 Double 0 0 ,First,#, {0}, ACRES,-1,-1; Instrument "Instrument" true true false 10 Text 0 0 ,First,#, {0}, Instrument,-1,-1; SiteAddres "SiteAddres" true true false 106 Text 0 0 ,First,#, {0}, SiteAddres,-1,-1; SiteCity "SiteCity" true true false 32 Text 0 0 ,First,#, {0}, SiteZip,-1,-1; SiteZip "SiteZip" true true false 10 Text 0 0 ,First,#, {0}, SiteZip,-1,-1 ''' def Layers1(PT1): """pass the variable and the constant into the function """ fieldmappings = arcpy.FieldMappings() fieldmappings.loadFromString(FieldMapString) return fieldmappings def main(args=None): if args is None: args = sys.argv # Process: Feature Class to Feature Class arcpy.Append_management(PT1, "C:\Temp\Scratchworkspace.gdb\PT_ALL","NO_TEST", Layers1(PT1)) try: print ('(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')') except Exception as 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) print (e.message)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I upgrade to Pro 2.3 this morning and now i am getting this error on line 81 and i didn't change the script at all. RuntimeError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. import sys, arcpy, os, fnmatch from datetime import datetime as d startTime = d.now() start_time = time.time() # Local variables: print ('Started') arcpy.env.overwriteOutput = True arcpy.env.workspace = "C:/Temp/Scratchworkspace.gdb" arcpy.env.qualifiedFieldNames = False arcpy.env.preserveGlobalIds = True PT1 = "C:/Temp/Scratchworkspace.gdb/Drain" FieldMapString = ''' DXF_TEXT "DXF_TEXT" true true false 11 Text 0 0 ,First,#, {0}, ACRES,-1,-1; ACCOUNT "ACCOUNT" true true false 11 Text 0 0 ,First,#, {0}, ACCOUNT,-1,-1; PIN "PIN" true true false 13 Text 0 0 ,First,#, {0}, PIN,-1,-1; ACRES "ACRES" true true false 4 Double 0 0 ,First,#, {0}, ACRES,-1,-1; Instrument "Instrument" true true false 10 Text 0 0 ,First,#, {0}, Instrument,-1,-1; SiteAddres "SiteAddres" true true false 106 Text 0 0 ,First,#, {0}, SiteAddres,-1,-1; SiteCity "SiteCity" true true false 32 Text 0 0 ,First,#, {0}, SiteZip,-1,-1; SiteZip "SiteZip" true true false 10 Text 0 0 ,First,#, {0}, SiteZip,-1,-1; ''' #print(FieldMapString.format(PT1)) def Layers15(PT1, FieldMapString): """pass the variable and the constant into the function """ fieldmappings = arcpy.FieldMappings() fieldmappings.loadFromString(FieldMapString) return fieldmappings def main(args=None): if args is None: args = sys.argv # Process: Feature Class to Feature Class arcpy.FeatureClassToFeatureClass_conversion(PT1, "C:/Temp/Scratchworkspace.gdb", "PT_ALL","", Layers15(PT1, FieldMapString),"") print ("Finished") print ('(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')') try: print ('(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')') except Exception as 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) print (e.message) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

ok i think i understand. so i tired to run what you posted to test but i am getting invalid syntax on line with %timeit Tester() ... View more