Citation: Center for Disease Control (2020). 2018 Miami-Dade CDC Social Vulnerability Index (tracts) [gis dataset]. CDC. https://www.atsdr.cdc.gov/placeandhealth/svi/data_documentation_download.html. last updated: 2024-11-08 (update frequency: Never). Abstract: Social vulnerability refers to the potential negative effects on communities caused by external stresses on human health. Such stresses include natural or human-caused disasters, or disease outbreaks. Reducing social vulnerability can decrease both human suffering and economic loss. The CDC/ATSDR Social Vulnerability Index (CDC/ATSDR SVI) uses 16 U.S. census variables to help local officials identify communities that may need support before, during, or after disasters. Key words: Florida, Miami-Dade, CDC, Vulnerability, Social Vulnerability Index, Census Tracts, Public-Safety Open Geospatial Consortium Standards: dynamic vector tiles | | WMS (coming soon) | WFS (coming soon) ESRI Standards: ArcGIS MapServer | ArcGIS FeatureServer | Open in ArcGIS Portal for GDSC Analytical Functions: gdsc_get_attributes(tablename=mdc_2018_svi_tract,lat=25.718,lng=-80.279,identifier=location,normal='') ETL documentation

ETL for mdc_2018_svi_tract

######### # 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_2018_svi_tract/{download,etl} && cd /data/mdc_2018_svi_tract # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # Create copy of geom dependency pg_dump -d $POSTGRES_DB -U $POSTGRES_USER -p $POSTGRES_PORT -h postgis-yj0h0awq5efff3lq -t fl_2018_svi_tract | sed 's/fl_2018_svi_tract/mdc_2018_svi_tract/g' | psql -d $POSTGRES_DB -U $POSTGRES_USER -p $POSTGRES_PORT -h postgis-tzsziiuqx3r5wfip # drop geom_local and subset as per custom parameters psql -d $POSTGRES_DB -U $POSTGRES_USER -p $POSTGRES_PORT -h postgis-tzsziiuqx3r5wfip -c " ALTER TABLE mdc_2018_svi_tract DROP COLUMN IF EXISTS geom_local; DELETE FROM mdc_2018_svi_tract WHERE NOT (stcnty = '12086'); COMMIT;" # add local geometry column and reproject existing geometries into local EPSG: SELECT AddGeometryColumn ( 'mdc_2018_svi_tract', 'geom_local', 2236, 'multipolygon', 2 ); UPDATE mdc_2018_svi_tract SET geom_local=ST_MakeValid(ST_RemoveRepeatedPoints(ST_Transform(ST_Multi(geom), 2236))); CREATE INDEX mdc_2018_svi_tract_geom_local_idx ON mdc_2018_svi_tract USING GIST (geom_local); NOTIFY pgrst, 'reload schema';