About this Dataset

Landscape Complexes

Displays landscape complexes maintained by the Seattle Department of Transportation.

View Layer: Link, which adds the recommended filter for general use of the dataset: 'CURRENT_STATUS NOT IN (REMOVED)'

Refresh Cycle: Daily

Feature Class: SDOT.V_LANDSCPCOMPLX
Organization: City of Seattle
Last updated: 2025-02-28T23:51:43.175062
Tags: common-data-layers, landscape-complexes, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_landscape_complexes.table_1

72.07 kB
609 rows
41 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" DOUBLE,
  "unitid" VARCHAR,
  "comptype" DOUBLE,
  "hansegkey" DOUBLE,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "unitdesc_seg" VARCHAR,
  "install_date" VARCHAR,
  "adddttm" VARCHAR,
  "moddttm" VARCHAR,
  "expdate" VARCHAR,
  "sector" VARCHAR,
  "sectordesc" VARCHAR,
  "subarea" VARCHAR,
  "subareadesc" VARCHAR,
  "areasz" DOUBLE,
  "areaum" VARCHAR,
  "maint_by" VARCHAR,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "ownership" VARCHAR,
  "lstverify" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "attachment_1" VARCHAR,
  "attachment_2" VARCHAR,
  "attachment_3" VARCHAR,
  "attachment_4" VARCHAR,
  "attachment_5" VARCHAR,
  "attachment_6" VARCHAR,
  "attachment_7" VARCHAR,
  "attachment_8" VARCHAR,
  "attachment_9" VARCHAR,
  "num_attachments" BIGINT,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);