UM Geospatial Digital Special Collections

Citation: Center for Disease Control (2022). 2020 Florida CDC Social Vulnerability Index (tracts) [gis dataset]. CDC. https://www.atsdr.cdc.gov/placeandhealth/svi/data_documentation_download.html. last updated: 2024-05-16 (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, CDC, Vulnerability, Social Vulnerability Index, Census Tracts, Public-Safety Open Geospatial Consortium Standards: vector tiles | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_get_attributes(tablename=fl_2020_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 fl_2020_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/fl_2020_svi_tract/{download,etl} && cd /data/fl_2020_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 # download if update flag is set: if do_update == 1 then wget -O download/fl_2020_svi_tract.zip 'https://svi.cdc.gov/Documents/Data/2020/db/states/Florida.zip' # unzip to download directory if update flag is set if do_update == 1 then unzip -d download download/fl_2020_svi_tract.zip && rm download/fl_2020_svi_tract.zip # load into postGIS with: ogr2ogr -lco GEOMETRY_NAME=geom -f PostgreSQL PG:"" download/SVI2020_FLORIDA_tract.gdb -nlt multipolygon -nln fl_2020_svi_tract ######### # Step 2 - SQL script (pseudo code): #### # remove duplicate points and make geometries valid: UPDATE fl_2020_svi_tract SET geom=ST_MakeValid(ST_RemoveRepeatedPoints(geom));" # add local geometry column and reproject existing geometries into local EPSG: SELECT AddGeometryColumn ( 'fl_2020_svi_tract', 'geom_local',2236,'multipolygon',2 ); UPDATE fl_2020_svi_tract SET geom_local=ST_Transform(ST_Multi(geom),2236); CREATE INDEX fl_2020_svi_tract_geom_local_idx ON fl_2020_svi_tract USING GIST (geom_local); NOTIFY pgrst, 'reload schema';"