-- Run this script to fix errors in the 2015 ZBP industry data table
-- NYC Geodatabase july2017 and jan2018

BEGIN;

DELETE FROM b_zctas_2015biz_ind
WHERE ZCTA5 IN ('11694','11697');

INSERT INTO b_zctas_2015biz_ind (ZCTA5, N00, N23, N31_33, N42, N44_45, N48_49, N51, N52, N53, N54, N56, N61, N62, N71, N72, N81, N23_PCT, N31_33_PCT, N42_PCT, N44_45_PCT, N48_49_PCT, N51_PCT, N52_PCT, N53_PCT, N54_PCT, N56_PCT, N61_PCT, N62_PCT, N71_PCT, N72_PCT, N81_PCT)
VALUES ('11694', 333, 33, 2, 17, 54, 8, 3, 8, 35, 28, 12, 6, 44, 5, 38, 40, 9.91, 0.6, 5.11, 16.22, 2.4, 0.9, 2.4, 10.51, 8.41, 3.6, 1.8, 13.21, 1.5, 11.41, 12.01);

INSERT INTO b_zctas_2015biz_ind (ZCTA5, N00, N23, N42, N44_45, N52, N53, N54, N56, N61, N62, N71, N72, N81, N23_PCT, N42_PCT, N44_45_PCT, N52_PCT, N53_PCT, N54_PCT, N56_PCT, N61_PCT, N62_PCT, N71_PCT, N72_PCT, N81_PCT)
VALUES ('11697', 46, 8, 3, 6, 2, 3, 4, 5, 1, 4, 2, 5, 3, 17.39, 6.52, 13.04, 4.35, 6.52, 8.7, 10.87, 2.17, 8.7, 4.35, 10.87, 6.52);

COMMIT;