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 Depth to Groundwater (feet) [gis dataset]. University of Miami. https://doi.org/10.17604/p318-6n41. last updated: 2023-03-17 (update frequency: Never). Abstract: Depth to groundwater (depth from ground surface to top of water table) Key words: Florida, Miami-Dade County, MDC, Miami-Dade County, Environment, Depth to Groundwater, Water, Hylo, Homestead, Little River Open Geospatial Consortium Standards: | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_zonal_statistics(table=mdc_2021_depth_to_groundwater_ft_30m,lat=25.718,lng=-80.279,radius=500) ETL documentation

ETL for mdc_2021_depth_to_groundwater_ft_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_depth_to_groundwater_ft_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 -t 48X48 GeoTIFF_Rasters/Depth_to_Groundwater_ft_MDC_30m.tif -F mdc_2021_depth_to_groundwater_ft_30m > load_raster.sql psql < load_raster.sql rm load_raster.sql