Latest Contributions by KimGarbade

Looks like these folks had the same problem and accepted a solution... I hope this helps. If you've seen this link already, I apologize for resending it. Solved: Attribute Rule when splitting a line - Esri Community

Hi, Are you exporting to PDF? If so, are you using the Export button or the Print button. If your using Export, you might try using the Print button and selecting "Microsoft Print to PDF" as your printer.... assuming you're creating a PDF that is.... I've also read some posts that people have exported to .jpeg and then converted that to PDF. If you don't have these options configured or you need another format, could you share an image of your Export window with the options you selected.

I have a polygon feature class (FC) in my database containing information about source documents we obtain from outside sources. Each source is given a polygon boundary and entered into the FC using an internally assigned unique identifier. Other information about the source is also entered into this FC (datums, dates, etc). When data from one of these sources is entered into an asset specific FC in the same database (Inlets for example), I would like for the newly created feature to obtain its HorizDatum attribute information from the Source FC based on the source's unique ID being entered into the feature template. I thought that if a user entered the unique identifier of the source into the "SrcLink" field in the feature template (SrcLink being used to link the asset back to the source we acquired it from) that I could use this value to pull data from the Sources polygon FC, but all my efforts are in vain. No matter what is entered into the template I only get the default value for datum (Unknown in our case) rather than the datum contained in the Sources FC. Is there a way to use feature template values in Arcade Calculate Rules? Thank you for all your help. K

‎01-15-2024

Un... sorry. Should have mentioned that.

‎01-15-2024

I have a table that contains no spatial data. It exists in an SDE enterprise geodatabase (SQL Server). The table contains log information generated by an FME process; data related to if a certain process ran successfully or not and why or why not. Again, this table contains no spatial data, but it is registered with the GDB. My question (and I should know this after 100 years) is can I use straight up SQL Server SQL commands to update the table (using SQL Executor in FME) or do I have to use a Writer that points specifically to an "Esri geodatabase (SDE)" format. Basically my question is can I edit a non-spatial table that is registered with the geodatabase using native SQL commands and cut an Esri client out of the picture? The native SQL just seems much faster without the overhead. At different times I've heard Yes, I've heard No, I've heard Yes but you shouldn't, I've heard Yes and it didn't hurt anything.... but nothing official. Thank you for your time.

‎12-21-2023

Sorry to keep bothering you but I have a window in the next week or so when we will have almost zero users and I want to make sure I get it right the first time. Does this sound like a good process flow: Delete any old versions that have already been rec and posted or which can be discarded. Check the remaining versions for conflict with default. Create a new version to accept the new district edits. Turn off my arcade rules and editor tracking. Make the edits in my version (using python) Rec and Post new version to default (which is protected by-the-way) Turn editor tracking and arcade rules back on

‎12-21-2023

Thank you so much for the quick and extensive response. I'll use the python method rather than the Arcade. Should I create a new version and make the edits there and then push them to default through a rec and post, or is editing Default an option (I hate that usually)?

‎12-21-2023

I have a branch versioned geodatabase in SQL Server. The database contains 300,000 features spread across 14 feature classes. One of the attributes of each feature in the GDB is “PlanningDistrict” (each of the 300,000 features has a district populated). The value is populated automatically by arcade scripts during data entry. Recently the planning districts were redrawn (many added, some deleted, all reshaped), so now I have to update literally every feature in the database. The actual calculation of the new data is not a big deal (we’ll just use Arcade), but what I’d like to know is what are the implications of versioning, what should I turn on and off (I.E. versioning, the arcade scripts, etc.)? What is the best/recommended way of going about this. More information is that we do have a few outstanding versions with edits at the moment.

‎08-09-2023

Too bad you didn't get a reply. This is my problem also in 2023.

‎04-06-2023

Thank you Joshua, I like this a lot. It makes perfect sense to me. We used to do this in the old days before database sequences. Since this has to be an everyday problem, I thought I was missing something that had to be built into AGOL natively to solve it, but I guess I'm not. Note to Esri though. Support for attribute rules would be AWESOME, and a database sequence object would be appreciated. If it's there already and I'm missing it, please let me know and I apologize to Esri. Thank you again Joshua.

‎04-05-2023

