About this Dataset

Street Use Permits Use Impacts

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 segment.

| 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)	Spefifies whether the kind of cycle this permit application is in.
Ammendment
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 | VARCHAR2(30) | Current stage of this permit in the
LEGACY_PERMIT | VARCHAR2(30) | Numbe
Organization: City of Seattle
Last updated: 2025-02-28T23:19:32.809247
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_impacts_f5d0a.table_1

79.18 MB
460,790 rows
62 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "applicant_name" VARCHAR,
  "maf_id" DOUBLE,
  "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_travel_lane" 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" BIGINT,
  "last_modified" TIMESTAMP,
  "street_id" DOUBLE,
  "segment_id" DOUBLE,
  "on_street" VARCHAR,
  "from_street" VARCHAR,
  "to_street" VARCHAR,
  "shape_length" DOUBLE
);