Shared Mobility Pilot Trips
This data was collected as part of The City of Calgary's two-year <a href="https://www.calgary.ca/Transportation/TP/Pages/Cycling/Cycling-Strategy/Shared-electric-scooter-pilot.aspx">shared electric scooter</a> and <a href="https://www.calgary.ca/Transportation/TP/Pages/Cycling/Cycling-Strategy/Bike-share-system.aspx">dockless bike share</a> pilots.
The trips in this dataset occurred between July 1st, 2019 and September 30th, 2019. Excluded from this dataset are trips that lasted fewer than 30 seconds or 100 metres, and trips where the geospatial data quality made it unsuitable for analysis.
Trip start times have been generalized to 1-hour intervals. Trip origins and destinations have been generalized by tiling the city with hexagonal bins measuring 30,000 square metres each. The latitude and longitude coordinates are the centrepoint of the corresponding bin.
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 \"calgary-ca/shared-mobility-pilot-trips-jicz-mxiz\".\"shared_mobility_pilot_trips\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
