Commissioner's Correspondence

DOT receives, tracks, and responds to correspondences sent to the Commissioner's Correspondence Unit (CCU) and Borough Commissioner’s (BC) offices. This includes some requests initially sent to 311 and the Mayor's Office, and then forwarded to DOT.

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/commissioners-correspondence-b4mf-rg6h\".\"commissioners_correspondence\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.