City Tree Inventory

This dataset shows all city-managed trees, the majority of which are located on public property, lining streets, or in right of ways. The original inventory of these trees was conducted in the late 1990s/early 2000s by the Norfolk Master Gardeners. No official re-inventory has been conducted since then by City officials or ISA Certified Arborists, however, tree records in this dataset have been and are being updated over time by City Staff. This dataset will be updated in the Open Data Portal every weekday.

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/city-tree-inventory-cmvv-agyb\".\"city_tree_inventory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.