UPDATE NH_TYPES
SET BLOCK_W= BLOCK_W * 0.58, BLOCK_H= BLOCK_H * 0.58
COMMIT;



update nh_types set BLOCK_NAME= 'SP-ANNOTATION-V1' WHERE BLOCK_NAME=' Annotation'; commit;
update nh_types set BLOCK_NAME= 'SP-ANTENNA-V1' WHERE BLOCK_NAME=' ANT'; commit;
update nh_types set BLOCK_NAME= 'SP-BLDG-V1' WHERE BLOCK_NAME=' b-bldgs'; commit;
update nh_types set BLOCK_NAME= 'SP-BOWTIE-SPLICE-V1' WHERE BLOCK_NAME=' BOWTIE-SPLICE'; commit;
update nh_types set BLOCK_NAME= 'SP-CABINET-V1' WHERE BLOCK_NAME=' CAB'; commit;
update nh_types set BLOCK_NAME= 'SP-CABINET-SMALL-V1' WHERE BLOCK_NAME=' CAB1'; commit;
update nh_types set BLOCK_NAME= 'SP-CAMERA-V1' WHERE BLOCK_NAME=' CAM'; commit;
update nh_types set BLOCK_NAME= 'SP-CAMERA-POLE-V1' WHERE BLOCK_NAME=' CAM-POLE'; commit;
update nh_types set BLOCK_NAME= 'SP-COMMUNICATION-VAULT-V1' WHERE BLOCK_NAME=' CV'; commit;
update nh_types set BLOCK_NAME= 'SP-DETECTOR-SHORT-V1' WHERE BLOCK_NAME=' DET'; commit;
update nh_types set BLOCK_NAME= 'SP- DETECTION-ZONE-V1' WHERE BLOCK_NAME=' DETECTION-ZONE'; commit;
update nh_types set BLOCK_NAME= 'SP-DETECTOR-LONG-V1' WHERE BLOCK_NAME=' DET-Long'; commit;
update nh_types set BLOCK_NAME= 'SP-GATE-V1' WHERE BLOCK_NAME=' GTE'; commit;
update nh_types set BLOCK_NAME= 'SP-HWY-ADVISORY-RADIO-V1' WHERE BLOCK_NAME=' HAR'; commit;
update nh_types set BLOCK_NAME= 'SP-HUT-V1' WHERE BLOCK_NAME=' HUT'; commit;
update nh_types set BLOCK_NAME= 'SP-JUNCTION-BOX-V1' WHERE BLOCK_NAME=' JB'; commit;

update nh_types set BLOCK_NAME= 'SP-METER-BREAKER-PED-V1' WHERE BLOCK_NAME=' MBP'; commit;
update nh_types set BLOCK_NAME= 'SP-MICROWAVE-DETECTOR-V1' WHERE BLOCK_NAME=' MD'; commit;
update nh_types set BLOCK_NAME= 'SP-MANHOLE-V1' WHERE BLOCK_NAME=' MH'; commit;
update nh_types set BLOCK_NAME= 'SP-OVERHEAD-SIGN-V1' WHERE BLOCK_NAME=' OHS'; commit;
update nh_types set BLOCK_NAME= 'SP-PULL-BOX-V1' WHERE BLOCK_NAME=' PB'; commit;

update nh_types set BLOCK_NAME= 'SP-POLE-V1' WHERE BLOCK_NAME=' POLE'; commit;
update nh_types set BLOCK_NAME= 'SP-QUANTITY-POINT-V1' WHERE BLOCK_NAME=' QM'; commit;
update nh_types set BLOCK_NAME= 'SP-RAMP-METER-OVERHEAD-SIGNAL-RIGHT-V1' WHERE BLOCK_NAME=' RMOS'; commit;
update nh_types set BLOCK_NAME= 'SP-RAMP-METER-OVERHEAD-SIGNAL-LEFT-V1' WHERE BLOCK_NAME=' RMOS-L'; commit;
update nh_types set BLOCK_NAME= 'SP-RAMP-METER-SIGNAL-V1' WHERE BLOCK_NAME=' RMS'; commit;
update nh_types set BLOCK_NAME= 'SP-ROAD-WEATHER-INFO-SYSTEM-V1' WHERE BLOCK_NAME=' RWIS'; commit;
update nh_types set BLOCK_NAME= 'SP-SIGN-V1' WHERE BLOCK_NAME=' SGN'; commit;
update nh_types set BLOCK_NAME= 'SP-DEADTERM-V1' WHERE BLOCK_NAME=' SP-DEADTERM-V1'; commit;
update nh_types set BLOCK_NAME= 'SP-SPLICE-V1' WHERE BLOCK_NAME=' SP-SPLICE-V1'; commit;
update nh_types set BLOCK_NAME= 'SP-TOUCH-AMERICA-POINT-V1' WHERE BLOCK_NAME=' TAP'; commit;
update nh_types set BLOCK_NAME= 'SP-TRENCH-TERM-V1' WHERE BLOCK_NAME=' Trench_term'; commit;
update nh_types set BLOCK_NAME= 'SP-INLET-TYPE-2-V1' WHERE BLOCK_NAME=' TYPE-2-INLET'; commit;
update nh_types set BLOCK_NAME= 'SP-VEHICLE-CLASSIFICATION-DETECTION-SENSOR-V1' WHERE BLOCK_NAME=' VCDS'; commit;
update nh_types set BLOCK_NAME= 'SP-VARIABLE-MESSAGE-SIGN-V1' WHERE BLOCK_NAME=' VMS'; commit;
update nh_types set BLOCK_NAME= 'SP-VIDEO-SENSOR-V1' WHERE BLOCK_NAME=' VS'; commit;
update nh_types set BLOCK_NAME= 'WS' WHERE BLOCK_NAME=' WS'; commit;
update nh_types set BLOCK_NAME= 'SP-YELLOW-FLASHER-V1' WHERE BLOCK_NAME=' YF'; commit;
