2d:null 2e:["$","title",null,{"children":"State of London SQLite page | Joe Heywood | Observable"}] 33:T417,style = html``34:[{"id":"c3248bf4b47478c569c8f5475d809fb21bdef2d3b1fc99fa9f2f9bde3506f1f8a9dd823b3376c59ae19d348d80e81319e5868d830d37b8ee326c1a782cab3d60","href":"https://static.observableusercontent.com/files/c3248bf4b47478c569c8f5475d809fb21bdef2d3b1fc99fa9f2f9bde3506f1f8a9dd823b3376c59ae19d348d80e81319e5868d830d37b8ee326c1a782cab3d60","name":"sol_v4.db","type":"application/x-sqlite3","lastModified":1726574162216.902,"size":1142784},{"id":"12ba512b479b7bbc2e21741fc1b32091a85c5e91594e41a0af4911677d3d206ed919432e9a16f71667ef729ce27cd5e5fc1187e92075148c0e47a128c3b3a5dd","href":"https://static.observableusercontent.com/files/12ba512b479b7bbc2e21741fc1b32091a85c5e91594e41a0af4911677d3d206ed919432e9a16f71667ef729ce27cd5e5fc1187e92075148c0e47a128c3b3a5dd","name":"sol_v4_charts@18.db","type":"application/x-sqlite3","lastModified":1726574233652.476,"size":577536},{"id":"6b63e5f89acc037b8dba13a63a17a6573e415ef85a339542e7459c8c682a410df1e63342f6ac4e11f220791409bc56851a1bf5839e82fd3c00b570e8a9d22741","href":"https://static.observableusercontent.com/files/6b63e5f89acc037b8dba13a63a17a6573e415ef85a339542e7459c8c682a410df1e63342f6ac4e11f220791409bc56851a1bf5839e82fd3c00b570e8a9d22741","name":"sol_v4_charts@19.db","type":"application/x-sqlite3","lastModified":1726574323638.407,"size":581632},{"id":"44e8fcbf0d27dffe6068fa33c8995978a02d3bbfca3a302667ee7da87e10aa78219ea39eae8a0207fffbbe06646ce32cc04024aa8578f80eb793aed46b456f40","href":"https://static.observableusercontent.com/files/44e8fcbf0d27dffe6068fa33c8995978a02d3bbfca3a302667ee7da87e10aa78219ea39eae8a0207fffbbe06646ce32cc04024aa8578f80eb793aed46b456f40","name":"sol_v4_charts@20.db","type":"application/x-sqlite3","lastModified":1726575035484.15,"size":585728},{"id":"77cfaca4ce2a3359340d75f5ef35500b239fef7f2e6edbce520e3ca252acaf82f5c4e808548d02425e731f94293a6860011d738209d7dba9a48c8282d5ad4c37","href":"https://static.observableusercontent.com/files/77cfaca4ce2a3359340d75f5ef35500b239fef7f2e6edbce520e3ca252acaf82f5c4e808548d02425e731f94293a6860011d738209d7dba9a48c8282d5ad4c37","name":"sol_v4_charts@21.db","type":"application/x-sqlite3","lastModified":1726575766997.468,"size":581632},{"id":"2a3846cb844ac2ef11211652158113fbbdba87b75dbe22a2ef57a5a4b2f930dd5b2e341ff6e7e1925c10c5d75bf9907345aa22c5a1ef8bc6b874393f5020905a","href":"https://static.observableusercontent.com/files/2a3846cb844ac2ef11211652158113fbbdba87b75dbe22a2ef57a5a4b2f930dd5b2e341ff6e7e1925c10c5d75bf9907345aa22c5a1ef8bc6b874393f5020905a","name":"sol_v5_charts.db","type":"application/x-sqlite3","lastModified":1726576541533.047,"size":520192},{"id":"12ba512b479b7bbc2e21741fc1b32091a85c5e91594e41a0af4911677d3d206ed919432e9a16f71667ef729ce27cd5e5fc1187e92075148c0e47a128c3b3a5dd","href":"https://static.observableusercontent.com/files/12ba512b479b7bbc2e21741fc1b32091a85c5e91594e41a0af4911677d3d206ed919432e9a16f71667ef729ce27cd5e5fc1187e92075148c0e47a128c3b3a5dd","name":"sol_v4_charts@17.db","type":"application/x-sqlite3","lastModified":1724852499268.76,"size":577536},{"id":"df871b2331d91bf6dd8c188c230b2f24ac3c82299403607df19a0ea41defdbfd34d330e02ae00c6a3f2b92f5fdd110fc7bdfa6948a39b8ad2a91c71edad71726","href":"https://static.observableusercontent.com/files/df871b2331d91bf6dd8c188c230b2f24ac3c82299403607df19a0ea41defdbfd34d330e02ae00c6a3f2b92f5fdd110fc7bdfa6948a39b8ad2a91c71edad71726","name":"sol_v4_charts@16.db","type":"application/x-sqlite3","lastModified":1722418410777.274,"size":577536},{"id":"2a3846cb844ac2ef11211652158113fbbdba87b75dbe22a2ef57a5a4b2f930dd5b2e341ff6e7e1925c10c5d75bf9907345aa22c5a1ef8bc6b874393f5020905a","href":"https://static.observableusercontent.com/files/2a3846cb844ac2ef11211652158113fbbdba87b75dbe22a2ef57a5a4b2f930dd5b2e341ff6e7e1925c10c5d75bf9907345aa22c5a1ef8bc6b874393f5020905a","name":"sol_v5_chartsaq.db","type":"application/x-sqlite3","lastModified":1738853223618.085,"size":520192},{"id":"fd4bb861528a3ab23a97b046e953efef47217d8466dbc913cb696ce00f13705ce3622cc3c9ecedf26a093e8a5bf7d29b94e09289d4b47db130863d424e755ffe","href":"https://static.observableusercontent.com/files/fd4bb861528a3ab23a97b046e953efef47217d8466dbc913cb696ce00f13705ce3622cc3c9ecedf26a093e8a5bf7d29b94e09289d4b47db130863d424e755ffe","name":"sol_v5_chartsaq@1.db","type":"application/x-sqlite3","lastModified":1738853519879.272,"size":536576},{"id":"ef739ddc68d9b5a7564a3c8657c878e9a44266f36f6bc65563d2bc9251c0d4bdeae009b0f108726d3acea79ad13ff479aea5f02dab1ce768f7cd2c8a121e2a5e","href":"https://static.observableusercontent.com/files/ef739ddc68d9b5a7564a3c8657c878e9a44266f36f6bc65563d2bc9251c0d4bdeae009b0f108726d3acea79ad13ff479aea5f02dab1ce768f7cd2c8a121e2a5e","name":"sol_v5_chartsaq@2.db","type":"application/x-sqlite3","lastModified":1738853792686.733,"size":630784},{"id":"e5ed01af1990f65eada48c4fdc4847b15ad629ddee4af5ab718bd4af0dfb243376fdd7030b8b0ef71e8de23c9ff941ff6f7e313aeb2391d8ce7df49833ceda9d","href":"https://static.observableusercontent.com/files/e5ed01af1990f65eada48c4fdc4847b15ad629ddee4af5ab718bd4af0dfb243376fdd7030b8b0ef71e8de23c9ff941ff6f7e313aeb2391d8ce7df49833ceda9d","name":"sol_v5_chartsaq@3.db","type":"application/x-sqlite3","lastModified":1740652977547.51,"size":630784},{"id":"a8c9e0c7c45c6208409aec6997b45b648a32dd5c001baea10d59d857aa597330a29541d7c8c34c605524922e8241f0fcafcd63ec1b47e2eca7d5ae49a84b76a6","href":"https://static.observableusercontent.com/files/a8c9e0c7c45c6208409aec6997b45b648a32dd5c001baea10d59d857aa597330a29541d7c8c34c605524922e8241f0fcafcd63ec1b47e2eca7d5ae49a84b76a6","name":"sol_v4_charts@13.db","type":"application/x-sqlite3","lastModified":1707389592163.008,"size":479232},{"id":"17f2fbb1e4f92240ba682f334da00afcbb904d9b36141b41edcdea61e30fb7dd5a28a695afff6ca0047697504f822a903460a711b324d77699179d2cc6cdeec9","href":"https://static.observableusercontent.com/files/17f2fbb1e4f92240ba682f334da00afcbb904d9b36141b41edcdea61e30fb7dd5a28a695afff6ca0047697504f822a903460a711b324d77699179d2cc6cdeec9","name":"sol_v4_charts@14.db","type":"application/x-sqlite3","lastModified":1707391092953.173,"size":471040},{"id":"df871b2331d91bf6dd8c188c230b2f24ac3c82299403607df19a0ea41defdbfd34d330e02ae00c6a3f2b92f5fdd110fc7bdfa6948a39b8ad2a91c71edad71726","href":"https://static.observableusercontent.com/files/df871b2331d91bf6dd8c188c230b2f24ac3c82299403607df19a0ea41defdbfd34d330e02ae00c6a3f2b92f5fdd110fc7bdfa6948a39b8ad2a91c71edad71726","name":"sol_v4_charts@15.db","type":"application/x-sqlite3","lastModified":1707391252116.867,"size":577536},{"id":"7d6295e6c1fd9b11f543cd298be983412ca474962c05581b997234c1595dc9a499eaeaba4adbff45a32f94f887597a7726d9a46ce7108ade23d7fdf235083f54","href":"https://static.observableusercontent.com/files/7d6295e6c1fd9b11f543cd298be983412ca474962c05581b997234c1595dc9a499eaeaba4adbff45a32f94f887597a7726d9a46ce7108ade23d7fdf235083f54","name":"sol@1.sqlite2","type":"application/x-sqlite3","lastModified":1700735775158.549,"size":741376},{"id":"6745e163cb60966518bec322c77c8d1825206dda317f839b6e3038cf62228db66b15b7cd6274dfb4c7ef8e945bae4af3df3fdaeedc3e921f6e22886d98eb8baf","href":"https://static.observableusercontent.com/files/6745e163cb60966518bec322c77c8d1825206dda317f839b6e3038cf62228db66b15b7cd6274dfb4c7ef8e945bae4af3df3fdaeedc3e921f6e22886d98eb8baf","name":"res@7.sqlite","type":"application/x-sqlite3","lastModified":1700735775158.549,"size":450560},{"id":"0c9eb891878f027a13fa7cbcd62013a98f78b8c293c9e49477b2a117895d787db60646ea2d64315847c8b8743a507ac239399eca432c94efbaa25ab6b26b0e0c","href":"https://static.observableusercontent.com/files/0c9eb891878f027a13fa7cbcd62013a98f78b8c293c9e49477b2a117895d787db60646ea2d64315847c8b8743a507ac239399eca432c94efbaa25ab6b26b0e0c","name":"sol_v4_charts@6.db","type":"application/x-sqlite3","lastModified":1706006281337.655,"size":458752},{"id":"7a9f0848f285cc1481ce4a5303e49dc12055d6c4458fca8066598340a916659de263da3185b1c62e9f7f4ca7e3d5730ba273d7f97067ee8355aaf7cb674902a3","href":"https://static.observableusercontent.com/files/7a9f0848f285cc1481ce4a5303e49dc12055d6c4458fca8066598340a916659de263da3185b1c62e9f7f4ca7e3d5730ba273d7f97067ee8355aaf7cb674902a3","name":"sol_v4_charts@2.db","type":"application/x-sqlite3","lastModified":1705574219575.966,"size":442368},{"id":"c472a293470bd0673f013f2134b9666ecdaed6caed8e5a9a30057f59649ea04777324fdd48bdb2dbaa2d4176ad61c2ee76aee6a2e56ba1731958b036148b1a24","href":"https://static.observableusercontent.com/files/c472a293470bd0673f013f2134b9666ecdaed6caed8e5a9a30057f59649ea04777324fdd48bdb2dbaa2d4176ad61c2ee76aee6a2e56ba1731958b036148b1a24","name":"sol_v4_charts@3.db","type":"application/x-sqlite3","lastModified":1705576495190.575,"size":471040},{"id":"1a4b455c1b075eb6b4556d962a44d277a2095b6473e0a87c78c1f7a7237dee7bacdc76f3bb1f4f5b53c6b69a0a37d8acc029989563a30f5b87cde3b4ca52991c","href":"https://static.observableusercontent.com/files/1a4b455c1b075eb6b4556d962a44d277a2095b6473e0a87c78c1f7a7237dee7bacdc76f3bb1f4f5b53c6b69a0a37d8acc029989563a30f5b87cde3b4ca52991c","name":"sol_v4_charts@7.db","type":"application/x-sqlite3","lastModified":1706019622394.333,"size":458752},{"id":"1ff928db5873e13f09f2c0dd07a47b1c69ec0f8352072f187925038dd7e35a7a9a47b21554bb5145aaecefc64edb007105337ce60f27a0d69562a6e0bfeb2cb7","href":"https://static.observableusercontent.com/files/1ff928db5873e13f09f2c0dd07a47b1c69ec0f8352072f187925038dd7e35a7a9a47b21554bb5145aaecefc64edb007105337ce60f27a0d69562a6e0bfeb2cb7","name":"sol_v4_charts@11.db","type":"application/x-sqlite3","lastModified":1706195019278.702,"size":495616},{"id":"56cd17ce2c42770cf45a6e4fee430ec2b8fec475508ccb74ff1efa20169ad8c8fea542b074e040a296f566e3995a6c23f5b97bc13f2d07a5469046d66622ba91","href":"https://static.observableusercontent.com/files/56cd17ce2c42770cf45a6e4fee430ec2b8fec475508ccb74ff1efa20169ad8c8fea542b074e040a296f566e3995a6c23f5b97bc13f2d07a5469046d66622ba91","name":"sol_v4_charts@10.db","type":"application/x-sqlite3","lastModified":1706025023230.275,"size":483328},{"id":"dc7c52566d54def0b23ebbaa29316b34eb2f376858915b93d4f3993a1296c8aec05d41569daeb2dd80936555ce9ece0e3f9359ae94fe7f214dd7e10079d96ec3","href":"https://static.observableusercontent.com/files/dc7c52566d54def0b23ebbaa29316b34eb2f376858915b93d4f3993a1296c8aec05d41569daeb2dd80936555ce9ece0e3f9359ae94fe7f214dd7e10079d96ec3","name":"sol_v4_charts@4.db","type":"application/x-sqlite3","lastModified":1705585511660.874,"size":454656},{"id":"31bcaac2426abcb4a6543c69adea2dfaa71e422516f39dfd070f7048fa79ec1344c5709ba42386eeb8bb5b7158f713d17e1157818ef3f9a6ea8ced1030ff6889","href":"https://static.observableusercontent.com/files/31bcaac2426abcb4a6543c69adea2dfaa71e422516f39dfd070f7048fa79ec1344c5709ba42386eeb8bb5b7158f713d17e1157818ef3f9a6ea8ced1030ff6889","name":"sol_v4_charts@5.db","type":"application/x-sqlite3","lastModified":1705586941004.832,"size":454656},{"id":"1afc88c300ac6d873b0397c221274fd9bbf541df08603042baa89d66db1bb632f94d8852842b83aad2e241e6e38591ff22d1bfb9c60a1fe66f61a5dcfe750285","href":"https://static.observableusercontent.com/files/1afc88c300ac6d873b0397c221274fd9bbf541df08603042baa89d66db1bb632f94d8852842b83aad2e241e6e38591ff22d1bfb9c60a1fe66f61a5dcfe750285","name":"sol_v4_charts@12.db","type":"application/x-sqlite3","lastModified":1706267739650.242,"size":212992},{"id":"41d12f9f2c740a9e03f3ea31c59c855d58b6a8e115857a09db2fb70da401bcbe6e9d47fe148ed3d369d3ad4b05d0a4a132195ad5d14e3fc42b6b20d6d5ae47bd","href":"https://static.observableusercontent.com/files/41d12f9f2c740a9e03f3ea31c59c855d58b6a8e115857a09db2fb70da401bcbe6e9d47fe148ed3d369d3ad4b05d0a4a132195ad5d14e3fc42b6b20d6d5ae47bd","name":"sol_v4_charts.db","type":"application/x-sqlite3","lastModified":1705505965587.08,"size":442368},{"id":"9dd3d09ae2d8b1f2b53c3265441015a50307a8d1e89004aac637e759cfa45cc1a5ef3ad034f7f5d9b3ba2dfb1c1af44be41bdf341a77846cab97edf7176828ee","href":"https://static.observableusercontent.com/files/9dd3d09ae2d8b1f2b53c3265441015a50307a8d1e89004aac637e759cfa45cc1a5ef3ad034f7f5d9b3ba2dfb1c1af44be41bdf341a77846cab97edf7176828ee","name":"sol_v4_charts@1.db","type":"application/x-sqlite3","lastModified":1705572273142.588,"size":442368},{"id":"e7594cb75ae1de1e4cb24551867722f172d07a25c55f52c06fa8e643d4be9fe155a2439c15cee76bc4638c752c636c0eaa4067c9890a06c139c64e3523cdfc97","href":"https://static.observableusercontent.com/files/e7594cb75ae1de1e4cb24551867722f172d07a25c55f52c06fa8e643d4be9fe155a2439c15cee76bc4638c752c636c0eaa4067c9890a06c139c64e3523cdfc97","name":"sol_v4_charts@8.db","type":"application/x-sqlite3","lastModified":1706023263911.35,"size":466944},{"id":"14190b6bf155160aba46e51383e8590a763ba07f55bccc1781595ad8e87dcec9a8c716835651eec56ab5d399d3b3fcdc31ed9b26b0b39c1483953491bcd3fd10","href":"https://static.observableusercontent.com/files/14190b6bf155160aba46e51383e8590a763ba07f55bccc1781595ad8e87dcec9a8c716835651eec56ab5d399d3b3fcdc31ed9b26b0b39c1483953491bcd3fd10","name":"sol_v4_charts@9.db","type":"application/x-sqlite3","lastModified":1706024099873.163,"size":475136}] 31:{"id":"37df4861e862c570","slug":"sol-sqlite","title":"State of London SQLite page","thumbnail":"a7395bb184c59a2939b5575b45e9b8e4272487312c72113a06eafb3a08a8b421","access_level":"public","create_time":"$D2023-11-23T10:36:15.158Z","update_time":"$D2025-02-27T10:42:54.470Z","view_time":null,"first_public_time":"$D2023-11-23T10:36:15.158Z","has_unpublished_edits":null,"fork":{"id":"d25f7c0e8ba1f584","slug":"gla-dpa-sqlite","title":"GLA DPA chart using data from SQLite DB","owner":{"id":"f25282bfd4a326d0","login":"joe-heywood-gla","name":"Joe Heywood"}},"stars":0,"starred":false,"owner":{"type":"team","id":"f25282bfd4a326d0","login":"joe-heywood-gla","name":"Joe Heywood","avatar_url":"https://avatars-next.observableusercontent.com/d8e8bba152da45ecac5e1785107e071eb5be2ae62270694947b94bb20425e9ba","tier":"starter_2024"},"version":857,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"35e2d1d04de9ff36","login":"joe-heywood-gla","name":"Joe Heywood","avatar_url":"https://avatars-next.observableusercontent.com/d8e8bba152da45ecac5e1785107e071eb5be2ae62270694947b94bb20425e9ba","tier":null}],"members":[{"type":"individual","id":"35e2d1d04de9ff36","login":"joe-heywood-gla","name":"Joe Heywood","avatar_url":"https://avatars-next.observableusercontent.com/d8e8bba152da45ecac5e1785107e071eb5be2ae62270694947b94bb20425e9ba","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"State of London SQLite page","cells":[{"id":592,"value":"# State of London SQLite page","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":572,"value":"viewof chpt = Inputs.select(chapters.map(d => d.chapter), {label: \"Chapter\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":584,"value":"viewof sct = Inputs.select(sections.map(d => d.sub), {label: \"Sections\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":589,"value":"viewof chrt = Inputs.select(charts, {format: d => d.title, label: \"Select chart\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":533,"value":"from_sqlite4 = chart_from_sqlite(chrt.dtst)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":620,"value":"update_info = {\n //let m = dbss4.query(`select * from meta where dtst = '${chrt.dtst}'`)\n let m = meta_obj[0]\n //return m\n return md`\n* Last update: ${meta_obj[0].last_update}\n* Last ran: ${m.last_check}\n* Last xaxis value: ${m.max_xval}\n\n`}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":644,"value":"tbl = Inputs.table(chapter_meta)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"tbl","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"meta_obj = dbss4.query(`select * from meta where dtst = '${chrt.dtst}'`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":642,"value":"chapter_meta = dbss4.query(`select title, last_update, last_check, max_xval from meta where chapter = '${chpt}'` )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":616,"value":"chrt.dtst","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":586,"value":"charts = dbss4.query(`select dtst, title from meta where chapter = \"${chpt}\" AND sub = \"${sct}\"`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"get_dbss.query(\"select dtst, title, chapter, sub FROM meta \")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":578,"value":"sections = dbss4.query(`select distinct sub from meta where chapter = \"${chpt}\"`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"chapters = dbss4.query(`select distinct chapter from meta`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"function chart_from_sqlite(chartID, {\n cw,\n ch\n} = {}){\n // let opts = {sqlite_fl: sqlite_fl}\n let data = get_sqlite_data(chartID);\n let chart = get_sqlite_chart_meta(chartID);\n let meta = get_sqlite_meta(chartID);\n meta.includetitles = true\n\n\n\n let g = Promise.all([data, chart, meta]).then(function(values){\n if(values[1].stackgroup == \"stack\") {\n values[0] = long_to_wide(values[0])\n }\n if(cw !== null) {\n values[1].cwidth = cw\n values[2].cwidth = cw\n }\n\n values[2].includetitles = true\n\n \n return new gla_chart_all(values[0], values[1], values[2])\n })\n //return g\n \n return g.then(value => value.draw())\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":702,"value":"function chart_from_sqlite_local(chartID, {\n cw,\n ch\n} = {}){\n // let opts = {sqlite_fl: sqlite_fl}\n let data = get_sqlite_data_local(chartID);\n let chart = get_sqlite_chart_meta_local(chartID);\n let meta = get_sqlite_meta_local(chartID);\n /*meta.includetitles = true\n meta.title = meta.ttl\n meta.sub = \"SUBTITLE\"*/\n //return true\n\n\n\n let g = Promise.all([data, chart, meta]).then(function(values){\n if(values[1].stackgroup == \"stack\") {\n values[0] = long_to_wide(values[0])\n }\n if(cw !== null) {\n values[1].cwidth = cw\n values[2].cwidth = cw\n }\n\n values[2].includetitles = true;\n /*values[2].title = values[2].ttl;\n values[2].sub = \"Subtitle\";*/\n \n console.log(values[2])\n\n \n return new gla_chart_all(values[0], values[1], values[2])\n })\n //return g\n \n return g.then(value => value.draw())\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"function get_sqlite_data(d_id){\n return get_dbss.query(`SELECT distinct * FROM chartdat WHERE dtst = '${d_id}'`)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":690,"value":"function get_sqlite_data_local(d_id) {\n return dbsol4.query(`SELECT distinct * FROM chartdat WHERE dtst = '${d_id}'`)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"function get_sqlite_chart_meta(d_id){ \n return get_dbss.query(`SELECT chartmeta FROM chartmeta WHERE dtst = '${d_id}'`).then(\n (value) => {\n return JSON.parse(value[0].chartmeta)\n })\n} ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":698,"value":"function get_sqlite_chart_meta_local(d_id){ \n return dbsol4.query(`SELECT chartmeta FROM chartmeta WHERE dtst = '${d_id}'`).then(\n (value) => {\n return JSON.parse(value[0].chartmeta)\n })\n} ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":752,"value":"function get_sqlite_chart_meta_local1(d_id){ \n return dbsol4x.query(`SELECT chartmeta FROM chartmeta WHERE dtst = '${d_id}'`).then(\n (value) => {\n return JSON.parse(value[0].chartmeta)\n })\n} ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":757,"value":"dbsol4x.query(`SELECT * FROM chartmeta`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":754,"value":"get_sqlite_chart_meta_local(\"sol_gva\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"function get_sqlite_meta(d_id) {\n return get_dbss.query(`SELECT meta FROM meta WHERE dtst = '${d_id}'`).then(\n (value) => {\n console.log(value);\n return JSON.parse(value[0].meta)\n })\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":700,"value":"function get_sqlite_meta_local(d_id) {\n return dbsol4.query(`SELECT meta FROM meta WHERE dtst = '${d_id}'`).then(\n (value) => {\n console.log(value);\n return JSON.parse(value[0].meta)\n })\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":722,"value":"dashboard_chart = \"sol_gva\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":656,"value":"for_dashboard = chart_from_sqlite_local(dashboard_chart)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":821,"value":"chart_from_sqlite(\"sol_gva\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":554,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":725,"value":"testing = get_sqlite_data_local(\"sol_gva\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"// chapters = get_chapters()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"//sections = get_chapter_sections(select)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"// charts = get_section_charts(sects)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"// viewof select = Inputs.select(chapters.map(d => d.chapter), {label: \"Select one\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"// viewof sects = Inputs.select(sections.map(d => d.section), {label: \"Select one\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"// viewof charts_opts = Inputs.select(charts, {format: d => d.title, label: \"Select one\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"// from_sqlite = chart_from_sqlite(charts_opts.dtst)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"/*db_opts = {\n return {\n sqlite_fl : \"solgit\",\n cw: dimopts[0],\n ch: dimopts[1]\n \n }\n}*/","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"buttons_opts = [\n {\n button_text: \"Unemployment rate\",\n id: \"sol_unempl\"\n },\n {\n button_text: \"Workforce\",\n id: \"sol_workforce\"\n },\n {\n button_text: \"Greenhouse\",\n id: \"sol_greenhouse\"\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"viewof buttons_select = {\n // code from: https://observablehq.com/@martien/buttons\n\n const view = html``;\n view.value = buttons_opts[0].id;\n return view;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"bchart = chart_from_sqlite_local(buttons_select)\n\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"// DOM.download(() => rasterize(bchart, undefined, \"Save to PNG\"))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"/*viewof dimopts = Inputs.button([\n [\"Small\", value => [600, 450]],\n [\"Medium\", value => [900, 500]],\n [\"Large\", value => [1200, 600] ]\n], {value: [1200, 600]})*/","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"// butts_obj = chart_object_from_sqlite(buttons_select, db_opts)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"// butts_obj.draw()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":335,"value":"// dimopts","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":228,"value":"### Functions\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":43,"value":"function get_chapter_sections(chpt) {\n return dbss.query(`select distinct section from meta where chapter = \"${chpt}\"`)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"function get_section_charts(sctn) {\n return dbss.query(`select dtst, title from meta where section = \"${sctn}\"`)\n} ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":403,"value":"/*get_sqlite_meta(\"sol_lpop\", \n {\n sqlite_fl: \"solgit3\"\n })*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"function chart_object_from_sqlite(chartID, {\n sqlite_fl = \"solgit\"\n} = {}){\n let opts = {sqlite_fl: sqlite_fl}\n let data = get_sqlite_data(chartID, opts);\n let chart = get_sqlite_chart_meta(chartID, opts);\n let meta = get_sqlite_meta(chartID, opts);\n\n\n return Promise.all([data, chart, meta]).then(function(values){\n if(values[1].stackgroup == \"stack\") {\n values[0] = long_to_wide(values[0])\n }\n\n values[2].includetitles = true;\n\n \n return new gla_chart_all(values[0], values[1], values[2])\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"### SQLite Database files","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":25,"value":"db = FileAttachment(\"sol@1.sqlite2\").sqlite()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"dbss = SQLiteDatabaseClient.open(await gh(sqlite_url))\n// https://observablehq.com/@observablehq/working-with-apis-remote-files#cell-25","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"dbss3.query(\"select * from chartmeta\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"sqlite_url = \"https://github.com/joeheywood/dashboard_files/blob/main/sqlite/sol.sqlite?raw=true\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":440,"value":"sol_sqlite_4 = \"https://github.com/joeheywood/dashboard_files/blob/main/sqlite/sol_v4_charts.db?raw=true\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"dbres = FileAttachment(\"res@7.sqlite\").sqlite()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":674,"value":"dbsol4 = FileAttachment(\"sol_v5_chartsaq@3.db\").sqlite()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":750,"value":"dbsol4x = FileAttachment(\"sol_v5_chartsaq@3.db\").sqlite()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"dbss3 = SQLiteDatabaseClient.open(await gh(db_sol3_url))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"dbss4 = SQLiteDatabaseClient.open(await gh(sol_sqlite_4))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":666,"value":"selected_db = \"obs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":658,"value":"get_dbss = {\n //let sol4;\n \n if(selected_db == \"github\") {\n //sol4 = sol_sqlite_4\n console.log(\"GETTING DATA FROM GTIHUB\")\n return dbss4\n } else {\n console.log(\"GETTING DATA FROM OBSERVABLE\")\n return dbsol4\n }\n return null\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":384,"value":"{\n let db = dbss3\n return db.query(\"SELECT distinct * from chartdat where dtst = 'sol_lpop' order by xd\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"updates = {\n let db = dbss4\n return db.query(\"SELECT * FROM updates\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":451,"value":"Inputs.table(updates)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":488,"value":"function section_table(sctn) {\n let arr = dbss4.query(`select title, lastmax, timestamp, latest_newvals from meta m inner join updates u on m.dtst = u.dtst WHERE section = '${sctn}'`)\n return Promise.all([arr]).then(function(values){\n return Inputs.table(values[0], {header: {title: \"Chart\", lastmax: \"Latest X-axis\", timestamp: \"Last Run\", latest_newvals: \"Last Modified\"}})\n })\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"db_sol3_url = \"https://github.com/joeheywood/dashboard_files/blob/main/sqlite/sol_v3.db?raw=true\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":125,"value":"// chart_from_sqlite(\"htrw\", {sqlite_fl: \"res\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":764,"value":"### Imports\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"import { long_to_wide} from \"@joe-heywood-gla/data-controller\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"import {gla_chart_all} from \"@joe-heywood-gla/gla-dpa-chart\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"import {gh} from \"@periscopic/github-api-in-observable\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":250,"value":"import {rasterize} from \"@mbostock/saving-svg\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"dbres.query(\"select dtst, title from meta\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"value":"get_sqlite_data(\"tfl\", {sqlite_fl : \"res\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":428,"value":"function run_info(chartID, opts) {\n let data = get_sqlite_data(chartID, opts);\n let updates = dbss4.query(`SELECT * FROM updates WHERE dtst = '${chartID}'`)\n\n return Promise.all([data, updates]).then(function(values){\n let max = d3.max(values[0], function(d) { return d.xd;} );\n let upd = values[1]\n let aa = upd[0].timestamp\n let ab = upd[0].latest_newvals\n\n\n\n\n \n return md`\n Update Info\n -----------\n * Most recent x-axis value: ${max}\n * Last Ran: ${aa}\n * Latest Update with new values: ${ab}\n\n `\n })\n \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":458,"value":"function get_updates_table(chartId, opts) {\n let updates = dbss4.query(`SELECT * FROM updates WHERE dtst = '${chartId}'`)\n let meta = get_sqlite_chart_meta(chartId, opts)\n console.log(meta)\n return meta\n \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":748,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"sol_v4_charts@11.db"},{"id":768,"value":"inpopts = [\"Roadside\", \"Urban Background\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":784,"value":"viewof aq_buttons_select = {\n // code from: https://observablehq.com/@martien/buttons\n\n const view = html``;\n view.value = aq_buttons_opts[0].id;\n return view;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":766,"value":"viewof aq_radio = Inputs.radio(inpopts, {label: \"Area\", value: inpopts[0], class: \"radbut\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":772,"value":"aqchart = {\n console.log(\"**************** AQ CHART **********************************\")\n let chartID = `${aq_buttons_select}_${aq_radio}`\n console.log(chartID)\n\n let data = get_sqlite_data_local(chartID);\n let chart = get_sqlite_chart_meta_local(chartID);\n let meta = get_sqlite_meta_local(chartID);\n console.log(`${aq_buttons_select}_${aq_radio}`)\n console.log(data)\n return chart_from_sqlite_local(`${aq_buttons_select}_${aq_radio}`)\n //return `${aq_buttons_select}_${aq_radio}`\n \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":846,"value":"dbsol4.query(`SELECT distinct dtst FROM chartdat`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":778,"value":"dbsol4.query(\"select distinct dtst from chartdat\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":788,"value":"aq_buttons_opts = [\n {\n button_text: \"Nitrogen dioxide\",\n id: \"aq_no2\"\n },\n {\n button_text: \"PM₁₀ concentration\",\n id: \"aq_pm10\"\n },\n {\n button_text: \"PM_2.5 concentration\",\n id: \"aq_pm25\"\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 32:"$31:body"