Function source

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

def compute_volume_source():
    """Sum of source-polygon volume estimates for this landslide."""
    return """
        SELECT l.id,
               SUM(p.polygon_volume) FILTER (WHERE p.role = 'source')::bigint 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.