About this Dataset

SDCI Development Sites

A Development Site (DV), referenced using a Development Site Number, is a property boundary that the Seattle Department of Construction and Inspections (SDCI) uses to apply code standards. A Development Site may overlap with one or more King County tax parcels.

Source Data: DPD.Devsites

Definition Query:

Where DEVSITE STATUS IN ('ACTIVE', 'PRESUMED', 'UPDATE')

And DEVSITE ID does not begin with 'UN'

And DEVSITE ID does not begin with 'WB'

And SEATTLE is not equal to 0

Symbology Category Expression:

var disp_txt = $feature["PRCLID"];

if (Find("RW", disp_txt, 0)>-1) {

return "Right-of-Way";

} else {

return "Non-Right-of-Way";

}

Refresh: Daily
Organization: City of Seattle
Last updated: 2025-04-19T17:02:00.528416
Tags: development-sites, devsites, sdci

Tables

Table 1

@usgov.city_of_seattle_sdci_development_sites.table_1

19.09 MB
236,565 rows
14 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "devsite_id" VARCHAR,
  "devsite_status" VARCHAR,
  "address" VARCHAR,
  "creation_date" VARCHAR,
  "activation_date" VARCHAR,
  "retirement_date" VARCHAR,
  "last_updated_date" VARCHAR,
  "seattle" BIGINT,
  "devsite_description" VARCHAR,
  "lot_size" DOUBLE,
  "legal_description" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);