2d:null 2e:["$","title",null,{"children":"Shared Imports | Office for Statistics and Data of the Canton of Zurich | Observable"}] 33:T6d2,swatches = function({ color, columns = null, format = x => x, swatchSize = 16, swatchWidth = swatchSize, swatchHeight = swatchSize, marginLeft = 0 }) { const id = DOM.uid().id; if (columns !== null) return html`

${color.domain().map(value => { const label = format(value); return html`

${document.createTextNode(label)}

`; })}

`; return html`

${color .domain() .map( value => html`${document.createTextNode(format(value))}` )}

`; }34:T800,/** * createPNG creates an png file from a given element id on the page and additional parameters. * use named parameters in an object literal for every argument. * @param {String} config.containerId html-id of an element to be exported with all it's childern. * @param {String} config.filename Name of the generated png-file, should end with .png (optional, default is "Grafik.png") * @param {Number} config.width * @param {String} config.padding */ createPNG = function (config) { let containerId = config.containerId == undefined ? undefined : config.containerId; let filename = config.filename == undefined ? "Grafik.png" : config.filename; let node = document.getElementById(containerId); const filter = (node) => { const exclusionClasses = ["dropdown"]; if (node.classList != undefined) { return !exclusionClasses.some((classname) => node.classList.contains(classname) ); } else { return true; } }; const nodeWidth = node.style.width; const nodePadding = node.style.padding; if (config.padding) { node.style.padding = config.padding; } if (config.width) { node.style.width = config.width + "px"; } /*htmlToImage.toBlob(node, { filter: filter}) .then(function (blob) { window.saveAs(blob, 'my-node.png'); });*/ htmlToImage .toPng(node, { quality: 1, filter: filter, backgroundColor: "#ffffff", cacheBust: true }) .then(function (dataUrl) { var link = document.createElement("a"); link.download = filename; link.href = dataUrl; link.click(); if (config.padding) { node.style.padding = nodePadding; } if (config.width) { node.style.width = nodeWidth; } }); /*htmlToImage.toJpeg(node, { quality: 1, filter: filter, backgroundColor: "#ffffff", cacheBust: true}) .then(function (dataUrl) { var link = document.createElement('a'); link.download = 'my-image-name.jpeg'; link.href = dataUrl; link.click(); });*/ }35:T477b,/** * createXLSX creates an xlsx file from a given dataset and additional parameters. * use named parameters in an object literal, for every argument but data. * @param {Array} config.data Each element of an array is a row, each row consists of on an object with all cells, each named by it's column title. * @param {Array} config.columns Array of all the collumn titles (optional) * @param {Array} config.datatypes Ordered array of the data types of all the collumns (optional, default is String) * @param {String} config.title Main title of the Dataset (optional, row is left out if not defined or empty string) * @param {String} config.subtitle Subtitle for the Dataset (optional, row is left out if not defined or empty string) * @param {String} config.description Any additional information on a dataset (optional, row is left out if not defined or empty string) * @param {String} config.source Source of the dataset to be displayed at the bottom (optional, row is left out if not defined or empty string) * @param {Boolean} config.autofilter Turns on autorfilter for every collumn with data if it contains data (option, default is false) * @param {String} config.filename Name of the generated xlsx-file, should end with .xlsx (optional, default is "Datentabelle.xlsx") */ createXLSX = function (config) { let data = config.data == undefined ? undefined : config.data; let columns = config.columns == undefined ? Object.keys(data[0]) : config.columns; let columnNames = config.columnNames == undefined ? config.columns == undefined ? Object.keys(data[0]) : config.columns : config.columnNames; let datatypes = config.datatypes == undefined ? undefined : config.datatypes; let title = config.title == undefined ? undefined : config.title; let subtitle = config.subtitle == undefined ? undefined : config.subtitle; let description = config.description == undefined ? undefined : config.description; let source = config.source == undefined ? undefined : config.source; let autofilters = config.autofilters == undefined ? false : config.autofilters; let filename = config.filename == undefined ? "Datentabelle.xlsx" : config.filename; //Throw error if data is undefined. if (typeof data == "undefined") { throw new Error("The data for the excel export has not been provided."); } let Datasheets = {}; //create workbook object and define some attributes var workbook = new ExcelJS.Workbook(); workbook.creator = config.contact[0]; workbook.lastModifiedBy = config.contact[0]; workbook.created = new Date(); workbook.modified = new Date(); //workbook.lastPrinted = new Date(); if (typeof datatypes == "undefined") { datatypes = []; for (var i = 0; i < columns.length; i++) { datatypes.push("string"); } } //create worksheet object var worksheet = workbook.addWorksheet("Datenblatt"); var minCellWidth = 10; var maxCellWidth = 100; //Define column widths depending on data Datasheets.cellWidths = []; //console.log(columns) for (i = 0; i < columns.length; ++i) { var cw = d3.max(data, function (d) { let wert = formater(datatypes[i], d[columns[i]]); return getTextWidth(wert, "10pt arial"); }) / 7.025 + 2; Datasheets.cellWidths.push(cw); } //Define width depending on column names, where names are wider than data for (let i = 0; i < columnNames.length; ++i) { let keyarray = columnNames[i].split(" "); let keywidth = 0; for (let j = 0; j < keyarray.length; ++j) { if (keywidth < getTextWidth(keyarray[j], "10pt arial")) { keywidth = getTextWidth(keyarray[j], "10pt arial"); } } var cw = keywidth / 7.025 + 2; if (Datasheets.cellWidths[i] < cw) { Datasheets.cellWidths[i] = cw; } } //Limit column widths with min and max for (i = 0; i < columns.length; ++i) { if (Datasheets.cellWidths[i] < minCellWidth) { Datasheets.cellWidths[i] = minCellWidth; } if (Datasheets.cellWidths[i] > maxCellWidth) { Datasheets.cellWidths[i] = maxCellWidth; } } //Fill array with default width for remaining columns up to 100 for (i = columns.length; i < 100; i++) { Datasheets.cellWidths.push(8.43); } //Create array with summed up column widths Datasheets.cellWidthsSums = [0.0]; for (i = 0; i < Datasheets.cellWidths.length; ++i) { Datasheets.cellWidthsSums.push( Datasheets.cellWidthsSums[i] + Datasheets.cellWidths[i] ); } //Define columns var defineColumns = []; for (i = 0; i < columns.length; i++) { defineColumns.push({ header: createRichText(columnNames[i], 10, false), key: columns[i], width: Datasheets.cellWidths[i] }); } /*for (i=columns.length; i<100; i++) { defineColumns.push({header: "", key: "", width: Datasheets.cellWidths[i], outlineLevel: 0}); }*/ worksheet.columns = defineColumns; //Counter for header rows and total rows (one row is allready defined though column definition) var headerRows = 1; var totalRows = 1; //If title exist splice it in at the top if (typeof title !== "undefined") { if (title != "") { var titlestr = createRichText([title], 20, true); var titlelength = getTextWidth(title, "20pt arial black"); worksheet.spliceRows(headerRows, 0, [titlestr]); ++headerRows; ++totalRows; } } //If subtitle exists splice it in if (typeof subtitle !== "undefined") { if (subtitle != "") { var subtitlestr = createRichText([subtitle], 12, true); var subtitlelength = getTextWidth(subtitle, "12pt arial black"); worksheet.spliceRows(headerRows, 0, [subtitlestr]); var subtitleRow = headerRows; ++headerRows; ++totalRows; } } //Splice in spacer row worksheet.spliceRows(headerRows, 0, [""]); var spacerRow = headerRows; ++headerRows; ++totalRows; //Add actual data to sheet data.forEach(function (d) { var cellContent = []; for (i = 0; i < columns.length; ++i) { switch (datatypes[i]) { case "string": case "year": var cellCT = createRichText(d[columns[i]], 10, false); break; case "date": var cellCT = d3.time.hour.offset(d[columns[i]], 2); break; default: var cellCT = d[columns[i]]; break; } //Wandelt undefined und NaN in "" um. if ((cellCT == undefined) | (cellCT !== cellCT)) { cellCT = ""; } cellContent.push(cellCT); } worksheet.addRow(cellContent); ++totalRows; }); //Add spacer row at the bottom, before remaining meta data worksheet.addRow([""]); ++totalRows; //If description exists add it at the bottom if (typeof description !== "undefined") { if (description != "") { var descriptionstr = createRichText([description], 10, false); worksheet.addRow([descriptionstr]); ++totalRows; var descriptionRow = totalRows; } } //If source exist add it at the bottom if (typeof source !== "undefined") { if (source != "") { var sourcestr = createRichText([source], 10, false); worksheet.addRow(["Datenquelle: " + sourcestr]); ++totalRows; var sourceRow = totalRows; } } //Add spacer row at the bottom, before remaining meta data worksheet.addRow([""]); ++totalRows; var logoRow = totalRows; //Add file source in any case worksheet.addRow(config.contact); ++totalRows; var filesourceRow = totalRows; //Add border to data portion (including header row) for (i = headerRows; i < data.length + headerRows + 1; ++i) { var row = worksheet.getRow(i); row.eachCell({ includeEmpty: true }, function (cell, colNumber) { cell.border = { top: { style: "thin", color: { argb: "FFD9D9D9" } }, left: { style: "thin", color: { argb: "FFD9D9D9" } }, bottom: { style: "thin", color: { argb: "FFD9D9D9" } }, right: { style: "thin", color: { argb: "FFD9D9D9" } } }; }); } //Add font to all rows worksheet.eachRow({ includeEmpty: true }, function (row, rowNumber) { row.font = { name: "Arial", family: 2, size: 10 }; }); //Add formating to metadata rows Datasheets.cellHeights = []; var headerHeight = 0.0; var maxMerge = 20; //Add formating to title row if (typeof titlelength != "undefined") { var firstRow = worksheet.getRow(1); firstRow.font = { name: "Arial Black", family: 2, size: 20, bold: true }; firstRow.alignment = { vertical: "middle", horizontal: "left", wrapText: true }; //Merge cells //default is 8 var merge = 8; //increase merge area as long as the content is bigger, the area is reasonably small and the merged area is not broader then the columns with data and not more than 20 colums wide while ( (Datasheets.cellWidthsSums[merge] < titlelength / 7.025 + 10) & (Datasheets.cellWidthsSums[merge] < 150) & (merge < columns.length) & (merge < 20) ) { ++merge; } //actually merge the cells worksheet.mergeCells(1, 1, 1, merge); //adapt row height firstRow.height = Math.ceil((titlelength / 7.95 + 10) / Datasheets.cellWidthsSums[merge]) * 30; Datasheets.cellHeights.push(firstRow.height); headerHeight += firstRow.height; if (merge > maxMerge) { maxMerge = merge; } } var fontSizeSubtitle = 12; //Add formating to subtitle row if (typeof subtitle !== "undefined") { if (subtitle != "") { var secondRow = worksheet.getRow(subtitleRow); secondRow.font = { name: "Arial Black", family: 2, size: fontSizeSubtitle, bold: true }; secondRow.alignment = { vertical: "middle", horizontal: "left", wrapText: true }; //Merge cells //default is 8 var merge = 8; //increase merge area as long as the content is bigger, the area is reasonably small and the merged area is not broader then the columns with data and not more than 20 colums wide while ( (Datasheets.cellWidthsSums[merge] < subtitlelength / 7.95 + 10) & (Datasheets.cellWidthsSums[merge] < 150) & (merge < columns.length) & (merge < 20) ) { ++merge; } //actually merge the cells worksheet.mergeCells(subtitleRow, 1, subtitleRow, merge); secondRow.height = Math.ceil( (subtitlelength / 7.95 + 10) / Datasheets.cellWidthsSums[merge] ) * 20; Datasheets.cellHeights.push(secondRow.height); headerHeight += secondRow.height; if (merge > maxMerge) { maxMerge = merge; } } } worksheet.getRow(spacerRow).height = 15; Datasheets.cellHeights.push(15.0); //Adapt hight of logoRow to fit the logo worksheet.getRow(logoRow).height = 52; //Adapt header row so that text fits in cells var dataHeaderRow = worksheet.getRow(headerRows); dataHeaderRow.alignment = { vertical: "top", horizontal: "left", wrapText: true }; //find max rows let maxRows = 1; for (let i = 1; i <= dataHeaderRow._cells.length; ++i) { maxRows = Math.max( maxRows, Math.ceil( (getTextWidth(dataHeaderRow.getCell(i).value, "10pt arial") / 7.025 + 1) / Datasheets.cellWidths[i] ) ); } //adjust header row heights (add some space for auto filters) dataHeaderRow.height = maxRows * 15; if (autofilters == true) { dataHeaderRow.height = maxRows * 15 + 12; } Datasheets.cellHeights.push(dataHeaderRow.height); //Add cell heights to array for data rows (including spacer row at bottom) for (i = headerRows + 1; i < data.length + headerRows + 2; ++i) { worksheet.getRow(i).height = 15; Datasheets.cellHeights.push(15.0); worksheet.getRow(i).alignment = { vertical: "middle" }; } //Add formating to description row if (typeof description !== "undefined") { if (description != "") { var descRow = worksheet.getRow(descriptionRow); //descRow.font = { name: 'Arial', family: 2, size: 20, bold: true }; descRow.alignment = { vertical: "middle", horizontal: "left", wrapText: true }; //Merge cells var merge = 8; while ( (Datasheets.cellWidthsSums[merge] < getTextWidth(description, "10pt arial") / 7.025 + 10) & (Datasheets.cellWidthsSums[merge] < 90) ) { ++merge; } if (merge > 20) { merge = 20; } worksheet.mergeCells(descriptionRow, 1, descriptionRow, merge); descRow.height = Math.ceil( (getTextWidth(description, "10pt arial") / 7.025 + 10) / Datasheets.cellWidthsSums[merge] ) * 15; Datasheets.cellHeights.push(descRow.height); } } //Add formating to source row if (typeof source !== "undefined") { if (source != "") { var sourcRow = worksheet.getRow(sourceRow); sourcRow.alignment = { vertical: "middle", horizontal: "left", wrapText: true }; //Merge cells var merge = 8; while ( (Datasheets.cellWidthsSums[merge] < getTextWidth("Quelle: " + source[0].Content, "10pt arial") / 7.025 + 10) & (Datasheets.cellWidthsSums[merge] < 90) ) { ++merge; } if (merge > 20) { merge = 20; } worksheet.mergeCells(sourceRow, 1, sourceRow, merge); sourcRow.height = Math.ceil( (getTextWidth("Quelle: " + source[0].Content, "10pt arial") / 7.025 + 10) / Datasheets.cellWidthsSums[merge] ) * 15; Datasheets.cellHeights.push(sourcRow.height); } } //Add formating to filesource row var filesourcRow = worksheet.getRow(filesourceRow); filesourcRow.alignment = { vertical: "middle", horizontal: "left", wrapText: true }; //Merge cells var merge = 8; while ( (Datasheets.cellWidthsSums[merge] < getTextWidth("", "10pt arial") / 7.025 + 10) & (Datasheets.cellWidthsSums[merge] < 90) ) { ++merge; } if (merge > 20) { merge = 20; } worksheet.mergeCells(filesourceRow, 1, filesourceRow, merge); filesourcRow.height = Math.ceil( (getTextWidth("", "10pt arial") / 7.025 + 10) / Datasheets.cellWidthsSums[merge] ) * 15; Datasheets.cellHeights.push(filesourcRow.height); //Create array with summed up cell heights Datasheets.cellHeightsSums = [0.0]; for (i = 0; i < Datasheets.cellHeights.length; ++i) { Datasheets.cellHeightsSums.push( Datasheets.cellHeightsSums[i] + Datasheets.cellHeights[i] ); } function calculateWidthinCells(width) { var result = [0, 0]; while (Datasheets.cellWidthsSums[result[0]] < width) { ++result[0]; } --result[0]; result[1] = Math.round( (width - Datasheets.cellWidthsSums[result[0]]) * 7.025 ); return result; } function calculateHeightinCells(height) { var result = [0, 0]; while (Datasheets.cellHeightsSums[result[0]] < height) { ++result[0]; } --result[0]; result[1] = Math.round( (height - Datasheets.cellHeightsSums[result[0]]) * 1.27 ); return result; } // add image to workbook by base64 // var logo = ""; // var imageId1 = workbook.addImage({ // base64: logo, // extension: "png" // }); //Position fixed from left var headerWidth = Math.max(60, Datasheets.cellWidthsSums[maxMerge]); var imageWidthStart = calculateWidthinCells(headerWidth); var imageWidthEnd = calculateWidthinCells(headerWidth + 35); var imageHeightEnd = calculateHeightinCells(79); var imageWidthEnd2 = calculateWidthinCells(33.1); // worksheet.addImage(imageId1, { // tl: { col: 0, row: logoRow - 1 }, // ext: { width: 223, height: 69 } // }); worksheet.views = [ { state: "frozen", xSplit: 0, ySplit: headerRows, activeCell: "A1", showGridLines: false } ]; //Seitendefinitionen fürs Drucken worksheet.pageSetup.paperSize = 9; if (Datasheets.cellWidthsSums[columns.length] <= 95) { worksheet.pageSetup.orientation = "portrait"; } else { worksheet.pageSetup.orientation = "landscape"; } worksheet.pageSetup.scale = 78; console.log(autofilters); if (autofilters == true) { worksheet.autoFilter = { from: { row: headerRows, column: 1 }, to: { row: headerRows, column: columns.length } }; } for (i = 0; i < datatypes.length; i++) { switch (datatypes[i]) { case "int": case "integer": worksheet.getColumn(i + 1).numFmt = "#,##0"; break; case "float": worksheet.getColumn(i + 1).numFmt = "#,##0.0"; break; case "float2": worksheet.getColumn(i + 1).numFmt = "#,##0.00"; break; case "float6": worksheet.getColumn(i + 1).numFmt = "#,##0.000000"; break; case "percentage": worksheet.getColumn(i + 1).numFmt = "0.00%"; break; case "chf": worksheet.getColumn(i + 1).numFmt = '"Fr." #,##0.00'; break; case "miochf": worksheet.getColumn(i + 1).numFmt = '#,##0.00 "Mio Fr."'; break; case "floatha": worksheet.getColumn(i + 1).numFmt = '#,##0.00 "ha"'; break; case "dateyear": worksheet.getColumn(i + 1).numFmt = "yyyy"; break; case "date": worksheet.getColumn(i + 1).numFmt = "dd.mm.yyyy"; break; case "week": worksheet.getColumn(i + 1).numFmt = '"Woche vom" dd.mm.yyyy'; break; case "datemonthyear": worksheet.getColumn(i + 1).numFmt = "mmm yyyy"; break; case "terrajoule": worksheet.getColumn(i + 1).numFmt = '#,##0 "TJ"'; break; } } if (true) { var buff = workbook.xlsx.writeBuffer().then(function (xlsxdata) { var blob = new Blob( [ xlsxdata ] /*, {type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"}*/ ); saveAs(blob, filename); }); } }36:T1115,// The MIT License (MIT) // // Copyright (c) 2014 Federal Office of Topography swisstopo, Wabern, CH // Copyright (c) 2016 Sacha Bron https://github.com/BinaryBrain // Copyright (c) 2016 Basile Vu https://github.com/Flagoul // // Permission is hereby granted, free of charge, to any person obtaining a copy // of this software and associated documentation files (the "Software"), to deal // in the Software without restriction, including without limitation the rights // to use, copy, modify, merge, publish, distribute, sublicense, and/or sell // copies of the Software, and to permit persons to whom the Software is // furnished to do so, subject to the following conditions: // // The above copyright notice and this permission notice shall be included in // all copies or substantial portions of the Software. // // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR // IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, // FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE // AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER // LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, // OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN // THE SOFTWARE. // // Source: http://www.swisstopo.admin.ch/internet/swisstopo/en/home/topics/survey/sys/refsys/projections.html (see PDFs under "Documentation") // Updated 9 dec 2014 // Please validate your results with NAVREF on-line service: http://www.swisstopo.admin.ch/internet/swisstopo/en/home/apps/calc/navref.html (difference ~ 1-2m) Swisstopo = ({ WGStoCH: function (lat, lng) { return [this.WGStoCHy(lat, lng), this.WGStoCHx(lat, lng)]; }, // Convert WGS lat/lng (� dec) to CH x WGStoCHx: function (lat, lng) { // Convert decimal degrees to sexagesimal seconds lat = this.DECtoSEX(lat); lng = this.DECtoSEX(lng); // Auxiliary values (% Bern) var lat_aux = (lat - 169028.66) / 10000; var lng_aux = (lng - 26782.5) / 10000; // Process X var x = 200147.07 + 308807.95 * lat_aux + 3745.25 * Math.pow(lng_aux, 2) + 76.63 * Math.pow(lat_aux, 2) - 194.56 * Math.pow(lng_aux, 2) * lat_aux + 119.79 * Math.pow(lat_aux, 3); return x; }, // Convert WGS lat/lng (� dec) to CH y WGStoCHy: function (lat, lng) { // Convert decimal degrees to sexagesimal seconds lat = this.DECtoSEX(lat); lng = this.DECtoSEX(lng); // Auxiliary values (% Bern) var lat_aux = (lat - 169028.66) / 10000; var lng_aux = (lng - 26782.5) / 10000; // Process Y var y = 600072.37 + 211455.93 * lng_aux - 10938.51 * lng_aux * lat_aux - 0.36 * lng_aux * Math.pow(lat_aux, 2) - 44.54 * Math.pow(lng_aux, 3); return y; }, CHtoWGS: function (y, x) { return [this.CHtoWGSlng(y, x), this.CHtoWGSlat(y, x)]; }, // Convert CH y/x to WGS lat CHtoWGSlat: function (y, x) { // Converts military to civil and to unit = 1000km // Auxiliary values (% Bern) var y_aux = (y - 600000) / 1000000; var x_aux = (x - 200000) / 1000000; // Process lat var lat = 16.9023892 + 3.238272 * x_aux - 0.270978 * Math.pow(y_aux, 2) - 0.002528 * Math.pow(x_aux, 2) - 0.0447 * Math.pow(y_aux, 2) * x_aux - 0.014 * Math.pow(x_aux, 3); // Unit 10000" to 1 " and converts seconds to degrees (dec) lat = (lat * 100) / 36; return lat; }, // Convert CH y/x to WGS lng CHtoWGSlng: function (y, x) { // Converts military to civil and to unit = 1000km // Auxiliary values (% Bern) var y_aux = (y - 600000) / 1000000; var x_aux = (x - 200000) / 1000000; // Process lng var lng = 2.6779094 + 4.728982 * y_aux + 0.791484 * y_aux * x_aux + 0.1306 * y_aux * Math.pow(x_aux, 2) - 0.0436 * Math.pow(y_aux, 3); // Unit 10000" to 1 " and converts seconds to degrees (dec) lng = (lng * 100) / 36; return lng; }, // Convert angle in decimal degrees to sexagesimal seconds DECtoSEX: function (angle) { // Extract DMS var deg = parseInt(angle); var min = parseInt((angle - deg) * 60); var sec = ((angle - deg) * 60 - min) * 60; // Result sexagesimal seconds return sec + min * 60.0 + deg * 3600.0; } })37:T4f6,function radio(config = {}) { let { value: formValue, title, description, submit, options, disabled } = Array.isArray(config) ? { options: config } : config; options = options.map(o => typeof o === "string" ? { value: o, label: o } : o ); const form = input({ type: "radio", title, description, submit, getValue: input => { if (input.checked) return input.value; const checked = Array.prototype.find.call(input, radio => radio.checked); return checked ? checked.value : undefined; }, form: html` ` }); form.output.remove(); return form; }38:Ta6b,function input(config) { let { form, type = "text", attributes = {}, action, getValue, title, description, format, display, submit, options } = config; const wrapper = html`

`; if (!form) form = html`

` ); form.append( html`` ); if (title) form.prepend( html`

${title}

` ); if (description) form.append( html`

${description}

` ); if (format) format = typeof format === "function" ? format : d3format.format(format); if (action) { action(form); } else { const verb = submit ? "onsubmit" : type == "button" ? "onclick" : type == "checkbox" || type == "radio" ? "onchange" : "oninput"; form[verb] = (e) => { e && e.preventDefault(); const value = getValue ? getValue(form.input) : form.input.value; if (form.output) { const out = display ? display(value) : format ? format(value) : value; if (out instanceof window.Element) { while (form.output.hasChildNodes()) { form.output.removeChild(form.output.lastChild); } form.output.append(out); } else { form.output.value = out; } } form.value = value; if (verb !== "oninput") form.dispatchEvent(new CustomEvent("input", { bubbles: true })); }; if (verb !== "oninput") wrapper.oninput = (e) => e && e.stopPropagation() && e.preventDefault(); if (verb !== "onsubmit") form.onsubmit = (e) => e && e.preventDefault(); form[verb](); } while (form.childNodes.length) { wrapper.appendChild(form.childNodes[0]); } form.append(wrapper); return form; }39:[{"id":"1a2e95ea62804b9cfef595b6d55690d274e2ec68f77b6c9754f76555cb5d2f5c095cf0878b26e1d78d40b195aa1362a87bbf177a7e091ae6a2d691d9eac64147","href":"https://static.observableusercontent.com/files/1a2e95ea62804b9cfef595b6d55690d274e2ec68f77b6c9754f76555cb5d2f5c095cf0878b26e1d78d40b195aa1362a87bbf177a7e091ae6a2d691d9eac64147","name":"statistisches_amt_kt_zh.png","type":"image/png","lastModified":1614757703202.807,"size":10045}] 31:{"id":"37f68a80161fefa3","slug":"shared-imports","title":"Shared Imports","thumbnail":"5fd6ebf37c4ce9f4544e5337aeff78c4ac1b7b9f12f555168250662b532a83dd","access_level":"public","create_time":"$D2021-03-03T07:47:29.441Z","update_time":"$D2025-10-16T17:58:50.028Z","view_time":null,"first_public_time":"$D2021-03-03T07:53:43.012Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich","avatar_url":"https://avatars-next.observableusercontent.com/61364635cd5db7a914727e7625ac41daa90fedeba239e3d2ce93b57a9ad3bce9","tier":"pro"},"version":374,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"37f1612f224a0555","login":"mmznrstat","name":"Matthias Mazenauer","avatar_url":"https://avatars-next.observableusercontent.com/ef3d946ccf160cca48b7f42bef702f21fe993881f97ef1654f4d43be2e36569d","tier":null}],"members":[{"type":"individual","id":"37f1612f224a0555","login":"mmznrstat","name":"Matthias Mazenauer","avatar_url":"https://avatars-next.observableusercontent.com/ef3d946ccf160cca48b7f42bef702f21fe993881f97ef1654f4d43be2e36569d","tier":null,"role":"editor"},{"type":"team","id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich","avatar_url":"https://avatars-next.observableusercontent.com/61364635cd5db7a914727e7625ac41daa90fedeba239e3d2ce93b57a9ad3bce9","tier":"pro","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"96fe6934007d014f","slug":"templates","title":"Templates","owner":{"id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich"}},"type":"notebook","body":{"title":"Shared Imports","cells":[{"id":0,"value":"md`# Shared Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"logo = md`\n

${Object.assign(\n await FileAttachment(\"statistisches_amt_kt_zh.png\").image(),\n { alt: 'Girl reading', style: 'width: 100%; max-width: 440px;' }\n)}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"style = html`