There is a more recent run of this report. Click here to view the most recent run of this report.

Report not found

There was a problem finding this report.
Bike Share Trips
June 17, 2016 · Refreshed over 1 year ago
Description
This report features a categorical bubble chart from Plotly's offline plots for Python. The report uses data from Bay Area Bike Share to compare daily mean temperature to daily mean trips. Bubble size represents the frequency of that mean temperature's occurrence in the dataset. For more information on Plotly's bubble charts check out: https://plot.ly/python/bubble-charts/ For Bay Area Bike Share data see: http://www.bayareabikeshare.com/open-data

Collaborators

Run History
SELECT DISTINCT(CITY)FROM modeanalytics.sf_bike_share_station s
SELECT DISTINCT(CITY)FROM modeanalytics.sf_bike_share_station s
WITH trips as( SELECT DATE_TRUNC('day',t.start_date)as date, CASE WHEN s.city != 'San Francisco' THEN 'Silicon Valley' ELSE s.city END as city, COUNT(t.id)as trips FROM modeanalytics.sf_bike_share_trip t JOIN modeanalytics.sf_bike_share_station s ON t.start_station_id = s.id GROUP BY 1,2) ,weather as( SELECT date, mean_temperature_f FROM modeanalytics.sf_weather WHERE mean_temperature_f is NOT NULL ) ,weather_frequency as( SELECT mean_temperature_f, COUNT(date)as days FROM modeanalytics.sf_weather WHERE mean_temperature_f is NOT NULL GROUP BY 1) SELECT weather.mean_temperature_f, weather_frequency.days, trips.city, AVG(trips.trips)as avg_trips FROM trips JOIN weather ON trips.date = weather.date JOIN weather_frequency ON weather.mean_temperature_f = weather_frequency.mean_temperature_f GROUP BY 1,2,3 ORDER BY 1
WITH trips as( SELECT DATE_TRUNC('day',t.start_date)as date, CASE WHEN s.city != 'San Francisco' THEN 'Silicon Valley' ELSE s.city END as city, COUNT(t.id)as trips FROM modeanalytics.sf_bike_share_trip t JOIN modeanalytics.sf_bike_share_station s ON t.start_station_id = s.id GROUP BY 1,2) ,weather as( SELECT date, mean_temperature_f FROM modeanalytics.sf_weather WHERE mean_temperature_f is NOT NULL ) ,weather_frequency as( SELECT mean_temperature_f, COUNT(date)as days FROM modeanalytics.sf_weather WHERE mean_temperature_f is NOT NULL GROUP BY 1) SELECT weather.mean_temperature_f, weather_frequency.days, trips.city, AVG(trips.trips)as avg_trips FROM trips JOIN weather ON trips.date = weather.date JOIN weather_frequency ON weather.mean_temperature_f = weather_frequency.mean_temperature_f GROUP BY 1,2,3 ORDER BY 1
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-7"> <mode-python id="python_68df31fd7693" options="python_options"></mode-python> </div> <div class="col-md-5"></div> </div> </div> <script> $("mode-python .chart-content").css("height",600) $("mode-python .mode-python").css("height",600) $("mode-python .mode-python").css("max-height",600) $("mode-python img").css("max-height",600)</script>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query. Get help here.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled