UM Geospatial Digital Special Collections

Citation: Miami Dade County (2018). Miami-Dade County Zoning [gis dataset]. Miami Dade County. https://gis-mdc.opendata.arcgis.com/datasets/MDC::county-zoning-1/about. last updated: 2024-10-28 (update frequency: 1 week). Abstract: A polygon feature class of the county zoning boundaries and overlays derived from the zoning maps and other layers from the parcel model. This dataset should not be used for applications requiring accurate plat survey information such as zone and overlay dimension and area. Updated: Weekly-Sat Key words: Florida, Miami-Dade County, MDC, Geography, Property, Housing, Zoning, Infrastructure Open Geospatial Consortium Standards: dynamic vector tiles | | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_get_attributes(tablename=mdc_county_zoning,lat=25.718,lng=-80.279,identifier=zone,attrs=[zone_id,zone,munc,ovly,ttrrss,zonemunc,zone_desc,short_desc,created_by,created_date,modified_by,modified_date],normal='') ETL documentation

ETL for mdc_county_zoning

######### # 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_county_zoning/{download,etl} && cd /data/mdc_county_zoning # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # download if update flag is set: if do_update == 1 then wget -O download/mdc_county_zoning.json 'https://opendata.arcgis.com/api/v3/datasets/69bda17d8d1f48e58268103aebf86546_0/downloads/data?format=geojson&spatialRefId=4326&where=1%3D1' # replace column names Shape__Length and Shape__Area to avoid conflict when # providing as service on ArcServer. sed -i 's/Shape__Length/shape_length/gI; s/Shape__Area/shape_area/gI' download/mdc_county_zoning.json # load into postGIS with: ogr2ogr -lco GEOMETRY_NAME=geom -f PostgreSQL PG:"" download/mdc_county_zoning.json -nlt multipolygon -nln mdc_county_zoning ######### # Step 2 - SQL script (pseudo code): #### # remove duplicate points and make geometries valid: UPDATE mdc_county_zoning SET geom=ST_MakeValid(ST_RemoveRepeatedPoints(geom));" # add local geometry column and reproject existing geometries into local EPSG: SELECT AddGeometryColumn ( 'mdc_county_zoning', 'geom_local',2236,'multipolygon',2 ); UPDATE mdc_county_zoning SET geom_local=ST_MakeValid(ST_RemoveRepeatedPoints(ST_Transform(ST_Multi(geom),2236))); CREATE INDEX mdc_county_zoning_geom_local_idx ON mdc_county_zoning USING GIST (geom_local); NOTIFY pgrst, 'reload schema';"