UM Geospatial Digital Special Collections

Citation: Center for Disease Control (2024). 2022 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) Analytical Functions: gdsc_get_attributes(tablename=mdc_2022_svi_tract,lat=25.718,lng=-80.279,identifier=location,attrs=[area_sqmi,county,e_afam,e_age17,e_age65,e_aian,e_asian,e_crowd,e_daypop,e_disabl,e_groupq,e_hburd,e_hh,e_hisp,e_hu,e_limeng,e_minrty,e_mobile,e_munit,e_nhpi,e_nohsdp,e_noint,e_noveh,e_otherrace,e_pov150,e_sngpnt,e_totpop,e_twomore,e_unemp,e_uninsur,ep_afam,ep_age17,ep_age65,ep_aian,ep_asian,ep_crowd,ep_disabl,ep_groupq,ep_hburd,ep_hisp,ep_limeng,ep_minrty,ep_mobile,ep_munit,ep_nhpi,ep_nohsdp,ep_noint,ep_noveh,ep_otherrace,ep_pov150,ep_sngpnt,ep_twomore,ep_unemp,ep_uninsur,epl_age17,epl_age65,epl_crowd,epl_disabl,epl_groupq,epl_hburd,epl_limeng,epl_minrty,epl_mobile,epl_munit,epl_nohsdp,epl_noveh,epl_pov150,epl_sngpnt,epl_unemp,epl_uninsur,f_age17,f_age65,f_crowd,f_disabl,f_groupq,f_hburd,f_limeng,f_minrty,f_mobile,f_munit,f_nohsdp,f_noveh,f_pov150,f_sngpnt,f_theme1,f_theme2,f_theme3,f_theme4,f_total,f_unemp,f_uninsur,fips,location,m_afam,m_age17,m_age65,m_aian,m_asian,m_crowd,m_disabl,m_groupq,m_hburd,m_hh,m_hisp,m_hu,m_limeng,m_minrty,m_mobile,m_munit,m_nhpi,m_nohsdp,m_noint,m_noveh,m_otherrace,m_pov150,m_sngpnt,m_totpop,m_twomore,m_unemp,m_uninsur,mp_afam,mp_age17,mp_age65,mp_aian,mp_asian,mp_crowd,mp_disabl,mp_groupq,mp_hburd,mp_hisp,mp_limeng,mp_minrty,mp_mobile,mp_munit,mp_nhpi,mp_nohsdp,mp_noint,mp_noveh,mp_otherrace,mp_pov150,mp_sngpnt,mp_twomore,mp_unemp,mp_uninsur,rpl_theme1,rpl_theme2,rpl_theme3,rpl_theme4,rpl_themes,spl_theme1,spl_theme2,spl_theme3,spl_theme4,spl_themes,st,st_abbr,state,stcnty],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 postgis-a9524noxszv23wer -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 postgis-5l65d707ujo9smbx # subset as per custom parameters psql -d $POSTGRES_DB -U $POSTGRES_USER -p $POSTGRES_PORT -h postgis-5l65d707ujo9smbx -c " DELETE FROM mdc_2022_svi_tract WHERE NOT (stcnty = '12086'); "