https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1191060#M7777 <P>Good idea&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/351335">@Bud</a>. Thank you.</P> Sat, 09 Jul 2022 00:21:41 GMT LorenMueller 2022-07-09T00:21:41Z https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1190620#M7772 <P>I am trying to create an Attribute Rule that on record update in a line feature class that grabs the value in Shape_Length and copies it into another field. But in the Arcade text editor when choosing the Shape_Length field, it populates the script with $feature['Shape.STLength()'], the underlying method that populates that field in the db.&nbsp; Well, when the system tries to evaluate the rule upon record update, it errors out saying that it can't find the field [Shape.STLength()]. Well yeah, that is not a field, it is an ST geom method.&nbsp; How does one get the current value in Shape_Length without calling the underlying ST geom method? The Length() method leaves me a bit nervous because of the caveat of changing the results based on the scale of the map!? Yikes. And the projection I am using is NAD 83, so I can't use the LengthGeodetic() method.&nbsp; Any ideas greatly appreciated.</P><P>(Esri 10.9.1, Pro 2.9.3)</P><P>&nbsp;</P> Thu, 07 Jul 2022 22:09:14 GMT https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1190620#M7772 LorenMueller 2022-07-07T22:09:14Z https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1190787#M7774 <P>Side note for anyone who’s interested:</P><P>Arcade automatically pre-densifies true curves. So that affects the Arcade length too (<SPAN>Length($feature))…the Arcade pre-densified length will be different than the real length.</SPAN></P><P>Whereas the Shape length (<SPAN>$feature.shape_length)&nbsp;</SPAN>doesn’t get pre-densified, at least not in SDE.ST_GEOMETRY in Oracle.</P><P><A href="https://community.esri.com/t5/arcgis-pro-ideas/hascurve-arcade-geometry-property/idc-p/1149449/highlight/true#M18873" target="_blank" rel="noopener">https://community.esri.com/t5/arcgis-pro-ideas/hascurve-arcade-geometry-property/idc-p/1149449/highlight/true#M18873</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_0-1657294981109.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/45559iD5D199BF5954BCC4/image-size/large?v=v2&amp;px=999" role="button" title="Bud_0-1657294981109.png" alt="Bud_0-1657294981109.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Bud_0-1657294981109.png</span></span></P><P>&nbsp;</P> Fri, 08 Jul 2022 15:43:10 GMT https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1190787#M7774 Bud 2022-07-08T15:43:10Z https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1190872#M7775 <P>If you don't end up getting an answer here, I wonder if it would be worthwhile posting in a different community, such as the <A href="https://community.esri.com/t5/attribute-rules/ct-p/attribute-rules" target="_self">Attribute Rules Community</A>.</P> Fri, 08 Jul 2022 15:44:54 GMT https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1190872#M7775 Bud 2022-07-08T15:44:54Z https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1191060#M7777 <P>Good idea&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/351335">@Bud</a>. Thank you.</P> Sat, 09 Jul 2022 00:21:41 GMT https://community.esri.com/t5/geodatabase-questions/can-arcade-get-the-value-of-shape-length-in-sql/m-p/1191060#M7777 LorenMueller 2022-07-09T00:21:41Z