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). 2021 Miami-Dade NDVI [gis dataset]. University of Miami. https://doi.org/10.17604/p318-6n41. last updated: 2024-05-01 (update frequency: Never). Abstract: Greenness (measured with NDVI-Normalized Difference Vegetation Index). Key words: Florida, Miami-Dade County, MDC, Miami-Dade County, Environment, NDVI, Hylo, Homestead, Little River, Public-Safety Open Geospatial Consortium Standards: | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_zonal_statistics(table=mdc_2021_NDVI_greenness_30m,lat=25.718,lng=-80.279,radius=500) ETL documentation

ETL for mdc_2021_NDVI_greenness_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_ndvi_greenness_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/Greenness_30m_MDC.tif -F -t 256x256 mdc_2021_NDVI_greenness_30m > load_raster.sql psql < load_raster.sql rm load_raster.sql