2c:null 2d:["$","title",null,{"children":"Integrating DuckDB, user inputs, and Mapbox for AA Meeting Data | amatevosian's Workspace | Observable"}] 32:T14f6,reviewData = [ {"review_id": 0, "username": "user62", "review_text": "I appreciated the emphasis on spiritual principles in this AA meeting. The discussions were deep and meaningful. The camaraderie among members is powerful. I'm grateful to have found this group."}, {"review_id": 1, "username": "user260", "review_text": "I appreciated the emphasis on spiritual principles in this AA meeting. The discussions were deep and meaningful. The camaraderie among members is powerful. I'm grateful to have found this group."}, {"review_id": 2, "username": "user102", "review_text": "Attending this AA discussion group has become a crucial part of my recovery routine. The sharing of experiences and challenges is relatable, and the sense of unity is palpable. Highly recommended for those seeking connection."}, {"review_id": 3, "username": "user447", "review_text": "I attended the open discussion meeting, and the inclusivity was remarkable. The facilitator ensured that everyone had a chance to speak. The meeting fostered a sense of belonging and acceptance. Solid 4 stars!"}, {"review_id": 4, "username": "user184", "review_text": "This AA community provides a safe and non-judgmental space for individuals recovering from alcohol addiction. The diversity of experiences shared adds richness to the discussions. A supportive environment overall."}, {"review_id": 5, "username": "user442", "review_text": "I appreciated the emphasis on spiritual principles in this AA meeting. The discussions were deep and meaningful. The camaraderie among members is powerful. I'm grateful to have found this group."}, {"review_id": 6, "username": "user164", "review_text": "I appreciated the emphasis on spiritual principles in this AA meeting. The discussions were deep and meaningful. The camaraderie among members is powerful. I'm grateful to have found this group."}, {"review_id": 7, "username": "user285", "review_text": "The open speaker meeting was a bit different from what I expected, but it turned out to be a fantastic experience. Hearing personal stories of recovery was both moving and motivating. Definitely worth attending."}, {"review_id": 8, "username": "user213", "review_text": "Attending this AA group has been a game-changer for me. The members are genuine, and the sharing sessions are heartfelt. I highly recommend it for anyone seeking a sense of community in recovery."}, {"review_id": 9, "username": "user473", "review_text": "The accountability-focused AA meeting was exactly what I needed. The group's commitment to supporting each other in staying sober is commendable. I feel more empowered on my journey to recovery."}, {"review_id": 10, "username": "user384", "review_text": "The Big Book study meeting was enlightening. Delving into the 12 steps has given me a new perspective on my recovery journey. The group's commitment to sobriety is truly inspiring. Solid 5 stars!"}, {"review_id": 11, "username": "user486", "review_text": "The accountability-focused AA meeting was exactly what I needed. The group's commitment to supporting each other in staying sober is commendable. I feel more empowered on my journey to recovery."}, {"review_id": 12, "username": "user447", "review_text": "Attending this AA group has been a game-changer for me. The members are genuine, and the sharing sessions are heartfelt. I highly recommend it for anyone seeking a sense of community in recovery."}, {"review_id": 13, "username": "user394", "review_text": "This AA community provides a safe and non-judgmental space for individuals recovering from alcohol addiction. The diversity of experiences shared adds richness to the discussions. A supportive environment overall."}, {"review_id": 14, "username": "user304", "review_text": "The accountability-focused AA meeting was exactly what I needed. The group's commitment to supporting each other in staying sober is commendable. I feel more empowered on my journey to recovery."}, {"review_id": 15, "username": "user175", "review_text": "This beginner-friendly AA meeting provided me with the information I needed to start my recovery journey. The members were supportive, and I left with a renewed sense of hope. A valuable experience for newcomers."}, {"review_id": 16, "username": "user462", "review_text": "Attending this AA group has been a game-changer for me. The members are genuine, and the sharing sessions are heartfelt. I highly recommend it for anyone seeking a sense of community in recovery."}, {"review_id": 17, "username": "user406", "review_text": "Attending this AA discussion group has become a crucial part of my recovery routine. The sharing of experiences and challenges is relatable, and the sense of unity is palpable. Highly recommended for those seeking connection."}, {"review_id": 18, "username": "user164", "review_text": "The open speaker meeting was a bit different from what I expected, but it turned out to be a fantastic experience. Hearing personal stories of recovery was both moving and motivating. Definitely worth attending."}, {"review_id": 19, "username": "user238", "review_text": "The Big Book study meeting was enlightening. Delving into the 12 steps has given me a new perspective on my recovery journey. The group's commitment to sobriety is truly inspiring. Solid 5 stars!"}, { "review_id": 20, "username": "user1000", "review_text": "Best meeting group in NYC."} ] 33:T696, viewof map = { const container = html`

`; yield container; // Give the container dimensions. const map = container.value = new mapboxgl.Map({ container, center: [-73.973103, 40.781031], // long lat in mapbox zoom: 11, style: "mapbox://styles/mapbox/light-v11", scrollZoom: false }); // Add zoom and rotation controls to the map. map.addControl(new mapboxgl.NavigationControl()); const markers = []; for (const element of daysQuery) { const thisMarker = new mapboxgl.Marker() .setLngLat([element.long, element.lat]) .addTo(map); thisMarker.setPopup(new mapboxgl.Popup().setHTML(`

${element.group_name || ''}

${element.building_name || ''}

${element.address_clean}
${element.day}, ${element.start_time}

Meeting Type: ${element.meeting_type ? element.meeting_type : 'N/A'}

Wheelchair Access: ${element.wheelchair_access ? element.wheelchair_access : 'N/A'}

${element.special_interest || ''}

"${element.review_text || ''}" ${element.username|| ''}

`)); //if null, show empty string markers.push(thisMarker); } // // Zoom to the first marker // if (markers.length > 0) { // const firstMarkerLngLat = markers[0].getLngLat(); // map.flyTo({ // center: [firstMarkerLngLat.lng, firstMarkerLngLat.lat], // zoom: 15, // }); // } invalidation.then(() => { // Remove markers and popups on invalidation for (const marker of markers) { marker.remove(); } map.remove(); // Remove the map as well }); }34:[{"id":"b26871933535645182651ac08fb1bc28eac3748c874d683059281da71e5c9c91974591fa4e3ef416971e595f9b3a4893db01650eacd63169a67b1fdfe1abd99a","href":"https://static.observableusercontent.com/files/b26871933535645182651ac08fb1bc28eac3748c874d683059281da71e5c9c91974591fa4e3ef416971e595f9b3a4893db01650eacd63169a67b1fdfe1abd99a","name":"AA_Data_Cleaned.csv","type":"text/csv","lastModified":1701221157776.665,"size":256672},{"id":"1d9bab02c9de5637646f21dbf3fa12490f743abde78feb4c4f04c074e8f72bc16c536aa996affcffe30130b94e85d2c20d5553c3596709b5753c99f3df9e745d","href":"https://static.observableusercontent.com/files/1d9bab02c9de5637646f21dbf3fa12490f743abde78feb4c4f04c074e8f72bc16c536aa996affcffe30130b94e85d2c20d5553c3596709b5753c99f3df9e745d","name":"AA_Data_Cleaned_Final.csv","type":"text/csv","lastModified":1702351764554.102,"size":254221},{"id":"e30ac9d47c4581294325c15a366b9b0a1d80e23d22d4e427604105b8174865cee17386850c3254cf6827d63c1f4c018c41a52797b5bd1514bfa55431124ccbeb","href":"https://static.observableusercontent.com/files/e30ac9d47c4581294325c15a366b9b0a1d80e23d22d4e427604105b8174865cee17386850c3254cf6827d63c1f4c018c41a52797b5bd1514bfa55431124ccbeb","name":"AA_Data_Final.csv","type":"text/csv","lastModified":1702388857096.777,"size":175062}] 30:{"id":"537f6a13b50b08f5","slug":null,"title":"Integrating DuckDB, user inputs, and Mapbox for AA Meeting Data","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-11-15T18:07:39.776Z","update_time":"$D2023-12-12T15:32:16.507Z","view_time":null,"first_public_time":"$D2023-11-15T18:07:39.776Z","has_unpublished_edits":null,"fork":{"id":"da3f3c7bef895f04","slug":"integrating-duckdb-user-inputs-and-mapbox","title":"Integrating DuckDB, user inputs, and Mapbox","owner":{"id":"3d100e334331cdef","login":"aaronxhill","name":"Aaron Hill"}},"stars":0,"starred":false,"owner":{"type":"team","id":"dd87817855e2f67e","login":"amatevosian-ws","name":"amatevosian's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/53040651c350a1736aaf50889467a48c17db09b127ec6a4e7f00e97871e40ae8","tier":"starter_2024"},"version":608,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"8883bd79828dc0ea","login":"amatevosian","name":"amatevosian","avatar_url":"https://avatars-next.observableusercontent.com/29b1a6267e6384169966a80a73a265efdc2371b2b959446691b7fbae82dd6bbc","tier":null}],"members":[{"type":"individual","id":"8883bd79828dc0ea","login":"amatevosian","name":"amatevosian","avatar_url":"https://avatars-next.observableusercontent.com/29b1a6267e6384169966a80a73a265efdc2371b2b959446691b7fbae82dd6bbc","tier":null,"role":"editor"},{"type":"team","id":"dd87817855e2f67e","login":"amatevosian-ws","name":"amatevosian's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/53040651c350a1736aaf50889467a48c17db09b127ec6a4e7f00e97871e40ae8","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Integrating DuckDB, user inputs, and Mapbox for AA Meeting Data","cells":[{"id":0,"value":"# Integrating DuckDB, user inputs, and Mapbox for AA Meeting Data\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":395,"value":"

Overview:

Ten meeting list agenda pages for Alcoholics Anonymous (AA) were parsed and stored in a new structure. Users can input day, time, and meeting type to filter through the data and view the meetings on a map.

\n\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":461,"value":"

Part 1

Below is an array of reviews for some of the meetings.","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":65,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$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","output":"","database":"$undefined"},{"id":3,"value":"client = DuckDBClient.of({\n meetings: FileAttachment(\"AA_Data_Final.csv\"),\n reviews: reviewData\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"client","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":320,"value":"SELECT column00, \"group_name\", Day, \"start_time\", \"address_clean\",\"wheelchair_access\", \"special_interest\", \"day\", \"meeting_type\", \"review_text\", \"username\", \"start_hr_24\"\nFROM meetings \nLEFT OUTER JOIN reviews ON meetings.column00 = reviews.review_id\nORDER BY column00;","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"meetings_reviews","database":"var:client"},{"id":328,"value":"SELECT\n meetings.*,\n reviews.*\nFROM\n meetings\nLEFT OUTER JOIN\n reviews\nON\n meetings.column00 = reviews.review_id;","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"meetings","database":"var:client"},{"id":98,"value":"### Save data from a query to a JavaScript variable\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":187,"value":"SELECT\n meetings.*,\n reviews.*\nFROM\n meetings\nLEFT OUTER JOIN\n reviews\nON\n meetings.column00 = reviews.review_id \n \n\nWHERE day = ${d} AND meetings.\"start_hr_24\" = ${st} ;\n\n","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"daysQuery","database":"var:client"},{"id":250,"value":"SELECT start_time\nFROM meetings\n","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"ST","database":"var:client"},{"id":192,"value":"d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"st","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"daysQuery","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"meetingtype = {\nlet meetingtype = [];\nfor (let i= 0; i Part 2\n

Map generated from SQL query that updates on user input

Select day and time (in military 24-hr format) to filter meetings.

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":138,"value":"d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"viewof d = Inputs.select(days, {label: \"Select Day\"});\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"viewof st = Inputs.range([1,24],{step:1}, {label: \"Select Start Time\"})\n \n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":406,"value":"Run the cell below to see the updated selected time (each time you update the time slider).","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":381,"value":"time = htl.html`The selected time (in military time) is ${[viewof st.value]}.`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"

Navigate the Map to View Meetings that Match Your Inputs

Each marker on the map represents an individual meeting. \n Click the markers to view details like the address, accessibility, meeting type, and individual meeting reviews, if available (note: many do not currently contain meeting reviews).

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":127,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$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} //doesn't need to change, keep this cell to run?","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"accessToken = \"pk.eyJ1IjoibW9sbGllbWFyaWUiLCJhIjoiY2txNXF0Mmw5MTVvdDJ3b2N3bHhobXN6aCJ9.ztC4Av-WFMynvpwyFgUiGw\"\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"days = [\"Sunday\", \"Monday\", \"Tuesday\", \"Wednesday\", \"Thursday\", \"Friday\", \"Saturday\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":287,"value":"SELECT distinct \"start_hr_24\" AS times\nFROM meetings","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"times","database":"var:client"},{"id":574,"value":"SELECT distinct \"start_time\"\nFROM meetings","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"starttimes","database":"var:client"},{"id":306,"value":"SELECT DISTINCT start_hr_24\nFROM meetings\nORDER BY start_hr_24 DESC; ","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"start_time_query","database":"var:client"},{"id":347,"value":"FROM meetings\nSELECT DISTINCT meeting_type;","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"meeting_type_query","database":"var:client"},{"id":310,"value":"start_times = {\nlet starttime = [];\nfor (let i= 0; i