UM Geospatial Digital Special Collections

Citation: 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: 2024-10-28 (update frequency: Never). Abstract: 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: | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_zonal_statistics(table=mdc_2021_surface_temperature_30m,lat=25.718,lng=-80.279,radius=500) 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 GeoTIFF_Rasters/Surface_Temperature_30m.tif -F -t 256x256 mdc_2021_surface_temperature_30m > load_raster.sql psql < load_raster.sql rm load_raster.sql cd /data/mdc_2021_hylo/mdc_2021_surface_temperature_30m/ mkdir -p derived # Create pg_dump and downloadable zip of table in derivate directory pg_dump -d $POSTGRES_DB -U $POSTGRES_USER -p $POSTGRES_PORT -h postgis-k36gj44h1g2r1h6y -t mdc_2021_surface_temperature_30m > derived/mdc_2021_surface_temperature_30m.sql 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