${data.title}

Data source: policysupport.org

\n View Source\n

\n\n \n\n`;\n}","deleted",false,"label",[37],"0b95f506-1dc2-11f0-aaca-569c3dd06744","downloadEcoData.ts","d88afa22-1dc0-11f0-b5ed-569c3dd06744",12,["D",1745137970359],4,"script","/**\n * Script to download ecological data from policysupport.org and save it to blob storage\n */\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nasync function downloadEcoData() {\n try {\n // URL to fetch data from\n const url = \"http://www1.policysupport.org/cgi-bin/ecoengine/fsl.cgi?action=Data2Dash&Query=SendAllData&FilterDates=1Y&format=CSV&FilterVars=P2&FID=L585&year=2024&AutoRange=True&StartDate=1706745600.0&EndDate=1709251199.0\";\n \n // Fetch the data\n console.log(\"Fetching data from policysupport.org...\");\n const response = await fetch(url);\n \n if (!response.ok) {\n throw new Error(`Failed to fetch data: ${response.status} ${response.statusText}`);\n }\n \n // Get the data as text (since it's CSV format)\n const csvData = await response.text();\n \n // Generate a timestamp for the filename\n const timestamp = new Date().toISOString().replace(/[:.]/g, \"-\");\n const blobKey = `eco_data_${timestamp}`;\n \n // Save to blob storage\n console.log(`Saving data to blob storage with key: ${blobKey}`);\n await blob.set(blobKey, csvData);\n \n // Also save with a consistent key for latest data\n await blob.set(\"eco_data_latest\", csvData);\n \n return {\n success: true,\n message: `Data successfully downloaded and saved to blob storage with keys: ${blobKey} and eco_data_latest`,\n timestamp: new Date().toISOString(),\n dataSize: csvData.length\n };\n } catch (error) {\n console.error(\"Error downloading or saving data:\", error);\n return {\n success: false,\n error: error.message,\n timestamp: new Date().toISOString()\n };\n }\n}\n\n// Run the function immediately\ndownloadEcoData()\n .then(result => console.log(\"Result:\", result))\n .catch(error => console.error(\"Execution error:\", error));",[59],"49192066-1dc1-11f0-b276-569c3dd06744","README.md","8d8b93a6-1dc0-11f0-badb-569c3dd06744",6,["D",1745137644063],2,"# jessiesdata\n\n## Scripts\n\n### downloadEcoData.ts\nDownloads ecological data from policysupport.org and saves it to blob storage. The script:\n- Fetches CSV data from the specified URL\n- Saves the data to blob storage with a timestamped key\n- Also saves the data with a consistent key \"eco_data_latest\" for easy access to the most recent data\n\nTo run this script manually, you can call it directly. To schedule it to run automatically, you can set up a cron trigger in the Val Town web UI.\n\n### viewEcoData.ts (HTTP)\nRenders the ecological data from blob storage in a clean, interactive HTML table. Features:\n- Displays data in a responsive, well-formatted table\n- Allows sorting by clicking on column headers\n- Includes search functionality to filter the table\n- Provides a download button to export the data as CSV\n- Highlights search matches in the table\n\nThis val requires that data has been previously downloaded using the `downloadEcoData.ts` script.",[68],{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":85,"_17":72,"_50":24,"_52":73,"_54":55,"_56":-5,"_79":86,"_18":87},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":82,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_79":83,"_18":84},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_79":80,"_18":81},["D",1745300785944],"children",[],[37],["D",1745137970359],[],[59],["D",1745137644063],[],[68],"f947ea96-1dbf-11f0-9997-569c3dd06744",["D",1745137080666],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","8acb974a-4b91-4d4a-b000-6f28827b7e16","pinnedFileId","pinPreview","pinMigrated","screenshotVersion",24,"likeCount",0,"orgId","b74060f0-0f1d-44f1-bee2-bdb9c9cf72e4","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_142":138},"org",{"_11":12,"_136":-5,"_137":138,"_97":98,"_139":140,"_141":55},"branch",{"_17":44,"_13":16,"_35":42,"_128":88,"_129":-5,"_130":-5,"_131":-5,"_132":-5,"_133":-5,"_134":14,"_135":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://secure.gravatar.com/avatar/109fa713caf4e083c57622b7c6dad365.jpg?s=200&d=identicon","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":88,"_13":14,"_47":185,"_90":-5,"_91":55,"_92":93,"_94":93,"_95":-5,"_96":-5,"_97":98,"_99":39,"_100":46,"_101":-5,"_102":103,"_104":105,"_106":107,"_108":-5,"_109":-5,"_110":-5,"_111":-5,"_112":113,"_114":113,"_115":116,"_117":116,"_118":116,"_119":113,"_120":113,"_121":186,"_123":187,"_125":188,"_127":55},[176,177,178],"files",[176,177,178],"counts",{"_167":105,"_168":49,"_169":105,"_31":170,"_171":172},[161,162,163],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":24,"_52":73,"_54":55,"_56":-5,"_18":166},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_18":165},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":164},[37],[59],[68],"pulls","branches","forks",{"_173":105,"_175":105},"connections",{"_173":105,"_174":105},"count","unfilledCount","emptyCount",{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":85,"_17":72,"_50":24,"_52":73,"_54":55,"_56":-5,"_79":183,"_18":184},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":82,"_17":63,"_50":64,"_52":65,"_54":55,"_56":-5,"_79":181,"_18":182},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_79":179,"_18":180},[],[37],[],[59],[],[68],["D",1745137080666],{"_11":12,"_142":138},{"_11":12,"_136":-5,"_137":138,"_97":98,"_139":140,"_141":55},{"_17":44,"_13":16,"_35":42,"_128":88,"_129":-5,"_130":-5,"_131":-5,"_132":-5,"_133":-5,"_134":14,"_135":12},"ctx",{"_121":-5,"_158":222,"_223":224,"_225":226,"_227":55,"_228":55,"_229":55,"_230":46,"_231":-5,"_232":-7,"_233":-7,"_234":105,"_235":55,"_236":55,"_237":-5,"_238":55,"_239":55,"_240":55,"_241":-5},"ENV",{"_193":194,"_195":196,"_197":16,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","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/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code