Join to FC — Include shape length field in attribute table

Bud — Wed, 30 Apr 2025 15:58:22 GMT

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB

I have an EVENTS non-spatial table (input table) joined to a ROADS FC (join table) via Add Join.

I want to do a field calculation on an EVENTS field, utilizing the shape length from ROADS in the field calculation. However, the shape length has not been included in the joined attribute table, so I can't use it in Calculate Field.

Could the shape length (or shape area) fields be included in joins for field calculations? I understand that the shape length isn't a real field in the database table; it's generated on the fly in Pro via ArcObjects. And I understand why the SHAPE field isn't included in the join; we wouldn't want multiple SHAPE fields in the same attribute table if joining from a FC to a FC. But that doesn't mean the shape length can't be included.

I can't add a temporary SHAPE_LENGTH field in the FC because this is a corporate enterprise geodatabase that is locked, and I don't own it. And I would prefer not to copy data to a FGDB (and add a helper field) every time I need to do something like this in Pro. Creating a query layer with a length field via SQL wouldn't be suitable because joining to query layers is too slow in Pro.

For what it's worth, sometimes this happens accidentally. Sometimes the shape length does get included in joins. I don't know why it happens, maybe it's a bug, but I suppose it proves that it's possible under certain circumstances.

I thought I already had an idea for this, but I can't find it right now.

Re: Join to FC — Include shape length field in attribute table

DanPatterson — Tue, 29 Apr 2025 17:32:14 GMT

From your other idea on this theme

Join from standalone table to FC — Bring in FC's s... - Esri Community

you might want to uptick it

idea Join to FC — Include shape length field in attribute table in ArcGIS Pro Ideas

Join to FC — Include shape length field in attribute table

Re: Join to FC — Include shape length field in attribute table