SDOT.V SU PERMIT USE IMPACT DISS by US Government | Demographics and Population Studies

About this Dataset

SDOT.V SU PERMIT USE IMPACT DISS

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:34:19.366425
Tags: permit-data-model, sdot, seattle-gis-open-data, street-use

Tables

Table 1

@usgov.city_of_seattle_sdot_v_su_permit_use_impact_diss.table_1

32.8 MB
181924 rows
18 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "permit_number" VARCHAR,
  "address" VARCHAR,
  "permit_type_alias" VARCHAR,
  "permit_category" VARCHAR,
  "permit_type" VARCHAR,
  "permit_subtype" VARCHAR,
  "permit_stage" VARCHAR,
  "received_date" VARCHAR,
  "first_issued_date" VARCHAR,
  "last_issued_date" VARCHAR,
  "next_expiration_date" VARCHAR,
  "project_description" VARCHAR,
  "applicant_name" VARCHAR,
  "applicant_company" VARCHAR,
  "concatenate_use_code" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "shape_length" DOUBLE
);