Changeset 24338 in main


Ignore:
Timestamp:
12/20/21 09:25:05 (8 months ago)
Author:
LoisHaggard_STG
Message:

HI 3.0 mort query updating to 3.0, believed to be final

Location:
adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort
Files:
1 added
2 deleted
9 edited
2 moved

Legend:

Unmodified
Added
Removed
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/MortCnty.xml

    r24311 r24338  
    33<QUERY_MODULE xmlns:ibis="http://www.ibisph.org">
    44
    5         <!-- <DEVELOPMENT_FLAG/> -->
     5        <DEVELOPMENT_FLAG/>
    66
    77        <NAME>MortCnty</NAME>
    88        <TITLE>Hawai'i Death Data</TITLE>
    99        <DESCRIPTION>Deaths by county</DESCRIPTION>
    10         <VERSION>Nov 22, 2021</VERSION>
     10        <VERSION>Dec 17, 2021</VERSION>
    1111        <KEYWORDS>mortality, leading causes of death, age at death, ICD-10</KEYWORDS>
    1212        <ORG_UNIT_NAME>DEFAULT</ORG_UNIT_NAME>
     
    7474                        <DEFAULT_CATEGORY_DIMENSION_NAME>YearProxy</DEFAULT_CATEGORY_DIMENSION_NAME>
    7575                        <DEFAULT_CHART_NAME>GroupedHorzBar</DEFAULT_CHART_NAME>
    76                         <DEFAULT_MAP_NAME>DEFAULT_RedOrYel</DEFAULT_MAP_NAME>
     76                        <DEFAULT_MAP_NAME>DEFAULT_YelOrRed</DEFAULT_MAP_NAME>
    7777                        <MEASURE_NAME>Rate100K</MEASURE_NAME>
    7878                        <MEASURE_TITLE_OVERRIDE>Deaths per 100,000 population, crude</MEASURE_TITLE_OVERRIDE>
     
    9393                                </DATASET_ANCILLARY_VALUE>
    9494                        </DATASET_ANCILLARY_VALUES>
    95                        
    9695                        <PARAMETERS>
    9796                                <PARAMETER>
     
    102101                                        <NAME>StateResRate</NAME>
    103102                                        <VALUE>1</VALUE>
    104                                 </PARAMETER>
    105                                 <ibis:include href="parameter/GeoProxyDataWhere.xml"/>   <!-- Used to limit Deaths to subselections, like DrugOverdose -->
     103                                </PARAMETER><!-- Used to limit state residence by dimension, like DrugOverdose -->
     104                                <ibis:include href="parameter/GeoProxyDataWhere.xml"/>
    106105                        </PARAMETERS>
    107106                        <CRITERIA>
     
    146145                                </DATASET_ANCILLARY_VALUE>
    147146                        </DATASET_ANCILLARY_VALUES>
    148 
    149147                        <PARAMETERS>
    150148                                <PARAMETER>
     
    155153                                        <NAME>StateResRate</NAME>
    156154                                        <VALUE>1</VALUE>
    157                                 </PARAMETER>
    158                                 <ibis:include href="parameter/GeoProxyDataWhere.xml"/>   <!-- Used to limit Deaths to subselections, like DrugOverdose -->
     155                                </PARAMETER><!-- Used to limit state residence by dimension, like DrugOverdose -->
     156                                <ibis:include href="parameter/GeoProxyDataWhere.xml"/>
    159157                        </PARAMETERS>
    160158                        <CRITERIA>
     
    214212                -->
    215213                <ibis:include href="dimension/GeoProxy.xml"/>
    216                 <ibis:include href="dimension/StateOccur.xml" configuration-name-list="Count"/>
    217                 <ibis:include href="dimension/GeoCntyOccur.xml" configuration-name-list="Count"/>
    218                 <ibis:include href="dimension/GeoIslandOccur.xml" configuration-name-list="Count"/>
    219214                <ibis:include href="dimension/StateRes.xml" configuration-name-list="Count"/>
    220215                <ibis:include href="dimension/StateResRate.xml" configuration-name-list="CrudeRate, AgeRate"/>
     
    222217                <ibis:include href="dimension/GeoCntyRate.xml" configuration-name-list="CrudeRate, AgeRate"/>
    223218                <ibis:include href="dimension/GeoIslandRes.xml" configuration-name-list="Count"/>
    224                 <ibis:include href="dimension/StateResCommunity.xml" configuration-name-list="Count"/>
     219                <ibis:include href="dimension/GeoCmmntyRes.xml" configuration-name-list="Count"/>
    225220                <ibis:include href="dimension/GeoPCSARes.xml" configuration-name-list="Count"/>
    226                 <ibis:include href="dimension/StateResSchool.xml" configuration-name-list="Count"/>
    227                 <ibis:include href="dimension/GeoSch.xml" configuration-name-list="Count"/>
     221                <ibis:include href="dimension/GeoSchRes.xml" configuration-name-list="Count"/>
     222                <ibis:include href="dimension/StateOccur.xml" configuration-name-list="Count"/>
     223                <ibis:include href="dimension/GeoCntyOccur.xml" configuration-name-list="Count"/>
     224                <ibis:include href="dimension/GeoIslandOccur.xml" configuration-name-list="Count"/>
    228225               
    229226                <ibis:include href="dimension/YearProxy.xml"/>
     
    237234               
    238235                <ibis:include href="dimension/Sex.xml"/>
    239                 <ibis:include href="dimension/RaceDOH.xml" configuration-name-list="Count"/>
     236                <ibis:include href="dimension/RaceDOHNoProxy.xml" configuration-name-list="Count"/>
    240237                <ibis:include href="dimension/RaceCensus.xml"/>
    241238                <ibis:include href="dimension/RaceProgram.xml" configuration-name-list="Count"/>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/MortCntyDOHRace.xml

    r24311 r24338  
    22
    33<QUERY_MODULE xmlns:ibis="http://www.ibisph.org">
    4 
    5         <!-- <DEVELOPMENT_FLAG/> -->
    64
    75        <NAME>MortCntyDOHRace</NAME>
    86        <TITLE>Hawai'i Death Data</TITLE>
    97        <DESCRIPTION>Deaths by county</DESCRIPTION>
    10         <VERSION>Nov 22, 2021</VERSION>
     8        <VERSION>Dec 17, 2021</VERSION>
    119        <KEYWORDS>mortality, leading causes of death, age at death, ICD-10</KEYWORDS>
    1210        <ORG_UNIT_NAME>DEFAULT</ORG_UNIT_NAME>
     
    4341                        <DEFAULT_CATEGORY_DIMENSION_NAME>RaceDOH</DEFAULT_CATEGORY_DIMENSION_NAME>
    4442                        <DEFAULT_CHART_NAME>GroupedHorzBar</DEFAULT_CHART_NAME>
    45                         <DEFAULT_MAP_NAME>DEFAULT_RedOrYel</DEFAULT_MAP_NAME>
     43                        <DEFAULT_MAP_NAME>DEFAULT_YelOrRed</DEFAULT_MAP_NAME>
    4644                        <MEASURE_NAME>Rate100K</MEASURE_NAME>
    4745                        <MEASURE_TITLE_OVERRIDE>Deaths per 100,000 population, crude</MEASURE_TITLE_OVERRIDE>
     
    6260                                </DATASET_ANCILLARY_VALUE>
    6361                        </DATASET_ANCILLARY_VALUES>
    64                        
     62
    6563                        <PARAMETERS>
    6664                                <PARAMETER>
     
    7169                                        <NAME>StateResRate</NAME>
    7270                                        <VALUE>1</VALUE>
    73                                 </PARAMETER>
     71                                </PARAMETER><!-- Used to limit state residence by dimension, like DrugOverdose -->
    7472                                <ibis:include href="parameter/GeoProxyDataWhere.xml"/>
    7573                        </PARAMETERS>
     
    9492                        <TITLE>Age-adjusted Rates, Deaths per 100,000 Population for DOH Race Categories</TITLE>
    9593                        <DESCRIPTION>Mortality Age-adjusted Rates</DESCRIPTION>
    96                         <DEFAULT_CATEGORY_DIMENSION_NAME>YearProxy</DEFAULT_CATEGORY_DIMENSION_NAME>
     94                        <DEFAULT_CATEGORY_DIMENSION_NAME>RaceDOH</DEFAULT_CATEGORY_DIMENSION_NAME>
    9795                        <DEFAULT_CHART_NAME>GroupedHorzBar</DEFAULT_CHART_NAME>
    98                         <DEFAULT_MAP_NAME>DEFAULT_RedOrYel</DEFAULT_MAP_NAME>
     96                        <DEFAULT_MAP_NAME>DEFAULT_YelOrRed</DEFAULT_MAP_NAME>
    9997                        <MEASURE_NAME>RateAA100K</MEASURE_NAME>
    10098                        <MEASURE_TITLE_OVERRIDE>Deaths per 100,000 population, age-adjusted</MEASURE_TITLE_OVERRIDE>
     
    124122                                        <NAME>StateResRate</NAME>
    125123                                        <VALUE>1</VALUE>
    126                                 </PARAMETER>
    127                                 <ibis:include href="parameter/GeoProxyDataWhere.xml"/>   <!-- Used to limit Deaths to subselections, like DrugOverdose -->
     124                                </PARAMETER><!-- Used to limit state residence by dimension, like DrugOverdose -->
     125                                <ibis:include href="parameter/GeoProxyDataWhere.xml"/>
    128126                        </PARAMETERS>
    129127                        <CRITERIA>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/dimension/GeoCmmntyRes.xml

    r24337 r24338  
    22
    33<DIMENSION>
    4         <NAME>GeoCmmnty</NAME>
     4        <NAME>GeoCmmntyRes</NAME>
    55        <TITLE>Decedent's Community of Residence</TITLE>
    66        <GEOGRAPHY_FLAG/>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/dimension/GeoCntyRate.xml

    r24118 r24338  
    11<?xml version="1.0" encoding="ISO-8859-1"?>
    2 <!-- For Rates we think we are only doing Hawai'i Residence -->
     2
     3<!--the Geo...Rate dimensions are HI state residents only. We don't have pop estimates for out of state.
     4        The only Geo dims with population estimates are State and County.
     5        No other Geos should have rates or include out of state residents.
     6        A "data_where" parameter is used to exclude out of state residents.
     7        Rates are also calculated for RacEthDOH and RaceEthCensus. No special exclusions for those.
     8-->
    39<DIMENSION>
    4         <NAME>GeoCntyRes</NAME>  <!-- For maps choropleht to be displayed this name must match the .json file -->
     10        <NAME>GeoCnty</NAME>  <!-- For maps choropleht to be displayed this name must match the .json file -->
    511        <TITLE>Decedent's County of Residence</TITLE>
    612        <GEOGRAPHY_FLAG/>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/dimension/GeoSchRes.xml

    r24337 r24338  
    22
    33<DIMENSION>
    4         <NAME>GeoSch</NAME>
    5         <TITLE>School Complex</TITLE>
     4        <NAME>GeoSchRes</NAME>
     5        <TITLE>Decedent's School Complex of Residence</TITLE>
    66        <GEOGRAPHY_FLAG/>
    77        <PROXY_DIMENSION_NAME>GeoProxy</PROXY_DIMENSION_NAME>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/dimension/RaceDOH.xml

    r24074 r24338  
    44        <NAME>RaceDOH</NAME>
    55        <TITLE>Decedent's Race/Ethnicity (DOH)</TITLE>
    6         <!-- cannot use this if want to be able to select across categoies - need to ask Katherine <PROXY_DIMENSION_NAME>RaceEthProxy</PROXY_DIMENSION_NAME> -->
     6        <!-- Use proxy so module.xml can use unproxied dim as default - that will constrain the cat display dim to RaceDOH-->
     7        <PROXY_DIMENSION_NAME>RaceEthProxy</PROXY_DIMENSION_NAME>
    78        <VALUES>
    89                <VALUE>1<TITLE>Caucasian</TITLE><SORT_ORDER>1</SORT_ORDER></VALUE>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/dimension/StateResRate.xml

    r24074 r24338  
    11<?xml version="1.0" encoding="ISO-8859-1"?>
    22
     3<!--the Geo...Rate dimensions are HI state residents only. We don't have pop estimates for out of state.
     4        The only Geo dims with population estimates are State and County.
     5        No other Geos should have rates or include out of state residents.
     6        A "data_where" parameter is used to exclude out of state residents.
     7        Rates are also calculated for RacEthDOH and RaceEthCensus. No special exclusions for those.
     8-->
    39<DIMENSION>
    410        <NAME>StateResRate</NAME>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/parameter/GeoProxyDataWhere.xml

    r24074 r24338  
    1414                <VALUE_IF_SELECTED_DIMENSION>
    1515                        <DIMENSION_NAME>GeoProxy</DIMENSION_NAME>
    16                         <DIMENSION_VALUE>GeoCntyRes</DIMENSION_VALUE>
     16                        <DIMENSION_VALUE>GeoCntyRate</DIMENSION_VALUE>
    1717                        <PARAMETER_VALUE>Res_State_HI_N=1</PARAMETER_VALUE>
    1818                </VALUE_IF_SELECTED_DIMENSION>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/section/CauseDeath.xml

    r24305 r24338  
    4040               
    4141                <SELECTION>
    42                         <TITLE>16 Leading Causes of Death in Hawai'i</TITLE>
     42                        <TITLE>16 leading causes of death in Hawai'i</TITLE>
    4343                        <VALUE>ICDHI16</VALUE>
    4444                        <ibis:include href="../help/CauseDeathICD.xml"/>
     
    5858
    5959                <SELECTION>
    60                         <TITLE>NCHS 39 Selected Causes of Death</TITLE>
     60                        <TITLE>NCHS 39 selected causes of death</TITLE>
    6161                        <VALUE>ICDNCHS39</VALUE>
    6262                        <ibis:include href="../help/NCHSCauses.xml"/>
     
    7575
    7676                <SELECTION>
    77                         <TITLE>NCHS 113 Selected Causes of Death</TITLE>
     77                        <TITLE>NCHS 113 selected causes of death</TITLE>
    7878                        <VALUE>ICDNCHS113</VALUE>
    7979                        <ibis:include href="../help/NCHSCauses.xml"/>
     
    160160                <SELECTION>
    161161                        <VALUE>CauseDeath9</VALUE>
    162                         <TITLE>User-defined Causes (Enter ICD codes. See links on right for help.)</TITLE>
     162                        <TITLE>User-defined causes (Enter ICD codes. See links on right for help.)</TITLE>
    163163                        <ibis:include href="../help/ICDCodes.xml"/>
    164164                        <ibis:include href="../help/CusICD.xml"/>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/section/Geo.xml

    r24074 r24338  
    33<SECTION xmlns:ibis="http://www.ibisph.org">
    44        <NAME>Geo</NAME>
    5         <TITLE>GEOGRAPHIC AREA:  NOTE: Only the County or Island geographic areas will produce a map</TITLE>
     5        <TITLE>GEOGRAPHIC AREA: NOTE: Only the County or Island geographic areas will produce a map</TITLE>
    66        <DESCRIPTION>Filter by a Hawai'i geography.</DESCRIPTION>
    77
     
    2323        <SELECTIONS>
    2424                <NAME>GeoProxy</NAME>
    25                 <TITLE>Select geographic area(s) (occurence or residence). (Default is all occurences.) NOTE: the County and Island geographic areas will produce a map</TITLE>
     25                <TITLE>Select geographic area(s) (occurrence or residence). (Default is all occurrences.) NOTE: the County and Island geographic areas will produce a map</TITLE>
    2626                <DESCRIPTION>Filter by sub population group</DESCRIPTION>
    2727                <SELECTION_TYPE><SINGLE/></SELECTION_TYPE>
    2828
    2929                <SELECTION>
    30                         <TITLE>Death Occurence, State</TITLE>
     30                        <TITLE>Death occurrence, state</TITLE>
    3131                        <VALUE>StateOccur</VALUE>
    3232                        <SELECTIONS>
     
    4141                </SELECTION>
    4242                <SELECTION>
    43                         <TITLE>Death Occurrence, County</TITLE>
     43                        <TITLE>Death occurrence, county</TITLE>
    4444                        <VALUE>GeoCntyOccur</VALUE>
    4545                        <SELECTIONS>
     
    5555                </SELECTION>
    5656                <SELECTION>
    57                         <TITLE>Death Occurence, Island</TITLE>
     57                        <TITLE>Death occurrence, island</TITLE>
    5858                        <VALUE>GeoIslandOccur</VALUE>
    5959                        <SELECTIONS>
     
    7070
    7171                <SELECTION>
    72                         <TITLE>Decedent's Residence, State</TITLE>
     72                        <TITLE>Decedent's residence, state</TITLE>
    7373                        <VALUE>StateRes</VALUE>
    7474                        <SELECTIONS>
     
    8585
    8686                <SELECTION>
    87                         <TITLE>Decedent's Residence, County - HI Residents Only</TITLE>
     87                        <TITLE>Decedent's residence, county - HI residents Only</TITLE>
    8888                        <VALUE>GeoCntyRes</VALUE>
    8989                        <SELECTIONS>
     
    9999                </SELECTION>
    100100                <SELECTION>
    101                         <TITLE>Decedent's Residence, Island - HI Residents Only</TITLE>
     101                        <TITLE>Decedent's residence, Island - HI residents Only</TITLE>
    102102                        <VALUE>GeoIslandRes</VALUE>
    103103                        <SELECTIONS>
     
    113113                </SELECTION>
    114114                <SELECTION>
    115                         <TITLE>Decedent's Residence, Community - HI Residents Only</TITLE>
    116                         <VALUE>StateResCommunity</VALUE>
     115                        <TITLE>Decedent's residence, community - HI residents Only</TITLE>
     116                        <VALUE>GeoCmmntyRes</VALUE>
    117117                        <SELECTIONS>
    118118                                <SELECTION><TITLE>All communities</TITLE></SELECTION>
    119                                 <DIMENSION_NAME>StateResCommunity</DIMENSION_NAME>
     119                                <DIMENSION_NAME>GeoCmmntyRes</DIMENSION_NAME>
    120120                                <SELECTION_TYPE>
    121121                                        <LIST>
     
    127127                </SELECTION>
    128128                <SELECTION>
    129                         <TITLE>Decedent's Residence, Primary Care Service Area (PCSA) - HI Residents Only</TITLE>
     129                        <TITLE>Decedent's residence, primary care service area (PCSA) - HI residents Only</TITLE>
    130130                        <VALUE>GeoPCSARes</VALUE>
    131131                        <SELECTIONS>
     
    141141                </SELECTION>
    142142                <SELECTION>
    143                         <TITLE>Decedent's Residence, School Complex - HI Residents Only</TITLE>
    144                         <VALUE>StateResSchool</VALUE>
     143                        <TITLE>Decedent's residence, school complex - HI residents Only</TITLE>
     144                        <VALUE>GeoSchRes</VALUE>
    145145                        <SELECTIONS>
    146146                                <SELECTION><TITLE>All school complexes</TITLE></SELECTION>
    147                                 <DIMENSION_NAME>StateResSchool</DIMENSION_NAME>
     147                                <DIMENSION_NAME>GeoSchRes</DIMENSION_NAME>
    148148                                <SELECTION_TYPE>
    149149                                        <LIST>
  • adopters/hi/trunk/src/main/webapps/hhdw-content/xml/query/module/mort/section/GeoRate.xml

    r24074 r24338  
    11<?xml version="1.0" encoding="ISO-8859-1"?>
    22
     3<!--the Geo...Rate dimensions are HI state residents only. We don't have pop estimates for out of state.
     4        The only Geo dims with population estimates are State and County.
     5        No other Geos should have rates or include out of state residents.
     6        A "data_where" parameter is used to exclude out of state residents.
     7        Rates are also calculated for RacEthDOH and RaceEthCensus. No special exclusions for those.
     8-->
    39<SECTION xmlns:ibis="http://www.ibisph.org">
    410        <NAME>Geo</NAME>
     
    2834
    2935                <SELECTION>
    30                         <TITLE>Decedent's Residence, State - HI Residents Only</TITLE>
     36                        <TITLE>Decedent's residence, state - HI residents Only</TITLE>
    3137                        <VALUE>StateResRate</VALUE>
    3238                        <SELECTIONS>
     
    4147                </SELECTION>
    4248                <SELECTION>
    43                         <TITLE>Decedent's Residence, County - HI Residents Only</TITLE>
    44                         <VALUE>GeoCntyRes</VALUE>
     49                        <TITLE>Decedent's residence, county - HI residents Only</TITLE>
     50                        <VALUE>GeoCnty</VALUE>
    4551                        <SELECTIONS>
    4652                                <SELECTION><TITLE>All counties</TITLE></SELECTION>
    47                                 <DIMENSION_NAME>GeoCntyRes</DIMENSION_NAME>
     53                                <DIMENSION_NAME>GeoCnty</DIMENSION_NAME>
    4854                                <SELECTION_TYPE>
    4955                                        <LIST>
Note: See TracChangeset for help on using the changeset viewer.