25:["$","title",null,{"children":"State of Bikeshare (as of Aug 2023) | Brady Law | Observable"}] 4c:Tdeb,sources = aq.from([ { system: "Bay Wheels", file: FileAttachment("bay_wheels@2.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@3.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("bluebikes.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.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@1.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@1.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@1.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.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.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, } } ])4d:[{"id":"4e5c822c2907d84b6ba28949c776d57a0f7fa68e5b55729fa00ad74e90fc9005c3cbe7476ca1ada8dcb5d5f526b6814c0f4040fa5cecbe4729c35710cfc377eb","href":"https://static.observableusercontent.com/files/4e5c822c2907d84b6ba28949c776d57a0f7fa68e5b55729fa00ad74e90fc9005c3cbe7476ca1ada8dcb5d5f526b6814c0f4040fa5cecbe4729c35710cfc377eb","name":"capital_bikeshare.csv","type":"text/csv","lastModified":1690996102762.567,"size":5223276},{"id":"3cc9cf5ac88bc3e50bb80c083b8aaefcc3d49304375e9ea195f3f28f4336edf6dd90d7f7a095db0995c2494825fb0d1726c914dee477212b3f43a449c35829c0","href":"https://static.observableusercontent.com/files/3cc9cf5ac88bc3e50bb80c083b8aaefcc3d49304375e9ea195f3f28f4336edf6dd90d7f7a095db0995c2494825fb0d1726c914dee477212b3f43a449c35829c0","name":"cogo@1.csv","type":"text/csv","lastModified":1690996139650.864,"size":63785},{"id":"72ecd19b6cfd967356c74abb14fb6fed9a763ad7ba4cc22a12eadd74e040fae803c5224c74cd2caa546db4ee1a6c17c533678189d0e6a6ae56b9dba0452c5e02","href":"https://static.observableusercontent.com/files/72ecd19b6cfd967356c74abb14fb6fed9a763ad7ba4cc22a12eadd74e040fae803c5224c74cd2caa546db4ee1a6c17c533678189d0e6a6ae56b9dba0452c5e02","name":"indego.csv","type":"text/csv","lastModified":1690996158216.428,"size":980510},{"id":"a3c3de303ecca5b6b7895925b7706f4d104ecf14344e8ba7a81baabe18a2b37ac570031209bef30d0451b62ada36a1a73443fcbe4f0fe83cb07d7bde9da5a3a4","href":"https://static.observableusercontent.com/files/a3c3de303ecca5b6b7895925b7706f4d104ecf14344e8ba7a81baabe18a2b37ac570031209bef30d0451b62ada36a1a73443fcbe4f0fe83cb07d7bde9da5a3a4","name":"electric_vs_classic.csv","type":"text/csv","lastModified":1690995944757.451,"size":23687},{"id":"af9c50d2360807ff6b4df61332ff9bc78efcfb36fdd405153abdba06737c723d943fdd00b9182cab5d302ff3ce6af36550ef34a9da4da73e8eb82fb0a3aab260","href":"https://static.observableusercontent.com/files/af9c50d2360807ff6b4df61332ff9bc78efcfb36fdd405153abdba06737c723d943fdd00b9182cab5d302ff3ce6af36550ef34a9da4da73e8eb82fb0a3aab260","name":"Divvy 2@2.jpg","type":"image/jpeg","lastModified":1690995944757.451,"size":460060},{"id":"15e97b9bcfd2f281a3f9bb25ce199a32e372b9070d3e8ac9bb5117d765ef35fceb6ab6b0673f5bb2fc13d1b641b6afbf3b8ea48f317838183b7f059ad4007e47","href":"https://static.observableusercontent.com/files/15e97b9bcfd2f281a3f9bb25ce199a32e372b9070d3e8ac9bb5117d765ef35fceb6ab6b0673f5bb2fc13d1b641b6afbf3b8ea48f317838183b7f059ad4007e47","name":"20210601_191236@1.jpg","type":"image/jpeg","lastModified":1690995944757.451,"size":357162},{"id":"701833c72f4f304ea61927c21ab5259d82f1d4674ca4d5e454723bc0c7f7018fd01cff3ab4eb630b82c539c775674226e35da4694dfe5df0b5fcc12968ad7886","href":"https://static.observableusercontent.com/files/701833c72f4f304ea61927c21ab5259d82f1d4674ca4d5e454723bc0c7f7018fd01cff3ab4eb630b82c539c775674226e35da4694dfe5df0b5fcc12968ad7886","name":"totals.csv","type":"text/csv","lastModified":1690998856595.899,"size":154},{"id":"9626801e0807cbd1f6faf12a2cf5735386513e0ad49580bc3e1cf815b5aa08f21f89c0b8b8a3d0c26cde71b863e410e0ada2c0062dfa5fe434d1799538f21677","href":"https://static.observableusercontent.com/files/9626801e0807cbd1f6faf12a2cf5735386513e0ad49580bc3e1cf815b5aa08f21f89c0b8b8a3d0c26cde71b863e410e0ada2c0062dfa5fe434d1799538f21677","name":"bixi.csv","type":"text/csv","lastModified":1690996088045.41,"size":5899669},{"id":"b4aa8eaa2c1c5c65a9a0b746cba28ca5b2a1f156165a6da35c68f047ea4d29ea5ffe47c5c3c06a79e41f22dd52fe1eff5399cddc6fa537ed8088cf599a5ba028","href":"https://static.observableusercontent.com/files/b4aa8eaa2c1c5c65a9a0b746cba28ca5b2a1f156165a6da35c68f047ea4d29ea5ffe47c5c3c06a79e41f22dd52fe1eff5399cddc6fa537ed8088cf599a5ba028","name":"bluebikes.csv","type":"text/csv","lastModified":1690996096170.767,"size":3629943},{"id":"a1a50e2191355b7c27680c9a53373720d9420f261c00b0edc762210063f3cab6dd0cf02a0fc23c00aee6a694f33fd471bd13fe49ee3a8fea4c7753254c5975b1","href":"https://static.observableusercontent.com/files/a1a50e2191355b7c27680c9a53373720d9420f261c00b0edc762210063f3cab6dd0cf02a0fc23c00aee6a694f33fd471bd13fe49ee3a8fea4c7753254c5975b1","name":"divvy@1.csv","type":"text/csv","lastModified":1690996147098.823,"size":6103734},{"id":"0ffd38345f5c3bc0802cfb9d3c6fdaa9da58729d01f3f29216c5b48e8cf567005d11910f2aa3e0d376f1eab92635947e424c4b70dd9754201cbb58619336c34b","href":"https://static.observableusercontent.com/files/0ffd38345f5c3bc0802cfb9d3c6fdaa9da58729d01f3f29216c5b48e8cf567005d11910f2aa3e0d376f1eab92635947e424c4b70dd9754201cbb58619336c34b","name":"metro_bike_share.csv","type":"text/csv","lastModified":1690996165480.148,"size":284367},{"id":"7a409fca68a1bf1b95fc1b8b5a820c33d54787a967199016486150edd0024c16e685b969d532d7c6ea79af276dea634baec8b6b7e970d0ff205383a6a66ed3fe","href":"https://static.observableusercontent.com/files/7a409fca68a1bf1b95fc1b8b5a820c33d54787a967199016486150edd0024c16e685b969d532d7c6ea79af276dea634baec8b6b7e970d0ff205383a6a66ed3fe","name":"bixi@1.csv","type":"text/csv","lastModified":1691004681431.795,"size":7482002},{"id":"e260244c040adf723c4d2e4a0073db5eac9b7ae4840ce5baf0a604a0e35f82d9e1b292dede1f8efd4dcb265a48c644000621391623c2806b3e8e9e3c32fc5076","href":"https://static.observableusercontent.com/files/e260244c040adf723c4d2e4a0073db5eac9b7ae4840ce5baf0a604a0e35f82d9e1b292dede1f8efd4dcb265a48c644000621391623c2806b3e8e9e3c32fc5076","name":"bay_wheels@2.csv","type":"text/csv","lastModified":1691024976513.087,"size":2356897},{"id":"06392af41814618a49f15fe8ef2af160bd1fd806bd262817723011b904149563b1149d2178c2dfb451638c0f26f9922fd3a8e949043c52a0aff23daa111ff206","href":"https://static.observableusercontent.com/files/06392af41814618a49f15fe8ef2af160bd1fd806bd262817723011b904149563b1149d2178c2dfb451638c0f26f9922fd3a8e949043c52a0aff23daa111ff206","name":"totals@2.csv","type":"text/csv","lastModified":1691001907395.287,"size":134},{"id":"147830c569610ad1071d34fc716899bb58e589db25b01c03d5d6d5e48fddd1390ec6dac239a245399037fa96486b5c807ae679653a1d355c689764c24c2774fe","href":"https://static.observableusercontent.com/files/147830c569610ad1071d34fc716899bb58e589db25b01c03d5d6d5e48fddd1390ec6dac239a245399037fa96486b5c807ae679653a1d355c689764c24c2774fe","name":"bixi@3.csv","type":"text/csv","lastModified":1691005278453.075,"size":7332266},{"id":"0c3ec412c4ce016baca9d8d8052ed6eecd949952f75e5049ffe0b4183d019f0e890771882271dd8c2ec6cac2e0d291d646de7e0095c559217458e955dcdaec49","href":"https://static.observableusercontent.com/files/0c3ec412c4ce016baca9d8d8052ed6eecd949952f75e5049ffe0b4183d019f0e890771882271dd8c2ec6cac2e0d291d646de7e0095c559217458e955dcdaec49","name":"totals-2.csv","type":"text/csv","lastModified":1691005517419.707,"size":144},{"id":"e260244c040adf723c4d2e4a0073db5eac9b7ae4840ce5baf0a604a0e35f82d9e1b292dede1f8efd4dcb265a48c644000621391623c2806b3e8e9e3c32fc5076","href":"https://static.observableusercontent.com/files/e260244c040adf723c4d2e4a0073db5eac9b7ae4840ce5baf0a604a0e35f82d9e1b292dede1f8efd4dcb265a48c644000621391623c2806b3e8e9e3c32fc5076","name":"bay_wheels.csv","type":"text/csv","lastModified":1690996079509.514,"size":2356897},{"id":"abd70305f8cb5623206fc07935ebb2503467c318faea2673c2158d09e1ed1d633f721a36a6fac7592c641fd5162981fee9c235279305c7db02f8d8c5d174bf03","href":"https://static.observableusercontent.com/files/abd70305f8cb5623206fc07935ebb2503467c318faea2673c2158d09e1ed1d633f721a36a6fac7592c641fd5162981fee9c235279305c7db02f8d8c5d174bf03","name":"citi_bike@1.csv","type":"text/csv","lastModified":1690996127350.399,"size":35365871}] 48:{"id":"ee51e816cac1a3e7","slug":"bikeshare-2023","title":"State of Bikeshare (as of Aug 2023)","thumbnail":"825f3e106ddd575f25ca6842b888fedc6db8b70eb722c70d2a0d78a758c41e36","access_level":"public","create_time":"$D2023-08-02T17:05:44.757Z","update_time":"$D2023-08-03T01:59:36.059Z","view_time":null,"first_public_time":"$D2023-08-02T17:05:44.757Z","has_unpublished_edits":null,"fork":{"id":"e8fdc75391faab6f","slug":"bikeshare","title":"Bikeshare in the United States","owner":{"id":"f64dd716a3bbbad7","login":"brady","name":"Brady Law"}},"stars":0,"starred":false,"owner":{"type":"team","id":"f64dd716a3bbbad7","login":"brady","name":"Brady Law","avatar_url":"https://avatars-next.observableusercontent.com/101597cb706624aedd0b13a4e66abe96f5cd8a09fa2d710e393c96266e8c74db","tier":"starter_2024","bio":"Engineer in San Francisco","followed_by_you":false,"follows_you":false},"version":2883,"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,"bio":"Engineer in San Francisco","followed_by_you":false,"follows_you":false}],"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":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"State of Bikeshare (as of Aug 2023)","cells":[{"id":0,"value":"# State of Bikeshare (as of Aug 2023)\n\nA collection of visualizations of public docked bikeshare systems.\n\n**This page is best viewed in Google Chrome on a desktop.**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1836,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":893,"value":"viewof new_station_months = Inputs.range([0, 36], {step: 1, label: \"Months:\", value: 12})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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 Citi Bike (NYC) or Divvy (Chicago), seasonality has a significant impact on ridership. ☃️","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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 type: \"band\",\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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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 in 2020 when the pandemic hit, but most have recovered and many have hit new records since.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"Plot.plot({\n grid: true,\n marginBottom: 80,\n x: {\n tickRotate: -90,\n type: \"band\",\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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"Plot.plot({\n grid: true,\n marginBottom: 80,\n x: {\n tickRotate: -90,\n type: \"band\",\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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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. ⚡️\n\nDespite their popularity, e-bike availability differs greatly by city. Citi Bike, for example, is seeing a declining percentage of e-bike availability leading to [user complaints](https://www.curbed.com/2023/07/citi-bikes-electric-bikes-lyft-broken-maintenance-batteries.html).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":840,"value":"Plot.plot({\n grid: true,\n marginBottom: 80,\n x: {\n tickRotate: -90,\n type: \"band\",\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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2353,"value":"html`

500 ? 500 : width}px;\"/>`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":997,"value":"---\n\n## Data filters (optional)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":229,"value":"---\n\n## Workbook\n\n### Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"import { swatches } from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":404,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1699,"value":"totals = {\n const text = await FileAttachment(\"totals-2.csv\").text()\n return aq.from(d3.csvParse(text)).derive({mil_trips: total => total.count / 1000 })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2437,"value":"format_num = d3.format(\",\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":587,"value":"### Visualizations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":668,"value":"html `\n(Mapbox Stylesheet)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4d","stdlib":"1"}} 24:null