-- Remove entries that do not suffice the requirements set out by the
-- constraint trigger on fairway_dimensions, but that could be left over
-- from an import run before the constraint trigger was in place
DELETE FROM waterway.fairway_dimensions fd
    USING waterway.fairway_dimensions fd_self
    WHERE ST_Equals(CAST(fd.area AS geometry), CAST(fd_self.area AS geometry))
        AND fd.validity && fd_self.validity
        AND fd.staging_done = fd_self.staging_done
        AND fd.id < fd_self.id