About this Dataset

Subdivision Cases

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

This data set contains information about the subdivision case applications submitted for review to the City of Austin. The data set includes information about case status in the permit review system, case number, proposed use, applicant, owner, and location.
Organization: City of Austin
Last updated: 2020-11-12T13:32:06.323305
Tags: austin, city-of-austin, development, development-services-department, subdivision-cases, subdivisions

Tables

Table 1

@usgov.city_of_austin_subdivision_cases.table_1

2.68 MB
15,086 rows
69 columns

CREATE TABLE table_1 (
  "folderrsn" BIGINT,
  "permit_number" VARCHAR,
  "referencefile" VARCHAR,
  "case_type" VARCHAR,
  "case_name" VARCHAR,
  "sub_type" VARCHAR,
  "work" VARCHAR,
  "status" VARCHAR,
  "proposed_land_use" VARCHAR,
  "desc_of_proposed_development" VARCHAR,
  "description_of_work" VARCHAR,
  "case_manager" VARCHAR,
  "link" VARCHAR,
  "final_date" TIMESTAMP,
  "status_date" TIMESTAMP,
  "application_start_date" TIMESTAMP,
  "approval_date" TIMESTAMP,
  "approved_in_last_30_days" VARCHAR,
  "day_approved" VARCHAR,
  "calendar_year_folder_created" DOUBLE,
  "calendar_year_folder_issued" DOUBLE,
  "fiscal_year_folder_created" DOUBLE,
  "fiscal_year_folder_issued" DOUBLE,
  "street_number" VARCHAR,
  "street_prefix" VARCHAR,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "unit_type" VARCHAR,
  "unit" VARCHAR,
  "propertyrsn" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "neighborhood_plan_name" VARCHAR,
  "smart_growth_zone" VARCHAR,
  "council_district" DOUBLE,
  "zip_code" DOUBLE,
  "school_district" VARCHAR,
  "city" VARCHAR,
  "watershed" VARCHAR,
  "watershed_class" VARCHAR,
  "existing_no_of_lots" DOUBLE,
  "legal_description" VARCHAR,
  "prop_impervious_cover_acres" VARCHAR,
  "prop_impervious_cover_percent" DOUBLE,
  "proposed_no_of_lots" DOUBLE,
  "proposed_no_of_units" DOUBLE,
  "tcad_id" VARCHAR,
  "gross_site_area_acres" DOUBLE,
  "existing_land_use" VARCHAR,
  "existing_zoning" VARCHAR,
  "related_cases" VARCHAR,
  "smart_housing" VARCHAR,
  "tia_required" VARCHAR,
  "tia_submitted" VARCHAR,
  "applicant_fullname" VARCHAR,
  "applicant_organization_name" VARCHAR,
  "applicant_address" VARCHAR,
  "applicant_addrcity" VARCHAR,
  "applicant_phone1" VARCHAR,
  "owner_fullname" VARCHAR,
  "owner_organization_name" VARCHAR,
  "owner_address" VARCHAR,
  "owner_addrcity" VARCHAR,
  "owner_phone1" VARCHAR,
  "update_date" VARCHAR,
  "location" VARCHAR,
  "jurisdiction" VARCHAR,
  "proposed_bldg_sq_footage" VARCHAR
);