Collector for ArcGIS

Estimate materials for a sandbag wall using ArcGIS Arcade

Flooding can be a dynamic, destructive force nearly everywhere on the globe.  Often temporary barriers are needed to divert water and protect people and structures from further damage.  Sandbag walls offer a way to construct barriers with relatively few materials almost anywhere.

Use Collector for ArcGIS and ArcGIS Arcade to calculate the materials needed to construct a wall the size you need to provide sufficient protection.  You’ll know how many sandbags, how much sand, and (where needed) how much polyethylene sheeting.

Siting locations for a sandbag wall

Determining the location of a sandbag wall is usually best estimated in the field.  Local relief, soil composition, and other factors can influence where to construct a sandbag wall for maximum effect.  Using Collector, field workers can evaluate various sites and capture where they want to place the sandbag wall by walking the desired location and collecting a line feature using their GPS.  In addition, they can capture other information about the proposed wall, including the desired height of the wall and the type of construction.

Here’s an example of a line captured in Collector with some basic attribution to define the key characteristics of our sandbag wall.

Estimating materials

Once the location of the sandbag wall is defined along with the desired wall height we can calculate the necessary materials.  We’ll use the following information we captured in Collector:

There are two basic types of sandbag walls: a single stacked row of sandbags, or a staggered wall called a dike.  Based on the type of wall, different amounts of material are required to build the same size wall. We’ll need to have two different Arcade expressions that can be used to calculate materials based on the type of wall.

Estimating materials for a single stack wall

Let’s start with estimating the material needed for a single stack sandbag wall.

First, we need to determine the number of sandbags using the following Arcade expression.

// Replace with appropriate field for height 
var finishedHeight = $feature.FinishedHeight;

function SandbagsNeeded(wallHeight,wallLength) {

    // 3 sandbags per vertical foot of wall
    return Round((wallLength * wallHeight * 3),0);
}

// Determine number of sandbags needed based on proposed 
// length, desired finished height
return SandbagsNeeded(finishedHeight, 
    Length($feature,"feet")); 

Once we have the number of sandbags needed for our single stack wall, calculating the amount of sand needed to fill the sandbags.  For this purpose, sandbags are only filled about 1/2 full.  We can use the following Arcade expression to determine the amount of sand.

function SandNeeded(numSandbags){
    // Approximately 0.4cubic ft of sand per sandbag
    var yardSand = (numSandbags * 0.4) / 27;
    
    // Amount needed to largest cubic yard
    return (Ceil(yardSand, 0));
}

Estimating materials for a dike wall

Dike sandbag walls require significantly more material to construct.  We’ll need a different formula to estimate the number of sandbags required to construct this type of sandbag wall.

The standard dike wall is recommended to be 1.5x wider than the desired wall height.  In our case, we want a wall 3 feet high, so our width is 4.5 feet.  Using the length and width of the dike wall, we can use the following Arcade expression to calculate the number of sandbags.

// Replace with appropriate field for height 
var finishedHeight = $feature.FinishedHeight;

function SandbagsNeeded(wallHeight,wallLength) {
    
    // determine number of sandbags per foot of dike wall
    var numSandbagsFoot = ((3 * wallHeight) + 
        (9 * pow(wallHeight,2))) / 2;
    
    // calculate number using desired length
    return Round(numSandbagsFoot * 
        wallLength,0);
}

// Determine number of sandbags needed based on proposed 
// length, desired finished height
return SandbagsNeeded(finishedHeight, 
    Length($feature,"feet")); 

We can adapt the calculation used for the the single stack wall above for the amount of sand needed.

In addition, plastic sheeting is often used to cover the dike wall, protecting it from wave action or current flow.  We can estimate the amount of sheeting needed to cover the water-facing portion of the wall.


// Replace with appropriate field for height
var finishedHeight = $feature.FinishedHeight;

// assume length of dike base and top are equal
// e.g. straight line for dike wall
var embankmentCrestLength = Length($feature,"feet");
var embankmentToeLength = Length($feature,"feet");

