Providence Tree Dataset

In 2006, a complete inventory of all the City’s street trees, including trees located within sidewalks, between sidewalks and curbs, or within 6 feet of the street if no sidewalk existed was conducted. One hundred volunteers were trained to record address, location, tree species, tree diameter, condition, and other related information. Trees located in parks and other public property were not included. Approximately 25,000 street trees were counted and the data was loaded into a tree database that the Forestry Division uses daily to manage the trees, track tree work, and record constituent concerns.

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 \"providenceri-gov/providence-tree-dataset-b77h-59tz\".\"providence_tree_dataset\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.