About this Dataset

Issued Construction Permits

NOTE TO USERS -- There may be disruption to this data set between March 19 to March 29 related to an upgrade. Please contact dsdopendata@austintexas.gov with questions. City of Austin Open Data Terms of Use https://data.austintexas.gov/stories/s/ranj-cccq Building, Electrical, Mechanical, and Plumbing Permits and Driveway/Sidewalk Permits issued by the City of Austin. Includes relevant details such as issue date, location, council district, expiration date, description of work, square footage, valuation, and units. This dataset is compliant with the Building & Land Development Specification (BLDS) data standard. Development Services DEPARTMENT DATA DISCLAIMER: ---------------------------------------------------------------------------------------------- 1. The data provided are for informational use only and may differ from official DSD data. 2. DSD’s database is continuously updated, so reports run at different times may produce different results. Care should be taken when comparing against other reports as different data collection methods and different data sources may have been used. 3. The Development Services Department does not assume any liability for any decision made or action taken or not taken by the recipient in reliance upon any information or data provided.
Organization: City of Austin
Last updated: 2020-11-12T13:21:20.308742
Tags: blds, building, development, driveway, electrical, land-development-code, mechanical, one-texas-center, permit-center, permits, plumbing, services, sidewalk

Tables

Table 1

@usgov.city_of_austin_issued_construction_permits.table_1

264.23 MB
2298880 rows
68 columns


CREATE TABLE table_1 (
  "permit_type" VARCHAR,
  "permit_type_desc" VARCHAR,
  "permit_num" VARCHAR,
  "permit_class_mapped" VARCHAR,
  "permit_class" VARCHAR,
  "work_class" VARCHAR,
  "condominium" VARCHAR,
  "project_name" VARCHAR,
  "description" VARCHAR,
  "tcad_id" VARCHAR,
  "property_legal_description" VARCHAR,
  "applied_date" TIMESTAMP,
  "issued_date" TIMESTAMP,
  "day_issued" VARCHAR,
  "calendar_year_issued" BIGINT,
  "fiscal_year_issued" BIGINT,
  "issued_in_last_30_days" VARCHAR,
  "issuance_method" VARCHAR,
  "status_current" VARCHAR,
  "status_date" TIMESTAMP,
  "expires_date" TIMESTAMP,
  "completed_date" TIMESTAMP,
  "total_existing_bldg_sqft" DOUBLE,
  "remodel_repair_sqft" DOUBLE,
  "total_new_add_sqft" DOUBLE,
  "total_valuation_remodel" DOUBLE,
  "total_job_valuation" DOUBLE,
  "number_of_floors" DOUBLE,
  "housing_units" DOUBLE,
  "building_valuation" DOUBLE,
  "building_valuation_remodel" DOUBLE,
  "electrical_valuation" DOUBLE,
  "electrical_valuation_remodel" DOUBLE,
  "mechanical_valuation" DOUBLE,
  "mechanical_valuation_remodel" DOUBLE,
  "plumbing_valuation" DOUBLE,
  "plumbing_valuation_remodel" DOUBLE,
  "medgas_valuation" VARCHAR,
  "medgas_valuation_remodel" DOUBLE,
  "original_address_1" VARCHAR,
  "original_city" VARCHAR,
  "original_state" VARCHAR,
  "original_zip" DOUBLE,
  "council_district" DOUBLE,
  "jurisdiction" VARCHAR,
  "link" VARCHAR,
  "project_id" BIGINT,
  "master_permit_num" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "contractor_trade" VARCHAR,
  "contractor_company_name" VARCHAR,
  "contractor_full_name" VARCHAR,
  "contractor_phone" VARCHAR,
  "contractor_address_1" VARCHAR,
  "contractor_address_2" VARCHAR,
  "contractor_city" VARCHAR,
  "contractor_zip" VARCHAR,
  "applicant_full_name" VARCHAR,
  "applicant_organization" VARCHAR,
  "applicant_phone" VARCHAR,
  "applicant_address_1" VARCHAR,
  "applicant_address_2" VARCHAR,
  "applicant_city" VARCHAR,
  "applicant_zip" VARCHAR,
  "certificate_of_occupancy" VARCHAR,
  "total_lot_sqft" DOUBLE
);