About this Dataset

Combined Tree Point

Displays Combined Tree Point maintained by the Seattle Department of Transportation. This is a presentation view of 5 contributing datasets from 4 city departments. Contributing datasets:

SDOT: SDOT.V_TREES
SPR: DPR.TREES_PT
SDCI: DPD.Trees
SPU: UTIL.URBAN_TREE_PT
SPU: UTIL.TFN_Planting_Location

This is a redacted view and is intended for public use.

Refresh Cycle: Weekly

Feature Class: SDOT.COMBINED_TREE_PT
Organization: City of Seattle
Last updated: 2025-02-28T23:49:04.773173
Tags: combined-tree-point, common-data-layers, sdot, seattle-gis-open-data, transportation, trees

Tables

Table 1

@usgov.city_of_seattle_combined_tree_point.table_1

18.08 MB
224780 rows
16 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "sdot_unit_id" VARCHAR,
  "spr_unit_id" DOUBLE,
  "sdci_unit_id" VARCHAR,
  "spu_tree_unit_id" VARCHAR,
  "spu_planting_unit_id" VARCHAR,
  "pest_unit_id" VARCHAR,
  "source_department" VARCHAR,
  "scientific_name" VARCHAR,
  "common_name" VARCHAR,
  "dbh" DOUBLE,
  "ownership" VARCHAR,
  "unit_description" VARCHAR,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);