Center for Disease Control (2024). 2022 Miami-Dade CDC Social Vulnerability Index (tracts) [gis dataset]. CDC. https://www.atsdr.cdc.gov/place-health/php/svi/svi-data-documentation-download.html. last updated: 0001-01-01 (update frequency: Never). 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) Analytical Functions: gdsc_get_attributes(tablename=mdc_2022_svi_tract,lat=25.718,lng=-80.279,identifier=location,normal='') ETL documentation

ETL for mdc_2022_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_2022_svi_tract/{download,etl} && cd /data/mdc_2022_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 gdsc-postgis-node-lp7ujcznz4d3nofr -t fl_2022_svi_tract | sed 's/fl_2022_svi_tract/mdc_2022_svi_tract/g' | psql -d $POSTGRES_DB -U $POSTGRES_USER -p $POSTGRES_PORT -h gdsc-postgis-node-b9dsxkidfr816zo3 # drop geom_local and subset as per custom parameters psql -d $POSTGRES_DB -U $POSTGRES_USER -p $POSTGRES_PORT -h gdsc-postgis-node-b9dsxkidfr816zo3 -c " ALTER TABLE mdc_2022_svi_tract DROP COLUMN IF EXISTS geom_local; DELETE FROM mdc_2022_svi_tract WHERE NOT (stcnty = '12086'); COMMIT;" # add local geometry column and reproject existing geometries into local EPSG: SELECT AddGeometryColumn ( 'mdc_2022_svi_tract', 'geom_local', 2236, 'multipolygon', 2 ); UPDATE mdc_2022_svi_tract SET geom_local=ST_MakeValid(ST_RemoveRepeatedPoints(ST_Transform(ST_Multi(geom),2236))); CREATE INDEX mdc_2022_svi_tract_geom_local_idx ON mdc_2022_svi_tract USING GIST (geom_local); NOTIFY pgrst, 'reload schema'; # Move into corrrect directory and create derivative directory in data package on osgeo cd /data/mdc_2022_svi_tract/ mkdir -p derived # Create shapefile of table in derivate directory on osgeo ogr2ogr -f "ESRI Shapefile" -overwrite derived/mdc_2022_svi_tract.shp PG:"" mdc_2022_svi_tract # Create downloadable tarfile of shp in derivative directory on osgeo rm -f derived/mdc_2022_svi_tract.shp.tar.gz tar -czf derived/mdc_2022_svi_tract.shp.tar.gz meta_dcat_mdc_2022_svi_tract.json -C derived mdc_2022_svi_tract.shp mdc_2022_svi_tract.prj mdc_2022_svi_tract.shx mdc_2022_svi_tract.dbf # Move into correct directory cd /data/mdc_2022_svi_tract/