31:T4a8,vegalite({ "$schema": "https://vega.github.io/schema/vega-lite/v5.json", "description": "Plot showing average data with raw values in the background.", // "transform": [{"filter": "datum.symbol==='GOOG'"}], "layer": [ {"title": "Buffalo Bayour River Gage Height at Houston", "data": {"values": gage_height_daily_array}, "mark": "line", "encoding": { "x": {"field": "dateTime", "type": "temporal"}, "y": {"field": "value", "title": " Height in feet", "type": "quantitative"} } }, { "data": {"values": [{"value":too_high_for_normal_bidirectional_trip}]}, "mark": "rule", "encoding": { "y": {"aggregate": "max", "field": "value"}, "color": {"value": "red"}, "size": {"value": 1}, "title": "Too high for normal upstream paddling trip" } }, { "data": {"values": [{"dateTime":time_slice_date.value, "value":0}]}, "mark": "rule", "encoding": { "x": {"type": "temporal", "field": "dateTime"}, "color": {"value": "green"}, "size": {"value": 3}, "title": "Date in question" } } ], "width":800 })32:T4ad,vegalite({ "$schema": "https://vega.github.io/schema/vega-lite/v5.json", "description": "Plot showing average data with raw values in the background.", // "transform": [{"filter": "datum.symbol==='GOOG'"}], "layer": [ {"title": "Buffalo Bayour River Gage Height at Houston", "data": {"values": filteredArrayForSeletedDate }, "mark": "line", "encoding": { "x": {"field": "dateTime", "type": "temporal"}, "y": {"field": "value", "title": " Height in feet", "type": "quantitative"} } }, { "data": {"values": [{"value":too_high_for_normal_bidirectional_trip}]}, "mark": "rule", "encoding": { "y": {"aggregate": "max", "field": "value"}, "color": {"value": "red"}, "size": {"value": 1}, "title": "Too high for normal upstream paddling trip" } }, { "data": {"values": [{"dateTime":time_slice_date.value, "value":0}]}, "mark": "rule", "encoding": { "x": {"type": "temporal", "field": "dateTime"}, "color": {"value": "green"}, "size": {"value": 3}, "title": "Date in question" } } ], "width":800 })33:T49e,html `

Possible Questions to Answer with Future Work

What percent of last X amount of time was the river paddleable?
What months are less likely to be paddeable?
How unusual is this stretch of high water?
What does history say about how long it will take until buffalo bayou is low enough to be paddled again?
How do these answers change based on directional trip vs. one-way and type of crafts & skill levels?
Make a list of paddle locations suitable right now
Rank list by how unusual suitability to paddling is over past X number of years
Rank list by how unusual suitability to paddling is for this time of year over past X number of years
For a given put-in location,experience level, and boat type predict the probability conditions will stay within, above, or below a given threshold based on current levels, trend over past Y days, and historical patterns.
Organize potential trips by distance to put-in, time required, length of trip, ideal boat, required experience level, type of paddling, and other static characteristics in addition to flow based criteria.

`34:[] 2f:{"title":"When Could You Paddle Buffalo Bayou?","cells":[{"id":0,"value":"md`# When Could You Paddle Buffalo Bayou?`","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"viewof too_high_for_normal_bidirectional_trip = slider({\n min: 0, \n max: 30, \n step: 0.5, \n value: 6.8, \n title: \"Gauge Height at Houston\", \n description: \"Select a gauge hight that would be too high for most bi-directional paddling trips on buffalo bayou\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":77,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":168,"value":"html `

Percent of days with conditions low enough that a beginner to intermediate paddler in any type of kayak could easily do a bi-directional paddle on Buffalo Bayou, meaning upstream and then back downstream from the Sabine Promenade put-in since ${minDate.slice(0,10)} to present day is \n${percent_good_days_for_bidirectional_trip_as_decimal.toFixed(2)*100} %.\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":328,"value":"## How long to show","pinned":false,"hidden":false,"mode":"md"},{"id":206,"value":"viewof date_for_filter_start = date({\n title: \"Filter Received Data. This starts the range at\", \n min: \"1985-01-01\",\n // max: \"2017-12-31\",\n value: \"2018-01-01\",\n description: \"Click the calendar icon to change starting point.Only dates since 1985 calendar year are allowed. \"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":232,"value":"html `And end of date range is:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":216,"value":"date_today_YYYYMMDD_string = new Date().toISOString().slice(0,10)","pinned":false,"hidden":false,"mode":"ojs"},{"id":325,"value":"## Select a single date within the larger range above \n### The date will be shown as green vertical marker in the plot above\n### and the flow height over just that day will be shown in the chart below","pinned":false,"hidden":false,"mode":"md"},{"id":362,"value":"This may be useful for looking at Google maps imagery and understanding range of height possible on a given day.","pinned":false,"hidden":false,"mode":"md"},{"id":314,"value":"time_slice_date = date({value: \"2022-07-04\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":368,"value":"

Plot shows river height changes on ${time_slice_date.value}

","pinned":false,"hidden":false,"mode":"html"},{"id":348,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":227,"value":"md `----------`","pinned":false,"hidden":false,"mode":"ojs"},{"id":264,"value":"md `----------`","pinned":false,"hidden":false,"mode":"ojs"},{"id":265,"value":"md `----------`","pinned":false,"hidden":false,"mode":"ojs"},{"id":242,"value":"md `# What is this?`","pinned":false,"hidden":false,"mode":"ojs"},{"id":244,"value":"md `\n#### This is a playground built up with a few minutes here and there to explore what questions you could ask to help plan kayaking trips from USGS river gauge data if you looked at the historical data and not just what the river is flowing at right now.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":253,"value":"md `\nI'm curious how representing and thinking about the data differently could affect decisions on when & where to paddle.\n\n- Would it prompt you to consider different types of trips? \n\n- Would it prompt you to take a trip based on the trip not usually being available?\n\n- Would it change how you plan?`","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"md `### This plot is from here: https://waterwatch.usgs.gov/index.php?sno=08074000&ds=dv01d&yt=yv&bdt=1985&edt=&ut=cfs&id=wwchart_rastergraph&ct=wwrg&mk=0 not sure why so much data is missing? Can we use it as inspiration but slightly different?`","pinned":false,"hidden":false,"mode":"ojs"},{"id":162,"value":"html `

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":261,"value":"md `# CALCULATIONS`","pinned":false,"hidden":false,"mode":"ojs"},{"id":157,"value":"percent_good_days_for_bidirectional_trip_as_decimal = percent_good_days_for_bidirectional_trip(gage_height_daily_array,\"value\",too_high_for_normal_bidirectional_trip)","pinned":false,"hidden":false,"mode":"ojs"},{"id":145,"value":"good_days_for_bidirectional_trip = calculatePercentDaysUnderLimit(gage_height_daily_array,\"value\",too_high_for_normal_bidirectional_trip)","pinned":true,"hidden":false,"mode":"ojs"},{"id":150,"value":"gage_height_daily_array","pinned":true,"hidden":false,"mode":"ojs"},{"id":152,"value":"function percent_good_days_for_bidirectional_trip(stream_data_array_of_objects,key_name,max_value){\n var good_days = calculatePercentDaysUnderLimit(stream_data_array_of_objects,key_name,max_value)\n var percent_good_days = good_days.length / stream_data_array_of_objects.length\n return percent_good_days\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":139,"value":"function calculatePercentDaysUnderLimit(stream_data_array_of_objects,key_name,max_value){\n return stream_data_array_of_objects.filter(good_days => (good_days[key_name] < max_value)); \n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":185,"value":"function limit_data_to_smaller_date_range(data){\n \n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":24,"value":"vegalite({\n \"title\": \"Buffalo Bayour River Gage Height at Houston\",\n \"data\": {\n \"values\": gage_height_daily_array\n },\n \"mark\": \"line\",\n \"encoding\": {\n \"x\": {\"field\": \"dateTime\", \"type\": \"temporal\"},\n \"y\": {\"field\": \"value\", \n \"title\": \" Height in feet\",\n \"type\": \"quantitative\"}\n },\n \"width\":\"800\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"maxDate = gage_height_daily_array.slice().sort((a, b) => d3.descending(a.dateTime, b.dateTime))[0].dateTime","pinned":true,"hidden":false,"mode":"ojs"},{"id":22,"value":"minDate = gage_height_daily_array.slice().sort((a, b) => d3.ascending(a.dateTime, b.dateTime))[0].dateTime","pinned":true,"hidden":false,"mode":"ojs"},{"id":330,"value":"function filterBySameDay(objectsArray, targetDate) {\n return objectsArray.filter(obj => {\n const objDate = new Date(obj.dateTime);\n const targetDateObj = new Date(targetDate);\n \n return (\n objDate.getFullYear() === targetDateObj.getFullYear() &&\n objDate.getMonth() === targetDateObj.getMonth() &&\n objDate.getDate() === targetDateObj.getDate()\n );\n });\n}\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":9,"value":"gage_height = data.value.timeSeries[1].values[0].value","pinned":true,"hidden":false,"mode":"ojs"},{"id":339,"value":"targetDate = \"2022-01-01T00:00:00.000-06:00\";","pinned":true,"hidden":false,"mode":"ojs"},{"id":332,"value":"heights_over_day = data.value.timeSeries[1].values[0].value","pinned":true,"hidden":false,"mode":"ojs"},{"id":342,"value":"filteredArrayForSeletedDate = filterBySameDay(heights_over_day, time_slice_date.value);","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"data = d3.json('https://nwis.waterservices.usgs.gov/nwis/iv/?format=json&sites=08074000&startDT='+date_for_filter_start+'&endDT='+date_today_YYYYMMDD_string+'¶meterCd=00060,00065&siteStatus=all')","pinned":true,"hidden":false,"mode":"ojs"},{"id":302,"value":"url_used = 'https://nwis.waterservices.usgs.gov/nwis/iv/?format=json&sites=08074000&startDT='+date_for_filter_start+'&endDT='+date_today_YYYYMMDD_string+'¶meterCd=00060,00065&siteStatus=all'","pinned":true,"hidden":false,"mode":"ojs"},{"id":44,"value":"gage_height_daily_array = getGageHeightFromDailyAverageResults(data_daily_avg,\"Gage height, ft\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":308,"value":"data_daily_avg","pinned":true,"hidden":false,"mode":"ojs"},{"id":42,"value":"function getGageHeightFromDailyAverageResults(raw_json_returned_daily_avgs,variableName){\n var variableName = \"Gage height, ft\"\n var data = raw_json_returned_daily_avgs.value.timeSeries\n for (var i = 0; i < data.length; i++){\n if(data[i].variable.variableName == \"Gage height, ft\"){\n return data[i].values[0].value\n }\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":297,"value":"md `### THE DATA! Thanks USGS`","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"data_daily_avg = d3.json('https://waterservices.usgs.gov/nwis/dv/?format=json&sites=08074000&startDT='+date_for_filter_start+'&endDT='+date_today_YYYYMMDD_string+'&siteStatus=all')\n\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":204,"value":"import {date} from \"@jashkenas/inputs\"\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":131,"value":"import {slider} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":2,"value":"d3 = require(\"d3@5\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":25,"value":"vegalite = require(\"@observablehq/vega-lite@0.1\")","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}