Chris Mader (2024). 2024 Little River Drone Survey [gis dataset]. University of Miami GDSC. https://gdsc.idsc.miami.edu/. last updated: 0001-01-01 (update frequency: Never). High resolution orthographic image of the Little River neighborhood of the greater 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 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 -t auto lr_2024_drone_survey.tif -F lr_2024_drone_survey > load_raster.sql psql < load_raster.sql rm load_raster.sql # render raster tiles cd /data/lr_2024_drone_survey/ gdal2tiles.py -ex --xyz -z 10-22 /data/lr_2024_drone_survey/download/lr_2024_drone_survey.tif /tiles/raster/lr_2024_drone_survey