About this Dataset

Residential Building Permits Issued And Final Since 1990

Permit records from the City of Seattle permitting system for building permits that create or demolish housing units. Records begin in 1990 and are through the current year quarter.

The permits in this layer are those that have either been completed or are currently issued. This data does not contain records for those permits that were issued but were not completed so are therefore not comparable to statistics that report permit issuance.

Each record represents the number of units added or demolished for each housing type in the project. Therefore a single building permit may appear multiple times if there are a mix of unit types in the project.

Housing unit types reflect the unit types regulated by the building codes and change through time. There has been no attempt to standardize these types and therefore reflect the unit types that existed at the time the permit was issued.

There may be multiple permits at any given address.
Organization: City of Seattle
Last updated: 2025-02-28T23:43:57.732285
Tags: gis, housing-units, permitexploreapp, permits, planning, seattle-gis-open-data, ucuvmonitordashb

Tables

Table 1

@usgov.city_of_seattle_residential_building_permits_issued_an_3bed3430.table_1

5.34 MB
44214 rows
61 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "project_address" VARCHAR,
  "development_site_square_feet" DOUBLE,
  "permit_number" BIGINT,
  "master_user_permit_number" DOUBLE,
  "permit_stage" VARCHAR,
  "type_of_permit" VARCHAR,
  "new_units_permitted" BIGINT,
  "demolished_units_permitted" BIGINT,
  "net_units_permitted" BIGINT,
  "sleeping_rooms_permitted" BIGINT,
  "permit_value" DOUBLE,
  "type_of_dwelling_unit" VARCHAR,
  "type_of_dwelling_unit_per_code" VARCHAR,
  "description_of_work" VARCHAR,
  "application_date" VARCHAR,
  "issued_date" VARCHAR,
  "year_issued" BIGINT,
  "final_date" VARCHAR,
  "year_finaled" DOUBLE,
  "villnumb" DOUBLE,
  "urban_village_name" VARCHAR,
  "urban_village_type" VARCHAR,
  "comp_plan_name" VARCHAR,
  "comp_plan_type" VARCHAR,
  "community_reporting_area_number" DOUBLE,
  "community_reporting_area" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" DOUBLE,
  "census_block_2010" DOUBLE,
  "census_block_group_2010" DOUBLE,
  "geoid10" DOUBLE,
  "sort" DOUBLE,
  "source" VARCHAR,
  "xcoord_stateplane" DOUBLE,
  "ycoord_stateplane" DOUBLE,
  "maf_id" DOUBLE,
  "devsite_id" VARCHAR,
  "recordnumber" VARCHAR,
  "status_color" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "expiration_date" VARCHAR,
  "zoning_all_zones" VARCHAR,
  "zoning_primary_zone" VARCHAR,
  "zoning_report_zone" VARCHAR,
  "zoning_category" VARCHAR,
  "zoning_class" VARCHAR,
  "parent_construction_permit" VARCHAR,
  "geoid20" DOUBLE,
  "census_block_2020" DOUBLE,
  "census_block_group_2020" DOUBLE,
  "quarter_issued" BIGINT,
  "quarter_and_year_issued" VARCHAR,
  "quarter_final" DOUBLE,
  "quarter_and_year_final" VARCHAR,
  "condo_parcel_or_plat_y_n" VARCHAR,
  "most_recent_inspection_date" VARCHAR,
  "most_recent_inspection_type" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);