Tree Inventory

Information about trees owned and maintained in the right of way by Parks, Recreation and Community Facilities (PRCF), Transportation and Transit departments. This dataset also includes other vegetation in city owned parks and open basins including cacti, bushes, etc. City owned/maintained trees are managed by 3rd parties such as West Coast Arborists (WCA). See also <b><a href="https://www.mesalistens.com/trees-are-cool" target="_blank" rel="noopener noreferrer">Mesa Trees Are Cool</a></b>.

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 \"citydata-mesaaz-gov/tree-inventory-jcys-68y7\".\"tree_inventory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.