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 Parks [gis dataset]. University of Miami. https://doi.org/10.17604/p318-6n41. last updated: 2025-05-07 (update frequency: Never). Abstract: A raster of the euclidean distance from parks 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_parks/{z}/{x}/{y}.png | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_zonal_statistics(table=mdc_distance_to_parks,lat=25.718,lng=-80.279,radius=500) ETL documentation

ETL for mdc_distance_to_parks

######### # 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_parks/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/Parks_Euclid_Dist_30m_MDC.tif -F -t 256x256 mdc_distance_to_parks > load_raster.sql psql < load_raster.sql rm load_raster.sql # create color raster mkdir -p /tiles/raster/mdc_distance_to_parks mkdir -p /data/mdc_2021_hylo/mdc_distance_to_parks/derived cd /data/mdc_2021_hylo cat > /data/mdc_2021_hylo/mdc_distance_to_parks/derived/mdc_distance_to_parks_color_ramp.txt <<_EOF 0 159 212 140 255 150 158 211 139 230 330 157 210 138 199 525 156 209 136 166 720 155 208 135 133 915 154 207 134 99 1110 152 206 133 66 1305 151 205 131 33 1500 150 204 130 0 _EOF gdaldem color-relief download/GeoTIFF_Rasters/Parks_Euclid_Dist_30m_MDC.tif /data/mdc_2021_hylo/mdc_distance_to_parks/derived/mdc_distance_to_parks_color_ramp.txt /data/mdc_2021_hylo/mdc_distance_to_parks/derived/mdc_distance_to_parks_color.tif -alpha # create color raster and render raster tiles mkdir -p /data/mdc_2021_hylo/mdc_distance_to_parks/derived cd /data/mdc_2021_hylo echo "iVBORw0KGgoAAAANSUhEUgAAAFcAAADzCAYAAADzRYqUAAAKmUlEQVR4nO2dW0hU/xbH10iWOl6gEEcxK0xTjnYhM0PRTkKg5UlIIcLyQPhSKOm/ejLMSDL0vGTQgz0cIgrLEpRKNDxJ5UP5NKXdKMy8hI7XUjPT9ef3gxm8jp7trGnv7frELmf/ZvZM31n7+1t77e3aBkREYEhwodksw+ISw+ISwuISwuISwuISwuISwuISwuISwuISwuISwuISwuLqWdyJiQnQa2FOkbgWiwUMBoNtWbNmDWzduhUePHhge05zczNs3rzZ7nampqZg+/btMD4+DroEFdDb2ytCDQcGBuTjkZERvH//PhqNRmxoaFjydiYmJuR2xsbGUI84RFwr58+fx/3798ufX716hcHBwfLnX79+YWZmJnp7e+OmTZuwqKhIrt+9e7fcjli6u7vxypUrGBoaiqtXr8awsDBsbGy0bSsqKgrT0tLQx8cHt23bhmaz2fa+4osNCQlBDw8PTEpKQovFItfX19djZGSkfF/x2v7+ftSsuC9evEBPT8854t6+fRsTExNxaGgIP336hCaTCd+8eTMjcpuamqTwbW1tck84c+YM7t2717Yt8byysjIcHBzEkydP4sGDB+XY58+f5R7z8OFD7OvrwxMnTsils7MTvby8sKqqSr4mOzsbjx49ipoV9+3bt2gwGHBycnKGuNXV1ejv74/Xr1/Hjo6ORW2hp6cHS0tLMSIiQj4W21q7dq1tXHwR4eHh8mcheGpq6pzPeO3aNUxJSbE9Fl+Yq6srjo+Po7NwaLYgJrqAgABwcZm52ZSUFDh9+jQUFxfD+vXrITk5GQYGBuZkDdnZ2eDr6wuhoaFw586dGVmEWG/F1dVVToaC3t5euc3ZdHR0QE1NjW3SNRqN8j3a29vBWThU3Pr6ejn7z8e5c+egra0NzGaz/BJu3rw5Y7y8vByamprg5cuXUvgLFy4s6T39/f2hs7NzznqTyQTHjh2TX9D0ZbEMRnXijo6OQkVFBVy9elWKOJuSkhI4dOiQFE38p0XkeXp6wqpVq2SU9/T0QH9/P3h5ecG6devgw4cPUtylpGgHDhyAJ0+eyGVwcBAuXbok95TU1FSorq6G2tpaGB4ehhs3bsgIF9HrNJbjudZFTBx79uzB2tpa23NeTfNc4aliMhGztnhuVlaWzCAEYr3IDp4/fy4nMDHj79ixAysqKtDNzQ2Hh4fltrZs2TJj29MfC08X2YV4rchWrL7+6NEj6dvu7u64a9cubG5uRmdiEH8576tcWfzxw189w+ISwuLqVdwJHVfEliVuXl4euLm5QWZmpqLXT+m9IgYAirMFb29vePr0qRRo9hHZUvj9+7fMd8fGxuSXpEcURW5gYCB8//4ddu7cKRN1kcCLeq6Pjw+kp6fPOLR9ssBYXFyc/Nfd3R2+ffsGukRpgiwqUaJMaK/61GlnTO+1XMGyxbVXfbpmZ2wliLtquZE/vfo0nfb2drtjGzduBL2z7FTMXvXJpILK1B9lubYgzhyIUy+PHz+WZxrKy8sxMDBQFmbsjQlcXFzwy5cvsriuR5Yt7mLVp0d2xqwVsZaWFtQjXBUjhGsLhLC4hLC4hLC4hLC4hLC4hLC4hLC4hLC4hLC4hLC4K1ncxsZGCA8PBw8PDzh+/LimTmiqWtzR0VF53k1cXPf161fbhXaaAVVMTU0NxsTE2B6LS/WDgoJQK6g6cj9+/AhhYWG2x+KiaHGKaGRkBLSAonNo/235j0M/xL//8de863/8+CG91or4lSxxPk5c6yCuFFc7yk5QOqm87uHhIYW0IiYzUdvXgrACZbZgcPCyAMIGhDVYef/+vbwgRVxIoltxDQ7+sxD79u2Dd+/ewb1796Cvrw/y8/PhyJEjoBVUPaEZjUaoqqqCixcvwoYNG+Q1ZYWFhaAVFF4UYmdfdjBxcXHw+vVr0CKKxLW3KzPLjVzWdklw5K7UCW2FRi6ji2xh5UXurOttmflhzyWEbYEQntAI4TxXfUdoLO5S4AmNEPZcQjhbIIQjlxD2XLVFLv9u1dLgPJcQFpcQ9lxCuORICOe5hLDnEsKn1gnhyCWEswVCOHIJ4VSMEE7FCOGSIyEcuerzXMd/ED3C2QIhbAuEcCpGCB+hEcKeSwhH7kr93V+twxfiEcKHv4RwnksI57mEcCpGCKdihHDkEsKeSwjbwkrtcSPIycmx3RhZLFFRUbCUVoRqaFOo6u5MgtbWVqirq7Pdeqa5uXnRVoRqaVOo+shtbW2FyMjIOesbGhogODgYDh8+LG/EXFRUZLsLtr0xZ6Jqzx0cHJS3Dhe7tbjDdXx8vOwttlgrQrW0KVR15La0tEjPLCgogK6uLoiOjpbRKOzBXitCe2PORNWpWGxsrIxeK8XFxVBWViaj0F4rQrW0KVRoC06c0WbdynZyclI2b7PXilAtbQpVbQuVlZUQEhICZrMZhoaGIDc3FxISEsDPz89uK0K1tClUdSqWlpYm7wSYlJQk7woo0qpbt24t2opQLW0KFd0P7X/t1Q79EP8M+hfoES7crNQ8V+uwuITwOTRC+OzvSj1C0zpsC4RwKkYIZwuEsOcSwrZACNsCIWwLhHAqRgh7LiF8+EsIX7ZPCNsCITyhEcKpGCE8oRHCtkAIRy4hXFsghG2BEM4WCGFbIISP0AhhWyCEJzRC2BYI4QmNEPZcQtgWCGFbIIRtgRC2BUI4zyWEbYEQLpYTwrZACNsCIZwtEMK2QAhPaITw4S8hbAuEcLZAiGZs4ezZs7KB0HSUdsRzVrc8Vfe4Efz8+RPy8vKgtLQUpqO0I54zu+UpE9fg2MUeWVlZ0NHRARkZGQ7piOfMbnmqb31VUlICd+/eBR8fnxnrlXbEc2a3PNUfoZlMpnnXK+2IZ2/M0U3dVC/uQijtiOfMbnkK+4o50XQXQGlHPGd2y3PRTrPBmSjtiOfMbnmqn9AWQmlHPGd2y1PUEa9t6INDP8RGn1DQI1xbIIRLjoRw4YYQzea5WoA9lxC2BUI0U8/VIuy5hHDkEsLiEsK2QAhnC4RwnksI24L6+oo5/HPoEo5cQrjkSAi3GySEbYEQFpcQtgVCeEIjhG2BED78JYQLN4SwLRDCxXJC2BYI4cglhD2XELYFQtgWCOGDCELYcwlhWyCEJzRC2BYIYXEJ4esWCOHIJYTFJYRPUBLCkUsIH0QQwgcRhHDhhhD2XELYFgjhy5kI0UwblrPztBvMycmRe5F1iYqKUlW7QdH26f9mamrKoYs9xsbGMDc3V7SKwcuXL88YS0xMxLq6ujmvGRkZQV9fX6ysrESLxYIpKSmYn5+/6JijUSSuM8nIyMD09HT572xx/f39sbu7e85rampqMCYmxvbYbDZjUFDQomOORvUHESULtBsUDS4tFovcrT09PSE+Pl72CBOopd2g6sU1LdBusKWlRXpmQUEBdHV1QXR0tGx+KfZGpe0GVXIQ8eeJjY2V0WtFTHZlZWUyCrXdblCFTExMwOTkpGzCpul2g2qgsrISQkJCwGw2w9DQEOTm5kJCQgL4+fmppt2g6rMFK6dOnZqTLRQWFmJAQAC6ublhcnIydnV12caePXuGERERaDQaZbYhUrCljDkSRe0GGZ3bghZgcQlhcQlhcQlhcQlhcQlhcYGOvwG67cAek0KTwgAAAABJRU5ErkJggg==" | base64 -d > /data/mdc_2021_hylo/mdc_distance_to_parks/derived/mdc_distance_to_parks_legend.png cp /data/mdc_2021_hylo/mdc_distance_to_parks/derived/mdc_distance_to_parks_legend.png /tiles/raster/mdc_distance_to_parks/ # render raster tiles cd /data/mdc_2021_hylo/mdc_distance_to_parks/ gdal2tiles.py -ex --xyz -z 8-16 /data/mdc_2021_hylo/mdc_distance_to_parks/derived/mdc_distance_to_parks_color.tif /tiles/raster/mdc_distance_to_parks