About this Dataset

Comprehensive Affordable Housing Directory

NOTICE*********
This dataset is incomplete and in the process of being updated. Please contact david.cruz@austintexas.gov with any questions.

This dataset contains all income-restricted housing within the Austin Full Purpose and into the 5-mile Extra Territorial Jurisdiction. This includes properties funded by the City of Austin along with the Housing Authority City of Austin, Housing Authority of Travis County, and Texas Department of Housing and Community Affairs. Some properties may be funded by more than one entity. The property attributes are intended to help Austin residents find income-restricted housing that best suits their needs.

The dataset is connected to the affordable housing data hub which is consistently updated with the most current property information. A Feature Manipulation Engine Script pulls a new dataset to the Open Data Portal on a daily basis.
Organization: City of Austin
Last updated: 2020-11-12T13:21:47.119867
Tags: affordable-housing

Tables

Table 1

@usgov.city_of_austin_comprehensive_affordable_housing_directory.table_1

212.44 kB
671 rows
97 columns

CREATE TABLE table_1 (
  "comp_affordable_housing_id" BIGINT,
  "property_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "unit_type" VARCHAR,
  "census_tract" VARCHAR,
  "owner" VARCHAR,
  "developer" VARCHAR,
  "council_district" DOUBLE,
  "phone" VARCHAR,
  "email" VARCHAR,
  "property_manager_or_landlord" VARCHAR,
  "website" VARCHAR,
  "students_only" VARCHAR,
  "community_elderly" VARCHAR,
  "community_disabled" VARCHAR,
  "cmty_domestic_abuse_survivor" VARCHAR,
  "community_mental" VARCHAR,
  "community_veteran" VARCHAR,
  "community_military" VARCHAR,
  "only_serves_designated_cmtys" VARCHAR,
  "cmty_served_descriptions" VARCHAR,
  "broken_lease" VARCHAR,
  "broken_lease_criteria" VARCHAR,
  "eviction_history" VARCHAR,
  "eviction_history_criteria" VARCHAR,
  "criminal_history" VARCHAR,
  "criminal_history_criteria" VARCHAR,
  "has_waitlist" VARCHAR,
  "total_units" DOUBLE,
  "total_permanent_support_units" DOUBLE,
  "has_permanent_support_units" VARCHAR,
  "total_income_restricted_units" DOUBLE,
  "has_allocated_ir_units" VARCHAR,
  "total_housing_choice_units" DOUBLE,
  "accepts_housing_choice" VARCHAR,
  "total_accessible_ir_units" DOUBLE,
  "has_allocated_acc_ir_units" VARCHAR,
  "num_units_mfi_30" DOUBLE,
  "num_units_mfi_40" DOUBLE,
  "num_units_mfi_50" DOUBLE,
  "num_units_mfi_60" DOUBLE,
  "num_units_mfi_65" DOUBLE,
  "num_units_mfi_70" VARCHAR,
  "num_units_mfi_80" DOUBLE,
  "num_units_mfi_90" VARCHAR,
  "num_units_mfi_100" DOUBLE,
  "num_units_mfi_110" VARCHAR,
  "num_units_mfi_120" VARCHAR,
  "has_0_bed_unit" VARCHAR,
  "has_1_bed_unit" VARCHAR,
  "has_2_bed_unit" VARCHAR,
  "has_3_bed_unit" VARCHAR,
  "has_4_bed_unit" VARCHAR,
  "has_5_bed_unit" VARCHAR,
  "num_ir_0_bed_units" DOUBLE,
  "num_ir_1_bed_units" DOUBLE,
  "num_ir_2_bed_units" DOUBLE,
  "num_ir_3_bed_units" DOUBLE,
  "num_ir_4_bed_units" DOUBLE,
  "num_ir_5_bed_units" DOUBLE,
  "has_playground" VARCHAR,
  "has_pool" VARCHAR,
  "has_off_street_parking" VARCHAR,
  "has_air_conditioning" VARCHAR,
  "has_ceiling_fans" VARCHAR,
  "washer_dryer_unit" VARCHAR,
  "washer_dryer_hookups" VARCHAR,
  "washer_dryer_onsite" VARCHAR,
  "washer_dryer_other" VARCHAR,
  "allows_pet" VARCHAR,
  "pet_other" VARCHAR,
  "bus_transit_distance" VARCHAR,
  "security" VARCHAR,
  "elementary_school" VARCHAR,
  "middle_school" VARCHAR,
  "high_school" VARCHAR,
  "affordability_start" TIMESTAMP,
  "affordability_expiration" TIMESTAMP,
  "austin_housing_inventory_id" DOUBLE,
  "housing_program" VARCHAR,
  "community_development_block_gr" DOUBLE,
  "home_program_funding" DOUBLE,
  "low_income_housing_tax_credit" VARCHAR,
  "source_atc_guide" VARCHAR,
  "source_tdhca" VARCHAR,
  "source_ahi" VARCHAR,
  "is_duplicate" BIGINT,
  "tdhca_funded" VARCHAR,
  "nhcd_funded" VARCHAR,
  "haca_funded" VARCHAR,
  "hatc_funded" DOUBLE,
  "geocolumn" VARCHAR
);