31:[{"id":"e24677ed263cf6b327af93ce08714053dc9b1c957dd9805ffaf6e49e54a572dbba321187f63901d8dfb79391234bd684798c89181bacba690bba8d1014ec2f6f","href":"https://static.observableusercontent.com/files/e24677ed263cf6b327af93ce08714053dc9b1c957dd9805ffaf6e49e54a572dbba321187f63901d8dfb79391234bd684798c89181bacba690bba8d1014ec2f6f","name":"Bicycle Facility Costs - Sheet7.csv","type":"text/csv","lastModified":1587888773413.007,"size":324}] 2f:{"title":"Bike Facility Costs","cells":[{"id":0,"value":"md`# Bike Facility Costs\n\nBiking facilities are often completed as part of repaving or road reconstruction projects, which makes it difficult to tease out the estimated cost of installation. These are estimates compiled from recent projects (2016) in the Portland, Oregon region ¹.\n\nTo compare the costs, we use the estimated cost of a building an additional lane-mile of urban freeway ².\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"md`## Table of Costs\n\n| Type | Category | $/Foot | $/Mile |\n|---|---|\n${costs.map(c => `|${c.Type}|${c.Category}|${c.Cost_Foot}|${c.Cost_Mile}|\\n`)}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"viewof facility = select({ title: \"Facility\", options: costs.map(c => c.Type) })","pinned":false,"hidden":false,"mode":"ojs"},{"id":130,"value":"viewof budget = text({ title: \"Budget\", placeholder: \"e.g. $500,000\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":148,"value":"html`

Miles of ${pluralize(\n facility\n)}: ${total_miles}

Cost per Mile: ${cost_mile_currency}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":243,"value":"html`

Lane-Miles of Urban Freeway: ${total_freeway_miles} miles

Cost per Mile: ${cost_mile_currency_freeway}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":82,"value":"md`# Appendix`","pinned":false,"hidden":false,"mode":"ojs"},{"id":177,"value":"// Citations\nmd` ### Citations \n1. Weigand L., McNeil N., Dill J. \"Cost Analysis of Bicycle Facilities: Cases from cities in the Portland, OR region,\" Active Living Research. Accessed June 3, 2020. https://activelivingresearch.org/sites/activelivingresearch.org/files/Dill_Bicycle_Facility_Cost_June2013.pdf.\n2. Geller, R. \"How Portland Benefits from Bicycle Transportation.\" Accessed June 3, 2020. http://www.portlandonline.com/transportation/index.cfm?c=34816&a=371038`","pinned":false,"hidden":false,"mode":"ojs"},{"id":193,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3,"value":"costs = d3.csvParse(\n await FileAttachment(\"Bicycle Facility Costs - Sheet7.csv\").text()\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"md`## Formatters`","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"cost_mile_currency = _.filter(costs, { Type: facility })[0]['Cost_Mile']","pinned":false,"hidden":false,"mode":"ojs"},{"id":232,"value":"cost_mile_freeway = currencyToNum(cost_mile_currency_freeway)","pinned":false,"hidden":false,"mode":"ojs"},{"id":247,"value":"cost_mile_currency_freeway = \"$60,000,000\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":48,"value":"cost_mile = currencyToNum(cost_mile_currency)","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"total_miles = _.round(currencyToNum(budget) / cost_mile)","pinned":false,"hidden":false,"mode":"ojs"},{"id":240,"value":"total_freeway_miles = (currencyToNum(budget) / cost_mile_freeway).toFixed(2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"formatter = new Intl.NumberFormat('en-US', {\n style: 'currency',\n currency: 'USD'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":136,"value":"function currencyToNum(curr) {\n return +_.chain(curr)\n .replace(/\\$/, '')\n .replace(/,/g, '')\n .value();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"function pluralize(str) {\n return _.endsWith(str, 's') ? str : str + 's';\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":94,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"import { text, slider, select, radio } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"d3 = require('d3-dsv')","pinned":false,"hidden":false,"mode":"ojs"},{"id":24,"value":"_ = require('lodash')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}