About this Dataset

Urban Tree Canopy By Census Block Group In 2020

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

284.65 kB
571 rows
79 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "statefp" BIGINT,
  "countyfp" BIGINT,
  "tractce" BIGINT,
  "blkgrpce" BIGINT,
  "geoid" BIGINT,
  "namelsad" VARCHAR,
  "mtfcc" VARCHAR,
  "funcstat" VARCHAR,
  "aland" BIGINT,
  "awater" BIGINT,
  "intptlat" DOUBLE,
  "intptlon" 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,
  "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,
  "field" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);