Subdivision Cases by US Government | Demographics and Population Studies

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.55 MB
15086 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
);