GIS » Gisaf

alter table avsm_survey."V_AVHW_HWAY_AVP1" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWAY_AVP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWAY_AVP3" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWAY_AVP4" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWAY_AVP5" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWAY_NHP1" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWAY_AVP6" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWAY_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWB0_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWB2_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWB3_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWRW_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWB4_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWBF_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_MARK_NHP1" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_MARK_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_ARCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_BMRK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_COUT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_EXTI" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_CTNR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_CTNS" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_DBIN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_FLOR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_GRAV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_GRIL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_HRAL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_HUT-" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_MESH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_METL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_MHOL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_MISC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_OBJT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_MISL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_OTLN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_OVHD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_PLTF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_PILL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_PLTF_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_PRCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_PLTF_STEP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_RFDR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_RAMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_ROOF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_RTWL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_SHED" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_UGND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_SPRT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_STRS" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_TEMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_WALL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_CCHK_CONT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_BMRK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_CCTV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_DUCT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_ELEV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_FIBR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_GRND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_HIDD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_JBOX" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_HTCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_MHOL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_OBJT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_OTLN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_OVHD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_PANL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_PHON" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_POLE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_SBST" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_SIGN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_TEMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_BMRK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_TOWR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_UGND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_CABL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_DUCT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_ELEV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_EQPM" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_GRND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_HIDD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_HTCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_JBOX" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_LITE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_LNLT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_LNHT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_MHOL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_MISC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_OTLN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_OVHD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_POLE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_PANL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_SBCK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_SBST" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_SIGN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_SOLR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_SWCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_TEMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_TOWR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_UGND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_XFMR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_ACTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_BMRK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_BUSH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_GATE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_GRIL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_HARD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_KEET" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_MESH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_METL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_MISC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_OBJT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_STEL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_STEP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_TROW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_TEMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_WOOD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_IRRI_HOSE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_BMRK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_IRRI_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_IRRI_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_BRDG" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_CRSS" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_CURB" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_EDGE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_ELEV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_EXTI" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_FPAT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_GRAL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_GRIL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_CYCP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_HTCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_OBJT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_MARK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_MISC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_OTLN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_PAVD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_PILE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_PROF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_RAMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_UPVD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_BDST" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_BMRK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_BOTB" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_BUNB" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_CAVI" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_BUNT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_CNTR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_CTPT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_CTRS" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_DEPR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_ERTH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_DTCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_ELPT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_FILL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_GRND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_HTCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_LIMI" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_MRKP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_LSCP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_MISC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_MRKD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_MRKR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_MSTK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_OBJT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_OTLN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_PERM" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_PLND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_STEP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_TEMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_TEST" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_TRAV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_TOPB" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_TPIT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_ZONE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_ACAC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_BALM" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_BNYN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_BBOO" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_BNDY" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_BNNA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_BUSA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_BUSH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_CASW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_CBAL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_COCO" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_MISC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_OBJT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_OTLN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_DRBA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_DRNC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_DRTA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_MHOL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_MISC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_NPW-" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_OBJT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_POOL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_OTLN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_PW--" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_AVHW_HWB1_NHP2" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_BNCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_HTCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_BLDG_RWLL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_CABL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_MISC" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_COMM_SWCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_ERTH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_OBJT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ELEC_SUSP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_BWLL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_LINK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_POST" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_SIGN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_FENC_SILT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_IRRI_DRIP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_IRRI_SPKL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_IRRI_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_BARR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_BKRS" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_BUSA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_CNTR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_HOLE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_PRKG" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_RWAY" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_SBCK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_SECT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_SIGN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_SPLI" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_SUSP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_TEMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_ROAD_TPIT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_CTRB" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_LEVL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_PNDG" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_POLE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_POST" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_PRCL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_PROF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_ROCK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_SECT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_SURF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_TOPO_UGND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_BAEL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_CHKO" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_CONI" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_COVR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_EUCA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_EXOT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_GIRT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_GUAV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_HDGE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_JFRT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_LEMN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_MANG" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_MLCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_NEEM" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_ORNG" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_PALM" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_PIPA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_PLNT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_ROSW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_SERV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TAMD" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TDEF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TEAK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TMPL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TREE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TRNK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TRNS" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TROW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_TURF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_WTRE" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_VEGE_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_DAM-" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_DRAS" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_DRBA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_DRBN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_DRTA" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_DRTN" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_EQPM" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_EWAT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_FDPL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_FEED" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_FLLW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_FLOW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_GNDW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_HTCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_PONB" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_POND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_RRAP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_SURF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_UGND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WATR_XDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_CNDT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_DUCT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_EQPM" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_FEED" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_FLLW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_FLOW" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_HTCH" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_HYDT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_JBOX" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_LDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_MRKR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_NPWR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_PDTL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_PIPL" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_PIPP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_SEPP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_SEPT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_SSWR" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_STRM" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_SUMP" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_SURF" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_SWMT" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_TANK" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_TAP-" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_UGND" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_VALV" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_WELB" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_WELO" ADD COLUMN status "char" default 'E';

alter table avsm_survey."V_WMNG_XDTL" ADD COLUMN status "char" default 'E';