About this Dataset

PLANNINGCADASTRE Board Of Adjustment Cases

This point dataset contains information retrieved 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.
Organization: City of Austin
Last updated: 2022-12-23T08:48:47.671464
Tags: agoltosocrata

Tables

Table 1

@usgov.city_of_austin_planningcadastre_board_of_adjustment_cases_data.table_1

957.75 kB
3,101 rows
63 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "board_of_adjustment_cases_id" BIGINT,
  "folderrsn" BIGINT,
  "permit_number" VARCHAR,
  "folder_name" VARCHAR,
  "project_name" VARCHAR,
  "case_type" VARCHAR,
  "folder_type" VARCHAR,
  "sub_type" VARCHAR,
  "work_class" VARCHAR,
  "referencefile" VARCHAR,
  "folder_description" VARCHAR,
  "status_current" VARCHAR,
  "status_date" VARCHAR,
  "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,
  "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,
  "propertyrsn" BIGINT,
  "update_date" VARCHAR,
  "created_date" VARCHAR,
  "created_by" VARCHAR,
  "modified_date" VARCHAR,
  "modified_by" VARCHAR
);