About this Dataset

Zoning Cases

This data set contains information about zoning cases submitted for review to the City of Austin where records existed. It includes information about case status, case number, proposed use, applicant, owner, and location. Another version of this data in the form of a location dataset exists, showing cases starting in about 2007, when cases were first created in GIS.
Organization: City of Austin
Last updated: 2020-11-12T13:26:23.299499
Tags: land-use, zoning

Tables

Table 1

@usgov.city_of_austin_zoning_cases.table_1

1.79 MB
6,767 rows
61 columns

CREATE TABLE table_1 (
  "folderrsn" BIGINT,
  "case_number" VARCHAR,
  "permit_number" VARCHAR,
  "case_name" VARCHAR,
  "case_type" VARCHAR,
  "work_type" VARCHAR,
  "sub_type" VARCHAR,
  "detailed_status" VARCHAR,
  "description_of_work" VARCHAR,
  "proposed_zoning" VARCHAR,
  "existing_zoning" VARCHAR,
  "proposed_land_use" VARCHAR,
  "existing_land_use" VARCHAR,
  "gross_site_area_acres" DOUBLE,
  "case_manager" VARCHAR,
  "tia_required" VARCHAR,
  "tia_submitted" VARCHAR,
  "site_address" VARCHAR,
  "council_district" DOUBLE,
  "watershed" VARCHAR,
  "watershed_class" VARCHAR,
  "smart_housing" VARCHAR,
  "related_cases" VARCHAR,
  "status_date" VARCHAR,
  "application_start_date" TIMESTAMP,
  "approval_date" TIMESTAMP,
  "approved_in_last_30_days" VARCHAR,
  "calendar_year_folder_created" DOUBLE,
  "calendar_year_folder_issued" DOUBLE,
  "day_approved" VARCHAR,
  "final_date" TIMESTAMP,
  "fiscal_year_folder_created" DOUBLE,
  "fiscal_year_folder_issued" DOUBLE,
  "peoplecode" BIGINT,
  "peoplersn" BIGINT,
  "propertyrsn" BIGINT,
  "applicant_peoplecode" DOUBLE,
  "applicant_fullname" VARCHAR,
  "applicant_organization_name" VARCHAR,
  "applicant_address" VARCHAR,
  "applicant_peoplersn" DOUBLE,
  "applicant_phone" VARCHAR,
  "owner_peoplecode" VARCHAR,
  "owner_peoplersn" DOUBLE,
  "owner_fullname" VARCHAR,
  "owner_organization_name" VARCHAR,
  "owner_address" VARCHAR,
  "owner_phone" VARCHAR,
  "organization_name" VARCHAR,
  "organization_address" VARCHAR,
  "organization_contact" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "neighborhood_plan_name" VARCHAR,
  "link" VARCHAR,
  "phone" VARCHAR,
  "school_district" VARCHAR,
  "tcad_id" VARCHAR,
  "legal_description" VARCHAR,
  "data_portal_update" TIMESTAMP,
  "location" VARCHAR
);