About this Dataset

DC Tree Structure And Benefits

DC 2022 LiDAR was used and processed using the “Extract Trees using Cluster Analysis” script which is included as part of Esri’s 3D Basemap solution. All LiDAR-derived trees within 2 meters of a Urban Forestry Division tree were removed as being duplicates.

Tree diameter (DBH, in inches) was estimated for the LiDAR-derived trees from calculated tree height (in feet) based on the equation: DBH = 0.4003*height - 1.9557. This equation was derived from a statistical analysis of a detailed park inventory tree data set and has an R^2 = 0.7418.

Extreme outliers were also modified, with any DBH larger than 80 inches being converted to a DBH of 80 inches.

The combined data set was processed using the USDA Forest Service i-Tree eco software, where structure and environmental benefits were estimated.
Organization: District of Columbia
Last updated: 2024-04-30T18:05:21.313283
Tags: dc, dc-trees, environmental-benefits, estimate-trees, extracted-trees, urban-forestry, washington

Tables

Table 1

@usgov.district_of_columbia_dc_tree_structure_and_benefits.table_1

169.42 MB
1,985,917 rows
41 columns

CREATE TABLE table_1 (
  "nlcd_land_cover" VARCHAR,
  "icode" VARCHAR,
  "status" VARCHAR,
  "tree_id" BIGINT,
  "smd_id" VARCHAR,
  "anc_id" VARCHAR,
  "arborist" VARCHAR,
  "ownership" VARCHAR,
  "dbh" DOUBLE,
  "height" BIGINT,
  "crown_height" DOUBLE,
  "crown_width" DOUBLE,
  "canopy_cover" DOUBLE,
  "leaf_area" DOUBLE,
  "leaf_biomass" DOUBLE,
  "leaf_area_index" DOUBLE,
  "basal_area" DOUBLE,
  "replacement_value" DOUBLE,
  "carbon_storage" DOUBLE,
  "carbon_storage_cost" DOUBLE,
  "gross_carbon_sequestration" DOUBLE,
  "gross_carbon_seq_cost" DOUBLE,
  "avoided_runoff" DOUBLE,
  "avoided_runoff_cost" DOUBLE,
  "pollution_removal" DOUBLE,
  "pollution_removal_cost" DOUBLE,
  "total_annual_benefits" DOUBLE,
  "carbon_avoided" DOUBLE,
  "carbon_avoided_cost" DOUBLE,
  "energy_savings" DOUBLE,
  "forest_patch_type" VARCHAR,
  "forest_patch_id" DOUBLE,
  "genus_name" VARCHAR,
  "common_name" VARCHAR,
  "scientific_name" VARCHAR,
  "ward_id" DOUBLE,
  "dc_hpn_code" VARCHAR,
  "tract_2010" DOUBLE,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "objectid" BIGINT
);