Funicular Trip Counts
This dataset contains the life to date trip count of Edmonton's Funicular.
The start date for the recording of the life to date trip count was on Aug 1, 2019.
A trip is travel from the bottom to the top OR from the top to the bottom (i.e. one way travel).
The trip count is recorded by the service/inspection person. The trip count may not be recorded every day or may have missing counts. In the instance where the count was missing, a -1 is recorded for the Trip Count.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"edmonton-ca/funicular-trip-counts-66ax-3ztq\".\"funicular_trip_counts\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
