UM Geospatial Digital Special Collections

Citation: CCE (2025). CCE Miami-Dade County Distinct DOR Code Map [gis dataset]. CCE. https://civic.miami.edu/. last updated: 2025-06-24 (update frequency: As Needed). Abstract: Department of Revenue (DOR) Code mapping for CCE online map applications LAND and CAMP. Key words: Miami-Dade County, DOR Codes Open Geospatial Consortium Standards: dynamic vector tiles | | WMS (coming soon) | WFS (coming soon) ETL documentation

ETL for mdc_cce_distinct_dor_codes

######### # 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_distinct_dor_codes/{download,etl} && cd /data/mdc_cce_distinct_dor_codes # 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_distinct_dor_codes.csv # load into postGIS with: ogr2ogr -lco GEOMETRY_NAME=geom -f PostgreSQL PG:"" download/mdc_cce_distinct_dor_codes.csv -nln mdc_cce_distinct_dor_codes