About this Dataset

PLANNINGCADASTRE Zoning Review Case

The polygon dataset contains information regarding the zoning cases that were submitted to the City of Austin's permit 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, proposed uses, proposed number of units, applicants, owners, case managers etc, if available.
Organization: City of Austin
Last updated: 2022-12-23T08:37:28.432568
Tags: agoltosocrata

Tables

Table 1

@usgov.city_of_austin_planningcadastre_zoning_review_case_cff22.table_1

8.03 MB
5,551 rows
71 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "folderrsn" DOUBLE,
  "case_number" VARCHAR,
  "case_name" VARCHAR,
  "status" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length,
  "watershed" VARCHAR,
  "street_name" VARCHAR,
  "fiscal_year_folder_issued" DOUBLE,
  "street_type" VARCHAR,
  "permit_number" VARCHAR,
  "description_of_work" VARCHAR,
  "existing_zoning" VARCHAR,
  "calendar_year_folder_issued" DOUBLE,
  "applicant_phone" VARCHAR,
  "owner_address" VARCHAR,
  "calendar_year_folder_created" DOUBLE,
  "latitude" DOUBLE,
  "detailed_status" VARCHAR,
  "day_approved" VARCHAR,
  "tia_submitted" VARCHAR,
  "sub_type" VARCHAR,
  "case_manager" VARCHAR,
  "owner_organization_name" VARCHAR,
  "organization_name" VARCHAR,
  "gross_site_area_acres" DOUBLE,
  "watershed_class" VARCHAR,
  "case_type" VARCHAR,
  "applicant_fullname" VARCHAR,
  "smart_housing" VARCHAR,
  "link" VARCHAR,
  "unit_type" VARCHAR,
  "street_direction" VARCHAR,
  "longitude" DOUBLE,
  "related_cases" VARCHAR,
  "legal_description" VARCHAR,
  "unit" VARCHAR,
  "approved_in_last_30_days" VARCHAR,
  "council_district" DOUBLE,
  "street_prefix" VARCHAR,
  "zip_code" DOUBLE,
  "school_district" VARCHAR,
  "owner_phone" VARCHAR,
  "applicant_organization_name" VARCHAR,
  "neighborhood_plan_name" VARCHAR,
  "tia_required" VARCHAR,
  "work_type" VARCHAR,
  "tcad_id" VARCHAR,
  "fiscal_year_folder_created" DOUBLE,
  "proposed_zoning" VARCHAR,
  "proposed_land_use" VARCHAR,
  "phone" VARCHAR,
  "owner_fullname" VARCHAR,
  "street_number" VARCHAR,
  "applicant_address" VARCHAR,
  "city" VARCHAR,
  "existing_land_use" VARCHAR,
  "created_date" VARCHAR,
  "modified_by" VARCHAR,
  "created_by" VARCHAR,
  "zoning_case_id" BIGINT,
  "modified_date" VARCHAR,
  "final_date" VARCHAR,
  "approval_date" VARCHAR,
  "status_date" VARCHAR,
  "data_portal_update" VARCHAR,
  "application_start_date" VARCHAR,
  "case_name_92e9af" VARCHAR  -- CASE NAME,
  "zoning_case_ztype" VARCHAR
);