UM Geospatial Digital Special Collections

Citation: Multi-Resolution Land Characteristics Consortium (2023). 2021 Miami-Dade NLCD Impervious Surfaces [gis dataset]. Multi-Resolution Land Characteristics Consortium. https://doi.org/10.1016/j.rse.2021.112357. last updated: 2024-05-01 (update frequency: Never). Abstract: NLCD Urban Imperviousness is a 30 m raster geospatial dataset that is available for the conterminous United States. They are generated by the U.S. Geological Survey (USGS), in partnership with several federal agencies. These data provide spatially explicit and reliable information on the Nation’s land cover and land cover change. NLCD imperviousness products represent urban impervious surfaces as a percentage of developed surface over every 30-meter pixel in the United States. Key words: Land cover , Land cover change, Landsat, NLCD, CONUS, Florida, Miami-Dade Open Geospatial Consortium Standards: | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_zonal_statistics(table=mdc_2021_nlcd_impervious_surfaces,lat=25.718,lng=-80.279,radius=500) ETL documentation

ETL for mdc_2021_nlcd_impervious_surfaces

######### # 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/mdc_2021_nlcd_impervious_surfaces/{download,etl} && cd /data/mdc_2021_nlcd_impervious_surfaces # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # load us_2021_nlcd_impervious_surfaces as dependency (see us_2021_nlcd_impervious_surfaces for details). # clip raster with geometry as: gdalwarp -cutline PG:"" -csql "SELECT geom FROM fl_2022_tl_cousub WHERE countyfp='086'" -crop_to_cutline -s_srs '+proj=aea +lat_0=23 +lon_0=-96 +lat_1=29.5 +lat_2=45.5 +x_0=0 +y_0=0 +datum=WGS84 +units=m +no_defs' -t_srs EPSG:4326 /data/us_2021_nlcd_impervious_surfaces/download/nlcd_2021_impervious_l48_20230630.img download/mdc_2021_nlcd_impervious_surfaces.tif ######### # Step 2 - SQL script (pseudo code): #### # load raster into postGIS with: raster2pgsql -s 4326 -d -C -I mdc_2021_nlcd_impervious_surfaces.tif -F -t 256x256 mdc_2021_nlcd_impervious_surfaces > load_raster.sql psql < load_raster.sql rm load_raster.sql