Function source

This is read live from inventory/derived.py via inspect.getsource(); what you see is exactly what runs.

def compute_area_deposit():
    """Sum of deposit-polygon areas for this landslide (NULL for slow).

    Aggregates `landslide_polygons.area` for rows where role='deposit'.
    """
    return """
        SELECT l.id,
               SUM(p.area) FILTER (WHERE p.role = 'deposit')::float8 AS computed
        FROM landslides l
        LEFT JOIN landslide_polygons p ON p.landslide_id = l.id
        GROUP BY l.id
        ORDER BY l.id
    """

Proposed changes

All rows already match this rule — nothing to apply.