.~best_data__555.twbr

<?xml version='1.0' encoding='utf-8' ?>

<!-- build 20192.19.0515.1630                               -->
<workbook source-build='2019.2.0 (20192.19.0515.1630)' source-platform='mac' version='18.1' xmlns:user='http://www.tableausoftware.com/xml/user'>
  <document-format-change-manifest>
    <AutoCreateAndUpdateDSDPhoneLayouts ignorable='true' predowngraded='true' />
    <IntuitiveSorting />
    <IntuitiveSorting_SP2 />
    <MapboxVectorStylesAndLayers />
    <SheetIdentifierTracking ignorable='true' predowngraded='true' />
    <SortTagCleanup />
    <WindowsPersistSimpleIdentifiers />
  </document-format-change-manifest>
  <preferences>
    <preference name='ui.encoding.shelf.height' value='24' />
    <preference name='ui.shelf.height' value='26' />
  </preferences>
  <datasources>
    <datasource caption='sso-location-info.csv+ (Multiple Connections)' inline='true' name='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny' version='18.1'>
      <connection class='federated'>
        <named-connections>
          <named-connection caption='sso-location-info' name='textscan.0ke9bsu0t91g5v15kj2uc0588caq'>
            <connection class='textscan' directory='/Users/sandragraham/Desktop/Datathon/data' filename='sso-location-info.csv' password='' server='' />
          </named-connection>
          <named-connection caption='sso-noloc' name='textscan.0spowrd0awdnkc1dk2l0n0dro43b'>
            <connection class='textscan' directory='/Users/sandragraham/Desktop/Datathon/data' filename='sso-noloc.csv' password='' server='' />
          </named-connection>
        </named-connections>
        <relation join='inner' type='join'>
          <clause type='join'>
            <expression op='='>
              <expression op='[sso-location-info.csv].[F1]' />
              <expression op='[sso-noloc.csv].[F1]' />
            </expression>
          </clause>
          <relation connection='textscan.0ke9bsu0t91g5v15kj2uc0588caq' name='sso-location-info.csv' table='[sso-location-info#csv]' type='table'>
            <columns character-set='UTF-8' header='yes' locale='en_US' separator=','>
              <column datatype='integer' name='F1' ordinal='0' />
              <column datatype='string' name='addresses' ordinal='1' />
              <column datatype='string' name='zip' ordinal='2' />
              <column datatype='real' name='lat' ordinal='3' />
              <column datatype='real' name='long' ordinal='4' />
              <column datatype='integer' name='short-zip' ordinal='5' />
            </columns>
          </relation>
          <relation connection='textscan.0spowrd0awdnkc1dk2l0n0dro43b' name='sso-noloc.csv' table='[sso-noloc#csv]' type='table'>
            <columns character-set='UTF-8' header='yes' locale='en_US' separator=','>
              <column datatype='integer' name='F1' ordinal='0' />
              <column datatype='date' name='report_date' ordinal='1' />
              <column datatype='integer' name='total_gallons' ordinal='2' />
              <column datatype='real' name='gallons_returned' ordinal='3' />
              <column datatype='datetime' name='spill_start' ordinal='4' />
              <column datatype='datetime' name='spill_stop' ordinal='5' />
              <column datatype='real' name='hours' ordinal='6' />
              <column datatype='string' name='cause' ordinal='7' />
              <column datatype='string' name='actions' ordinal='8' />
              <column datatype='string' name='watershed' ordinal='9' />
              <column datatype='integer' name='unit_id_1' ordinal='10' />
              <column datatype='string' name='unit_id_2' ordinal='11' />
              <column datatype='string' name='discharge_to' ordinal='12' />
              <column datatype='string' name='discharge_route' ordinal='13' />
              <column datatype='integer' name='council_district' ordinal='14' />
              <column datatype='integer' name='month' ordinal='15' />
              <column datatype='integer' name='year' ordinal='16' />
              <column datatype='integer' name='week' ordinal='17' />
              <column datatype='integer' name='edwards_zone' ordinal='18' />
              <column datatype='real' name='pipe_diameter' ordinal='19' />
              <column datatype='real' name='pipe_length' ordinal='20' />
              <column datatype='string' name='pipe_type' ordinal='21' />
              <column datatype='integer' name='installation_year' ordinal='22' />
              <column datatype='real' name='inches_no' ordinal='23' />
              <column datatype='real' name='rainfall_less_3' ordinal='24' />
              <column datatype='integer' name='num_spills_compkey' ordinal='25' />
              <column datatype='integer' name='num_spills_24mos' ordinal='26' />
              <column datatype='string' name='unit_type' ordinal='27' />
              <column datatype='string' name='asset_type' ordinal='28' />
              <column datatype='date' name='last_cleaned' ordinal='29' />
              <column datatype='real' name='response_time' ordinal='30' />
              <column datatype='date' name='response_datetime' ordinal='31' />
              <column datatype='boolean' name='public_notice' ordinal='32' />
              <column datatype='integer' name='time_int' ordinal='33' />
              <column datatype='string' name='root_cause' ordinal='34' />
              <column datatype='string' name='steps_to_prevent' ordinal='35' />
              <column datatype='string' name='spill_street_address' ordinal='36' />
              <column datatype='boolean' name='multiple_spills' ordinal='37' />
              <column datatype='integer' name='counts' ordinal='38' />
              <column datatype='real' name='months_since_cleaned' ordinal='39' />
            </columns>
          </relation>
        </relation>
        <cols>
          <map key='[F1 (sso-noloc.csv)]' value='[sso-noloc.csv].[F1]' />
          <map key='[F1]' value='[sso-location-info.csv].[F1]' />
          <map key='[actions]' value='[sso-noloc.csv].[actions]' />
          <map key='[addresses]' value='[sso-location-info.csv].[addresses]' />
          <map key='[asset_type]' value='[sso-noloc.csv].[asset_type]' />
          <map key='[cause]' value='[sso-noloc.csv].[cause]' />
          <map key='[council_district]' value='[sso-noloc.csv].[council_district]' />
          <map key='[counts]' value='[sso-noloc.csv].[counts]' />
          <map key='[discharge_route]' value='[sso-noloc.csv].[discharge_route]' />
          <map key='[discharge_to]' value='[sso-noloc.csv].[discharge_to]' />
          <map key='[edwards_zone]' value='[sso-noloc.csv].[edwards_zone]' />
          <map key='[gallons_returned]' value='[sso-noloc.csv].[gallons_returned]' />
          <map key='[hours]' value='[sso-noloc.csv].[hours]' />
          <map key='[inches_no]' value='[sso-noloc.csv].[inches_no]' />
          <map key='[installation_year]' value='[sso-noloc.csv].[installation_year]' />
          <map key='[last_cleaned]' value='[sso-noloc.csv].[last_cleaned]' />
          <map key='[lat]' value='[sso-location-info.csv].[lat]' />
          <map key='[long]' value='[sso-location-info.csv].[long]' />
          <map key='[month]' value='[sso-noloc.csv].[month]' />
          <map key='[months_since_cleaned]' value='[sso-noloc.csv].[months_since_cleaned]' />
          <map key='[multiple_spills]' value='[sso-noloc.csv].[multiple_spills]' />
          <map key='[num_spills_24mos]' value='[sso-noloc.csv].[num_spills_24mos]' />
          <map key='[num_spills_compkey]' value='[sso-noloc.csv].[num_spills_compkey]' />
          <map key='[pipe_diameter]' value='[sso-noloc.csv].[pipe_diameter]' />
          <map key='[pipe_length]' value='[sso-noloc.csv].[pipe_length]' />
          <map key='[pipe_type]' value='[sso-noloc.csv].[pipe_type]' />
          <map key='[public_notice]' value='[sso-noloc.csv].[public_notice]' />
          <map key='[rainfall_less_3]' value='[sso-noloc.csv].[rainfall_less_3]' />
          <map key='[report_date]' value='[sso-noloc.csv].[report_date]' />
          <map key='[response_datetime]' value='[sso-noloc.csv].[response_datetime]' />
          <map key='[response_time]' value='[sso-noloc.csv].[response_time]' />
          <map key='[root_cause]' value='[sso-noloc.csv].[root_cause]' />
          <map key='[short-zip]' value='[sso-location-info.csv].[short-zip]' />
          <map key='[spill_start]' value='[sso-noloc.csv].[spill_start]' />
          <map key='[spill_stop]' value='[sso-noloc.csv].[spill_stop]' />
          <map key='[spill_street_address]' value='[sso-noloc.csv].[spill_street_address]' />
          <map key='[steps_to_prevent]' value='[sso-noloc.csv].[steps_to_prevent]' />
          <map key='[time_int]' value='[sso-noloc.csv].[time_int]' />
          <map key='[total_gallons]' value='[sso-noloc.csv].[total_gallons]' />
          <map key='[unit_id_1]' value='[sso-noloc.csv].[unit_id_1]' />
          <map key='[unit_id_2]' value='[sso-noloc.csv].[unit_id_2]' />
          <map key='[unit_type]' value='[sso-noloc.csv].[unit_type]' />
          <map key='[watershed]' value='[sso-noloc.csv].[watershed]' />
          <map key='[week]' value='[sso-noloc.csv].[week]' />
          <map key='[year]' value='[sso-noloc.csv].[year]' />
          <map key='[zip]' value='[sso-location-info.csv].[zip]' />
        </cols>
        <metadata-records>
          <metadata-record class='capability'>
            <remote-name />
            <remote-type>0</remote-type>
            <parent-name>[sso-location-info.csv]</parent-name>
            <remote-alias />
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <attributes>
              <attribute datatype='string' name='character-set'>&quot;UTF-8&quot;</attribute>
              <attribute datatype='string' name='collation'>&quot;en_US&quot;</attribute>
              <attribute datatype='string' name='field-delimiter'>&quot;,&quot;</attribute>
              <attribute datatype='string' name='header-row'>&quot;true&quot;</attribute>
              <attribute datatype='string' name='locale'>&quot;en_US&quot;</attribute>
              <attribute datatype='string' name='single-char'>&quot;&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>F1</remote-name>
            <remote-type>20</remote-type>
            <local-name>[F1]</local-name>
            <parent-name>[sso-location-info.csv]</parent-name>
            <remote-alias>F1</remote-alias>
            <ordinal>0</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>addresses</remote-name>
            <remote-type>129</remote-type>
            <local-name>[addresses]</local-name>
            <parent-name>[sso-location-info.csv]</parent-name>
            <remote-alias>addresses</remote-alias>
            <ordinal>1</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>zip</remote-name>
            <remote-type>129</remote-type>
            <local-name>[zip]</local-name>
            <parent-name>[sso-location-info.csv]</parent-name>
            <remote-alias>zip</remote-alias>
            <ordinal>2</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>lat</remote-name>
            <remote-type>5</remote-type>
            <local-name>[lat]</local-name>
            <parent-name>[sso-location-info.csv]</parent-name>
            <remote-alias>lat</remote-alias>
            <ordinal>3</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>long</remote-name>
            <remote-type>5</remote-type>
            <local-name>[long]</local-name>
            <parent-name>[sso-location-info.csv]</parent-name>
            <remote-alias>long</remote-alias>
            <ordinal>4</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>short-zip</remote-name>
            <remote-type>20</remote-type>
            <local-name>[short-zip]</local-name>
            <parent-name>[sso-location-info.csv]</parent-name>
            <remote-alias>short-zip</remote-alias>
            <ordinal>5</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='capability'>
            <remote-name />
            <remote-type>0</remote-type>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias />
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <attributes>
              <attribute datatype='string' name='character-set'>&quot;UTF-8&quot;</attribute>
              <attribute datatype='string' name='collation'>&quot;en_US&quot;</attribute>
              <attribute datatype='string' name='field-delimiter'>&quot;,&quot;</attribute>
              <attribute datatype='string' name='header-row'>&quot;true&quot;</attribute>
              <attribute datatype='string' name='locale'>&quot;en_US&quot;</attribute>
              <attribute datatype='string' name='single-char'>&quot;&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>F1</remote-name>
            <remote-type>20</remote-type>
            <local-name>[F1 (sso-noloc.csv)]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>F1</remote-alias>
            <ordinal>6</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>report_date</remote-name>
            <remote-type>133</remote-type>
            <local-name>[report_date]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>report_date</remote-alias>
            <ordinal>7</ordinal>
            <local-type>date</local-type>
            <aggregation>Year</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>total_gallons</remote-name>
            <remote-type>20</remote-type>
            <local-name>[total_gallons]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>total_gallons</remote-alias>
            <ordinal>8</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>gallons_returned</remote-name>
            <remote-type>5</remote-type>
            <local-name>[gallons_returned]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>gallons_returned</remote-alias>
            <ordinal>9</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>spill_start</remote-name>
            <remote-type>135</remote-type>
            <local-name>[spill_start]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>spill_start</remote-alias>
            <ordinal>10</ordinal>
            <local-type>datetime</local-type>
            <aggregation>Year</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>spill_stop</remote-name>
            <remote-type>135</remote-type>
            <local-name>[spill_stop]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>spill_stop</remote-alias>
            <ordinal>11</ordinal>
            <local-type>datetime</local-type>
            <aggregation>Year</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>hours</remote-name>
            <remote-type>5</remote-type>
            <local-name>[hours]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>hours</remote-alias>
            <ordinal>12</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>cause</remote-name>
            <remote-type>129</remote-type>
            <local-name>[cause]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>cause</remote-alias>
            <ordinal>13</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>actions</remote-name>
            <remote-type>129</remote-type>
            <local-name>[actions]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>actions</remote-alias>
            <ordinal>14</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>watershed</remote-name>
            <remote-type>129</remote-type>
            <local-name>[watershed]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>watershed</remote-alias>
            <ordinal>15</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>unit_id_1</remote-name>
            <remote-type>20</remote-type>
            <local-name>[unit_id_1]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>unit_id_1</remote-alias>
            <ordinal>16</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>unit_id_2</remote-name>
            <remote-type>129</remote-type>
            <local-name>[unit_id_2]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>unit_id_2</remote-alias>
            <ordinal>17</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>discharge_to</remote-name>
            <remote-type>129</remote-type>
            <local-name>[discharge_to]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>discharge_to</remote-alias>
            <ordinal>18</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>discharge_route</remote-name>
            <remote-type>129</remote-type>
            <local-name>[discharge_route]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>discharge_route</remote-alias>
            <ordinal>19</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>council_district</remote-name>
            <remote-type>20</remote-type>
            <local-name>[council_district]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>council_district</remote-alias>
            <ordinal>20</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>month</remote-name>
            <remote-type>20</remote-type>
            <local-name>[month]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>month</remote-alias>
            <ordinal>21</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>year</remote-name>
            <remote-type>20</remote-type>
            <local-name>[year]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>year</remote-alias>
            <ordinal>22</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>week</remote-name>
            <remote-type>20</remote-type>
            <local-name>[week]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>week</remote-alias>
            <ordinal>23</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>edwards_zone</remote-name>
            <remote-type>20</remote-type>
            <local-name>[edwards_zone]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>edwards_zone</remote-alias>
            <ordinal>24</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>pipe_diameter</remote-name>
            <remote-type>5</remote-type>
            <local-name>[pipe_diameter]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>pipe_diameter</remote-alias>
            <ordinal>25</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>pipe_length</remote-name>
            <remote-type>5</remote-type>
            <local-name>[pipe_length]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>pipe_length</remote-alias>
            <ordinal>26</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>pipe_type</remote-name>
            <remote-type>129</remote-type>
            <local-name>[pipe_type]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>pipe_type</remote-alias>
            <ordinal>27</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>installation_year</remote-name>
            <remote-type>20</remote-type>
            <local-name>[installation_year]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>installation_year</remote-alias>
            <ordinal>28</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>inches_no</remote-name>
            <remote-type>5</remote-type>
            <local-name>[inches_no]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>inches_no</remote-alias>
            <ordinal>29</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>rainfall_less_3</remote-name>
            <remote-type>5</remote-type>
            <local-name>[rainfall_less_3]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>rainfall_less_3</remote-alias>
            <ordinal>30</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>num_spills_compkey</remote-name>
            <remote-type>20</remote-type>
            <local-name>[num_spills_compkey]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>num_spills_compkey</remote-alias>
            <ordinal>31</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>num_spills_24mos</remote-name>
            <remote-type>20</remote-type>
            <local-name>[num_spills_24mos]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>num_spills_24mos</remote-alias>
            <ordinal>32</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>unit_type</remote-name>
            <remote-type>129</remote-type>
            <local-name>[unit_type]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>unit_type</remote-alias>
            <ordinal>33</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>asset_type</remote-name>
            <remote-type>129</remote-type>
            <local-name>[asset_type]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>asset_type</remote-alias>
            <ordinal>34</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>last_cleaned</remote-name>
            <remote-type>133</remote-type>
            <local-name>[last_cleaned]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>last_cleaned</remote-alias>
            <ordinal>35</ordinal>
            <local-type>date</local-type>
            <aggregation>Year</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>response_time</remote-name>
            <remote-type>5</remote-type>
            <local-name>[response_time]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>response_time</remote-alias>
            <ordinal>36</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>response_datetime</remote-name>
            <remote-type>133</remote-type>
            <local-name>[response_datetime]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>response_datetime</remote-alias>
            <ordinal>37</ordinal>
            <local-type>date</local-type>
            <aggregation>Year</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>public_notice</remote-name>
            <remote-type>11</remote-type>
            <local-name>[public_notice]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>public_notice</remote-alias>
            <ordinal>38</ordinal>
            <local-type>boolean</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>time_int</remote-name>
            <remote-type>20</remote-type>
            <local-name>[time_int]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>time_int</remote-alias>
            <ordinal>39</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>root_cause</remote-name>
            <remote-type>129</remote-type>
            <local-name>[root_cause]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>root_cause</remote-alias>
            <ordinal>40</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>steps_to_prevent</remote-name>
            <remote-type>129</remote-type>
            <local-name>[steps_to_prevent]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>steps_to_prevent</remote-alias>
            <ordinal>41</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>spill_street_address</remote-name>
            <remote-type>129</remote-type>
            <local-name>[spill_street_address]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>spill_street_address</remote-alias>
            <ordinal>42</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>multiple_spills</remote-name>
            <remote-type>11</remote-type>
            <local-name>[multiple_spills]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>multiple_spills</remote-alias>
            <ordinal>43</ordinal>
            <local-type>boolean</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>counts</remote-name>
            <remote-type>20</remote-type>
            <local-name>[counts]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>counts</remote-alias>
            <ordinal>44</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>months_since_cleaned</remote-name>
            <remote-type>5</remote-type>
            <local-name>[months_since_cleaned]</local-name>
            <parent-name>[sso-noloc.csv]</parent-name>
            <remote-alias>months_since_cleaned</remote-alias>
            <ordinal>45</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
        </metadata-records>
      </connection>
      <aliases enabled='yes' />
      <column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
        <calculation class='tableau' formula='1' />
      </column>
      <column caption='Actions' datatype='string' name='[actions]' role='dimension' type='nominal' />
      <column caption='Addresses' datatype='string' name='[addresses]' role='dimension' type='nominal' />
      <column caption='Asset Type' datatype='string' name='[asset_type]' role='dimension' type='nominal' />
      <column caption='Cause' datatype='string' name='[cause]' role='dimension' type='nominal'>
        <aliases>
          <alias key='&quot;i/i&quot;' value='inflow and infiltraion' />
        </aliases>
      </column>
      <column caption='Council District' datatype='integer' name='[council_district]' role='measure' type='quantitative' />
      <column caption='Counts' datatype='integer' name='[counts]' role='measure' type='quantitative' />
      <column caption='Discharge Route' datatype='string' name='[discharge_route]' role='dimension' type='nominal' />
      <column caption='Discharge To' datatype='string' name='[discharge_to]' role='dimension' type='nominal' />
      <column caption='Edwards Zone' datatype='integer' name='[edwards_zone]' role='measure' type='quantitative' />
      <column caption='Gallons Returned' datatype='real' name='[gallons_returned]' role='measure' type='quantitative' />
      <column caption='Hours' datatype='real' name='[hours]' role='measure' type='quantitative' />
      <column caption='Inches No' datatype='real' name='[inches_no]' role='measure' type='quantitative' />
      <column caption='Installation Year' datatype='integer' name='[installation_year]' role='dimension' type='quantitative' />
      <column caption='Last Cleaned' datatype='date' name='[last_cleaned]' role='dimension' type='ordinal' />
      <column aggregation='Avg' caption='Lat' datatype='real' name='[lat]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
      <column aggregation='Avg' caption='Long' datatype='real' name='[long]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
      <column caption='Month' datatype='integer' name='[month]' role='dimension' type='quantitative' />
      <column caption='Months Since Cleaned' datatype='real' name='[months_since_cleaned]' role='measure' type='quantitative' />
      <column caption='Multiple Spills' datatype='boolean' name='[multiple_spills]' role='dimension' type='nominal' />
      <column caption='Num Spills 24Mos' datatype='integer' name='[num_spills_24mos]' role='measure' type='quantitative' />
      <column caption='Num Spills Compkey' datatype='integer' name='[num_spills_compkey]' role='measure' type='quantitative' />
      <column caption='Pipe Diameter' datatype='real' name='[pipe_diameter]' role='measure' type='quantitative' />
      <column caption='Pipe Length' datatype='real' name='[pipe_length]' role='measure' type='quantitative' />
      <column caption='Pipe Type' datatype='string' name='[pipe_type]' role='dimension' type='nominal' />
      <column caption='Public Notice' datatype='boolean' name='[public_notice]' role='dimension' type='nominal' />
      <column caption='Rainfall Less 3' datatype='real' name='[rainfall_less_3]' role='measure' type='quantitative' />
      <column caption='Report Date' datatype='date' name='[report_date]' role='dimension' type='ordinal' />
      <column caption='Response Datetime' datatype='date' name='[response_datetime]' role='dimension' type='ordinal' />
      <column caption='Response Time' datatype='real' name='[response_time]' role='measure' type='quantitative' />
      <column caption='Root Cause' datatype='string' name='[root_cause]' role='dimension' type='nominal'>
        <aliases>
          <alias key='&quot;by pass pump leak&quot;' value='bypass' />
        </aliases>
      </column>
      <column caption='Spill Start' datatype='datetime' name='[spill_start]' role='dimension' type='ordinal' />
      <column caption='Spill Stop' datatype='datetime' name='[spill_stop]' role='dimension' type='ordinal' />
      <column caption='Spill Street Address' datatype='string' name='[spill_street_address]' role='dimension' type='nominal' />
      <column caption='Steps To Prevent' datatype='string' name='[steps_to_prevent]' role='dimension' type='nominal' />
      <column caption='Time Int' datatype='integer' name='[time_int]' role='measure' type='quantitative' />
      <column caption='Total Gallons' datatype='integer' name='[total_gallons]' role='measure' type='quantitative' />
      <column caption='Unit Id 1' datatype='integer' name='[unit_id_1]' role='dimension' type='ordinal' />
      <column caption='Unit Id 2' datatype='string' name='[unit_id_2]' role='dimension' type='nominal' />
      <column caption='Unit Type' datatype='string' name='[unit_type]' role='dimension' type='nominal' />
      <column caption='Sewershed' datatype='string' name='[watershed]' role='dimension' type='nominal' />
      <column caption='Week' datatype='integer' name='[week]' role='dimension' type='quantitative' />
      <column caption='Year' datatype='integer' name='[year]' role='dimension' type='quantitative' />
      <column caption='Zip' datatype='string' name='[zip]' role='dimension' semantic-role='[ZipCode].[Name]' type='nominal' />
      <layout dim-ordering='alphabetic' dim-percentage='0.525849' measure-ordering='alphabetic' measure-percentage='0.474151' rowDisplayCount='10000' show-structure='true' />
      <semantic-values>
        <semantic-value key='[Country].[Name]' value='&quot;United States&quot;' />
      </semantic-values>
    </datasource>
    <datasource caption='pipe_2' inline='true' name='federated.1meiot20rlt53v14dcxeb1fsiqdw' version='18.1'>
      <connection class='federated'>
        <named-connections>
          <named-connection caption='pipe_2' name='textscan.1h2jh8f1nd4o111gvdvfc18djeee'>
            <connection class='textscan' directory='/Users/sandragraham/Desktop/Datathon/data' filename='pipe_2.csv' password='' server='' />
          </named-connection>
        </named-connections>
        <relation connection='textscan.1h2jh8f1nd4o111gvdvfc18djeee' name='pipe_2.csv' table='[pipe_2#csv]' type='table'>
          <columns character-set='UTF-8' header='yes' locale='en_US' separator=','>
            <column datatype='integer' name='percent_flow' ordinal='0' />
            <column datatype='integer' name='days' ordinal='1' />
          </columns>
        </relation>
        <metadata-records>
          <metadata-record class='capability'>
            <remote-name />
            <remote-type>0</remote-type>
            <parent-name>[pipe_2.csv]</parent-name>
            <remote-alias />
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <attributes>
              <attribute datatype='string' name='character-set'>&quot;UTF-8&quot;</attribute>
              <attribute datatype='string' name='collation'>&quot;en_US&quot;</attribute>
              <attribute datatype='string' name='field-delimiter'>&quot;,&quot;</attribute>
              <attribute datatype='string' name='header-row'>&quot;true&quot;</attribute>
              <attribute datatype='string' name='locale'>&quot;en_US&quot;</attribute>
              <attribute datatype='string' name='single-char'>&quot;&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>percent_flow</remote-name>
            <remote-type>20</remote-type>
            <local-name>[percent_flow]</local-name>
            <parent-name>[pipe_2.csv]</parent-name>
            <remote-alias>percent_flow</remote-alias>
            <ordinal>0</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>days</remote-name>
            <remote-type>20</remote-type>
            <local-name>[days]</local-name>
            <parent-name>[pipe_2.csv]</parent-name>
            <remote-alias>days</remote-alias>
            <ordinal>1</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
        </metadata-records>
      </connection>
      <aliases enabled='yes' />
      <column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
        <calculation class='tableau' formula='1' />
      </column>
      <column caption='Days' datatype='integer' name='[days]' role='measure' type='quantitative' />
      <column caption='Percent Flow' datatype='integer' name='[percent_flow]' role='measure' type='quantitative' />
      <layout dim-ordering='alphabetic' dim-percentage='0.461047' measure-ordering='alphabetic' measure-percentage='0.538953' show-structure='true' />
      <semantic-values>
        <semantic-value key='[Country].[Name]' value='&quot;United States&quot;' />
      </semantic-values>
    </datasource>
    <datasource caption='Sheet1 (sso_most_frequent_lat_long)' inline='true' name='federated.0z4t00e1mynjhf199g7rp0l6qucy' version='18.1'>
      <connection class='federated'>
        <named-connections>
          <named-connection caption='sso_most_frequent_lat_long' name='excel-direct.1g2bj630grcqap1e7qdgu0km7v3y'>
            <connection class='excel-direct' cleaning='no' compat='no' dataRefreshTime='' filename='/Users/sandragraham/Desktop/Datathon/data/sso_most_frequent_lat_long.xlsx' interpretationMode='0' password='' server='' validate='no' />
          </named-connection>
        </named-connections>
        <relation connection='excel-direct.1g2bj630grcqap1e7qdgu0km7v3y' name='Sheet1' table='[Sheet1$]' type='table'>
          <columns gridOrigin='A1:L14:no:A1:L14:0' header='yes' outcome='2'>
            <column datatype='string' name='address' ordinal='0' />
            <column datatype='real' name='latitude' ordinal='1' />
            <column datatype='real' name='longitude' ordinal='2' />
            <column datatype='integer' name='number_of_sso' ordinal='3' />
            <column datatype='string' name='primary_root_cause' ordinal='4' />
            <column datatype='string' name='prim_perc' ordinal='5' />
            <column datatype='string' name='sec_root_cause' ordinal='6' />
            <column datatype='string' name='sec_perc' ordinal='7' />
            <column datatype='string' name='primary_cause' ordinal='8' />
            <column datatype='string' name='prim_cause_perc' ordinal='9' />
            <column datatype='string' name='sec_cause' ordinal='10' />
            <column datatype='string' name='sec_cause_perc' ordinal='11' />
          </columns>
        </relation>
        <metadata-records>
          <metadata-record class='column'>
            <remote-name>address</remote-name>
            <remote-type>130</remote-type>
            <local-name>[address]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>address</remote-alias>
            <ordinal>0</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>latitude</remote-name>
            <remote-type>5</remote-type>
            <local-name>[latitude]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>latitude</remote-alias>
            <ordinal>1</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <precision>15</precision>
            <contains-null>true</contains-null>
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;R8&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>longitude</remote-name>
            <remote-type>5</remote-type>
            <local-name>[longitude]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>longitude</remote-alias>
            <ordinal>2</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <precision>15</precision>
            <contains-null>true</contains-null>
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;R8&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>number_of_sso</remote-name>
            <remote-type>20</remote-type>
            <local-name>[number_of_sso]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>number_of_sso</remote-alias>
            <ordinal>3</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;I8&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>primary_root_cause</remote-name>
            <remote-type>130</remote-type>
            <local-name>[primary_root_cause]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>primary_root_cause</remote-alias>
            <ordinal>4</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>prim_perc</remote-name>
            <remote-type>130</remote-type>
            <local-name>[prim_perc]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>prim_perc</remote-alias>
            <ordinal>5</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_root_cause</remote-name>
            <remote-type>130</remote-type>
            <local-name>[sec_root_cause]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>sec_root_cause</remote-alias>
            <ordinal>6</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_perc</remote-name>
            <remote-type>130</remote-type>
            <local-name>[sec_perc]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>sec_perc</remote-alias>
            <ordinal>7</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>primary_cause</remote-name>
            <remote-type>130</remote-type>
            <local-name>[primary_cause]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>primary_cause</remote-alias>
            <ordinal>8</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>prim_cause_perc</remote-name>
            <remote-type>130</remote-type>
            <local-name>[prim_cause_perc]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>prim_cause_perc</remote-alias>
            <ordinal>9</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_cause</remote-name>
            <remote-type>130</remote-type>
            <local-name>[sec_cause]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>sec_cause</remote-alias>
            <ordinal>10</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_cause_perc</remote-name>
            <remote-type>130</remote-type>
            <local-name>[sec_cause_perc]</local-name>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias>sec_cause_perc</remote-alias>
            <ordinal>11</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <collation flag='1' name='LEN_RUS_S2' />
            <attributes>
              <attribute datatype='string' name='DebugRemoteType'>&quot;WSTR&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='capability'>
            <remote-name />
            <remote-type>0</remote-type>
            <parent-name>[Sheet1]</parent-name>
            <remote-alias />
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <attributes>
              <attribute datatype='integer' name='context'>0</attribute>
              <attribute datatype='string' name='gridOrigin'>&quot;A1:L14:no:A1:L14:0&quot;</attribute>
              <attribute datatype='boolean' name='header'>true</attribute>
              <attribute datatype='integer' name='outcome'>2</attribute>
            </attributes>
          </metadata-record>
        </metadata-records>
      </connection>
      <aliases enabled='yes' />
      <column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
        <calculation class='tableau' formula='1' />
      </column>
      <column caption='Address' datatype='string' name='[address]' role='dimension' type='nominal' />
      <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
      <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
      <column caption='Number Of Sso' datatype='integer' name='[number_of_sso]' role='measure' type='quantitative' />
      <layout dim-ordering='alphabetic' dim-percentage='0.568327' measure-ordering='alphabetic' measure-percentage='0.431673' show-structure='true' />
      <semantic-values>
        <semantic-value key='[Country].[Name]' value='&quot;United States&quot;' />
      </semantic-values>
    </datasource>
    <datasource caption='most_gallons' inline='true' name='federated.0gv4ky81v0fz3r12lfxyn0fepy1v' version='18.1'>
      <connection class='federated'>
        <named-connections>
          <named-connection caption='most_gallons' name='textscan.1vhlyoz0xduv7q1apdkwu0bjsblt'>
            <connection class='textscan' directory='/Users/sandragraham/Desktop/Datathon/data' filename='most_gallons.csv' password='' server='' />
          </named-connection>
        </named-connections>
        <relation connection='textscan.1vhlyoz0xduv7q1apdkwu0bjsblt' name='most_gallons.csv' table='[most_gallons#csv]' type='table'>
          <columns character-set='UTF-8' header='yes' locale='en_US' separator=','>
            <column datatype='string' name='spill_street_address' ordinal='0' />
            <column datatype='integer' name='total_gallons' ordinal='1' />
            <column datatype='real' name='latitude' ordinal='2' />
            <column datatype='real' name='longitude' ordinal='3' />
            <column datatype='integer' name='total_sso' ordinal='4' />
            <column datatype='string' name='primary_root_cause' ordinal='5' />
            <column datatype='integer' name='prim_root_cause_count' ordinal='6' />
            <column datatype='string' name='prim_perc' ordinal='7' />
            <column datatype='string' name='sec_root_cause' ordinal='8' />
            <column datatype='integer' name='sec_root_cause_count' ordinal='9' />
            <column datatype='string' name='sec_perc' ordinal='10' />
            <column datatype='string' name='primary_cause' ordinal='11' />
            <column datatype='integer' name='prim_cause_count' ordinal='12' />
            <column datatype='string' name='prim_cause_perc' ordinal='13' />
            <column datatype='string' name='sec_cause' ordinal='14' />
            <column datatype='string' name='sec_cause_perc' ordinal='15' />
            <column datatype='real' name='sec_cause_perc 1' ordinal='16' />
          </columns>
        </relation>
        <metadata-records>
          <metadata-record class='capability'>
            <remote-name />
            <remote-type>0</remote-type>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias />
            <aggregation>Count</aggregation>
            <contains-null>true</contains-null>
            <attributes>
              <attribute datatype='string' name='character-set'>&quot;UTF-8&quot;</attribute>
              <attribute datatype='string' name='collation'>&quot;en_US&quot;</attribute>
              <attribute datatype='string' name='field-delimiter'>&quot;,&quot;</attribute>
              <attribute datatype='string' name='header-row'>&quot;true&quot;</attribute>
              <attribute datatype='string' name='locale'>&quot;en_US&quot;</attribute>
              <attribute datatype='string' name='single-char'>&quot;&quot;</attribute>
            </attributes>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>spill_street_address</remote-name>
            <remote-type>129</remote-type>
            <local-name>[spill_street_address]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>spill_street_address</remote-alias>
            <ordinal>0</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>total_gallons</remote-name>
            <remote-type>20</remote-type>
            <local-name>[total_gallons]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>total_gallons</remote-alias>
            <ordinal>1</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>latitude</remote-name>
            <remote-type>5</remote-type>
            <local-name>[latitude]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>latitude</remote-alias>
            <ordinal>2</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>longitude</remote-name>
            <remote-type>5</remote-type>
            <local-name>[longitude]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>longitude</remote-alias>
            <ordinal>3</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>total_sso</remote-name>
            <remote-type>20</remote-type>
            <local-name>[total_sso]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>total_sso</remote-alias>
            <ordinal>4</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>primary_root_cause</remote-name>
            <remote-type>129</remote-type>
            <local-name>[primary_root_cause]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>primary_root_cause</remote-alias>
            <ordinal>5</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>prim_root_cause_count</remote-name>
            <remote-type>20</remote-type>
            <local-name>[prim_root_cause_count]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>prim_root_cause_count</remote-alias>
            <ordinal>6</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>prim_perc</remote-name>
            <remote-type>129</remote-type>
            <local-name>[prim_perc]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>prim_perc</remote-alias>
            <ordinal>7</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_root_cause</remote-name>
            <remote-type>129</remote-type>
            <local-name>[sec_root_cause]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>sec_root_cause</remote-alias>
            <ordinal>8</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_root_cause_count</remote-name>
            <remote-type>20</remote-type>
            <local-name>[sec_root_cause_count]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>sec_root_cause_count</remote-alias>
            <ordinal>9</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_perc</remote-name>
            <remote-type>129</remote-type>
            <local-name>[sec_perc]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>sec_perc</remote-alias>
            <ordinal>10</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>primary_cause</remote-name>
            <remote-type>129</remote-type>
            <local-name>[primary_cause]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>primary_cause</remote-alias>
            <ordinal>11</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>prim_cause_count</remote-name>
            <remote-type>20</remote-type>
            <local-name>[prim_cause_count]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>prim_cause_count</remote-alias>
            <ordinal>12</ordinal>
            <local-type>integer</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>prim_cause_perc</remote-name>
            <remote-type>129</remote-type>
            <local-name>[prim_cause_perc]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>prim_cause_perc</remote-alias>
            <ordinal>13</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_cause</remote-name>
            <remote-type>129</remote-type>
            <local-name>[sec_cause]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>sec_cause</remote-alias>
            <ordinal>14</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_cause_perc</remote-name>
            <remote-type>129</remote-type>
            <local-name>[sec_cause_perc]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>sec_cause_perc</remote-alias>
            <ordinal>15</ordinal>
            <local-type>string</local-type>
            <aggregation>Count</aggregation>
            <scale>1</scale>
            <width>1073741823</width>
            <contains-null>true</contains-null>
            <collation flag='0' name='LEN_RUS' />
          </metadata-record>
          <metadata-record class='column'>
            <remote-name>sec_cause_perc 1</remote-name>
            <remote-type>5</remote-type>
            <local-name>[sec_cause_perc 1]</local-name>
            <parent-name>[most_gallons.csv]</parent-name>
            <remote-alias>sec_cause_perc 1</remote-alias>
            <ordinal>16</ordinal>
            <local-type>real</local-type>
            <aggregation>Sum</aggregation>
            <contains-null>true</contains-null>
          </metadata-record>
        </metadata-records>
      </connection>
      <aliases enabled='yes' />
      <column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
        <calculation class='tableau' formula='1' />
      </column>
      <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
      <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
      <column caption='Spill Street Address' datatype='string' name='[spill_street_address]' role='dimension' type='nominal' />
      <column caption='Total Gallons' datatype='integer' name='[total_gallons]' role='measure' type='quantitative' />
      <layout dim-ordering='alphabetic' dim-percentage='0.500639' measure-ordering='alphabetic' measure-percentage='0.499361' show-structure='true' />
      <semantic-values>
        <semantic-value key='[Country].[Name]' value='&quot;United States&quot;' />
      </semantic-values>
    </datasource>
  </datasources>
  <mapsources>
    <mapsource name='Tableau' />
  </mapsources>
  <worksheets>
    <worksheet name='CauseByCnt'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontalignment='1' fontcolor='#000000' fontsize='32'>Top Five Causes by Frequency</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='sso-location-info.csv+ (Multiple Connections)' name='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny' />
          </datasources>
          <datasource-dependencies datasource='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny'>
            <column datatype='integer' name='[F1]' role='measure' type='quantitative' />
            <column caption='Cause' datatype='string' name='[cause]' role='dimension' type='nominal'>
              <aliases>
                <alias key='&quot;i/i&quot;' value='inflow and infiltraion' />
              </aliases>
            </column>
            <column-instance column='[F1]' derivation='Count' name='[cnt:F1:qk]' pivot='key' type='quantitative' />
            <column-instance column='[cause]' derivation='None' name='[none:cause:nk]' pivot='key' type='nominal' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]'>
            <groupfilter count='5' end='top' function='end' units='records' user:ui-marker='end' user:ui-top-by-field='true'>
              <groupfilter direction='DESC' expression='COUNT([cause])' function='order' user:ui-marker='order'>
                <groupfilter function='level-members' level='[none:cause:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
              </groupfilter>
            </groupfilter>
          </filter>
          <shelf-sorts>
            <shelf-sort-v2 dimension-to-sort='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' direction='DESC' is-on-innermost-dimension='true' measure-to-sort-by='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' shelf='rows' />
          </shelf-sorts>
          <slices>
            <column>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]</column>
          </slices>
          <aggregation value='true' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' field-type='quantitative' major-origin='0' major-spacing='300' scope='cols' type='space' />
            <format attr='title' class='0' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' scope='cols' value='Count of SSOs' />
          </style-rule>
          <style-rule element='label'>
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' value='22' />
            <format attr='font-weight' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' value='bold' />
            <format attr='color' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' value='#000000' />
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' value='22' />
            <format attr='font-weight' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' value='bold' />
            <format attr='color' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' value='#000000' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
          </pane>
        </panes>
        <rows>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]</rows>
        <cols>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]</cols>
      </table>
      <simple-id uuid='{B2BE8862-79EA-442D-A9D9-F1FD22EE1CBE}' />
    </worksheet>
    <worksheet name='CauseByGal'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontcolor='#000000' fontsize='32'>Cause by Gallons Spilled</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='sso-location-info.csv+ (Multiple Connections)' name='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny' />
          </datasources>
          <datasource-dependencies datasource='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny'>
            <column caption='Cause' datatype='string' name='[cause]' role='dimension' type='nominal'>
              <aliases>
                <alias key='&quot;i/i&quot;' value='inflow and infiltraion' />
              </aliases>
            </column>
            <column-instance column='[cause]' derivation='None' name='[none:cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[total_gallons]' derivation='Sum' name='[sum:total_gallons:qk]' pivot='key' type='quantitative' />
            <column caption='Total Gallons' datatype='integer' name='[total_gallons]' role='measure' type='quantitative' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]'>
            <groupfilter count='5' end='top' function='end' units='records' user:ui-marker='end' user:ui-top-by-field='true'>
              <groupfilter direction='DESC' expression='SUM([total_gallons])' function='order' user:ui-marker='order'>
                <groupfilter function='level-members' level='[none:cause:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
              </groupfilter>
            </groupfilter>
          </filter>
          <shelf-sorts>
            <shelf-sort-v2 dimension-to-sort='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' direction='DESC' is-on-innermost-dimension='true' measure-to-sort-by='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' shelf='rows' />
          </shelf-sorts>
          <slices>
            <column>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]</column>
          </slices>
          <aggregation value='true' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' field-type='quantitative' major-origin='0' major-spacing='20000000' scope='cols' type='space' />
          </style-rule>
          <style-rule element='header'>
            <format attr='width' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' value='156' />
          </style-rule>
          <style-rule element='label'>
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' value='22' />
            <format attr='color' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' value='#000000' />
            <format attr='font-weight' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]' value='bold' />
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' value='22' />
            <format attr='font-weight' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' value='bold' />
            <format attr='color' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' value='#000000' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
          </pane>
        </panes>
        <rows>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:cause:nk]</rows>
        <cols>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]</cols>
      </table>
      <simple-id uuid='{0CE3B37A-70DC-4E16-A916-F8C375EA38CD}' />
    </worksheet>
    <worksheet name='Freq Holbrook'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontcolor='#000000' fontsize='32'>Holbrook Needs Attention</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='Sheet1 (sso_most_frequent_lat_long)' name='federated.0z4t00e1mynjhf199g7rp0l6qucy' />
          </datasources>
          <mapsources>
            <mapsource name='Tableau' />
          </mapsources>
          <datasource-dependencies datasource='federated.0z4t00e1mynjhf199g7rp0l6qucy'>
            <column caption='Address' datatype='string' name='[address]' role='dimension' type='nominal' />
            <column-instance column='[prim_cause_perc]' derivation='Attribute' name='[attr:prim_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[prim_perc]' derivation='Attribute' name='[attr:prim_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='Attribute' name='[attr:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='Attribute' name='[attr:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause]' derivation='Attribute' name='[attr:sec_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause_perc]' derivation='Attribute' name='[attr:sec_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_perc]' derivation='Attribute' name='[attr:sec_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_root_cause]' derivation='Attribute' name='[attr:sec_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[latitude]' derivation='Avg' name='[avg:latitude:qk]' pivot='key' type='quantitative' />
            <column-instance column='[longitude]' derivation='Avg' name='[avg:longitude:qk]' pivot='key' type='quantitative' />
            <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
            <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
            <column-instance column='[address]' derivation='None' name='[none:address:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='None' name='[none:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='None' name='[none:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column caption='Number Of Sso' datatype='integer' name='[number_of_sso]' role='measure' type='quantitative' />
            <column datatype='string' name='[prim_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[prim_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_root_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_root_cause]' role='dimension' type='nominal' />
            <column-instance column='[number_of_sso]' derivation='Sum' name='[sum:number_of_sso:qk]' pivot='key' type='quantitative' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]'>
            <groupfilter function='level-members' level='[none:address:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]'>
            <groupfilter function='member' level='[none:primary_cause:nk]' member='&quot;I/I&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]'>
            <groupfilter function='member' level='[none:primary_root_cause:nk]' member='&quot;RAIN EVENT&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <slices>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]</column>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]</column>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]</column>
          </slices>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]' field-type='quantitative' max='-10954219.324775562' min='-10956440.34816505' projection='EPSG:3857' range-type='fixed' scope='cols' type='space' />
            <encoding attr='space' class='0' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]' field-type='quantitative' max='3438209.3444762006' min='3436624.0273307418' projection='EPSG:3857' range-type='fixed' scope='rows' type='space' />
          </style-rule>
          <style-rule element='mark'>
            <encoding attr='color' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' palette='red_10_0' type='interpolated' />
            <encoding attr='size' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' field-type='quantitative' max-size='1' min-size='0' type='quantsize' />
          </style-rule>
          <style-rule element='legend-title-text'>
            <format attr='color' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' value='Number Of SSOs'>
              <formatted-text>
                <run>Number Of SSOs</run>
              </formatted-text>
            </format>
          </style-rule>
          <style-rule element='map-layer'>
            <format attr='enabled' id='building' value='true' />
            <format attr='enabled' id='building-line' value='true' />
            <format attr='enabled' id='place-suburb' value='true' />
            <format attr='enabled' id='place-neighborhood' value='true' />
            <format attr='enabled' id='poi-minor-secondary' value='true' />
            <format attr='enabled' id='poi-minor-primary' value='true' />
            <format attr='enabled' id='poi-main-monuments' value='true' />
            <format attr='enabled' id='poi-main-cemetery' value='true' />
            <format attr='enabled' id='poi-main-greenspace' value='true' />
            <format attr='enabled' id='poi-main-primary' value='true' />
            <format attr='enabled' id='poi-main-peaks' value='true' />
            <format attr='enabled' id='poi-rail' value='true' />
            <format attr='enabled' id='airport-label' value='true' />
            <format attr='enabled' id='place-village' value='true' />
            <format attr='enabled' id='place-town' value='true' />
            <format attr='enabled' id='place-islands' value='true' />
            <format attr='enabled' id='place-city-sm' value='true' />
            <format attr='enabled' id='place-city-md-s' value='true' />
            <format attr='enabled' id='place-city-md-n' value='true' />
            <format attr='enabled' id='place-city-lg-s' value='true' />
            <format attr='enabled' id='place-city-lg-n' value='true' />
            <format attr='enabled' id='place-capital-s' value='true' />
            <format attr='enabled' id='place-capital-n' value='true' />
            <format attr='enabled' id='marine-label-sm-ln' value='true' />
            <format attr='enabled' id='marine-label-sm-pt' value='true' />
            <format attr='enabled' id='marine-label-md-ln' value='true' />
            <format attr='enabled' id='marine-label-md-pt' value='true' />
            <format attr='enabled' id='marine-label-lg-ln' value='true' />
            <format attr='enabled' id='marine-label-lg-pt' value='true' />
            <format attr='enabled' id='water-label' value='true' />
            <format attr='enabled' id='Zip Code Labels' value='true' />
            <format attr='enabled' id='Zip Code Boundaries' value='true' />
            <format attr='enabled' id='admin-2-label' value='true' />
            <format attr='enabled' id='admin-2-boundaries-bg' value='true' />
            <format attr='enabled' id='admin-2-boundaries' value='true' />
            <format attr='enabled' id='admin-1-label-9th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-8th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-7th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-6th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-1st-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-3rd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-2nd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute-sub' value='false' />
            <format attr='enabled' id='admin-0-boundaries-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents' value='false' />
            <format attr='enabled' id='admin1-water-lines-usa-tableau' value='false' />
            <format attr='enabled' id='9-dash-line-casing' value='false' />
            <format attr='enabled' id='9-dash-line' value='false' />
            <format attr='enabled' id='admin-0-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute' value='false' />
            <format attr='enabled' id='tunnel-service-link-track-case' value='true' />
            <format attr='enabled' id='tunnel-street_limited-case' value='true' />
            <format attr='enabled' id='tunnel-street-case' value='true' />
            <format attr='enabled' id='tunnel-secondary-tertiary-case' value='true' />
            <format attr='enabled' id='tunnel-primary-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link-case' value='true' />
            <format attr='enabled' id='tunnel-motorway_link-case' value='true' />
            <format attr='enabled' id='tunnel-trunk-case' value='true' />
            <format attr='enabled' id='tunnel-motorway-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link' value='true' />
            <format attr='enabled' id='tunnel-motorway_link' value='true' />
            <format attr='enabled' id='tunnel-service-link-track' value='true' />
            <format attr='enabled' id='tunnel-street_limited' value='true' />
            <format attr='enabled' id='tunnel-street' value='true' />
            <format attr='enabled' id='tunnel-tertiary' value='true' />
            <format attr='enabled' id='tunnel-secondary' value='true' />
            <format attr='enabled' id='tunnel-primary' value='true' />
            <format attr='enabled' id='tunnel-trunk' value='true' />
            <format attr='enabled' id='tunnel-motorway' value='true' />
            <format attr='enabled' id='road-street-low' value='true' />
            <format attr='enabled' id='road-street_limited-low' value='true' />
            <format attr='enabled' id='road-pedestrian-case' value='true' />
            <format attr='enabled' id='road-service-link-track-case' value='true' />
            <format attr='enabled' id='road-street_limited-case' value='true' />
            <format attr='enabled' id='road-street-case' value='true' />
            <format attr='enabled' id='road-tertiary-case' value='true' />
            <format attr='enabled' id='road-secondary-case' value='true' />
            <format attr='enabled' id='road-primary-case' value='true' />
            <format attr='enabled' id='road-motorway_link-case' value='true' />
            <format attr='enabled' id='road-trunk_link-case' value='true' />
            <format attr='enabled' id='road-trunk-case' value='true' />
            <format attr='enabled' id='road-motorway-case' value='true' />
            <format attr='enabled' id='road-trunk_link' value='true' />
            <format attr='enabled' id='road-motorway_link' value='true' />
            <format attr='enabled' id='road-path' value='true' />
            <format attr='enabled' id='road-pedestrian' value='true' />
            <format attr='enabled' id='road-polygon' value='true' />
            <format attr='enabled' id='road-service-link-track' value='true' />
            <format attr='enabled' id='road-street_limited' value='true' />
            <format attr='enabled' id='road-street' value='true' />
            <format attr='enabled' id='road-tertiary' value='true' />
            <format attr='enabled' id='road-secondary' value='true' />
            <format attr='enabled' id='road-primary' value='true' />
            <format attr='enabled' id='road-trunk' value='true' />
            <format attr='enabled' id='road-motorway' value='true' />
            <format attr='enabled' id='road-rail' value='true' />
            <format attr='enabled' id='road-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-street-low' value='true' />
            <format attr='enabled' id='bridge-street_limited-low' value='true' />
            <format attr='enabled' id='bridge-pedestrian-case' value='true' />
            <format attr='enabled' id='bridge-service-link-track-case' value='true' />
            <format attr='enabled' id='bridge-street_limited-case' value='true' />
            <format attr='enabled' id='bridge-street-case' value='true' />
            <format attr='enabled' id='bridge-tertiary-case' value='true' />
            <format attr='enabled' id='bridge-secondary-case' value='true' />
            <format attr='enabled' id='bridge-primary-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-case' value='true' />
            <format attr='enabled' id='bridge-trunk-case' value='true' />
            <format attr='enabled' id='bridge-motorway-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link' value='true' />
            <format attr='enabled' id='bridge-motorway_link' value='true' />
            <format attr='enabled' id='bridge-path' value='true' />
            <format attr='enabled' id='bridge-pedestrian' value='true' />
            <format attr='enabled' id='bridge-service-link-track' value='true' />
            <format attr='enabled' id='bridge-street_limited' value='true' />
            <format attr='enabled' id='bridge-street' value='true' />
            <format attr='enabled' id='bridge-tertiary' value='true' />
            <format attr='enabled' id='bridge-secondary' value='true' />
            <format attr='enabled' id='bridge-primary' value='true' />
            <format attr='enabled' id='bridge-trunk' value='true' />
            <format attr='enabled' id='bridge-motorway' value='true' />
            <format attr='enabled' id='bridge-rail' value='true' />
            <format attr='enabled' id='bridge-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2' value='true' />
            <format attr='enabled' id='bridge-trunk-2' value='true' />
            <format attr='enabled' id='bridge-motorway-2' value='true' />
            <format attr='enabled' id='road-shields-2-white' value='true' />
            <format attr='enabled' id='road-shields-2-black' value='true' />
            <format attr='enabled' id='road-shields-1-white' value='true' />
            <format attr='enabled' id='road-shields-1-black' value='true' />
            <format attr='enabled' id='road-label-small' value='true' />
            <format attr='enabled' id='road-label-big' value='true' />
            <format attr='enabled' id='background' value='false' />
            <format attr='enabled' id='barrier_line-land-polygon' value='false' />
            <format attr='enabled' id='barrier_line-land-line' value='false' />
            <format attr='enabled' id='national_park' value='false' />
            <format attr='enabled' id='pitch' value='false' />
            <format attr='enabled' id='industrial' value='false' />
            <format attr='enabled' id='built-up-area' value='false' />
            <format attr='enabled' id='water' value='false' />
            <format attr='enabled' id='waterway-river-canal' value='false' />
            <format attr='enabled' id='aeroway-polygon' value='false' />
            <format attr='enabled' id='aeroway-runway' value='false' />
            <format attr='enabled' id='aeroway-taxiway' value='false' />
            <format attr='enabled' id='parks' value='false' />
            <format attr='enabled' id='landcover_wood' value='false' />
            <format attr='enabled' id='landcover_scrub' value='false' />
            <format attr='enabled' id='landcover_grass' value='false' />
            <format attr='enabled' id='landcover_crop' value='false' />
          </style-rule>
          <style-rule element='map'>
            <format attr='washout' value='0.0' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='off' />
            </view>
            <mark class='Automatic' />
            <encodings>
              <color column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_root_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_root_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_cause_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause_perc:nk]' />
              <text column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' />
              <lod column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' />
            </encodings>
            <customized-tooltip>
              <formatted-text>
                <run bold='true'>Address:</run>
                <run bold='true' fontsize='12'> &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'># SSOs: </run>
                <run bold='true' fontsize='12'>&lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run bold='true'>Primary Root Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_root_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'>Secondary Root Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_root_cause:nk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run bold='true'>Primary Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'>Secondary Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause:nk]&gt;</run>
              </formatted-text>
            </customized-tooltip>
            <style>
              <style-rule element='cell'>
                <format attr='wrap' value='on' />
                <format attr='text-align' value='center' />
                <format attr='vertical-align' value='auto' />
              </style-rule>
              <style-rule element='datalabel'>
                <format attr='color-mode' value='user' />
                <format attr='font-size' value='15' />
                <format attr='font-weight' value='bold' />
                <format attr='color' value='#000000' />
              </style-rule>
              <style-rule element='mark'>
                <format attr='size' value='2.2382433414459229' />
                <format attr='mark-labels-cull' value='false' />
                <format attr='mark-labels-show' value='true' />
              </style-rule>
            </style>
          </pane>
        </panes>
        <rows>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]</rows>
        <cols>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]</cols>
      </table>
      <simple-id uuid='{2F91F8FF-B8F3-433A-AC4C-C21455B2F95E}' />
    </worksheet>
    <worksheet name='FreqLiftStations'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontcolor='#000000' fontsize='32'>Lift Stations with Frequent SSOs</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='Sheet1 (sso_most_frequent_lat_long)' name='federated.0z4t00e1mynjhf199g7rp0l6qucy' />
          </datasources>
          <mapsources>
            <mapsource name='Tableau' />
          </mapsources>
          <datasource-dependencies datasource='federated.0z4t00e1mynjhf199g7rp0l6qucy'>
            <column caption='Address' datatype='string' name='[address]' role='dimension' type='nominal' />
            <column-instance column='[prim_cause_perc]' derivation='Attribute' name='[attr:prim_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[prim_perc]' derivation='Attribute' name='[attr:prim_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='Attribute' name='[attr:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='Attribute' name='[attr:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause]' derivation='Attribute' name='[attr:sec_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause_perc]' derivation='Attribute' name='[attr:sec_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_perc]' derivation='Attribute' name='[attr:sec_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_root_cause]' derivation='Attribute' name='[attr:sec_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[latitude]' derivation='Avg' name='[avg:latitude:qk]' pivot='key' type='quantitative' />
            <column-instance column='[longitude]' derivation='Avg' name='[avg:longitude:qk]' pivot='key' type='quantitative' />
            <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
            <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
            <column-instance column='[address]' derivation='None' name='[none:address:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='None' name='[none:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='None' name='[none:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column caption='Number Of Sso' datatype='integer' name='[number_of_sso]' role='measure' type='quantitative' />
            <column datatype='string' name='[prim_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[prim_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_root_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_root_cause]' role='dimension' type='nominal' />
            <column-instance column='[number_of_sso]' derivation='Sum' name='[sum:number_of_sso:qk]' pivot='key' type='quantitative' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]'>
            <groupfilter function='level-members' level='[none:address:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]'>
            <groupfilter function='member' level='[none:primary_cause:nk]' member='&quot;Lift Station&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]'>
            <groupfilter function='member' level='[none:primary_root_cause:nk]' member='&quot;LIFT STATION&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <slices>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]</column>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]</column>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]</column>
          </slices>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]' field-type='quantitative' max='-10951312.546342732' min='-10990639.925736491' projection='EPSG:3857' range-type='fixed' scope='cols' type='space' />
            <encoding attr='space' class='0' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]' field-type='quantitative' max='3448636.3696577596' min='3419481.673481931' projection='EPSG:3857' range-type='fixed' scope='rows' type='space' />
          </style-rule>
          <style-rule element='mark'>
            <encoding attr='color' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' palette='red_10_0' type='interpolated' />
            <encoding attr='size' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' field-type='quantitative' max-size='1' min-size='0' type='quantsize' />
          </style-rule>
          <style-rule element='legend-title-text'>
            <format attr='color' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' value='Number Of SSOs'>
              <formatted-text>
                <run>Number Of SSOs</run>
              </formatted-text>
            </format>
          </style-rule>
          <style-rule element='map-layer'>
            <format attr='enabled' id='building' value='true' />
            <format attr='enabled' id='building-line' value='true' />
            <format attr='enabled' id='place-suburb' value='true' />
            <format attr='enabled' id='place-neighborhood' value='true' />
            <format attr='enabled' id='poi-minor-secondary' value='true' />
            <format attr='enabled' id='poi-minor-primary' value='true' />
            <format attr='enabled' id='poi-main-monuments' value='true' />
            <format attr='enabled' id='poi-main-cemetery' value='true' />
            <format attr='enabled' id='poi-main-greenspace' value='true' />
            <format attr='enabled' id='poi-main-primary' value='true' />
            <format attr='enabled' id='poi-main-peaks' value='true' />
            <format attr='enabled' id='poi-rail' value='true' />
            <format attr='enabled' id='airport-label' value='true' />
            <format attr='enabled' id='place-village' value='true' />
            <format attr='enabled' id='place-town' value='true' />
            <format attr='enabled' id='place-islands' value='true' />
            <format attr='enabled' id='place-city-sm' value='true' />
            <format attr='enabled' id='place-city-md-s' value='true' />
            <format attr='enabled' id='place-city-md-n' value='true' />
            <format attr='enabled' id='place-city-lg-s' value='true' />
            <format attr='enabled' id='place-city-lg-n' value='true' />
            <format attr='enabled' id='place-capital-s' value='true' />
            <format attr='enabled' id='place-capital-n' value='true' />
            <format attr='enabled' id='marine-label-sm-ln' value='true' />
            <format attr='enabled' id='marine-label-sm-pt' value='true' />
            <format attr='enabled' id='marine-label-md-ln' value='true' />
            <format attr='enabled' id='marine-label-md-pt' value='true' />
            <format attr='enabled' id='marine-label-lg-ln' value='true' />
            <format attr='enabled' id='marine-label-lg-pt' value='true' />
            <format attr='enabled' id='water-label' value='true' />
            <format attr='enabled' id='Zip Code Labels' value='true' />
            <format attr='enabled' id='Zip Code Boundaries' value='true' />
            <format attr='enabled' id='admin-2-label' value='true' />
            <format attr='enabled' id='admin-2-boundaries-bg' value='true' />
            <format attr='enabled' id='admin-2-boundaries' value='true' />
            <format attr='enabled' id='admin-1-label-9th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-8th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-7th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-6th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-1st-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-3rd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-2nd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute-sub' value='false' />
            <format attr='enabled' id='admin-0-boundaries-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents' value='false' />
            <format attr='enabled' id='admin1-water-lines-usa-tableau' value='false' />
            <format attr='enabled' id='9-dash-line-casing' value='false' />
            <format attr='enabled' id='9-dash-line' value='false' />
            <format attr='enabled' id='admin-0-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute' value='false' />
            <format attr='enabled' id='tunnel-service-link-track-case' value='true' />
            <format attr='enabled' id='tunnel-street_limited-case' value='true' />
            <format attr='enabled' id='tunnel-street-case' value='true' />
            <format attr='enabled' id='tunnel-secondary-tertiary-case' value='true' />
            <format attr='enabled' id='tunnel-primary-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link-case' value='true' />
            <format attr='enabled' id='tunnel-motorway_link-case' value='true' />
            <format attr='enabled' id='tunnel-trunk-case' value='true' />
            <format attr='enabled' id='tunnel-motorway-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link' value='true' />
            <format attr='enabled' id='tunnel-motorway_link' value='true' />
            <format attr='enabled' id='tunnel-service-link-track' value='true' />
            <format attr='enabled' id='tunnel-street_limited' value='true' />
            <format attr='enabled' id='tunnel-street' value='true' />
            <format attr='enabled' id='tunnel-tertiary' value='true' />
            <format attr='enabled' id='tunnel-secondary' value='true' />
            <format attr='enabled' id='tunnel-primary' value='true' />
            <format attr='enabled' id='tunnel-trunk' value='true' />
            <format attr='enabled' id='tunnel-motorway' value='true' />
            <format attr='enabled' id='road-street-low' value='true' />
            <format attr='enabled' id='road-street_limited-low' value='true' />
            <format attr='enabled' id='road-pedestrian-case' value='true' />
            <format attr='enabled' id='road-service-link-track-case' value='true' />
            <format attr='enabled' id='road-street_limited-case' value='true' />
            <format attr='enabled' id='road-street-case' value='true' />
            <format attr='enabled' id='road-tertiary-case' value='true' />
            <format attr='enabled' id='road-secondary-case' value='true' />
            <format attr='enabled' id='road-primary-case' value='true' />
            <format attr='enabled' id='road-motorway_link-case' value='true' />
            <format attr='enabled' id='road-trunk_link-case' value='true' />
            <format attr='enabled' id='road-trunk-case' value='true' />
            <format attr='enabled' id='road-motorway-case' value='true' />
            <format attr='enabled' id='road-trunk_link' value='true' />
            <format attr='enabled' id='road-motorway_link' value='true' />
            <format attr='enabled' id='road-path' value='true' />
            <format attr='enabled' id='road-pedestrian' value='true' />
            <format attr='enabled' id='road-polygon' value='true' />
            <format attr='enabled' id='road-service-link-track' value='true' />
            <format attr='enabled' id='road-street_limited' value='true' />
            <format attr='enabled' id='road-street' value='true' />
            <format attr='enabled' id='road-tertiary' value='true' />
            <format attr='enabled' id='road-secondary' value='true' />
            <format attr='enabled' id='road-primary' value='true' />
            <format attr='enabled' id='road-trunk' value='true' />
            <format attr='enabled' id='road-motorway' value='true' />
            <format attr='enabled' id='road-rail' value='true' />
            <format attr='enabled' id='road-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-street-low' value='true' />
            <format attr='enabled' id='bridge-street_limited-low' value='true' />
            <format attr='enabled' id='bridge-pedestrian-case' value='true' />
            <format attr='enabled' id='bridge-service-link-track-case' value='true' />
            <format attr='enabled' id='bridge-street_limited-case' value='true' />
            <format attr='enabled' id='bridge-street-case' value='true' />
            <format attr='enabled' id='bridge-tertiary-case' value='true' />
            <format attr='enabled' id='bridge-secondary-case' value='true' />
            <format attr='enabled' id='bridge-primary-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-case' value='true' />
            <format attr='enabled' id='bridge-trunk-case' value='true' />
            <format attr='enabled' id='bridge-motorway-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link' value='true' />
            <format attr='enabled' id='bridge-motorway_link' value='true' />
            <format attr='enabled' id='bridge-path' value='true' />
            <format attr='enabled' id='bridge-pedestrian' value='true' />
            <format attr='enabled' id='bridge-service-link-track' value='true' />
            <format attr='enabled' id='bridge-street_limited' value='true' />
            <format attr='enabled' id='bridge-street' value='true' />
            <format attr='enabled' id='bridge-tertiary' value='true' />
            <format attr='enabled' id='bridge-secondary' value='true' />
            <format attr='enabled' id='bridge-primary' value='true' />
            <format attr='enabled' id='bridge-trunk' value='true' />
            <format attr='enabled' id='bridge-motorway' value='true' />
            <format attr='enabled' id='bridge-rail' value='true' />
            <format attr='enabled' id='bridge-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2' value='true' />
            <format attr='enabled' id='bridge-trunk-2' value='true' />
            <format attr='enabled' id='bridge-motorway-2' value='true' />
            <format attr='enabled' id='road-shields-2-white' value='true' />
            <format attr='enabled' id='road-shields-2-black' value='true' />
            <format attr='enabled' id='road-shields-1-white' value='true' />
            <format attr='enabled' id='road-shields-1-black' value='true' />
            <format attr='enabled' id='road-label-small' value='true' />
            <format attr='enabled' id='road-label-big' value='true' />
            <format attr='enabled' id='background' value='false' />
            <format attr='enabled' id='barrier_line-land-polygon' value='false' />
            <format attr='enabled' id='barrier_line-land-line' value='false' />
            <format attr='enabled' id='national_park' value='false' />
            <format attr='enabled' id='pitch' value='false' />
            <format attr='enabled' id='industrial' value='false' />
            <format attr='enabled' id='built-up-area' value='false' />
            <format attr='enabled' id='water' value='false' />
            <format attr='enabled' id='waterway-river-canal' value='false' />
            <format attr='enabled' id='aeroway-polygon' value='false' />
            <format attr='enabled' id='aeroway-runway' value='false' />
            <format attr='enabled' id='aeroway-taxiway' value='false' />
            <format attr='enabled' id='parks' value='false' />
            <format attr='enabled' id='landcover_wood' value='false' />
            <format attr='enabled' id='landcover_scrub' value='false' />
            <format attr='enabled' id='landcover_grass' value='false' />
            <format attr='enabled' id='landcover_crop' value='false' />
          </style-rule>
          <style-rule element='map'>
            <format attr='washout' value='0.0' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='off' />
            </view>
            <mark class='Automatic' />
            <encodings>
              <color column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_root_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_root_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_cause_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause_perc:nk]' />
              <text column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' />
              <lod column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' />
            </encodings>
            <customized-tooltip>
              <formatted-text>
                <run bold='true'>Address:</run>
                <run bold='true' fontsize='12'> &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'># SSOs: </run>
                <run bold='true' fontsize='12'>&lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run bold='true'>Primary Root Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_root_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'>Secondary Root Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_root_cause:nk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run bold='true'>Primary Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_cause_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'>Secondary Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause:nk]&gt;</run>
              </formatted-text>
            </customized-tooltip>
            <style>
              <style-rule element='cell'>
                <format attr='wrap' value='on' />
                <format attr='text-align' value='center' />
                <format attr='vertical-align' value='auto' />
              </style-rule>
              <style-rule element='datalabel'>
                <format attr='color-mode' value='user' />
                <format attr='font-size' value='15' />
                <format attr='font-weight' value='bold' />
                <format attr='color' value='#000000' />
              </style-rule>
              <style-rule element='mark'>
                <format attr='size' value='2.2382433414459229' />
                <format attr='mark-labels-cull' value='false' />
                <format attr='mark-labels-show' value='true' />
              </style-rule>
            </style>
          </pane>
        </panes>
        <rows>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]</rows>
        <cols>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]</cols>
        <annotations>
          <annotation class='area' id='0' text-pinx='0.5' text-piny='0.5' text-width-delta='-18'>
            <formatted-text>
              <run fontalignment='0'>These locations are all lift stations.</run>
            </formatted-text>
            <top-left>
              <visual-coordinate class='axis'>
                <x-coord axis-value='-10983613.433951473'>
                  <node-reference>
                    <axis>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]</axis>
                  </node-reference>
                </x-coord>
                <y-coord axis-value='3445280.4334073043'>
                  <node-reference>
                    <axis>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]</axis>
                  </node-reference>
                </y-coord>
                <page-reference />
                <projection name='EPSG:3857' u='-98.6674782257911' v='29.545652878946949' />
              </visual-coordinate>
            </top-left>
            <bottom-right>
              <visual-coordinate class='axis'>
                <x-coord axis-value='-10980117.66689425'>
                  <node-reference>
                    <axis>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]</axis>
                  </node-reference>
                </x-coord>
                <y-coord axis-value='3441784.6664797473'>
                  <node-reference>
                    <axis>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]</axis>
                  </node-reference>
                </y-coord>
                <page-reference />
                <projection name='EPSG:3857' u='-98.636075216018838' v='29.518329730367164' />
              </visual-coordinate>
            </bottom-right>
            <text x='0.5' y='0.5' />
          </annotation>
        </annotations>
      </table>
      <simple-id uuid='{C63DF06E-EF3C-44AB-BD9B-639D653737C9}' />
    </worksheet>
    <worksheet name='FreqRain-I/I'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontcolor='#000000' fontsize='32'>Most Frequent SSOs Caused by Rain</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='Sheet1 (sso_most_frequent_lat_long)' name='federated.0z4t00e1mynjhf199g7rp0l6qucy' />
          </datasources>
          <mapsources>
            <mapsource name='Tableau' />
          </mapsources>
          <datasource-dependencies datasource='federated.0z4t00e1mynjhf199g7rp0l6qucy'>
            <column caption='Address' datatype='string' name='[address]' role='dimension' type='nominal' />
            <column-instance column='[prim_cause_perc]' derivation='Attribute' name='[attr:prim_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[prim_perc]' derivation='Attribute' name='[attr:prim_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='Attribute' name='[attr:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='Attribute' name='[attr:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause]' derivation='Attribute' name='[attr:sec_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause_perc]' derivation='Attribute' name='[attr:sec_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_perc]' derivation='Attribute' name='[attr:sec_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_root_cause]' derivation='Attribute' name='[attr:sec_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[latitude]' derivation='Avg' name='[avg:latitude:qk]' pivot='key' type='quantitative' />
            <column-instance column='[longitude]' derivation='Avg' name='[avg:longitude:qk]' pivot='key' type='quantitative' />
            <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
            <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
            <column-instance column='[address]' derivation='None' name='[none:address:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='None' name='[none:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='None' name='[none:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column caption='Number Of Sso' datatype='integer' name='[number_of_sso]' role='measure' type='quantitative' />
            <column datatype='string' name='[prim_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[prim_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_root_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_root_cause]' role='dimension' type='nominal' />
            <column-instance column='[number_of_sso]' derivation='Sum' name='[sum:number_of_sso:qk]' pivot='key' type='quantitative' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]'>
            <groupfilter function='level-members' level='[none:address:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]'>
            <groupfilter function='member' level='[none:primary_cause:nk]' member='&quot;I/I&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]'>
            <groupfilter function='member' level='[none:primary_root_cause:nk]' member='&quot;RAIN EVENT&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <slices>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]</column>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]</column>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]</column>
          </slices>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]' field-type='quantitative' max='-10948350.977810146' min='-10994411.346912639' projection='EPSG:3857' range-type='fixed' scope='cols' type='space' />
            <encoding attr='space' class='0' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]' field-type='quantitative' max='3448265.1871832986' min='3419110.4910074701' projection='EPSG:3857' range-type='fixed' scope='rows' type='space' />
          </style-rule>
          <style-rule element='mark'>
            <encoding attr='color' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' palette='red_10_0' type='interpolated' />
            <encoding attr='size' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' field-type='quantitative' max-size='1' min-size='0' type='quantsize' />
          </style-rule>
          <style-rule element='legend-title-text'>
            <format attr='color' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' value='Number Of SSOs'>
              <formatted-text>
                <run>Number Of SSOs</run>
              </formatted-text>
            </format>
          </style-rule>
          <style-rule element='map-layer'>
            <format attr='enabled' id='building' value='true' />
            <format attr='enabled' id='building-line' value='true' />
            <format attr='enabled' id='place-suburb' value='true' />
            <format attr='enabled' id='place-neighborhood' value='true' />
            <format attr='enabled' id='poi-minor-secondary' value='true' />
            <format attr='enabled' id='poi-minor-primary' value='true' />
            <format attr='enabled' id='poi-main-monuments' value='true' />
            <format attr='enabled' id='poi-main-cemetery' value='true' />
            <format attr='enabled' id='poi-main-greenspace' value='true' />
            <format attr='enabled' id='poi-main-primary' value='true' />
            <format attr='enabled' id='poi-main-peaks' value='true' />
            <format attr='enabled' id='poi-rail' value='true' />
            <format attr='enabled' id='airport-label' value='true' />
            <format attr='enabled' id='place-village' value='true' />
            <format attr='enabled' id='place-town' value='true' />
            <format attr='enabled' id='place-islands' value='true' />
            <format attr='enabled' id='place-city-sm' value='true' />
            <format attr='enabled' id='place-city-md-s' value='true' />
            <format attr='enabled' id='place-city-md-n' value='true' />
            <format attr='enabled' id='place-city-lg-s' value='true' />
            <format attr='enabled' id='place-city-lg-n' value='true' />
            <format attr='enabled' id='place-capital-s' value='true' />
            <format attr='enabled' id='place-capital-n' value='true' />
            <format attr='enabled' id='marine-label-sm-ln' value='true' />
            <format attr='enabled' id='marine-label-sm-pt' value='true' />
            <format attr='enabled' id='marine-label-md-ln' value='true' />
            <format attr='enabled' id='marine-label-md-pt' value='true' />
            <format attr='enabled' id='marine-label-lg-ln' value='true' />
            <format attr='enabled' id='marine-label-lg-pt' value='true' />
            <format attr='enabled' id='water-label' value='true' />
            <format attr='enabled' id='Zip Code Labels' value='true' />
            <format attr='enabled' id='Zip Code Boundaries' value='true' />
            <format attr='enabled' id='admin-2-label' value='true' />
            <format attr='enabled' id='admin-2-boundaries-bg' value='true' />
            <format attr='enabled' id='admin-2-boundaries' value='true' />
            <format attr='enabled' id='admin-1-label-9th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-8th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-7th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-6th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-1st-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-3rd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-2nd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute-sub' value='false' />
            <format attr='enabled' id='admin-0-boundaries-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents' value='false' />
            <format attr='enabled' id='admin1-water-lines-usa-tableau' value='false' />
            <format attr='enabled' id='9-dash-line-casing' value='false' />
            <format attr='enabled' id='9-dash-line' value='false' />
            <format attr='enabled' id='admin-0-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute' value='false' />
            <format attr='enabled' id='tunnel-service-link-track-case' value='true' />
            <format attr='enabled' id='tunnel-street_limited-case' value='true' />
            <format attr='enabled' id='tunnel-street-case' value='true' />
            <format attr='enabled' id='tunnel-secondary-tertiary-case' value='true' />
            <format attr='enabled' id='tunnel-primary-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link-case' value='true' />
            <format attr='enabled' id='tunnel-motorway_link-case' value='true' />
            <format attr='enabled' id='tunnel-trunk-case' value='true' />
            <format attr='enabled' id='tunnel-motorway-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link' value='true' />
            <format attr='enabled' id='tunnel-motorway_link' value='true' />
            <format attr='enabled' id='tunnel-service-link-track' value='true' />
            <format attr='enabled' id='tunnel-street_limited' value='true' />
            <format attr='enabled' id='tunnel-street' value='true' />
            <format attr='enabled' id='tunnel-tertiary' value='true' />
            <format attr='enabled' id='tunnel-secondary' value='true' />
            <format attr='enabled' id='tunnel-primary' value='true' />
            <format attr='enabled' id='tunnel-trunk' value='true' />
            <format attr='enabled' id='tunnel-motorway' value='true' />
            <format attr='enabled' id='road-street-low' value='true' />
            <format attr='enabled' id='road-street_limited-low' value='true' />
            <format attr='enabled' id='road-pedestrian-case' value='true' />
            <format attr='enabled' id='road-service-link-track-case' value='true' />
            <format attr='enabled' id='road-street_limited-case' value='true' />
            <format attr='enabled' id='road-street-case' value='true' />
            <format attr='enabled' id='road-tertiary-case' value='true' />
            <format attr='enabled' id='road-secondary-case' value='true' />
            <format attr='enabled' id='road-primary-case' value='true' />
            <format attr='enabled' id='road-motorway_link-case' value='true' />
            <format attr='enabled' id='road-trunk_link-case' value='true' />
            <format attr='enabled' id='road-trunk-case' value='true' />
            <format attr='enabled' id='road-motorway-case' value='true' />
            <format attr='enabled' id='road-trunk_link' value='true' />
            <format attr='enabled' id='road-motorway_link' value='true' />
            <format attr='enabled' id='road-path' value='true' />
            <format attr='enabled' id='road-pedestrian' value='true' />
            <format attr='enabled' id='road-polygon' value='true' />
            <format attr='enabled' id='road-service-link-track' value='true' />
            <format attr='enabled' id='road-street_limited' value='true' />
            <format attr='enabled' id='road-street' value='true' />
            <format attr='enabled' id='road-tertiary' value='true' />
            <format attr='enabled' id='road-secondary' value='true' />
            <format attr='enabled' id='road-primary' value='true' />
            <format attr='enabled' id='road-trunk' value='true' />
            <format attr='enabled' id='road-motorway' value='true' />
            <format attr='enabled' id='road-rail' value='true' />
            <format attr='enabled' id='road-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-street-low' value='true' />
            <format attr='enabled' id='bridge-street_limited-low' value='true' />
            <format attr='enabled' id='bridge-pedestrian-case' value='true' />
            <format attr='enabled' id='bridge-service-link-track-case' value='true' />
            <format attr='enabled' id='bridge-street_limited-case' value='true' />
            <format attr='enabled' id='bridge-street-case' value='true' />
            <format attr='enabled' id='bridge-tertiary-case' value='true' />
            <format attr='enabled' id='bridge-secondary-case' value='true' />
            <format attr='enabled' id='bridge-primary-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-case' value='true' />
            <format attr='enabled' id='bridge-trunk-case' value='true' />
            <format attr='enabled' id='bridge-motorway-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link' value='true' />
            <format attr='enabled' id='bridge-motorway_link' value='true' />
            <format attr='enabled' id='bridge-path' value='true' />
            <format attr='enabled' id='bridge-pedestrian' value='true' />
            <format attr='enabled' id='bridge-service-link-track' value='true' />
            <format attr='enabled' id='bridge-street_limited' value='true' />
            <format attr='enabled' id='bridge-street' value='true' />
            <format attr='enabled' id='bridge-tertiary' value='true' />
            <format attr='enabled' id='bridge-secondary' value='true' />
            <format attr='enabled' id='bridge-primary' value='true' />
            <format attr='enabled' id='bridge-trunk' value='true' />
            <format attr='enabled' id='bridge-motorway' value='true' />
            <format attr='enabled' id='bridge-rail' value='true' />
            <format attr='enabled' id='bridge-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2' value='true' />
            <format attr='enabled' id='bridge-trunk-2' value='true' />
            <format attr='enabled' id='bridge-motorway-2' value='true' />
            <format attr='enabled' id='road-shields-2-white' value='true' />
            <format attr='enabled' id='road-shields-2-black' value='true' />
            <format attr='enabled' id='road-shields-1-white' value='true' />
            <format attr='enabled' id='road-shields-1-black' value='true' />
            <format attr='enabled' id='road-label-small' value='true' />
            <format attr='enabled' id='road-label-big' value='true' />
            <format attr='enabled' id='background' value='false' />
            <format attr='enabled' id='barrier_line-land-polygon' value='false' />
            <format attr='enabled' id='barrier_line-land-line' value='false' />
            <format attr='enabled' id='national_park' value='false' />
            <format attr='enabled' id='pitch' value='false' />
            <format attr='enabled' id='industrial' value='false' />
            <format attr='enabled' id='built-up-area' value='false' />
            <format attr='enabled' id='water' value='false' />
            <format attr='enabled' id='waterway-river-canal' value='false' />
            <format attr='enabled' id='aeroway-polygon' value='false' />
            <format attr='enabled' id='aeroway-runway' value='false' />
            <format attr='enabled' id='aeroway-taxiway' value='false' />
            <format attr='enabled' id='parks' value='false' />
            <format attr='enabled' id='landcover_wood' value='false' />
            <format attr='enabled' id='landcover_scrub' value='false' />
            <format attr='enabled' id='landcover_grass' value='false' />
            <format attr='enabled' id='landcover_crop' value='false' />
          </style-rule>
          <style-rule element='map'>
            <format attr='washout' value='0.0' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='off' />
            </view>
            <mark class='Automatic' />
            <encodings>
              <color column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_root_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_root_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_cause_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause_perc:nk]' />
              <text column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' />
              <lod column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' />
            </encodings>
            <customized-tooltip>
              <formatted-text>
                <run bold='true'>Address:</run>
                <run bold='true' fontsize='12'> &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'># SSOs: </run>
                <run bold='true' fontsize='12'>&lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run bold='true'>Primary Root Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_root_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'>Secondary Root Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_root_cause:nk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run bold='true'>Primary Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run bold='true'>Secondary Cause:   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause:nk]&gt;</run>
              </formatted-text>
            </customized-tooltip>
            <style>
              <style-rule element='cell'>
                <format attr='wrap' value='on' />
                <format attr='text-align' value='center' />
                <format attr='vertical-align' value='bottom' />
              </style-rule>
              <style-rule element='datalabel'>
                <format attr='color-mode' value='user' />
                <format attr='font-size' value='15' />
                <format attr='color' value='#000000' />
                <format attr='font-weight' value='bold' />
              </style-rule>
              <style-rule element='mark'>
                <format attr='size' value='2.2382433414459229' />
                <format attr='mark-labels-cull' value='false' />
                <format attr='mark-labels-show' value='true' />
              </style-rule>
            </style>
          </pane>
        </panes>
        <rows>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]</rows>
        <cols>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]</cols>
        <annotations>
          <annotation class='area' id='0' text-pinx='0.5' text-piny='0.5' text-width-delta='-18'>
            <formatted-text>
              <run bold='true' fontalignment='0' fontsize='22'>The pipes leading into these locations could benefit from slip lining the pipes and manholes, rehabilitating the pipes, and/or creating temporary storage basins for the overflow from the SSOs.</run>
            </formatted-text>
            <top-left>
              <visual-coordinate class='axis'>
                <x-coord axis-value='-10991627.253491333'>
                  <node-reference>
                    <axis>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]</axis>
                  </node-reference>
                </x-coord>
                <y-coord axis-value='3442162.9466958833'>
                  <node-reference>
                    <axis>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]</axis>
                  </node-reference>
                </y-coord>
                <page-reference />
                <projection name='EPSG:3857' u='-98.739467591559432' v='29.521286750024732' />
              </visual-coordinate>
            </top-left>
            <bottom-right>
              <visual-coordinate class='axis'>
                <x-coord axis-value='-10966283.814847384'>
                  <node-reference>
                    <axis>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]</axis>
                  </node-reference>
                </x-coord>
                <y-coord axis-value='3433933.4943881524'>
                  <node-reference>
                    <axis>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]</axis>
                  </node-reference>
                </y-coord>
                <page-reference />
                <projection name='EPSG:3857' u='-98.511803608699367' v='29.456937551505305' />
              </visual-coordinate>
            </bottom-right>
            <text x='0.5' y='0.5' />
          </annotation>
        </annotations>
      </table>
      <simple-id uuid='{DCB54EC2-781B-4B74-A73D-4174439CED56}' />
    </worksheet>
    <worksheet name='Gal Holbrook'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontcolor='#000000' fontsize='32'>Holbrook is a Major Spill Area</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='most_gallons' name='federated.0gv4ky81v0fz3r12lfxyn0fepy1v' />
          </datasources>
          <mapsources>
            <mapsource name='Tableau' />
          </mapsources>
          <datasource-dependencies datasource='federated.0gv4ky81v0fz3r12lfxyn0fepy1v'>
            <column-instance column='[prim_cause_perc]' derivation='Attribute' name='[attr:prim_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[prim_perc]' derivation='Attribute' name='[attr:prim_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='Attribute' name='[attr:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='Attribute' name='[attr:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause]' derivation='Attribute' name='[attr:sec_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause_perc]' derivation='Attribute' name='[attr:sec_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_perc]' derivation='Attribute' name='[attr:sec_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_root_cause]' derivation='Attribute' name='[attr:sec_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[latitude]' derivation='Avg' name='[avg:latitude:qk]' pivot='key' type='quantitative' />
            <column-instance column='[longitude]' derivation='Avg' name='[avg:longitude:qk]' pivot='key' type='quantitative' />
            <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
            <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
            <column-instance column='[primary_cause]' derivation='None' name='[none:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='None' name='[none:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[spill_street_address]' derivation='None' name='[none:spill_street_address:nk]' pivot='key' type='nominal' />
            <column datatype='string' name='[prim_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[prim_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_root_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_root_cause]' role='dimension' type='nominal' />
            <column caption='Spill Street Address' datatype='string' name='[spill_street_address]' role='dimension' type='nominal' />
            <column-instance column='[total_gallons]' derivation='Sum' name='[sum:total_gallons:qk]' pivot='key' type='quantitative' />
            <column caption='Total Gallons' datatype='integer' name='[total_gallons]' role='measure' type='quantitative' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_cause:nk]'>
            <groupfilter function='member' level='[none:primary_cause:nk]' member='&quot;I/I&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_root_cause:nk]'>
            <groupfilter function='member' level='[none:primary_root_cause:nk]' member='&quot;RAIN EVENT&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <slices>
            <column>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_root_cause:nk]</column>
            <column>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_cause:nk]</column>
          </slices>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:longitude:qk]' field-type='quantitative' max='-10954317.022186074' min='-10956483.413911277' projection='EPSG:3857' range-type='fixed' scope='cols' type='space' />
            <encoding attr='space' class='0' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:latitude:qk]' field-type='quantitative' max='3438304.7315864908' min='3436698.7132471115' projection='EPSG:3857' range-type='fixed' scope='rows' type='space' />
          </style-rule>
          <style-rule element='mark'>
            <encoding attr='size' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' field-type='quantitative' max-size='1' min-size='0' type='quantsize' />
            <encoding attr='color' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' palette='blue_10_0' type='interpolated' />
          </style-rule>
          <style-rule element='map-layer'>
            <format attr='enabled' id='building' value='true' />
            <format attr='enabled' id='building-line' value='true' />
            <format attr='enabled' id='place-suburb' value='true' />
            <format attr='enabled' id='place-neighborhood' value='true' />
            <format attr='enabled' id='poi-minor-secondary' value='true' />
            <format attr='enabled' id='poi-minor-primary' value='true' />
            <format attr='enabled' id='poi-main-monuments' value='true' />
            <format attr='enabled' id='poi-main-cemetery' value='true' />
            <format attr='enabled' id='poi-main-greenspace' value='true' />
            <format attr='enabled' id='poi-main-primary' value='true' />
            <format attr='enabled' id='poi-main-peaks' value='true' />
            <format attr='enabled' id='poi-rail' value='true' />
            <format attr='enabled' id='airport-label' value='true' />
            <format attr='enabled' id='place-village' value='true' />
            <format attr='enabled' id='place-town' value='true' />
            <format attr='enabled' id='place-islands' value='true' />
            <format attr='enabled' id='place-city-sm' value='true' />
            <format attr='enabled' id='place-city-md-s' value='true' />
            <format attr='enabled' id='place-city-md-n' value='true' />
            <format attr='enabled' id='place-city-lg-s' value='true' />
            <format attr='enabled' id='place-city-lg-n' value='true' />
            <format attr='enabled' id='place-capital-s' value='true' />
            <format attr='enabled' id='place-capital-n' value='true' />
            <format attr='enabled' id='marine-label-sm-ln' value='true' />
            <format attr='enabled' id='marine-label-sm-pt' value='true' />
            <format attr='enabled' id='marine-label-md-ln' value='true' />
            <format attr='enabled' id='marine-label-md-pt' value='true' />
            <format attr='enabled' id='marine-label-lg-ln' value='true' />
            <format attr='enabled' id='marine-label-lg-pt' value='true' />
            <format attr='enabled' id='water-label' value='true' />
            <format attr='enabled' id='Zip Code Labels' value='true' />
            <format attr='enabled' id='Zip Code Boundaries' value='true' />
            <format attr='enabled' id='admin-2-label' value='true' />
            <format attr='enabled' id='admin-2-boundaries-bg' value='true' />
            <format attr='enabled' id='admin-2-boundaries' value='true' />
            <format attr='enabled' id='admin-1-label-9th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-8th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-7th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-6th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-1st-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-3rd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-2nd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute-sub' value='false' />
            <format attr='enabled' id='admin-0-boundaries-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents' value='false' />
            <format attr='enabled' id='admin1-water-lines-usa-tableau' value='false' />
            <format attr='enabled' id='9-dash-line-casing' value='false' />
            <format attr='enabled' id='9-dash-line' value='false' />
            <format attr='enabled' id='admin-0-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute' value='false' />
            <format attr='enabled' id='tunnel-service-link-track-case' value='true' />
            <format attr='enabled' id='tunnel-street_limited-case' value='true' />
            <format attr='enabled' id='tunnel-street-case' value='true' />
            <format attr='enabled' id='tunnel-secondary-tertiary-case' value='true' />
            <format attr='enabled' id='tunnel-primary-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link-case' value='true' />
            <format attr='enabled' id='tunnel-motorway_link-case' value='true' />
            <format attr='enabled' id='tunnel-trunk-case' value='true' />
            <format attr='enabled' id='tunnel-motorway-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link' value='true' />
            <format attr='enabled' id='tunnel-motorway_link' value='true' />
            <format attr='enabled' id='tunnel-service-link-track' value='true' />
            <format attr='enabled' id='tunnel-street_limited' value='true' />
            <format attr='enabled' id='tunnel-street' value='true' />
            <format attr='enabled' id='tunnel-tertiary' value='true' />
            <format attr='enabled' id='tunnel-secondary' value='true' />
            <format attr='enabled' id='tunnel-primary' value='true' />
            <format attr='enabled' id='tunnel-trunk' value='true' />
            <format attr='enabled' id='tunnel-motorway' value='true' />
            <format attr='enabled' id='road-street-low' value='true' />
            <format attr='enabled' id='road-street_limited-low' value='true' />
            <format attr='enabled' id='road-pedestrian-case' value='true' />
            <format attr='enabled' id='road-service-link-track-case' value='true' />
            <format attr='enabled' id='road-street_limited-case' value='true' />
            <format attr='enabled' id='road-street-case' value='true' />
            <format attr='enabled' id='road-tertiary-case' value='true' />
            <format attr='enabled' id='road-secondary-case' value='true' />
            <format attr='enabled' id='road-primary-case' value='true' />
            <format attr='enabled' id='road-motorway_link-case' value='true' />
            <format attr='enabled' id='road-trunk_link-case' value='true' />
            <format attr='enabled' id='road-trunk-case' value='true' />
            <format attr='enabled' id='road-motorway-case' value='true' />
            <format attr='enabled' id='road-trunk_link' value='true' />
            <format attr='enabled' id='road-motorway_link' value='true' />
            <format attr='enabled' id='road-path' value='true' />
            <format attr='enabled' id='road-pedestrian' value='true' />
            <format attr='enabled' id='road-polygon' value='true' />
            <format attr='enabled' id='road-service-link-track' value='true' />
            <format attr='enabled' id='road-street_limited' value='true' />
            <format attr='enabled' id='road-street' value='true' />
            <format attr='enabled' id='road-tertiary' value='true' />
            <format attr='enabled' id='road-secondary' value='true' />
            <format attr='enabled' id='road-primary' value='true' />
            <format attr='enabled' id='road-trunk' value='true' />
            <format attr='enabled' id='road-motorway' value='true' />
            <format attr='enabled' id='road-rail' value='true' />
            <format attr='enabled' id='road-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-street-low' value='true' />
            <format attr='enabled' id='bridge-street_limited-low' value='true' />
            <format attr='enabled' id='bridge-pedestrian-case' value='true' />
            <format attr='enabled' id='bridge-service-link-track-case' value='true' />
            <format attr='enabled' id='bridge-street_limited-case' value='true' />
            <format attr='enabled' id='bridge-street-case' value='true' />
            <format attr='enabled' id='bridge-tertiary-case' value='true' />
            <format attr='enabled' id='bridge-secondary-case' value='true' />
            <format attr='enabled' id='bridge-primary-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-case' value='true' />
            <format attr='enabled' id='bridge-trunk-case' value='true' />
            <format attr='enabled' id='bridge-motorway-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link' value='true' />
            <format attr='enabled' id='bridge-motorway_link' value='true' />
            <format attr='enabled' id='bridge-path' value='true' />
            <format attr='enabled' id='bridge-pedestrian' value='true' />
            <format attr='enabled' id='bridge-service-link-track' value='true' />
            <format attr='enabled' id='bridge-street_limited' value='true' />
            <format attr='enabled' id='bridge-street' value='true' />
            <format attr='enabled' id='bridge-tertiary' value='true' />
            <format attr='enabled' id='bridge-secondary' value='true' />
            <format attr='enabled' id='bridge-primary' value='true' />
            <format attr='enabled' id='bridge-trunk' value='true' />
            <format attr='enabled' id='bridge-motorway' value='true' />
            <format attr='enabled' id='bridge-rail' value='true' />
            <format attr='enabled' id='bridge-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2' value='true' />
            <format attr='enabled' id='bridge-trunk-2' value='true' />
            <format attr='enabled' id='bridge-motorway-2' value='true' />
            <format attr='enabled' id='road-shields-2-white' value='true' />
            <format attr='enabled' id='road-shields-2-black' value='true' />
            <format attr='enabled' id='road-shields-1-white' value='true' />
            <format attr='enabled' id='road-shields-1-black' value='true' />
            <format attr='enabled' id='road-label-small' value='true' />
            <format attr='enabled' id='road-label-big' value='true' />
            <format attr='enabled' id='hillshade_highlight_bright' value='true' />
            <format attr='enabled' id='hillshade_highlight_med' value='true' />
            <format attr='enabled' id='hillshade_shadow_faint' value='true' />
            <format attr='enabled' id='hillshade_shadow_med' value='true' />
            <format attr='enabled' id='hillshade_shadow_dark' value='true' />
            <format attr='enabled' id='hillshade_shadow_extreme' value='true' />
          </style-rule>
          <style-rule element='map'>
            <format attr='washout' value='0.0' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
            <encodings>
              <color column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_root_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_root_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_cause_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' />
              <text column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]' />
              <lod column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]' />
            </encodings>
            <customized-tooltip>
              <formatted-text>
                <run fontcolor='#787878'>Spill Street Address:&#9;</run>
                <run bold='true' fontsize='12'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>Total Gallons:&#9;</run>
                <run bold='true' fontsize='12'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run fontcolor='#787878'>primary root cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_root_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>secondary root cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_root_cause:nk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run fontcolor='#787878'>primary cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_cause_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>secondary cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause:nk]&gt;</run>
              </formatted-text>
            </customized-tooltip>
            <style>
              <style-rule element='cell'>
                <format attr='wrap' value='on' />
                <format attr='vertical-align' value='bottom' />
              </style-rule>
              <style-rule element='datalabel'>
                <format attr='color-mode' value='user' />
                <format attr='font-weight' value='bold' />
                <format attr='color' value='#000000' />
                <format attr='font-size' value='15' />
              </style-rule>
              <style-rule element='mark'>
                <format attr='mark-labels-show' value='true' />
                <format attr='mark-labels-cull' value='false' />
                <format attr='size' value='1.6811823844909668' />
              </style-rule>
            </style>
          </pane>
        </panes>
        <rows>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:latitude:qk]</rows>
        <cols>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:longitude:qk]</cols>
      </table>
      <simple-id uuid='{BFF16945-D837-4206-8B34-571A12422F8A}' />
    </worksheet>
    <worksheet name='GalRain-I/I'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontcolor='#000000' fontsize='32'>10 Locations Spilling Most Sewage Caused by Rainwater Infiltrating the Sewer Pipes</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='most_gallons' name='federated.0gv4ky81v0fz3r12lfxyn0fepy1v' />
          </datasources>
          <mapsources>
            <mapsource name='Tableau' />
          </mapsources>
          <datasource-dependencies datasource='federated.0gv4ky81v0fz3r12lfxyn0fepy1v'>
            <column-instance column='[prim_cause_perc]' derivation='Attribute' name='[attr:prim_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[prim_perc]' derivation='Attribute' name='[attr:prim_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='Attribute' name='[attr:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='Attribute' name='[attr:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause]' derivation='Attribute' name='[attr:sec_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause_perc]' derivation='Attribute' name='[attr:sec_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_perc]' derivation='Attribute' name='[attr:sec_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_root_cause]' derivation='Attribute' name='[attr:sec_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[latitude]' derivation='Avg' name='[avg:latitude:qk]' pivot='key' type='quantitative' />
            <column-instance column='[longitude]' derivation='Avg' name='[avg:longitude:qk]' pivot='key' type='quantitative' />
            <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
            <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
            <column-instance column='[primary_cause]' derivation='None' name='[none:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='None' name='[none:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[spill_street_address]' derivation='None' name='[none:spill_street_address:nk]' pivot='key' type='nominal' />
            <column datatype='string' name='[prim_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[prim_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_root_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_root_cause]' role='dimension' type='nominal' />
            <column caption='Spill Street Address' datatype='string' name='[spill_street_address]' role='dimension' type='nominal' />
            <column-instance column='[total_gallons]' derivation='Sum' name='[sum:total_gallons:qk]' pivot='key' type='quantitative' />
            <column caption='Total Gallons' datatype='integer' name='[total_gallons]' role='measure' type='quantitative' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_cause:nk]'>
            <groupfilter function='member' level='[none:primary_cause:nk]' member='&quot;I/I&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_root_cause:nk]'>
            <groupfilter function='member' level='[none:primary_root_cause:nk]' member='&quot;RAIN EVENT&quot;' user:ui-domain='relevant' user:ui-enumeration='inclusive' user:ui-marker='enumerate' />
          </filter>
          <slices>
            <column>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_root_cause:nk]</column>
            <column>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_cause:nk]</column>
          </slices>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:longitude:qk]' field-type='quantitative' max='-10942968.056394149' min='-10991315.728800768' projection='EPSG:3857' range-type='fixed' scope='cols' type='space' />
            <encoding attr='space' class='0' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:latitude:qk]' field-type='quantitative' max='3450948.2267705519' min='3418974.29994153' projection='EPSG:3857' range-type='fixed' scope='rows' type='space' />
          </style-rule>
          <style-rule element='mark'>
            <encoding attr='size' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' field-type='quantitative' max-size='1' min-size='0' type='quantsize' />
            <encoding attr='color' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' palette='blue_10_0' type='interpolated' />
          </style-rule>
          <style-rule element='map-layer'>
            <format attr='enabled' id='building' value='true' />
            <format attr='enabled' id='building-line' value='true' />
            <format attr='enabled' id='place-suburb' value='true' />
            <format attr='enabled' id='place-neighborhood' value='true' />
            <format attr='enabled' id='poi-minor-secondary' value='true' />
            <format attr='enabled' id='poi-minor-primary' value='true' />
            <format attr='enabled' id='poi-main-monuments' value='true' />
            <format attr='enabled' id='poi-main-cemetery' value='true' />
            <format attr='enabled' id='poi-main-greenspace' value='true' />
            <format attr='enabled' id='poi-main-primary' value='true' />
            <format attr='enabled' id='poi-main-peaks' value='true' />
            <format attr='enabled' id='poi-rail' value='true' />
            <format attr='enabled' id='airport-label' value='true' />
            <format attr='enabled' id='place-village' value='true' />
            <format attr='enabled' id='place-town' value='true' />
            <format attr='enabled' id='place-islands' value='true' />
            <format attr='enabled' id='place-city-sm' value='true' />
            <format attr='enabled' id='place-city-md-s' value='true' />
            <format attr='enabled' id='place-city-md-n' value='true' />
            <format attr='enabled' id='place-city-lg-s' value='true' />
            <format attr='enabled' id='place-city-lg-n' value='true' />
            <format attr='enabled' id='place-capital-s' value='true' />
            <format attr='enabled' id='place-capital-n' value='true' />
            <format attr='enabled' id='marine-label-sm-ln' value='true' />
            <format attr='enabled' id='marine-label-sm-pt' value='true' />
            <format attr='enabled' id='marine-label-md-ln' value='true' />
            <format attr='enabled' id='marine-label-md-pt' value='true' />
            <format attr='enabled' id='marine-label-lg-ln' value='true' />
            <format attr='enabled' id='marine-label-lg-pt' value='true' />
            <format attr='enabled' id='water-label' value='true' />
            <format attr='enabled' id='Zip Code Labels' value='true' />
            <format attr='enabled' id='Zip Code Boundaries' value='true' />
            <format attr='enabled' id='admin-2-label' value='true' />
            <format attr='enabled' id='admin-2-boundaries-bg' value='true' />
            <format attr='enabled' id='admin-2-boundaries' value='true' />
            <format attr='enabled' id='admin-1-label-9th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-8th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-7th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-6th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-1st-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-3rd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-2nd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute-sub' value='false' />
            <format attr='enabled' id='admin-0-boundaries-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents' value='false' />
            <format attr='enabled' id='admin1-water-lines-usa-tableau' value='false' />
            <format attr='enabled' id='9-dash-line-casing' value='false' />
            <format attr='enabled' id='9-dash-line' value='false' />
            <format attr='enabled' id='admin-0-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute' value='false' />
            <format attr='enabled' id='tunnel-service-link-track-case' value='true' />
            <format attr='enabled' id='tunnel-street_limited-case' value='true' />
            <format attr='enabled' id='tunnel-street-case' value='true' />
            <format attr='enabled' id='tunnel-secondary-tertiary-case' value='true' />
            <format attr='enabled' id='tunnel-primary-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link-case' value='true' />
            <format attr='enabled' id='tunnel-motorway_link-case' value='true' />
            <format attr='enabled' id='tunnel-trunk-case' value='true' />
            <format attr='enabled' id='tunnel-motorway-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link' value='true' />
            <format attr='enabled' id='tunnel-motorway_link' value='true' />
            <format attr='enabled' id='tunnel-service-link-track' value='true' />
            <format attr='enabled' id='tunnel-street_limited' value='true' />
            <format attr='enabled' id='tunnel-street' value='true' />
            <format attr='enabled' id='tunnel-tertiary' value='true' />
            <format attr='enabled' id='tunnel-secondary' value='true' />
            <format attr='enabled' id='tunnel-primary' value='true' />
            <format attr='enabled' id='tunnel-trunk' value='true' />
            <format attr='enabled' id='tunnel-motorway' value='true' />
            <format attr='enabled' id='road-street-low' value='true' />
            <format attr='enabled' id='road-street_limited-low' value='true' />
            <format attr='enabled' id='road-pedestrian-case' value='true' />
            <format attr='enabled' id='road-service-link-track-case' value='true' />
            <format attr='enabled' id='road-street_limited-case' value='true' />
            <format attr='enabled' id='road-street-case' value='true' />
            <format attr='enabled' id='road-tertiary-case' value='true' />
            <format attr='enabled' id='road-secondary-case' value='true' />
            <format attr='enabled' id='road-primary-case' value='true' />
            <format attr='enabled' id='road-motorway_link-case' value='true' />
            <format attr='enabled' id='road-trunk_link-case' value='true' />
            <format attr='enabled' id='road-trunk-case' value='true' />
            <format attr='enabled' id='road-motorway-case' value='true' />
            <format attr='enabled' id='road-trunk_link' value='true' />
            <format attr='enabled' id='road-motorway_link' value='true' />
            <format attr='enabled' id='road-path' value='true' />
            <format attr='enabled' id='road-pedestrian' value='true' />
            <format attr='enabled' id='road-polygon' value='true' />
            <format attr='enabled' id='road-service-link-track' value='true' />
            <format attr='enabled' id='road-street_limited' value='true' />
            <format attr='enabled' id='road-street' value='true' />
            <format attr='enabled' id='road-tertiary' value='true' />
            <format attr='enabled' id='road-secondary' value='true' />
            <format attr='enabled' id='road-primary' value='true' />
            <format attr='enabled' id='road-trunk' value='true' />
            <format attr='enabled' id='road-motorway' value='true' />
            <format attr='enabled' id='road-rail' value='true' />
            <format attr='enabled' id='road-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-street-low' value='true' />
            <format attr='enabled' id='bridge-street_limited-low' value='true' />
            <format attr='enabled' id='bridge-pedestrian-case' value='true' />
            <format attr='enabled' id='bridge-service-link-track-case' value='true' />
            <format attr='enabled' id='bridge-street_limited-case' value='true' />
            <format attr='enabled' id='bridge-street-case' value='true' />
            <format attr='enabled' id='bridge-tertiary-case' value='true' />
            <format attr='enabled' id='bridge-secondary-case' value='true' />
            <format attr='enabled' id='bridge-primary-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-case' value='true' />
            <format attr='enabled' id='bridge-trunk-case' value='true' />
            <format attr='enabled' id='bridge-motorway-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link' value='true' />
            <format attr='enabled' id='bridge-motorway_link' value='true' />
            <format attr='enabled' id='bridge-path' value='true' />
            <format attr='enabled' id='bridge-pedestrian' value='true' />
            <format attr='enabled' id='bridge-service-link-track' value='true' />
            <format attr='enabled' id='bridge-street_limited' value='true' />
            <format attr='enabled' id='bridge-street' value='true' />
            <format attr='enabled' id='bridge-tertiary' value='true' />
            <format attr='enabled' id='bridge-secondary' value='true' />
            <format attr='enabled' id='bridge-primary' value='true' />
            <format attr='enabled' id='bridge-trunk' value='true' />
            <format attr='enabled' id='bridge-motorway' value='true' />
            <format attr='enabled' id='bridge-rail' value='true' />
            <format attr='enabled' id='bridge-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2' value='true' />
            <format attr='enabled' id='bridge-trunk-2' value='true' />
            <format attr='enabled' id='bridge-motorway-2' value='true' />
            <format attr='enabled' id='road-shields-2-white' value='true' />
            <format attr='enabled' id='road-shields-2-black' value='true' />
            <format attr='enabled' id='road-shields-1-white' value='true' />
            <format attr='enabled' id='road-shields-1-black' value='true' />
            <format attr='enabled' id='road-label-small' value='true' />
            <format attr='enabled' id='road-label-big' value='true' />
            <format attr='enabled' id='background' value='false' />
            <format attr='enabled' id='barrier_line-land-polygon' value='false' />
            <format attr='enabled' id='barrier_line-land-line' value='false' />
            <format attr='enabled' id='national_park' value='false' />
            <format attr='enabled' id='pitch' value='false' />
            <format attr='enabled' id='industrial' value='false' />
            <format attr='enabled' id='built-up-area' value='false' />
            <format attr='enabled' id='water' value='false' />
            <format attr='enabled' id='waterway-river-canal' value='false' />
            <format attr='enabled' id='aeroway-polygon' value='false' />
            <format attr='enabled' id='aeroway-runway' value='false' />
            <format attr='enabled' id='aeroway-taxiway' value='false' />
            <format attr='enabled' id='parks' value='false' />
            <format attr='enabled' id='landcover_wood' value='false' />
            <format attr='enabled' id='landcover_scrub' value='false' />
            <format attr='enabled' id='landcover_grass' value='false' />
            <format attr='enabled' id='landcover_crop' value='false' />
          </style-rule>
          <style-rule element='map'>
            <format attr='washout' value='0.0' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
            <encodings>
              <color column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_root_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_root_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_cause_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' />
              <text column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]' />
              <lod column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]' />
            </encodings>
            <customized-tooltip>
              <formatted-text>
                <run fontcolor='#787878'>Spill Street Address:&#9;</run>
                <run bold='true' fontsize='12'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>Total Gallons:&#9;</run>
                <run bold='true' fontsize='12'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run fontcolor='#787878'>primary root cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_root_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>secondary root cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_root_cause:nk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run fontcolor='#787878'>primary cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_cause_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>secondary cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause:nk]&gt;</run>
              </formatted-text>
            </customized-tooltip>
            <style>
              <style-rule element='cell'>
                <format attr='wrap' value='on' />
                <format attr='vertical-align' value='bottom' />
              </style-rule>
              <style-rule element='datalabel'>
                <format attr='color-mode' value='user' />
                <format attr='font-weight' value='bold' />
                <format attr='color' value='#000000' />
                <format attr='font-size' value='15' />
              </style-rule>
              <style-rule element='mark'>
                <format attr='mark-labels-show' value='true' />
                <format attr='mark-labels-cull' value='false' />
                <format attr='size' value='1.6811823844909668' />
              </style-rule>
            </style>
          </pane>
        </panes>
        <rows>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:latitude:qk]</rows>
        <cols>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:longitude:qk]</cols>
      </table>
      <simple-id uuid='{E4B47B46-22E6-4816-AAD7-B52914A5193F}' />
    </worksheet>
    <worksheet name='ModelPred'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontsize='32'>Model Prediction</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='pipe_2' name='federated.1meiot20rlt53v14dcxeb1fsiqdw' />
          </datasources>
          <datasource-dependencies datasource='federated.1meiot20rlt53v14dcxeb1fsiqdw'>
            <column caption='Days' datatype='integer' name='[days]' role='measure' type='quantitative' />
            <column caption='Percent Flow' datatype='integer' name='[percent_flow]' role='measure' type='quantitative' />
            <column-instance column='[days]' derivation='Sum' name='[sum:days:qk]' pivot='key' type='quantitative' />
            <column-instance column='[percent_flow]' derivation='Sum' name='[sum:percent_flow:qk]' pivot='key' type='quantitative' />
          </datasource-dependencies>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]' field-type='quantitative' major-origin='0' major-spacing='20' max='80' min='-1' range-type='fixed' scope='cols' type='space' />
            <encoding attr='space' class='0' field='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:percent_flow:qk]' field-type='quantitative' major-origin='0' major-spacing='30' scope='rows' type='space' />
            <format attr='title' class='0' field='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]' scope='cols' value='Days Since Cleaned' />
          </style-rule>
          <style-rule element='label'>
            <format attr='font-weight' field='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]' value='bold' />
            <format attr='font-weight' field='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:percent_flow:qk]' value='bold' />
            <format attr='font-size' field='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:percent_flow:qk]' value='22' />
            <format attr='font-size' field='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]' value='22' />
          </style-rule>
          <style-rule element='refline'>
            <format attr='fill-above' id='refline0' value='#00000000' />
            <format attr='fill-below' id='refline0' value='#00000000' />
            <format attr='fill-above' id='refline1' value='#00000000' />
            <format attr='fill-below' id='refline1' value='#00000000' />
            <format attr='color' id='refline1' value='#e15759' />
            <format attr='stroke-size' id='refline1' value='5' />
            <format attr='stroke-color' id='refline1' value='#e15759' />
            <format attr='stroke-color' id='refline0' value='#000000' />
            <format attr='stroke-size' id='refline0' value='5' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
            <mark-sizing mark-sizing-setting='marks-scaling-off' />
            <reference-line axis-column='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]' enable-instant-analytics='true' formula='constant' id='refline0' label-type='none' scope='per-pane' value='60' value-column='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]' z-order='1' />
            <reference-line axis-column='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:percent_flow:qk]' enable-instant-analytics='true' formula='constant' id='refline1' label-type='none' scope='per-pane' value='20' value-column='[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:percent_flow:qk]' z-order='2' />
            <style>
              <style-rule element='mark'>
                <format attr='shape' value=':filled/circle' />
                <format attr='size' value='1.7251380681991577' />
              </style-rule>
            </style>
          </pane>
        </panes>
        <rows>[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:percent_flow:qk]</rows>
        <cols>[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]</cols>
        <annotations>
          <annotation class='area' id='0' text-pinx='0.5' text-piny='0.5' text-width-delta='-18'>
            <formatted-text>
              <run bold='true' fontsize='25'>Predicted Day is 75.</run>
              <run>Æ&#10;</run>
              <run bold='true' fontsize='25'>Actual is Day 76.</run>
            </formatted-text>
            <top-left>
              <visual-coordinate class='axis'>
                <x-coord axis-value='31.33047210300429'>
                  <node-reference>
                    <axis>[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]</axis>
                  </node-reference>
                </x-coord>
                <y-coord axis-value='99.483471074380162'>
                  <node-reference>
                    <axis>[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:percent_flow:qk]</axis>
                  </node-reference>
                </y-coord>
                <page-reference />
              </visual-coordinate>
            </top-left>
            <bottom-right>
              <visual-coordinate class='axis'>
                <x-coord axis-value='57.472961373390554'>
                  <node-reference>
                    <axis>[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:days:qk]</axis>
                  </node-reference>
                </x-coord>
                <y-coord axis-value='86.366391184573004'>
                  <node-reference>
                    <axis>[federated.1meiot20rlt53v14dcxeb1fsiqdw].[sum:percent_flow:qk]</axis>
                  </node-reference>
                </y-coord>
                <page-reference />
              </visual-coordinate>
            </bottom-right>
            <text x='0.5' y='0.5' />
          </annotation>
        </annotations>
      </table>
      <simple-id uuid='{B7E6C268-D222-4F8C-8588-2479416C7428}' />
    </worksheet>
    <worksheet name='RootByCnt'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontalignment='1' fontcolor='#000000' fontsize='32'>Top Five Root Causes by Frequency</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='sso-location-info.csv+ (Multiple Connections)' name='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny' />
          </datasources>
          <datasource-dependencies datasource='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny'>
            <column datatype='integer' name='[F1]' role='measure' type='quantitative' />
            <column-instance column='[F1]' derivation='Count' name='[cnt:F1:qk]' pivot='key' type='quantitative' />
            <column-instance column='[root_cause]' derivation='None' name='[none:root_cause:nk]' pivot='key' type='nominal' />
            <column caption='Root Cause' datatype='string' name='[root_cause]' role='dimension' type='nominal'>
              <aliases>
                <alias key='&quot;by pass pump leak&quot;' value='bypass' />
              </aliases>
            </column>
          </datasource-dependencies>
          <filter class='categorical' column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]'>
            <groupfilter count='5' end='top' function='end' units='records' user:ui-marker='end' user:ui-top-by-field='true'>
              <groupfilter direction='DESC' expression='COUNT([F1])' function='order' user:ui-marker='order'>
                <groupfilter function='level-members' level='[none:root_cause:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
              </groupfilter>
            </groupfilter>
          </filter>
          <manual-sort column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]' direction='ASC'>
            <dictionary>
              <bucket>&quot;structural&quot;</bucket>
              <bucket>&quot;grease&quot;</bucket>
              <bucket>&quot;debris&quot;</bucket>
              <bucket>&quot;rain event&quot;</bucket>
              <bucket>&quot;contractor&quot;</bucket>
              <bucket>&quot;lift station&quot;</bucket>
              <bucket>&quot;vandalism&quot;</bucket>
              <bucket>&quot;other&quot;</bucket>
              <bucket>&quot;roots&quot;</bucket>
              <bucket>&quot;i/i&quot;</bucket>
              <bucket>&quot;na&quot;</bucket>
              <bucket>&quot;by pass pump leak&quot;</bucket>
              <bucket>%all%</bucket>
            </dictionary>
          </manual-sort>
          <slices>
            <column>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]</column>
          </slices>
          <aggregation value='true' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' field-type='quantitative' major-origin='0' major-spacing='300' scope='cols' type='space' />
            <format attr='title' class='0' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' scope='cols' value='Count of SSO&apos;s' />
          </style-rule>
          <style-rule element='label'>
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' value='22' />
            <format attr='font-weight' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' value='bold' />
            <format attr='font-weight' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]' value='bold' />
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]' value='22' />
            <format attr='color' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]' value='#000000' />
            <format attr='color' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' value='#000000' />
          </style-rule>
          <style-rule element='axis-title'>
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]' value='22' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
          </pane>
        </panes>
        <rows>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]</rows>
        <cols>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[cnt:F1:qk]</cols>
      </table>
      <simple-id uuid='{E73BC5C8-EC32-4BCE-A6E7-0B2386CFD3F5}' />
    </worksheet>
    <worksheet name='RootByGal'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontalignment='1' fontcolor='#000000' fontsize='32'>Top 5 Root Causes by Gallons Spilled</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='sso-location-info.csv+ (Multiple Connections)' name='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny' />
          </datasources>
          <datasource-dependencies datasource='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny'>
            <column-instance column='[root_cause]' derivation='None' name='[none:root_cause:nk]' pivot='key' type='nominal' />
            <column caption='Root Cause' datatype='string' name='[root_cause]' role='dimension' type='nominal'>
              <aliases>
                <alias key='&quot;by pass pump leak&quot;' value='bypass' />
              </aliases>
            </column>
            <column-instance column='[total_gallons]' derivation='Sum' name='[sum:total_gallons:qk]' pivot='key' type='quantitative' />
            <column caption='Total Gallons' datatype='integer' name='[total_gallons]' role='measure' type='quantitative' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]'>
            <groupfilter count='5' end='top' function='end' units='records' user:ui-marker='end' user:ui-top-by-field='true'>
              <groupfilter direction='DESC' expression='SUM([total_gallons])' function='order' user:ui-marker='order'>
                <groupfilter function='level-members' level='[none:root_cause:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
              </groupfilter>
            </groupfilter>
          </filter>
          <manual-sort column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]' direction='ASC'>
            <dictionary>
              <bucket>&quot;rain event&quot;</bucket>
              <bucket>&quot;structural&quot;</bucket>
              <bucket>&quot;contractor&quot;</bucket>
              <bucket>&quot;debris&quot;</bucket>
              <bucket>&quot;lift station&quot;</bucket>
              <bucket>&quot;vandalism&quot;</bucket>
              <bucket>&quot;grease&quot;</bucket>
              <bucket>&quot;other&quot;</bucket>
              <bucket>&quot;roots&quot;</bucket>
              <bucket>&quot;i/i&quot;</bucket>
              <bucket>&quot;by pass pump leak&quot;</bucket>
              <bucket>&quot;na&quot;</bucket>
              <bucket>%all%</bucket>
            </dictionary>
          </manual-sort>
          <slices>
            <column>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]</column>
          </slices>
          <aggregation value='true' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' field-type='quantitative' major-origin='0' major-spacing='20000000' scope='cols' type='space' />
          </style-rule>
          <style-rule element='label'>
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]' value='22' />
            <format attr='font-weight' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]' value='normal' />
            <format attr='color' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]' value='#000000' />
            <format attr='font-size' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' value='22' />
            <format attr='font-weight' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' value='bold' />
            <format attr='color' field='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' value='#000000' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
          </pane>
        </panes>
        <rows>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:root_cause:nk]</rows>
        <cols>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]</cols>
      </table>
      <simple-id uuid='{27D36445-12BF-4AAF-A104-4845E968594C}' />
    </worksheet>
    <worksheet name='Sewersheds'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontalignment='1' fontcolor='#000000' fontsize='32'>SSOs in each Sewershed</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='sso-location-info.csv+ (Multiple Connections)' name='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny' />
          </datasources>
          <mapsources>
            <mapsource name='Tableau' />
          </mapsources>
          <datasource-dependencies datasource='federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny'>
            <column caption='Asset Type' datatype='string' name='[asset_type]' role='dimension' type='nominal' />
            <column-instance column='[asset_type]' derivation='Attribute' name='[attr:asset_type:nk]' pivot='key' type='nominal' />
            <column-instance column='[cause]' derivation='Attribute' name='[attr:cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[root_cause]' derivation='Attribute' name='[attr:root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[lat]' derivation='Avg' name='[avg:lat:qk]' pivot='key' type='quantitative' />
            <column-instance column='[long]' derivation='Avg' name='[avg:long:qk]' pivot='key' type='quantitative' />
            <column caption='Cause' datatype='string' name='[cause]' role='dimension' type='nominal'>
              <aliases>
                <alias key='&quot;i/i&quot;' value='inflow and infiltraion' />
              </aliases>
            </column>
            <column aggregation='Avg' caption='Lat' datatype='real' name='[lat]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
            <column aggregation='Avg' caption='Long' datatype='real' name='[long]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
            <column-instance column='[watershed]' derivation='None' name='[none:watershed:nk]' pivot='key' type='nominal' />
            <column caption='Root Cause' datatype='string' name='[root_cause]' role='dimension' type='nominal'>
              <aliases>
                <alias key='&quot;by pass pump leak&quot;' value='bypass' />
              </aliases>
            </column>
            <column-instance column='[total_gallons]' derivation='Sum' name='[sum:total_gallons:qk]' pivot='key' type='quantitative' />
            <column caption='Total Gallons' datatype='integer' name='[total_gallons]' role='measure' type='quantitative' />
            <column caption='Sewershed' datatype='string' name='[watershed]' role='dimension' type='nominal' />
          </datasource-dependencies>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='legend'>
            <format attr='background-color' value='#f7f1f6' />
            <format attr='font-size' value='15' />
          </style-rule>
          <style-rule element='legend-title'>
            <format attr='font-size' value='20' />
          </style-rule>
          <style-rule element='map-layer'>
            <format attr='enabled' id='building' value='true' />
            <format attr='enabled' id='building-line' value='true' />
            <format attr='enabled' id='place-suburb' value='true' />
            <format attr='enabled' id='place-neighborhood' value='true' />
            <format attr='enabled' id='poi-minor-secondary' value='true' />
            <format attr='enabled' id='poi-minor-primary' value='true' />
            <format attr='enabled' id='poi-main-monuments' value='true' />
            <format attr='enabled' id='poi-main-cemetery' value='true' />
            <format attr='enabled' id='poi-main-greenspace' value='true' />
            <format attr='enabled' id='poi-main-primary' value='true' />
            <format attr='enabled' id='poi-main-peaks' value='true' />
            <format attr='enabled' id='poi-rail' value='true' />
            <format attr='enabled' id='airport-label' value='true' />
            <format attr='enabled' id='place-village' value='true' />
            <format attr='enabled' id='place-town' value='true' />
            <format attr='enabled' id='place-islands' value='true' />
            <format attr='enabled' id='place-city-sm' value='true' />
            <format attr='enabled' id='place-city-md-s' value='true' />
            <format attr='enabled' id='place-city-md-n' value='true' />
            <format attr='enabled' id='place-city-lg-s' value='true' />
            <format attr='enabled' id='place-city-lg-n' value='true' />
            <format attr='enabled' id='place-capital-s' value='true' />
            <format attr='enabled' id='place-capital-n' value='true' />
            <format attr='enabled' id='marine-label-sm-ln' value='true' />
            <format attr='enabled' id='marine-label-sm-pt' value='true' />
            <format attr='enabled' id='marine-label-md-ln' value='true' />
            <format attr='enabled' id='marine-label-md-pt' value='true' />
            <format attr='enabled' id='marine-label-lg-ln' value='true' />
            <format attr='enabled' id='marine-label-lg-pt' value='true' />
            <format attr='enabled' id='water-label' value='true' />
            <format attr='enabled' id='Zip Code Labels' value='true' />
            <format attr='enabled' id='Zip Code Boundaries' value='true' />
            <format attr='enabled' id='admin-2-label' value='true' />
            <format attr='enabled' id='admin-2-boundaries-bg' value='true' />
            <format attr='enabled' id='admin-2-boundaries' value='true' />
            <format attr='enabled' id='admin-1-label-9th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-8th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-7th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-6th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-1st-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-3rd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-2nd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute-sub' value='false' />
            <format attr='enabled' id='admin-0-boundaries-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents' value='false' />
            <format attr='enabled' id='admin1-water-lines-usa-tableau' value='false' />
            <format attr='enabled' id='9-dash-line-casing' value='false' />
            <format attr='enabled' id='9-dash-line' value='false' />
            <format attr='enabled' id='admin-0-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute' value='false' />
            <format attr='enabled' id='tunnel-service-link-track-case' value='true' />
            <format attr='enabled' id='tunnel-street_limited-case' value='true' />
            <format attr='enabled' id='tunnel-street-case' value='true' />
            <format attr='enabled' id='tunnel-secondary-tertiary-case' value='true' />
            <format attr='enabled' id='tunnel-primary-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link-case' value='true' />
            <format attr='enabled' id='tunnel-motorway_link-case' value='true' />
            <format attr='enabled' id='tunnel-trunk-case' value='true' />
            <format attr='enabled' id='tunnel-motorway-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link' value='true' />
            <format attr='enabled' id='tunnel-motorway_link' value='true' />
            <format attr='enabled' id='tunnel-service-link-track' value='true' />
            <format attr='enabled' id='tunnel-street_limited' value='true' />
            <format attr='enabled' id='tunnel-street' value='true' />
            <format attr='enabled' id='tunnel-tertiary' value='true' />
            <format attr='enabled' id='tunnel-secondary' value='true' />
            <format attr='enabled' id='tunnel-primary' value='true' />
            <format attr='enabled' id='tunnel-trunk' value='true' />
            <format attr='enabled' id='tunnel-motorway' value='true' />
            <format attr='enabled' id='road-street-low' value='true' />
            <format attr='enabled' id='road-street_limited-low' value='true' />
            <format attr='enabled' id='road-pedestrian-case' value='true' />
            <format attr='enabled' id='road-service-link-track-case' value='true' />
            <format attr='enabled' id='road-street_limited-case' value='true' />
            <format attr='enabled' id='road-street-case' value='true' />
            <format attr='enabled' id='road-tertiary-case' value='true' />
            <format attr='enabled' id='road-secondary-case' value='true' />
            <format attr='enabled' id='road-primary-case' value='true' />
            <format attr='enabled' id='road-motorway_link-case' value='true' />
            <format attr='enabled' id='road-trunk_link-case' value='true' />
            <format attr='enabled' id='road-trunk-case' value='true' />
            <format attr='enabled' id='road-motorway-case' value='true' />
            <format attr='enabled' id='road-trunk_link' value='true' />
            <format attr='enabled' id='road-motorway_link' value='true' />
            <format attr='enabled' id='road-path' value='true' />
            <format attr='enabled' id='road-pedestrian' value='true' />
            <format attr='enabled' id='road-polygon' value='true' />
            <format attr='enabled' id='road-service-link-track' value='true' />
            <format attr='enabled' id='road-street_limited' value='true' />
            <format attr='enabled' id='road-street' value='true' />
            <format attr='enabled' id='road-tertiary' value='true' />
            <format attr='enabled' id='road-secondary' value='true' />
            <format attr='enabled' id='road-primary' value='true' />
            <format attr='enabled' id='road-trunk' value='true' />
            <format attr='enabled' id='road-motorway' value='true' />
            <format attr='enabled' id='road-rail' value='true' />
            <format attr='enabled' id='road-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-street-low' value='true' />
            <format attr='enabled' id='bridge-street_limited-low' value='true' />
            <format attr='enabled' id='bridge-pedestrian-case' value='true' />
            <format attr='enabled' id='bridge-service-link-track-case' value='true' />
            <format attr='enabled' id='bridge-street_limited-case' value='true' />
            <format attr='enabled' id='bridge-street-case' value='true' />
            <format attr='enabled' id='bridge-tertiary-case' value='true' />
            <format attr='enabled' id='bridge-secondary-case' value='true' />
            <format attr='enabled' id='bridge-primary-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-case' value='true' />
            <format attr='enabled' id='bridge-trunk-case' value='true' />
            <format attr='enabled' id='bridge-motorway-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link' value='true' />
            <format attr='enabled' id='bridge-motorway_link' value='true' />
            <format attr='enabled' id='bridge-path' value='true' />
            <format attr='enabled' id='bridge-pedestrian' value='true' />
            <format attr='enabled' id='bridge-service-link-track' value='true' />
            <format attr='enabled' id='bridge-street_limited' value='true' />
            <format attr='enabled' id='bridge-street' value='true' />
            <format attr='enabled' id='bridge-tertiary' value='true' />
            <format attr='enabled' id='bridge-secondary' value='true' />
            <format attr='enabled' id='bridge-primary' value='true' />
            <format attr='enabled' id='bridge-trunk' value='true' />
            <format attr='enabled' id='bridge-motorway' value='true' />
            <format attr='enabled' id='bridge-rail' value='true' />
            <format attr='enabled' id='bridge-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2' value='true' />
            <format attr='enabled' id='bridge-trunk-2' value='true' />
            <format attr='enabled' id='bridge-motorway-2' value='true' />
            <format attr='enabled' id='road-shields-2-white' value='true' />
            <format attr='enabled' id='road-shields-2-black' value='true' />
            <format attr='enabled' id='road-shields-1-white' value='true' />
            <format attr='enabled' id='road-shields-1-black' value='true' />
            <format attr='enabled' id='road-label-small' value='true' />
            <format attr='enabled' id='road-label-big' value='true' />
            <format attr='enabled' id='background' value='false' />
            <format attr='enabled' id='barrier_line-land-polygon' value='false' />
            <format attr='enabled' id='barrier_line-land-line' value='false' />
            <format attr='enabled' id='national_park' value='false' />
            <format attr='enabled' id='pitch' value='false' />
            <format attr='enabled' id='industrial' value='false' />
            <format attr='enabled' id='built-up-area' value='false' />
            <format attr='enabled' id='water' value='false' />
            <format attr='enabled' id='waterway-river-canal' value='false' />
            <format attr='enabled' id='aeroway-polygon' value='false' />
            <format attr='enabled' id='aeroway-runway' value='false' />
            <format attr='enabled' id='aeroway-taxiway' value='false' />
            <format attr='enabled' id='parks' value='false' />
            <format attr='enabled' id='landcover_wood' value='false' />
            <format attr='enabled' id='landcover_scrub' value='false' />
            <format attr='enabled' id='landcover_grass' value='false' />
            <format attr='enabled' id='landcover_crop' value='false' />
          </style-rule>
          <style-rule element='map'>
            <format attr='washout' value='0.0' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
            <encodings>
              <color column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:watershed:nk]' />
              <tooltip column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[attr:asset_type:nk]' />
              <tooltip column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[attr:root_cause:nk]' />
              <tooltip column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[attr:cause:nk]' />
              <tooltip column='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[sum:total_gallons:qk]' />
            </encodings>
            <customized-tooltip>
              <formatted-text>
                <run fontcolor='#787878'>Sewershed:&#9;</run>
                <run bold='true'>&lt;[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:watershed:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>Asset Type:&#9;</run>
                <run bold='true'>&lt;[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[attr:asset_type:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>Root Cause:&#9;</run>
                <run bold='true'>&lt;[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[attr:root_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>Cause:&#9;</run>
                <run bold='true'>&lt;[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[attr:cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>Total Gallons:&#9;</run>
              </formatted-text>
            </customized-tooltip>
          </pane>
        </panes>
        <rows>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[avg:lat:qk]</rows>
        <cols>[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[avg:long:qk]</cols>
      </table>
      <simple-id uuid='{66BA65BD-7846-48AC-A93D-BB94B3B28213}' />
    </worksheet>
    <worksheet name='TopFreqMap'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontcolor='#000000' fontsize='32'>10 Most Frequent Locations of SSOs</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='Sheet1 (sso_most_frequent_lat_long)' name='federated.0z4t00e1mynjhf199g7rp0l6qucy' />
          </datasources>
          <mapsources>
            <mapsource name='Tableau' />
          </mapsources>
          <datasource-dependencies datasource='federated.0z4t00e1mynjhf199g7rp0l6qucy'>
            <column caption='Address' datatype='string' name='[address]' role='dimension' type='nominal' />
            <column-instance column='[prim_cause_perc]' derivation='Attribute' name='[attr:prim_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[prim_perc]' derivation='Attribute' name='[attr:prim_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='Attribute' name='[attr:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='Attribute' name='[attr:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause]' derivation='Attribute' name='[attr:sec_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause_perc]' derivation='Attribute' name='[attr:sec_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_perc]' derivation='Attribute' name='[attr:sec_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_root_cause]' derivation='Attribute' name='[attr:sec_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[latitude]' derivation='Avg' name='[avg:latitude:qk]' pivot='key' type='quantitative' />
            <column-instance column='[longitude]' derivation='Avg' name='[avg:longitude:qk]' pivot='key' type='quantitative' />
            <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
            <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
            <column-instance column='[address]' derivation='None' name='[none:address:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='None' name='[none:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='None' name='[none:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column caption='Number Of Sso' datatype='integer' name='[number_of_sso]' role='measure' type='quantitative' />
            <column datatype='string' name='[prim_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[prim_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_root_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_root_cause]' role='dimension' type='nominal' />
            <column-instance column='[number_of_sso]' derivation='Sum' name='[sum:number_of_sso:qk]' pivot='key' type='quantitative' />
          </datasource-dependencies>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]'>
            <groupfilter function='level-members' level='[none:address:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]'>
            <groupfilter function='level-members' level='[none:primary_cause:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
          </filter>
          <filter class='categorical' column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]'>
            <groupfilter function='level-members' level='[none:primary_root_cause:nk]' user:ui-enumeration='all' user:ui-marker='enumerate' />
          </filter>
          <slices>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]</column>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]</column>
            <column>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]</column>
          </slices>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]' field-type='quantitative' max='-10945382.054907417' min='-10992523.896791384' projection='EPSG:3857' range-type='fixed' scope='cols' type='space' />
            <encoding attr='space' class='0' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]' field-type='quantitative' max='3452440.7048851335' min='3417492.8873981102' projection='EPSG:3857' range-type='fixed' scope='rows' type='space' />
          </style-rule>
          <style-rule element='mark'>
            <encoding attr='color' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' palette='red_10_0' type='interpolated' />
            <encoding attr='size' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' field-type='quantitative' max-size='1' min-size='0' type='quantsize' />
          </style-rule>
          <style-rule element='legend-title-text'>
            <format attr='color' field='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' value='Number Of SSOs'>
              <formatted-text>
                <run>Number Of SSOs</run>
              </formatted-text>
            </format>
          </style-rule>
          <style-rule element='map-layer'>
            <format attr='enabled' id='place-village' value='true' />
            <format attr='enabled' id='place-town' value='true' />
            <format attr='enabled' id='place-islands' value='true' />
            <format attr='enabled' id='place-city-sm' value='true' />
            <format attr='enabled' id='place-city-md-s' value='true' />
            <format attr='enabled' id='place-city-md-n' value='true' />
            <format attr='enabled' id='place-city-lg-s' value='true' />
            <format attr='enabled' id='place-city-lg-n' value='true' />
            <format attr='enabled' id='place-capital-s' value='true' />
            <format attr='enabled' id='place-capital-n' value='true' />
            <format attr='enabled' id='marine-label-sm-ln' value='true' />
            <format attr='enabled' id='marine-label-sm-pt' value='true' />
            <format attr='enabled' id='marine-label-md-ln' value='true' />
            <format attr='enabled' id='marine-label-md-pt' value='true' />
            <format attr='enabled' id='marine-label-lg-ln' value='true' />
            <format attr='enabled' id='marine-label-lg-pt' value='true' />
            <format attr='enabled' id='water-label' value='true' />
            <format attr='enabled' id='Zip Code Labels' value='true' />
            <format attr='enabled' id='Zip Code Boundaries' value='true' />
            <format attr='enabled' id='admin-2-label' value='true' />
            <format attr='enabled' id='admin-2-boundaries-bg' value='true' />
            <format attr='enabled' id='admin-2-boundaries' value='true' />
            <format attr='enabled' id='admin-1-label-9th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-8th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-7th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-6th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-1st-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-3rd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-2nd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute-sub' value='false' />
            <format attr='enabled' id='admin-0-boundaries-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents' value='false' />
            <format attr='enabled' id='admin1-water-lines-usa-tableau' value='false' />
            <format attr='enabled' id='9-dash-line-casing' value='false' />
            <format attr='enabled' id='9-dash-line' value='false' />
            <format attr='enabled' id='admin-0-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute' value='false' />
            <format attr='enabled' id='tunnel-service-link-track-case' value='true' />
            <format attr='enabled' id='tunnel-street_limited-case' value='true' />
            <format attr='enabled' id='tunnel-street-case' value='true' />
            <format attr='enabled' id='tunnel-secondary-tertiary-case' value='true' />
            <format attr='enabled' id='tunnel-primary-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link-case' value='true' />
            <format attr='enabled' id='tunnel-motorway_link-case' value='true' />
            <format attr='enabled' id='tunnel-trunk-case' value='true' />
            <format attr='enabled' id='tunnel-motorway-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link' value='true' />
            <format attr='enabled' id='tunnel-motorway_link' value='true' />
            <format attr='enabled' id='tunnel-service-link-track' value='true' />
            <format attr='enabled' id='tunnel-street_limited' value='true' />
            <format attr='enabled' id='tunnel-street' value='true' />
            <format attr='enabled' id='tunnel-tertiary' value='true' />
            <format attr='enabled' id='tunnel-secondary' value='true' />
            <format attr='enabled' id='tunnel-primary' value='true' />
            <format attr='enabled' id='tunnel-trunk' value='true' />
            <format attr='enabled' id='tunnel-motorway' value='true' />
            <format attr='enabled' id='road-street-low' value='true' />
            <format attr='enabled' id='road-street_limited-low' value='true' />
            <format attr='enabled' id='road-pedestrian-case' value='true' />
            <format attr='enabled' id='road-service-link-track-case' value='true' />
            <format attr='enabled' id='road-street_limited-case' value='true' />
            <format attr='enabled' id='road-street-case' value='true' />
            <format attr='enabled' id='road-tertiary-case' value='true' />
            <format attr='enabled' id='road-secondary-case' value='true' />
            <format attr='enabled' id='road-primary-case' value='true' />
            <format attr='enabled' id='road-motorway_link-case' value='true' />
            <format attr='enabled' id='road-trunk_link-case' value='true' />
            <format attr='enabled' id='road-trunk-case' value='true' />
            <format attr='enabled' id='road-motorway-case' value='true' />
            <format attr='enabled' id='road-trunk_link' value='true' />
            <format attr='enabled' id='road-motorway_link' value='true' />
            <format attr='enabled' id='road-path' value='true' />
            <format attr='enabled' id='road-pedestrian' value='true' />
            <format attr='enabled' id='road-polygon' value='true' />
            <format attr='enabled' id='road-service-link-track' value='true' />
            <format attr='enabled' id='road-street_limited' value='true' />
            <format attr='enabled' id='road-street' value='true' />
            <format attr='enabled' id='road-tertiary' value='true' />
            <format attr='enabled' id='road-secondary' value='true' />
            <format attr='enabled' id='road-primary' value='true' />
            <format attr='enabled' id='road-trunk' value='true' />
            <format attr='enabled' id='road-motorway' value='true' />
            <format attr='enabled' id='road-rail' value='true' />
            <format attr='enabled' id='road-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-street-low' value='true' />
            <format attr='enabled' id='bridge-street_limited-low' value='true' />
            <format attr='enabled' id='bridge-pedestrian-case' value='true' />
            <format attr='enabled' id='bridge-service-link-track-case' value='true' />
            <format attr='enabled' id='bridge-street_limited-case' value='true' />
            <format attr='enabled' id='bridge-street-case' value='true' />
            <format attr='enabled' id='bridge-tertiary-case' value='true' />
            <format attr='enabled' id='bridge-secondary-case' value='true' />
            <format attr='enabled' id='bridge-primary-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-case' value='true' />
            <format attr='enabled' id='bridge-trunk-case' value='true' />
            <format attr='enabled' id='bridge-motorway-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link' value='true' />
            <format attr='enabled' id='bridge-motorway_link' value='true' />
            <format attr='enabled' id='bridge-path' value='true' />
            <format attr='enabled' id='bridge-pedestrian' value='true' />
            <format attr='enabled' id='bridge-service-link-track' value='true' />
            <format attr='enabled' id='bridge-street_limited' value='true' />
            <format attr='enabled' id='bridge-street' value='true' />
            <format attr='enabled' id='bridge-tertiary' value='true' />
            <format attr='enabled' id='bridge-secondary' value='true' />
            <format attr='enabled' id='bridge-primary' value='true' />
            <format attr='enabled' id='bridge-trunk' value='true' />
            <format attr='enabled' id='bridge-motorway' value='true' />
            <format attr='enabled' id='bridge-rail' value='true' />
            <format attr='enabled' id='bridge-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2' value='true' />
            <format attr='enabled' id='bridge-trunk-2' value='true' />
            <format attr='enabled' id='bridge-motorway-2' value='true' />
            <format attr='enabled' id='road-shields-2-white' value='true' />
            <format attr='enabled' id='road-shields-2-black' value='true' />
            <format attr='enabled' id='road-shields-1-white' value='true' />
            <format attr='enabled' id='road-shields-1-black' value='true' />
            <format attr='enabled' id='road-label-small' value='true' />
            <format attr='enabled' id='road-label-big' value='true' />
            <format attr='enabled' id='parks' value='false' />
            <format attr='enabled' id='landcover_wood' value='false' />
            <format attr='enabled' id='landcover_scrub' value='false' />
            <format attr='enabled' id='landcover_grass' value='false' />
            <format attr='enabled' id='landcover_crop' value='false' />
            <format attr='enabled' id='background' value='false' />
            <format attr='enabled' id='barrier_line-land-polygon' value='false' />
            <format attr='enabled' id='barrier_line-land-line' value='false' />
            <format attr='enabled' id='national_park' value='false' />
            <format attr='enabled' id='pitch' value='false' />
            <format attr='enabled' id='industrial' value='false' />
            <format attr='enabled' id='built-up-area' value='false' />
            <format attr='enabled' id='water' value='false' />
            <format attr='enabled' id='waterway-river-canal' value='false' />
            <format attr='enabled' id='aeroway-polygon' value='false' />
            <format attr='enabled' id='aeroway-runway' value='false' />
            <format attr='enabled' id='aeroway-taxiway' value='false' />
          </style-rule>
          <style-rule element='map'>
            <format attr='washout' value='0.0' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='off' />
            </view>
            <mark class='Automatic' />
            <encodings>
              <color column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_root_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_root_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_cause_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_perc:nk]' />
              <tooltip column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause_perc:nk]' />
              <text column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' />
              <lod column='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' />
            </encodings>
            <customized-tooltip>
              <formatted-text>
                <run>Address:</run>
                <run bold='true' fontsize='12'> &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]&gt;</run>
                <run>&#10;# SSOs:</run>
                <run bold='true'>Æ </run>
                <run bold='true' fontsize='12'>&lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]&gt;</run>
                <run>&#10;&#10;Primary Root Cause:</run>
                <run bold='true'>   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_root_cause:nk]&gt;</run>
                <run>&#10;Secondary Root Cause: </run>
                <run bold='true'>  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_root_cause:nk]&gt;</run>
                <run>&#10;&#10;Primary Cause: </run>
                <run bold='true'>  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:prim_cause_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:primary_cause:nk]&gt;</run>
                <run>&#10;Secondary Cause:</run>
                <run bold='true'>   &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause_perc:nk]&gt;  &lt;[federated.0z4t00e1mynjhf199g7rp0l6qucy].[attr:sec_cause:nk]&gt;</run>
              </formatted-text>
            </customized-tooltip>
            <style>
              <style-rule element='cell'>
                <format attr='wrap' value='on' />
                <format attr='text-align' value='center' />
                <format attr='vertical-align' value='bottom' />
              </style-rule>
              <style-rule element='datalabel'>
                <format attr='color-mode' value='auto' />
                <format attr='font-weight' value='bold' />
                <format attr='font-size' value='15' />
              </style-rule>
              <style-rule element='mark'>
                <format attr='size' value='2.2382433414459229' />
                <format attr='mark-labels-cull' value='false' />
                <format attr='mark-labels-show' value='true' />
              </style-rule>
            </style>
          </pane>
        </panes>
        <rows>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:latitude:qk]</rows>
        <cols>[federated.0z4t00e1mynjhf199g7rp0l6qucy].[avg:longitude:qk]</cols>
      </table>
      <simple-id uuid='{5B9B5856-0282-4F55-8262-2A53DC194491}' />
    </worksheet>
    <worksheet name='TopGalMap'>
      <layout-options>
        <title>
          <formatted-text>
            <run bold='true' fontcolor='#000000' fontsize='32'>10 Locations Spilling Most Sewage</run>
          </formatted-text>
        </title>
      </layout-options>
      <table>
        <view>
          <datasources>
            <datasource caption='most_gallons' name='federated.0gv4ky81v0fz3r12lfxyn0fepy1v' />
          </datasources>
          <mapsources>
            <mapsource name='Tableau' />
          </mapsources>
          <datasource-dependencies datasource='federated.0gv4ky81v0fz3r12lfxyn0fepy1v'>
            <column-instance column='[prim_cause_perc]' derivation='Attribute' name='[attr:prim_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[prim_perc]' derivation='Attribute' name='[attr:prim_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_cause]' derivation='Attribute' name='[attr:primary_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[primary_root_cause]' derivation='Attribute' name='[attr:primary_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause]' derivation='Attribute' name='[attr:sec_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_cause_perc]' derivation='Attribute' name='[attr:sec_cause_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_perc]' derivation='Attribute' name='[attr:sec_perc:nk]' pivot='key' type='nominal' />
            <column-instance column='[sec_root_cause]' derivation='Attribute' name='[attr:sec_root_cause:nk]' pivot='key' type='nominal' />
            <column-instance column='[latitude]' derivation='Avg' name='[avg:latitude:qk]' pivot='key' type='quantitative' />
            <column-instance column='[longitude]' derivation='Avg' name='[avg:longitude:qk]' pivot='key' type='quantitative' />
            <column aggregation='Avg' caption='Latitude' datatype='real' name='[latitude]' role='measure' semantic-role='[Geographical].[Latitude]' type='quantitative' />
            <column aggregation='Avg' caption='Longitude' datatype='real' name='[longitude]' role='measure' semantic-role='[Geographical].[Longitude]' type='quantitative' />
            <column-instance column='[spill_street_address]' derivation='None' name='[none:spill_street_address:nk]' pivot='key' type='nominal' />
            <column datatype='string' name='[prim_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[prim_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[primary_root_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_cause_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_perc]' role='dimension' type='nominal' />
            <column datatype='string' name='[sec_root_cause]' role='dimension' type='nominal' />
            <column caption='Spill Street Address' datatype='string' name='[spill_street_address]' role='dimension' type='nominal' />
            <column-instance column='[total_gallons]' derivation='Sum' name='[sum:total_gallons:qk]' pivot='key' type='quantitative' />
            <column caption='Total Gallons' datatype='integer' name='[total_gallons]' role='measure' type='quantitative' />
          </datasource-dependencies>
          <aggregation value='false' />
        </view>
        <style>
          <style-rule element='axis'>
            <encoding attr='space' class='0' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:longitude:qk]' field-type='quantitative' max='-10942857.771485897' min='-10987914.574620845' projection='EPSG:3857' range-type='fixed' scope='cols' type='space' />
            <encoding attr='space' class='0' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:latitude:qk]' field-type='quantitative' max='3447496.5683385003' min='3415336.023398933' projection='EPSG:3857' range-type='fixed' scope='rows' type='space' />
          </style-rule>
          <style-rule element='mark'>
            <encoding attr='size' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' field-type='quantitative' max-size='1' min-size='0' type='quantsize' />
            <encoding attr='color' field='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' palette='blue_10_0' type='interpolated' />
          </style-rule>
          <style-rule element='map-layer'>
            <format attr='enabled' id='building' value='true' />
            <format attr='enabled' id='building-line' value='true' />
            <format attr='enabled' id='place-suburb' value='true' />
            <format attr='enabled' id='place-neighborhood' value='true' />
            <format attr='enabled' id='poi-minor-secondary' value='true' />
            <format attr='enabled' id='poi-minor-primary' value='true' />
            <format attr='enabled' id='poi-main-monuments' value='true' />
            <format attr='enabled' id='poi-main-cemetery' value='true' />
            <format attr='enabled' id='poi-main-greenspace' value='true' />
            <format attr='enabled' id='poi-main-primary' value='true' />
            <format attr='enabled' id='poi-main-peaks' value='true' />
            <format attr='enabled' id='poi-rail' value='true' />
            <format attr='enabled' id='airport-label' value='true' />
            <format attr='enabled' id='place-village' value='true' />
            <format attr='enabled' id='place-town' value='true' />
            <format attr='enabled' id='place-islands' value='true' />
            <format attr='enabled' id='place-city-sm' value='true' />
            <format attr='enabled' id='place-city-md-s' value='true' />
            <format attr='enabled' id='place-city-md-n' value='true' />
            <format attr='enabled' id='place-city-lg-s' value='true' />
            <format attr='enabled' id='place-city-lg-n' value='true' />
            <format attr='enabled' id='place-capital-s' value='true' />
            <format attr='enabled' id='place-capital-n' value='true' />
            <format attr='enabled' id='marine-label-sm-ln' value='true' />
            <format attr='enabled' id='marine-label-sm-pt' value='true' />
            <format attr='enabled' id='marine-label-md-ln' value='true' />
            <format attr='enabled' id='marine-label-md-pt' value='true' />
            <format attr='enabled' id='marine-label-lg-ln' value='true' />
            <format attr='enabled' id='marine-label-lg-pt' value='true' />
            <format attr='enabled' id='water-label' value='true' />
            <format attr='enabled' id='Zip Code Labels' value='true' />
            <format attr='enabled' id='Zip Code Boundaries' value='true' />
            <format attr='enabled' id='admin-2-label' value='true' />
            <format attr='enabled' id='admin-2-boundaries-bg' value='true' />
            <format attr='enabled' id='admin-2-boundaries' value='true' />
            <format attr='enabled' id='admin-1-label-9th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-8th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-7th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-6th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-1-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-1-label-1st-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-3rd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-2nd-tier' value='false' />
            <format attr='enabled' id='us-admin-1-label-abbr-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents-bg' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute-sub' value='false' />
            <format attr='enabled' id='admin-0-boundaries-sub' value='false' />
            <format attr='enabled' id='admin-1-boundaries-supress' value='false' />
            <format attr='enabled' id='admin-1-boundaries-sm-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-md-parents' value='false' />
            <format attr='enabled' id='admin-1-boundaries-lg-parents' value='false' />
            <format attr='enabled' id='admin1-water-lines-usa-tableau' value='false' />
            <format attr='enabled' id='9-dash-line-casing' value='false' />
            <format attr='enabled' id='9-dash-line' value='false' />
            <format attr='enabled' id='admin-0-label-5th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-4th-tier' value='false' />
            <format attr='enabled' id='admin-0-label-3rd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-2nd-tier' value='false' />
            <format attr='enabled' id='admin-0-label-1st-tier' value='false' />
            <format attr='enabled' id='admin-0-boundaries-bg' value='false' />
            <format attr='enabled' id='admin-0-boundaries' value='false' />
            <format attr='enabled' id='admin-0-boundaries-dispute' value='false' />
            <format attr='enabled' id='tunnel-service-link-track-case' value='true' />
            <format attr='enabled' id='tunnel-street_limited-case' value='true' />
            <format attr='enabled' id='tunnel-street-case' value='true' />
            <format attr='enabled' id='tunnel-secondary-tertiary-case' value='true' />
            <format attr='enabled' id='tunnel-primary-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link-case' value='true' />
            <format attr='enabled' id='tunnel-motorway_link-case' value='true' />
            <format attr='enabled' id='tunnel-trunk-case' value='true' />
            <format attr='enabled' id='tunnel-motorway-case' value='true' />
            <format attr='enabled' id='tunnel-trunk_link' value='true' />
            <format attr='enabled' id='tunnel-motorway_link' value='true' />
            <format attr='enabled' id='tunnel-service-link-track' value='true' />
            <format attr='enabled' id='tunnel-street_limited' value='true' />
            <format attr='enabled' id='tunnel-street' value='true' />
            <format attr='enabled' id='tunnel-tertiary' value='true' />
            <format attr='enabled' id='tunnel-secondary' value='true' />
            <format attr='enabled' id='tunnel-primary' value='true' />
            <format attr='enabled' id='tunnel-trunk' value='true' />
            <format attr='enabled' id='tunnel-motorway' value='true' />
            <format attr='enabled' id='road-street-low' value='true' />
            <format attr='enabled' id='road-street_limited-low' value='true' />
            <format attr='enabled' id='road-pedestrian-case' value='true' />
            <format attr='enabled' id='road-service-link-track-case' value='true' />
            <format attr='enabled' id='road-street_limited-case' value='true' />
            <format attr='enabled' id='road-street-case' value='true' />
            <format attr='enabled' id='road-tertiary-case' value='true' />
            <format attr='enabled' id='road-secondary-case' value='true' />
            <format attr='enabled' id='road-primary-case' value='true' />
            <format attr='enabled' id='road-motorway_link-case' value='true' />
            <format attr='enabled' id='road-trunk_link-case' value='true' />
            <format attr='enabled' id='road-trunk-case' value='true' />
            <format attr='enabled' id='road-motorway-case' value='true' />
            <format attr='enabled' id='road-trunk_link' value='true' />
            <format attr='enabled' id='road-motorway_link' value='true' />
            <format attr='enabled' id='road-path' value='true' />
            <format attr='enabled' id='road-pedestrian' value='true' />
            <format attr='enabled' id='road-polygon' value='true' />
            <format attr='enabled' id='road-service-link-track' value='true' />
            <format attr='enabled' id='road-street_limited' value='true' />
            <format attr='enabled' id='road-street' value='true' />
            <format attr='enabled' id='road-tertiary' value='true' />
            <format attr='enabled' id='road-secondary' value='true' />
            <format attr='enabled' id='road-primary' value='true' />
            <format attr='enabled' id='road-trunk' value='true' />
            <format attr='enabled' id='road-motorway' value='true' />
            <format attr='enabled' id='road-rail' value='true' />
            <format attr='enabled' id='road-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-street-low' value='true' />
            <format attr='enabled' id='bridge-street_limited-low' value='true' />
            <format attr='enabled' id='bridge-pedestrian-case' value='true' />
            <format attr='enabled' id='bridge-service-link-track-case' value='true' />
            <format attr='enabled' id='bridge-street_limited-case' value='true' />
            <format attr='enabled' id='bridge-street-case' value='true' />
            <format attr='enabled' id='bridge-tertiary-case' value='true' />
            <format attr='enabled' id='bridge-secondary-case' value='true' />
            <format attr='enabled' id='bridge-primary-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-case' value='true' />
            <format attr='enabled' id='bridge-trunk-case' value='true' />
            <format attr='enabled' id='bridge-motorway-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link' value='true' />
            <format attr='enabled' id='bridge-motorway_link' value='true' />
            <format attr='enabled' id='bridge-path' value='true' />
            <format attr='enabled' id='bridge-pedestrian' value='true' />
            <format attr='enabled' id='bridge-service-link-track' value='true' />
            <format attr='enabled' id='bridge-street_limited' value='true' />
            <format attr='enabled' id='bridge-street' value='true' />
            <format attr='enabled' id='bridge-tertiary' value='true' />
            <format attr='enabled' id='bridge-secondary' value='true' />
            <format attr='enabled' id='bridge-primary' value='true' />
            <format attr='enabled' id='bridge-trunk' value='true' />
            <format attr='enabled' id='bridge-motorway' value='true' />
            <format attr='enabled' id='bridge-rail' value='true' />
            <format attr='enabled' id='bridge-rail-tracks' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk-2-case' value='true' />
            <format attr='enabled' id='bridge-motorway-2-case' value='true' />
            <format attr='enabled' id='bridge-trunk_link-2' value='true' />
            <format attr='enabled' id='bridge-motorway_link-2' value='true' />
            <format attr='enabled' id='bridge-trunk-2' value='true' />
            <format attr='enabled' id='bridge-motorway-2' value='true' />
            <format attr='enabled' id='road-shields-2-white' value='true' />
            <format attr='enabled' id='road-shields-2-black' value='true' />
            <format attr='enabled' id='road-shields-1-white' value='true' />
            <format attr='enabled' id='road-shields-1-black' value='true' />
            <format attr='enabled' id='road-label-small' value='true' />
            <format attr='enabled' id='road-label-big' value='true' />
            <format attr='enabled' id='background' value='false' />
            <format attr='enabled' id='barrier_line-land-polygon' value='false' />
            <format attr='enabled' id='barrier_line-land-line' value='false' />
            <format attr='enabled' id='national_park' value='false' />
            <format attr='enabled' id='pitch' value='false' />
            <format attr='enabled' id='industrial' value='false' />
            <format attr='enabled' id='built-up-area' value='false' />
            <format attr='enabled' id='water' value='false' />
            <format attr='enabled' id='waterway-river-canal' value='false' />
            <format attr='enabled' id='aeroway-polygon' value='false' />
            <format attr='enabled' id='aeroway-runway' value='false' />
            <format attr='enabled' id='aeroway-taxiway' value='false' />
            <format attr='enabled' id='parks' value='false' />
            <format attr='enabled' id='landcover_wood' value='false' />
            <format attr='enabled' id='landcover_scrub' value='false' />
            <format attr='enabled' id='landcover_grass' value='false' />
            <format attr='enabled' id='landcover_crop' value='false' />
          </style-rule>
          <style-rule element='map'>
            <format attr='washout' value='0.0' />
          </style-rule>
        </style>
        <panes>
          <pane selection-relaxation-option='selection-relaxation-allow'>
            <view>
              <breakdown value='auto' />
            </view>
            <mark class='Automatic' />
            <encodings>
              <color column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_root_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_root_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_cause_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause_perc:nk]' />
              <tooltip column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' />
              <text column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]' />
              <lod column='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]' />
            </encodings>
            <customized-tooltip>
              <formatted-text>
                <run fontcolor='#787878'>Spill Street Address:&#9;</run>
                <run bold='true' fontsize='12'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:spill_street_address:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>Total Gallons:&#9;</run>
                <run bold='true' fontsize='12'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run fontcolor='#787878'>primary root cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_root_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>secondary root cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_root_cause:nk]&gt;</run>
                <run>Æ&#10;&#10;</run>
                <run fontcolor='#787878'>primary cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:prim_cause_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:primary_cause:nk]&gt;</run>
                <run>Æ&#10;</run>
                <run fontcolor='#787878'>secondary cause:  </run>
                <run bold='true'>&lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause_perc:nk]&gt;  &lt;[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[attr:sec_cause:nk]&gt;</run>
              </formatted-text>
            </customized-tooltip>
            <style>
              <style-rule element='cell'>
                <format attr='wrap' value='on' />
                <format attr='vertical-align' value='bottom' />
              </style-rule>
              <style-rule element='datalabel'>
                <format attr='color-mode' value='user' />
                <format attr='font-weight' value='bold' />
                <format attr='color' value='#000000' />
                <format attr='font-size' value='15' />
              </style-rule>
              <style-rule element='mark'>
                <format attr='mark-labels-show' value='true' />
                <format attr='mark-labels-cull' value='false' />
                <format attr='size' value='1.6811823844909668' />
              </style-rule>
            </style>
          </pane>
        </panes>
        <rows>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:latitude:qk]</rows>
        <cols>[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[avg:longitude:qk]</cols>
      </table>
      <simple-id uuid='{B0939030-C0F8-414C-B11E-9E4B808D2D84}' />
    </worksheet>
  </worksheets>
  <dashboards>
    <dashboard name='CauseDash'>
      <style />
      <size maxheight='800' maxwidth='1000' minheight='800' minwidth='1000' />
      <zones>
        <zone h='100000' id='4' type='layout-basic' w='100000' x='0' y='0'>
          <zone h='49000' id='3' name='CauseByCnt' w='98400' x='800' y='1000'>
            <zone-style>
              <format attr='border-color' value='#000000' />
              <format attr='border-style' value='none' />
              <format attr='border-width' value='0' />
              <format attr='margin' value='4' />
            </zone-style>
          </zone>
          <zone h='49000' id='5' name='CauseByGal' w='98400' x='800' y='50000'>
            <zone-style>
              <format attr='border-color' value='#000000' />
              <format attr='border-style' value='none' />
              <format attr='border-width' value='0' />
              <format attr='margin' value='4' />
            </zone-style>
          </zone>
          <zone-style>
            <format attr='border-color' value='#000000' />
            <format attr='border-style' value='none' />
            <format attr='border-width' value='0' />
            <format attr='margin' value='8' />
          </zone-style>
        </zone>
      </zones>
      <devicelayouts>
        <devicelayout auto-generated='true' name='Phone'>
          <size maxheight='700' minheight='700' sizing-mode='vscroll' />
          <zones>
            <zone h='100000' id='40' type='layout-basic' w='100000' x='0' y='0'>
              <zone h='98000' id='41' param='vert' type='layout-flow' w='98400' x='800' y='1000'>
                <zone fixed-size='280' h='49000' id='3' is-fixed='true' name='CauseByCnt' w='98400' x='800' y='1000'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
                <zone fixed-size='280' h='49000' id='5' is-fixed='true' name='CauseByGal' w='98400' x='800' y='50000'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
              </zone>
              <zone-style>
                <format attr='border-color' value='#000000' />
                <format attr='border-style' value='none' />
                <format attr='border-width' value='0' />
                <format attr='margin' value='8' />
              </zone-style>
            </zone>
          </zones>
        </devicelayout>
      </devicelayouts>
      <simple-id uuid='{ABD664C0-05E2-4FB2-8566-67CAF3AC3DED}' />
    </dashboard>
    <dashboard name='FreqMapDash'>
      <style />
      <size maxheight='800' maxwidth='1000' minheight='800' minwidth='1000' />
      <zones>
        <zone h='100000' id='4' type='layout-basic' w='100000' x='0' y='0'>
          <zone h='98000' id='17' param='horz' type='layout-flow' w='98400' x='800' y='1000'>
            <zone h='98000' id='15' param='horz' type='layout-flow' w='98400' x='800' y='1000'>
              <zone h='98000' id='7' param='horz' type='layout-flow' w='98400' x='800' y='1000'>
                <zone h='98000' id='5' type='layout-basic' w='98400' x='800' y='1000'>
                  <zone h='49000' id='3' name='TopFreqMap' w='98400' x='800' y='1000'>
                    <zone-style>
                      <format attr='border-color' value='#000000' />
                      <format attr='border-style' value='none' />
                      <format attr='border-width' value='0' />
                      <format attr='margin' value='4' />
                    </zone-style>
                  </zone>
                  <zone h='49000' id='13' name='TopGalMap' w='98400' x='800' y='50000'>
                    <zone-style>
                      <format attr='border-color' value='#000000' />
                      <format attr='border-style' value='none' />
                      <format attr='border-width' value='0' />
                      <format attr='margin' value='4' />
                    </zone-style>
                  </zone>
                </zone>
              </zone>
            </zone>
          </zone>
          <zone-style>
            <format attr='border-color' value='#000000' />
            <format attr='border-style' value='none' />
            <format attr='border-width' value='0' />
            <format attr='margin' value='8' />
          </zone-style>
        </zone>
        <zone h='6375' id='9' name='TopFreqMap' pane-specification-id='0' param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' type='color' w='14000' x='83700' y='41125' />
        <zone h='6000' id='18' name='TopGalMap' pane-specification-id='0' param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' type='color' w='14000' x='83000' y='90375' />
      </zones>
      <devicelayouts>
        <devicelayout auto-generated='true' name='Phone'>
          <size maxheight='750' minheight='750' sizing-mode='vscroll' />
          <zones>
            <zone h='100000' id='47' type='layout-basic' w='100000' x='0' y='0'>
              <zone h='98000' id='48' param='vert' type='layout-flow' w='98400' x='800' y='1000'>
                <zone fixed-size='280' h='49000' id='3' is-fixed='true' name='TopFreqMap' w='98400' x='800' y='1000'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
                <zone h='6375' id='9' name='TopFreqMap' pane-specification-id='0' param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' type='color' w='14000' x='83700' y='41125'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
                <zone fixed-size='280' h='49000' id='13' is-fixed='true' name='TopGalMap' w='98400' x='800' y='50000'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
                <zone h='6000' id='18' name='TopGalMap' pane-specification-id='0' param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' type='color' w='14000' x='83000' y='90375'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
              </zone>
              <zone-style>
                <format attr='border-color' value='#000000' />
                <format attr='border-style' value='none' />
                <format attr='border-width' value='0' />
                <format attr='margin' value='8' />
              </zone-style>
            </zone>
          </zones>
        </devicelayout>
      </devicelayouts>
      <simple-id uuid='{C24FB095-0C84-48D6-8E99-A826EC3D18F2}' />
    </dashboard>
    <dashboard name='RootDash'>
      <style />
      <size maxheight='800' maxwidth='1000' minheight='800' minwidth='1000' />
      <zones>
        <zone h='100000' id='4' type='layout-basic' w='100000' x='0' y='0'>
          <zone h='49000' id='3' name='RootByCnt' w='98400' x='800' y='1000'>
            <zone-style>
              <format attr='border-color' value='#000000' />
              <format attr='border-style' value='none' />
              <format attr='border-width' value='0' />
              <format attr='margin' value='4' />
            </zone-style>
          </zone>
          <zone h='49000' id='5' name='RootByGal' w='98400' x='800' y='50000'>
            <zone-style>
              <format attr='border-color' value='#000000' />
              <format attr='border-style' value='none' />
              <format attr='border-width' value='0' />
              <format attr='margin' value='4' />
            </zone-style>
          </zone>
          <zone-style>
            <format attr='border-color' value='#000000' />
            <format attr='border-style' value='none' />
            <format attr='border-width' value='0' />
            <format attr='margin' value='8' />
          </zone-style>
        </zone>
      </zones>
      <devicelayouts>
        <devicelayout auto-generated='true' name='Phone'>
          <size maxheight='700' minheight='700' sizing-mode='vscroll' />
          <zones>
            <zone h='100000' id='40' type='layout-basic' w='100000' x='0' y='0'>
              <zone h='98000' id='41' param='vert' type='layout-flow' w='98400' x='800' y='1000'>
                <zone fixed-size='280' h='49000' id='3' is-fixed='true' name='RootByCnt' w='98400' x='800' y='1000'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
                <zone fixed-size='280' h='49000' id='5' is-fixed='true' name='RootByGal' w='98400' x='800' y='50000'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
              </zone>
              <zone-style>
                <format attr='border-color' value='#000000' />
                <format attr='border-style' value='none' />
                <format attr='border-width' value='0' />
                <format attr='margin' value='8' />
              </zone-style>
            </zone>
          </zones>
        </devicelayout>
      </devicelayouts>
      <simple-id uuid='{94503991-A8EE-4091-9723-882D3977BF5B}' />
    </dashboard>
    <dashboard name='SewershedDash'>
      <style />
      <size maxheight='800' maxwidth='1000' minheight='800' minwidth='1000' />
      <zones>
        <zone h='100000' id='4' type='layout-basic' w='100000' x='0' y='0'>
          <zone h='98000' id='7' param='horz' type='layout-flow' w='98400' x='800' y='1000'>
            <zone h='98000' id='5' type='layout-basic' w='98400' x='800' y='1000'>
              <zone h='98000' id='3' name='Sewersheds' w='98400' x='800' y='1000'>
                <zone-style>
                  <format attr='border-color' value='#000000' />
                  <format attr='border-style' value='none' />
                  <format attr='border-width' value='0' />
                  <format attr='margin' value='4' />
                </zone-style>
              </zone>
            </zone>
          </zone>
          <zone-style>
            <format attr='border-color' value='#000000' />
            <format attr='border-style' value='none' />
            <format attr='border-width' value='0' />
            <format attr='margin' value='8' />
          </zone-style>
        </zone>
        <zone h='23375' id='8' name='Sewersheds' pane-specification-id='0' param='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:watershed:nk]' type='color' w='22500' x='5300' y='65375' />
      </zones>
      <devicelayouts>
        <devicelayout auto-generated='true' name='Phone'>
          <size maxheight='700' minheight='700' sizing-mode='vscroll' />
          <zones>
            <zone h='100000' id='41' type='layout-basic' w='100000' x='0' y='0'>
              <zone h='98000' id='42' param='vert' type='layout-flow' w='98400' x='800' y='1000'>
                <zone fixed-size='280' h='98000' id='3' is-fixed='true' name='Sewersheds' w='98400' x='800' y='1000'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
                <zone h='23375' id='8' name='Sewersheds' pane-specification-id='0' param='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:watershed:nk]' type='color' w='22500' x='5300' y='65375'>
                  <zone-style>
                    <format attr='border-color' value='#000000' />
                    <format attr='border-style' value='none' />
                    <format attr='border-width' value='0' />
                    <format attr='margin' value='4' />
                    <format attr='padding' value='0' />
                  </zone-style>
                </zone>
              </zone>
              <zone-style>
                <format attr='border-color' value='#000000' />
                <format attr='border-style' value='none' />
                <format attr='border-width' value='0' />
                <format attr='margin' value='8' />
              </zone-style>
            </zone>
          </zones>
        </devicelayout>
      </devicelayouts>
      <simple-id uuid='{4FB12CA0-BDEB-4966-9565-8B628084ABF5}' />
    </dashboard>
  </dashboards>
  <windows source-height='93'>
    <window class='worksheet' name='Sewersheds'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='31'>
            <card type='title' />
          </strip>
        </edge>
        <edge name='right'>
          <strip size='160'>
            <card pane-specification-id='0' param='[federated.1e4fb3w1e6ajcc17zk9bo0gdp7ny].[none:watershed:nk]' type='color' />
          </strip>
        </edge>
      </cards>
      <simple-id uuid='{021C0E18-82D1-401C-97B2-3DF730C54127}' />
    </window>
    <window class='dashboard' name='SewershedDash'>
      <viewpoints>
        <viewpoint name='Sewersheds'>
          <zoom type='entire-view' />
        </viewpoint>
      </viewpoints>
      <active id='-1' />
      <simple-id uuid='{F489E99F-D160-4D9F-9501-6197E6E31C44}' />
    </window>
    <window class='worksheet' maximized='true' name='RootByCnt'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='31'>
            <card type='title' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <zoom type='entire-view' />
      </viewpoint>
      <simple-id uuid='{E7442860-977A-4047-B108-E2F807E8B338}' />
    </window>
    <window class='worksheet' name='CauseByCnt'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='31'>
            <card type='title' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <zoom type='entire-view' />
      </viewpoint>
      <simple-id uuid='{896F81CF-36C9-4A09-85E0-175C76FF9F62}' />
    </window>
    <window class='worksheet' name='RootByGal'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='31'>
            <card type='title' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <zoom type='entire-view' />
      </viewpoint>
      <simple-id uuid='{491E03E2-F2E9-4595-8CD7-39A0687EF9B7}' />
    </window>
    <window class='worksheet' name='CauseByGal'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='31'>
            <card type='title' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <zoom type='entire-view' />
      </viewpoint>
      <simple-id uuid='{D0EEB7E7-D37E-411F-AC18-F6FA9B2A6DBF}' />
    </window>
    <window class='dashboard' name='RootDash'>
      <viewpoints>
        <viewpoint name='RootByCnt' />
        <viewpoint name='RootByGal'>
          <zoom type='entire-view' />
        </viewpoint>
      </viewpoints>
      <active id='-1' />
      <simple-id uuid='{9F11537E-3561-415D-847A-22D6596E1F79}' />
    </window>
    <window class='dashboard' name='CauseDash'>
      <viewpoints>
        <viewpoint name='CauseByCnt' />
        <viewpoint name='CauseByGal' />
      </viewpoints>
      <active id='-1' />
      <simple-id uuid='{4BA0D145-2242-42F4-AFE0-AFD6FD93A59E}' />
    </window>
    <window class='worksheet' name='ModelPred'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='31'>
            <card type='title' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <zoom type='entire-view' />
      </viewpoint>
      <simple-id uuid='{49628487-66D0-4C85-952E-2BE33870DF6E}' />
    </window>
    <window class='worksheet' name='TopFreqMap'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='2147483647'>
            <card type='title' />
          </strip>
        </edge>
        <edge name='right'>
          <strip size='160'>
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]' type='filter' />
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]' type='filter' />
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' type='filter' />
            <card pane-specification-id='0' param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' type='color' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <default-map-tool-selection tool='1' />
      </viewpoint>
      <simple-id uuid='{409304D0-0E64-4C13-BC55-03DFE8DA6449}' />
    </window>
    <window class='worksheet' name='FreqRain-I/I'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='2147483647'>
            <card type='title' />
          </strip>
        </edge>
        <edge name='right'>
          <strip size='160'>
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]' type='filter' />
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]' type='filter' />
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' type='filter' />
            <card pane-specification-id='0' param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' type='color' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <default-map-tool-selection tool='1' />
      </viewpoint>
      <simple-id uuid='{FC573991-D6A4-492C-B6A5-231A8CB67E58}' />
    </window>
    <window class='worksheet' name='Freq Holbrook'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='2147483647'>
            <card type='title' />
          </strip>
        </edge>
        <edge name='right'>
          <strip size='160'>
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]' type='filter' />
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]' type='filter' />
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' type='filter' />
            <card pane-specification-id='0' param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' type='color' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <default-map-tool-selection tool='1' />
      </viewpoint>
      <simple-id uuid='{2CFEAD10-9BE1-4FEE-B350-3A5ACA9007CE}' />
    </window>
    <window class='worksheet' name='FreqLiftStations'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='2147483647'>
            <card type='title' />
          </strip>
        </edge>
        <edge name='right'>
          <strip size='160'>
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_root_cause:nk]' type='filter' />
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:primary_cause:nk]' type='filter' />
            <card param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[none:address:nk]' type='filter' />
            <card pane-specification-id='0' param='[federated.0z4t00e1mynjhf199g7rp0l6qucy].[sum:number_of_sso:qk]' type='color' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <default-map-tool-selection tool='1' />
      </viewpoint>
      <simple-id uuid='{9AF71923-1E74-4FEA-9EEA-89DB0A2B9E9C}' />
    </window>
    <window class='worksheet' name='TopGalMap'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='2147483647'>
            <card type='title' />
          </strip>
        </edge>
        <edge name='right'>
          <strip size='160'>
            <card pane-specification-id='0' param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' type='color' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <default-map-tool-selection tool='1' />
      </viewpoint>
      <simple-id uuid='{D7F89E61-08AE-47F9-91A8-156C03559531}' />
    </window>
    <window class='worksheet' name='GalRain-I/I'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='2147483647'>
            <card type='title' />
          </strip>
        </edge>
        <edge name='right'>
          <strip size='160'>
            <card param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_cause:nk]' type='filter' />
            <card param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_root_cause:nk]' type='filter' />
            <card pane-specification-id='0' param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' type='color' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <default-map-tool-selection tool='1' />
      </viewpoint>
      <simple-id uuid='{91D7C3F0-28A7-4EC1-A008-4D3DE2136382}' />
    </window>
    <window class='worksheet' name='Gal Holbrook'>
      <cards>
        <edge name='left'>
          <strip size='160'>
            <card type='pages' />
            <card type='filters' />
            <card type='marks' />
          </strip>
        </edge>
        <edge name='top'>
          <strip size='2147483647'>
            <card type='columns' />
          </strip>
          <strip size='2147483647'>
            <card type='rows' />
          </strip>
          <strip size='2147483647'>
            <card type='title' />
          </strip>
        </edge>
        <edge name='right'>
          <strip size='160'>
            <card param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_cause:nk]' type='filter' />
            <card param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[none:primary_root_cause:nk]' type='filter' />
            <card pane-specification-id='0' param='[federated.0gv4ky81v0fz3r12lfxyn0fepy1v].[sum:total_gallons:qk]' type='color' />
          </strip>
        </edge>
      </cards>
      <viewpoint>
        <default-map-tool-selection tool='1' />
      </viewpoint>
      <simple-id uuid='{A512CA5B-99A9-41BA-A7B4-08F9C0068B6B}' />
    </window>
    <window class='dashboard' name='FreqMapDash'>
      <viewpoints>
        <viewpoint name='TopFreqMap'>
          <zoom type='entire-view' />
          <default-map-tool-selection tool='1' />
        </viewpoint>
        <viewpoint name='TopGalMap'>
          <zoom type='entire-view' />
          <default-map-tool-selection tool='1' />
        </viewpoint>
      </viewpoints>
      <active id='-1' />
      <simple-id uuid='{1D554913-7900-4EB5-AC37-EACB790B99B4}' />
    </window>
  </windows>
</workbook>