Urban Forestry Street Trees by US Government | Environmental and Climate Sciences

About this Dataset

Urban Forestry Street Trees

DDOT's Urban Forestry Division (UFD) is the primary steward of Washington DC's ~175,000 public trees and has a mission of keeping this resource healthy, safe, & growing. Trees in the city are critical to our well-being. Visit trees.dc.gov for more information.
Organization: District of Columbia
Last updated: 2024-04-30T18:36:19.723733
Tags: canopy, dc, ddot, district-of-columbia, environment, street-tree, terrestrial, tree, washington-dc

Tables

Table 1

@usgov.district_of_columbia_urban_forestry_street_trees.table_1

31.17 MB
218010 rows
50 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "sci_nm" VARCHAR,
  "cmmn_nm" VARCHAR,
  "genus_name" VARCHAR,
  "fam_name" VARCHAR,
  "date_plant" VARCHAR,
  "facilityid" VARCHAR,
  "vicinity" VARCHAR,
  "ward" DOUBLE,
  "tbox_l" DOUBLE,
  "tbox_w" DOUBLE,
  "wires" VARCHAR,
  "curb" VARCHAR,
  "sidewalk" VARCHAR,
  "tbox_stat" VARCHAR,
  "retireddt" VARCHAR,
  "dbh" DOUBLE,
  "disease" VARCHAR,
  "pests" VARCHAR,
  "condition" VARCHAR,
  "conditiodt" VARCHAR,
  "ownership" VARCHAR,
  "tree_notes" VARCHAR,
  "mbg_width" DOUBLE,
  "mbg_length" DOUBLE,
  "mbg_orientation" DOUBLE,
  "max_crown_height" DOUBLE,
  "max_mean" DOUBLE,
  "min_crown_base" DOUBLE,
  "dtm_mean" DOUBLE,
  "perim" DOUBLE,
  "crown_area" DOUBLE,
  "cicada_survey" VARCHAR,
  "oneyearphoto" VARCHAR,
  "specialphoto" VARCHAR,
  "photoremarks" VARCHAR,
  "elevation" VARCHAR,
  "sign" VARCHAR,
  "trrs" DOUBLE,
  "warranty" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_date" TIMESTAMP,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "created" VARCHAR,
  "edited" VARCHAR,
  "shape" VARCHAR,
  "objectid" BIGINT
);