Automations Dashboard

Open Data is most useful when it’s up-to-date. Over the past eight years, NYC Open Data has invested in dataset automation, so that data is updated without human intervention.

As the demand for City data continues to increase, and new technologies continue to surface, our goal is to automate more data, at a faster rate. In the last few months we have been testing tools and processes that should bring us closer to achieving this goal.

These efforts will lead to more reliable data, while allowing the Open Data Team and agency staff to work more efficiently. We plan to invest more time into testing new methods of automation, and have released a this dataset so anyone can track our progress on automations.

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/automations-dashboard-s52s-navf\".\"automations_dashboard\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.