About this Dataset

Issued Sign/Banner 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 sign/banner permits folders in AMANDA. The dataset contains information regarding the type, size, applicant, and location of the sign and permit. It also includes geographic information like Council District and Jurisdiction Type.

The point dataset contains information regarding issued sign/banner permits that were created if the permit is tied to a property. Information in this dataset has been retrieved from the City's Application MANagement and Data Automation (AMANDA) database. The dataset contains information on location, banner direction, illumination type, variance requirement, installation date, type of sign, and removal date.
Organization: City of Austin
Last updated: 2020-11-12T13:23:40.937530
Tags: banner, permit, sign

Tables

Table 1

@usgov.city_of_austin_issued_sign_banner_permits.table_1

1.32 MB
11,999 rows
33 columns

CREATE TABLE table_1 (
  "permit_id" BIGINT,
  "calendar_year" VARCHAR,
  "fiscal_year" VARCHAR,
  "permit_location_name" VARCHAR,
  "permit_number" VARCHAR,
  "permit_condition" VARCHAR,
  "permit_description" VARCHAR,
  "permit_in_date" TIMESTAMP,
  "permit_expire_date" TIMESTAMP,
  "permit_final_date" TIMESTAMP,
  "permit_parent_id" DOUBLE,
  "permit_status" VARCHAR,
  "permit_sub_type" VARCHAR,
  "permit_work_type" VARCHAR,
  "installation_date" TIMESTAMP,
  "removal_date" TIMESTAMP,
  "banner_direction" VARCHAR,
  "banner_location" VARCHAR,
  "engineering_req" VARCHAR,
  "illumination_type" VARCHAR,
  "sign_in_etj" VARCHAR,
  "sign_variance_req" VARCHAR,
  "submitted_501c3" VARCHAR,
  "total_sign_face_area" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "council_district" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "applicant_name" VARCHAR,
  "applicant_organization" VARCHAR,
  "fme_rejection_code" VARCHAR
);