migrate waterway dock

gistfile1.sql

BEGIN;

ALTER TABLE planet_osm_polygon DISABLE TRIGGER USER;

COMMIT;

BEGIN;

CREATE OR REPLACE FUNCTION mz_calculate_is_water(
    waterway_val text, natural_val text, landuse_val text)
RETURNS BOOLEAN AS $$
BEGIN
    RETURN (
        waterway_val IN ('riverbank', 'dock')
     OR natural_val IN ('water')
     OR landuse_val IN ('basin', 'reservoir')
    );
END;
$$ LANGUAGE plpgsql IMMUTABLE;

COMMIT;

BEGIN;

UPDATE planet_osm_polygon
  SET mz_is_water = TRUE
  WHERE mz_is_water IS NOT TRUE AND waterway='dock';

COMMIT;

BEGIN;

ALTER TABLE planet_osm_polygon ENABLE TRIGGER USER;

COMMIT;