SDOT Trees by US Government | Transportation and Logistics

About this Dataset

SDOT Trees

Listing of both publicly and privately maintained trees in the public right of way, with information on the condition, location, size, species and maintenance responsibility. Data was collected with the intent to predict maintenance needs, as well as to show the level of diversification within the street tree population.

Displays trees maintained by the Seattle Department of Transportation.

Views: Link, adds recommended definition query for general use: 'CURRENT_STATUS = INSVC'

Refresh Cycle: Daily

Feature Class: SDOT.V_TREES
Organization: City of Seattle
Last updated: 2025-02-28T23:33:40.236382
Tags: common-data-layers, sdot, seattle-gis-open-data, transportation, trees

Tables

Table 1

@usgov.city_of_seattle_sdot_trees.table_1

15.26 MB
256913 rows
56 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "current_status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "unittype" VARCHAR,
  "ownership" VARCHAR,
  "current_status_date" VARCHAR,
  "last_verify_date" VARCHAR,
  "planted_date" VARCHAR,
  "botanical_name" VARCHAR,
  "scientific_name" VARCHAR,
  "heritage" VARCHAR,
  "exceptional" VARCHAR,
  "codereq" VARCHAR,
  "gsi" VARCHAR,
  "green_factor" VARCHAR,
  "wires" VARCHAR,
  "cabled" VARCHAR,
  "clearance_problem" VARCHAR,
  "spacetype" VARCHAR,
  "sitetype" VARCHAR,
  "growspace" DOUBLE,
  "diam" DOUBLE,
  "condition_rating" DOUBLE,
  "funding_source" VARCHAR,
  "water_through_yr1" BIGINT,
  "water_through_yr2" BIGINT,
  "water_through_yr3" BIGINT,
  "ownerdiam" VARCHAR,
  "expdate" VARCHAR,
  "common_name" VARCHAR,
  "treeheight" DOUBLE,
  "asbuiltplanno" VARCHAR,
  "landscapeareaassoc" BIGINT,
  "comments" VARCHAR,
  "overridecomment" VARCHAR,
  "shape_lng" VARCHAR,
  "shape_lat" VARCHAR,
  "irrigatesysyn" VARCHAR,
  "assetgroupid" VARCHAR,
  "assetgroupdesc" VARCHAR,
  "moddate" VARCHAR,
  "total_rank" DOUBLE,
  "total_count" DOUBLE,
  "genus" VARCHAR,
  "ufmaintmgmtunit" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);