About this Dataset

Built Units Since 2010

Permit records from the City of Seattle permitting system for building permits that create or demolish housing units. Records begin from the beginning of the previous decade from the current quarter year.

The permits in this layer are those that have been completed. 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:41:07.933846
Tags: gis, housing-units, permits, planning, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_built_units_since_2010_cfd28.table_1

3.28 MB
22751 rows
60 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" BIGINT,
  "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,
  "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" BIGINT,
  "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
);