About this Dataset

Urban Tree Canopy At Parcel Level In 2020

These data represent Common Ownership Lots in Washington, DC. Urban tree canopy (UTC) and possible planting area (PPA) metrics have been calculated for Common Ownership 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:40:10.217230
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_at_parcel_level_in_2020.table_1

22.12 MB
137,200 rows
63 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "res" VARCHAR,
  "par" VARCHAR,
  "lot" VARCHAR,
  "ssl" VARCHAR,
  "proptype" VARCHAR,
  "usecode" VARCHAR,
  "landarea" BIGINT,
  "premiseadd" VARCHAR,
  "ownername" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "citystzip" VARCHAR,
  "assessment" BIGINT,
  "annualtax" DOUBLE,
  "ownname2" 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,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);