T11 Street Safety

All of the data for the injury collision maps came from TIMS – the Transportation Injury Mapping System. TIMS is a project of UC Berkeley’s Safe Transportation Research and Education Center (SafeTREC). It takes data from another mapping system called SWITRS (State-Wide Integrated Traffic Records System), which is compiled by the CHP from law enforcement agencies throughout the state.

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/t11-street-safety-8eps-cjuk\".\"t11_street_safety\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.