I think this object Domain—ArcGIS Pro | Documentation and this function ListDomains—ArcGIS Pro | Documentation are what I would try. The result looks like a dictionary, so should be pretty easy for format. Hope this helps. K

‎04-05-2023

I have a hosted feature layer on AGOL. This layer is editable. When a new feature is added I have to create a new "SmartID" prefaced with the side of town it falls within based on overlay analysis and then using the next highest value from a database sequence (IE VALV-N-0001 the next one could be VALV-S-0002). I originally wrote this pretty fast in the Pro I published the service from using Arcade, an Attribute rule and a database sequence....Come to find out Attribute rule don't work in AGOL....OUCH....I thought I'd come up with a work around using a Template/Form for data entry in AGOL and using Arcade again to create a calculated value in the AssetID field, but now I find out that AGOL (I guess) doesn't know what database sequences are either since Arcade doesn't understand "nextsequencevalue" in the context of the Form (and I definitely had a database sequence contained in the database I publish from, but I guess it doesn't get published automatically and I can't find how to publish the sequence for use in AGOL).... AGOL also (to the best of my knowledge) doesn't have an iterating data type I can use as a sequence replacement.... What am I missing!? There has to be a way to assign the next highest ID (other than ObjectID) to a new asset created in AGOL? Any help would be appreciated.

‎02-22-2023

We've written a scripting tool in ArcGIS Pro 3.0.1 (Python API) that allows a user to select a Layer Name from a portal using a dropdown list. The tool reports back which web maps on the portal the layer is used in. The script works well, but we've noticed that once a layer has been removed from a web map and we run the tool again selecting the same layer name, that the map from which the layer was removed still shows up on the list of web maps the layer is used in. Its almost like the web maps JASON isn't being updated to reflect the changes that have been made to it. Is their a way to refresh or update portal information so we can see the most recent web map data (I.E. showing the layer has been removed) so the map will not show up on the tools output list again?... I really don't think its a problem with the code.

‎01-17-2023

I know this post isn't "fresh", but I wanted to thank you for that first line of code in the solution. Fantastic! I knew I had used an attribute of $feature in a filter before, but I couldn't remember the syntax and finding it online is close to impossible...maybe I'm Google search challenged. Finally, I tripped over it here (probably where I stole it from the first time I did it). Man, could Esri have come up with a more convoluted syntax?... Tildes, single quotes, 2 dollar signs, and every kind of bracket....Yikes. Thank you for figuring this out for all of us.

‎01-09-2023

The syntax you are debugging is specific to using field calculator in Pro or ArcMap when updating a table's field (using the Python Expression Type). You could try entering it there and testing it (I.E. the expression in the top box and the code block below like this) I debugged it using Python in Spyder like this (since python doesn't understand the syntax "CodeBlock" as far as I know, and the code block itself is just a python function.): # -*- coding: utf-8 -*- """ Created on Mon Jan 9 11:17:59 2023 @author: Tester """ lengthField = 10 widthField = 5 num = 2 expression = "reclass(!%d!,!%d!,!%d!)" % (lengthField, widthField, num) def reclass(lengthField,widthField,num): if ((lengthField/num) >= (widthField)): return 'True' else: return '' print (expression) print (reclass(lengthField,widthField,num)) The result was I hope I understood you question correctly and that this is helpful. K

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by KimGarbade

Re: Attribute Rules for handling a unique internal ID

Re: Missing Features after Exporting Layout

Using values from a feature template in an Arcade calculate rule

Re: Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands?

Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands?

Re: Recommendations for massive update of branch versioned data.

Re: Recommendations for massive update of branch versioned data.

Recommendations for massive update of branch versioned data.

Re: Enterprise geodatabase Schema case (upper/lower)!

Re: Best way to create a sequence based ID hosted feature layer

Re: Want to add a list of domain values to a script that lists fields and field details for each feature class in a specified feature dataset

Best way to create a sequence based ID hosted feature layer

Update Enterprise Content Data

Re: Arcade: Create Filter On Buffer & Intersect of Feature

Re: Correct Codeblock Python syntax for CalculateField

Recommendations for massive update of branch versi...

Re: explain SQL statement for Branch version

Best way to create a sequence based ID hosted feat...

Re: Can a user input variable be used in an expres...

Re: Workflow Manager Server - Cannot see jobs assi...