Portland, Oregon Test Data Set Freeway Loop Detector Data

This set of data files was acquired under USDOT FHWA cooperative agreement DTFH61-11-H-00025 as one of the four test data sets acquired by the USDOT Data Capture and Management program.The freeway data consists of two months of data (Sept 15 2011 through Nov 15 2011) from dual-loop detectors deployed in the main line and on-ramps of a Portland-area freeway. The section of I-205 NB covered by this test data set is 10.09 miles long and the section of I-205 SB covered by this test data set is 12.01 miles long The data includes: flow, occupancy, and speed.

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 \"datahub-transportation-gov/portland-oregon-test-data-set-freeway-loop-6bhp-rgk2\".\"portland_oregon_test_data_set_freeway_loop\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.