Function source

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

def compute_centroid_lat():
    """Centroid latitude in WGS84 (decimal degrees, 6 d.p. ≈ 11 cm)."""
    return """
        SELECT l.id, ROUND(ST_Y(ST_Transform(c.albers, 4326))::numeric, 6)::float8 AS computed
    """ + _CENTROID_LATERAL + " ORDER BY l.id"

Proposed changes

The following rows would be updated. Review carefully, then click Apply at the bottom to UPDATE every row in one transaction.

Sign in as an editor to apply this rule.