-- 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;