USDA Forest Service (2023). USFS NLCD Percent Tree Canopy (CONUS) v2021-4 [gis dataset]. Multi-Resolution Land Characteristics Consortium, Sioux Falls, SD. last updated: 2024-12-02 (update frequency: Never). NLCD tree canopy cover is a 30 m raster geospatial dataset that is available for the conterminous United States. They are generated by the USDA Forest Service. These data contain percent tree canopy estimates, as a continuous variable, for each pixel across all land covers and types. Tree canopy cover is derived from multi-spectral satellite imagery and other available ground and ancillary information. Key words: tree density, tree canopy cover, percent tree canopy, Landsat, Sentinel-2, CONUS, United States Open Geospatial Consortium Standards: Analytical Functions:

gdsc_zonal_statistics( table, lat, lng, radius )

ETL documentation

ETL for us_2021_nlcd_tcc_v4

######### # GDSC ETL is performed in two steps: shell script to ETL data into postgres # and then additional transformations with SQL in postGIS (if needed). #### ######### # Step 1 - bash script (pseudo code) #### # create directory structure and move into it mkdir -p /data/us_2021_nlcd_tcc_v4/download -p /data/us_2021_nlcd_tcc_v4/etl chmod -R 777 /data/us_2021_nlcd_tcc_v4 cd /data/us_2021_nlcd_tcc_v4 # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # unzip to download directory if update flag is set if do_update == 1 then unzip -o download/us_2021_nlcd_tcc_v4.zip -d download && rm download/us_2021_nlcd_tcc_v4.zip 2>&1 # load raster into postGIS with: raster2pgsql -s 5070 -d -C -I -t 256x256 nlcd_tcc_conus_2021_v2021-4.tif -F us_2021_nlcd_tcc_v4 > load_raster.sql psql < load_raster.sql rm load_raster.sql