About this Dataset

Urban Tree Canopy By DC Owned Property In 2020

These data represent DC Owned Lots in Washington, DC. Urban tree canopy (UTC) and possible planting area (PPA) metrics have been calculated for DC Owned Lots 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-30T17:38:49.266705
Tags: dc, ddot, district-of-columbia, environment, land-cover, naip, possible-planting-area, ppa, tree-canopy, tree-cover, ufd, urban-forestry, utc, washington-dc

Tables

Table 1

@usgov.district_of_columbia_urban_tree_canopy_by_dc_owned_pro_5aed8eea.table_1

1 MB
4,234 rows
75 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "mar_id" BIGINT,
  "address" VARCHAR,
  "agency" VARCHAR,
  "ownername" VARCHAR,
  "ownername2" VARCHAR,
  "assessment" VARCHAR,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "res" VARCHAR,
  "par" VARCHAR,
  "lot" VARCHAR,
  "ssl" VARCHAR,
  "lot_sf" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "sitename" VARCHAR,
  "proptype" 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_15" DOUBLE,
  "utc_pct_15" DOUBLE,
  "utcac1520" DOUBLE,
  "utcpct1520" DOUBLE,
  "utc_ac_11" DOUBLE,
  "utc_pct_11" DOUBLE,
  "utcac1120" DOUBLE,
  "utcpct1120" DOUBLE,
  "utc_ac_06" DOUBLE,
  "utc_pct_06" DOUBLE,
  "utcac0620" DOUBLE,
  "utcpct0620" DOUBLE,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);