T1 Modal Split

Employers of 10 - 49 employees are required to submit annual trip reduction plans to the City. This information captures the modes of employee commute as reported by those employers. Some employers report directly to the South Coast Air Quality Management District.

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 \"sustainablesm/t1-modal-split-et3b-ze58\".\"t1_modal_split\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.