3e:null 3f:["$","title",null,{"children":"Course Assignment | Kallol Chatterjee | Observable"}] 45:T58c,{ const conditions = [ "Satisfactory", "Fair", "Poor", "Unsatisfactory" ]; return Plot.plot({ title: "California Dam's Good?", subtitle: "Dam condition assessment by the decade completed", x: { label: "Decade Completed", tickFormat: "d" }, y: { label: optionsTask1.relativeProportion ? "% Decade" : "Number of dams", grid: true, percent: optionsTask1.relativeProportion }, color: { legend: true, domain: conditions, range: [ "hsl(141deg,49%,30%)", "hsl(45deg,49%,66%)", "hsl(60deg,41%,26%)", "hsl(0deg,42%,90%)", "#ccc"//not the default colors I must build something ] }, marks: [ Plot.rectY( caDams, Plot.stackY( { order: conditions, offset: optionsTask1.relativeProportion ? "normalize" : null }, Plot.binX( { y: "count" }, { filter: (d) => optionsTask1.missingData ? d : d.ConditionAssessment !== "No data", x: "YearCompleted", y: "ConditionAssessment", fill: "ConditionAssessment", interval: 10, //1 instead of 10 from the task for finer b-distribution tip: true } ) ) ), Plot.ruleY([0]) ] }); }46:T563,--- ### Task 2: Water storage and hazard classification (interactive) In Observable Plot, create an interactive **bubble chart of dam water storage volume (acre-feet) versus surface area (acres)** (the variable names in `caDams` are `StorageAcreFeet` and `SurfaceAreaAcres`), with the **radius dependent on dam drainage area** (`DrainageAreaSqMiles`). Add tooltips that show each of the channels above, **plus the dam name.** Add a radio button Input that lets a user select a HazardPotentialClassification (Low, Significant, or High) such that only damns with the selected hazard classification are highlighted in a meaningful color, and others are in gray. **Task 2 minimum requirements (but feel free to do more!):** - An interactive bubble chart of dam water storage versus surface area, with radius based on drainage area, and with color indicating the hazard potential. From an Input, a user can select different hazard potential classifications, and dams with that classification are highlighted in the chart. - A custom color scale (with a legend in meaningful order, Low > Significant > High) - One (or both) axis updated to a log scale to compress values across orders of magnitudes - An interactive tooltip that shows the dam name, along with other channels you choose Create your Task 2 chart in a cell immediately below.47:T4c0,Plot.plot({ projection: { type: "mercator", domain: caCounties }, width: 1000, height: 1000, color: { type: "categorical", domain: ["Low", "Significant", "High"], range: ["hsl(141deg,29%,90%)", "hsl(45deg,49%,66%)", "hsl(3deg,59%,40%)"], legend: true }, symbol: { domain: primaryPurposes, legend: true }, r: { domain: d3.extent(caDams.map((d) => d.StorageAcreFeet)), range: [3, 15] }, marks: [ Plot.geo(caCounties, { stroke: "grey", strokeWidth: 0.9 }), Plot.geo(caHydro, { stroke: "blue", strokeWidth: showRivers ? 0.3 : 0 }), Plot.dot( caDams.filter( (d) => mapHazzardClass.includes(d.HazardPotentialClassification) && selectedPurposes.includes(d.PrimaryPurpose) && d.YearCompleted <= pickYear && d.StorageAcreFeet >= minStorage ), { x: "Longitude", type: "log", y: "Latitude", tip: true, fill: "HazardPotentialClassification", // stroke: "black", symbol: "PrimaryPurpose", opacity: 0.5, r: "StorageAcreFeet", channels: { Dam_Name: "DamName", Year_Completed: "YearCompleted" } } ) ] })48:[{"id":"b1bbc6ad24ded1e336293e40ec279d5d81d22fba986ccd43f4251e96d5e8c02742de26be597aa0377fed25bb0801fa08d5dfc25d4797caca05e8003da702c781","href":"https://static.observableusercontent.com/files/b1bbc6ad24ded1e336293e40ec279d5d81d22fba986ccd43f4251e96d5e8c02742de26be597aa0377fed25bb0801fa08d5dfc25d4797caca05e8003da702c781","name":"californiaDams.csv","type":"text/csv","lastModified":1698738465873.021,"size":505612},{"id":"5443aa69344628c1768d1610c485534930d91e481db4b16c2a9287259cb7a033959c6c9af3965762f3fe500a0f5c699f7847caa653f32558c5edd3bbb41b3a0f","href":"https://static.observableusercontent.com/files/5443aa69344628c1768d1610c485534930d91e481db4b16c2a9287259cb7a033959c6c9af3965762f3fe500a0f5c699f7847caa653f32558c5edd3bbb41b3a0f","name":"california-counties.geojson","type":"application/geo+json","lastModified":1698738465873.021,"size":416370},{"id":"3a786bcccfb498eaa3392542b8fc56122281aa102a8e754ee95087218141bf1757a34421bc29320182f0de97dd75a13300efedb207483fe63460b6749c212e06","href":"https://static.observableusercontent.com/files/3a786bcccfb498eaa3392542b8fc56122281aa102a8e754ee95087218141bf1757a34421bc29320182f0de97dd75a13300efedb207483fe63460b6749c212e06","name":"California_Hydro.geojson","type":"application/geo+json","lastModified":1698997402770.131,"size":1712957}] 43:{"id":"1c45855c8fcef960","slug":null,"title":"Course Assignment","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-10-31T07:47:45.873Z","update_time":"$D2023-11-10T06:35:46.769Z","view_time":null,"first_public_time":"$D2023-10-31T07:47:45.873Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"dc97a2766ef9be06","login":"k-chat","name":"Kallol Chatterjee","avatar_url":"https://avatars-next.observableusercontent.com/f31a56f01fed3c9a0499394b5920853e37295852e119e35d12c6a0f8848a4d84","tier":"starter_2024","bio":"","following":false},"version":271,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"a092fa1ed8517f3f","login":"k-chat","name":"Kallol Chatterjee","avatar_url":"https://avatars-next.observableusercontent.com/f31a56f01fed3c9a0499394b5920853e37295852e119e35d12c6a0f8848a4d84","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"a092fa1ed8517f3f","login":"k-chat","name":"Kallol Chatterjee","avatar_url":"https://avatars-next.observableusercontent.com/f31a56f01fed3c9a0499394b5920853e37295852e119e35d12c6a0f8848a4d84","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Course Assignment","cells":[{"id":3,"value":"# Course Assignment\n## Introduction to data visualization with Observable Plot","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4,"value":"## Logistics\n\n- **Fork this notebook** to make your own copy. Complete tasks below in your fork.\n- When you are ready to submit, ensure that your fork visibility is **Public unlisted** so that we can see your work. To update the setting, go to the Share button, the under Access choose “Can view (unlisted)” for Public visibility. Make sure to Save changes.\n- Submit assignment by sharing your notebook URL in [this Google Form](https://forms.gle/JEKph2PVvow1cFJK7) by end of day **November 6, 2023**\n- Ask questions in the Observable Community Slack **#introduction-observable-plot** channel.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"## Data: Dams on California waterways","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":6,"value":"For this assignment, you will use Observable Plot to visualize information about dams on California waterways from the [National Inventory of Dams](https://nid.sec.usace.army.mil/#/).\n\nAll the data you'll need is already attached and loaded in this notebook, named **caDams**. The `caDams` data is previewed below:\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"caDams","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":54,"value":"<## Testing Charts for EDA>","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"---\n## Assignment tasks","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"---\n### Task 1: Visualize condition assessment by decade-built\nThe `ConditionAssessment` variable contains an ordinal descriptor of each dam's condition (No data, Poor, Unsatisfactory, Satisfactory, or Fair). In Observable Plot, create a **bar chart** to visualize the **number of dams in each condition, binned by decade completed** (using the `YearCompleted` variable).\n\nTask 1 minimum requirements (but feel free to do more!): \n- Stacked bar chart of dam counts by decade completed (hint: `interval: 10`), with color indicating the condition\n- A meaningful, custom color scheme indicating the different conditions (e.g., \"Unsatisfactory\" might be red)\n- Updated x- and y-axis labels\n- Below your chart in a separate markdown cell, describe major takeaways from your chart in 1 - 2 sentences.\n\nCreate your Task 1 chart in a cell immediately below.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":194,"value":"viewof optionsTask1 = Inputs.form({\n missingData: Inputs.toggle({label: \"Include 'No data'\", value: false}),\n relativeProportion: Inputs.toggle({label: \"Relative Proportion\", value: true}),\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"$46","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":124,"value":"viewof hazzardClass = Inputs.checkbox([\"Low\", \"Significant\", \"High\"], {\n label: \"Select Hazard Potential:\",\n unique: true,\n value: [\"Low\", \"Significant\", \"High\"]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"Plot.plot({\n x: { type: \"log\", grid: true },\n y: { type: \"sequential\", grid: true, domain: [1, 150000] },\n width,\n tip: true,\n r: { range: [3, 30] },\n color: {\n type: \"categorical\",\n domain: [\"Low\", \"Significant\", \"High\"],\n range: [\"hsl(141deg,49%,90%)\",\n \"hsl(45deg,49%,66%)\",\n \"hsl(3deg,59%,40%)\"],\n legend: true\n },\n marks: [\n Plot.dot(caDams, {\n x: \"StorageAcreFeet\",\n type: \"log\",\n y: \"SurfaceAreaAcres\",\n tip: true,\n fill: \"HazardPotentialClassification\",\n opacity: 1,\n r: \"DrainageAreaSqMiles\",\n channels: { DamName: \"DamName\" }\n }),\n \n Plot.dot(\n caDams.filter((d) =>\n hazzardClass.includes(d.HazardPotentialClassification)\n ),\n {\n x: \"StorageAcreFeet\",\n type: \"log\",\n y: \"SurfaceAreaAcres\",\n tip: true,\n fill: \"HazardPotentialClassification\",\n r: \"DrainageAreaSqMiles\",\n channels: { DamName: \"DamName\" }\n }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"---\n### Task 3: An interactive map of California dams\nIn Observable Plot, create an interactive map of dams in California. The spatial data you need with California county boundaries (as a basemap) is already attached and loaded as `caCounties`, and `caDams` contains variables for Longitude and Latitude. **Hint:** to crop a map to only the area of this spatial data, you can set a domain option within the projection (e.g. `projection: {type: \"mercator\", domain: caCounties}`).\n\nFor this activity, you can choose which variable(s) you want to visualize! \n\n**Task 3 minimum requirements (but feel free to do more):**\n- A basemap of California\n- At least two Inputs (you choose the types) that allow a viewer to focus on different subset of dams (for example by dam type, size/storage, hazard potential, condition, or year completed)\n- A tooltip revealing the dam name (and any other channels you want to include)\n\nCreate your Task 3 map in a cell immediately below.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":159,"value":"viewof pickYear = Inputs.range(\n d3.extent(caDams, (d) => d.YearCompleted),\n { label: \"Year of Completion \", step: 0.5, value: 2022 }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":157,"value":"viewof mapHazzardClass = Inputs.checkbox([\"Low\", \"Significant\", \"High\"], {\n label: \"Dams With these Hazard Potentials:\",\n unique: true,\n value: [\"Low\", \"Significant\", \"High\"]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"viewof minStorage = Inputs.range(\n d3.extent(caDams, (d) => d.StructuralHeightFt),\n {\n label: \"Only Dams with at Least 1 Acre Feet of Storage \",\n step: 1,\n value: 1,\n transform: Math.seq\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"viewof showRivers = Inputs.toggle({ label: \"Show Rivers\", value: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"primaryPurposes = [...new Set(caDams.map((d) => d.PrimaryPurpose))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"viewof selectedPurposes = Inputs.checkbox(primaryPurposes, {\n label: \"And Also With These Primary Purposes:\",\n unique: true,\n value: primaryPurposes\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"$47","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"caHydro = FileAttachment(\"California_Hydro.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"---\n## Congratulations! Submit your assignment.\n\nOnce you’re done with the assignment, make sure to: \n\n- Update your notebook settings (click the Share button) so that Public access is “View (unlisted)”\n- Submit the URL to your notebook in [this Google form](https://forms.gle/JEKph2PVvow1cFJK7) by midnight on November 6, 2023\n- Keep an eye out for course certificates, which we'll send out via email by November 10, 2023 \n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":19,"value":"_**Thank you** for joining us for the **Introduction to Data Visualization in Observable Plot** course! We look forward to seeing you at our upcoming events, and in our Community Slack!_ ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"---\n## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":21,"value":"dams = FileAttachment(\"californiaDams.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"var:caDams"},{"id":52,"value":"Plot.plot({\n color: {\n legend: true\n },\n marks: [\n Plot.auto(dams, {x: \"DistanceNearestCityMiles\", fx: \"PrimaryPurpose\", color: \"HazardPotentialClassification\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":263,"value":"Plot.plot({\n color: { legend: true },\n width: 2000,\n marks: [\n Plot.frame({ strokeOpacity: 0.05 }),\n Plot.rectY(\n dams,\n Plot.binX(\n { y: \"count\" },\n {\n fx: \"PrimaryPurpose\",\n x: \"DistanceNearestCityMiles\",\n fill: \"HazardPotentialClassification\",\n tip: true\n }\n )\n ),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"await FileAttachment(\"3110Modi.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":22,"value":"caDams = dams.map((d) => ({\n ...d,\n ConditionAssessment:\n d[\"ConditionAssessment\"] == \"\" ||\n d[\"ConditionAssessment\"] == \"Not Available\" ||\n d[\"ConditionAssessment\"] == \"Not Rated\" ||\n d[\"ConditionAssessment\"] == null\n ? \"No data\"\n : d[\"ConditionAssessment\"]\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"caCounties = FileAttachment(\"california-counties.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"Plot.plot({\n marginTop: 50,\n marginLeft: 100,\n marginRight: 50,\n width: width,\n height: 17000,\ncolor: {\n legend: true\n },\n marks: [\n Plot.auto(caDams, {x: \"SurfaceAreaAcres\", y: \"DamName\", color: \"Purposes\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":168,"value":"Plot.plot({\n color: { legend: true },\n width,\n height: 17000,\n marginTop: 50,\n marginLeft: 100,\n marginRight: 50,\n marks: [\n Plot.barX(caDams, {\n x: \"SurfaceAreaAcres\",\n y: \"DamName\",\n fill: \"Purposes\",\n r: \"Purposes\",\n tip: true\n }),\n Plot.ruleX([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W48","stdlib":"1"}} 44:"$43:body"