Bronx Hurricane Sandy Damaged Trees

damaged tree complaints logged in three days after Hurricane Sandy. The source file is updated automatically and is logging in tree damage not associated with the storm, so I isolated the damage reports to the following three days after the storm. This dataset is historical and will not be updated.

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 \"bronx-lehman-cuny-edu/bronx-hurricane-sandy-damaged-trees-x3s6-cqrv\".\"bronx_hurricane_sandy_damaged_trees\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.