About this Dataset

Residential Building Permits Issued Not Yet Complete

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 are currently issued. This data does not contain records for those permits that were issued but were not completed, cancelled or withdrawn.

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:49:48.475135
Tags: gis, housing-units, permits, planning, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_residential_building_permits_issued_no_0528f95c.table_1

541.45 kB
2,980 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" VARCHAR,
  "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" VARCHAR,
  "quarter_and_year_final" VARCHAR,
  "condo_parcel_or_plat_y_n" VARCHAR  -- Condo Parcel Or Plat (Y/N),
  "most_recent_inspection_date" VARCHAR,
  "most_recent_inspection_type" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);