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

Report not found

There was a problem finding this report.
Force Directed Graph
October 31, 2016 · Refreshed about 2 years ago

Collaborators

Run History
SELECT CASE WHEN node ilike '%)%' THEN SPLIT_PART(node,')',1) ELSE node END AS node, node_group, node_size FROM( SELECT CASE WHEN start_station_name ilike '%(%' THEN SPLIT_PART(start_station_name,'(',2) WHEN start_station_id = 46 THEN 'Washington at Kearney' ELSE start_station_name END AS node, s.city AS node_group, COUNT(*) AS node_size 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 ) a ORDER BY 3 DESC
SELECT CASE WHEN node ilike '%)%' THEN SPLIT_PART(node,')',1) ELSE node END AS node, node_group, node_size FROM( SELECT CASE WHEN start_station_name ilike '%(%' THEN SPLIT_PART(start_station_name,'(',2) WHEN start_station_id = 46 THEN 'Washington at Kearney' ELSE start_station_name END AS node, s.city AS node_group, COUNT(*) AS node_size 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 ) a ORDER BY 3 DESC
SELECT CASE WHEN source ilike '%)%' THEN SPLIT_PART(source,')',1) ELSE source END AS source, CASE WHEN target ilike '%)%' THEN SPLIT_PART(target,')',1) ELSE target END AS target, edge_size FROM( SELECT CASE WHEN start_station_name ilike '%(%' THEN SPLIT_PART(start_station_name,'(',2) WHEN start_station_id = 46 THEN 'Washington at Kearney' ELSE start_station_name END AS source, CASE WHEN end_station_name ilike '%(%' THEN SPLIT_PART(end_station_name,'(',2) WHEN end_station_id = 46 THEN 'Washington at Kearney' ELSE end_station_name END AS target, COUNT(*) AS edge_size FROM modeanalytics.sf_bike_share_trip t GROUP BY 1,2 ) a ORDER BY 1,2
SELECT CASE WHEN source ilike '%)%' THEN SPLIT_PART(source,')',1) ELSE source END AS source, CASE WHEN target ilike '%)%' THEN SPLIT_PART(target,')',1) ELSE target END AS target, edge_size FROM( SELECT CASE WHEN start_station_name ilike '%(%' THEN SPLIT_PART(start_station_name,'(',2) WHEN start_station_id = 46 THEN 'Washington at Kearney' ELSE start_station_name END AS source, CASE WHEN end_station_name ilike '%(%' THEN SPLIT_PART(end_station_name,'(',2) WHEN end_station_id = 46 THEN 'Washington at Kearney' ELSE end_station_name END AS target, COUNT(*) AS edge_size FROM modeanalytics.sf_bike_share_trip t GROUP BY 1,2 ) a ORDER BY 1,2
<link rel="stylesheet" href="https://mode.github.io/alamode/alamode.min.css"> <script src="https://mode.github.io/alamode/alamode.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/d3-tip/0.6.7/d3-tip.min.js"></script> <div id="force-directed-graph"></div> <script> alamode.forceDirectedGraph( { "node_query": "Stations", "edge_query": "Trips", "html_element": "#force-directed-graph", "title": "SF Bike Share network", "chart_width": 1000, "chart_height": 1000, "group_colors": { "San Francisco": "#37B067", "San Jose": "#894FBA", "Mountain View": "#22A3C0", "Palo Alto": "#EE7437", "Redwood City": "#DA364A" }, "links_to_show":1000 } ) </script>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

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