T1 AVR

AVR is a measure of persons per vehicle calculated by dividing the number of employees arriving or departing the worksite by the number of vehicles used to commute to and from the worksite. AVR is calculated using information about employee commute patterns collected over a five day survey period. The minimum AVR attainment goal is 1.5 persons per vehicle for the morning commute period (6:00 a.m. to 10:00 a.m.) and the evening commute period (3:00 p.m. to 7:00 p.m.)

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-avr-he6r-ceuk\".\"t1_avr\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.