$1.In$ class, $we$ constructed two maps $of$ Washington state that displayed information about structurally deficient bridges across the state.

This Tableau workbook should contain two worksheets

$-$deficient bridges map

$-$county map

And, your maps $in$ these worksheets should match with what $we$ did $in$ class.

Submission Instructions: Upload your $unsaf{e}_{b}ridge{s}_y$ourlastname.$TWBX$ file $to$ the Mapping Data $in$ Tableau Assignment link $in$ Canvas.

$2.$ What other questions might you answer with this type $of$ data? Using the data $inwa-15.xlsx$ file that $we$ examined $in$ class, answer the following questions.

There $is$ a document entitled $ReportingGuid{e}_N$ationalBridgeInventory$in$ Mapping Data $in$ Tableau Assignment $in$ Canvas that provides you the names and descriptions $of$ some $of$ the column names $(fields)in$ the data you will need $to$ understand before attempting this problem.

NOTE: PART $OF$ THE CHALLENGE $OF$ THIS ASSIGNMENT $ISTO$ IDENTIFY THE CORRECT BRIDGE. Read through the reporting guide and revisit the scenario $in$ class. The information you need $is$ there!

Produce a separate worksheet $in$ Tableau $to$ answer each question. Place your responses $to$ the questions below.

$a.$ What$s$ the rating $of$ the Skagit River bridge that collapsed into the river?

Name this worksheet $in$ Tableau $Q2a.$

$b.$ When was the bridge last inspected and how often $isit$ inspected?

Name this worksheet $in$ Tableau $Q2b.$

$c.Isit$ considered fracture$-$critical, meaning one hit $to$ a span can knock $it$ out?

Name this worksheet $in$ Tableau $Q2c.$

$d.$ How much average daily traffic does $it$ get?

Name this worksheet $in$ Tableau $Q2d.$

Each worksheet $in$ Tableau should support the response you provide.

Submission Instructions: Save your Tableau workbook $asa.TWBX$ file and name the file $mor{e}_{b}ridge{s}_y$ourlastname and upload $to$ the Mapping Data $in$ Tableau Assignment link $in$ Canvas. Also, upload this Word document with your responses $to$ the questions $in$ #$2to$ the same assignment link.