Latest Contributions by MatthewDriscoll

I see.   I think its more important to change the db_connection_properties.  Really you should probably change all the connectionProperties when changing to a different databases, it seems you are only changing some of the properties.   Try to find and replace every single property.  See the ESRI sample below which includes every property, without joins or relates, I believe.   {'connection_info': {'authentication_mode': 'OSA', 'database': 'Uhuru', 'db_connection_properties': 'Dunbar', 'dbclient': 'sqlserver', 'instance': 'sde:sqlserver:Dunbar', 'password': '*********', 'server': 'Dunbar', 'user': 'Sly', 'version': 'sde.DEFAULT'}, 'dataset': 'Uhuru.SDE.RangerStations', 'workspace_factory': 'SDE'}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

This is what I use, first I get the current connection info and then replace it using parameters. import arcpy arcpy.SetProgressor("1234", "working on updating sources...") aprx = arcpy.mp.ArcGISProject("CURRENT") find_dict = {'connection_info': {'user':'username','password':'userpassword','version':'sde.DEFAULT'},'workspace_factory': 'SDE'} newuser = arcpy.GetParameterAsText(0) newpassword = arcpy.GetParameterAsText(1) version = arcpy.GetParameterAsText(2) replace_dict = {'connection_info': {'user':newuser,'password':newpassword,'version':version},'workspace_factory': 'SDE'} aprx.updateConnectionProperties(find_dict, replace_dict,"",False)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

It is not exactly clear what you are asking, but you could probably start by calculating the watershed of each point to get a better idea.   Fill -> Direction -> Accumulation -> Snap Pour Point (these will be E, F, G, H, I) -> Watershed. ... View more

You could write a python script to loop through the layers and set the visible property.    ... View more

I see you put this in the Desktop category.   It is to my understanding they are not enhancing Desktop anymore, all the focus is on Pro now.   ... View more

For a Python 3 Expression try.  str(!INLET_ID!) + str(!OBJECTID!-39618)‍‍‍ There are several ways to pad it with zeros in python and you do not need to add an extra step.  Here is an example. str(!INLET_ID!) + str(f'{!OBJECTID!-39618:04}')‍‍‍‍ ... View more

After you create a version and before you change it try creating a connection to it.    CreateDatabaseConnection_management  ... View more

The status of Esri BUG-000121285 - Angle Alignment set to "Display" is not honored after printing the map directly from ArcGIS Pro. - that you have been associated with has been changed to Implemented. Public Explanation:                     Case Number: 02290974                             Version Fixed: 2.3.2 ... View more

Wow.   I am not sure what I first searched before asking now.   Thanks ... View more

I was just testing the Copy and Project to show that you are perhaps going down the wrong path.  I did not see anything that stuck out.  If I were you I might comment out as much as you can and maybe test it line by line until the behavior is reproduced to find your smoking gun.    ... View more

What I was pointing out was that if you look at the numbers, on the original photo, they are not +1, this shows that the copies of the main feature classes are getting copied more than are getting put on the TOC.   I simplified the code and ran it and was not able to reproduce this problem.   Also, after reading the Project documentation I found I steered you down a wrong path, you cannot use the in_memory for that particular tool.  Which is why you got that error. import arcpy arcpy.env.overwriteOutput = True output_gdb = r"C:\\Users\\mdriscoll\\Desktop\\New Folder\\abc\\Default.gdb\\" exclude_list = ["A","E"] fc = output_gdb + "pnt" with arcpy.da.SearchCursor(fc,"*") as cursor: copy = output_gdb + "copy" outCS = arcpy.SpatialReference('NAD 1983 UTM Zone 11N') outputCS = output_gdb + "copy_proj" for row in cursor: field = row[2] if field in exclude_list: continue else: arcpy.CopyFeatures_management(fc,copy) arcpy.Project_management(copy, outputCS, outCS) print(field) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Nothing really sticking out here for the reason of the behavior.  I really do think it is something in your code and not a bug for the following reason:   The original example screen shot shows that a copy is getting created a lot but only every other third ends up in the table of contents.  So it seems like it still creates a copy when it is in your exclude_list (continue) but does not go into your TOC.    I do agree that it creating a new copy of the original on every loop and some of them getting added to the TOC is a major factor to slowing it down.     ... View more

Click on the field and hit the Delete button on your keyboard. ... View more