Instead of creating a separate field for the length, we used Arcade to create an array that sums the Shape_Length fields and included any other necessary fields for our dashboard.
// Write an expression that returns a FeatureSet.
var fs = FeatureSetByPortalItem(
Portal('<insert portal address>'),
'27a5912865834591bbddbf97066f9c56',
39,
['SHAPE.STLength()', 'LIFECYCLESTATUS', 'FEEDERID', 'ASSETTYPE'],
false
);
// Build an array of new features
var features = [];
for (var f in fs) {
var lifestatus = f["LIFECYCLESTATUS"];
if (lifestatus == 'ACT'){
var FeederID = f["FEEDERID"];
var AssetType = f["ASSETTYPE"]
var lengthFeet = f["SHAPE.STLength()"];
var lengthMiles = Round(lengthFeet / 5280, 2)
Push(features, {
attributes: {
length_miles: lengthMiles,
length_feet: lengthFeet,
FeederID: FeederID,
AssetType: AssetType,
},
});}
}
// Define the fields (include the new one for miles)
var convertedValues = {
fields: [
{ name: 'length_miles', type: 'esriFieldTypeDouble' },
{ name: 'length_feet', type: 'esriFieldTypeDouble' },
{ name: 'FeederID', type: 'esriFieldTypeString' },
{ name: 'AssetType', type: 'esriFieldTypeSmallInteger'}
],
geometryType: '',
features: features
};
return FeatureSet(convertedValues);
