About this Dataset

Plan Review Cases

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

This dataset was created to compile information about Plan Review (PR) cases filed with the City of Austin. The information is retrieved daily from the City's Application MANagement and Data Automation (AMANDA) database and includes information on location, proposed variances, applicants, owners, etc, if available. Note that many fields are intentionally left blank or are not filled out for various reasons.More information about the Plan Review process is available at https://austintexas.gov/buildingreview and by using the Austin Build and Connect portal https://abc.austintexas.gov/web/permit/public-search-other.
Organization: City of Austin
Last updated: 2020-11-12T13:30:15.032780
Tags: case, development, permit, plan, review

Tables

Table 1

@usgov.city_of_austin_plan_review_cases.table_1

35.66 MB
148,324 rows
61 columns

CREATE TABLE table_1 (
  "case_type" VARCHAR,
  "folder_type" VARCHAR,
  "sub_type" VARCHAR,
  "work_class" VARCHAR,
  "permit_number" VARCHAR,
  "referencefile" VARCHAR,
  "project_name" VARCHAR,
  "folder_description" VARCHAR,
  "express_permit" VARCHAR,
  "folder_section" VARCHAR,
  "folderrsn" BIGINT,
  "web_link" VARCHAR,
  "status_current" VARCHAR,
  "status_date" VARCHAR,
  "applicant_full_name" VARCHAR,
  "applicant_organization_name" VARCHAR,
  "applicant_address" VARCHAR,
  "applicant_phone" VARCHAR,
  "owner_full_name" VARCHAR,
  "owner_organization_name" VARCHAR,
  "owner_address" VARCHAR,
  "owner_phone" VARCHAR,
  "other_full_name" VARCHAR,
  "other_organization_name" VARCHAR,
  "other_address" VARCHAR,
  "other_phone" VARCHAR,
  "condominium" VARCHAR,
  "appraisal_id" VARCHAR,
  "issued_date" VARCHAR,
  "issued_in_last_30_days" BOOLEAN,
  "day_issued" VARCHAR,
  "calendar_year_issued" DOUBLE,
  "fiscal_year_issued" DOUBLE,
  "applied_date" VARCHAR,
  "fiscal_year_indate" VARCHAR,
  "expires_date" VARCHAR,
  "final_date" VARCHAR,
  "building_valuation" DOUBLE,
  "building_valuation_remodel" DOUBLE,
  "electrical_valuation" DOUBLE,
  "electrical_valuation_remodel" DOUBLE,
  "mechanical_valuation" DOUBLE,
  "mechanical_valuation_remodel" DOUBLE,
  "medgas_valuation" VARCHAR,
  "medgas_valuation_remodel" DOUBLE,
  "number_of_floors" DOUBLE,
  "number_of_units" DOUBLE,
  "plumbing_valuation" DOUBLE,
  "plumbing_valuation_remodel" DOUBLE,
  "remodel_repair_footage" DOUBLE,
  "total_existing_bldg_footage" DOUBLE,
  "total_job_valuation" DOUBLE,
  "total_new_add_footage" DOUBLE,
  "total_valuation_remodel" DOUBLE,
  "council_district" DOUBLE,
  "legal_description" VARCHAR,
  "propx" DOUBLE,
  "propy" DOUBLE,
  "propertyrsn" BIGINT,
  "update_date" TIMESTAMP,
  "location" VARCHAR
);