Issued Tree Permits

This dataset was created by the City of Austin to compile information regarding all issued Tree Permit folders in AMANDA. The dataset contains information regarding the species, condition, and trunk diameter of the tree. It also includes geographic information like Council District and Jurisdiction Type. These permits are created throughout various review process at the City of Austin.

The point dataset contains information regarding active tree permits that were created throughout the City of Austin's review process. Information in this dataset has been retrieved from the City's Application MANagement and Data Automation (AMANDA) database. The dataset contains information on location, permit type, date of issue/expiration, heritage status, species, trunk diameter, condition, reason for request, council district, jurisdiction, associated fee, link to permit, and more.

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 \"datahub-austintexas-gov/issued-tree-permits-ac2h-ha3r\".\"issued_tree_permits\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.