Blocked Railroad Crossing Incident Reports

This dataset includes reported incidents where road and railroad intersections are blocked. The data is pulled from the Blocked Crossing Incident Data dashboard on the U.S. Department of Transportation Federal Railroad Administration website. The Federal Railroad Administration provides users with a way to report incidents through their Public Blocked Crossing Incident Reporter. The data provided in this dataset only includes Norfolk incidents and provides specific location information of incidents. This dataset will be updated daily.

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 \"norfolk-gov/blocked-railroad-crossing-incident-reports-bguc-8iwd\".\"blocked_railroad_crossing_incident_reports\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.