31:Te34,chart = { let show_public = () => show_on == "public" || show_on == "both"; let show_private = () => show_on == "private" || show_on == "both"; let data_baumbilanz = baumbilanz.filter( x => (show_private() && x['genehmigte_Fällungen_Privatflächen']) || (show_public() && x['Fällung_öffentliches_Grün']) ); return c3({ size: { height: width / 1.6 }, data: { x: 'year', names: { data_removal_private: 'approved tree removal on private land', data_plant_private: 'claimed tree planting on private land', data_removal_public: 'tree removal on public land', data_plant_public: 'tree planting on public land', data_total_amount: 'total net amount' }, columns: [ // x-axix ['year', ...data_baumbilanz.map(x => x['Jahr'])], // data od private land ...(show_private() ? [ [ 'data_plant_private', ...data_baumbilanz.map( x => x['festgesetzte_Ersatzpflanzungen_Privatflächen'] ) ], [ 'data_removal_private', ...data_baumbilanz.map( x => -x['genehmigte_Fällungen_Privatflächen'] ) ] ] : []), // data of public land ...(show_public() ? [ [ 'data_plant_public', ...data_baumbilanz.map(x => x['Ersatz_öffentliches_Grün']) ], [ 'data_removal_public', ...data_baumbilanz.map(x => -x['Fällung_öffentliches_Grün']) ] ] : []), // total amount [ 'data_total_amount', ...data_baumbilanz.map( x => (show_private() ? -1 : 0) * Number(x['genehmigte_Fällungen_Privatflächen']) + (show_private() ? 1 : 0) * Number(x['festgesetzte_Ersatzpflanzungen_Privatflächen']) + (show_public() ? -1 : 0) * Number(x['Fällung_öffentliches_Grün']) + (show_public() ? 1 : 0) * Number(x['Ersatz_öffentliches_Grün']) ) ] ], // columns colors: { data_removal_private: color_tree_private_removal, data_plant_private: color_tree_private_plant, data_removal_public: color_tree_public_removal, data_plant_public: color_tree_public_plant, data_total_amount: show_private() ? 'red' : 'darkgreen' }, type: 'bar', types: { data_total_amount: 'line' }, groups: [ ['data_removal_private', 'data_plant_private'], ['data_removal_public', 'data_plant_public'] ] }, legend: { position: 'inset', inset: { anchor: 'top-left', x: 0, y: 0, step: 2 } }, tooltip: { order: function(t1, t2) { return t1.index > t2.index; }, format: { title: function(i) { return 'Year ' + data_baumbilanz[i]['Jahr']; }, value: function(value, ratio, id) { return value ? value : 'n/a'; } } }, axis: { x: { type: 'category', label: { text: 'year', position: 'outer-center' }, tick: { rotate: -45, multiline: false } }, y: { label: { text: 'number of trees', position: 'outer-middle' } } } }); }32:[{"id":"e51a808733d2e5f7a137101fed26440fcbf15fd7905ef4b68d1ec916f9a0244afe0008dddb82ca92a948e35f7d45cae1c4496dc11a1a4b6c65bf1dcde73ce804","href":"https://static.observableusercontent.com/files/e51a808733d2e5f7a137101fed26440fcbf15fd7905ef4b68d1ec916f9a0244afe0008dddb82ca92a948e35f7d45cae1c4496dc11a1a4b6c65bf1dcde73ce804","name":"baumbilanz@6.csv","type":"text/csv","lastModified":1720129079556.288,"size":484},{"id":"6ae3cb0ca51b266f35d81d88e1c7775bfa3ba2a9cb40af6b332df163034a024e4ce8694387b112525a718414258c99e2bfd36714d94bcb182580c9e0b9e977e7","href":"https://static.observableusercontent.com/files/6ae3cb0ca51b266f35d81d88e1c7775bfa3ba2a9cb40af6b332df163034a024e4ce8694387b112525a718414258c99e2bfd36714d94bcb182580c9e0b9e977e7","name":"baumbilanz@3.csv","type":"text/csv","lastModified":1619806072746.169,"size":401},{"id":"067c619783ff9ad0b3e107873600a2b55be3c54e2ac587c4e3b89911b5cb801e12481b57fe3d1a7437cecc8f115839e419f9977b4d90563004306d273bcd40d9","href":"https://static.observableusercontent.com/files/067c619783ff9ad0b3e107873600a2b55be3c54e2ac587c4e3b89911b5cb801e12481b57fe3d1a7437cecc8f115839e419f9977b4d90563004306d273bcd40d9","name":"baumbilanz@4.csv","type":"text/csv","lastModified":1620838276571.941,"size":409},{"id":"5d54ccf519b9592034ab79823228dd50c7a9cbf29782386f6bfdc22e51ae6842964555145291944b2b27355dd84d1defa366a73a8176c7079c7f959662d9d7f0","href":"https://static.observableusercontent.com/files/5d54ccf519b9592034ab79823228dd50c7a9cbf29782386f6bfdc22e51ae6842964555145291944b2b27355dd84d1defa366a73a8176c7079c7f959662d9d7f0","name":"baumbilanz@5.csv","type":"text/csv","lastModified":1689711736067.983,"size":459},{"id":"99f0dc5e15e9c76d617747692114ddc2e32b29d66185a04708ed003b6b6289f08d0cd6b03e752406d15787e0b17ccec8777be473e74d0978f34ac235543a3130","href":"https://static.observableusercontent.com/files/99f0dc5e15e9c76d617747692114ddc2e32b29d66185a04708ed003b6b6289f08d0cd6b03e752406d15787e0b17ccec8777be473e74d0978f34ac235543a3130","name":"baumstatistik.csv","type":"text/csv","lastModified":1619634617865.916,"size":659}] 2f:{"title":"Munich Urban Tree Statistics","cells":[{"id":0,"value":"md`# Munich Urban Tree Statistics`","pinned":false,"hidden":false,"mode":"ojs"},{"id":730,"value":"md`**Is Munich city really getting greener?** \n\nprobably Yes, if you only look at public land and don't care about loss of old trees.\n\nand definitely No, the city is constantly loosing a large number of trees particularly on private land!`","pinned":false,"hidden":false,"mode":"ojs"},{"id":763,"value":"{\n let yr = baumbilanz.map(x => x['Jahr']);\n let young = Math.abs(\n baumbilanz\n .map(\n x =>\n Number(x['festgesetzte_Ersatzpflanzungen_Privatflächen']) +\n Number(x['Ersatz_öffentliches_Grün'])\n )\n .reduce((a, b) => a + b, 0)\n );\n let gone = Math.abs(\n baumbilanz\n .map(\n x =>\n -1 * Number(x['genehmigte_Fällungen_Privatflächen']) +\n -1 * Number(x['Fällung_öffentliches_Grün']) \n \n )\n .reduce((a, b) => a + b, 0)\n );\n let net = Math.abs(young - gone);\n \n return md`From ${yr[0]} to ${\n yr[yr.length - 1]\n } Munich has documented **net total ${net} trees lost** on both public and private land altogether. To make things worse the city has **lost at least total ${gone} mature or old trees**!`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":596,"value":"viewof show_on = Radio(\n new Map([\n [\"only public land\", \"public\"],\n [\"only private land\", \"private\"],\n [\"both public and private land\", \"both\"]\n ]),\n { label: \"Show statistics on:\", value: \"both\" }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":230,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"md`## Data Source`","pinned":false,"hidden":false,"mode":"ojs"},{"id":132,"value":"md`Statistics from 2010 to 2020^[1]^[2]. \n\nFurther data from \n\n - https://stadt.muenchen.de/infos/baumschutz-muenchen.html (Baumbilanz)\n - https://ru.muenchen.de/ (Baumbilanz)\n - 2023 öffentliche und gesamte Flächer`","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"Table(baumbilanz, {\n format: {\n genehmigte_Fällungen_Privatflächen: (x, i, a) =>\n a[i].Jahr <= 2015 ? html`

${x}

` : x,\n festgesetzte_Ersatzpflanzungen_Privatflächen: (x, i, a) =>\n a[i].Jahr <= 2015\n ? html`

${x}

`\n : x,\n Fällung_öffentliches_Grün: (x, i, a) =>\n a[i].Jahr <= 2015 ? html`

${x}

` : x,\n Ersatz_öffentliches_Grün: (x, i, a) =>\n a[i].Jahr <= 2015 ? html`

${x}

` : x\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":139,"value":"md`More detail from 2010 to 2015^[3]`","pinned":false,"hidden":false,"mode":"ojs"},{"id":108,"value":"Table(baumstatistik, {\n format: {\n genehmigte_Einzelfällanträge: x =>\n html`

${x}

`,\n genehmigte_Fällungen_aufgrund_von_Baumaßnahmen: x =>\n html`

${x}

`,\n geforderte_Ersatzpflanzungen: x =>\n html`

${x}

`,\n geforderte_Ersatzpflanzungen_im_Rahmen_der_Baumaßnahmen: x =>\n html`

${x}

`,\n Fällungen_Gartenbau: x => html`

${x}

`,\n Ersatzpflanzungen_Gartenbau: x =>\n html`

${x}

`\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":114,"value":"ref1 = md`*[1] Angela Burkhardt-Keller, Kreisgruppe München, BUND Naturschutz in Bayern e.V. (Special thanks to her generosity for sharing her compiled data from Rathaus Umschau and UNB)*\n - *Rathaus Umschau (Ausgabe: 2016/7, 2016/57, 2017/5, 2017/238, 2019/19, 2020/19, 2021/16)*\n - *Die Untere Naturschutzbehörde, Referat für Stadtplanung und Bauordnung München*\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":828,"value":"ref2 = md`*[2] [Antwortschreiben](https://fragdenstaat.de/anfrage/baumstatistik-von-munchen-zwischen-2016-und-2021/596128/anhang/AnfrageBaumstatistikMnchen_geschwaerzt.pdf) von der UNB - Anfrage „Baumstatistik von München“*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":121,"value":"ref3 = md`*[3] [Antwortschreiben](https://www.ris-muenchen.de/RII/RII/DOK/ANTRAG/4002710.pdf) von Referat für Stadtplanungund Bauordnung: Baumstatistik – ist München für den Klimawandel gerüstet? Schriftliche Anfrage gemäß § 68 GeschO\nAnfrage Nr. 14-20 / F 00367 von Frau StRin Sabine Krieger vom 06.08.2015*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":844,"value":"md`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":81,"value":"md`## Appendix\n\nDetailed implementation of data visualization`","pinned":false,"hidden":false,"mode":"ojs"},{"id":54,"value":"baumbilanz = FileAttachment(\"baumbilanz@6.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":28,"value":"baumstatistik = FileAttachment(\"baumstatistik.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":463,"value":"color_tree_private_removal = '#ffaa00'","pinned":false,"hidden":false,"mode":"ojs"},{"id":465,"value":"color_tree_private_plant = '#80b918'","pinned":false,"hidden":false,"mode":"ojs"},{"id":471,"value":"color_tree_public_removal = '#ffdd00'","pinned":false,"hidden":false,"mode":"ojs"},{"id":473,"value":"color_tree_public_plant = '#dddf00'","pinned":false,"hidden":false,"mode":"ojs"},{"id":179,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"import { c3 } from \"@mbostock/c3\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":103,"value":"import { Radio, Table } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}