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: 2025-05-08 (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: raster tiles | raster tile url: https://gdsc.idsc.miami.edu/rastertiles/mdc_distance_to_water/{z}/{x}/{y}.png | 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 # create color raster mkdir -p /tiles/raster/mdc_distance_to_water mkdir -p /data/mdc_2021_hylo/mdc_distance_to_water/derived cd /data/mdc_2021_hylo cat > /data/mdc_2021_hylo/mdc_distance_to_water/derived/mdc_distance_to_water_color_ramp.txt <<_EOF 0 171 198 230 255 150 171 198 230 230 330 171 198 230 199 525 171 198 230 166 720 171 198 230 133 915 171 198 230 99 1110 171 198 230 66 1305 171 198 230 33 1500 171 198 230 0 _EOF gdaldem color-relief download/GeoTIFF_Rasters/Water_Euclid_Dist_30m_MDC.tif /data/mdc_2021_hylo/mdc_distance_to_water/derived/mdc_distance_to_water_color_ramp.txt /data/mdc_2021_hylo/mdc_distance_to_water/derived/mdc_distance_to_water_color.tif -alpha # create color raster and render raster tiles mkdir -p /data/mdc_2021_hylo/mdc_distance_to_water/derived mkdir -p /tiles/raster/mdc_distance_to_water cd /data/mdc_2021_hylo echo "iVBORw0KGgoAAAANSUhEUgAAAF0AAACrCAYAAAAEupDHAAAJLklEQVR4nO2dXUhUXRfH10iWzvjxvIU0I2aFaQraB1kZSUVCoCUJKURYXoQ3hZFSXRllJBV6lUEXdhVRWJagVKIhSeUD5ZWlfb2FlR+h42fpZKbrZW9e53H8GOWMz1mzZ9YvjnrOnjkT/7PO2uusvddsAyIiMLrio+/HMSw6ESw6ASw6ASw6ASw6ASw6ASw6ASw6ASw6ASw6ASw6ASy6N4o+OjoK3pbo1CS61WoFg8Fg35YsWQLr1q2DBw8e2F/T2NgIa9ascXqe8fFx2LBhA4yMjIBXgRro7u4Wpol9fX1yf2hoCO/fv48mkwnr6urmfZ7R0VF5HpvNht7Egog+wdmzZ3HPnj3y71evXmFERIT8+/fv35iVlYVBQUG4evVqLCwslMe3bt0qzyO2zs5OvHLlCkZFReHixYsxOjoa6+vr7eeKj4/H9PR0DA4OxvXr12NTU5P9c8UFj4yMRKPRiMnJyWi1WuXx2tpajIuLk58r3tvb24seJ/qLFy8wICBgmui3b9/GpKQkHBgYwE+fPqHZbMY3b944WHpDQ4O8IK2trfLOOXXqFO7atct+LvG6kpIS7O/vx2PHjuG+fftk2+fPn+Ud9vDhQ+zp6cGjR4/Krb29HQMDA7GiokK+JycnBw8dOoQeJ/rbt2/RYDDg2NiYg+iVlZVosVjw+vXr2NbWNqd76erqwuLiYoyNjZX74lxLly61t4sLFBMTI/8WFyItLW3a//HatWuYmppq3xcX0tfXF0dGRpCaBY1eRAcbGhoKPj6Op01NTYWTJ0/C5cuXYcWKFZCSkgJ9fX3TopicnBwICQmBqKgouHPnjkNUI45P4OvrKzthQXd3tzznVNra2qCqqsre2ZtMJvkZX79+BWoWVPTa2loZjczEmTNnoLW1FZqamuTFuXnzpkN7aWkpNDQ0wMuXL+UFOX/+/Lw+02KxQHt7+7TjZrMZDh8+LC/c5G2uiEoZ0YeHh6GsrAyuXr0qxZ1KUVER7N+/X4ppNpulpQYEBMCiRYvkXdHV1QW9vb0QGBgIy5Ytgw8fPkjR5xNK7t27F548eSK3/v5+uHjxoryz0tLSoLKyEqqrq2FwcBBu3Lgh7whh7eS44tMnNtFhbdu2Daurq+2vmezThc8WnZiIIgIDAzE7O1tGNAJxXEQrz58/lx2niEA2btyIZWVl6Ofnh4ODg/Jca9eudTj35H3RZ4hoR7xXRE8T/cajR49kv+Dv74+bN2/GxsZGdAcM4gf1hfc2yNMA3giLTgCL7m2ij3phhtEl0fPy8sDPzw+ysrI0vX/cWzOMAKA5egkKCoKnT59K4aY+gc6HP3/+yHjdZrPJi+dNaLL0sLAw+PHjB2zatEk+gIgHE5FPDw4OhoyMDIdH/NnaEhMT5W9/f3/4/v07eBVaA3yR2RPpWGfZPGdto16aSxe4LLqzbJ6ztlEvFn2Rq3fK5GzeZEQ2z1nbqlWrwFtxOWR0ls1z50wfKa66FzHSI4bQHj9+LEeGSktLMSwsTCa0nLUJfHx88MuXL3LQw5twWfS5snnO2g79P8PY3NyM3gRnGQng3AsBLDoBLDoBLDoBLDoBLDoBLDoBLDoBLDoBLDoBLDoByopeX18PMTExYDQa4ciRI0oNcCsp+vDwsBxvFZNFv337Zp84qgyoIFVVVZiQkGDfF6Uw4eHhqApKWvrHjx8hOjravi+KCMQQ4NDQEKiApjHS8r87QQ/St1lmPP7z50/pyycQJZViHFbMoREVFx4p+pRxZt0xGo1S4AlEJyrGYlQQXKDJvRh02mZDuBPhYiZ4//69nAAlJi6pgDafLkxdj20Wdu/eDe/evYN79+5BT08P5Ofnw8GDB0EVlLR0k8kEFRUVcOHCBVi5cqWcC1lQUACqoM2nAz2JiYnw+vVrUBFtM7zcQXWFUdbSVUZjyMiyu4KST6Sqo+TDkeqwTyeAoxcC2Ker417Y1F2BO1ICuCMlgB+OCGBLJ4B9OgEcpxPAISMB7F4I4I6UALZ0ArgjJYATXgRw9EIA+3QCWHQC2L0oM62Odiqj5MSJEw4r0MTHx8+rNMYdymaUnMsoaGlpgZqaGvtXVIklfuYqjXGXshllLb2lpQXi4uKmHa+rq4OIiAg4cOCA/AL8wsJC+6oEztoUsHR9/s2GsFCxxINwD2LFgR07dsg56nOVxrhL2YySlt7c3Cx98rlz56CjowO2bNkirVe4GWelMc7a9ETJkHH79u3S2icQq8qUlJRIq3VWGuMuZTNKupeZvhJ8bGxMFgc4K41xl7IZjeUvtOFLeXk5REZGyuV7BgYGIDc3F3bu3AnLly93WhrjLmUzSia80tPT5TebJicny285FeHfrVu35iyNcZeyGU3fy/jyv//403+TLWv+Ak+ER44I4MlGBLClE6BknK46LDoBnE8ngC2dAO5ICWBLJ4DjdAKUzL2oDotOAPt0AtinE8AhIwHsXghg0Qng3AsBbOkEcEdKAIeMBLB7IYDdCwFc0kiA8gmv06dPywmkk9FaiaFXlYbGqdIGXTZn/Pr1C/Ly8qC4uNjhuNZKDD2rNJQtf8nOzoa2tjbIzMxckEoMPas0lCwKEBQVFcHdu3chODgYJqO1EkPPKg1lLd1sNs94XGslhp5VGh73cGTUWImhZ5WGsu5lNrRWYuhZpaGse5kNrZUYelZpeJylmzRWYuhZpaGpEuN7nz6l3eb/LAFPhBNeBLDoyiS8OOPl3QkvFWH3QgCLTgCPHBHgcbkXFWBLJ4B9OgEsOgE8l5EAnoJBALsXAti9EMCWTgAnvAjghyMC2L0QwLkXAti9EMDuhQC2dALYpxPAuRcClJ/LeHqG8he3X6QENTA2rs/mDJvNhrm5uWJKIF66dMmhLSkpCWtqaqa9Z2hoCENCQrC8vBytViumpqZifn7+nG0LjSbRx3XanJGZmYkZGRny91TRLRYLdnZ2TntPVVUVJiQk2PebmpowPDx8zraFRln3UjRL+YsKi5Qom/Ayz1L+osIiJRrnMrov2xVYpERZS1d5kRKPE71chUVKUHGOHz8+LXopKCjA0NBQ9PPzw5SUFOzo6LC3PXv2DGNjY9FkMsnoR4SK82lbSDSVvzCu4XHuRQVYdAJYdAJYdAJYdAJYdAJYdNCf/wFW9fN9LlIa0gAAAABJRU5ErkJggg==" | base64 -d > /data/mdc_2021_hylo/mdc_distance_to_water/derived/mdc_distance_to_water_legend.png cp /data/mdc_2021_hylo/mdc_distance_to_water/derived/mdc_distance_to_water_legend.png /tiles/raster/mdc_distance_to_water/ # render raster tiles cd /data/mdc_2021_hylo/mdc_distance_to_water/ gdal2tiles.py -ex --xyz -z 8-16 /data/mdc_2021_hylo/mdc_distance_to_water/derived/mdc_distance_to_water_color.tif /tiles/raster/mdc_distance_to_water