About this Dataset

Street Use Permits Use Addresses

Containing all Seattle Department of Transportation Street Use permits uses recorded since 2012. Street Use permits are required for certain activities in the public right of way, including private road work, material storage, and vending or café serving. Locations in this feature class are tied to the closest available address. For permits relating to building development or business activities these addresses are those of the site, but for types of work that span multiple streets an available adjacent address is chosen. This feature class contains one record per permit per use, resulting in repeated permit information between use records on the same permit

| Update Cycle: Nightly

| Contact: Street Use, Seattle Department of Transportation

| Attribute Information

Name	Type	Description
PERMIT_NUMBER	VARCHAR2(30)	The Permit Number. Used to identify the permit in all communication
PERMIT_KEY	VARCHAR2(30)	Primary Key for the permit record in the source system
ADDRESS	VARCHAR2(200)	Address of the location of the permit. The permit may have many impacts on streets surrounding the address not described here
PERMIT_TYPE_ALIAS	VARCHAR2(255)	The type of permit. Describes the type of work and also
PERMIT_CATEGORY	VARCHAR2(30)	Specifies whether the kind of cycle this permit application is in.
Amendment
Annual Review
PERMIT_TYPE	VARCHAR2(30)	Type of permit. Native to particular database.
PERMIT_SUBTYPE	VARCHAR2(30)	Sub type of permit Native to particular database.
PERMIT_STATUS	VARCHAR2(30)	Applied
Issued
Complete
Closed

PERMIT_STAGE <td style='border-top:none; border-left:non
Organization: City of Seattle
Last updated: 2025-02-28T23:33:51.513645
Tags: gis, otc, permit, renew, sdot, seattle, seattle-gis-open-data, street-use, transportation, wa

Tables

Table 1

@usgov.city_of_seattle_street_use_permits_use_addresses_2797b.table_1

111.37 MB
639,061 rows
58 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "applicant_name" VARCHAR,
  "maf_id" BIGINT,
  "inspection_district" VARCHAR,
  "use_code" VARCHAR,
  "use_description" VARCHAR,
  "use_start_date" VARCHAR,
  "project_name" VARCHAR,
  "source" VARCHAR,
  "permit_number" VARCHAR,
  "permit_key" VARCHAR,
  "address" VARCHAR,
  "permit_type_alias" VARCHAR,
  "permit_category" VARCHAR,
  "permit_type" VARCHAR,
  "permit_subtype" VARCHAR,
  "permit_status" VARCHAR,
  "permit_stage" VARCHAR,
  "legacy_permit" VARCHAR,
  "received_date" TIMESTAMP,
  "first_issued_date" TIMESTAMP,
  "last_issued_date" TIMESTAMP,
  "next_expiration_date" VARCHAR,
  "project_description" VARCHAR,
  "permit_is_arterial" VARCHAR,
  "applicant_company" VARCHAR,
  "applicant_id" VARCHAR,
  "inspection_discipline" VARCHAR,
  "review_discipline" VARCHAR,
  "review_district" VARCHAR,
  "use_key" VARCHAR,
  "use_space_code" VARCHAR,
  "use_type" VARCHAR,
  "use_issued_date" TIMESTAMP,
  "use_end_date" VARCHAR,
  "work_days" VARCHAR,
  "mobility_type" VARCHAR,
  "closure_type" VARCHAR,
  "street_side" VARCHAR,
  "arterial" VARCHAR,
  "impact_transit_lane" VARCHAR,
  "impact_sidewalk" VARCHAR,
  "impact_bike_lane" VARCHAR,
  "impact_parking" VARCHAR,
  "impact_other" VARCHAR,
  "area_sqft" DOUBLE,
  "duration" DOUBLE,
  "rate_start_days" DOUBLE,
  "use_day" VARCHAR,
  "use_start_time" VARCHAR,
  "use_end_time" VARCHAR,
  "expected_attendees" DOUBLE,
  "fee_key" DOUBLE,
  "street_key" DOUBLE,
  "last_modified" TIMESTAMP,
  "impact_travel_lane" VARCHAR
);