[{"_1":2,"_265":-5,"_266":-5},"loaderData",{"_3":4,"_95":96,"_217":218,"_264":-5},"root",{"_5":6,"_34":35,"_62":63,"_93":94},"ctx",{"_7":8,"_19":20,"_21":-5,"_22":23,"_24":25,"_26":27,"_28":27,"_29":27,"_30":31,"_32":33},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","f8fa8c4a4e93c9e28f2a5e80f55cea87f3043a94","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","API_URL","https://api.val.town","WORKER_FINGERPRINT","fd7e47ba602df66e0f857b45e802b861","clerkState",{"_64":65},"__internal_clerk_state",{"_66":67,"_68":45,"_69":70,"_71":70,"_72":27,"_73":70,"_74":70,"_75":70,"_76":70,"_77":70,"_78":70,"_79":70,"_80":70,"_81":82,"_91":27,"_92":27},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_83":27,"_84":70,"_85":86,"_87":70,"_88":45,"_89":27,"_90":70},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.x.$handle.$name",{"_97":98,"_99":100,"_101":43,"_102":103,"_104":-7,"_105":106,"_145":146,"_195":196,"_197":198,"_203":204,"_205":206,"_209":-5,"_210":211,"_216":27},"handle","maxm","name","nextgen","branchName","path","trees.ts","version","project",{"_107":108,"_99":100,"_109":110,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":119,"_120":121,"_122":123,"_124":33,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":27,"_21":134,"_137":138},"id","c7d66670-0985-11f0-a7ac-569c3dd06744","createdAt",["D",1742913063648],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","418c1e39-eb48-4f2f-8c97-122ece94631c","pinnedFileId","cd66652c-0985-11f0-9948-569c3dd06744","pinPreview",true,"screenshotVersion",29,"likeCount","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","isOwned",{"_97":98,"_135":136},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJnTEtkSHlOMWxWZm1GRHdKYUVTNklYM3FpdiJ9","branch",{"_104":123,"_99":43,"_107":139,"_140":108,"_141":-5,"_142":-5,"_143":-5,"_144":-5},"c7d6b8f0-0985-11f0-a7ac-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectUserId","tree",[147,167,177,186],{"_107":148,"_99":149,"_150":151,"_152":-5,"_153":139,"_154":155,"_156":121,"_109":157,"_104":94,"_158":159,"_160":161,"_162":27,"_163":-5,"_164":165,"_102":166},"73c82520-0988-11f0-b582-569c3dd06744","cache.ts","fileId","6e6efb9e-0988-11f0-8c70-569c3dd06744","parentId","branchId","branchVersion",15,"latest",["D",1742914211109],"fileType","script","content","import { ddb } from \"./trees.ts\";\n\nconst cache = await caches.open(\"my-cache\");\n\nexport default async function(req: Request): Promise {\n const cached = await cache.match(req);\n if (cached) {\n return cached;\n }\n\n // return Response.json({ ok: true });\n const res = new Response(await ddb(), { headers: { \"content-type\": \"application/json\" } });\n\n await cache.put(req, res.clone());\n return res;\n}","deleted","subdomain","children",[],[149],{"_107":168,"_99":169,"_150":170,"_152":-5,"_153":139,"_154":171,"_156":121,"_109":172,"_104":173,"_158":159,"_160":174,"_162":27,"_163":-5,"_164":175,"_102":176},"c61c305a-0988-11f0-ad09-569c3dd06744","ddb.ts","c531fc56-0988-11f0-8b0a-569c3dd06744",24,["D",1742914349231],1,"async function ddb() {\n const duckdb = await import(\"npm:duckdb-async\");\n const db = await duckdb.default.Database.create(\":memory:\");\n const conn = await db.connect();\n\n return await conn.all(`\nSELECT\n 42 as fourtytwo`);\n}",[],[169],{"_107":178,"_99":179,"_150":119,"_152":-5,"_153":139,"_154":123,"_156":121,"_109":180,"_104":181,"_158":182,"_160":183,"_162":27,"_163":-5,"_164":184,"_102":185},"72fd911e-099e-11f0-acb8-569c3dd06744","index.tsx",["D",1742923658705],17,"http","export default async function(req: Request): Promise {\n return Response.json(await ddb());\n}\n\nasync function ddb() {\n const duckdb = await import(\"npm:duckdb-async\");\n const db = await duckdb.default.Database.create(\":memory:\");\n const conn = await db.connect();\n\n return await conn.all(`\nSELECT\n 42 as fourtytwo`);\n}",[],[179],{"_107":187,"_99":103,"_150":188,"_152":-5,"_153":139,"_154":189,"_156":121,"_109":190,"_104":191,"_158":159,"_160":192,"_162":27,"_163":-5,"_164":193,"_102":194},"cf632c36-0988-11f0-961b-569c3dd06744","e39feea2-0986-11f0-84fa-569c3dd06744",26,["D",1742914364797],5,"// import { ddb } from \"./trees.ts\";\n// return new Response(await ddb(), { headers: { \"content-type\": \"application/json\" } });\n\n// import duckdb from \"npm:duckdb\";\nexport async function ddb() {\n const resp = await fetch(\n \"https://raw.githubusercontent.com/maxmcd/t/refs/heads/main/trees-24.csv\",\n );\n const file = await Deno.open(\"./trees.csv\", { write: true, create: true });\n await resp.body?.pipeTo(file.writable);\n\n const duckdb = await import(\"npm:duckdb-async\");\n const db = await duckdb.default.Database.create(\":memory:\");\n const conn = await db.connect();\n\n const boroughStats = await conn.all(`\nSELECT\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_trees DESC;\n`);\n\n const top5Species = await conn.all(`\nSELECT\nspc_common AS species,\nCOUNT(*) AS total_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health_count,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY spc_common\nORDER BY total_count DESC\nLIMIT 5;\n\n`);\n\n const top5Neighborhoods = await conn.all(`\nSELECT\nnta_name AS neighborhood,\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species\nFROM read_csv_auto('./trees.csv')\nGROUP BY nta_name, borough\nORDER BY total_trees DESC\nLIMIT 5;\n`);\n\n const treeHealthDistribution = await conn.all(`\nSELECT\nborough,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health,\nCOUNT(CASE WHEN health IS NULL OR health = '' THEN 1 END) AS unknown_health\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY SUM(CASE WHEN health = 'Good' THEN 1 ELSE 0 END) DESC;\n`);\n\n const treeSizeDistribution = await conn.all(`\nSELECT\nCASE\n WHEN tree_dbh < 5 THEN 'Very Small (< 5\")'\n WHEN tree_dbh >= 5 AND tree_dbh < 10 THEN 'Small (5-10\")'\n WHEN tree_dbh >= 10 AND tree_dbh < 20 THEN 'Medium (10-20\")'\n WHEN tree_dbh >= 20 AND tree_dbh < 30 THEN 'Large (20-30\")'\n WHEN tree_dbh >= 30 AND tree_dbh < 40 THEN 'Very Large (30-40\")'\n WHEN tree_dbh >= 40 THEN 'Enormous (40\"+)'\nEND AS size_class,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nMIN(tree_dbh) AS min_diameter,\nMAX(tree_dbh) AS max_diameter,\nROUND(COUNT(*)::FLOAT / (SELECT COUNT(*) FROM read_csv_auto('./trees.csv')) * 100, 2) AS percentage\nFROM read_csv_auto('./trees.csv')\nWHERE tree_dbh IS NOT NULL\nGROUP BY size_class\nORDER BY MIN(tree_dbh);\n\n`);\n\n const ecologicalImpact = await conn.all(`\nSELECT\nborough,\nSUM(tree_dbh) AS total_dbh_inches,\nROUND(AVG(tree_dbh), 2) AS avg_dbh_inches,\nCOUNT(*) AS tree_count,\nROUND(SUM(tree_dbh)::FLOAT / COUNT(*), 2) AS dbh_per_tree\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_dbh_inches DESC;\n\n`);\n\n const stewardshipImpact = await conn.all(`\nSELECT\nsteward AS stewardship_level,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY steward\nORDER BY percent_healthy DESC;\n`);\n await conn.close();\n await db.close();\n return jsonStringify({\n boroughStats,\n top5Species,\n top5Neighborhoods,\n treeHealthDistribution,\n treeSizeDistribution,\n ecologicalImpact,\n stewardshipImpact,\n });\n}\n\nconst jsonStringify = (data) => {\n return JSON.stringify(data, (key, value) =>\n typeof value === \"bigint\"\n ? value.toString()\n : value);\n};",[],[103],"files",[147,167,177,186],"counts",{"_199":33,"_200":173,"_201":33,"_202":33},"pulls","branches","forks","envVars","contents",[],"file",{"_107":187,"_99":103,"_150":188,"_152":-5,"_153":139,"_154":189,"_156":121,"_109":207,"_104":191,"_158":159,"_160":192,"_162":27,"_163":-5,"_102":208},["D",1742914364797],[103],"upstream","screenshots",{"_212":213,"_214":215},"thumbnail","https://screenshots.valtown.net/screenshot.png?width=1024&height=768&version=29&url=https%3A%2F%2Fmaxm--cd66652c098511f09948569c3dd06744.web.val.run","preview","https://screenshots.valtown.net/screenshot.png?width=1920&height=1080&version=29&url=https%3A%2F%2Fmaxm--cd66652c098511f09948569c3dd06744.web.val.run","emptyEnvVars","routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_97":98,"_99":100,"_101":43,"_102":103,"_105":219,"_205":223,"_226":227,"_252":253,"_261":-7,"_262":33,"_263":27},{"_107":108,"_99":100,"_109":220,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":119,"_120":121,"_122":123,"_124":33,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":27,"_21":221,"_137":222},["D",1742913063648],{"_97":98,"_135":136},{"_104":123,"_99":43,"_107":139,"_140":108,"_141":-5,"_142":-5,"_143":-5,"_144":-5},{"_107":187,"_99":103,"_150":188,"_152":-5,"_153":139,"_154":189,"_156":121,"_109":224,"_104":191,"_158":159,"_160":192,"_162":27,"_163":-5,"_102":225},["D",1742914364797],[103],"history",[228,230,236,241,245,249],{"_107":187,"_153":139,"_150":188,"_99":103,"_160":192,"_158":159,"_104":191,"_152":-5,"_109":229,"_154":189,"_163":-5},["D",1742914364797],{"_107":231,"_153":139,"_150":188,"_99":103,"_160":232,"_158":159,"_104":233,"_152":-5,"_109":234,"_154":235,"_163":-5},"0e0e3cd8-0988-11f0-8df4-569c3dd06744","// import duckdb from \"npm:duckdb\";\nexport async function ddb() {\n const resp = await fetch(\n \"https://raw.githubusercontent.com/maxmcd/t/refs/heads/main/trees-24.csv\",\n );\n const file = await Deno.open(\"./trees.csv\", { write: true, create: true });\n await resp.body?.pipeTo(file.writable);\n\n const duckdb = await import(\"npm:duckdb-async\");\n const db = await duckdb.default.Database.create(\":memory:\");\n const conn = await db.connect();\n\n const boroughStats = await conn.all(`\nSELECT\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_trees DESC;\n`);\n\n const top5Species = await conn.all(`\nSELECT\nspc_common AS species,\nCOUNT(*) AS total_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health_count,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY spc_common\nORDER BY total_count DESC\nLIMIT 5;\n\n`);\n\n const top5Neighborhoods = await conn.all(`\nSELECT\nnta_name AS neighborhood,\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species\nFROM read_csv_auto('./trees.csv')\nGROUP BY nta_name, borough\nORDER BY total_trees DESC\nLIMIT 5;\n`);\n\n const treeHealthDistribution = await conn.all(`\nSELECT\nborough,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health,\nCOUNT(CASE WHEN health IS NULL OR health = '' THEN 1 END) AS unknown_health\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY SUM(CASE WHEN health = 'Good' THEN 1 ELSE 0 END) DESC;\n`);\n\n const treeSizeDistribution = await conn.all(`\nSELECT\nCASE\n WHEN tree_dbh < 5 THEN 'Very Small (< 5\")'\n WHEN tree_dbh >= 5 AND tree_dbh < 10 THEN 'Small (5-10\")'\n WHEN tree_dbh >= 10 AND tree_dbh < 20 THEN 'Medium (10-20\")'\n WHEN tree_dbh >= 20 AND tree_dbh < 30 THEN 'Large (20-30\")'\n WHEN tree_dbh >= 30 AND tree_dbh < 40 THEN 'Very Large (30-40\")'\n WHEN tree_dbh >= 40 THEN 'Enormous (40\"+)'\nEND AS size_class,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nMIN(tree_dbh) AS min_diameter,\nMAX(tree_dbh) AS max_diameter,\nROUND(COUNT(*)::FLOAT / (SELECT COUNT(*) FROM read_csv_auto('./trees.csv')) * 100, 2) AS percentage\nFROM read_csv_auto('./trees.csv')\nWHERE tree_dbh IS NOT NULL\nGROUP BY size_class\nORDER BY MIN(tree_dbh);\n\n`);\n\n const ecologicalImpact = await conn.all(`\nSELECT\nborough,\nSUM(tree_dbh) AS total_dbh_inches,\nROUND(AVG(tree_dbh), 2) AS avg_dbh_inches,\nCOUNT(*) AS tree_count,\nROUND(SUM(tree_dbh)::FLOAT / COUNT(*), 2) AS dbh_per_tree\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_dbh_inches DESC;\n\n`);\n\n const stewardshipImpact = await conn.all(`\nSELECT\nsteward AS stewardship_level,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY steward\nORDER BY percent_healthy DESC;\n`);\n await conn.close();\n await db.close();\n return jsonStringify({\n boroughStats,\n top5Species,\n top5Neighborhoods,\n treeHealthDistribution,\n treeSizeDistribution,\n ecologicalImpact,\n stewardshipImpact,\n });\n}\n\nconst jsonStringify = (data) => {\n return JSON.stringify(data, (key, value) =>\n typeof value === \"bigint\"\n ? value.toString()\n : value);\n};",4,["D",1742914040440],10,{"_107":237,"_153":139,"_150":188,"_99":103,"_160":238,"_158":159,"_104":239,"_152":-5,"_109":240,"_154":191,"_163":-5},"ec504880-0986-11f0-ab56-569c3dd06744","// import duckdb from \"npm:duckdb\";\nexport async function ddb() {\n const resp = await fetch(\n \"https://raw.githubusercontent.com/maxmcd/t/refs/heads/main/trees-24.csv\",\n );\n const file = await Deno.open(\"./trees.csv\", { write: true, create: true });\n await resp.body?.pipeTo(file.writable);\n\n const duckdb = await import(\"npm:duckdb-async\");\n const db = await duckdb.default.Database.create(\":memory:\");\n const conn = await db.connect();\n\n const boroughStats = await conn.all(`\nSELECT\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_trees DESC;\n`);\n\n const top5Species = await conn.all(`\nSELECT\nspc_common AS species,\nCOUNT(*) AS total_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health_count,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY spc_common\nORDER BY total_count DESC\nLIMIT 5;\n\n`);\n\n const top5Neighborhoods = await conn.all(`\nSELECT\nnta_name AS neighborhood,\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species\nFROM read_csv_auto('./trees.csv')\nGROUP BY nta_name, borough\nORDER BY total_trees DESC\nLIMIT 5;\n`);\n\n const treeHealthDistribution = await conn.all(`\nSELECT\nborough,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health,\nCOUNT(CASE WHEN health IS NULL OR health = '' THEN 1 END) AS unknown_health\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY SUM(CASE WHEN health = 'Good' THEN 1 ELSE 0 END) DESC;\n`);\n\n const treeSizeDistribution = await conn.all(`\nSELECT\nCASE\n WHEN tree_dbh < 5 THEN 'Very Small (< 5\")'\n WHEN tree_dbh >= 5 AND tree_dbh < 10 THEN 'Small (5-10\")'\n WHEN tree_dbh >= 10 AND tree_dbh < 20 THEN 'Medium (10-20\")'\n WHEN tree_dbh >= 20 AND tree_dbh < 30 THEN 'Large (20-30\")'\n WHEN tree_dbh >= 30 AND tree_dbh < 40 THEN 'Very Large (30-40\")'\n WHEN tree_dbh >= 40 THEN 'Enormous (40\"+)'\nEND AS size_class,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nMIN(tree_dbh) AS min_diameter,\nMAX(tree_dbh) AS max_diameter,\nROUND(COUNT(*)::FLOAT / (SELECT COUNT(*) FROM read_csv_auto('./trees.csv')) * 100, 2) AS percentage\nFROM read_csv_auto('./trees.csv')\nWHERE tree_dbh IS NOT NULL\nGROUP BY size_class\nORDER BY MIN(tree_dbh);\n\n`);\n\n const ecologicalImpact = await conn.all(`\nSELECT\nborough,\nSUM(tree_dbh) AS total_dbh_inches,\nROUND(AVG(tree_dbh), 2) AS avg_dbh_inches,\nCOUNT(*) AS tree_count,\nROUND(SUM(tree_dbh)::FLOAT / COUNT(*), 2) AS dbh_per_tree\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_dbh_inches DESC;\n\n`);\n\n const stewardshipImpact = await conn.all(`\nSELECT\nsteward AS stewardship_level,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY steward\nORDER BY percent_healthy DESC;\n`);\n await conn.close();\n await db.close();\n return {\n boroughStats,\n top5Species,\n top5Neighborhoods,\n treeHealthDistribution,\n treeSizeDistribution,\n ecologicalImpact,\n stewardshipImpact,\n };\n}",3,["D",1742913554335],{"_107":242,"_153":139,"_150":188,"_99":103,"_160":243,"_158":159,"_104":94,"_152":-5,"_109":244,"_154":233,"_163":-5},"e8950442-0986-11f0-926a-569c3dd06744","// import duckdb from \"npm:duckdb\";\nexport async function ddb() {\n const resp = await fetch(\n \"https://raw.githubusercontent.com/maxmcd/t/refs/heads/main/trees-24.csv\",\n );\n const file = await Deno.open(\"./trees.csv\", { write: true, create: true });\n await resp.body?.pipeTo(file.writable);\n\n const duckdb = await import(\"npm:duckdb-async\");\n const db = await duckdb.default.Database.create(\":memory:\");\n const conn = await db.connect();\n\n const boroughStats = await conn.all(`\nSELECT\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_trees DESC;\n`);\n\n const top5Species = await conn.all(`\nSELECT\nspc_common AS species,\nCOUNT(*) AS total_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health_count,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY spc_common\nORDER BY total_count DESC\nLIMIT 5;\n\n`);\n\n const top5Neighborhoods = await conn.all(`\nSELECT\nnta_name AS neighborhood,\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species\nFROM read_csv_auto('./trees.csv')\nGROUP BY nta_name, borough\nORDER BY total_trees DESC\nLIMIT 5;\n`);\n\n const treeHealthDistribution = await conn.all(`\nSELECT\nborough,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health,\nCOUNT(CASE WHEN health IS NULL OR health = '' THEN 1 END) AS unknown_health\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY SUM(CASE WHEN health = 'Good' THEN 1 ELSE 0 END) DESC;\n`);\n\n const treeSizeDistribution = await conn.all(`\nSELECT\nCASE\n WHEN tree_dbh < 5 THEN 'Very Small (< 5\")'\n WHEN tree_dbh >= 5 AND tree_dbh < 10 THEN 'Small (5-10\")'\n WHEN tree_dbh >= 10 AND tree_dbh < 20 THEN 'Medium (10-20\")'\n WHEN tree_dbh >= 20 AND tree_dbh < 30 THEN 'Large (20-30\")'\n WHEN tree_dbh >= 30 AND tree_dbh < 40 THEN 'Very Large (30-40\")'\n WHEN tree_dbh >= 40 THEN 'Enormous (40\"+)'\nEND AS size_class,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nMIN(tree_dbh) AS min_diameter,\nMAX(tree_dbh) AS max_diameter,\nROUND(COUNT(*)::FLOAT / (SELECT COUNT(*) FROM read_csv_auto('./trees.csv')) * 100, 2) AS percentage\nFROM read_csv_auto('./trees.csv')\nWHERE tree_dbh IS NOT NULL\nGROUP BY size_class\nORDER BY MIN(tree_dbh);\n\n`);\n\n const ecologicalImpact = await conn.all(`\nSELECT\nborough,\nSUM(tree_dbh) AS total_dbh_inches,\nROUND(AVG(tree_dbh), 2) AS avg_dbh_inches,\nCOUNT(*) AS tree_count,\nROUND(SUM(tree_dbh)::FLOAT / COUNT(*), 2) AS dbh_per_tree\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_dbh_inches DESC;\n\n`);\n\n const stewardshipImpact = await conn.all(`\nSELECT\nsteward AS stewardship_level,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY steward\nORDER BY percent_healthy DESC;\n`);\n await conn.close();\n await db.close();\n return {\n boroughStats,\n top5Species,\n top5Neighborhoods,\n treeHealthDistribution,\n treeSizeDistribution,\n ecologicalImpact,\n stewardshipImpact,\n };\n}\n\nconsole.log(await ddb());",["D",1742913548075],{"_107":246,"_153":139,"_150":188,"_99":103,"_160":247,"_158":159,"_104":173,"_152":-5,"_109":248,"_154":239,"_163":-5},"e717cc12-0986-11f0-9492-569c3dd06744","// import duckdb from \"npm:duckdb\";\nasync function ddb() {\n const resp = await fetch(\n \"https://raw.githubusercontent.com/maxmcd/t/refs/heads/main/trees-24.csv\",\n );\n const file = await Deno.open(\"./trees.csv\", { write: true, create: true });\n await resp.body?.pipeTo(file.writable);\n\n const duckdb = await import(\"npm:duckdb-async\");\n const db = await duckdb.default.Database.create(\":memory:\");\n const conn = await db.connect();\n\n const boroughStats = await conn.all(`\nSELECT\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_trees DESC;\n`);\n\n const top5Species = await conn.all(`\nSELECT\nspc_common AS species,\nCOUNT(*) AS total_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health_count,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY spc_common\nORDER BY total_count DESC\nLIMIT 5;\n\n`);\n\n const top5Neighborhoods = await conn.all(`\nSELECT\nnta_name AS neighborhood,\nborough,\nCOUNT(*) AS total_trees,\nCOUNT(DISTINCT spc_common) AS unique_species,\nROUND(AVG(tree_dbh), 1) AS avg_diameter_inches,\nMODE(spc_common) AS most_common_species\nFROM read_csv_auto('./trees.csv')\nGROUP BY nta_name, borough\nORDER BY total_trees DESC\nLIMIT 5;\n`);\n\n const treeHealthDistribution = await conn.all(`\nSELECT\nborough,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health,\nCOUNT(CASE WHEN health = 'Fair' THEN 1 END) AS fair_health,\nCOUNT(CASE WHEN health = 'Poor' THEN 1 END) AS poor_health,\nCOUNT(CASE WHEN health IS NULL OR health = '' THEN 1 END) AS unknown_health\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY SUM(CASE WHEN health = 'Good' THEN 1 ELSE 0 END) DESC;\n`);\n\n const treeSizeDistribution = await conn.all(`\nSELECT\nCASE\n WHEN tree_dbh < 5 THEN 'Very Small (< 5\")'\n WHEN tree_dbh >= 5 AND tree_dbh < 10 THEN 'Small (5-10\")'\n WHEN tree_dbh >= 10 AND tree_dbh < 20 THEN 'Medium (10-20\")'\n WHEN tree_dbh >= 20 AND tree_dbh < 30 THEN 'Large (20-30\")'\n WHEN tree_dbh >= 30 AND tree_dbh < 40 THEN 'Very Large (30-40\")'\n WHEN tree_dbh >= 40 THEN 'Enormous (40\"+)'\nEND AS size_class,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nMIN(tree_dbh) AS min_diameter,\nMAX(tree_dbh) AS max_diameter,\nROUND(COUNT(*)::FLOAT / (SELECT COUNT(*) FROM read_csv_auto('./trees.csv')) * 100, 2) AS percentage\nFROM read_csv_auto('./trees.csv')\nWHERE tree_dbh IS NOT NULL\nGROUP BY size_class\nORDER BY MIN(tree_dbh);\n\n`);\n\n const ecologicalImpact = await conn.all(`\nSELECT\nborough,\nSUM(tree_dbh) AS total_dbh_inches,\nROUND(AVG(tree_dbh), 2) AS avg_dbh_inches,\nCOUNT(*) AS tree_count,\nROUND(SUM(tree_dbh)::FLOAT / COUNT(*), 2) AS dbh_per_tree\nFROM read_csv_auto('./trees.csv')\nGROUP BY borough\nORDER BY total_dbh_inches DESC;\n\n`);\n\n const stewardshipImpact = await conn.all(`\nSELECT\nsteward AS stewardship_level,\nCOUNT(*) AS tree_count,\nROUND(AVG(tree_dbh), 1) AS avg_diameter,\nCOUNT(CASE WHEN health = 'Good' THEN 1 END) AS good_health_count,\nROUND(COUNT(CASE WHEN health = 'Good' THEN 1 END)::FLOAT / NULLIF(COUNT(*), 0) * 100, 1) AS percent_healthy\nFROM read_csv_auto('./trees.csv')\nGROUP BY steward\nORDER BY percent_healthy DESC;\n`);\n await conn.close();\n await db.close();\n return {\n boroughStats,\n top5Species,\n top5Neighborhoods,\n treeHealthDistribution,\n treeSizeDistribution,\n ecologicalImpact,\n stewardshipImpact,\n };\n}\n\nconsole.log(await ddb());",["D",1742913545575],{"_107":250,"_153":139,"_150":188,"_99":103,"_160":70,"_158":159,"_104":33,"_152":-5,"_109":251,"_154":94,"_163":-5},"e39fedb2-0986-11f0-84fa-569c3dd06744",["D",1742913539753],"versions",[254,256,257,258,259,260],{"_205":228,"_255":230},"previous",{"_205":230,"_255":236},{"_205":236,"_255":241},{"_205":241,"_255":245},{"_205":245,"_255":249},{"_205":249,"_255":-5},"versionNumber","page","hasNext","routes/_app","actionData","errors"]

History for trees.ts