function CalculatePolySheeting(wallLengthAtCrest,
    wallLengthAtBase,dikeHeight){

    // dike wall width is assumed to be 3x height
    var dikeWidth = dikeHeight * 3;        

    // calculate the slope of the embankment that needs 
    // to be covered (water side)
    var slopeLength = Sqrt(pow(dikeHeight,2) + 
        pow((dikeWidth / 2),2));

    // Assume dike wall top (crest) is one sandbag wide, ~1'
    var embankmentCrestWidth = 1;

    // calculate area to be covered on the side of the embankment
    var embankmentArea = (wallLengthAtCrest + 
        wallLengthAtBase) / 2 * slopeLength;

    // determine area of the crest of wall to be covered. 
    // Assume one sandbag in width (~1')
    var crestArea = wallLengthAtCrest * embankmentCrestWidth;

    //compute total area
    return Ceil(embankmentArea + crestArea,0);
}

return CalculatePolySheeting(embankmentCrestLength,
    embankmentToeLength,finishedHeight);

Putting it all together

Now that we can calculate the sandbags and sand needed for our types of sandbag walls, let’s combine these into a single Arcade expression, and use our wall type to determine which calculation to use for the sandbags.

// Replace with appropriate fields for height 
// and type of sandbag wall
var finishedHeight = $feature.FinishedHeight;
var sandbagType = $feature.SandbagType;

function SandBagsNeeded(wallHeight,wallLength,wallType) {
    
    // sandbag wall types
    // single stack = 0
    // dike == 1 
    If(wallType == 0){
        // 3 sandbags per vertical foot of wall
        return Round((wallLength * dikeHeight * 3),0);
    }
    else {
        // determine number of sandbags per foot of dike wall
        var numSandbagsFoot = ((3 * dikeHeight) + 
            (9 * pow(dikeHeight,2))) / 2;
        
        // calculate number using desired length
        return Round(numSandbagsFoot * 
            wallLength,0);
    }
}

// Determine number of sandbags needed based on proposed 
// length, desired finished height, and wall type
return SandBagsNeeded(finishedHeight, 
    Length($feature,"feet"), sandbagType); 

We’ll also modify our polyethylene sheeting expression to only calculate this material for a dike wall.

// Replace with appropriate fields for height and wall type
var wallType = $feature.SandbagType;
var finishedHeight = $feature.FinishedHeight;

// assume length of dike base and top are equal
// e.g. straight line for dike wall
var embankmentCrestLength = Length($feature,"feet");
var embankmentToeLength = Length($feature,"feet");

function CalculatePolySheeting(wallLengthAtCrest,
    wallLengthAtBase,wallHeight){

    // dike wall width is assumed to be 3x height
    var wallWidth = wallHeight * 3;        

    // calculate the slope of the embankment that needs 
    // to be covered (water side)
    var slopeLength = Sqrt(pow(wallHeight,2) + 
        pow((wallWidth / 2),2));

    // Assume dike wall top (crest) is one sandbag wide, ~1'
    var embankmentCrestWidth = 1;

    // calculate area to be covered on the side of the embankment
    var embankmentArea = (wallLengthAtCrest + 
        wallLengthAtBase) / 2 * slopeLength;

    // determine area of the crest of wall to be covered. 
    // Assume one sandbag in width (~1')
    var crestArea = wallLengthAtCrest * embankmentCrestWidth;

    //compute total area
    return Ceil(embankmentArea + crestArea,0);

}

If(wallType == 1)
    return CalculatePolySheeting(embankmentCrestLength,
        embankmentToeLength, finishedHeight);
Else
    return "-";

Now that we have our material Arcade expressions in place, we will add them to our pop-up so that we can see the materials needed for each sandbag wall.

Let’s collect a new proposed dike wall in Collector.

Collecting Sandbag Wall

The Arcade expressions are processed immediately in Collector once the new sandbag wall is submitted, so material calculations are available even when working in areas with no internet connectivity.

Want to try this yourself?  Save a copy of this map and open in Collector.

More information

Sandbagging techniques (US Army Corps of Engineers)

 

About the author

Doug is the Product Owner for Collector for ArcGIS. He works to extend the reach of GIS to include the mobile workforce to help organizations make quicker, more informed decisions.

Connect:

Next Article

What's new in Web AppBuilder (December 2019)

Read this article