Tree Planting Program

Recreation, Parks and Open Space’s Bureau of Parks and Urban Forestry plants hundreds of trees each year along city streets, within city parks, and on other city properties. This dataset gives pertinent tree species information, shows important geographic information about which parts of Norfolk are receiving trees in a given year, and historical data about planting date. City staff utilizes Microsoft excel to track tree planting information. This dataset will show where the City of Norfolk plants its trees on city owned properties. This data is updated annually.

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 \"norfolk-gov/tree-planting-program-u85v-sad9\".\"tree_planting_program\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.