SDOT.V SU PERMITS by US Government | Demographics and Population Studies

About this Dataset

SDOT.V SU PERMITS

An updated Permit Data Model that includes relationships between the component feature classes. The Dissolved Use Impacts (SDOT.V_SU_PERMIT_USE_IMPACT_DISS) feature class is derived from dissolving the Use Impacts (SDOT.V_SU_PERMIT_USE_IMPACTS) feature class by Permit Number. The Impacts feature class is the Use Impact street line segments that are associated with any give Permit point (V_SU_PERMITS). The relationships connect the Permit points to the Dissolved Use Impacts and then the Dissolved Use Impacts to the component Use Impacts. This data model allows you to see all impacted street line segments associated with any given Permit easily, while also being able to drill down to any specific Use Impact for a given Permit.

Service is constructed for use in the Right of Way Map.

Data set to Nightly Refresh.

Any Questions or Concerns contact the SDOT Street Use Data and GIS Team: Craig Moore/Bryan Bommersbach
Organization: City of Seattle
Last updated: 2025-02-28T23:27:45.694581
Tags: permit-data-model, sdot, seattle-gis-open-data, street-use

Tables

Table 1

@usgov.city_of_seattle_sdot_v_su_permits.table_1

85.21 MB
436795 rows
37 columns


CREATE TABLE table_1 (
  "objectid" 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" VARCHAR,
  "first_issued_date" VARCHAR,
  "last_issued_date" VARCHAR,
  "next_expiration_date" VARCHAR,
  "project_name" VARCHAR,
  "project_description" VARCHAR,
  "permit_is_arterial" VARCHAR,
  "applicant_name" VARCHAR,
  "applicant_company" VARCHAR,
  "applicant_id" VARCHAR,
  "contact_name" VARCHAR,
  "contact_phone" VARCHAR,
  "inspection_discipline" VARCHAR,
  "inspection_district" VARCHAR,
  "review_discipline" VARCHAR,
  "review_district" VARCHAR,
  "sdci_permits" VARCHAR,
  "sdot_permits" VARCHAR,
  "dependent_permits" VARCHAR,
  "maf_id" DOUBLE,
  "source" VARCHAR,
  "last_modified" VARCHAR,
  "created_by" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);