Latest Contributions by KimberlyGarbade

SDE has a lot more overhead.  For example if your database is versioned and you update a field with Field Calculator field calculator has to navigate the versioning tree and the delta tables to write the changes.  If you have editor tracking turned on, or attribute rules, or certain logging enabled on the database server these can slow you down, as can relationships that uses messaging or a geometric network.... when did you compress last, rebuild your indexes... On the database server side, how big are your transaction logs and what level of logging are you using and are the logs fragmented, stuff like that....  There are just a lot of things that can slow you down using enterprise SDE.  I guess some of these apply to a file gdb also... so no telling for sure... still 24,000% is a lot :-). ... View more

When you say it didn't work what do you mean (I.E. What message does it give you when you click which button)? Also, when you open the connection file's "connection properties"; if you don't change the username and password, can you click on the "Database" dropdown and see the name of the database you are try to connect to?  Is it only when you hit "OK" that it gives the message? KimGarbade_0-1647873113703.png   ... View more

I liked this question because I've been looking for a reason to mess the multi-part polyline paths object for a while.... Three lines of code is easier to read, but you can do it in 1 (very bottom... in keeping with the "most succinct" theme) var pathcount = Count(Geometry($feature).paths)-1 var linepath = Geometry($feature).paths[pathcount] return Back(linepath).x +","+ Back(linepath).y In the image below the selected polyline is multipart.  The blue labels are just the vertices of the lines labeled with their coordinates. The black labels are the results of the code to label the last vertex of each line. KimGarbade_0-1647694736433.png One line: return Back(Geometry($feature).paths[Count(Geometry($feature).paths)-1]).x +","+ Back(Geometry($feature).paths[Count(Geometry($feature).paths)-1]).y ... View more

Have you tried seeing if your "transf_FS" feature set has any records in it?  Something like: var transf_FSCount = Count(transf_FS)   if (transf_FSCount > 0){       if(IsEmpty(t.assetid)){           return domainName...and the rest of your code here           .           .       }   }   I'm thinking Arcade might be returning t as a type "Feature" because the First function returns a Feature if a FeatureSet is used as input into the function... regardless of if that chunk of memory defined as t (a Feature) holds any actual data or not. ... View more

When you create a successful connection to a SQL Server instance ArcGIS Pro creates a "NameOfTheConnection.sde" file on a drive somewhere.  You can use this connection to connect to the database using the "Add Database" option instead of the "New Database Connection" option.  Can you reference, or copy a successful .sde file from one of the other computers that can connect, to a network drive you have access to and try that file?  If it works or if it doesn't... either way its a clue to what's going on creating a new connection. ... View more

I think you want to use the "paths" property of the $feature's geometry KimGarbade_1-1647548954980.png If you look closely at the labeled line below you can see that it shows the coordinates of a "multipart" polyline.  See how there are two opening and closing brackets every so often.  These "[[" and "]]" brackets contain the coordinates of multiple parts of the same line. KimGarbade_0-1647548237194.png This code uses "paths" to return the first point of the first polyline part: KimGarbade_3-1647550109431.png This code uses "paths" to return the first point of the second polyline part: KimGarbade_2-1647549989513.png Unless there is a way to do it I'm unaware of, I think you will have to construct what your looks for from this structure.   ... View more

By the greyed out check mark next to the Colorado County Boundaries box I would say that the layer is set not the turn on at the scale you are mapping it at.  Right click the layer in your table of contents and select Properties.  Then go to the General Tab and see if it is set to turn of out beyond or in beyond a certain scale?  KimGarbade_0-1647547068796.png   ... View more

Sounds like your ArcGIS Pro version might be out of step with your geodatabase version:  Client and geodatabase compatibility—ArcGIS Pro | Documentation You are wise not to delete geodatabase objects using SSMS. I would check your ArcGIS Pro version against your geodatabase version (you can use SSMS to open the SDE.SDE_Version table or query that table to see your gdb version).  You could try connecting to the database using a different ArcGIS Pro version (one more compatible with your database version) and see if that helps.  --------------------- P.S. I'm not suggesting you do it (but in case you infer from the above link it might be a course of action), but changing your geodatabase version isn't something I would do without thinking about it hard and planning for it with other concerned parties (I.E. What other departments might be effected, what versions of Pro does everyone in our organization use, what services might be using the database, what version of Enterprise is your organization using)...you could go from one problem to a bigger problem...Before you do anything like that back the database up and verify the backup was successful.   ... View more

A few questions.   1)  What is a well stick (how is the data formatted)? 2)  You only want the first and last well of the section going from East to West or North to South or both (Looks like East to West)? 3) In your example the well lines (Are  these the sticks?) are mostly parallel to your East and West section lines and straight.  Is this typical, or can they be more unpredictable?  Say running East/West or turning? 4) I see in your example that it looks like two lines are almost identical along the West edge of the section.  Using the coordinates at the midpoint of the line might not give you the one you want in this case (I.E. the one that is truly closest to the section boundary.  Would that matter? Would you want to return both?  ... View more

You didn't include the other fields you were comparing in the function definition. KimGarbade_0-1646994150351.png   ... View more

Yes. It's populating the transformers array with the GlobalIDs of the individual features in the feature set fsDeviseIntersects. It uses the array later to know which transformers it is going to mark as needing calculation.  ... View more