25:["$","title",null,{"children":"Emergency Response: Weather and Traffic | Toby Zhu | Observable"}] 49:[] 29:{"id":"72d8cf1b45bac53b","slug":null,"title":"Emergency Response: Weather and Traffic","thumbnail":"bf909ceba98f53972121cf075a62a7f713cb482965af6fbfdeb826b6e99dc398","access_level":"public","create_time":"$D2023-05-02T01:43:23.705Z","update_time":"$D2023-05-02T01:43:23.705Z","view_time":null,"first_public_time":"$D2023-05-02T01:43:23.705Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"50ba3ab87865222e","login":"tobyzhu","name":"Toby Zhu","avatar_url":"https://avatars-next.observableusercontent.com/16f7991fbd592946eff73e262dbfa58c16e735759dd313d388c0cf2baa2b72b4","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1091,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"a53831491c225e96","login":"tobyzhu","name":"Toby Zhu","avatar_url":"https://avatars-next.observableusercontent.com/16f7991fbd592946eff73e262dbfa58c16e735759dd313d388c0cf2baa2b72b4","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"a53831491c225e96","login":"tobyzhu","name":"Toby Zhu","avatar_url":"https://avatars-next.observableusercontent.com/16f7991fbd592946eff73e262dbfa58c16e735759dd313d388c0cf2baa2b72b4","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Emergency Response: Weather and Traffic","cells":[{"id":0,"value":"# Emergency Response: Weather and Traffic","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"## Set Credentials for Amazon S3","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"viewof accessKeyId = secret('accessKeyId', {title: \"AWS Access Key ID\", submit: \"Set\", description: \"localStorage[\\\"accessKeyId\\\"]\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"viewof secretAccessKey = secret('secretAccessKey', {title: \"AWS Secret Access Key\", submit: \"Set\", description: \"localStorage[\\\"secretAccessKey\\\"]\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"viewof sessionToken = secret('sessionToken', {title: \"AWS Session Token\", submit: \"Set\", description: \"localStorage[\\\"sessionToken\\\"]\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"AWS.config.credentials = new AWS.Credentials(localStorage[\"accessKeyId\"], localStorage[\"secretAccessKey\"], localStorage['sessionToken'])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"auth_AWS = {\n AWS.config.credentials;\n AWS.config.region;\n return AWS;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"## Visualization","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":451,"value":"viewof weather = Inputs.select(['Humidity', 'Rain', 'Snow', 'Temperature', 'Wind'], {label: \"Weather condition\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"\n \n \n \n

\n Number of incidents under different levels of weather conditions\n

\n Number of incidents per 1000 occurrences of specific weather conditions\n

\n ${selector[0]}\n

\n ${selector[1]}\n

\n Response time under different levels of weather conditions\n

\n ${selector[2]}\n

\n Number of incidents under different levels of traffic conditions\n

\n Number of incidents per 100000 records of specific traffic conditions\n

\n ${selector_t[0]}\n

\n ${selector_t[1]}\n

\n Response time under different levels of traffic conditions\n

\n ${selector_t[2]}\n

\n \n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":706,"value":"### Data preparation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":453,"value":"selector = {\n switch(weather) {\n case 'Humidity':\n return [plt_h, plt_h2, plt_h3]\n case 'Temperature':\n return [plt_t, plt_t2, plt_t3]\n case 'Wind':\n return [plt_w, plt_w2, plt_w3]\n case 'Rain':\n return [plt_r, plt_r2, plt_r3]\n case 'Snow':\n return [plt_s, plt_s2, plt_s3]\n default:\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1086,"value":"selector_t = {\n switch(traffic) {\n case 'Average Speed':\n return [plt_as, plt_as2, plt_as3]\n case 'Congestion':\n return [plt_c, plt_c2, plt_c3] \n default:\n return [plt_sp, plt_sp2, plt_sp3]\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":952,"value":"#### Weather","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":42,"value":"humidity_incidents = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/humidity_bracket.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"humidity_occurs = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/humidity_occur.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"humidity_per = {\n return humidity_occurs.map((d,i) => {\n if (i === 0) return {hum_group:d.wind_group, num_entries:0}\n return {hum_group:d.wind_group, num_entries:humidity_incidents[i-1].num_entries / d.num_entries * 1000}\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":804,"value":"humidity_resp = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/humidity_rt.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = Number(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"rain_incidents = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/rain_bracket.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n data[10].snow_group = '> 9'\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":566,"value":"rain_occurs = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/rain_occur.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n data[10].precip_group = '> 9'\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":570,"value":"rain_per = rain_occurs.map((d,i) => ({precip_group:d.precip_group, num_entries:rain_incidents[i].num_entries / d.num_entries * 1000}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":892,"value":"rain_resp = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/rain_rt.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.response_time = Number(d.response_time))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":578,"value":"snow_incidents = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/snow_bracket.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n data[8].snow_group = '> 9'\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":582,"value":"snow_occurs = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/snow_occur.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n data[10].snow_group = '> 9'\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":586,"value":"snow_per = {\n return snow_occurs.map((d,i) => {\n if (i < 7) {\n return {snow_group:d.snow_group, num_entries:snow_incidents[i].num_entries / d.num_entries * 1000}\n } else if (i === 7 || i === 9) {\n return {snow_group:d.snow_group, num_entries:0}\n } else if (i === 8) {\n return {snow_group:d.snow_group, num_entries:snow_incidents[i-1].num_entries / d.num_entries * 1000}\n } else {\n return {snow_group:d.snow_group, num_entries:snow_incidents[i-2].num_entries / d.num_entries * 1000}\n }\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":907,"value":"snow_resp = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/snow_rt.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = Number(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"temp_incidents = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/temp_bracket.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"temp_occurs = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/temp_occur.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data.slice(1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"temp_per = temp_occurs.map((d,i) => ({temperature_group:d.temperature_group, num_entries:temp_incidents[i].num_entries / d.num_entries * 1000}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":922,"value":"temp_resp = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/temp_rt.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = Number(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"wind_incidents = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/wind_bracket.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"wind_occurs = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/wind_occur.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"wind_per = wind_occurs.map((d,i) => ({wind_group:d.wind_group, num_entries:wind_incidents[i].num_entries / d.num_entries * 1000}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":927,"value":"wind_resp = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/wind_rt.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = Number(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":954,"value":"#### Traffic","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":956,"value":"avg_speed_incidents = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/avg_speed_bracket.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":965,"value":"avg_speed_occurs = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/avg_speed_occur.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":972,"value":"avg_speed_per = avg_speed_occurs.map((d,i) => ({average_speed_group:d.average_speed_group, num_entries:avg_speed_incidents[i].num_entries / d.num_entries * 100000}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":980,"value":"avg_speed_resp = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/avg_speed_rt.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = Number(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":987,"value":"speed_incidents = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/speed_bracket.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":988,"value":"speed_occurs = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/speed_occur.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":989,"value":"speed_per = speed_occurs.map((d,i) => ({speed_group:d.speed_group, num_entries:speed_incidents[i].num_entries / d.num_entries * 100000}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":990,"value":"speed_resp = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/speed_rt.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = Number(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":"cong_incidents = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/cong_bracket.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1003,"value":"cong_occurs = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/cong_occur.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = parseInt(d.num_entries))\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1004,"value":"cong_per = cong_occurs.map((d,i) => ({congestion_group:d.congestion_group, num_entries:cong_incidents[i].num_entries / d.num_entries * 100000}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1005,"value":"cong_resp = {\n let objectParams = ({\n Bucket: 'wwu-incidents',\n Key: 'incidents_weather_insights/cong_rt.csv',\n Expires: 60*5\n })\n let data = await d3.csv(s3.getSignedUrl('getObject', objectParams))\n data.forEach(d => d.num_entries = Number(d.num_entries))\n return data.slice(0,-1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":669,"value":"### Individual plots","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1018,"value":"#### Weather","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":791,"value":"plt_h = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n domain: humidity_occurs.map(d => d.wind_group),\n label: 'Humidity Level',\n },\n y: {\n grid: true, \n label: 'Incident Count', \n domain:[0,6000],\n ticks:10\n },\n marks: [\n Plot.barY(humidity_incidents, {x: \"hum_group\", y: \"num_entries\", fill: '#65a7ff'}),\n Plot.text(humidity_incidents, {x: \"hum_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":796,"value":"plt_h2 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Humidity Level'\n },\n y: {\n grid: true, \n label: 'Incident Count per 1000 Occurrence',\n domain: [0,3.2]\n },\n marks: [\n Plot.barY(humidity_per, {x: \"hum_group\", y: \"num_entries\", fill: '#b33a52'}),\n Plot.text(humidity_per, {x: \"hum_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"value":"plt_h3 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Humidity Level',\n domain: humidity_occurs.map(d => d.wind_group)\n },\n y: {\n grid: true, \n label: 'Average Response Time (sec)',\n domain: [0,450]\n },\n marks: [\n Plot.barY(humidity_resp, {x: \"hum_group\", y: \"num_entries\", fill: \"#69b3a2\"}),\n Plot.text(humidity_resp, {x: \"hum_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":612,"value":"plt_r = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Precipitation Level',\n },\n y: {grid: true, label: 'Incident Count', domain:[0,2200]},\n marks: [\n Plot.barY(rain_incidents, {x: \"snow_group\", y: \"num_entries\", fill: '#65a7ff'}),\n Plot.text(rain_incidents, {x: \"snow_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":620,"value":"plt_r2 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Precipitation Level'\n },\n y: {\n grid: true, \n label: 'Incident Count per 1000 Occurrence',\n domain: [0,3.5]\n },\n marks: [\n Plot.barY(rain_per, {x: \"precip_group\", y: \"num_entries\", fill: '#b33a52'}),\n Plot.text(rain_per, {x: \"precip_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":890,"value":"plt_r3 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Precipitation Level'\n },\n y: {\n grid: true, \n label: 'Average Response Time (sec)',\n domain: [0,470]\n },\n marks: [\n Plot.barY(rain_resp, {x: \"snow_group\", y: \"response_time\", fill: '#69b3a2'}),\n Plot.text(rain_resp, {x: \"snow_group\", y: \"response_time\", text: (d) => (d.response_time), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"plt_s = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Snow Level',\n },\n y: {grid: true, label: 'Incident Count', domain:[0,30]},\n marks: [\n Plot.barY(snow_incidents, {x: \"snow_group\", y: \"num_entries\", fill: '#65a7ff'}),\n Plot.text(snow_incidents, {x: \"snow_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":659,"value":"plt_s2 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Snow Level'\n },\n y: {\n grid: true, \n label: 'Incident Count per 1000 Occurrence',\n domain:[0,7],\n ticks:10\n },\n marks: [\n Plot.barY(snow_per, {x: \"snow_group\", y: \"num_entries\", fill: '#b33a52'}),\n Plot.text(snow_per, {x: \"snow_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":912,"value":"plt_s3 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Snow Level'\n },\n y: {\n grid: true, \n label: 'Average Response Time (sec)',\n domain: [0,680],\n ticks:10\n },\n marks: [\n Plot.barY(snow_resp, {x: \"snow_group\", y: \"num_entries\", fill: '#69b3a2'}),\n Plot.text(snow_resp, {x: \"snow_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":522,"value":"plt_t = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n domain: temp_incidents.map(d => d.temperature_group),\n label: 'Temperature Level'\n },\n y: {\n grid: true, \n label: 'Incident Count',\n domain: [0,5500],\n ticks:10\n },\n marks: [\n Plot.barY(temp_incidents, {x: \"temperature_group\", y: \"num_entries\", fill: '#65a7ff'}),\n Plot.text(temp_incidents, {x: \"temperature_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"plt_t2 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n domain: temp_per.map(d => d.temperature_group),\n label: 'Temperature Level'\n },\n y: {\n grid: true, \n label: 'Incident Count per 1000 Occurrence',\n domain: [0,3.5]\n },\n marks: [\n Plot.barY(temp_per, {x: \"temperature_group\", y: \"num_entries\", fill: '#b33a52'}),\n Plot.text(temp_per, {x: \"temperature_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":930,"value":"plt_t3 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Temperature Level',\n domain: temp_per.map(d => d.temperature_group),\n },\n y: {\n grid: true, \n label: 'Average Response Time (sec)',\n domain: [0,850],\n ticks:10\n },\n marks: [\n Plot.barY(temp_resp, {x: \"temperature_group\", y: \"num_entries\", fill: '#69b3a2'}),\n Plot.text(temp_resp, {x: \"temperature_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":472,"value":"plt_w = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n domain: wind_incidents.map(d => d.wind_group),\n label: 'Wind Level'\n },\n y: {grid: true, label: 'Incident Count'},\n marks: [\n Plot.barY(wind_incidents, {x: \"wind_group\", y: \"num_entries\", fill: '#65a7ff'}),\n Plot.text(wind_incidents, {x: \"wind_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":498,"value":"plt_w2 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n domain: wind_per.map(d => d.wind_group),\n label: 'Wind Level'\n },\n y: {\n grid: true, \n label: 'Incident Count per 1000 Occurrence',\n domain: [0,3]\n },\n marks: [\n Plot.barY(wind_per, {x: \"wind_group\", y: \"num_entries\", fill: '#b33a52'}),\n Plot.text(wind_per, {x: \"wind_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":941,"value":"plt_w3 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Wind Level',\n domain: wind_per.map(d => d.wind_group),\n },\n y: {\n grid: true, \n label: 'Average Response Time (sec)',\n domain: [0,450],\n ticks:10\n },\n marks: [\n Plot.barY(wind_resp, {x: \"wind_group\", y: \"num_entries\", fill: '#69b3a2'}),\n Plot.text(wind_resp, {x: \"wind_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1020,"value":"#### Traffic","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1022,"value":"plt_as = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Average Speed Level (mph)'\n },\n y: {\n grid: true, \n label: 'Incident Count',\n domain: [0,5000]\n },\n marks: [\n Plot.barY(avg_speed_incidents, {x: \"average_speed_group\", y: \"num_entries\", fill: '#65a7ff'}),\n Plot.text(avg_speed_incidents, {x: \"average_speed_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1023,"value":"plt_as2 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Average Speed Level (mph)'\n },\n y: {\n grid: true, \n label: 'Incident Count per 100000 Records',\n domain: [0,2]\n },\n marks: [\n Plot.barY(avg_speed_per, {x: \"average_speed_group\", y: \"num_entries\", fill: '#b33a52'}),\n Plot.text(avg_speed_per, {x: \"average_speed_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1024,"value":"plt_as3 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Average Speed Level (mph)'\n },\n y: {\n grid: true, \n label: 'Average Response Time (sec)',\n domain: [0,550],\n ticks:10\n },\n marks: [\n Plot.barY(avg_speed_resp, {x: \"average_speed_group\", y: \"num_entries\", fill: '#69b3a2'}),\n Plot.text(avg_speed_resp, {x: \"average_speed_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1043,"value":"plt_sp = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Speed Level When Incident Happened (mph)'\n },\n y: {\n grid: true, \n label: 'Incident Count',\n domain: [0,5000]\n },\n marks: [\n Plot.barY(speed_incidents, {x: \"speed_group\", y: \"num_entries\", fill: '#65a7ff'}),\n Plot.text(speed_incidents, {x: \"speed_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1044,"value":"plt_sp2 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Speed Level When Incident Happened (mph)'\n },\n y: {\n grid: true, \n label: 'Incident Count per 100000 Records',\n domain: [0,2.2]\n },\n marks: [\n Plot.barY(speed_per, {x: \"speed_group\", y: \"num_entries\", fill: '#b33a52'}),\n Plot.text(speed_per, {x: \"speed_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1045,"value":"plt_sp3 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Speed Level When Incident Happened (mph)'\n },\n y: {\n grid: true, \n label: 'Average Response Time (sec)',\n domain: [0,550],\n ticks:10\n },\n marks: [\n Plot.barY(speed_resp, {x: \"speed_group\", y: \"num_entries\", fill: '#69b3a2'}),\n Plot.text(speed_resp, {x: \"speed_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1054,"value":"plt_c = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Congestion Level',\n type: 'band'\n },\n y: {\n grid: true, \n label: 'Incident Count',\n domain: [0,12000],\n ticks: 10\n },\n marks: [\n Plot.barY(cong_incidents, {x: \"congestion_group\", y: \"num_entries\", fill: '#65a7ff'}),\n Plot.text(cong_incidents, {x: \"congestion_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1055,"value":"plt_c2 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Congestion Level',\n type: 'band'\n },\n y: {\n grid: true, \n label: 'Incident Count per 100000 Records',\n domain: [0,0.8]\n },\n marks: [\n Plot.barY(cong_per, {x: \"congestion_group\", y: \"num_entries\", fill: '#b33a52'}),\n Plot.text(cong_per, {x: \"congestion_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1056,"value":"plt_c3 = Plot.plot({\n width: width/2,\n height: 300,\n x: {\n grid: true,\n label: 'Congestion Level',\n type: 'band'\n },\n y: {\n grid: true, \n label: 'Average Response Time (sec)',\n domain: [0,450],\n ticks:10\n },\n marks: [\n Plot.barY(cong_resp, {x: \"congestion_group\", y: \"num_entries\", fill: '#69b3a2'}),\n Plot.text(cong_resp, {x: \"congestion_group\", y: \"num_entries\", text: (d) => (d.num_entries), dy: -6, lineAnchor: \"bottom\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":729,"value":"### Imports and requiring","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"import {secret} from \"@tmcw/secret\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"AWS = require('aws-sdk@2.794.0/dist/aws-sdk-react-native.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"s3 = new auth_AWS.S3({apiVersion: '2006-03-01'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 24:null