28:null 29:["$","title",null,{"children":"Bikeshare in the United States | Brady Law | Observable"}] 2e:Tf95,sources = aq.from([ { system: "Bay Wheels", file: FileAttachment("bay_wheels@1.csv"), location: "San Francisco Bay Area", data_agreement_label: "Bay Wheels License Agreement", data_agreement_url: "https://baywheels-assets.s3.amazonaws.com/data-license-agreement.html", data_url: "https://www.lyft.com/bikes/bay-wheels/system-data", map_defaults: { longitude: -122.4194, latitude: 37.7749, zoom: 12, }, }, { system: "Bixi", file: FileAttachment("bixi@2.csv"), location: "Montréal, CA", data_agreement_label: "Terms and Conditions", data_agreement_url: "https://bixi.com/en/website-terms", data_url: "https://bixi.com/en/open-data", map_defaults: { longitude: -73.5673, latitude: 45.5017, zoom: 11, }, }, { system: "Bluebikes", file: FileAttachment("blue_bikes.csv"), location: "Boston", data_agreement_label: "Bluebikes Data License Agreement", data_agreement_url: "https://www.bluebikes.com/data-license-agreement", data_url: "https://www.bluebikes.com/system-data", map_defaults: { longitude: -71.0942, latitude: 42.3601, zoom: 12, } }, { system: "Capital Bikeshare", file: FileAttachment("capital_bikeshare@1.csv"), location: "Washington D.C.", data_agreement_label: "Capital Bikeshare Data License Agreement", data_agreement_url: "https://www.capitalbikeshare.com/data-license-agreement", data_url: "https://www.capitalbikeshare.com/system-data", map_defaults: { longitude: -77.0369, latitude: 38.9072, zoom: 12, } }, { system: "Citi Bike", file: FileAttachment("citi_bike.csv"), location: "New York", data_agreement_label: "NYCBS Data Use Policy", data_agreement_url: "https://ride.citibikenyc.com/data-sharing-policy", data_url: "https://ride.citibikenyc.com/system-data", map_defaults: { longitude: -73.98, latitude: 40.7357548, zoom: 11, } }, { system: "CoGo", file: FileAttachment("cogo.csv"), location: "Columbus", data_agreement_label: "CoGo Data License Agreement", data_agreement_url: "https://www.cogobikeshare.com/data-license-agreement", data_url: "https://www.cogobikeshare.com/system-data", map_defaults: { longitude: -82.9988, latitude: 39.9612, zoom: 12, } }, { system: "Divvy", file: FileAttachment("divvy.csv"), location: "Chicago", data_agreement_label: "Divvy Data License Agreement", data_agreement_url: "https://www.divvybikes.com/data-license-agreement", data_url: "https://www.divvybikes.com/system-data", map_defaults: { longitude: -87.6298, latitude: 41.8781, zoom: 11, } }, { system: "Indego", file: FileAttachment("indego@1.csv"), location: "Philidelphia", data_agreement_label: "Terms and Conditions", data_agreement_url: "https://www.rideindego.com/terms-and-conditions/", data_url: "https://www.rideindego.com/about/data/", map_defaults: { longitude: -75.1652, latitude: 39.9526, zoom: 12, } }, { system: "Metro Bike Share", file: FileAttachment("metro_bike_share@4.csv"), location: "Los Angeles", data_agreement_label: "Terms and Conditions", data_agreement_url: "https://bikeshare.metro.net/terms-and-conditions/", data_url: "https://bikeshare.metro.net/about/data/", map_defaults: { longitude: -118.2518, latitude: 34.0488, zoom: 12, } }, { system: "Nice Ride", file: FileAttachment("niceride@1.csv"), location: "Minneapolis / St. Paul", data_agreement_label: "Nice Ride Minnesota Data License Agreement", data_agreement_url: "https://assets.niceridemn.com/data-license-agreement.html", data_url: "https://www.niceridemn.com/system-data", map_defaults: { longitude: -93.2650, latitude: 44.9778, zoom: 12, } } ])2f:[{"id":"c6c792c62e21092f30d2ea10bd66e49173e3a38605358b9d571920a4bcd09a34d935253d4701a8a287571149cb0c49bd55b59899c9f690536911188ae873c7e1","href":"https://static.observableusercontent.com/files/c6c792c62e21092f30d2ea10bd66e49173e3a38605358b9d571920a4bcd09a34d935253d4701a8a287571149cb0c49bd55b59899c9f690536911188ae873c7e1","name":"bay_wheels.csv","type":"text/csv","lastModified":1637356467941.347,"size":1565653},{"id":"717609b5100bdc285ddd484c49b5bdb7f5773f4f83040fe6c3b639a08ba22b774872b7ae5da45cbb3c92f19efeb1da1c4fedb5f7b453e192f9c7401afb4196a5","href":"https://static.observableusercontent.com/files/717609b5100bdc285ddd484c49b5bdb7f5773f4f83040fe6c3b639a08ba22b774872b7ae5da45cbb3c92f19efeb1da1c4fedb5f7b453e192f9c7401afb4196a5","name":"citibike.csv","type":"text/csv","lastModified":1637109892197.625,"size":25244163},{"id":"cfffb58b8fb9834e46ca0ba32e89c8b6f14cadb482f1769a77af80fe9c3585166f578249df474cbd5e39b2a6276b9ece8e8e8ab62b9ca1313d20bc431b3f2b58","href":"https://static.observableusercontent.com/files/cfffb58b8fb9834e46ca0ba32e89c8b6f14cadb482f1769a77af80fe9c3585166f578249df474cbd5e39b2a6276b9ece8e8e8ab62b9ca1313d20bc431b3f2b58","name":"cogo.csv","type":"text/csv","lastModified":1637358380593.285,"size":51253},{"id":"a3c3de303ecca5b6b7895925b7706f4d104ecf14344e8ba7a81baabe18a2b37ac570031209bef30d0451b62ada36a1a73443fcbe4f0fe83cb07d7bde9da5a3a4","href":"https://static.observableusercontent.com/files/a3c3de303ecca5b6b7895925b7706f4d104ecf14344e8ba7a81baabe18a2b37ac570031209bef30d0451b62ada36a1a73443fcbe4f0fe83cb07d7bde9da5a3a4","name":"electric_vs_classic.csv","type":"text/csv","lastModified":1637711872027.513,"size":23687},{"id":"af9c50d2360807ff6b4df61332ff9bc78efcfb36fdd405153abdba06737c723d943fdd00b9182cab5d302ff3ce6af36550ef34a9da4da73e8eb82fb0a3aab260","href":"https://static.observableusercontent.com/files/af9c50d2360807ff6b4df61332ff9bc78efcfb36fdd405153abdba06737c723d943fdd00b9182cab5d302ff3ce6af36550ef34a9da4da73e8eb82fb0a3aab260","name":"Divvy 2@2.jpg","type":"image/jpeg","lastModified":1637792249187.467,"size":460060},{"id":"90b770ecc7328b068758a9b663bf0071ea891b57519d38008f6e2255e32e86bf0aea343f414e3c778eff7c56fde6578c901a266ac81fabea62240f914d3c6ab1","href":"https://static.observableusercontent.com/files/90b770ecc7328b068758a9b663bf0071ea891b57519d38008f6e2255e32e86bf0aea343f414e3c778eff7c56fde6578c901a266ac81fabea62240f914d3c6ab1","name":"metro_bike_share@3.csv","type":"text/csv","lastModified":1637969410526.504,"size":199387},{"id":"727e3aea9699cfafd8969add41e728ef9c8358d65bd9f2a377a95f3db130a9f5ca862b7a1f173c1ea8b4d2c1722275ed70f7d022ea8d84a6c03ac69b6948b215","href":"https://static.observableusercontent.com/files/727e3aea9699cfafd8969add41e728ef9c8358d65bd9f2a377a95f3db130a9f5ca862b7a1f173c1ea8b4d2c1722275ed70f7d022ea8d84a6c03ac69b6948b215","name":"indego@1.csv","type":"text/csv","lastModified":1637968287674.449,"size":717978},{"id":"5cd2fc038052e4a0f84ef6143e21e5b499b3161d29a17aedfe94dbd9547a317a05e32e9a21fde1f244ffb343ef43d48e45b17291bdeac109a955fc121ade4fe3","href":"https://static.observableusercontent.com/files/5cd2fc038052e4a0f84ef6143e21e5b499b3161d29a17aedfe94dbd9547a317a05e32e9a21fde1f244ffb343ef43d48e45b17291bdeac109a955fc121ade4fe3","name":"bay_wheels@1.csv","type":"text/csv","lastModified":1648938467064.41,"size":1689113},{"id":"ba6540c23f92e2ddf7f0e9027767c520e5dd9296b95373d772f5202443fcd1a7b126476d0389bb92fef2312dc8930d18bc13e9caba09415aad86ad4ce57ebd65","href":"https://static.observableusercontent.com/files/ba6540c23f92e2ddf7f0e9027767c520e5dd9296b95373d772f5202443fcd1a7b126476d0389bb92fef2312dc8930d18bc13e9caba09415aad86ad4ce57ebd65","name":"capital_bikeshare.csv","type":"text/csv","lastModified":1637358127349.312,"size":4062876},{"id":"e426940d5d94cb5af57d918bb96b80632feaff7148e13dd48ff5e062b8578d9e2d0f8bcbd38b96a082c10f9ae303858aa22f371afb97ec2330770c31719389cb","href":"https://static.observableusercontent.com/files/e426940d5d94cb5af57d918bb96b80632feaff7148e13dd48ff5e062b8578d9e2d0f8bcbd38b96a082c10f9ae303858aa22f371afb97ec2330770c31719389cb","name":"divvy.csv","type":"text/csv","lastModified":1637358036429.099,"size":4457804},{"id":"e7a93d64b195afafb254eec1d05bfffbbe206edf8ec3728b2a4a2bea98b7b063b8f89961f457918069475c73b7d7310b1ef740c1f7c316c91d918afd3955676d","href":"https://static.observableusercontent.com/files/e7a93d64b195afafb254eec1d05bfffbbe206edf8ec3728b2a4a2bea98b7b063b8f89961f457918069475c73b7d7310b1ef740c1f7c316c91d918afd3955676d","name":"blue_bikes.csv","type":"text/csv","lastModified":1637631211299.223,"size":2497990},{"id":"1bd33ef683535559257ab5940a2a46541b1fc264a18d9e3f03ce790acb0150cefe743a89651c9933865e6ed7d20e4668516af3b7797dd7da68149d93e5e42d7c","href":"https://static.observableusercontent.com/files/1bd33ef683535559257ab5940a2a46541b1fc264a18d9e3f03ce790acb0150cefe743a89651c9933865e6ed7d20e4668516af3b7797dd7da68149d93e5e42d7c","name":"niceride@1.csv","type":"text/csv","lastModified":1637695500155.958,"size":546220},{"id":"15e97b9bcfd2f281a3f9bb25ce199a32e372b9070d3e8ac9bb5117d765ef35fceb6ab6b0673f5bb2fc13d1b641b6afbf3b8ea48f317838183b7f059ad4007e47","href":"https://static.observableusercontent.com/files/15e97b9bcfd2f281a3f9bb25ce199a32e372b9070d3e8ac9bb5117d765ef35fceb6ab6b0673f5bb2fc13d1b641b6afbf3b8ea48f317838183b7f059ad4007e47","name":"20210601_191236@1.jpg","type":"image/jpeg","lastModified":1637802909876.838,"size":357162},{"id":"379a1e5bcf0f84ef19f7eaff0f72f453df5f741c273816f5ca897f44933268122c3b5fd7d934e793883ef6137fc8bb93b9300425a670d28a79305536984eea06","href":"https://static.observableusercontent.com/files/379a1e5bcf0f84ef19f7eaff0f72f453df5f741c273816f5ca897f44933268122c3b5fd7d934e793883ef6137fc8bb93b9300425a670d28a79305536984eea06","name":"bixi@1.csv","type":"text/csv","lastModified":1637972920451.398,"size":5733744},{"id":"42086d34bb796510606f6bad6c1cb6352b7102779e53914f5ada9c91d39487fd4083276f8cd65a55a64ac9abc21bb546aa25f028a39d0ca8bca0110dccbe664b","href":"https://static.observableusercontent.com/files/42086d34bb796510606f6bad6c1cb6352b7102779e53914f5ada9c91d39487fd4083276f8cd65a55a64ac9abc21bb546aa25f028a39d0ca8bca0110dccbe664b","name":"totals@1.csv","type":"text/csv","lastModified":1637978523663.078,"size":158},{"id":"b7b2b2368e29af2d1458df62dffa0e1464bdc552e633247137ff5a976046ab009a6525e3c14ea6ad64d44007ce5b5aee459c8416af83a664272baa30fab0ea10","href":"https://static.observableusercontent.com/files/b7b2b2368e29af2d1458df62dffa0e1464bdc552e633247137ff5a976046ab009a6525e3c14ea6ad64d44007ce5b5aee459c8416af83a664272baa30fab0ea10","name":"citi_bike.csv","type":"text/csv","lastModified":1648938682046.565,"size":26474693},{"id":"398619f3fde57f1e3d7ae7e5bf37de209441eedff5ae84592c3d8dd1b12501c49347762871fe1fa7bfb0d88e870ba4130126507356678b8081f0cfd1b1afee77","href":"https://static.observableusercontent.com/files/398619f3fde57f1e3d7ae7e5bf37de209441eedff5ae84592c3d8dd1b12501c49347762871fe1fa7bfb0d88e870ba4130126507356678b8081f0cfd1b1afee77","name":"metro_bike_share@4.csv","type":"text/csv","lastModified":1648938399837.521,"size":209427},{"id":"379a1e5bcf0f84ef19f7eaff0f72f453df5f741c273816f5ca897f44933268122c3b5fd7d934e793883ef6137fc8bb93b9300425a670d28a79305536984eea06","href":"https://static.observableusercontent.com/files/379a1e5bcf0f84ef19f7eaff0f72f453df5f741c273816f5ca897f44933268122c3b5fd7d934e793883ef6137fc8bb93b9300425a670d28a79305536984eea06","name":"bixi@2.csv","type":"text/csv","lastModified":1648938354293.85,"size":5733744},{"id":"cef56cf836f59d19d7b74b67f7f73edb6336d9380f66f0080da32894166fa59973a385976ab29d21cc08994d7fdae92ada0495c9a22ea176e0ef843cd175d0f3","href":"https://static.observableusercontent.com/files/cef56cf836f59d19d7b74b67f7f73edb6336d9380f66f0080da32894166fa59973a385976ab29d21cc08994d7fdae92ada0495c9a22ea176e0ef843cd175d0f3","name":"capital_bikeshare@1.csv","type":"text/csv","lastModified":1648938051362.911,"size":4206712}] 2c:{"id":"e8fdc75391faab6f","slug":"bikeshare","title":"Bikeshare in the United States","thumbnail":"7dba345849fdc55d868bad554a03def727847f084bc51386fe15078032587e1d","access_level":"public","create_time":"$D2021-11-17T00:31:09.733Z","update_time":"$D2022-04-02T22:31:19.544Z","view_time":null,"first_public_time":"$D2021-11-27T03:13:17.386Z","has_unpublished_edits":null,"fork":false,"stars":6,"starred":false,"owner":{"type":"team","id":"f64dd716a3bbbad7","login":"brady","name":"Brady Law","avatar_url":"https://avatars-next.observableusercontent.com/101597cb706624aedd0b13a4e66abe96f5cd8a09fa2d710e393c96266e8c74db","tier":"starter_2024"},"version":2755,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"475de7f49262bc1b","login":"brady","name":"Brady Law","avatar_url":"https://avatars-next.observableusercontent.com/101597cb706624aedd0b13a4e66abe96f5cd8a09fa2d710e393c96266e8c74db","tier":null}],"members":[{"type":"individual","id":"475de7f49262bc1b","login":"brady","name":"Brady Law","avatar_url":"https://avatars-next.observableusercontent.com/101597cb706624aedd0b13a4e66abe96f5cd8a09fa2d710e393c96266e8c74db","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":7,"collection":null,"type":"notebook","body":{"title":"Bikeshare in the United States","cells":[{"id":0,"value":"# Bikeshare in the United States\n\nA collection of visualizations of public docked bikeshare systems. This page is best viewed in Google Chrome on a desktop **(Safari is currently broken)**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1836,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":911,"value":"viewof start_or_end_locations = Inputs.radio([\"start_location\", \"end_location\"], {label: \"Select:\", value: \"start_location\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":902,"value":"viewof start_location_bucket_meters = Inputs.range([5, 1000], {step: 5, label: \"Bucket size (meters):\", value: 25})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":815,"value":"## Most popular stations\n\nOften the most popular stations are at public transit hubs, like Caltrain and BART stations in SF Bay area, or Grand Central Terminal (Pershing Square North) in NYC.\n\n_**Note:** Stations are occasionally renamed, which can impact rankings across longer time spans._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":821,"value":"most_popular_stations\n .select(\"start_station_name\", \"count\")\n .rename({start_station_name: 'Start station', count: 'Trips (thousands)'})\n .view({limit: 50})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1468,"value":"---\n\n## ${system.system} stations over time","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1567,"value":"**${format_num(most_popular_stations.params({station_min_year}).filter(d => op.year(d.first_ride_at) <= station_min_year).numRows())}** stations were active on or before **${station_min_year}**. Newly active stations appear as blue, existing shown in white, and new stations in the year are shown in blue.\n\nMany systems have massively expanded their footprint since launch. 📈","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1545,"value":"viewof station_min_year = {\n const year = new Date().getFullYear()\n return Inputs.range([2009, year], {step: 1, label: \"Select year:\", value: year - 2})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1471,"value":"station_age_container = html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":876,"value":"## Popular new stations\n\nIn the past **${new_station_months}** month(s), these stations have the most trips. Before that time, there were no sampled trips (likely indicating a new station).\n\n_**Warning:** Lower trip counts are highly subject to sampling error._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":893,"value":"viewof new_station_months = Inputs.range([0, 36], {step: 1, label: \"Months:\", value: 6})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":942,"value":"{\n const approxMsInMonths = 1000 * 60 * 60 * 25 * 30\n return most_popular_stations\n .params({approxMsInMonths, max_date, new_station_months})\n .filter(d => op.timestamp(d.first_ride_at) >= op.timestamp(max_date) - approxMsInMonths * new_station_months)\n .derive({first_ride_at: d => op.substring(d.first_ride_at, 0, 16)})\n .select(\"start_station_name\", \"count\", \"first_ride_at\")\n .rename({start_station_name: 'Start station', count: 'Trips (thousands)', first_ride_at: 'First trip at'})\n .view({limit: 50})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":245,"value":"---\n\n## ${system.system} trips per quarter of year (thousands)\n\nIn systems with cold winters like Divvy (Chicago), seasonality has a significant impact on ridership. Nice Ride (Minneapolis) shuts down completely for winter. ☃️","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1241,"value":"_**Note:** Most recent quarter of data may be incomplete._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2128,"value":"swatches({color: d3.scaleOrdinal([\"Jan - Mar\", \"Apr - Jun\", \"Jul - Sep\", \"Oct - Dec\"],[\"#bab0ab\", \"#59a14f\", \"#76b7b2\", \"#f28e2c\"])})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":252,"value":"Plot.plot({\n grid: true,\n marginBottom: 80,\n color: {\n domain: [0, 1, 2, 3],\n range: [\"#bab0ab\", \"#59a14f\", \"#76b7b2\", \"#f28e2c\"]\n },\n x: {\n tickRotate: -90,\n label: null\n },\n y: {\n label: \"trips (1k)\",\n tickPadding: 1\n },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(trips_per_quarter, {x: \"time_bucket\", y: \"count\", fill: d => d.time_bucket.getUTCMonth() / 3})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"## ${system.system} year-over-year % change in trips\n\nNearly all systems had a big drop in ridership starting in the first half of 2020 when the pandemic hit the US.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"Plot.plot({\n grid: true,\n marginBottom: 80,\n x: {\n tickRotate: -90,\n label: null\n },\n y: {\n percent: true\n },\n color: {\n type: \"linear\",\n domain: [-1, 1],\n interpolate: t => `hsl(${t >= .5 ? 140 : 355}, ${Math.round(Math.abs(2 * (t - 0.5)) * 40) + 30}%, 55%)`\n },\n marks: [\n Plot.ruleY([-1, 0, 1]),\n Plot.barY(trips_year_over_year, {x: \"time_bucket\", y: \"yoy\", fill: \"yoy\"}),\n Plot.text(trips_year_over_year, {\n x: \"time_bucket\",\n y: \"yoy\",\n text: d => `${d.yoy > 0 ? '+' : ''}${op.round(d.yoy * 100)}%`,\n dy: -5\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"---\n\n## ${system.system} trips by member status (thousands)\n\nMany systems have shown a rise in casual ridership (non-member trips) in recent years.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1246,"value":"_**Note:** Most recent quarter of data may be incomplete._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2010,"value":"swatches({color: trips_per_quarter_by_status_color_scale})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"Plot.plot({\n grid: true,\n marginBottom: 80,\n x: {\n tickRotate: -90,\n label: null\n },\n y: {\n label: \"trips (1k)\"\n },\n color: {\n domain: trips_per_quarter_by_status_color_scale.domain(),\n range: trips_per_quarter_by_status_color_scale.range()\n },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(trips_per_quarter_by_status, {y: \"count\", x: \"time_bucket\", fill: \"user_type\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":834,"value":"## ${system.system} trips by bike type (thousands)\n\nE-bike trips generally cost more, but are faster and require less effort than a traditional bikeshare bikes. ⚡️","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1253,"value":"_**Note:** Most recent quarter of data may be incomplete. Not all systems clearly indicate the bike type used (e.g. Citi Bike)._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2003,"value":"swatches({ color: trips_per_quarter_by_rideable_type_color_scale })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":840,"value":"Plot.plot({\n grid: true,\n marginBottom: 80,\n x: {\n tickRotate: -90,\n label: null\n },\n y: {\n label: \"trips (1k)\"\n },\n color: {\n domain: trips_per_quarter_by_rideable_type_color_scale.domain(),\n range: trips_per_quarter_by_rideable_type_color_scale.range()\n },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(trips_per_quarter_by_rideable_type, {y: \"count\", x: \"time_bucket\", fill:\"rideable_type\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1402,"value":"---\n\n# A closer look: Bay Wheels e-bikes ⚡️\n\nHow do e-bikes perform as compared to classic bikes? For popular routes with 100+ data points for both bike types, we can inspect median travel times and compare durations of a typical trip.\n\nWe see that for the majority of routes, the median **travel time is 10-30% faster on an e-bike.**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1413,"value":"{\n const data = ebikePerfData.slice(0, 25)\n return Plot.plot({\n marginLeft: 350,\n grid: true,\n x: {\n axis: \"top\",\n label: \"← % change in duration (ebike vs classic) →\",\n labelAnchor: \"center\",\n percent: true\n },\n y: {\n label: null,\n domain: data.array(\"route\")\n },\n marks: [\n Plot.barX(data, {\n y: \"route\",\n x: d => -1 + d.speed_ratio\n }),\n Plot.ruleX([0]),\n Plot.ruleX([-1])\n ]\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1982,"value":"---\n\n**Thanks for reading!**\n\nInterested in digging in more? Fork this notebook and discover new insights.\n\nThis post leverages the [opendata](https://github.com/babldev/opendata) python library for bulk download and processing of the public data.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1991,"value":"shareTweet(document.baseURI, {\n buttonText: \"Share this notebook\",\n text: \"An interactive look at bikeshare in the US\",\n hashtags: \"observablehq,bikeshare,opendata\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2353,"value":"html`

500 ? 500 : width}px;\"/>`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":997,"value":"---\n\n## Data filters (optional)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":727,"value":"viewof start_date = Inputs.date({label: \"Start date:\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":737,"value":"viewof end_date = Inputs.date({label: \"End date:\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":229,"value":"---\n\n## Workbook\n\n### Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"import { swatches } from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1989,"value":"import {shareTweet} from \"@pierreleripoll/share-on-twitter-button\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2555,"value":"import {update} from \"@uwdata/arquero-row-manipulation\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":555,"value":"deckgl = require('deck.gl@~5.2.0/deckgl.min.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":593,"value":"mapboxgl = require('mapbox-gl@~2.6.1/dist/mapbox-gl.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":404,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":524,"value":"// system = sources.objects()[0]\nsystem = {\n return sources\n .params({choice: system_choice})\n .filter((d, $) => d.system == $.choice).objects()[0]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"data = {\n const text = await system.file.text();\n const parseTime = d3.timeParse(\"%Y-%m-%d %H:%M:%S.%L\");\n const parseTimeLong = d3.timeParse(\"%Y-%m-%d %H:%M:%S\");\n return aq\n .from(d3.csvParse(text, (row) => {\n row.started_at = parseTime(row.started_at) || parseTimeLong(row.started_at);\n row.ended_at = parseTime(row.ended_at) || parseTimeLong(row.ended_at);\n return row;\n }))\n .params({start_date: start_date, end_date: end_date})\n .filter((t, $) => (!$.start_date || t.started_at >= $.start_date) && (!$.end_date || t.started_at <= $.end_date));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":241,"value":"trips_per_year = {\n return data\n .derive({time_bucket: trip => op.year(trip.started_at)})\n .groupby('time_bucket').count({as: 'count'})\n .orderby('time_bucket')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"trips_per_quarter = fillEmptyQuarterBins(data\n .derive({time_bucket: trip => op.utcdatetime(op.year(trip.started_at), Math.floor(op.month(trip.started_at) / 3) * 3)}, \"count\", \"0\")\n .groupby('time_bucket').count({as: 'count'})\n .orderby('time_bucket'), \"count\", 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"trips_year_over_year = trips_per_quarter\n .derive({yoy: row => (row.count - op.lag(row.count, 4, 0)) / op.lag(row.count, 4, 0)})\n .derive({yoy: row => op.is_finite(row.yoy) ? row.yoy : 0})\n .slice(5, -1) // lag is of size 4, we add 1 in case first bucket is not an entire time window","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"trips_per_quarter_by_status = data\n .derive({\n time_bucket: trip => op.utcdatetime(\n op.year(trip.started_at), Math.floor(op.month(trip.started_at) / 3) * 3),\n user_type: trip => trip.user_type ? trip.user_type : \"n/a\"\n })\n .groupby('time_bucket', 'user_type').count({as: 'count'})\n .orderby('time_bucket', 'user_type')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":322,"value":"trips_per_quarter_by_status_color_scale = d3.scaleOrdinal(\n [...new Set(trips_per_quarter_by_status.array(\"user_type\"))],\n d3.schemeTableau10\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":845,"value":"trips_per_quarter_by_rideable_type = data\n .derive({\n time_bucket: trip => op.utcdatetime(\n op.year(trip.started_at), Math.floor(op.month(trip.started_at) / 3) * 3),\n rideable_type: trip => trip.rideable_type ? trip.rideable_type : \"n/a\"\n })\n .groupby('time_bucket', 'rideable_type').count({as: 'count'})\n .orderby('time_bucket', 'rideable_type')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":849,"value":"trips_per_quarter_by_rideable_type_color_scale = d3.scaleOrdinal(\n [...new Set(trips_per_quarter_by_rideable_type.array(\"rideable_type\"))],\n d3.schemeTableau10\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":953,"value":"most_popular_stations = data\n .filter(d => d.start_station_name)\n .groupby('start_station_name')\n .rollup({\n 'count': op.count(),\n 'first_ride_at': d => op.min(d.started_at),\n 'lat': d => op.max(d.start_lat),\n 'lng': d => op.max(d.start_lng)\n })\n .orderby(aq.desc('count'))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":960,"value":"max_date = end_date ? end_date : new Date()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1337,"value":"ebikePerfData = {\n const text = await FileAttachment(\"electric_vs_classic.csv\").text()\n return aq.from(d3.csvParse(text))\n .derive({\n \"speed_ratio\": d => d[\"electric_bike_duration\"] / d[\"classic_bike_duration\"],\n \"route\": d => `${d.start_station_name} → ${d.end_station_name}`\n })\n .orderby(aq.desc(\"electric_bike_count\"), aq.desc(\"classic_bike_count\"))\n .select(\"route\", \"electric_bike_count\", \"classic_bike_count\", \"electric_bike_duration\", \"classic_bike_duration\", \"speed_ratio\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1699,"value":"totals = {\n const text = await FileAttachment(\"totals@1.csv\").text()\n return aq.from(d3.csvParse(text))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2302,"value":"system_colors = d3.scaleOrdinal(\n sources.array(\"system\"),\n d3.schemeTableau10\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2437,"value":"format_num = d3.format(\",\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2507,"value":"fillEmptyQuarterBins = function(d, column, default_value) {\n const range = d.rollup({ min: op.min('time_bucket'), max: op.max('time_bucket') }).object()\n const minYear = range.min.getUTCFullYear();\n const maxYear = range.max.getUTCFullYear();\n const minMonth = range.min.getUTCMonth();\n const maxMonth = range.max.getUTCMonth();\n var result = []\n for (var year = range.min.getUTCFullYear(); year <= range.max.getUTCFullYear(); year++) {\n var month = (year == minYear) ? minMonth : 0\n const curEndMonth = (year == maxYear) ? maxMonth : 11\n for (month; month < curEndMonth; month += 3) {\n result.push({time_bucket: new Date(Date.UTC(year, month, 1)), [column]: default_value})\n }\n }\n const defaultTable = aq.from(result)\n return defaultTable.join_left(d, \"time_bucket\", update(defaultTable, d)).orderby(\"time_bucket\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":587,"value":"### Visualizations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":623,"value":"map = {\n return new deckgl.DeckGL({\n container,\n map: mapboxgl,\n mapboxAccessToken: '',\n // This token is for demo-purpose only and rotated regularly. Get your token at https://www.mapbox.com\n mapboxApiAccessToken: 'pk.eyJ1IjoiYnJhZHltYXBzMTIzIiwiYSI6ImNrdzc1bnp0c2Jtd3Uyb3FwdWpwb2ltMXgifQ.DoBCUXOl9uG4xuWl-ZLpjg',\n mapStyle: 'mapbox://styles/mapbox/dark-v9',\n longitude: system.map_defaults.longitude,\n latitude: system.map_defaults.latitude,\n zoom: system.map_defaults.zoom,\n minZoom: 5,\n maxZoom: 14,\n pitch: 35,\n touchRotate: true\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":668,"value":"html `\n(Mapbox Stylesheet)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":682,"value":"colorRange = {\n return [\n [1, 152, 189],\n [73, 227, 206],\n [216, 254, 181],\n [254, 237, 177],\n [254, 173, 84],\n [209, 55, 78]\n ];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":776,"value":"{\n system\n map.setProps({\n initialViewState: {\n longitude: system.map_defaults.longitude,\n latitude: system.map_defaults.latitude,\n zoom: system.map_defaults.zoom\n }\n })\n return html `(System select observer)`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":680,"value":"lightSettings = {\n return {\n lightsPosition: [-0.144528, 49.739968, 8000, -3.807751, 54.104682, 8000],\n ambientRatio: 0.6,\n diffuseRatio: 0.7,\n specularRatio: 0.3,\n lightsStrength: [0.75, 0.0, 0.75, 0.0],\n numberOfLights: 2\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":678,"value":"{\n const locationMap = {\n start_location: {\n lat: \"start_lat\",\n lng: \"start_lng\"\n },\n end_location: {\n lat: \"end_lat\",\n lng: \"end_lng\"\n }\n };\n const locationMapChoice = locationMap[start_or_end_locations];\n\n const hexagonLayer = new deckgl.HexagonLayer({\n id: 'heatmap',\n colorRange,\n data: data.params({locationMapChoice}).filter((d, $) => d[$.locationMapChoice.lat] && d[$.locationMapChoice.lng]).objects(),\n elevationRange: [0, 100],\n elevationScale: 50,\n extruded: true,\n getPosition: d => [d[locationMapChoice.lng], d[locationMapChoice.lat]],\n material: true,\n opacity: 0.2,\n radius: start_location_bucket_meters,\n upperPercentile: 100,\n lightSettings\n });\n\n map.setProps({layers: [hexagonLayer]});\n \n return hexagonLayer;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1479,"value":"stations_age_map = {\n return new deckgl.DeckGL({\n container: station_age_container,\n map: mapboxgl,\n mapboxAccessToken: '',\n // This token is for demo-purpose only and rotated regularly. Get your token at https://www.mapbox.com\n mapboxApiAccessToken: 'pk.eyJ1IjoiYnJhZHltYXBzMTIzIiwiYSI6ImNrdzc1bnp0c2Jtd3Uyb3FwdWpwb2ltMXgifQ.DoBCUXOl9uG4xuWl-ZLpjg',\n mapStyle: 'mapbox://styles/mapbox/dark-v9',\n longitude: system.map_defaults.longitude,\n latitude: system.map_defaults.latitude,\n zoom: system.map_defaults.zoom - 1,\n minZoom: 5,\n maxZoom: 14\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1489,"value":"{\n const colorStation = function(row) {\n const firstRideAtYear = (new Date(row.first_ride_at)).getFullYear();\n if (firstRideAtYear == station_min_year) {\n return [1, 152, 189, 200]\n } else if (firstRideAtYear <= station_min_year) {\n return [255, 255, 255, 200]\n } else {\n return [0, 0, 0, 200]\n }\n }\n const layer = new deckgl.ScatterplotLayer({\n data: most_popular_stations.objects(),\n pickable: true,\n opacity: 0.8,\n stroked: true,\n filled: true,\n radiusScale: 6,\n radiusMinPixels: 1,\n radiusMaxPixels: 100,\n lineWidthMinPixels: 1,\n getPosition: d => [d.lng, d.lat],\n getRadius: d => 10,\n getColor: colorStation,\n getFillColor: d => [127, 255, 255],\n getLineColor: d => [255, 127, 255]\n });\n\n stations_age_map.setProps({layers: [layer]});\n \n return layer;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2d:"$2c:body"