Landslide Science
Rule · volume_deposit
volume_deposit
→ writes volume_deposit
This is read live from inventory/derived.py via
inspect.getsource(); what you see is exactly what runs.
def compute_volume_deposit():
"""Sum of deposit-polygon volume estimates for this landslide."""
return """
SELECT l.id,
SUM(p.polygon_volume) FILTER (WHERE p.role = 'deposit')::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
"""
All rows already match this rule — nothing to apply.