About this Dataset

Inactive Addresses (MAF)

Displays inactive citywide address points using TRANSPO.MAFDAP_PV with the definition query "DCLUSTAT includes ('CANCELED', 'RETIRED')". Differs from TRANSPO.DAP in that it contains address data. Attributes include house number and modifier, directional, street name, and street type. Does not display when zoomed out beyond 1:10,000. Labels are based on the attribute MAF_HSENUMMOD and do not display when zoomed out beyond 1:3,000.

ATTRIBUTE INFORMATION:

MAILUSECODE: Identifies suitability of MAF address and associated MAFUNIT record(s) for use as a mailing address. This field serves as an indicator whether the address is being utilized in the City's Utility Billing System. If so, it is more likely (but still not guaranteed) to be a valid mailing address.
Organization: City of Seattle
Last updated: 2025-10-25T21:39:09.299775
Tags: address, addresses, maf, seattle, seattle-gis-open-data, transpo

Tables

Table 1

@usgov.city_of_seattle_inactive_addresses_maf.table_1

899.31 kB
16,206 rows
17 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "maf_id" BIGINT,
  "dap_id" BIGINT,
  "snd_id" BIGINT,
  "maf_hsenummod" VARCHAR,
  "maf_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "mailusecode" BIGINT,
  "dclustat" VARCHAR,
  "dclustatdt" TIMESTAMP,
  "sourcename" VARCHAR,
  "sourcedescription" VARCHAR,
  "se_anno_cad_data" VARCHAR
);