Tyler Harrison, Amy C Clement, Gina L. Maranto, Sam Purkis, Joanna L. Lombard, Angela C. Clark-Hughes, Abraham K Parrish, Marcus B. Reamer, Olivia Collins, Caroline Lewis, Mayra Cruz, Anaruth Solace (2021). Miami-Dade Surface Temperature (degrees Fahrenheit) [gis dataset]. University of Miami. https://doi.org/10.17604/p318-6n41. last updated: 2026-05-06 (update frequency: Never). Max Landsat 8 ARD (Analysis Ready Data) Surface Temperature from 7 different images ranging from 2011-2020. Key words: Florida, Miami-Dade County, MDC, Miami-Dade County, Environment, Surface Temperature, Climate, Atmospheric Science, Hylo, Homestead, Little River, Public-Safety Open Geospatial Consortium Standards: Analytical Functions:

gdsc_zonal_statistics( table, lat, lng, radius )

ETL documentation

ETL for mdc_2021_surface_temperature_30m

######### # 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_hylo/{download,mdc_2021_surface_temperature_30m/etl} && cd /data/mdc_2021_hylo # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # download if update flag is set: if do_update == 1 then wget -O download/mdc_2021_hylo.zip 'https://scholarship.miami.edu/view/fileRedirect?instCode=01UOML_INST&filePid=13395678880002976&download=true' # unzip to download directory if update flag is set if do_update == 1 then unzip -d download download/mdc_2021_hylo.zip && rm download/mdc_2021_hylo.zip # load raster into postGIS with: raster2pgsql -s 3857 -d -C -I -t 48x48 GeoTIFF_Rasters/Surface_Temperature_30m.tif -F mdc_2021_surface_temperature_30m > load_raster.sql psql < load_raster.sql rm load_raster.sql # Move into corrrect directory and create derivative directory in data package on osgeo cd /data/mdc_2021_hylo/mdc_2021_surface_temperature_30m/ mkdir -p derived # Move into correct directory cd /data/mdc_2021_hylo/mdc_2021_surface_temperature_30m/ # Create pg_dump of table SQL in derivate directory on postgis. pg_dump -h gdsc-postgis-node-kncqy8cvxwgodsls -t mdc_2021_surface_temperature_30m > derived/mdc_2021_surface_temperature_30m.sql # Create downloadable tarfile of SQL in derivative directory on postgis rm -f derived/mdc_2021_surface_temperature_30m.sql.tar.gz tar -czf derived/mdc_2021_surface_temperature_30m.sql.tar.gz meta_dcat_mdc_2021_surface_temperature_30m.json -C derived mdc_2021_surface_temperature_30m.sql