²EXPORT:V10.02.01 UWQSDB RUSERS 2048 0 20 0 ²Ð6 Thu Feb 14 16:46:14 2008C:\dka\indus\wqs\Aug07\Fed08\release91\wqsdb_rel91.DMPd`$     #C###A°#ƒÐd`$     #G###A°#ƒ²²+00:00BYTEUNUSED2 INTERPRETED DISABLE:ALL METRICSU METRICSUpre-schema procedural objects and actions PROCACTION ýÿBEGIN £sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'EPASTAGE.INDUSCORP.COM', inst_scn=>'5084634391341'); COMMIT; END; METRICEU 16 METRICSUforeign function library names for user METRICEU 16 METRICSUPUBLIC type synonyms METRICEU 16 METRICSUprivate type synonyms METRICEU 16 METRICSUobject type definitions for user METRICEU 16 METRICSUpre-schema procedural objects and actions METRICEU 16 METRICSUdatabase links CREATE DATABASE LINK "RAD8.INDUSCORP.COM" CONNECT TO "RAD" IDENTIFIED BY VALUES '05BB40C459E86B7B48C1B7EAD2D8DCE184' USING 'rad8' CREATE DATABASE LINK "RADREVIEW.INDUSCORP.COM" CONNECT TO "RAD" IDENTIFIED BY VALUES '05C2EF99E733ED6499E89AF2675080CE58' USING 'radreview' METRICEU 18 METRICSUsequence numbers CREATE SEQUENCE "S_CAS" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "S_COD" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "S_CSD" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "S_DBG" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "S_SES" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "S_SOL" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "S_USR" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "TERM_ALIAS_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "TERM_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "TRACK_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 413 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "USE_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "WCC_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "GEO_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "HUC_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 5785 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "JUR_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "NSD_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 78 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "NSWT_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 167 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "ODK_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE CREATE SEQUENCE "ROLE_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "ALIAS_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "CRITERIA_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21414 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "CRITERIA_REF_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 139 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "CZ_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "DISCLAIMER_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "DISTRICT_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "DK_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 509 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "TM_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 119 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "WCOUNTY_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 447 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "META_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 770 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "GU_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 43 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "WH_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 258019 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "DU_APP_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "WB_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 115207 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "SWT_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 5641 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "SSD_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1155 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "OWNER_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 117 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "SDL_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1091 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "DOCUMENT_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 454 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "BASIN_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 24641 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "AGREE_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 135 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "SGD_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1022 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "DUP_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 30 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "CD_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 2314 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "CLASS_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 266 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "PS_TXN_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "WC_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 111143 NOCACHE NOORDER NOCYCLE CREATE SEQUENCE "WSGD_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1202283 NOCACHE NOORDER NOCYCLE METRICEU 65 METRICSUcluster definitions METRICEU 65 METRICSUXDB Schemas by user METRICEU 65 TABLE "TMP_CRITERIA_DU_RAW_AK" CREATE TABLE "TMP_CRITERIA_DU_RAW_AK" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_DW_PM_CL" VARCHAR2(100), "T_DW_PM_CL_DISC" VARCHAR2(50), "T_HHW_A_O" VARCHAR2(100), "T_HHW_A_O_DISC" VARCHAR2(50), "T_HH_OO" VARCHAR2(100), "T_HH_OO_DISC" VARCHAR2(50), "T_SW" VARCHAR2(100), "T_SW_DISC" VARCHAR2(50), "T_AL_FW_C" VARCHAR2(100), "T_AL_FW_C_DISC" VARCHAR2(50), "T_TURB" VARCHAR2(100), "T_TURB_DISC" VARCHAR2(50), "T_R" VARCHAR2(100), "T_R_DISC" VARCHAR2(50), "T_F_C" VARCHAR2(100), "T_F_C_DISC" VARCHAR2(50), "T_ENTERO" VARCHAR2(100), "T_ENTERO_DISC" VARCHAR2(50), "T_FC_HH_WO" VARCHAR2(100), "T_FC_HH_WO_DISC" VARCHAR2(50), "T_FC_HH_OO" VARCHAR2(100), "T_FC_HH_OO_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_AK" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_DW_PM_CL", "T_DW_PM_CL_DISC", "T_HHW_A_O", "T_HHW_A_O_DISC", "T_HH_OO", "T_HH_OO_DISC", "T_SW", "T_SW_DISC", "T_AL_FW_C", "T_AL_FW_C_DISC", "T_TURB", "T_TURB_DISC", "T_R", "T_R_DISC", "T_F_C", "T_F_C_DISC", "T_ENTERO", "T_ENTERO_DISC", "T_FC_HH_WO", "T_FC_HH_WO_DISC", "T_FC_HH_OO", "T_FC_HH_OO_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26) ôÈ2d2d2d2d2d2d2d2d2d2d2d2AntimonyIOCÄ-=ppb6þÿ14þÿ4300þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿArsenicIOCÄ-Sppb50þÿþÿþÿþÿþÿ50þÿ150þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAsbestosIOCÄ"MFL7þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBariumIOCÄ-^ppb2000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BerylliumIOCÄ-ppb4þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCadmiumIOCÄ-(ppb5þÿþÿþÿþÿþÿþÿþÿNC[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChromium (total)IOCÄ7dppb100þÿþÿþÿþÿþÿNC[b]NC[a][c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCopperIOCÄ- ppbþÿþÿ1300þÿþÿþÿþÿþÿNC[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb200þÿ700þÿ22000þÿþÿþÿ5.2þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ220000þÿFluorideIOCÄOppb2000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿþÿþÿþÿþÿNC[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿMercuryIOCÄ,dMppb2þÿ0.05þÿ0.051þÿþÿþÿ0.012[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppb10000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppb1000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppb50þÿ170þÿ11000þÿ10þÿ5[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿThalliumIOCÄ-Qppb2þÿ1.7þÿ6.3þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlachlorSOCÄb ppb2þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAtrazineSOCÄ\2ppb3þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.2þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ0.0028þÿ0.031þÿ CarbofuranSOCÄ9%?ppb4þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChlordaneSOCÃN2ppb2[e]þÿ[e]þÿ[e]þÿ[e]0.0043[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]0.00057[e]0.00059[e]2,4-DSOCà 0:ppb70þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDalaponSOCÃ<[ppb200þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppb0.2[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]Di(2-ethylhexyl) adipateSOCà ! ppb400þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb6þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1.8þÿ5.9þÿDinosebSOCà Y:ppb7[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]Dioxin (2,3,7,8-TCDD)SOCÄK=ppb0.00003þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ 0.000000013þÿ 0.000000014þÿDiquatSOCà 3ppb20þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EndothallSOCÃ:"ppb100þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿEndrinSOCà ppb2[e]0.76[e]0.81[e]þÿ[e]0.036[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]0.76[e]0.81[e]&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppb0.05[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e] GlyphosateSOCÄ%ppb700þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.4þÿþÿþÿþÿþÿþÿþÿ0.0038þÿþÿþÿþÿþÿþÿþÿþÿþÿ0.00021þÿ0.00021þÿHeptachlor epoxideSOCÄ.Jppb0.2þÿþÿþÿþÿþÿþÿþÿ0.0038þÿþÿþÿþÿþÿþÿþÿþÿþÿ0.0001þÿ0.00011þÿHexachlorobenzeneSOCà X*ppb1[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]0.00075[e]0.00077[e]HexachlorocyclopentadieneSOCÃKKppb50þÿ240þÿ17000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.2þÿþÿþÿþÿþÿþÿþÿ0.95[f]þÿþÿþÿþÿþÿþÿþÿþÿ0.019þÿ0.063þÿ MethoxychlorSOCÃ$ppb40þÿþÿþÿþÿþÿþÿþÿ0.03þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppb200þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.5þÿþÿþÿþÿþÿþÿþÿ0.014þÿþÿþÿþÿþÿþÿþÿþÿþÿ0.00017þÿ0.00017þÿPentachlorophenolSOCà OBppb1þÿþÿþÿþÿþÿþÿþÿNC[a]þÿþÿþÿþÿþÿþÿþÿþÿ0.28þÿ8.2þÿPicloramSOCÄ\Qppb500þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSimazineSOCà 2ppb4þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ToxapheneSOCÄ 5ppb3þÿþÿþÿþÿþÿþÿþÿ0.0002þÿþÿþÿþÿþÿþÿþÿþÿþÿ0.00073þÿ0.00075þÿ2,4,5-TP (Silvex)SOCà &ppb50[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]þÿ[e]BenzeneVOCÃ!ppb5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1.2þÿ71þÿCarbon tetrachlorideVOCÃ?$ppb5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ0.25þÿ4.4þÿ ChlorobenzeneVOCà Zppb100þÿ680þÿ17000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ21000þÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb600þÿ2700þÿ2600þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb75þÿ400þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ0.38þÿ99þÿ1,1-DichloroethyleneVOCÃ67ppb7þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ0.057þÿ3.2þÿcis-1,2-DichloroethyleneVOCÃB]ppb70þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb100þÿ700þÿ140000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloromethaneVOCÃ3]ppb5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EthylbenzeneVOCà ppb700þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿStyreneVOCà ppb100þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTetrachloroethyleneVOCà HUppb5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ0.8þÿ8.85þÿTolueneVOCà YTppb1000þÿ6800þÿ200000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppb70þÿ260þÿ940þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppb200þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ0.6þÿ42þÿTrichloroethyleneVOCÃ[ppb5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ2.7þÿ81þÿVinyl chlorideVOCÃ3ppb2þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿXylenes (total)VOCÄ"ppb10000þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ15þÿþÿþÿþÿþÿþÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ4þÿþÿþÿþÿþÿþÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ5þÿþÿþÿþÿþÿþÿþÿþÿþÿUranium RadionuclidesÄ- ¿g/LþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromateDBPsÄ77ppb10þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿ11[g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppb60þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppb80þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ5.7þÿ470þÿBromodichloromethaneDBPsÃ5Kppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ0.27þÿ22þÿDibromochloromethaneDBPsà -Rppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ0.41þÿ34þÿ BromoformDBPsÃ55ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ4.3þÿ360þÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[h]þÿþÿþÿþÿþÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[i]þÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[j]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNickel No Fed. MCLþÿppb100þÿ610þÿ4600þÿþÿþÿNC[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ20000þÿþÿþÿþÿþÿþÿþÿþÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ8þÿþÿþÿþÿþÿþÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_AK" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_AL" CREATE TABLE "TMP_CRITERIA_DU_RAW_AL" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_C_W_F" VARCHAR2(100), "T_HHC_C_W_F_DISC" VARCHAR2(50), "T_HH_CC_FO" VARCHAR2(100), "T_HH_CC_FO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_FC_AW" VARCHAR2(100), "T_FC_AW_DISC" VARCHAR2(50), "T_E" VARCHAR2(100), "T_E_DISC" VARCHAR2(50), "T_FC_IC" VARCHAR2(100), "T_FC_IC_DISC" VARCHAR2(50), "T_T" VARCHAR2(100), "T_T_DISC" VARCHAR2(50), "T_R" VARCHAR2(100), "T_R_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_AL" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_C_W_F", "T_HHC_C_W_F_DISC", "T_HH_CC_FO", "T_HH_CC_FO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_FC_AW", "T_FC_AW_DISC", "T_E", "T_E_DISC", "T_FC_IC", "T_FC_IC_DISC", "T_T", "T_T_DISC", "T_R", "T_R_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20) ôÈ2d2d2d2d2d2d2d2d2AntimonyIOCÄ-=ppb13.79[a]933.33[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿArsenicIOCÄ-Sppb0.12[b]0.30[b]NC[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAsbestosIOCÄ"MFL7.00þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChromium (total)IOCÄ7dppbþÿþÿþÿþÿNC[e]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCopperIOCÄ- ppb1300.00þÿþÿþÿNC[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb689.66[a]46666.67[a]5.2þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿNC[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿMercuryIOCÄ,dMppb0.04[a]0.04[a]0.012þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppb163.25[a]2430.56[a]5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿThalliumIOCÄ-Qppb0.87[a]1.37[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.03[b]0.11[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.004706[b][g]0.004728[b][g]0.0043[g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[g]þÿ[g]þÿ[g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb8.47[b][g]12.82[b][g]þÿ[g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDinosebSOCà Y:ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDioxin (2,3,7,8-TCDD)SOCÄK=ppb0.00[b]0.00[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿEndrinSOCà ppb0.17[a][g]0.18[a][g]0.036[g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[g]þÿ[g]þÿ[g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00[b]0.00[b]0.0038þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.00[b]0.00[b]0.0038þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00[b][g]0.00[b][g]þÿ[g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHexachlorocyclopentadieneSOCÃKKppb197.16[a]3225.81[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb3.56[a]5.38[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00[h]0.00[h]0.014[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿPentachlorophenolSOCà OBppb2.50[b]17.68[b]NC[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿPicloramSOCÄ\QppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00161[b]0.001619[b]0.0002þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[g]þÿ[g]þÿ[g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBenzeneVOCÃ!ppb11.20[b]154.73[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb2.10[b]9.57[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChlorobenzeneVOCà Zppb606.32[a]4530.74[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb1717.56[a]3776.98[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb255.73[a]562.35[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb3.78[b]213.68[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppb1614.39[a]20833.33[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb683.79[a]29535.86[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloromethaneVOCÃ3]ppb46.05[b]3456.79[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb4.92[b]84.94[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EthylbenzeneVOCà ppb2240.00[a]6222.22[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTetrachloroethyleneVOCà HUppb6.03[b]19.17[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTolueneVOCà YTppb6031.88[a]43613.71[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppb129.15[a]204.68[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb5.75[b]90.97[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb23.97[b]174.70[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿVinyl chlorideVOCÃ3ppb0.25[b]14.25[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/LþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[i]"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[i]$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/LþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[i]Uranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppb54.32[b]1020.04[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb5.34[b]100.36[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb3.94[b]74.07[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb41.94[b]787.62[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿNC[j]þÿþÿNC[k][l]þÿþÿþÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC [m][n][o]þÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ50[p]þÿþÿTotal Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNickel No Fed. MCLþÿppb410.56[a]992.91[a]NC[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/LþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[i] Strontium 90 No Fed. MCLþÿpCi/LþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[i]ÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_AL" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_AR" CREATE TABLE "TMP_CRITERIA_DU_RAW_AR" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HH" VARCHAR2(100), "T_HH_DISC" VARCHAR2(50), "T_ALC" VARCHAR2(100), "T_ALC_DISC" VARCHAR2(50), "T_B" VARCHAR2(100), "T_B_DISC" VARCHAR2(50), "T_TUR" VARCHAR2(100), "T_TUR_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_AR" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HH", "T_HH_DISC", "T_ALC", "T_ALC_DISC", "T_B", "T_B_DISC", "T_TUR", "T_TUR_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) ôÈ2d2d2d2d2AntimonyIOCÄ-=ppbþÿþÿþÿþÿþÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿþÿþÿþÿþÿAsbestosIOCÄ"MFLþÿþÿþÿþÿþÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿþÿþÿ BerylliumIOCÄ-ppb0.076þÿþÿþÿþÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿNC[a]þÿþÿþÿþÿChromium (total)IOCÄ7dppbþÿþÿNC[a][b]þÿþÿþÿþÿCopperIOCÄ- ppbþÿþÿNC[a]þÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppbþÿþÿ5.2[c]þÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿNC[a]þÿþÿþÿþÿMercuryIOCÄ,dMppbþÿþÿ0.012[c]þÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿ5[c]þÿþÿþÿþÿThalliumIOCÄ-QppbþÿþÿþÿþÿþÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppbþÿþÿþÿþÿþÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.005[d]0.0043[d]þÿþÿþÿþÿ2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[d]þÿ[d]þÿþÿþÿþÿDi(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà OppbþÿþÿþÿþÿþÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[d]þÿ[d]þÿþÿþÿþÿDioxin (2,3,7,8-TCDD)SOCÄK=ppb0.000001þÿþÿþÿþÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿþÿþÿEndrinSOCà ppbþÿ[d]0.0023[d][e]þÿþÿþÿþÿ&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[d]þÿ[d]þÿþÿþÿþÿ GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿþÿþÿ HeptachlorSOCÃA1ppbþÿþÿ0.0038þÿþÿþÿþÿþÿHeptachlor epoxideSOCÄ.JppbþÿþÿþÿþÿþÿþÿþÿþÿHexachlorobenzeneSOCà X*ppbþÿ[d]þÿ[d]þÿþÿþÿþÿHexachlorocyclopentadieneSOCÃKKppbþÿþÿþÿþÿþÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppbþÿþÿþÿþÿþÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.0004þÿ0.014þÿþÿþÿþÿþÿPentachlorophenolSOCà OBppbþÿþÿNC[a]þÿþÿþÿþÿPicloramSOCÄ\QppbþÿþÿþÿþÿþÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.0063þÿ0.0002þÿþÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[d]þÿ[d]þÿþÿþÿþÿBenzeneVOCÃ!ppbþÿþÿþÿþÿþÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppbþÿþÿþÿþÿþÿþÿþÿþÿ ChlorobenzeneVOCà Zppbþÿþÿþÿþÿþÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppbþÿþÿþÿþÿþÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppbþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppbþÿþÿþÿþÿþÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppbþÿþÿþÿþÿþÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppbþÿþÿþÿþÿþÿþÿþÿþÿDichloromethaneVOCÃ3]ppbþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppbþÿþÿþÿþÿþÿþÿþÿþÿ EthylbenzeneVOCà ppbþÿþÿþÿþÿþÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿþÿþÿTetrachloroethyleneVOCà HUppbþÿþÿþÿþÿþÿþÿþÿþÿTolueneVOCà YTppbþÿþÿþÿþÿþÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppbþÿþÿþÿþÿþÿþÿþÿþÿTrichloroethyleneVOCÃ[ppbþÿþÿþÿþÿþÿþÿþÿþÿVinyl chlorideVOCÃ3ppbþÿþÿþÿþÿþÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/LNC[f]þÿþÿþÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrNC[f]þÿþÿþÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/LNC[f]þÿþÿþÿþÿþÿþÿUranium RadionuclidesÄ- ppbNC[f]þÿþÿþÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5KppbþÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppbþÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppbþÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿNC[h]þÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿNC[i]þÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿNC[j]Total Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_AR" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_AZ" CREATE TABLE "TMP_CRITERIA_DU_RAW_AZ" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_DWS_D_W_S" VARCHAR2(100), "T_DWS_D_W_S_DISC" VARCHAR2(50), "T_FC" VARCHAR2(100), "T_FC_DISC" VARCHAR2(50), "T_AWC" VARCHAR2(100), "T_AWC_DISC" VARCHAR2(50), "T_AWW" VARCHAR2(100), "T_AWW_DISC" VARCHAR2(50), "T_FBC" VARCHAR2(100), "T_FBC_DISC" VARCHAR2(50), "T_PBC" VARCHAR2(100), "T_PBC_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_AZ" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_DWS_D_W_S", "T_DWS_D_W_S_DISC", "T_FC", "T_FC_DISC", "T_AWC", "T_AWC_DISC", "T_AWW", "T_AWW_DISC", "T_FBC", "T_FBC_DISC", "T_PBC", "T_PBC_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) ôÈ2d2d2d2d2d2d2AntimonyIOCÄ-=ppb6[a]4,300[a]30[b][c]30[b][c]560[a]560[a]ArsenicIOCÄ-Sppb50[a]1,450[a]190[b][c]190[b][c]50[a]420[a]AsbestosIOCÄ"MFL7þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBariumIOCÄ-^ppb2,000[a]þÿþÿþÿþÿþÿþÿ98,000þÿ98,000þÿ BerylliumIOCÄ-ppb4[a]1,130[a]5.3[b][c]5.3[b][c]2,800[a][d]2,800[a]CadmiumIOCÄ-(ppb5[a]84[a]NC[e][c]NC[e][c]700[a]700[a]Chromium (total)IOCÄ7dppb100[a][f]NC[f]NC[f]NC[f]100[d][f]100[f]CopperIOCÄ- ppb1,300[a][c]þÿþÿNC[e][c]NC[e][c]1,300 [a][d][e][c]1,300 [a][e][c]Cyanide (as free cyanide)IOCÃHppb200[a]215000[a]5.2[b][a]9.7[b][a]28,000[a]28,000[a]FluorideIOCÄOppb4,000þÿþÿþÿþÿþÿþÿþÿ84,000þÿ84,000þÿLeadIOCÄ,dppb15[a]þÿþÿNC[e][c]NC[e][c]15[a]15[a]MercuryIOCÄ,dMppb2[a]0.6[a]0.01[b][c]0.01[b][c]420[a]420[a]Nitrate (measured as Nitrogen)IOCÄPL;ppb10,000þÿþÿþÿþÿþÿþÿþÿ 2,240,000þÿ 2,240,000þÿNitrite (measured as Nitrogen)IOCÄPM3ppb1,000þÿþÿþÿþÿþÿþÿþÿ140,000þÿ140,000þÿSeleniumIOCÄO]ppb50[a]9,000[a]2[b][a]2[b][a]7,000[a]7,000[a]ThalliumIOCÄ-Qppb2[a]7.2[a]150[b][c]150[b][c]112[a]112þÿAlachlorSOCÄb ppb2þÿþÿþÿ170[b]170[b]14,000þÿ14,000þÿAtrazineSOCÄ\2ppb3þÿþÿþÿþÿþÿþÿþÿ49,000þÿ49,000þÿBenzo(a)pyrene (PAHs)SOCÃppb0.2þÿ0.05þÿþÿþÿþÿþÿ0.2þÿ0.2þÿ CarbofuranSOCÄ9%?ppb40þÿþÿþÿ50[b]50[b]7,000þÿ7,000þÿ ChlordaneSOCÃN2ppb2[h]0.002[h]0.004[b][h]0.21[b][h]4[h]700[h]2,4-DSOCà 0:ppb70þÿþÿþÿþÿþÿþÿþÿ14,000þÿ14,000þÿDalaponSOCÃ<[ppb200þÿ161,500þÿþÿþÿþÿþÿ42,000þÿ42,000þÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppb0.2[h]þÿ[h]þÿ[h]þÿ[h]2,800[h]2,800[h]Di(2-ethylhexyl) adipateSOCà ! ppb400þÿþÿþÿþÿþÿþÿþÿ1,200þÿ840,000þÿDi(2-ethylhexyl) phthalateSOCà Oppb6þÿ7.4þÿ360[b]360[b]100þÿ28,000þÿDinosebSOCà Y:ppb7[h]þÿ[h]þÿ[h]þÿ[h]1,400[h]1,400[h]Dioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.0000003[i] 0.000000004[i]0.005[b]0.005[b]0.00009[i]1.4þÿDiquatSOCà 3ppb20þÿþÿþÿþÿþÿþÿþÿ3,080þÿ3,080þÿ EndothallSOCÃ:"ppb100þÿþÿþÿþÿþÿþÿþÿ28,000þÿ28,000þÿEndrinSOCà ppb2[h]0.8[h]0.002[b][h]0.08[b][h]420[h]420[h]&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppb0.05[d][h]þÿ[h]þÿ[h]þÿ[h]0.05[h]0.05[h] GlyphosateSOCÄ%ppb700þÿ 1,077,000þÿþÿþÿþÿþÿ140,000þÿ140,000þÿ HeptachlorSOCÃA1ppb0.4þÿ0.0002þÿ0.004[b]0.004[b]0.4þÿ700þÿHeptachlor epoxideSOCÄ.Jppb0.2þÿ0.0001þÿ0.004[b]0.004[b]0.2þÿ18þÿHexachlorobenzeneSOCà X*ppb1[h]0.001[h]3.7[b][h]þÿ[h]1[h]1,120[h]HexachlorocyclopentadieneSOCÃKKppb50þÿ580þÿ0.3[b]0.3[b]9,800þÿ9,800þÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.2þÿ25þÿ0.08[b]0.28[b]420þÿ420þÿ MethoxychlorSOCÃ$ppb40þÿþÿþÿþÿþÿþÿþÿ7,000þÿ7,000þÿOxamyl (Vydate)SOCÄ5ppb200þÿþÿþÿþÿþÿþÿþÿ35,000þÿ35,000þÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.5þÿ0.007þÿ0.01[b]0.02[b]28þÿ28þÿPentachlorophenolSOCà OBppb1þÿ1,000þÿNC[e]NC[e]12þÿ42,000þÿPicloramSOCÄ\Qppb500þÿ24,300þÿþÿþÿþÿþÿ98,000þÿ98,000þÿSimazineSOCà 2ppb4þÿþÿþÿþÿþÿþÿþÿ7,000þÿ7,000þÿ ToxapheneSOCÄ 5ppb3þÿ0.001þÿ0.0002[b]0.02[b]1.3þÿ1,400þÿ2,4,5-TP (Silvex)SOCà &ppb50[h]þÿ[h]þÿ[h]þÿ[h]11,200[h]11,200[h]BenzeneVOCÃ!ppb5þÿ140þÿ180[b]180[b]93þÿ93þÿCarbon tetrachlorideVOCÃ?$ppb5þÿ4þÿ1,100[b]1,100[b]11þÿ980þÿ ChlorobenzeneVOCà Zppb100þÿ20,900þÿ260[b]260[b]28,000þÿ28,000þÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb600þÿ2,800þÿ300[b]470[b]126,000þÿ126,000þÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb75þÿ77,500þÿ210[b]780[b]560,000þÿ560,000þÿ1,2-DichloroethaneVOCà G?ppb5þÿ100þÿ41,000[b]41,000[b]15þÿ280,000þÿ1,1-DichloroethyleneVOCÃ67ppb7þÿ320þÿ950[b]950[b]230þÿ126,000þÿcis-1,2-DichloroethyleneVOCÃB]ppb70þÿþÿþÿþÿþÿþÿþÿ70þÿ70þÿtrans-1,2-DichloroethyleneVOCÃCppb100þÿ136,000þÿ3,900[b]3,900[b]28,000þÿ28,000þÿDichloromethaneVOCÃ3]ppb5þÿ1,600þÿ5,500[b]5,500[b]190þÿ84,000þÿ1,2-DichloropropaneVOCÃYLppb5þÿ236,000þÿ9,200[b]9,200[b]126,000þÿ126,000þÿ EthylbenzeneVOCà ppb700þÿ28,700þÿ1,400[b]1,400[b]140,000þÿ140,000þÿStyreneVOCà ppb100þÿþÿþÿ370[b]370[b]280,000þÿ280,000þÿTetrachloroethyleneVOCà HUppb5þÿ3,500þÿ280[b]680[b]14,000þÿ14,000þÿTolueneVOCà YTppb1,000þÿ201,000þÿ180[b]180[b]280,000þÿ280,000þÿ1,2,4-TrichlorobenzeneVOCà ppb70þÿ950þÿ130[b]300[b]14,000þÿ14,000þÿ1,1,1-TrichloroethaneVOCÃ9ppb200þÿþÿþÿ1,600[b]1,600[b]200þÿ200þÿ1,1,2-TrichloroethaneVOCÃ[ppb5þÿ42þÿ12,000[b]12,000[b]25þÿ5,600þÿTrichloroethyleneVOCÃ[ppb5þÿ203,200þÿ1,300[b]1,300[b]280,000þÿ280,000þÿVinyl chlorideVOCÃ3ppb2þÿ13þÿþÿþÿþÿþÿ2þÿ4,200þÿXylenes (total)VOCÄ"ppb10,000þÿþÿþÿþÿþÿþÿþÿ 2,800,000þÿ 2,800,000þÿAlpha particles RadionuclidesþÿpCi/L15þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yr4þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/L5þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿUranium RadionuclidesÄ- ppb35[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppb700[j]þÿþÿ5[j]5[j]140,000þÿ140,000þÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppb100þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿ470þÿ900[b]900[b]230þÿ14,000þÿBromodichloromethaneDBPsÃ5Kppbþÿþÿ46þÿþÿþÿþÿþÿþÿþÿ2,800þÿDibromochloromethaneDBPsà -Rppbþÿþÿ34þÿþÿþÿþÿþÿþÿþÿ2,800þÿ BromoformDBPsÃ55ppbþÿþÿ360þÿ10000[b]10000[b]180þÿ2,800þÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[k]NC[l] EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿ[m]þÿ[m]þÿ[m]þÿ[m]þÿ[m]þÿ[m]Total Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_AZ" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA1" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA1" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_CWO" VARCHAR2(100), "T_HHC_CWO_DISC" VARCHAR2(50), "T_HHC_COO" VARCHAR2(100), "T_HHC_COO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MCL_DW" VARCHAR2(100), "T_MCL_DW_DISC" VARCHAR2(50), "T_W_C_R" VARCHAR2(100), "T_W_C_R_DISC" VARCHAR2(50), "T_SHELL" VARCHAR2(100), "T_SHELL_DISC" VARCHAR2(50), "T_T" VARCHAR2(100), "T_T_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA1" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_CWO", "T_HHC_CWO_DISC", "T_HHC_COO", "T_HHC_COO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MCL_DW", "T_MCL_DW_DISC", "T_W_C_R", "T_W_C_R_DISC", "T_SHELL", "T_SHELL_DISC", "T_T", "T_T_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18) ôÈ2d2d2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿ6[c]þÿþÿþÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][d][e]50[c]þÿþÿþÿþÿþÿþÿAsbestosIOCÄ"MFLþÿþÿ7[a]þÿþÿ7[c]þÿþÿþÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿ1000[c]þÿþÿþÿþÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][f]5[c]þÿþÿþÿþÿþÿþÿChromium (total)IOCÄ7dppbþÿþÿþÿþÿNCþÿ50[c]þÿþÿþÿþÿþÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿþÿ [a][d][e][f]1000[g]þÿþÿþÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]150[c]þÿþÿþÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿNC[h]þÿþÿþÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿþÿ [a][d][e][f]50[c]þÿþÿþÿþÿþÿþÿMercuryIOCÄ,dMppb0.05[a]0.051[a]þÿþÿ2[c]þÿþÿþÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000[c][i]þÿþÿþÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][j]10[c]þÿþÿþÿþÿþÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿ2[c]þÿþÿþÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿ2[c]þÿþÿþÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿ1[c]þÿþÿþÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿ0.2[c]þÿþÿþÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.00057[a][k]0.00059[a][k]0.0043[a][k]0.1[c][k]þÿþÿþÿþÿþÿþÿ2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿþÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[k]þÿ[k]þÿ[k]0.2[c][k]þÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿ400[c]þÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿ4[c]þÿþÿþÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[k]þÿ[k]þÿ[k]7[c][k]þÿþÿþÿþÿþÿþÿDioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿ0.00003[c]þÿþÿþÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿþÿþÿEndrinSOCà ppb0.76[a][k]0.81[a][k]0.036[a][k]0.2[k][l]þÿþÿþÿþÿþÿþÿ&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[k]þÿ[k]þÿ[k]0.02[k][l]þÿþÿþÿþÿþÿþÿ GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿ700[c]þÿþÿþÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]0.01[c]þÿþÿþÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]0.01[c]þÿþÿþÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][k]0.00077[a][k]þÿ[k]1[c][k]þÿþÿþÿþÿþÿþÿHexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿ50[c]þÿþÿþÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿ0.2[c]þÿþÿþÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿ30[c]þÿþÿþÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]0.5[c]þÿþÿþÿþÿþÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][m]1[c]þÿþÿþÿþÿþÿþÿPicloramSOCÄ\Qppbþÿþÿþÿþÿþÿþÿ500[c]þÿþÿþÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]3[c]þÿþÿþÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[k]þÿ[k]þÿ[k]10[k][l]þÿþÿþÿþÿþÿþÿBenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿ1[c]þÿþÿþÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿ0.5[c]þÿþÿþÿþÿþÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿ30[l]þÿþÿþÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿ600[c]þÿþÿþÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿ0.5[c]þÿþÿþÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿ6[c]þÿþÿþÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿ6[c]þÿþÿþÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿ10[c]þÿþÿþÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿ300[c]þÿþÿþÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿþÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿ150[c]þÿþÿþÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿ0.5[c]þÿþÿþÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿ1750[c]þÿþÿþÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[c]þÿþÿþÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿþÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[n]NC[o]þÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿ5[g]NCþÿþÿþÿNC[p]Total Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿ13[c]þÿþÿþÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[c]þÿþÿþÿþÿþÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[c]þÿþÿþÿþÿþÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿ1[c]þÿþÿþÿþÿþÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ150[c]þÿþÿþÿþÿþÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1200[c]þÿþÿþÿþÿþÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿþÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿþÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1[g]þÿþÿþÿþÿþÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]100[c]þÿþÿþÿþÿþÿþÿAluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ200[g]þÿþÿþÿþÿþÿþÿColor No Fed. MCLþÿ Color Unitsþÿþÿþÿþÿþÿþÿ15[g]þÿþÿþÿþÿþÿþÿ Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500[g]þÿþÿþÿþÿþÿþÿIron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ300[g]þÿþÿþÿþÿþÿþÿ Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ50[g]þÿþÿþÿþÿþÿþÿOdor No Fed. MCLþÿ Odor Unitsþÿþÿþÿþÿþÿþÿ3[g]þÿþÿþÿþÿþÿþÿSilver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ100[g]þÿþÿþÿþÿþÿþÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1000000[g]þÿþÿþÿþÿþÿþÿChloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[g]þÿþÿþÿþÿþÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[g]þÿþÿþÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA1" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA2" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA2" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_CWO" VARCHAR2(100), "T_HHC_CWO_DISC" VARCHAR2(50), "T_HHC_COO" VARCHAR2(100), "T_HHC_COO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MCL_DW" VARCHAR2(100), "T_MCL_DW_DISC" VARCHAR2(50), "T_W_C_R" VARCHAR2(100), "T_W_C_R_DISC" VARCHAR2(50), "T_CFAW" VARCHAR2(100), "T_CFAW_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA2" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_CWO", "T_HHC_CWO_DISC", "T_HHC_COO", "T_HHC_COO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MCL_DW", "T_MCL_DW_DISC", "T_W_C_R", "T_W_C_R_DISC", "T_CFAW", "T_CFAW_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) ôÈ2d2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿ6[c]þÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][d][e]50[c]þÿþÿ190þÿAsbestosIOCÄ"MFLþÿþÿ7[a]þÿþÿ7[c]þÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿ1000[c]þÿþÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][f]5[c]þÿþÿNC[f]Chromium (total)IOCÄ7dppbþÿþÿþÿþÿNCþÿ50[c]þÿþÿþÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿþÿ [a][d][e][f]1000[g]þÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]150[c]þÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿNC[h]þÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿþÿ [a][d][e][f]50[c]þÿþÿþÿþÿMercuryIOCÄ,dMppb0.05[a]0.051[a]þÿþÿ2[c]þÿþÿ0.025þÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000[c][i]þÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][j]10[c]þÿþÿþÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿ2[c]þÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿ2[c]þÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿ1[c]þÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿ0.2[c]þÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.00057[a][k]0.00059[a][k]0.0043[a][k]0.1[c][k]þÿ[k]þÿ[k]2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[k]þÿ[k]þÿ[k]0.2[c][k]þÿ[k]þÿ[k]Di(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿ400[c]þÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿ4[c]þÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[k]þÿ[k]þÿ[k]7[c][k]þÿ[k]þÿ[k]Dioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿ0.00003[c]þÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿEndrinSOCà ppb0.76[a][k]0.81[a][k]0.036[a][k]2[c][k]þÿ[k]þÿ[k]&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[k]þÿ[k]þÿ[k]0.05[c][k]þÿ[k]þÿ[k] GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿ700[c]þÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]0.01[c]þÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]0.01[c]þÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][k]0.00077[a][k]þÿ[k]1[c][k]þÿ[k]þÿ[k]HexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿ50[c]þÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿ0.2[c]þÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿ30[c]þÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]0.5[c]þÿþÿþÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][l]1[c]þÿþÿþÿþÿPicloramSOCÄ\Qppbþÿþÿþÿþÿþÿþÿ500[c]þÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]3[c]þÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[k]þÿ[k]þÿ[k]50[c][k]þÿ[k]þÿ[k]BenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿ1[c]þÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿ0.5[c]þÿþÿþÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿ70[c]þÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿ600[c]þÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿ5[c]þÿþÿþÿþÿ1 2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿ0.5[c]þÿþÿþÿþÿ1 1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿ6[c]þÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿ6[c]þÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿ10[c]þÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿ5[c]þÿþÿþÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿ300[c]þÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿ5[c]þÿþÿþÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿ150[c]þÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿ5[c]þÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿ5[c]þÿþÿþÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿ0.5[c]þÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿ1750[c]þÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[c]þÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿNC[m]NC[n]þÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿNC[m]NC[o]þÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿ5[g]þÿþÿþÿþÿTotal Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿ13[c]þÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[c]þÿþÿþÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[c]þÿþÿþÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿ1[c]þÿþÿþÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ150[c]þÿþÿþÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1200[c]þÿþÿþÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1[g]þÿþÿþÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]100þÿþÿþÿNC[f]Aluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ200[g]þÿþÿþÿþÿColor No Fed. MCLþÿ Color Unitsþÿþÿþÿþÿþÿþÿ15[g]þÿþÿþÿþÿ Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500[g]þÿþÿþÿþÿIron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ300[g]þÿþÿþÿþÿ Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ50[g]þÿþÿþÿþÿOdor No Fed. MCLþÿ Odor Unitsþÿþÿþÿþÿþÿþÿ3[g]þÿþÿþÿþÿSilver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ50[g]þÿþÿ1.2þÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[g]þÿþÿþÿþÿChloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ250000[g]þÿþÿþÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ250000[g]þÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿ0.5[c]þÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA2" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA3" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA3" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_CWO" VARCHAR2(100), "T_HHC_CWO_DISC" VARCHAR2(50), "T_HHC_COO" VARCHAR2(100), "T_HHC_COO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MCL_DW" VARCHAR2(100), "T_MCL_DW_DISC" VARCHAR2(50), "T_T" VARCHAR2(100), "T_T_DISC" VARCHAR2(50), "T_FS" VARCHAR2(100), "T_FS_DISC" VARCHAR2(50), "T_SH" VARCHAR2(100), "T_SH_DISC" VARCHAR2(50), "T_SR" VARCHAR2(100), "T_SR_DISC" VARCHAR2(50), "T_PR" VARCHAR2(100), "T_PR_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA3" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_CWO", "T_HHC_CWO_DISC", "T_HHC_COO", "T_HHC_COO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MCL_DW", "T_MCL_DW_DISC", "T_T", "T_T_DISC", "T_FS", "T_FS_DISC", "T_SH", "T_SH_DISC", "T_SR", "T_SR_DISC", "T_PR", "T_PR_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) ôÈ2d2d2d2d2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿ6[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][d][e]50[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAsbestosIOCÄ"MFLþÿþÿ7[a]þÿþÿ7[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿ1000[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][f]5[c]þÿþÿNC[f]þÿþÿþÿþÿþÿþÿChromium (total)IOCÄ7dppbþÿþÿþÿþÿNC[f][g]50[c]þÿþÿþÿþÿ10þÿþÿþÿþÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿNC [a][d][e][f]1000[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]150[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿNC[i]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿNC [a][d][e][f]50[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿMercuryIOCÄ,dMppb0.05[a]0.051[a]NC[f][g]2[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000[c][j]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿ1000[c][j]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][k]10[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿ2[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿ2[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿ1[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿ0.2[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.00057[a][l]0.00059[a][l]0.0043[a][l]0.1[c][l]þÿþÿþÿ[l]þÿ[l]þÿþÿþÿþÿ2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[l]þÿ[l]þÿ[l]0.2[c][l]þÿþÿþÿ[l]þÿ[l]þÿþÿþÿþÿDi(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿ400[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿ4[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[l]þÿ[l]þÿ[l]7[c][l]þÿþÿþÿ[l]þÿ[l]þÿþÿþÿþÿDioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿ0.00003[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿEndrinSOCà ppb0.76[a][l]0.81[a][l]0.036[a][l]0.2[l][m]þÿþÿþÿ[l]þÿ[l]þÿþÿþÿþÿ&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[l]þÿ[l]þÿ[l]0.02[l][m]þÿþÿþÿ[l]þÿ[l]þÿþÿþÿþÿ GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿ700[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]0.01[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]0.01[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][l]0.00077[a][l]þÿ[l]1[c][l]þÿþÿþÿ[l]þÿ[l]þÿþÿþÿþÿHexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿ50[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿ0.2[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿ30[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]0.5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][n]1[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿPicloramSOCÄ\Qppbþÿþÿþÿþÿþÿþÿ500[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]3[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[l]þÿ[l]þÿ[l]10[l][m]þÿþÿþÿ[l]þÿ[l]þÿþÿþÿþÿBenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿ1[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿ0.5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿ70[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿ600[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿ0.5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿ6[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿ6[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿ10[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿ300[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿ150[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿ5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿ0.5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿ1750[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[p]NC[q]E. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿNC[r]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿ5[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿ1[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ150[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1200[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]100[c]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ200[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿColor No Fed. MCLþÿ Color UnitsþÿþÿþÿþÿþÿþÿþÿþÿNC[g]þÿþÿþÿþÿþÿþÿþÿþÿ Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿIron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ300[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ50[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿOdor No Fed. MCLþÿ Odor Unitsþÿþÿþÿþÿþÿþÿ3[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSilver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ100[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1000000[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA3" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA4" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA4" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_C_W_O" VARCHAR2(100), "T_HHC_C_W_O_DISC" VARCHAR2(50), "T_HHC_C_OO" VARCHAR2(100), "T_HHC_C_OO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MCL" VARCHAR2(100), "T_MCL_DISC" VARCHAR2(50), "T_WCR" VARCHAR2(100), "T_WCR_DISC" VARCHAR2(50), "T_T" VARCHAR2(100), "T_T_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA4" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_C_W_O", "T_HHC_C_W_O_DISC", "T_HHC_C_OO", "T_HHC_C_OO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MCL", "T_MCL_DISC", "T_WCR", "T_WCR_DISC", "T_T", "T_T_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) ôÈ2d2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿ6[c]þÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][d][e]50[c]þÿþÿþÿþÿAsbestosIOCÄ"MFLþÿþÿ7[a]þÿþÿ7[c]þÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿ1000[c]þÿþÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][f]5[c]þÿþÿþÿþÿChromium (total)IOCÄ7dppbþÿþÿþÿþÿNC[f][g]50[c]þÿþÿþÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿNC [a][d][e][f]þÿþÿþÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]150[c]þÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿNC[h]þÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿNC [a][d][e][f]50[c]þÿþÿþÿþÿMercuryIOCÄ,dMppb0.05[a]0.051[a]NC[f][g]2[c]þÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000 [c][i][j]þÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿ1000 [c][i][j]þÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][k]10[c]þÿþÿþÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿ2[c]þÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿ2[c]þÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿ1[c]þÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿ0.2[c]þÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.00057[a][l]0.00059[a][l]0.0043[a][l]0.1[c][l]þÿ[l]þÿþÿ2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[l]þÿ[l]þÿ[l]0.2[c][l]þÿ[l]þÿþÿDi(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿ400[c]þÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿ4[c]þÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[l]þÿ[l]þÿ[l]7[c][l]þÿ[l]þÿþÿDioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿ0.00003[c]þÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿEndrinSOCà ppb0.76[a][l]0.81[a][l]0.036[a][l]2[c][l]þÿ[l]þÿþÿ&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[l]þÿ[l]þÿ[l]0.05[c][l]þÿ[l]þÿþÿ GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿ700[c]þÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]0.01[c]þÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]0.01[c]þÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][l]0.00077[a][l]þÿ[l]1[c][l]þÿ[l]þÿþÿHexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿ50[c]þÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿ0.2[c]þÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿ30[c]þÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]0.5[c]þÿþÿþÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][m]1[c]þÿþÿþÿþÿPicloramSOCÄ\Qppbþÿþÿþÿþÿþÿþÿ500[c]þÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]3[c]þÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[l]þÿ[l]þÿ[l]50[c][l]þÿ[l]þÿþÿBenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿ1[c]þÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿ0.5[c]þÿþÿþÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿ70[c]þÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿ600[c]þÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿ5[c]þÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿ0.5[c]þÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿ6[c]þÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿ6[c]þÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿ10[c]þÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿ5[c]þÿþÿþÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿ300[c]þÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿ5[c]þÿþÿþÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿ150[c]þÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿ5[c]þÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿ5[c]þÿþÿþÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿ0.5[c]þÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿ1750[c]þÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[c]þÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿNC[j]þÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿNC[n]þÿþÿþÿþÿþÿþÿNC[o]þÿþÿFecal ColiformMicroorganismsþÿþÿNC[n]þÿþÿþÿþÿþÿþÿNC[o]þÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[p]Total Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿ13[c]þÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[c]þÿþÿþÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[c]þÿþÿþÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿ1[c]þÿþÿþÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ150[c]þÿþÿþÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1200[c]þÿþÿþÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿþÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]100[c]þÿþÿþÿþÿAluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1000[c]þÿþÿþÿþÿColor No Fed. MCLþÿ Color Unitsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500[q]þÿþÿþÿþÿIron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿOdor No Fed. MCLþÿ Odor UnitsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSilver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿNC[j][q]þÿþÿþÿþÿChloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿNC[j][q]þÿþÿþÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿNC[j][q]þÿþÿþÿþÿDichloromethane VOC þÿppb4.7 [a]1600 [a]þÿþÿ5 [c]þÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA4" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA5" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA5" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_C_W_O" VARCHAR2(100), "T_HHC_C_W_O_DISC" VARCHAR2(50), "T_HHC_C_OO" VARCHAR2(100), "T_HHC_C_OO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MCL_F_DW" VARCHAR2(100), "T_MCL_F_DW_DISC" VARCHAR2(50), "T_W_C_R_B" VARCHAR2(100), "T_W_C_R_B_DISC" VARCHAR2(50), "T_T" VARCHAR2(100), "T_T_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA5" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_C_W_O", "T_HHC_C_W_O_DISC", "T_HHC_C_OO", "T_HHC_C_OO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MCL_F_DW", "T_MCL_F_DW_DISC", "T_W_C_R_B", "T_W_C_R_B_DISC", "T_T", "T_T_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) ôÈ2d2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿ6[c]þÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][d][e]50[c]þÿþÿþÿþÿAsbestosIOCÄ"MFLþÿþÿ7[a]þÿþÿ7[c]þÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿ1000[c]þÿþÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][f]5[c]þÿþÿþÿþÿChromium (total)IOCÄ7dppbþÿþÿþÿþÿNC[f][g]50[c]þÿþÿþÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿNC [a][d][e][f]1000[h]þÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]150[c]þÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿNC[i]þÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿNC [a][d][e][f]15[j]þÿþÿþÿþÿMercuryIOCÄ,dMppb0.05[a]0.051[a]NC[f][g]2[c]þÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000[c][k]þÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][l]10[c]þÿþÿþÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿ2[c]þÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿ2[c]þÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿ1[c]þÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿ0.2[c]þÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.00057[a][m]0.00059[a][m]0.0043[a][m]0.1[c][m]þÿ[m]þÿþÿ2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[m]þÿ[m]þÿ[m]0.2[c][m]þÿ[m]þÿþÿDi(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿ400[c]þÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿ4[c]þÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[m]þÿ[m]þÿ[m]7[c][m]þÿ[m]þÿþÿDioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿ0.00003[c]þÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿEndrinSOCà ppb0.76[a][m]0.81[a][m]0.036[a][m]2[c][m]þÿ[m]þÿþÿ&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[m]þÿ[m]þÿ[m]0.05[c][m]þÿ[m]þÿþÿ GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿ700[c]þÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]0.01[c]þÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]0.01[c]þÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][m]0.00077[a][m]þÿ[m]1[c][m]þÿ[m]þÿþÿHexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿ50[c]þÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿ0.2[c]þÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿ30[c]þÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]0.5[c]þÿþÿþÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][n]1[c]þÿþÿþÿþÿPicloramSOCÄ\Qppbþÿþÿþÿþÿþÿþÿ500[c]þÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]3[c]þÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[m]þÿ[m]þÿ[m]50[c][m]þÿ[m]þÿþÿBenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿ1[c]þÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿ0.5[c]þÿþÿþÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿ70[c]þÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿ600[c]þÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿ5[c]þÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿ0.5[c]þÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿ6[c]þÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿ6[c]þÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿ10[c]þÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿ5[c]þÿþÿþÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿ300[c]þÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿ5[c]þÿþÿþÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿ150[c]þÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿ5[c]þÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿ5[c]þÿþÿþÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿ0.5[c]þÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿ1750[c]þÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[c]þÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[o]þÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿ5[h]þÿþÿNC[p]Total Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿ13[c]þÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[c]þÿþÿþÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[c]þÿþÿþÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿ1[c]þÿþÿþÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ150[c]þÿþÿþÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1200[c]þÿþÿþÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1[h]þÿþÿþÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]100[c]þÿþÿþÿþÿAluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ200[h]þÿþÿþÿþÿColor No Fed. MCLþÿ Color Unitsþÿþÿþÿþÿþÿþÿ15[h]þÿþÿþÿþÿ Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500[h]þÿþÿþÿþÿIron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ300[h]þÿþÿþÿþÿ Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ50[h]þÿþÿþÿþÿOdor No Fed. MCLþÿ Odor Unitsþÿþÿþÿþÿþÿþÿ3[h]þÿþÿþÿþÿSilver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ100[h]þÿþÿþÿþÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1000000[h][q]þÿþÿþÿþÿChloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[h]þÿþÿþÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[h]þÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA5" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA6" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA6" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_C_W_O" VARCHAR2(100), "T_HHC_C_W_O_DISC" VARCHAR2(50), "T_HHC_C_OO" VARCHAR2(100), "T_HHC_C_OO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MCL" VARCHAR2(100), "T_MCL_DISC" VARCHAR2(50), "T_GC" VARCHAR2(100), "T_GC_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA6" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_C_W_O", "T_HHC_C_W_O_DISC", "T_HHC_C_OO", "T_HHC_C_OO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MCL", "T_MCL_DISC", "T_GC", "T_GC_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14) ôÈ2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿ6[c]þÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][d][e]50[c]NC[f][g]AsbestosIOCÄ"MFLþÿþÿ7[a]þÿþÿ7[c]þÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿ1000[c]þÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][g]5[c]þÿþÿChromium (total)IOCÄ7dppbþÿþÿþÿþÿþÿþÿ50[c]þÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿNC [a][d][e][g]1000[h]þÿþÿCyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]150[c]þÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿNC[i]þÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿNC [a][d][e][g]15[j]þÿþÿMercuryIOCÄ,dMppb0.05[a]0.051[a]þÿþÿ2[c]þÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000[c][k]þÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][l]10[c]þÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿ2[c]þÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿ2[c]þÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿ1[c]þÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿ0.2[c]þÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿ ChlordaneSOCÃN2ppb0.00057[a][m]0.00059[a][m]0.0043[a][m]0.1[c][m]þÿ[m]2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[m]þÿ[m]þÿ[m]0.2[c][m]þÿ[m]Di(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿ400[c]þÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿ4[c]þÿþÿDinosebSOCà Y:ppbþÿ[m]þÿ[m]þÿ[m]7[c][m]þÿ[m]Dioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿ0.00003[c]þÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿEndrinSOCà ppb0.76[a][m]0.81[a][m]0.036[a][m]2[c][m]þÿ[m]&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[m]þÿ[m]þÿ[m]0.05[c][m]þÿ[m] GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿ700[c]þÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]0.01[c]þÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]0.01[c]þÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][m]0.00077[a][m]þÿ[m]1[c][m]þÿ[m]HexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿ50[c]þÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿ0.2[c]þÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿ30[c]þÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿ50[c]þÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]0.5[c]þÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][n]1[c]þÿþÿPicloramSOCÄ\Qppbþÿþÿþÿþÿþÿþÿ500[c]þÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]3[c]þÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[m]þÿ[m]þÿ[m]50[c][m]þÿ[m]BenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿ1[c]þÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿ0.5[c]þÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿ70[c]þÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿ600[c]þÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿ5[c]þÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿ0.5[c]þÿþÿ1,1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿ6[c]þÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿ6[c]þÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿ10[c]þÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿ5[c]þÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿ300[c]þÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿ5[c]þÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿ150[c]þÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿ5[c]þÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿ5[c]þÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿ5[c]þÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿ0.5[c]þÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿ1750[c]þÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[c]þÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[c]þÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[c]þÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿ3[o]þÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[f][p]E. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿ5[h]NC[f][q]Total Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿ13[c]þÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[c]þÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[c]þÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿ1[c]þÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ150[c]þÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1200[c]þÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1[h]þÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]100[c]þÿþÿAluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ200[h]þÿþÿColor No Fed. MCLþÿ Color Unitsþÿþÿþÿþÿþÿþÿ15[h]þÿþÿ Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500[h]þÿþÿIron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ300[h]þÿþÿ Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ50[h]þÿþÿOdor No Fed. MCLþÿ Odor Unitsþÿþÿþÿþÿþÿþÿ3[h]þÿþÿSilver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ100[h]þÿþÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1000000[h][f]þÿþÿChloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[h]þÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500000[h]þÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA6" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA7" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA7" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_CWO" VARCHAR2(100), "T_HHC_CWO_DISC" VARCHAR2(50), "T_HHC_COO" VARCHAR2(100), "T_HHC_COO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MCL_DW" VARCHAR2(100), "T_MCL_DW_DISC" VARCHAR2(50), "T_W_R" VARCHAR2(100), "T_W_R_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA7" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_CWO", "T_HHC_CWO_DISC", "T_HHC_COO", "T_HHC_COO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MCL_DW", "T_MCL_DW_DISC", "T_W_R", "T_W_R_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14) ôÈ2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿþÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][c][d]50þÿþÿþÿAsbestosIOCÄ"MFLþÿþÿ7[a][e]þÿþÿ7þÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿ1000þÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][f]10þÿþÿþÿChromium (total)IOCÄ7dppbþÿþÿþÿþÿþÿþÿ50þÿþÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿNC [a][c][d][f]þÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]þÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿNC[g]þÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿNC [a][c][d][f]50þÿþÿþÿMercuryIOCÄ,dMppb0.05[a]0.051[a]þÿþÿ2þÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000[h]þÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][i]10[j]þÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿþÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿþÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.00057[a][l]0.00059[a][l]0.0043[a][l]þÿ[l]þÿ[l]2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿ100þÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[l]þÿ[l]þÿ[l]þÿ[l]þÿ[l]Di(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿþÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[l]þÿ[l]þÿ[l]þÿ[l]þÿ[l]Dioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿþÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿEndrinSOCà ppb0.76[a][l]0.81[a][l]0.036[a][l]2[l]þÿ[l]&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[l]þÿ[l]þÿ[l]þÿ[l]þÿ[l] GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]þÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]þÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][l]0.00077[a][l]þÿ[l]þÿ[l]þÿ[l]HexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿþÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿ4þÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿ100þÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]þÿþÿþÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][k]þÿþÿþÿþÿPicloramSOCÄ\QppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]5þÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[l]þÿ[l]þÿ[l]10[l]þÿ[l]BenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿþÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿþÿþÿþÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿþÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿþÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿþÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿþÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿþÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿþÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿþÿþÿþÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿþÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿþÿþÿþÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿþÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿþÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿþÿþÿþÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿþÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[m]þÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[m]þÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[m]þÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[m]þÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[n]E. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[o] EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[p] TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[m]þÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[m]þÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿþÿþÿþÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]þÿþÿþÿþÿAluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿColor No Fed. MCLþÿ Color Unitsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿIron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿOdor No Fed. MCLþÿ Odor Unitsþÿþÿþÿþÿþÿþÿ50þÿþÿþÿSilver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA7" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA8" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA8" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_C_W_O" VARCHAR2(100), "T_HHC_C_W_O_DISC" VARCHAR2(50), "T_HHC_COO" VARCHAR2(100), "T_HHC_COO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MWS" VARCHAR2(100), "T_MWS_DISC" VARCHAR2(50), "T_WR_B" VARCHAR2(100), "T_WR_B_DISC" VARCHAR2(50), "T_TUR" VARCHAR2(100), "T_TUR_DISC" VARCHAR2(50), "T_M" VARCHAR2(100), "T_M_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA8" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_C_W_O", "T_HHC_C_W_O_DISC", "T_HHC_COO", "T_HHC_COO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MWS", "T_MWS_DISC", "T_WR_B", "T_WR_B_DISC", "T_TUR", "T_TUR_DISC", "T_M", "T_M_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18) ôÈ2d2d2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][c][d]þÿþÿþÿþÿþÿþÿþÿþÿAsbestosIOCÄ"MFLþÿþÿ7[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][e]þÿþÿþÿþÿþÿþÿNC[e][f]Chromium (total)IOCÄ7dppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿNC [a][c][d][e]þÿþÿþÿþÿþÿþÿNC[e][f]Cyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]þÿþÿþÿþÿþÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿNC[g]þÿþÿþÿþÿþÿþÿLeadIOCÄ,dppbþÿþÿþÿþÿNC [a][c][d][e]þÿþÿþÿþÿþÿþÿNC[e][f]MercuryIOCÄ,dMppb0.05[a]0.051[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000þÿþÿþÿþÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][h]þÿþÿþÿþÿþÿþÿþÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.00057[a][i]0.00059[a][i]0.0043[a][i]þÿ[i]þÿ[i]þÿþÿþÿ[i]2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[i]þÿ[i]þÿ[i]þÿ[i]þÿ[i]þÿþÿþÿ[i]Di(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[i]þÿ[i]þÿ[i]þÿ[i]þÿ[i]þÿþÿþÿ[i]Dioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿEndrinSOCà ppb0.76[a][i]0.81[a][i]0.036[a][i]þÿ[i]þÿ[i]þÿþÿþÿ[i]&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[i]þÿ[i]þÿ[i]þÿ[i]þÿ[i]þÿþÿþÿ[i] GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]þÿþÿþÿþÿþÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]þÿþÿþÿþÿþÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][i]0.00077[a][i]þÿ[i]þÿ[i]þÿ[i]þÿþÿþÿ[i]HexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]þÿþÿþÿþÿþÿþÿþÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][j]þÿþÿþÿþÿþÿþÿþÿþÿPicloramSOCÄ\QppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]þÿþÿþÿþÿþÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[i]þÿ[i]þÿ[i]þÿ[i]þÿ[i]þÿþÿþÿ[i]BenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[k]þÿþÿþÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[k]þÿþÿþÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[k]þÿþÿþÿþÿþÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[k]þÿþÿþÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿ100[l]þÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿNC[m]þÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[n]þÿþÿþÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[o]þÿþÿTotal Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[k]þÿþÿþÿþÿþÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[k]þÿþÿþÿþÿþÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]þÿþÿþÿþÿþÿþÿþÿþÿAluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿColor No Fed. MCLþÿ Color Unitsþÿþÿþÿþÿþÿþÿ15þÿþÿþÿþÿþÿþÿþÿ Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿIron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿOdor No Fed. MCLþÿ Odor UnitsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSilver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA8" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CA9" CREATE TABLE "TMP_CRITERIA_DU_RAW_CA9" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HHC_C_W_O" VARCHAR2(100), "T_HHC_C_W_O_DISC" VARCHAR2(50), "T_HHC_COO" VARCHAR2(100), "T_HHC_COO_DISC" VARCHAR2(50), "T_ALC_F_C" VARCHAR2(100), "T_ALC_F_C_DISC" VARCHAR2(50), "T_MCL" VARCHAR2(100), "T_MCL_DISC" VARCHAR2(50), "T_WR_B" VARCHAR2(100), "T_WR_B_DISC" VARCHAR2(50), "T_GC" VARCHAR2(100), "T_GC_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CA9" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HHC_C_W_O", "T_HHC_C_W_O_DISC", "T_HHC_COO", "T_HHC_COO_DISC", "T_ALC_F_C", "T_ALC_F_C_DISC", "T_MCL", "T_MCL_DISC", "T_WR_B", "T_WR_B_DISC", "T_GC", "T_GC_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) ôÈ2d2d2d2d2d2d2AntimonyIOCÄ-=ppb14[a]4300[b]þÿþÿ6[c]þÿþÿþÿþÿArsenicIOCÄ-SppbþÿþÿþÿþÿNC [a][d][e]50[c]þÿþÿþÿþÿAsbestosIOCÄ"MFLþÿþÿ7[a]þÿþÿ7[c]þÿþÿþÿþÿBariumIOCÄ-^ppbþÿþÿþÿþÿþÿþÿ1000[c]þÿþÿþÿþÿ BerylliumIOCÄ-ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿCadmiumIOCÄ-(ppbþÿþÿþÿþÿNC[a][f]5[c]þÿþÿþÿþÿChromium (total)IOCÄ7dppbþÿþÿþÿþÿNC[g][f]50[c]þÿþÿþÿþÿCopperIOCÄ- ppbþÿ[a]þÿþÿNC [a][d][e][f]þÿþÿþÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb700[a] 220,000[a]5.2[b]150[c]þÿþÿþÿþÿFluorideIOCÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[h]LeadIOCÄ,dppbþÿþÿþÿþÿNC [a][d][e][f]50[c]þÿþÿþÿþÿMercuryIOCÄ,dMppb0.05[a]0.051[a]NC[g][f]2[c]þÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppbþÿþÿþÿþÿþÿþÿ10000 [c][h][h]þÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppbþÿþÿþÿþÿþÿþÿ1000 [c][h][h]þÿþÿþÿþÿSeleniumIOCÄO]ppbþÿþÿþÿþÿ5[a][i]10[c]þÿþÿþÿþÿThalliumIOCÄ-Qppb1.7[a]6.3[b]þÿþÿ2[c]þÿþÿþÿþÿAlachlorSOCÄb ppbþÿþÿþÿþÿþÿþÿ2[c]þÿþÿþÿþÿAtrazineSOCÄ\2ppbþÿþÿþÿþÿþÿþÿ1[c]þÿþÿþÿþÿBenzo(a)pyrene (PAHs)SOCÃppb0.0044[a]0.049[a]þÿþÿ0.2[c]þÿþÿþÿþÿ CarbofuranSOCÄ9%?ppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿ ChlordaneSOCÃN2ppb0.00057[a][j]0.00059[a][j]0.0043[a][j]0.1[c][j]þÿ[j]þÿ[j]2,4-DSOCà 0:ppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿþÿþÿDalaponSOCÃ<[ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿ"1,2-Dibromo-3-chloropropane (DBCP)SOCà >ppbþÿ[j]þÿ[j]þÿ[j]0.2[c][j]þÿ[j]þÿ[j]Di(2-ethylhexyl) adipateSOCà ! ppbþÿþÿþÿþÿþÿþÿ400[c]þÿþÿþÿþÿDi(2-ethylhexyl) phthalateSOCà Oppb1.8þÿ5.9[b]þÿþÿ4[c]þÿþÿþÿþÿDinosebSOCà Y:ppbþÿ[j]þÿ[j]þÿ[j]7[c][j]þÿ[j]þÿ[j]Dioxin (2,3,7,8-TCDD)SOCÄK=ppb 0.000000013[a] 0.000000014[a]þÿþÿ0.00003[c]þÿþÿþÿþÿDiquatSOCà 3ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿ EndothallSOCÃ:"ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿEndrinSOCà ppb0.76[a][j]0.81[a][j]0.036[a][j]2[c][j]þÿ[j]þÿ[j]&Ethylene dibromide (1,2 Dibromoethane)SOCà F#ppbþÿ[j]þÿ[j]þÿ[j]0.05[c][j]þÿ[j]þÿ[j] GlyphosateSOCÄ%ppbþÿþÿþÿþÿþÿþÿ700[c]þÿþÿþÿþÿ HeptachlorSOCÃA1ppb0.00021[a]0.00021[a]0.0038[a]0.01[c]þÿþÿþÿþÿHeptachlor epoxideSOCÄ.Jppb0.0001[a]0.00011[a]0.0038[a]0.01[c]þÿþÿþÿþÿHexachlorobenzeneSOCà X*ppb0.00075[a][j]0.00077[a][j]þÿ[j]1[c][j]þÿ[j]þÿ[j]HexachlorocyclopentadieneSOCÃKKppb240[a]17,000[b]þÿþÿ50[c]þÿþÿþÿþÿ%Lindane (hexachlorocyclohexane gamma)SOCÃYdppb0.019[a]0.063[a]þÿþÿ0.2[c]þÿþÿþÿþÿ MethoxychlorSOCÃ$ppbþÿþÿþÿþÿþÿþÿ30[c]þÿþÿþÿþÿOxamyl (Vydate)SOCÄ5ppbþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿ Polychlorinated biphenyls (PCBs)SOCÄ"@@ppb0.00017[a]0.00017[a]0.014[a]0.5[c]þÿþÿþÿþÿPentachlorophenolSOCà OBppb0.28[a]8.2[a]NC[a][k]1[c]þÿþÿþÿþÿPicloramSOCÄ\Qppbþÿþÿþÿþÿþÿþÿ500[c]þÿþÿþÿþÿSimazineSOCà 2ppbþÿþÿþÿþÿþÿþÿ4[c]þÿþÿþÿþÿ ToxapheneSOCÄ 5ppb0.00073[a]0.00075[a]0.0002[a]3[c]þÿþÿþÿþÿ2,4,5-TP (Silvex)SOCà &ppbþÿ[j]þÿ[j]þÿ[j]50[c][j]þÿ[j]þÿ[j]BenzeneVOCÃ!ppb1.2[a]71[a]þÿþÿ1[c]þÿþÿþÿþÿCarbon tetrachlorideVOCÃ?$ppb0.25[a]4.4[b]þÿþÿ0.5[c]þÿþÿþÿþÿ ChlorobenzeneVOCà Zppb680[a]21,000[b]þÿþÿ70[c]þÿþÿþÿþÿ'o-Dichlorobenzene (1,2-Dichlorobenzene)VOCà 8ppb2,700[a]17,000[a]þÿþÿ600[c]þÿþÿþÿþÿ'p-Dichlorobenzene (1,4-Dichlorobenzene)VOCà ADppb400[a]2,600[a]þÿþÿ5[c]þÿþÿþÿþÿ1,2-DichloroethaneVOCà G?ppb0.38[a]99[a]þÿþÿ0.5[c]þÿþÿþÿþÿ1,1-DichloroethyleneVOCÃ67ppb0.057[a]3.2[b]þÿþÿ6[c]þÿþÿþÿþÿcis-1,2-DichloroethyleneVOCÃB]ppbþÿþÿþÿþÿþÿþÿ6[c]þÿþÿþÿþÿtrans-1,2-DichloroethyleneVOCÃCppb700[a]140,000[a]þÿþÿ10[c]þÿþÿþÿþÿ1,2-DichloropropaneVOCÃYLppb0.52[a]39[a]þÿþÿ5[c]þÿþÿþÿþÿ EthylbenzeneVOCà ppb3100[a]29,000[b]þÿþÿ300[c]þÿþÿþÿþÿStyreneVOCà ppbþÿþÿþÿþÿþÿþÿ100[c]þÿþÿþÿþÿTetrachloroethyleneVOCà HUppb0.8[a]8.85[b]þÿþÿ5[c]þÿþÿþÿþÿTolueneVOCà YTppb6,800[a]200,000[a]þÿþÿ150[c]þÿþÿþÿþÿ1,2,4-TrichlorobenzeneVOCà ppbþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿ1,1,1-TrichloroethaneVOCÃ9ppbþÿþÿþÿþÿþÿþÿ200[c]þÿþÿþÿþÿ1,1,2-TrichloroethaneVOCÃ[ppb0.6[a]42[b]þÿþÿ5[c]þÿþÿþÿþÿTrichloroethyleneVOCÃ[ppb2.7[a]81[b]þÿþÿ5[c]þÿþÿþÿþÿVinyl chlorideVOCÃ3ppb2[a]525[b]þÿþÿ0.5[c]þÿþÿþÿþÿXylenes (total)VOCÄ"ppbþÿþÿþÿþÿþÿþÿ1750[c]þÿþÿþÿþÿAlpha particles RadionuclidesþÿpCi/Lþÿþÿþÿþÿþÿþÿ15[c]þÿþÿþÿþÿ"Beta particles and photon emitters Radionuclidesþÿmrem/yrþÿþÿþÿþÿþÿþÿ50[c]þÿþÿþÿþÿ$Radium 226 and Radium 228 (combined) RadionuclidesÄ--pCi/Lþÿþÿþÿþÿþÿþÿ5[c]þÿþÿþÿþÿUranium RadionuclidesÄ- ppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿBromateDBPsÄ77ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChlorineDBPsÄOppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿHaloacetic acidsDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿDichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTrichloroacetic AcidDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal TrihalomethanesDBPsþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ ChloroformDBPsÃM@ppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBromodichloromethaneDBPsÃ5Kppb0.56[a]46[a]þÿþÿþÿþÿþÿþÿþÿþÿDibromochloromethaneDBPsà -Rppb0.401[a]34[a]þÿþÿþÿþÿþÿþÿþÿþÿ BromoformDBPsÃ55ppb4.3[a]360[a]þÿþÿþÿþÿþÿþÿþÿþÿCryptosporidiumMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTotal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFecal ColiformMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNC[l]þÿþÿE. ColiMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ[m]þÿþÿ EnterococciMicroorganismsþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ TurbidityMicroorganismsþÿNTUþÿþÿþÿþÿþÿþÿ5[o]þÿþÿNC[n]Total Organic Carbon (TOC) No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ!Methyltertiary-butyl ether (MTBE) No Fed. MCLÄ@)-ppbþÿþÿþÿþÿþÿþÿ13[c]þÿþÿþÿþÿDacthal No Fed. MCLÄWppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ Perchlorate No Fed. MCLÄPNppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿTritium No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ20000[c]þÿþÿþÿþÿ Strontium-90 No Fed. MCLþÿpCi/Lþÿþÿþÿþÿþÿþÿ8[c]þÿþÿþÿþÿ1,1-Dichloroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,3-Dichloropropene No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ1,1,2,2-Tetrachloroethane No Fed. MCLþÿppb0.17[a]11[b]þÿþÿ1[c]þÿþÿþÿþÿTrichlorofluoromethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ150[c]þÿþÿþÿþÿ%1,1,2-Trichloro-1,2,2-Trifluoroethane No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ1200[c]þÿþÿþÿþÿBentazon No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ18[c]þÿþÿþÿþÿMolinate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ20[c]þÿþÿþÿþÿ Thiobencarb No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ70[c]þÿþÿþÿþÿNickel No Fed. MCLþÿppb610[a]4600[a]52[a]100[c]þÿþÿþÿþÿAluminum No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ200[o]þÿþÿþÿþÿColor No Fed. MCLþÿ Color Unitsþÿþÿþÿþÿþÿþÿ15[o]þÿþÿNC[m] Corrosivity No Fed. MCLþÿþÿþÿþÿþÿþÿþÿþÿNC[o]þÿþÿþÿþÿFoaming Agents (MBAs) No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ500[o]þÿþÿNC[m]Iron No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ300[o]þÿþÿNC[m] Manganese No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ50[o]þÿþÿNC[m]Odor No Fed. MCLþÿ Odor Unitsþÿþÿþÿþÿþÿþÿ3[o]þÿþÿNC[m]Silver No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿ100[o]þÿþÿþÿþÿTotal Dissolved Solids No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿNC[o]þÿþÿNC[m]Chloride No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿNC[o]þÿþÿNC[m]Sulfate No Fed. MCLþÿppbþÿþÿþÿþÿþÿþÿNC[o]þÿþÿNC[m]ÿÿ GRANT SELECT ON "TMP_CRITERIA_DU_RAW_CA9" TO "WQSDEV" TABLE "TMP_CRITERIA_DU_RAW_CO" CREATE TABLE "TMP_CRITERIA_DU_RAW_CO" ("CONTAMINANT" VARCHAR2(500), "CATEGORY" VARCHAR2(200), "CAS_NUMBER" NUMBER(12, 0), "UNITS" VARCHAR2(50), "T_HH_WS_DWS" VARCHAR2(100), "T_HH_WS_DWS_DISC" VARCHAR2(50), "T_ALC" VARCHAR2(100), "T_ALC_DISC" VARCHAR2(50), "T_HH_W_F" VARCHAR2(100), "T_HH_W_F_DISC" VARCHAR2(50), "T_HH_F_I" VARCHAR2(100), "T_HH_F_I_DISC" VARCHAR2(50), "T_R_EPC" VARCHAR2(100), "T_R_EPC_DISC" VARCHAR2(50), "T_R_PPC" VARCHAR2(100), "T_R_PPC_DISC" VARCHAR2(50), "T_R_SC" VARCHAR2(100), "T_R_SC_DISC" VARCHAR2(50), "T_R" VARCHAR2(100), "T_R_DISC" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WQS_DATA" LOGGING NOCOMPRESS INSERT INTO "TMP_CRITERIA_DU_RAW_CO" ("CONTAMINANT", "CATEGORY", "CAS_NUMBER", "UNITS", "T_HH_WS_DWS", "T_HH_WS_DWS_DISC", "T_ALC", "T_ALC_DISC", "T_HH_W_F", "T_HH_W_F_DISC", "T_HH_F_I", "T_HH_F_I_DISC", "T_R_EPC", "T_R_EPC_DISC", "T_R_PPC", "T_R_PPC_DISC", "T_R_SC", "T_R_SC_DISC", "T_R", "T_R_DISC") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20) ôÈ2d2d2d2d2d2d2d2d2AntimonyIOCÄ-=ppb6[a][b]þÿþÿ5.6þÿ640þÿþÿþÿþÿþÿþÿþÿþÿþÿArsenicIOCÄ-SppbNC [a][b][c]150[d]0.02þÿ7.6þÿþÿþÿþÿþÿþÿþÿþÿþÿAsbestosIOCÄ"MFL7þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿBariumIOCÄ-^ppbNC[b][f]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿ BerylliumIOCÄ-ppb4[a][b]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCadmiumIOCÄ-(ppb5[b][d]NC[e][g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿChromium (total)IOCÄ7dppb50[b][d]11[e][h]100[a][h]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCopperIOCÄ- ppb1,000[a][b]NC[e][g]1,300þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿCyanide (as free cyanide)IOCÃHppb200[d]5[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿFluorideIOCÄOppb2,000[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿLeadIOCÄ,dppb50[b][d]NC[e][g]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿMercuryIOCÄ,dMppb0.01[b][d]2[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrate (measured as Nitrogen)IOCÄPL;ppb10,000[d]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿNitrite (measured as Nitrogen)IOCÄPM3ppb1,000[d]þÿ[i]þÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿþÿSeleniumIOCÄO]ppb50[a][b]4.6[e]170þÿ4,200þÿþÿþÿþÿþÿþÿþÿþÿþÿThalliumIOCÄ-Qppb0.5[a][b]15[e]0.24þÿ0.47þÿþÿþÿþÿþÿþÿþÿþÿþÿAlachlorSOCÄb ppb2[j]þÿþÿ2þÿ140þÿþÿþÿþÿþÿþÿþÿþÿþÿAt