Trees Planted by the Port Authority of NY NJ in New York City: Beginning 2008

This dataset contains information about trees that have been planted in New York City by the Port Authority of New York and New Jersey from 2008 to 2012. Trees are planted by the Port Authority or contactors on Port Authority Property. Tree data includes the tree species, size, location and quantity.

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 \"ny-gov/trees-planted-by-the-port-authority-of-ny-nj-in-dxb3-4wp7\".\"trees_planted_by_the_port_authority_of_ny_nj_in\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.