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)
Number for the
previous permit if the work performed was shifted to another. Permits may be
combined or replaced as needed to account for changes in the work or billing
RECEIVED_DATE
DATETIME2
The date on which the
application for this permit was recived.
FIRST_ISSUED_DATE
DATETIME2
The date on which
this permit was first issued. If null, this permit is only an application and
has not yet been issued to the applicant
LAST_ISSUED_DATE
DATETIME2
The date on which the
permit was last issued. Permits may be reissued, exteded, modifyed or renewed
NEXT_EXPIRATION_DATE
DATETIME2
The date on which the
permit described here expires. It may be renewed or extended based on permit
type and the nature of the work
PROJECT_NAME
VARCHAR2(255)
Short description of
the permit, may include well known names for the work ie "Neighborhood
Farmers Market" or codes used by permittees to track work
PROJECT_DESCRIPTION
VARCHAR2(2000)
Long form description
of the work to be performed under this permit. Details of the location and
nature of the work may be recorded, but not structured in any particular
order. If the details recorded exceed 2000 charecters, information may be cut
off
PERMIT_IS_ARTERIAL
VARCHAR2(2)
Y/N flag whether the
permit is considered Arterial for billing purposes. An Arterial permit has
impacts to ROW on an arterial street.
APPLICANT_NAME
VARCHAR2(255)
The name of the party
financially responsible for this permit. May be blank if the permit is issued
to a company without a specific name given
APPLICANT_COMPANY
VARCHAR2(255)
Name of the company
or organization to which this permit is issued. May be blank if this permit
is paid for by an individual not acting on behalf of an organization
APPLICANT_ID
VARCHAR2(20)
Summit billing ID
used to track bills against this permit in external financial system
INSPECTION_DISCIPLINE
VARCHAR2(20)
Category of the
inspection team assigned to this type of permit.
INSPECTION_DISTRICT
VARCHAR2(10)
District names within
the set of district names for this inspection discipline. Inspection
districts may have the same name as another of in a different discipline, but
may have different boundaries
REVIEW_DISCIPLINE
VARCHAR2(20)
Category of the
reviews team assigned to this type of permit.
REVIEW_DISTRICT
VARCHAR2(10)
Name of the review
district in which this permit resides. Review districts may have the same
name as another from a different discipline, but may have different
boundaries
MAF_ID
NUMBER(10)
Master Address
Identifier for addresses in the
SOURCE
VARCHAR2(7)
"Hansen7"
for permits from legacy Hansen 7 system. "Accela" for application
in current system
LAST_MODIFIED
DATETIME2
Date that this permit
was last modified
USE_KEY
VARCHAR2(20)
Unique key for this
use space record
USE_CODE
VARCHAR2(3)
Code valued value for
the type of use
USE_SPACE_CODE
VARCHAR2(1)
Code used to maintain
record of spaces that are reissued over the lifecycle of a project.
USE_TYPE
VARCHAR2(100)
Type of activity
performed under this use
USE_DESCRIPTION
VARCHAR2(510)
Description of the
specific activity or area of right-of-way impacted by this use
USE_ISSUED_DATE
DATETIME2
The date this use was
issued to the applicant. Use issuance is part of the issuance of a permit,
and new uses are created and issued as the scope of the permit changes
USE_START_DATE
DATETIME2
The date on which
this use becomes valid. If work is performed or right of way impacted prior
to this date it is out of compliance with the permit
USE_END_DATE
DATETIME2
The date on which
this use stops being valid. If work is perfomed a day after this date, it is
considered out of compliance with the permit
MOBILITY_TYPE
VARCHAR2(100)
Type or types of
impacted right of way. A use space may impact one or more types if the
affected area includes muliple types dedicated to different needs.
CLOSURE_TYPE
VARCHAR2(50)
The effect of this
use space on the right of way impacted. A lane may be partially or fully
closed, or may remain open and the space used only to pass trucks through
STREET_SIDE
VARCHAR2(12)
The cardinal/ordinal
side of the street on which this use space is permitted
ARTERIAL
VARCHAR2(20)
The category of the
street on which this use is permitted.
IMPACT_TRAVEL_LANE
VARCHAR2(50)
The impact this use
space has to Travel Lanes. Travel lanes are those lanes which may be used by
any form of vehicle, including turn lanes.
IMPACT_SIDEWALK
VARCHAR2(50)
The impact this use
space has to dedicated pedestrian walkways, usually sidewalks
IMPACT_BIKE_LANE
VARCHAR2(50)
The impact this use
space has to dedicated bike lanes.
IMPACT_PARKING
VARCHAR2(50)
The impact this use
space has to dedicated parking lanes
IMPACT_OTHER
VARCHAR2(50)
The impact this use
space has to other types of Right of Way such as planting strips, shoulders,
or medians
AREA_SQFT
NUMERIC
The square footage of
the area covered by this use space
DURATION
NUMERIC
The duration in days
for this activity
RATE_START_DAYS
NUMERIC
For reissued uses,
the total elapsed days given to this use space before this use space duration
is in effect.
WORK_DAYS
VARCHAR2(20)
USE_DAY
VARCHAR2(21)
If applicable, the
day of week for which this use space is in effect
USE_START_TIME
VARCHAR2(5)
If applicable, the
time of day at which this use may begin
USE_END_TIME
VARCHAR2(5)
If applicable, the
time of day at which the use must end
EXPECTED_ATTENDEES
NUMERIC
The number of
attendees expected for this use, if the use is a form of public event such as
a block party
FEE_KEY
NUMERIC
Key to an external
fee record assessed for this use
STREET_KEY
NUMERIC
Key of the street
segment record on which this use takes place
STREET_ID
Key for a named
street aka UNITID
SEGMENT_ID
Key for a segment of
a named street aka UNITID2