Landslide Science
Rule · volume_body
volume_body
→ writes volume_body
This is read live from inventory/derived.py via
inspect.getsource(); what you see is exactly what runs.
def compute_volume_body():
"""Sum of body-polygon volume estimates for this landslide."""
return """
SELECT l.id,
SUM(p.polygon_volume) FILTER (WHERE p.role = 'body')::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.