About this Dataset

Issued Tree Permits

City of Austin Open Data Terms of Use
https://data.austintexas.gov/stories/s/ranj-cccq

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.
Organization: City of Austin
Last updated: 2020-11-12T13:24:24.028144
Tags: construction, development, permit, permitting, review, tree

Tables

Table 1

@usgov.city_of_austin_issued_tree_permits.table_1

6.63 MB
49,555 rows
30 columns

CREATE TABLE table_1 (
  "permit_number" VARCHAR,
  "project_id" BIGINT,
  "permit_class" VARCHAR,
  "permit_address" VARCHAR,
  "property_id" BIGINT,
  "issued_date" VARCHAR,
  "expires_date" VARCHAR,
  "permit_status" VARCHAR,
  "application_type" VARCHAR,
  "fee_required" VARCHAR,
  "heritage_tree" VARCHAR,
  "public_tree" VARCHAR,
  "removal_of_regulated_tree" VARCHAR,
  "encroachment_of_root_zone" VARCHAR,
  "crown_removal" VARCHAR,
  "species" VARCHAR,
  "trunk_diameter" VARCHAR,
  "tree_condition" VARCHAR,
  "reason_for_request" VARCHAR,
  "propx" DOUBLE,
  "propy" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "council_district" DOUBLE,
  "jurisdiction" VARCHAR,
  "link_to_details" VARCHAR,
  "appendix_f_removed" DOUBLE,
  "non_appendix_f_removed" DOUBLE,
  "mitigation" DOUBLE,
  "combined_geo" VARCHAR
);