UM Geospatial Digital Special Collections

Citation: CCE (2025). CCE Miami-Dade County LAND Exclude Water [gis dataset]. CCE. https://civic.miami.edu/. last updated: 2025-06-25 (update frequency: As Needed). Abstract: Curated list of water parcels with folio number. Key words: Miami-Dade County, Parcels, water Open Geospatial Consortium Standards: dynamic vector tiles | | WMS (coming soon) | WFS (coming soon) ETL documentation

ETL for mdc_cce_land_exclude_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_cce_land_exclude_water/{download,etl} && cd /data/mdc_cce_land_exclude_water # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # remove spaces for all column headers in csv sed -i '1 s/ /_/g' download/mdc_cce_land_exclude_water.csv # load into postGIS with: ogr2ogr -lco GEOMETRY_NAME=geom -f PostgreSQL PG:"" download/mdc_cce_land_exclude_water.csv -nln mdc_cce_land_exclude_water