International BRT Parking and Curb Inventory

Fehr & Peers conducted a parking inventory and occupancy study in Oakland to support the ongoing International BRT project. The study area consisted of block faces within 1,500 feet of International Boulevard between 1st Avenue and Durant Avenue, a 6.8 mile-long corridor.

Inventory and occupancy data was collected for over 2,500 block faces in February of 2018 between 11:00 AM and 3:00 PM. Block faces were selected for inclusion in the study if any portion of the block face was within 1,500 feet of International Boulevard between 1st Avenue and Durant Avenue. The total length of available parking on each block was collected for blocks with parallel parking, and a number of spaces was collected for those with angled or perpendicular parking. Spaces were further differentiated by metered, unmarked regular, commercial loading, passenger loading, and accessible spaces. Private access or otherwise reserved spaces were not included in the study. Data validation efforts included additional field visits to ground-truth the inventory data and ensure that the observed occupancies were typical, as well as comparisons of the inventory data to block face lengths to identify data entry errors. Certain block faces with identified data entry or collection errors were re-collected in subsequent field visits in March of 2018.

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 \"oaklandca-gov/international-brt-parking-and-curb-inventory-2jm8-ffak\".\"international_brt_parking_and_curb_inventory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.