Seattle Building Permit Completion
Suitability and evaluation
Evaluation setting: retrospective research. Read the prediction setting and limitations below. Public validation is development data; downloadable holdout labels must stay outside the evaluated agent workspace.
Will a newly issued Seattle building permit for a substantive construction project reach final inspection sign-off within four years of issuance?
Population: Every row in the live Socrata snapshot with PermitTypeMapped equal to Building, IssuedDate in the half-open window 2016-01-01 through 2022-10-01, and EstProjectCost at least 50000 nominal USD. Rows with impossible chronology (CompletedDate before IssuedDate, or IssuedDate before AppliedDate when both are present) are excluded as a source data-quality rule per the construction recipe. The unit is the permit as issued; no site-level or contractor-level aggregates are used. The population is fixed by permit type, issuance date and declared cost, not by the label value.
Target: y = 1 if CompletedDate is non-null and CompletedDate <= IssuedDate + 48 calendar months (dateutil relativedelta, month arithmetic); y = 0 otherwise, including permits still under inspection, expired permits and withdrawn permits. Evaluated against the 2026-11-14 snapshot, by which date the 48-month window of every eligible cohort has already closed, so the label can no longer flip from 0 to 1.
Prediction time: The permit IssuedDate, when the permit is issued. Only fields written at submittal, during plan review, or at issuance are used; CompletedDate, StatusCurrent, ExpiresDate and post-issuance revisions are excluded from features. The label is observed retrospectively after the 48-month window.
Splits: Fixed calendar boundaries on IssuedDate, no shuffling: train = 2016-01-01..2018-12-31 (11,289 eligible permits), eval = 2019-01-01..2020-12-31 (7,135), holdout = 2021-01-01..2022-09-30 (6,326). The holdout end date is chosen so the last 48-month label window closes on 2026-09-30, before the 2026-11-14 snapshot. No embargo is applied or needed: every feature is strictly row-local, there are no lags, rolling aggregates or other permits' outcomes, so moving a boundary by a month cannot leak anything.
Outcome horizon: 48 months from IssuedDate
Inputs: permitclass: Project class recorded on the application: Single Family/Duplex, Commercial, Multifamily, Institutional, Industrial, Vacant Land, or N/A. Categorical and row-local.; permitclassmapped: Residential, Non-Residential or N/A roll-up of permit class.; permittypedesc: New, Addition/Alteration, Tenant Improvement, Temporary, Change of Use Only - No Construction, Curb Cut, or NONE.; estprojectcost: Applicant-declared fair-market construction cost in nominal USD; all included rows have at least 50000 by population definition. Mutable if the project is later modified, so read as current-vintage.; housingunitsadded: Housing units the project adds; null for many rows and left blank, not zero.; housingunitsremoved: Housing units the project removes; null left blank.; housingunits: Net housing-unit change for the project; null left blank.; applied_to_issued_days: Calendar days from AppliedDate to IssuedDate; null if AppliedDate is missing. Both timestamps are at or before issuance.; totaldaysplanreview: Total plan-review days recorded by SDCI; frequently null in 2016-era rows and left blank.; numberreviewcycles: Number of plan-review correction cycles recorded before issuance; null left blank.; daysoutcorrections: Days the applicant spent outside the city responding to plan-review corrections; missing values left blank.; issue_month_sin: Sine of the issuance month, a cyclical calendar encoding known at issuance.; issue_month_cos: Cosine of the issuance month, a cyclical calendar encoding known at issuance.; originalzip: Five-digit project ZIP mapped to the 20 most frequent training-row ZIPs plus other and missing; the top-20 list is fitted on training rows only.; description_length: Character length of the free-text scope description; null when description is missing.; description_stfi: Binary token for stfi in the scope description; null when description is missing, not zero.; description_per_plan: Binary token for per plan in the scope description; null when description is missing, not zero.; description_apartment: Binary token for apartment in the scope description; null when description is missing, not zero.; description_unit: Binary token for unit in the scope description; null when description is missing, not zero.; description_tenant: Binary token for tenant in the scope description; null when description is missing, not zero.; description_demolition: Binary token for demolition in the scope description; null when description is missing, not zero.; dependentbuilding: Dependent-building indicator recorded at filing; null left blank.; standardplan: Pre-approved DADU standard-plan indicator; null left blank.; parent_permit_flag: One when ParentPermitNum is present, else zero; a filing-structure indicator.; related_mup_flag: One when RelatedMUP is present, else zero; a filing-structure indicator.