Latest Contributions by KimberlyGarbade

How did you make the connection to your SQLite database in the "Edit Query Layer" dialog? I don't use SQLite database very often and I can't seem to connect via this dialog to test it.  I know I'm asking more questions than I'm answering, but trying to wrap my head around this.     ... View more

Sorry, I'm not at the computer I wrote that code on (that was my home PC).  So I don't have a text version of the code here (at work), but the code I used was in the first image above.  There are no lines of code either above or below the lines shown (no lines below line 27). I wrote the code in Spyder, which is a third party Python editor, but it should work in any python environment that supports arcpy. ... View more

Sorry about all the questions but just to  be clear: you see all zero's when you open the table from the Contents pane and you see the Route_Type field populated correctly when you open the same table from the Catalog pane?  Hmmm...that is odd in my experience.  Where (in what context or dialog box) are you using the "SELECT ROUTE_TYPE FROM main.Roads" query (or the "SELECT * FROM main.Roads" query)? Again sorry about all the questions.   ... View more

In the first image example above (all zeros) when you say you "open the Attribute Table for this layer", what method are you using to open it?   ... View more

Its not an ArcGIS Pro centric solution, but if you are running windows you can hit the "Windows" key and the "+" key at the same time and it will bring up a menu that will let you zoom in on your screen making everything larger.  To go back to the original view its "Windows" and the "-" key. ... View more

I'm assuming you mean that one location (having the same ID across all of the input layers) has multiple records in the source layers (maybe different sampling events) and you want to average them?  Can you give us an idea of the result you want to achieve?  I.E. Do you want the average in a separate table, do you want to label each point with the average, generate a report, symbolize based on the average value?  ... View more

There might be more elegant ways of doing it but this worked for me.  I wrote this in Spyder: result in my test data:   ... View more

What version of Pro are you using and what version is your enterprise?  We had some "issues" (problems) recently with our Enterprise being at 10.8.1 and the Pro version we were using to edit our branch versioned data being at 2.9.1.... workflow manager was acting odd, the error inspector wasn't working correctly... turns out that it was a compatibility issue between our Pro and Enterprise versions. ... View more

You might have accidentally set the Trace With Offset option (or some other offset option):   But, It almost looks like something else I've seen in the past, something old school in todays project on the fly world... Are the traced polygons in a different feature class than the polygons they were traced from?  The reason I ask is that these two polygons are in different feature classes.  The yellow was traced from the green.  One feature class uses StatePlane NAD 27, the other uses StatePlane NAD 83, and the Map they are loaded into is set to use WGS 1984 Web Mercator (aux sphere).... it almost looks to me like they are two different feature classes with two different datums.   ... View more

I guess we need to upgrade our enterprise to 10.9.1.  We are only running Pro 2.8.5 because 2.9.1 was not working with Workflow Manager Server because our enterprise was at 10.8.1... that was also a bug, so maybe the only overall solution is 2.9.1 paired with 10.9.1. A few more questions.  Validation rules written in pure Arcade can co-exist in the same database schema with Built in Attribute Rules (I.E. we have both types stored in a feature class at one time) but is this a supported configuration?  Should all the rules be either pure Arcade OR Built-In and not mixed? 2) Is it expected behavior that when you use pure Arcade validation rules, when the error is fixed by a reviewer, that the error is deleted from the Error Layers (I.E. the "VALIDATIONLINEERRROS" table)? ... View more

Hi @JayCary  We are using ArcGIS Pro 2.8.5 and ArcGIS Enterprise 10.8.1 and SQL Server 2019 Some more info on my Map Service if it helps.  The two features I break on purpose both flag as errors with "validation required"  I fix the error.... And the pipes still flag as errors, only this time with "no validation required, has errors."   My very simple rule is supposed to check that: if a pipe's "Profile" is set to "CIRCULAR" that its Width is set to "0" (we only store dimension data in the Height field for a circular pipe, width should be 0).  The built in validation rule finds the pipes when I edit them to break the rule, but not when I update the pipe to fix the problem... maybe it is a problem with my Built In Rule's logic: Another mystery is that if I view the "VALIDATIONLINEERRORS" table by opening the Line Errors table in ArcGIS Pro the "Last Update" date is set to 2/18/22 even though I last edited the feature class being checked today and I last ran the Error Inspector today (2/23/22). Its almost as if those records are "stuck" in the table. Thank you for your time and patience.  ... View more

Have you tried textColor? ... View more

Sorry, just a quirk of English (and it's the only language I know), but I meant is there only one record in the entire table and does it reference parent_state_id zero?  This would mean that you have reconciled and posted all child versions up to default and then compressed the database to get it to "state 0".  The reason I asked was because I got the impression that this is what you were trying to do, and if it had succeeded (and there was only state zero represented in the table) it might have given us a clue as to the "Target state not found.." message...I.E. that it didn't make a lot of sense given your database state. However, the table seems to indicate versions still exist, so the message is probably correct.   If you think you should be at state 0 (I.E. that you should only have default and no children) then running the repair tools is probably your best option; unless you know for sure when the unreferenced state was created and how; and that restoring a backup and correcting the problem would only cost you very little work related to lost edits.... No matter what you try though please take @CraigRussell 's advise and make sure your backups are rock solid.   ... View more

Dang... now I'm going to have to look at it closer.... I found the sample map viewer project the original code you borrowed from was based on (I don't have good cluster data to test against).   Power Plants around the Globe (arcgis.com) I then copied your code in a custom clustered popup in that project and just changed the attribute names back to the names from the original code your borrowed from (I.E. your code with just field names changed). And.... it worked :-(. I would have preferred if it didn't because then I would have something to solve for. Here's the code I used if it helps.  Maybe I changed something small like a comma or capitalization without realizing it.  Hope this helps.  If nothing else, the fact that it works might provide a clue.   ... View more