Traffic Bollards Tracking and Installations

New York City Department of Transportation installs flexible traffic bollards to reduce traffic speeds. It is used as separators between lanes, and for pedestrian safety. This dataset tracks flexible traffic bollards, installation and replacements.

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 \"cityofnewyork-us/traffic-bollards-tracking-and-installations-3f5t-9dqu\".\"traffic_bollards_tracking_and_installations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.