About this Dataset

Urban Tree Canopy By Ward In 2020

These data represent Wards 2012 in Washington, DC. Urban tree canopy (UTC) and possible planting area (PPA) metrics have been calculated for Wards within the study area. UTC results provided in vector format with attribute fields (area/percent metrics/percent change metrics) for each land cover class and UTC type (UTC, PPA, Unsuitable UTC, UTC Change).
Organization: District of Columbia
Last updated: 2024-04-30T18:30:51.288718
Tags: district-of-columbia, environment, planning, possible-planting-area, ppa, urban-tree-canopy, utc, washington-dc

Tables

Table 1

@usgov.district_of_columbia_urban_tree_canopy_by_ward_in_2020.table_1

50.93 kB
8 rows
70 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ward" BIGINT,
  "name" VARCHAR,
  "ward_id" BIGINT,
  "label" VARCHAR,
  "gid" BIGINT,
  "total_ac" DOUBLE,
  "land_ac" DOUBLE,
  "tcan_ac" DOUBLE,
  "tcan_pct" DOUBLE,
  "veg_ac" DOUBLE,
  "veg_pct" DOUBLE,
  "bld_ac" DOUBLE,
  "bld_pct" DOUBLE,
  "to_ia_ac" DOUBLE,
  "to_ia_pct" DOUBLE,
  "road_ac" DOUBLE,
  "road_pct" DOUBLE,
  "plot_ac" DOUBLE,
  "plot_pct" DOUBLE,
  "swalk_ac" DOUBLE,
  "swalk_pct" DOUBLE,
  "ot_ia_ac" DOUBLE,
  "ot_ia_pct" DOUBLE,
  "wat_ac" DOUBLE,
  "wat_pct" DOUBLE,
  "soil_ac" DOUBLE,
  "soil_pct" DOUBLE,
  "utc_ac" DOUBLE,
  "utc_pct" DOUBLE,
  "ppa_v_ac" DOUBLE,
  "ppa_v_pct" DOUBLE,
  "to_ppa_ac" DOUBLE,
  "to_ppa_pct" DOUBLE,
  "ppa_ia_ac" DOUBLE,
  "ppa_ia_pct" DOUBLE,
  "un_v_ac" DOUBLE,
  "un_v_pct" DOUBLE,
  "to_un_ac" DOUBLE,
  "to_un_pct" DOUBLE,
  "un_ia_ac" DOUBLE,
  "un_ia_pct" DOUBLE,
  "un_sl_ac" DOUBLE,
  "un_sl_pct" DOUBLE,
  "wtr_ac" DOUBLE,
  "wtr_pct" DOUBLE,
  "utc_ac_06" DOUBLE,
  "utc_pct_06" DOUBLE,
  "utcac0620" DOUBLE,
  "utcpct0620" DOUBLE,
  "utc_ac_11" DOUBLE,
  "utc_pct_11" DOUBLE,
  "utcac1120" DOUBLE,
  "utcpct1120" DOUBLE,
  "utc_ac_15" DOUBLE,
  "utc_pct_15" DOUBLE,
  "utcac1520" DOUBLE,
  "utcpct1520" DOUBLE,
  "enrgy_con" DOUBLE,
  "strm_wtr" DOUBLE,
  "uhi" DOUBLE,
  "land_own" DOUBLE,
  "wldlf_con" DOUBLE,
  "overall" DOUBLE,
  "low_utc" DOUBLE,
  "pos_utc" DOUBLE,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);