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 County Distance to Water [gis dataset]. University of Miami. https://doi.org/10.17604/p318-6n41. last updated: 2024-10-28 (update frequency: Never). Abstract: A raster of the euclidean distance from bodies of water within Miami-Dade County. Key words: Miami-Dade County Open Geospatial Consortium Standards: | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_zonal_statistics(table=mdc_distance_to_water,lat=25.718,lng=-80.279,radius=500) ETL documentation

ETL for mdc_distance_to_water

######### # 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_distance_to_water/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/Water_Euclid_Dist_30m_MDC.tif -F -t 256x256 mdc_distance_to_water > load_raster.sql psql < load_raster.sql rm load_raster.sql