25:["$","title",null,{"children":"YuMingWu_Final_Assignement | YU MING WU's Workspace | Observable"}] 49:Tbb5,reviewData = [ {"id": 1, "username": "Usersss", "review": "The AA meeting was very supportive and welcoming. I felt comfortable sharing my experiences."}, {"id": 2, "username": "RecoveryQueen", "review": "I appreciate the open-minded atmosphere at this AA meeting. It's a great place to find help."}, {"id": 3, "username": "SoberSoul", "review": "The speaker was inspiring and had a powerful story to share. This meeting is a lifeline for me."}, {"id": 4, "username": "GratitudeSeeker", "review": "I've made lasting friendships through this AA group. We truly understand and support each other."}, {"id": 5, "username": "NewBeginner", "review": "Attending this AA meeting was a big step in my recovery journey. It felt like a safe space."}, {"id": 6, "username": "HopefulHeart", "review": "The discussions in this AA meeting are meaningful and help me stay on track in my sobriety."}, {"id": 7, "username": "FreedomFighter", "review": "I've been coming to this AA meeting for years, and it never fails to provide a sense of belonging."}, {"id": 8, "username": "SoberWarrior", "review": "This group has been instrumental in my recovery. It's a beacon of hope in my life."}, {"id": 9, "username": "SupportiveSobriety", "review": "I was skeptical at first, but this AA meeting turned out to be a place of hope and transformation."}, {"id": 10, "username": "RecoveryRising", "review": "The AA meeting's facilitators are compassionate and experienced. It's a great resource."}, {"id": 11, "username": "GratefulHeart", "review": "Being part of this AA community has changed my life. I'm forever grateful for the support."}, {"id": 12, "username": "SerenityNow", "review": "This AA meeting provides a sense of serenity and understanding that's vital in my recovery."}, {"id": 13, "username": "CourageToChange", "review": "The diversity of experiences shared in this AA meeting is incredibly inspiring."}, {"id": 14, "username": "WellnessWarrior", "review": "I look forward to this AA meeting every week. It's a cornerstone of my sobriety."}, {"id": 15, "username": "NewHorizons", "review": "I've gained valuable insights into my addiction through this AA group. It's a path to self-discovery."}, {"id": 16, "username": "EmpoweredLife", "review": "The AA meeting helped me find the strength to overcome my addiction. I can't thank them enough."}, {"id": 17, "username": "BrighterDays", "review": "The positive vibes and camaraderie in this AA meeting are truly uplifting."}, {"id": 18, "username": "RecoveryChampion", "review": "This AA group is a testament to the power of recovery and unity. It's been a game-changer for me."}, {"id": 19, "username": "SobrietyExplorer", "review": "The honesty and support in this AA meeting have made a huge difference in my journey."}, {"id": 20, "username": "RenewedHope", "review": "I had lost all hope before coming to this AA meeting. Now, I'm on a path to recovery and renewal."} ] 4a:T5fa,viewof map = { const container = html`

`; yield container; // Give the container dimensions. const map = (container.value = new mapboxgl.Map({ container, center: [-73.973103, 40.770091], zoom: 11.5, style: "mapbox://styles/mapbox/dark-v11", scrollZoom: false, dragPan: false })); for (const element of allQuery) { const popupContent = document.createElement("div"); popupContent.innerHTML = `

${element.GROUP_NAME}

${element.meeting_type}

${element.date}

${element.time}

`; const popup = new mapboxgl.Popup({ closeButton: true, closeOnClick: true }).setDOMContent(popupContent); popupContent.style.backgroundColor = "black"; popupContent.style.padding = "10px"; popupContent.style.border = "2px solid #ccc"; popupContent.style.borderRadius = "5px"; popupContent.style.boxShadow = "0 2px 8px rgba(0, 0, 0, 0.1)"; popupContent.style.opacity = "0.8"; popupContent.style.color = "white"; const customMarker = document.createElement("div"); customMarker.style.width = "10px"; customMarker.style.height = "10px"; customMarker.style.background = "#fb8500"; customMarker.style.borderRadius = "20%"; const thisMarker = new mapboxgl.Marker({ element: customMarker }) .setLngLat([element.longitude, element.latitude]) .setPopup(popup) .addTo(map); } invalidation.then(() => map.remove()); }4b:[{"id":"087ac4e7afa471826a594c0188b09b31686effadbd2e3bb93bba35b72beeea9e79cc166e9a6b50297de335edc022c5f887f609a6aad06f174734e95a58ac91af","href":"https://static.observableusercontent.com/files/087ac4e7afa471826a594c0188b09b31686effadbd2e3bb93bba35b72beeea9e79cc166e9a6b50297de335edc022c5f887f609a6aad06f174734e95a58ac91af","name":"AA_meeting_all.csv","type":"text/csv","lastModified":1702348998145.834,"size":101287},{"id":"a2ee92af97d9f28901fa618a97de8278877aa92a15b70896a802a0db078e505a67f6f6f3a23e8f79bb9258e916c1051a5ee97f4b5124d3319a37fa0ea706a46e","href":"https://static.observableusercontent.com/files/a2ee92af97d9f28901fa618a97de8278877aa92a15b70896a802a0db078e505a67f6f6f3a23e8f79bb9258e916c1051a5ee97f4b5124d3319a37fa0ea706a46e","name":"icon.png","type":"image/png","lastModified":1702350472326.918,"size":257786}] 29:{"id":"518096faaba981f2","slug":null,"title":"YuMingWu_Final_Assignement","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-12-12T02:36:15.294Z","update_time":"$D2023-12-12T03:36:21.280Z","view_time":null,"first_public_time":"$D2023-12-12T02:36:15.294Z","has_unpublished_edits":null,"fork":{"id":"45b4c350e00e587d","slug":null,"title":"HaoChe's Final Assignement","owner":{"id":"c32e51353e9ac9e4","login":"hhc9106","name":"HaoChe"}},"stars":0,"starred":false,"owner":{"type":"team","id":"bee6d8bc1f76176f","login":"yu-ming-wu-ws","name":"YU MING WU's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/a4a64c8f68258b9b2f48e2948b1e5b69fe10a75b6cb4e60124905eaceed5c286","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":390,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"16653fa8c00bbb3f","login":"yu-ming-wu","name":"YU MING WU","avatar_url":"https://avatars-next.observableusercontent.com/5afac38ddd2fd67fcd3254ce66a3adb0cc5a63ad0d308e82eb664a145581920d","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"16653fa8c00bbb3f","login":"yu-ming-wu","name":"YU MING WU","avatar_url":"https://avatars-next.observableusercontent.com/5afac38ddd2fd67fcd3254ce66a3adb0cc5a63ad0d308e82eb664a145581920d","tier":null,"role":"editor"},{"type":"team","id":"bee6d8bc1f76176f","login":"yu-ming-wu-ws","name":"YU MING WU's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/a4a64c8f68258b9b2f48e2948b1e5b69fe10a75b6cb4e60124905eaceed5c286","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"YuMingWu_Final_Assignement","cells":[{"id":0,"value":"# YuMingWu_Final_Assignement\n\nLast week, we used [DuckDB](https://observablehq.com/@observablehq/duckdb) to [import AA data and reviews](https://observablehq.com/@aaronxhill/duckdb-demo). \n\nIn the next step toward your final assignment, you will use [Mapbox in Observable](https://observablehq.com/@aaronxhill/hello-mapbox-gl) to plot your AA data. \n\nThis demo shows how you can use the values of [Observable user inputs](https://observablehq.com/@observablehq/learning-observable-user-inputs-and-interactivity) within your DuckDB queries, and connecting those query results to your Mapbox map. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":280,"value":"aa_meeting_all = await FileAttachment(\"AA_meeting_all.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"aa_meeting_all","database":"$undefined"},{"id":181,"value":"aa_meeting_all4 = aa_meeting_all","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"aa_meeting_all4","database":"$undefined"},{"id":185,"value":"$49","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"### Create database\n\nCreate a new instance of DuckDBClient, in a variable named `client`. This variable will hold two tables: 1) `meetings` from an attached CSV file, and 2) `reviews` from an array of objects: ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":3,"value":"client = DuckDBClient.of({\n meetings: FileAttachment(\"AA_meeting_all.csv\"),\n reviews: reviewData\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"### Save data from a query to a JavaScript variable\n\nWhen creating a new SQL cell, give it a name. I'll name this one `daysQuery`:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":100,"value":"SELECT *\nFROM meetings\nWHERE date = ${d}; -- previously: WHERE Day = 'Wednesdays';","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"daysQuery","database":"var:client"},{"id":105,"value":"daysQuery","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"# Map generated from SQL query that updates on user input","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":138,"value":"d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"zones = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"SELECT *\nFROM meetings\nWHERE zone = ${z}; ","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"areaQuery","database":"var:client"},{"id":198,"value":"areaQuery","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":257,"value":"meeting = [\n \"B = Beginners meeting\",\n \"BB = Big Book meeting\",\n \"C = Closed Discussion\",\n \"OD = Open Discussion\",\n \"S = Step meeting\"\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"SELECT *\nFROM meetings\nWHERE meeting_type = ${c}; ","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"meetingQuery","database":"var:client"},{"id":271,"value":"SELECT *\nFROM meetings\nWHERE zone = ${z} or meeting_type = ${c} and date = ${d} ; ","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"allQuery","database":"var:client"},{"id":358,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"null"},{"id":214,"value":"viewof d = Inputs.select(days, { label: \"Days\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"viewof z = Inputs.select(zones, { label: \"Zone\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":246,"value":"viewof c = Inputs.select(meeting, { label: \"Meeting\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":241,"value":"zones","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"$4a","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"mapboxgl = {\n const gl = await require(\"mapbox-gl@1\");\n if (!gl.accessToken) {\n gl.accessToken = accessToken;\n const href = await require.resolve(\"mapbox-gl@1/dist/mapbox-gl.css\");\n document.head.appendChild(html``);\n }\n return gl;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"accessToken = \"pk.eyJ1IjoiZGFycmVuMzMxMCIsImEiOiJjbG54ZW53Z3QwY3pyMmpxaHozdDF4a2M0In0.LX0YYPhsZK6-ZZ0dfd885w\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"days = [\n \"Sundays\",\n \"Mondays\",\n \"Tuesdays\",\n \"Wednesdays\",\n \"Thursdays\",\n \"Fridays\",\n \"Saturdays\"\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 24:null