Landslide Science
Manage · rules
Landslide Science
Manage · rules
Each rule is a Python function that computes a single column from other columns on the landslide record. The function source itself is shown on the rule detail page — it's the canonical definition (no separate prose can drift). Click a rule to see proposed changes and apply them across the whole inventory.
| Rule | Writes to | Inputs | Agree | Disagree |
|---|---|---|---|---|
|
polygon_area
Polygon area in EPSG:3338 / Alaska Albers (square meters).
|
landslide_polygons.area SQL | geom | 1901 | 0 |
|
area_body
Sum of body-polygon areas.
|
landslides.area_body SQL | landslide_polygons.area, landslide_polygons.role | 1556 | 0 |
|
area_source
Sum of source-polygon areas.
|
landslides.area_source SQL | landslide_polygons.area, landslide_polygons.role | 1556 | 0 |
|
area_deposit
Sum of deposit-polygon areas.
|
landslides.area_deposit SQL | landslide_polygons.area, landslide_polygons.role | 1556 | 0 |
|
size_inclusion
Boolean: does this landslide meet the size threshold for inclusion in the main inventory.
|
landslides.size_inclusion | landslide_type, area_body, area_source, area_deposit | 1556 | 0 |
|
centroid_albers_x
Primary-polygon centroid X in EPSG:3338, whole meters.
|
landslides.centroid_albers_x SQL | landslide_polygons.geom, landslide_polygons.role, landslides.landslide_type | 1556 | 0 |
|
centroid_albers_y
Primary-polygon centroid Y in EPSG:3338, whole meters.
|
landslides.centroid_albers_y SQL | landslide_polygons.geom, landslide_polygons.role, landslides.landslide_type | 1556 | 0 |
|
centroid_lat
Primary-polygon centroid latitude (WGS84).
|
landslides.centroid_lat SQL | landslide_polygons.geom, landslide_polygons.role, landslides.landslide_type | 1555 | 1 |
|
centroid_lon
Primary-polygon centroid longitude (WGS84).
|
landslides.centroid_lon SQL | landslide_polygons.geom, landslide_polygons.role, landslides.landslide_type | 1555 | 1 |
|
country
Country (sovereign) containing the centroid, via EEZ+land polygons.
|
landslides.country SQL | landslides.centroid_lat, landslides.centroid_lon | 1556 | 0 |
|
polygon_volume
Per-polygon volume estimate via role-aware thickness × area formulas.
|
landslide_polygons.polygon_volume SQL | landslides.features, landslides.landslide_type, landslide_polygons.role, landslide_polygons.area | 1901 | 0 |
|
volume_body
Sum of body-polygon volume estimates.
|
landslides.volume_body SQL | landslide_polygons.polygon_volume, landslide_polygons.role | 1556 | 0 |
|
volume_source
Sum of source-polygon volume estimates.
|
landslides.volume_source SQL | landslide_polygons.polygon_volume, landslide_polygons.role | 1556 | 0 |
|
volume_deposit
Sum of deposit-polygon volume estimates.
|
landslides.volume_deposit SQL | landslide_polygons.polygon_volume, landslide_polygons.role | 1556 | 0 |
|
volume_estimated
Landslide-level estimate composed from the role-summed volumes.
|
landslides.volume_estimated | landslide_type, volume_body, volume_source, volume_deposit | 1556 | 0 |
|
volume_preferred
Site-specific volume if available, else the estimate.
|
landslides.volume_preferred | volume_site_specific, volume_estimated | 1556 | 0 |
|
volume_method
Canonical label for auto-estimated rows; pass-through for site-specific.
|
landslides.volume_method | volume_site_specific, volume_method | 1556 | 0 |
|
insar_creep
Tri-state OR-merge of the per-study InSAR creep flags (preserves NULL="not yet assessed").
|
landslides.insar_creep | insar_schaefer, insar_kim, insar_opera, insar_other | 1556 | 0 |
|
creep_behavior
Creep-evidence label. Planet or ITS_LIVE motion is obvious creep; the Planet patchy flag overrides plain obvious; "Cryptic" when creep_evaluated=TRUE with no positive evidence.
|
landslides.creep_behavior | planet_labs_patchy_creep, planet_labs_creep, its_live_creep, insar_creep, other_subtle_creep, geomorph_creep, creep_evaluated | 1556 | 0 |
|
landslide_class
Categorical class derived from type, size, creep evidence, and event year.
|
landslides.landslide_class | landslide_type, size_inclusion, creep_behavior, seismic_datetime, year_text, date_min | 1556 | 0 |