Office for Civic and Community Engagement, University of Miami, Institute for Data Science and Computing (2024). Miami-Dade Parcels Augmented for CAMP Ownership [gis dataset]. University of Miami Institute for Data Science and Computing. last updated: 2026-05-20 (update frequency: 1 week). A polygon feature class of property boundaries in Miami-Dade county sourced from the Miami-Dade Open Data Portal and then augmented with elevation data, flood zone data, qualified opportunity zone boolean, water overlap as boolean, managed areas (parks), intersections with major roads, and both county and municipal zoning information. All of the augmentation is based on spatial joines. Please see the ETL and provenance documentation for more information. Key words: Miami-Dade County, property, elevation, flood zones, municipal zoning, county zoning, qualified opportunity zones, land use, DOR codes Open Geospatial Consortium Standards: dynamic vector tiles Analytical Functions: gdsc_get_attributes(tablename=mdc_parcels_camp_ownership,lat=25.718,lng=-80.279,identifier=folio,normal='') ETL documentation

ETL for mdc_parcels_camp_ownership

######### # 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_parcels_camp_ownership/{download,etl} && cd /data/mdc_parcels_camp_ownership # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # load mdc_parcels_camp_filtered as dependency (see mdc_parcels_camp_filtered for details). # clone a git repo and run the code# load into postGIS with: ogr2ogr -lco GEOMETRY_NAME=geom -f PostgreSQL PG:"" download/mdc_parcels_camp_ownership.json -nlt multipolygon -nln mdc_parcels_camp_ownership # add local geometry column and reproject existing geometries into local EPSG: SELECT AddGeometryColumn ( 'mdc_parcels_camp_ownership', 'geom_local', 2236, 'multipolygon', 2 ); UPDATE mdc_parcels_camp_ownership SET geom_local=ST_MakeValid(ST_RemoveRepeatedPoints(ST_Transform(ST_Multi(geom),2236))); CREATE INDEX mdc_parcels_camp_ownership_geom_local_idx ON mdc_parcels_camp_ownership USING GIST (geom_local); NOTIFY pgrst, 'reload schema'; # Move into corrrect directory and create derivative directory in data package on osgeo cd /data/mdc_parcels_camp_ownership/ mkdir -p derived # Create shapefile of table in derivate directory on osgeo ogr2ogr -f "ESRI Shapefile" -overwrite derived/mdc_parcels_camp_ownership.shp PG:"" mdc_parcels_camp_ownership # Create downloadable tarfile of shp in derivative directory on osgeo rm -f derived/mdc_parcels_camp_ownership.shp.tar.gz tar -czf derived/mdc_parcels_camp_ownership.shp.tar.gz meta_dcat_mdc_parcels_camp_ownership.json -C derived mdc_parcels_camp_ownership.shp mdc_parcels_camp_ownership.prj mdc_parcels_camp_ownership.shx mdc_parcels_camp_ownership.dbf # Move into correct directory cd /data/mdc_parcels_camp_ownership/ # Create pg_dump of table SQL in derivate directory on postgis. pg_dump -h gdsc-postgis-node-lpchu1bcm56m0xti -t mdc_parcels_camp_ownership > derived/mdc_parcels_camp_ownership.sql # Create downloadable tarfile of SQL in derivative directory on postgis rm -f derived/mdc_parcels_camp_ownership.sql.tar.gz tar -czf derived/mdc_parcels_camp_ownership.sql.tar.gz meta_dcat_mdc_parcels_camp_ownership.json -C derived mdc_parcels_camp_ownership.sql