1995 Street Tree Census

Citywide street tree data from the 1995 Street Tree Census, conducted by volunteers organized by NYC Parks & Recreation. Trees were inventoried by address, and were collected from 1995-1996. Data collected includes tree species, diameter, condition.

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/1995-street-tree-census-kyad-zm4j\".\"1995_street_tree_census\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.