About this Dataset

Board Of Adjustment 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 Board of Adjustment (BOA) 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, case managers etc, if available. Note that many fields are intentionally left blank or are not filled out for various reasons.More information about the BOA process is available at http://www.austintexas.gov/boa 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:35:15.751688
Tags: cases, development, permits, regulations, variances, zoning

Tables

Table 1

@usgov.city_of_austin_board_of_adjustment_cases.table_1

1.02 MB
3,251 rows
57 columns

CREATE TABLE table_1 (
  "case_type" VARCHAR,
  "folder_type" VARCHAR,
  "sub_type" VARCHAR,
  "work_class" VARCHAR,
  "permit_number" VARCHAR,
  "referencefile" VARCHAR,
  "folder_name" VARCHAR,
  "folder_description" VARCHAR,
  "project_name" VARCHAR,
  "folderrsn" BIGINT,
  "web_link" 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" DOUBLE,
  "other_full_name" VARCHAR,
  "other_organization_name" VARCHAR,
  "other_address" VARCHAR,
  "other_phone" VARCHAR,
  "appraisal_id" VARCHAR,
  "case_manager" VARCHAR,
  "boa_consideration" VARCHAR,
  "hearing_date" VARCHAR,
  "parking_crit_free_flow" VARCHAR,
  "parking_crit_safety_haz" VARCHAR,
  "parking_crit_spec_to_use" VARCHAR,
  "parking_crit_traffic_vol" VARCHAR,
  "variance_reason" VARCHAR,
  "structure_type" VARCHAR,
  "unique_hardship" VARCHAR,
  "unusual_hardship" VARCHAR,
  "zoning_district" VARCHAR,
  "historic_review" VARCHAR,
  "effect_adj_property" VARCHAR,
  "variance_type" VARCHAR,
  "status_current" VARCHAR,
  "status_date" VARCHAR,
  "issued_date" VARCHAR,
  "issued_in_last_30_days" VARCHAR,
  "calendar_year_issued" DOUBLE,
  "fiscal_year_issued" DOUBLE,
  "applied_date" VARCHAR,
  "day_issued" VARCHAR,
  "expires_date" VARCHAR,
  "council_district" DOUBLE,
  "legal_description" VARCHAR,
  "propx" DOUBLE,
  "propy" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "propertyrsn" BIGINT,
  "update_date" VARCHAR
);