About this Dataset

Urban Tree Canopy By Census Block In 2020

These data represent Census Blocks 2020 in Washington, DC. Urban tree canopy (UTC) and possible planting area (PPA) metrics have been calculated for Census Blocks 2020 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:39:07.150836
Tags: census-block, 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_census_block_in_2020.table_1

1.48 MB
6,012 rows
70 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "statefp20" BIGINT,
  "countyfp20" BIGINT,
  "tractce20" BIGINT,
  "blockce20" BIGINT,
  "geoid20" BIGINT,
  "name20" VARCHAR,
  "mtfcc20" VARCHAR,
  "funcstat20" VARCHAR,
  "aland20" BIGINT,
  "awater20" BIGINT,
  "intptlat20" DOUBLE,
  "intptlon20" DOUBLE,
  "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,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);