|
IDEA
|
ArcGIS Pro Attribute Rules: It would be nice if there were a way to copy the error message text to the clipboard: Copying the text would be convenient for googling and documentation purposes.
... View more
02-28-2022
12:53 PM
|
1
|
2
|
1143
|
|
POST
|
Arcade — ArcGIS Pro 2.9 — FGDB: I have a Arcade_Length field in a polyline FGDB FC that I populate using a Calculation Attribute Rule: Length($feature) Question: Why is the Length($feature) value different from the Shape_Length value? I would have expected the two lengths to be the same.
... View more
02-28-2022
12:40 PM
|
0
|
4
|
3364
|
|
POST
|
ArcGIS Pro 2.9 Attribute Rules: Is there a way to copy the error message text to the clipboard? Copying the text would be convenient for googling and documentation purposes.
... View more
02-28-2022
11:25 AM
|
0
|
1
|
828
|
|
POST
|
@JohannesLindner Good points. Regarding versioning: I suspect that versioning with the option to move edits to base could solve some of the issues you mentioned. Regarding error handling: I believe it's possible to put error handling in Oracle PL/SQL triggers...and then that error message gets returned to the ArcGIS application (such as ArcGIS Pro). IF v_upd_row = 0 THEN raise_application_error ( -20001, 'a custom message that pops up in ArcGIS Pro'); END IF; That error message would be displayed in a popup message in the application. It'd be the same kind of message that you'd get for any other database-related error. Source: Prevent deletes in a versioned table at the database level By the way, if you're a data owner, the data owner likely has CREATE TRIGGER privileges. So in a pinch, you could probably create triggers if you needed to. But it sounds like you don't. You could install an SQL client or you could execute SQL statements using the ArcSDESQLExecute ArcPy class. I just thought I'd mention that...for anyone else who might be reading this post.
... View more
02-28-2022
10:00 AM
|
0
|
1
|
7994
|
|
IDEA
|
Regarding the Densifiy() function in Arcade: It looks like we only have the option to densify using maxSegmentLength. We don't have a way to densify using an angle. Could ESRI consider adding the option to densify using an angle too?
... View more
02-27-2022
08:51 PM
|
2
|
4
|
1115
|
|
POST
|
FYI - I submitted an ArcGIS Pro Idea: Prevent users from creating true curves
... View more
02-27-2022
08:44 PM
|
0
|
0
|
8246
|
|
IDEA
|
Curves can be a headache when working with features. Idea: Could an optional property be added to feature classes that would allow us to prevent users from creating true curves in polylines? Related: True Curves = True Evil
... View more
02-27-2022
08:42 PM
|
0
|
2
|
1253
|
|
POST
|
What are the pros & cons of database triggers vs. calculation attribute rules? Example: a trigger or calculation attribute rule that would modify the M-values of polylines after edits (in real-time). SDE.St_Geometry; Oracle 18c; versioned with moving edits to base Database Triggers: Pros: Don't need to worry about users locking data -- which seems like it would be a problem with calculation attribute rules. Lots of functionality available in the DB: There are more St_Geometry functions than there are Arcade functions. And SQL has a lot more functionality in general than Arcade. Oracle trigger functionality will never be deprecated. Whereas there is a chance ArcGIS functionality like attribute rules/arcade will be deprecated at some point. I know it's hard to imagine that happening in the foreseeable future, but deprecation does seem to be something that happens in Esri applications. So it's not beyond the realm of possibility. Fast performance. Cons: Only SQL developers (with SQL client software) can manage triggers. We consider triggers to be customization...we try to avoid customization if we can. If the triggers use St_Geometry functions, then that means we are married to St_Geometry. (We've always dreamt of moving to SDO_GEOMETRY, since it has a lot more functionality, including linear referencing functions. And Oracle Spatial is now free. So if we wanted to switch to SDO_Geometry, we would need to consider how much it would impact any existing St_Geometry-based triggers.) No access to true curves information -- since it's hidden in the CAD BLOB. Although, Arcade doesn't seem to be much better. Accessing all of a feature's vertices is difficult. Calculation Attribute Rules: Pros: Anyone who's a data owner can make attribute rules right in the application. No need to be a SQL developer. Although, basic JavaScript skills are still required. I wouldn't consider attribute rules to be customization, which is good. (There is a benefit to putting logic in the application, where it is visible and accessible to everyone.) Not specific to a certain database vendor or spatial data type. Easily prevent a field from being edited. I imagine Esri would be quick to provide support for a problem with attribute rules. And reluctant to provide support for DB triggers, especially on versioned data. Editing related FCs is relatively straightforward. "Rules can be targeted for specific subtypes in the rule definition. This is helpful when you want a rule to only apply to a subset of features in a dataset." Link We can use attribute rules to enforce domains Cons: Can't manage attribute rules if data is locked. I imagine a table would be locked if even a single user has the table in their map. I'm a data owner, not a geodatabase administrator, so I think that could be a pain. Arcade has limited functionality -- for example, geometry has limited functions and properties. There is a chance attribute rules/arcade could be deprecated at some point. We saw that happen with Python add-ins. People lost a lot of work when that happened. Performance might be relatively slow -- for batch scenarios. Note: Attribute rules require a GlobalID field. That's not really a problem, just worth noting. No direct access to true curves information. Polylines get automatically densified (similar to ST_Geometry). Arcade doesn’t handle nulls properly. We can't develop scripts in a proper IDE -- and test them right there in the IDE. Batch calculation attribute rules seem clunky. They have lots of very specific requirements: the FC must be in a feature service, the feature service must have validation capability, and the FC must be branch versioned. For my notes: Batch calculation rules are not to be confused with a scheduled job that calculates an entire field. Batch calculation rules are more about deferring slow edits until later. What do you think? What did I miss?
... View more
02-27-2022
02:37 PM
|
0
|
10
|
8339
|
|
POST
|
To anyone who's interested: Oracle Spatial is now free (as of December 5, 2019). Oracle Advanced Analytics and Oracle Spatial and Graph Licensing Change Effective December 5, 2019, Oracle Advanced Analytics (OAA) and Oracle Spatial and Graph (OSG) options are included with Oracle Database. This affects Enterprise Edition, SE2 and Database Cloud Service (DBCS) Standard Edition and Enterprise Edition. This licensing change encourages and enables more customers and prospects to use the full breadth of Oracle Database. Technologies like machine learning, graph analytics, and spatial intelligence should be part of almost every modern application, and Oracle believes that these technologies should be broadly available to all Oracle customers. While these capabilities are widely used today, the added cost of the database options have prohibited adoption for some customers. The removal of cost as a factor, combined with recent additions of developer and data scientist-friendly Oracle Machine Learning Notebooks and self-service tools like Spatial Studio with Oracle Autonomous Database, offers a more all-inclusive data platform for developer and data scientist communities. That's a big deal for organizations like ours. We currently use the St_Geometry spatial type, but St_Geometry has some significant limitations like the lack of a GetVertices function and the lack of linear referencing functionality. Moving to SDO_Geometry / Oracle Spatial would solve those issues. Hopefully that's helpful to some people. Oracle didn't seem to advertise that change -- so a lot of people didn't know about it (including us, at first). Cheers!
... View more
02-27-2022
01:51 PM
|
1
|
0
|
2779
|
|
IDEA
|
I'm a data owner in an Oracle EDGB, but not a geodatabase administrator. When I want to modify the design of my tables via ArcMap/ArcGIS Pro, I spend a lot of time coordinating with users and geodatabase administrators to get them to remove locks on the tables. It would be better if the geodatabase administrator had a way to optionally allow me to remove locks on my own data. Could Esri consider adding functionality that would allow data owners to remove locks on their data?
... View more
02-27-2022
01:11 PM
|
1
|
2
|
1184
|
|
IDEA
|
It would be helpful if ESRI could add a hasCurve geometry property to Arcade. Use case: When using Calculation Attribute Rules to update the shape column of features, it would be helpful if we could check if polylines or polygons have true curves or not. https://developers.arcgis.com/arcade/guide/types/#polyline Thanks.
... View more
02-25-2022
02:35 PM
|
7
|
2
|
1960
|
|
POST
|
Good call. When reading the docs for Arcade, I came across this line: "Geometry is immutable, meaning it is not possible to change the geometry after it is created." https://developers.arcgis.com/arcade/guide/types/#geometry So I figured Attribute Rules wouldn't be an option. But I think I must have misunderstood. Related info here: Idea: Easy way to update geometry in real time — after an edit is saved
... View more
02-24-2022
07:26 AM
|
0
|
0
|
1628
|
|
IDEA
|
@Scott_Harris Thanks! I'd been reading the docs for Arcade, and came across this line: "Geometry is immutable, meaning it is not possible to change the geometry after it is created." https://developers.arcgis.com/arcade/guide/types/#geometry So I figured Attribute Rules (which I think use Arcade) wouldn't be an option. But I must have misunderstood.
... View more
02-24-2022
07:01 AM
|
0
|
0
|
1258
|
|
POST
|
Related: Script (ArcPy) vs field calculator (Python Parser) behaviour of getPart in ArcGIS for Desktop?
... View more
02-23-2022
09:10 PM
|
0
|
0
|
1897
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 04-30-2026 11:08 AM | |
| 1 | 05-11-2026 11:23 AM | |
| 2 | 05-07-2026 04:19 AM | |
| 1 | 05-06-2026 09:03 AM | |
| 1 | 03-19-2026 09:29 AM |