Micromobility Trips

The micromobility e-scooters and e-bikes trips in this dataset occurred on or after June 3, 2022. Individual trips that have a reported duration of less than 30 seconds or a reported distance of less than 100 metres have been excluded. Trip start times have been generalized to 1-hour intervals by truncation, and have been converted to local time. Trip origins and destinations have been generalized by tiling the city with hexagonal bins using the H3 library by Uber Technologies, Inc. Centrepoints and polygons are provided. Provider (vendor) names have been withheld. Trip IDs are hashed.

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/micromobility-trips-73zp-zcvj\".\"micromobility_trips\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.