Latest Contributions by Bud

‎03-03-2022

I found this post just now, which confirms what @JohannesLindner mentioned. Where do the Arcade Console messages go to?

‎03-03-2022

In an Arcade attribute rule: Is there a way to compare a feature's geometry before the edit was made... vs. ...the edited geometry? Example: If the pre-edit geometry is different from the edited geometry, then do x to the geometry. Else, do nothing. Related: Attribute Rules: Update only on geometry change I was hoping I'd be able to use $feature.shape as to get the pre-edit geometry. But that failed. Which is weird, because I can use $feature.shape_length without issue.

‎03-03-2022

Side question: In your post, it looks like you are sending an output to the console(). Out of curiosity, what are you doing there? Where are you displaying that value? Thanks.

‎03-03-2022

Related: What is the hierarchical structure of the ArcPy Geometry class?

‎03-03-2022

I'm a novice learning about Arcade. From my limited experience, it seems like there is a hierarchical nature to Arcade types and subtypes. If that’s correct, what does the hierarchical structure of geometry types look like? - Geometry - Point - Multipoint - Points - Polyline - Paths - Points - Polygon - Rings - Points - Envelope Also, are the types considered to be object oriented?

‎03-03-2022

Arcade geometry types and subtypes (point, polyline, etc.) are immutable. It’s not possible to change them after they’re created. As a novice, I’m wondering: Is there any chance those types could be enhanced so that they’re mutable? If so, that would make writing expressions for calculation attribute rules easier. (edited)

‎03-02-2022

If I understand correctly, the Arcade Geometry type has subtypes: Point Multipoint Polyline Polygon Extent Question: Are those subtypes immutable, since the Geometry supertype is immutable? Geometry is immutable, meaning it is not possible to change the geometry after it is created. For example, if I assign a value to a point, does that mean that geometry can't be changed? var pt = Point({ 'x': 100, 'y': 100, 'spatialReference':{'wkid':102100} });

‎03-02-2022

It would be helpful if there were a way to test polyline calculation attribute rules in the Arcade Developer Playground: https://developers.arcgis.com/arcade/playground/ Currently, it looks like that's not possible: Source code here: Code Review SE - Modify polyline vertices

‎03-02-2022

Could Esri consider adding a measureOnLine() function to Arcade? Returns a measure from the start point of the line to the in_point. measureOnLine (in_point, {use_percentage}) Parameter Explanation Data Type in_point A point that is used to measure from the start point of the polyline. Point use_percentage If False, the measure will be returned as a distance; if True, the measure will be returned as a percentage. (The default value is False) Boolean Return Value Data Type Explanation Double A distance or percentage. That would be helpful for linear referencing purposes.

‎03-02-2022

Migrated from a duplicate idea: I have calculation attribute rules that only needs to be run if the geometry is edited. Example: If a new feature is created or if an existing feature's geometry is edited, then: Redefine the M-Values by setting them to the cumulative length of the line. It's not necessary to run those kinds of calculation attribute rules if only the non-spatial fields get edited. And there are scenarios where unnecessarily running the attribute rules causes slow performance. Could an optional setting be added to calculation attribute rules that would let us only run the rule if the geometry has been changed?

‎03-02-2022

When copy/pasting a FC in the same GDB: The new FC will have a different name, since duplicate names aren't allowed. However, the alias from the original FC will be brought over as the alias for the new FC. We often don't think to change the alias, so it means both FCs will have the same alias. It's very confusing when two different FCs have the same alias (seemingly the same name) when dealing with them in Contents, Fields, Attribute Rules. Could Esri change that behavior so that the new FC doesn't inherit the alias from the old FC? And just make the alias be the same as the FC name -- until the user changes it? I think that would be the preferable option.

‎03-02-2022

If a user is viewing a table in an ArcGIS Pro map, then the table becomes locked from calculation attribute rule changes. Could ESRI make it so locks only occur if the table is being actively edited? Or alternatively, give us an optional setting to not lock the table at all? Thanks.

‎03-02-2022

Possible workaround: Create an attribute rule that compares the true length vs the densified length. If there is a difference, then there is a curve, so prevent the user from saving the edit. More info here: https://community.esri.com/t5/arcgis-pro-ideas/hascurve-arcade-geometry-property/idc-p/1149449/highlight/true#M18873

‎03-02-2022

In the meantime, I wonder if this would be a possible workaround: 1. Create a field in the feature class called HAS_CURVES. 2. Populate the field in real-time/when a user creates or modifies a feature -- using a Calculation Attribute Rule. Compare $feature.shape_length, which is the true length, including true curves vs. Length($feature), which is the pre-densified length, where true curves have been converted into straight segments. https://i.stack.imgur.com/ilJrg.png If there is a difference between those two values, then that tells us that the line has curves. Use a Calculation Attribute Rule to set the HAS_CURVES field to "Y". 3. That field would be available to SQL. So we could query on it as needed. Disclaimer: It's possible that comparing the those lengths might not work in all scenarios (due to rounding complications, etc.). Testing would be needed. As the idea suggests, it would be a lot more robust to have a SDE.ST_HasCurves() function in ST_GEOMETRY. Related: Idea: hasCurve Arcade geometry property Calculate length of line without using length function (and without densifying curves) Select SDE.ST_GEOMETRY polylines that have arcs?

‎03-02-2022

Currently, in ArcGIS Pro, SQL field calculations are only possible for unversioned EDGB data. SQL expressions support faster calculations for feature services and enterprise geodatabases. Instead of performing calculations one feature or row at a time, a single request is sent to the server or database, resulting in faster calculations. Only feature services and enterprise geodatabases support SQL expressions. For other formats, use Python or Arcade expressions. Using the SQL option for the Expression Type parameter has the following limitations: - The option is only supported for Db2, Oracle, PostgreSQL, SAP HANA, and SQL Server enterprise geodatabases. - Calculating field values on joined tables is not supported. - Versioned and archived data is not supported. - The ability to undo geoprocessing operations is not supported. It would be helpful if SQL field calculation support could be expanded to versioned data too. Specifically, traditional versioning, with the option to move edits to base.

My Ideas

Latest Contributions by Bud

Re: Are Arcade geometry subtypes immutable? (i.e. point, polyline, polygon)

Compare pre-edit geometry with edited geometry

Re: Are Arcade geometry subtypes immutable? (i.e. point, polyline, polygon)

Re: What is the hierarchical structure of Arcade geometry types? Are they object oriented?

What is the hierarchical structure of Arcade geometry types? Are they object oriented?

Make the Arcade geometry types and subtypes mutable?

Are Arcade geometry subtypes immutable? (i.e. point, polyline, polygon)

Test polyline calculation attribute rules in Arcade Developer Playground

measureOnLine() function in Arcade

Only run calculation attribute rule if geometry is edited (optional setting)

Don't inherit FC alias when copy/pasting in same GDB

Only lock attribute rules if table is being edited

Re: Prevent users from creating true curves

Re: Determine if line has true curves via SQL (SDE.ST_GEOMETRY in Oracle)

Use SQL for field calculations on versioned data (option to move edits to base)

Would a EGDB constraint attribute rule error messa...

Advanced views without locking layer schemas

Computed column (SQL expression field) in AGOL tab...

What are the rules when setting default values for...

Run Notebook from Enterprise Data Pipeline

ArcGIS Arcade

Experience Builder Tips and Tricks

Roads and Highways User Group (RHUG)

GIS Jobs

Mapping and Charting Enterprise Databases