25:["$","title",null,{"children":"AgroPatterns | AgroPatterns | Observable"}] 49:T44b,viewof grafica = Inputs.form( [ Inputs.select(sensores, { label: "Bloque", format: (x) => x.name }), Inputs.date({ label: "Fecha Incial", value: new Date(new Date().setDate(new Date().getDate() - 60)) }), Inputs.date({ label: "Fecha Final", value: new Date() }) ], { template: (inputs) => htl.html`

${Object.values(inputs)}

` } )4a:T462,viewof rangosTemp = Inputs.form( [ Inputs.range([0, 30], { value: 4, label: "Temp. Base (°C)", step: 1 }), Inputs.range([0, 15], { value: 4, label: "Temp. Min (°C)", step: 1 }), Inputs.range([22, 35], { value: 4, label: "Temp. Max (°C)", step: 1 }) ], { template: (inputs) => htl.html`

${Object.values(inputs)}

` } )4b:T42e,WITH daily_gdd AS ( SELECT CAST(timestamp AS DATE) AS day, bloque, device_id, AVG(t) AS avg_temp, MIN(t) AS min_temp, -- Calculate the minimum temperature for the day MAX(t) AS max_temp, -- Calculate the maximum temperature for the day GREATEST(AVG(t) - ${rangosTemp[0]}, 0) AS gradosDia -- Calculate daily GDD based on a defined base temperature FROM responses WHERE t > ${rangosTemp[1]} -- Filter for temperatures greater than the minimum defined elsewhere AND t < ${rangosTemp[2]} -- Filter for temperatures less than the maximum defined elsewhere AND device_id = ${grafica[0].sensor} -- Filter by specific sensor GROUP BY CAST(timestamp AS DATE), bloque, device_id -- Group by day, bloque, and device_id ) SELECT day AS dia, bloque, device_id, ROUND(avg_temp, 1) AS avg_temp, ROUND(gradosDia, 1) AS gradosDia, ROUND(SUM(gradosDia) OVER (PARTITION BY bloque, device_id ORDER BY day), 1) AS acumuladoGD FROM daily_gdd WHERE day BETWEEN ${grafica[1]} AND ${grafica[2]} -- Filter by date range ORDER BY day DESC; 4c:T4ec,function convertToCSV(data) { if (!data || !data.length) { return ""; } const csvRows = []; // Get the headers from the first object in the array const headers = Object.keys(data[0]); csvRows.push(headers.join(",")); // Loop over the rows and create CSV lines for (const row of data) { const values = headers.map((header) => { let value = row[header]; // Format dates to a shorter version (e.g., YYYY-MM-DD) if (value instanceof Date) { value = value.toISOString().split("T")[0]; // Convert Date to YYYY-MM-DD } else if ( typeof value === "string" && /^\d{4}-\d{2}-\d{2}T/.test(value) ) { // Check if the value is an ISO string resembling a date and shorten it value = value.split("T")[0]; } // Check if the value is a number and has decimals if (typeof value === "number" && !Number.isInteger(value)) { value = value.toFixed(2); } // Handle cases where the value contains commas, quotes, or newlines if (typeof value === "string") { value = value.replace(/"/g, '""'); // Escape double quotes } return `"${value}"`; }); csvRows.push(values.join(",")); } return csvRows.join("\n"); }4d:[{"id":"2c01ddc1975ffe4a3fc7f7b19a067f75fecd89b25970f938a046f2d067e6916389453a366f3bcc94bb6e88dda634c4483726c086dbf4ff7ecd24acb4fbdddafb","href":"https://static.observableusercontent.com/files/2c01ddc1975ffe4a3fc7f7b19a067f75fecd89b25970f938a046f2d067e6916389453a366f3bcc94bb6e88dda634c4483726c086dbf4ff7ecd24acb4fbdddafb","name":"sensorTempHumidityReadings-2.parquet","type":"application/octet-stream","lastModified":1733408663143.529,"size":4695513},{"id":"30eced6e23be895f38374d3ed9bf94f8384579793bfe1e051502a4f569ab6f7b06d309a6c643b9966414fee579f159ddb67be80d96491fad286fb15f5c042b56","href":"https://static.observableusercontent.com/files/30eced6e23be895f38374d3ed9bf94f8384579793bfe1e051502a4f569ab6f7b06d309a6c643b9966414fee579f159ddb67be80d96491fad286fb15f5c042b56","name":"sensorTempHumidityReadings.parquet","type":"application/octet-stream","lastModified":1733257637405.537,"size":5126606},{"id":"5026b0d255bfbe2fe343be943e74484f4fffb9c161789507e9355af23d8e4d4aef6f5881276fabf34f68c3d6398d0768f3750f74cda3a9ccfe2e3b11cec92024","href":"https://static.observableusercontent.com/files/5026b0d255bfbe2fe343be943e74484f4fffb9c161789507e9355af23d8e4d4aef6f5881276fabf34f68c3d6398d0768f3750f74cda3a9ccfe2e3b11cec92024","name":"combined_devices_12-08.parquet","type":"application/octet-stream","lastModified":1733667487734.795,"size":1485085},{"id":"77bc9f605d3fbc0b3bd6dc5af67499901b00792b4c67136b122c7ff6b1ac047634170d4250b6e87687075a30c5728751f5eb7e6abb58bfaf8f56b5668f6a3ed7","href":"https://static.observableusercontent.com/files/77bc9f605d3fbc0b3bd6dc5af67499901b00792b4c67136b122c7ff6b1ac047634170d4250b6e87687075a30c5728751f5eb7e6abb58bfaf8f56b5668f6a3ed7","name":"sensorTempHumidityReadings (2).parquet","type":"application/octet-stream","lastModified":1733320203258.144,"size":5126509},{"id":"4d604b12e5ea99072f2a4137439b5f173f25cce96bf89827f7c8e5629106f6c6151b9c8bc743aff046f44013f44ed64df8b7ad891289ba689a7cae6ce37dbd26","href":"https://static.observableusercontent.com/files/4d604b12e5ea99072f2a4137439b5f173f25cce96bf89827f7c8e5629106f6c6151b9c8bc743aff046f44013f44ed64df8b7ad891289ba689a7cae6ce37dbd26","name":"sensorTempHumidityReadings-2@1.parquet","type":"application/octet-stream","lastModified":1733709311975.259,"size":4719877}] 29:{"id":"caa07a4f0197ba98","slug":null,"title":"AgroPatterns","thumbnail":"2ecde4dda13ffe25f5f76a6642affffd5f30373fe36d3c5ff09dd8d692fab1fe","access_level":"unlisted","create_time":"$D2024-12-03T20:26:23.775Z","update_time":"$D2024-12-09T01:55:05.615Z","view_time":null,"first_public_time":null,"has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"c4dbc581a6dcc8e0","login":"agropatterns","name":"AgroPatterns","avatar_url":"https://avatars-next.observableusercontent.com/bf43ed660cc2c271a795244cd7a6b313e0df26a68c42f0c14b7aed9f5653f769","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":711,"publish_version":null,"role":null,"authored":false,"authors":[],"members":[{"type":"individual","id":"7ff6bd0b10289728","login":"gcoch","name":"Gabriel Coch","avatar_url":"https://avatars-next.observableusercontent.com/9dd1ebc4f82239794f8c01fe1de0ea2d82a40676208a72285db42c35cfaac423","tier":null,"role":"editor"},{"type":"team","id":"c4dbc581a6dcc8e0","login":"agropatterns","name":"AgroPatterns","avatar_url":"https://avatars-next.observableusercontent.com/bf43ed660cc2c271a795244cd7a6b313e0df26a68c42f0c14b7aed9f5653f769","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"AgroPatterns","cells":[{"id":600,"value":"# AgroPatterns","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":0,"value":"titulo1 = htl.html`

Grados Día de Crecimiento

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":619,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"graficaGD = Plot.plot({\n subtitle: htl.html`

Grados Día Acumulados: Bloque: ${grafica[0].name}

`,\n color: { legend: true },\n width: width,\n height: 500,\n marginLeft: 60,\n padding: 0.2,\n marginRight: 20,\n grid: true,\n insetTop: 30,\n insetBottom: 10,\n style: {\n fontSize: 11,\n background: \"#fbffde\",\n color: \"black\"\n },\n x: { interval: \"day\" },\n y: { label: \"Grados Día - Acumulados\" },\n marks: [\n Plot.barY(prueba, {\n x: \"dia\",\n y: \"acumuladoGD\",\n fill: \"steelblue\",\n tip: true\n }),\n Plot.tickY(prueba, { x: \"dia\", stroke: \"red\", y: \"acumuladoGD\" }),\n Plot.ruleY([0]),\n Plot.frame()\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"$4b","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"prueba","database":"var:sensorsdb"},{"id":577,"value":"descargarArchivo = {\n let button = Inputs.button(\"Descargar\");\n\n button.addEventListener(\"click\", function () {\n // Assuming `prueba` contains the preformatted CSV content\n const blob = new Blob([datosCSV], { type: \"text/csv\" }); // Create a Blob with the CSV content\n const element = document.createElement(\"a\");\n element.href = URL.createObjectURL(blob);\n element.download = \"archivo.csv\"; // Set the filename\n element.style.display = \"none\";\n document.body.appendChild(element);\n element.click();\n document.body.removeChild(element);\n URL.revokeObjectURL(element.href); // Clean up\n });\n\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":515,"value":"datosCSV = convertToCSV(prueba)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":534,"value":"function downloadCsvFile(filename, content) {\n // Convert JSON content to CSV\n const rows = Array.isArray(content) ? content : [content]; // Ensure content is an array\n const headers = Object.keys(rows[0]); // Get headers from the first object\n const csvContent = [\n headers.join(\",\"), // Add headers as the first row\n ...rows.map((row) =>\n headers.map((header) => JSON.stringify(row[header] ?? \"\")).join(\",\")\n ) // Add data rows\n ].join(\"\\n\");\n\n // Create a blob for the CSV content\n const blob = new Blob([csvContent], { type: \"text/csv\" });\n\n // Create a download link and trigger the download\n const element = document.createElement(\"a\");\n element.href = URL.createObjectURL(blob);\n element.download = filename.endsWith(\".csv\") ? filename : `${filename}.csv`; // Ensure .csv extension\n element.style.display = \"none\";\n document.body.appendChild(element);\n element.click();\n document.body.removeChild(element);\n URL.revokeObjectURL(element.href);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"sensorsdb = await DuckDBClient.of({\n responses: sensorTemp\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":426,"value":"sensores = [\n {\n name: \"Bloque 02\",\n code: \"B02\",\n sensor: \"dev:867730051163743\"\n },\n {\n name: \"Bloque 04\",\n code: \"B04\",\n sensor: \"dev:864475046458393\"\n },\n {\n name: \"Bloque 05 - Plantas Madre\",\n code: \"B05MADRE\",\n sensor: \"dev:867730051643504\"\n },\n {\n name: \"Bloque 05 - Enraizamiento\",\n code: \"B05-ENR\",\n sensor: \"dev:867730051163842\"\n },\n {\n name: \"Bloque 06\",\n code: \"B06\",\n sensor: \"dev:867730051767725\"\n },\n {\n name: \"Bloque 07\",\n code: \"B07\",\n sensor: \"dev:864475046461397\"\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":257,"value":"sensorTemp = FileAttachment(\"sensorTempHumidityReadings-2@1.parquet\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4d","stdlib":"1"}} 24:null