There is a more recent run of this report.
Click here to view it.
Network Matrix
October 31, 2016 · Refreshed about 3 years ago
Collaborators
Joel Carron
Run History
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
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
<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="network-matrix"></div>
<script>
alamode.networkMatrix(
{
"html_element": "#network-matrix",
"node_query": "Stations",
"edge_query": "Trips",
"title": "SF Bike Share Network",
"chart_width": 900,
"chart_height": 900,
"padding_for_names": 255,
"left_label": "Starting station",
"top_label": "Ending station",
"group_colors": {
"San Francisco": "#37B067",
"San Jose": "#894FBA",
"Mountain View": "#22A3C0",
"Palo Alto": "#EE7437",
"Redwood City": "#DA364A"
}
}
)
</script>
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