Changeset 21581 in main


Ignore:
Timestamp:
09/18/20 15:52:13 (5 weeks ago)
Author:
LoisHaggard_NM
Message:

NMBIS Backend QModules - EPHT watewr and childlead

Location:
adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT
Files:
14 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/childlead/_childlead.cfg

    r20642 r21581  
    2020d saspopdata birth90_17geo_18ungeo
    2121d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    22 r data_where 2009<=bcyear<=2016
     22r data_where 2009<=bcyear<=2017
    2323r pop_where 2009<=year<=2016&and&NMRes=1
    2424d sascdata temp
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/childlead/_childlead6in1.cfg

    r20642 r21581  
    1818d saspop E:\ibisq\sasData\final\
    1919d sasdata childleadann
    20 r data_where 2009<=t_year<=2018
     20r data_where 2009<=t_year<=2019
    2121d saspopdata popibiscnty90_18_28jun2019
    2222r pop_where 2009<=year<=2018&and&AGEGRP35<7
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/childlead/_childleadElevRate.cfg

    r20642 r21581  
    1919d saspop E:\ibisq\sasData\final\
    2020d sasdata childlead
    21 r data_where 2009<=bcyear<=2016
     21r data_where 2009<=bcyear<=2017
    2222d saspopdata childlead
    2323#d saspopdata birth90_11geosecure
    24 r pop_where 2009<=bcyear<=2016
     24r pop_where 2009<=bcyear<=2017
    2525d sasstdpop morstd
    2626r pop_where stdyr=2000
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/childlead/_childleadtested6in1.cfg

    r20642 r21581  
    1818d saspop E:\ibisq\sasData\final\
    1919d sasdata childleadann
    20 r data_where 2009<=t_year<=2018
     20r data_where 2009<=t_year<=2019
    2121d saspopdata childleadann
    22 r pop_where 2009<=t_year<=2018
     22r pop_where 2009<=t_year<=2019
    2323d sasstdpop morstd
    2424r pop_where stdyr=2000
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/climate/XML3Count.map

    r21223 r21581  
    111 MEASURE 1 Num
    222 ANCILLARY_VALUE Numerator
    3 2 ANCILLARY_VALUE Denominator
    4 2 VALUE_ATTRIBUTE #
     33 ANCILLARY_VALUE Denominator
     44 VALUE_ATTRIBUTE
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/NM_MaxNitR.def

    r20954 r21581  
    2929#################################################
    3030# definition for output file
    31 f xml_out_map_file XML2Rate.map
     31f xml_out_map_file XMLNM2Rate.map
    3232--------BoNdArY--------
    3333f out_detail lbl_not_used__see_xml_out_map_file
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/NM_MeanNitR.def

    r20965 r21581  
    2828#################################################
    2929# definition for output file
    30 f xml_out_map_file XML2Rate.map
     30f xml_out_map_file XMLNM2Rate.map
    3131--------BoNdArY--------
    3232f out_detail lbl_not_used__see_xml_out_map_file
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/NM_MeanQtrNitR.def

    r20965 r21581  
    3030#################################################
    3131# definition for output file
    32 f xml_out_map_file XML2Rate.map
     32f xml_out_map_file XMLNM2Rate.map
    3333--------BoNdArY--------
    3434f out_detail lbl_not_used__see_xml_out_map_file
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/NM_SystemsCount.def

    r20965 r21581  
     1
    12#f label Count
    23f type special
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/XMLNMSys2Number.map

    r20965 r21581  
    111 MEASURE number
    222 ANCILLARY_VALUE Numerator
    3 3 VALUE_ATTRIBUTE #
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/XMLNMSysNumber.map

    r20965 r21581  
    111 MEASURE number
    2 3 VALUE_ATTRIBUTE #
     23 VALUE_ATTRIBUTE
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/_Water_AnnMax.cfg

    r21457 r21581  
    77# 05/26/2011  Brian       Use Utah model, thanks Tong and Sharndra.
    88# 04/24/2019  Brian               Continuous revisions, added multile dimensions
     9# 09/11/2020  Brian               Complete MCL and Raw revisions, sync with 3.0
    910#=========================================================================
    1011#value name_path value_path
     
    58591 year_s Year null Sample&Year num 0 4
    5960
    60 2 MaxMCLARS MCL_Arsenic null MCL&Level&by&Arsenic num 0 8
    61 2 MaxRawMCLARS MCL_Raw_Arsenic null MCL&Level&by&Arsenic num 0 8
    62 2 maxArs Level_Arsenic null Level&by&Arsenic num 0 8
    63 2 MaxRawArs Level_Raw_Arsenic null Level&by&Arsenic num 0 8
     612 MaxMCLARS Arsenic_MCL null MCL&Level&by&Arsenic num 0 8
     622 MaxRawMCLARS Arsenic_MCL_Raw null MCL&Level&by&Arsenic num 0 8
     632 maxArs Arsenic_Level null Level&by&Arsenic num 0 8
     642 MaxRawArs Arsenic_Level_Raw null Level&by&Arsenic num 0 8
    6465#2 MaxNDARS ND_Level_Arsenic null ND&Level&by&Arsenic num 0 8
    6566#2 MaxRawNDARS ND_Level_Raw_Arsenic null ND&Level&by&Arsenic num 0 8
    6667
    67 2 MaxMCLAtr MCL_ATR null MCL&Level&by&ATR num 0 8
    68 2 maxAtr Level_ATR null Level&by&Atrazine num 0 8
    69 2 MaxRawATR Level_Raw_ATR null Level&by&ATR num 0 8
    70 2 MaxRawMCLATR MCL_Raw_ATR null MCL&Level&by&ATR num 0 8
     682 MaxMCLATR ATR_MCL null MCL&Level&by&ATR num 0 8
     692 MaxAtr ATR_Level null Level&by&Atrazine num 0 8
     702 MaxRawATR ATR_Level_Raw null Level&by&ATR num 0 8
     712 MaxRawMCLATR ATR_MCL_Raw null MCL&Level&by&ATR num 0 8
    7172#2 MaxNDATR ND_Level_ATR null ND&Level&by&ATR num 0 8
    7273#2 MaxRawNDATR ND_Level_Raw_ATR null ND&Level&by&ATR num 0 8
    7374
    74 2 MaxDEHP Level_DEHP null Level&by&DEHP num 0 8
    75 2 MaxNDDEHP ND_Level_DEHP null ND&Level&by&DEHP num 0 8
    76 2 MaxMCLDEHP MCL_DEHP null MCL&Level&by&DEHP num 0 8
    77 2 MaxRawDEHP Level_Raw_DEHP null Level&by&DEHP num 0 8
    78 2 MaxRawNDDEHP ND_Level_Raw_DEHP null ND&Level&by&DEHP num 0 8
    79 2 MaxRawMCLDEHP MCL_Raw_DEHP null MCL&Level&by&DEHP num 0 8
     752 MaxDEHP DEHP_Level null Level&by&DEHP num 0 8
     762 MaxRawDEHP DEHP_Level_Raw null Level&by&DEHP num 0 8
     772 MaxMCLDEHP DEHP_MCL null MCL&Level&by&DEHP num 0 8
     782 MaxRawMCLDEHP DEHP_MCL_Raw null MCL&Level&by&DEHP num 0 8
     79#2 MaxNDDEHP ND_Level_DEHP null ND&Level&by&DEHP num 0 8
     80#2 MaxRawNDDEHP ND_Level_Raw_DEHP null ND&Level&by&DEHP num 0 8
    8081
    81 2 MaxHAA Level_HAA null Level&by&HAA5 num 0 8
    82 2 MaxNDHAA ND_Level_HAA null ND&Level&by&HAA num 0 8
    83 2 MaxMCLHAA MCL_HAA null MCL&Level&by&HAA num 0 8
    84 2 MaxRawHAA Level_Raw_HAA null Level&by&HAA num 0 8
    85 2 MaxRawNDHAA ND_Level_Raw_HAA null ND&Level&by&HAA num 0 8
    86 2 MaxRawMCLHAA MCL_Raw_HAA null MCL&Level&by&HAA num 0 8
     822 MaxMCLHAA HAA_MCL null MCL&Level&by&HAA num 0 8
     832 MaxHAA HAA_Level null Level&by&HAA5 num 0 8
     842 MaxRawMCLHAA HAA_MCL_Raw null MCL&Level&by&HAA num 0 8
     852 MaxRawHAA HAA_Level_Raw null Level&by&HAA num 0 8
     86#2 MaxRawNDHAA ND_HAA_Level_Raw null ND&Level&by&HAA num 0 8
     87#2 MaxNDHAA ND_HAA_Level null ND&Level&by&HAA num 0 8
    8788
    88 2 maxNit Level_Nitrate null Level&by&Nitrates num 0 8
    89 2 maxPCE Level_PCE null Level&by&PCE num 0 8
    90 2 maxRadium Level_Radium null Level&by&Radium num 0 8
    91 2 maxTCE Level_TCE null Level&by&TCE num 0 8
    92 2 maxTHM Level_THM null Level&by&THM num 0 8
    93 2 maxUranium Level_Uranium null Level&by&Uranium num 0 8
     892 MaxNit Nitrate_Level null Level&by&Nitrates num 0 8
     902 MaxMCLNIT Nitrate_MCL null MCL&Level&by&NIT num 0 8
     912 MaxRawMCLNIT Nitrate_MCL_Raw null Level&by&NIT num 0 8
     922 MaxRawNIT Nitrate_Level_Raw null MCL&Level&by&NIT num 0 8
     93
     942 maxPCE PCE_Level null Level&by&PCE num 0 8
     952 MaxMCLPCE PCE_MCL null MCL&Level&by&PCE num 0 8
     962 MaxRawMCLPCE PCE_MCL_Raw null Level&by&PCE num 0 8
     972 MaxRawPCE PCE_Level_Raw null MCL&Level&by&PCE num 0 8
     98
     992 MaxRadium Radium_Level null Level&by&Radium num 0 8
     1002 MaxMCLRadium Radium_MCL null MCL&Level&by&Radium num 0 8
     1012 MaxRawMCLRadium Radium_MCL_Raw null Level&by&Radium num 0 8
     1022 MaxRawRadium Radium_Level_Raw null MCL&Level&by&Radium num 0 8
     103
     1042 MaxTCE TCE_Level null Level&by&TCE num 0 8
     1052 MaxMCLTCE TCE_MCL null MCL&Level&by&TCE num 0 8
     1062 MaxRawMCLTCE TCE_MCL_Raw null Level&by&TCE num 0 8
     1072 MaxRawTCE TCE_Level_Raw null MCL&Level&by&TCE num 0 8
     108
     1092 MaxTHM THM_Level null Level&by&THM num 0 3
     1102 MaxRawTHM THM_Level_Raw null Level&by&THM num 0 8
     1112 MaxMCLTHM THM_MCL null MCL&Level&by&THM num 0 8
     1122 MaxRawMCLTHM THM_MCL_Raw null MCL&Level&by&THM num 0 8
     113
     1142 MaxUranium Uranium_Level null Level&by&Uranium num 0 3
     1152 MaxRawUranium Uranium_Level_Raw null Level&by&Uranium num 0 8
     1162 MaxMCLUranium Uranium_MCL null MCL&Level&by&Uranium num 0 8
     1172 MaxRawMCLUranium Uranium_MCL_Raw null MCL&Level&by&Uranium num 0 8
    94118
    951193 PopSize PopSize null Persons&Served&by&System num 0 8
     
    971214 null GeoProxy null ProxyVar num 10 4
    981224 PWSID PWSInventory null Community&Water&System num 0 5
    99 
    100 
    101 
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/_Water_AnnMean.cfg

    r21457 r21581  
    66# ----------  ----------  -------------------------------------------------
    77# 05/26/2011  Brian       Use Utah model, thanks Tong and Sharndra, Annual cfg. 
    8 # 04/24/2019  Brian               Continuous revisions, added multile dimensions
     8# 04/24/2019  Brian               Continuous revisions, added multile dimensions
     9# 09/11/2020  Brian               Complete MCL and Raw revisions, sync with 3.0
    910#=========================================================================
    10 #value name_path value_path   
     11#value name_path value_path
    1112d homepath E:\ibisq\qModules30\_EPHT\water\
    1213d workpath E:\ibisq\workpath
     
    59601 year_s Year null Sample&Year num 0 4
    6061
    61 2 MeanMCLARS MCL_Arsenic null MCL&Level&by&Arsenic num 0 8
    62 2 meanRawArs Level_Raw_Arsenic null Level&by&Arsenic num 0 8
    63 2 meanArs Level_Arsenic null Level&by&Arsenic num 0 8
    64 2 MeanRawMCLARS MCL_Raw_Arsenic null MCL&Level&by&Arsenic num 0 8
     622 MeanMCLARS Arsenic_MCL null MCL&Level&by&Arsenic num 0 8
     632 MeanRawMCLARS Arsenic_MCL_Raw null MCL&Level&by&Arsenic num 0 8
     642 MeanArs Arsenic_Level null Level&by&Arsenic num 0 8
     652 MeanRawArs Arsenic_Level_Raw null Level&by&Arsenic num 0 8
    6566#2 MeanNDARS ND_Level_Arsenic null ND&Level&by&Arsenic num 0 8
    6667#2 MeanRawNDARS ND_Level_Raw_Arsenic null ND&Level&by&Arsenic num 0 8
    6768
    68 2 meanAtr Level_ATR null Level&by&Atrazine num 0 8
    69 2 MeanMCLATR MCL_ATR null MCL&Level&by&ATR num 0 8
    70 2 MeanRawMCLATR MCL_Raw_ATR null MCL&Level&by&ATR num 0 8
    71 2 meanRawATR Level_Raw_ATR null Level&by&ATR num 0 8
     692 MeanAtr ATR_Level null Level&by&Atrazine num 0 8
     702 MeanMCLATR ATR_MCL null MCL&Level&by&ATR num 0 8
     712 MeanRawMCLATR ATR_MCL_Raw null MCL&Level&by&ATR num 0 8
     722 MeanRawATR ATR_Level_Raw null Level&by&ATR num 0 8
    7273#2 MeanNDATR ND_Level_ATR null ND&Level&by&ATR num 0 8
    7374#2 MeanRawNDATR ND_Level_Raw_ATR null ND&Level&by&ATR num 0 8
    7475
    75 2 MeanDEHP Level_DEHP null Level&by&DEHP num 0 8
    76 2 MeanMCLDEHP MCL_DEHP null MCL&Level&by&DEHP num 0 8
    77 2 meanRawDEHP Level_Raw_DEHP null Level&by&DEHP num 0 8
    78 2 MeanRawMCLDEHP MCL_Raw_DEHP null MCL&Level&by&DEHP num 0 8
     762 MeanDEHP DEHP_Level null Level&by&DEHP num 0 8
     772 MeanRawDEHP DEHP_Level_Raw null Level&by&DEHP num 0 8
     782 MeanMCLDEHP DEHP_MCL null MCL&Level&by&DEHP num 0 8
     792 MeanRawMCLDEHP DEHP_MCL_Raw null MCL&Level&by&DEHP num 0 8
    7980#2 MeanNDDEHP ND_Level_DEHP null ND&Level&by&DEHP num 0 8
    8081#2 MeanRawNDDEHP ND_Level_Raw_DEHP null ND&Level&by&DEHP num 0 8
    8182
    82 2 MeanHAA Level_HAA null Level&by&HAA5 num 0 8
    83 2 MeanMCLHAA MCL_HAA null MCL&Level&by&HAA num 0 8
    84 2 meanRawHAA Level_Raw_HAA null Level&by&HAA num 0 8
    85 2 MeanRawMCLHAA MCL_Raw_HAA null MCL&Level&by&HAA num 0 8
    86 #2 MeanNDHAA ND_Level_HAA null ND&Level&by&HAA num 0 8
    87 #2 MeanRawNDHAA ND_Level_Raw_HAA null ND&Level&by&HAA num 0 8
     832 MeanHAA HAA_Level null Level&by&HAA5 num 0 8
     842 MeanMCLHAA HAA_MCL null MCL&Level&by&HAA num 0 8
     852 meanRawHAA HAA_Level_Raw null Level&by&HAA num 0 8
     862 MeanRawMCLHAA HAA_MCL_Raw null MCL&Level&by&HAA num 0 8
     87#2 MeanNDHAA ND_HAA_Level null ND&Level&by&HAA num 0 8
     88#2 MeanRawNDHAA ND_HAA_Level_Raw null ND&Level&by&HAA num 0 8
    8889
    89 2 meanNit Level_Nitrate null Level&by&Nitrates num 0 8
    90 2 meanPCE Level_PCE null Level&by&PCE num 0 8
    91 2 meanRadium Level_Radium null Level&by&Radium num 0 8
    92 2 meanTCE Level_TCE null Level&by&TCE num 0 8
    93 2 meanTHM Level_THM null Level&by&THM num 0 8
    94 2 meanUranium Level_Uranium null Level&by&Uranium num 0 8
     902 meanNit Nitrate_Level null Level&by&Nitrates num 0 8
     912 MeanMCLNIT Nitrate_MCL null MCL&Level&by&NIT num 0 8
     922 meanRawNIT Nitrate_Level_Raw null Level&by&NIT num 0 8
     932 MeanRawMCLNIT Nitrate_MCL_Raw null MCL&Level&by&NIT num 0 8
     94
     952 MeanPCE PCE_Level null Level&by&PCE num 0 8
     962 MeanMCLPCE PCE_MCL null MCL&Level&by&PCE num 0 8
     972 MeanRawMCLPCE PCE_MCL_Raw null Level&by&PCE num 0 8
     982 MeanRawPCE PCE_Level_Raw null MCL&Level&by&PCE num 0 8
     99
     1002 MeanRadium Radium_Level null Level&by&Radium num 0 8
     1012 MeanMCLRadium Radium_MCL null MCL&Level&by&Radium num 0 8
     1022 MeanRawMCLRadium Radium_MCL_Raw null Level&by&Radium num 0 8
     1032 MeanRawRadium Radium_Level_Raw null MCL&Level&by&Radium num 0 8
     104
     1052 MeanTCE TCE_Level null Level&by&TCE num 0 8
     1062 MeanMCLTCE TCE_MCL null MCL&Level&by&TCE num 0 8
     1072 MeanRawMCLTCE TCE_MCL_Raw null Level&by&TCE num 0 8
     1082 MeanRawTCE TCE_Level_Raw null MCL&Level&by&TCE num 0 8
     109
     1102 meanTHM THM_Level null Level&by&THM num 0 3
     1112 meanRawTHM THM_Level_Raw null Level&by&THM num 0 8
     1122 MeanMCLTHM THM_MCL null MCL&Level&by&THM num 0 8
     1132 MeanRawMCLTHM THM_MCL_Raw null MCL&Level&by&THM num 0 8
     114
     1152 MeanUranium Uranium_Level null Level&by&Uranium num 0 3
     1162 MeanRawUranium Uranium_Level_Raw null Level&by&Uranium num 0 8
     1172 MeanMCLUranium Uranium_MCL null MCL&Level&by&Uranium num 0 8
     1182 MeanRawMCLUranium Uranium_MCL_Raw null MCL&Level&by&Uranium num 0 8
    95119
    961203 PopSize PopSize null Persons&Served&by&System num 0 4
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/water/_Water_Qtr.cfg

    r21457 r21581  
    1 #==============================================================================
     1#=========================================================================
    22# IBIS-Q Configuration File
    33
     
    66# ----------  ----------  -------------------------------------------------
    77# 03/26/2020  Brian       update with 2019 data. 
    8 #==============================================================================
     8#=========================================================================
    99#value name_path value_path   
    1010d homepath E:\ibisq\qModules30\_EPHT\water\
     
    2929r sas 0
    3030r test 0
    31 ###########################################################################
     31##########################################################################
    3232#value =any value, place holder only
    3333# name_sas  = SAS variable name in the numerator data set
     
    5151#        9 -- Disable variable (To avoid conflict)
    5252#       10 –  Proxy variable
    53 #============================================================================
     53#=========================================================================
    5454#value name_sas Dimension_name_html name_pop prompt type1 type2 length 
    55 #============================================================================
     55#=========================================================================
    56561 null QuarterProxy null ProxyVar num 10 4
    57571 qtr Quarter null Year&and&Quarter num 0 4
    5858
    59 2 null THMProxy null ProxyVar num 10 4
    60 2 meanAtr Level_ATR null Level&by&Atrazine num 0 3
    61 2 MeanMCLATR MCL_ATR null MCL&Level&by&ATR num 0 8
    62 2 MeanRawMCLATR MCL_Raw_ATR null MCL&Level&by&ATR num 0 8
    63 2 meanRawATR Level_Raw_ATR null Level&by&ATR num 0 8
     592 meanAtr ATR_Level null Level&by&Atrazine num 0 8
     602 MeanMCLATR ATR_MCL null MCL&Level&by&ATR num 0 8
     612 MeanRawMCLATR ATR_MCL_Raw null MCL&Level&by&ATR num 0 8
     622 meanRawATR ATR_Level_Raw null Level&by&ATR num 0 8
    6463
    65 2 meanHAA Level_HAA null Level&by&HAA5 num 0 3
    66 2 MeanMCLHAA MCL_HAA null MCL&Level&by&HAA num 0 8
    67 2 MeanRawMCLHAA MCL_Raw_HAA null MCL&Level&by&HAA num 0 8
    68 2 meanRawHAA Level_Raw_HAA null Level&by&HAA num 0 8
     642 meanHAA HAA_Level null Level&by&HAA5 num 0 3
     652 MeanMCLHAA HAA_MCL null MCL&Level&by&HAA num 0 8
     662 MeanRawMCLHAA HAA_MCL_Raw null MCL&Level&by&HAA num 0 8
     672 meanRawHAA HAA_Level_Raw null Level&by&HAA num 0 8
    6968
    70 2 meanNit Level_Nitrate null Level&by&Nitrates num 0 3
    71 2 MeanMCLNitrate MCL_Nitrate null MCL&Level&by&Nitrate num 0 8
    72 2 MeanRawMCLNitrate MCL_Raw_Nitrate null MCL&Level&by&Nitrate num 0 8
    73 2 meanRawNitrate Level_Raw_Nitrate null Level&by&Nitrate num 0 8
     692 meanNit Nitrate_Level null Level&by&Nitrates num 0 8
     702 MeanMCLNIT Nitrate_MCL null MCL&Level&by&NIT num 0 8
     712 meanRawNIT Nitrate_Level_Raw null Level&by&NIT num 0 8
     722 MeanRawMCLNIT Nitrate_MCL_Raw null MCL&Level&by&NIT num 0 8
    7473
    75 2 meanTHM Level_THM null Level&by&THM num 0 3
    76 2 MeanMCLTHM MCL_THM null MCL&Level&by&THM num 0 8
    77 2 MeanRawMCLTHM MCL_Raw_THM null MCL&Level&by&THM num 0 8
    78 2 meanRawTHM Level_Raw_THM null Level&by&THM num 0 8
     74#2 null THMProxy null ProxyVar num 10 4
     752 meanTHM THM_Level null Level&by&THM num 0 3
     762 meanRawTHM THM_Level_Raw null Level&by&THM num 0 8
     772 MeanMCLTHM THM_MCL null MCL&Level&by&THM num 0 8
     782 MeanRawMCLTHM THM_MCL_Raw null MCL&Level&by&THM num 0 8
    7979
    80803 popsize PopSize null Persons&Served&by&System num 0 4
     81
    81824 null GeoProxy null ProxyVar num 10 4
    82834 PWSID PWSInventory null Community&Water&System num 0 5
Note: See TracChangeset for help on using the changeset viewer.