UM Geospatial Digital Special Collections

Citation: Chris Mader (2024). 2024 Little River Drone Survey [gis dataset]. University of Miami GDSC. https://gdsc.idsc.miami.edu/. last updated: 2024-10-03 (update frequency: Never). Abstract: High resolution orthographic image of the Litte River neighborhood of the grater Miami metropolitan area. The image was created from a drone survey of the area. Key words: Miami-Dade County, Little River, Drone Survey, orthographic image Open Geospatial Consortium Standards: raster tiles | raster tile url: https://gdsc.idsc.miami.edu/tiles/2024_little_river/{z}/{x}/{y}.png | WMS (coming soon) | WFS (coming soon) ETL documentation

ETL for lr_2024_drone_survey

######### # 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/lr_2024_drone_survey/{download,etl} && cd /data/lr_2024_drone_survey # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # load raster into postGIS with: raster2pgsql -s 3857 -d -C -I lr_2024_drone_survey.tif -F -t 256x256 lr_2024_drone_survey > load_raster.sql psql < load_raster.sql rm load_raster.sql