Change projection to EPSG:3857

ALTER TABLE vectormapdistrict.administrativeboundary ALTER COLUMN geom TYPE Geometry(MultiLinestring, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.airport ALTER COLUMN geom TYPE Geometry(Point, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.building ALTER COLUMN geom TYPE Geometry(MultiPolygon, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.electricitytransmissionline ALTER COLUMN geom TYPE Geometry(MultiLinestring, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.foreshore ALTER COLUMN geom TYPE Geometry(MultiPolygon, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.glasshouse ALTER COLUMN geom TYPE Geometry(MultiPolygon, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.heritagesite ALTER COLUMN geom TYPE Geometry(Point, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.land ALTER COLUMN geom TYPE Geometry(MultiPolygon, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.motorwayjunction ALTER COLUMN geom TYPE Geometry(Point, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.namedplace ALTER COLUMN geom TYPE Geometry(Point, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.ornament ALTER COLUMN geom TYPE Geometry(MultiPolygon, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.publicamenity ALTER COLUMN geom TYPE Geometry(Point, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.railwaystation ALTER COLUMN geom TYPE Geometry(Point, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.railwaytrack ALTER COLUMN geom TYPE Geometry(MultiLinestring, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.railwaytunnel ALTER COLUMN geom TYPE Geometry(MultiLinestring, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.road ALTER COLUMN geom TYPE Geometry(MultiLinestring, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.roadtunnel ALTER COLUMN geom TYPE Geometry(MultiLinestring, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.roundabout ALTER COLUMN geom TYPE Geometry(Point, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.spotheight ALTER COLUMN geom TYPE Geometry(Point, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.surfacewater_area ALTER COLUMN geom TYPE Geometry(MultiPolygon, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.surfacewater_line ALTER COLUMN geom TYPE Geometry(MultiLinestring, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.tidalboundary ALTER COLUMN geom TYPE Geometry(MultiLinestring, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.tidalwater ALTER COLUMN geom TYPE Geometry(MultiPolygon, 3857) USING ST_Transform(geom, 3857);
COMMIT;
ALTER TABLE vectormapdistrict.woodland ALTER COLUMN geom TYPE Geometry(MultiPolygon, 3857) USING ST_Transform(geom, 3857);
COMMIT;