UM Geospatial Digital Special Collections

Citation: Center for Disease Control (2020). 2018 Florida CDC Social Vulnerability Index (tracts) [gis dataset]. CDC. https://www.atsdr.cdc.gov/placeandhealth/svi/data_documentation_download.html. last updated: 2024-10-28 (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: 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=fl_2018_svi_tract,lat=25.718,lng=-80.279,identifier=location,attrs=[area_sqmi,county,e_age17,e_age65,e_crowd,e_daypop,e_disabl,e_groupq,e_hh,e_hu,e_limeng,e_minrty,e_mobile,e_munit,e_nohsdp,e_noveh,e_pci,e_pov,e_sngpnt,e_totpop,e_unemp,e_uninsur,ep_age17,ep_age65,ep_crowd,ep_disabl,ep_groupq,ep_limeng,ep_minrty,ep_mobile,ep_munit,ep_nohsdp,ep_noveh,ep_pci,ep_pov,ep_sngpnt,ep_unemp,ep_uninsur,epl_age17,epl_age65,epl_crowd,epl_disabl,epl_groupq,epl_limeng,epl_minrty,epl_mobile,epl_munit,epl_nohsdp,epl_noveh,epl_pci,epl_pov,epl_sngpnt,epl_unemp,f_age17,f_age65,f_crowd,f_disabl,f_groupq,f_limeng,f_minrty,f_mobile,f_munit,f_nohsdp,f_noveh,f_pci,f_pov,f_sngpnt,f_theme1,f_theme2,f_theme3,f_theme4,f_total,f_unemp,fips,location,m_age17,m_age65,m_crowd,m_disabl,m_groupq,m_hh,m_hu,m_limeng,m_minrty,m_mobile,m_munit,m_nohsdp,m_noveh,m_pci,m_pov,m_sngpnt,m_totpop,m_unemp,m_uninsur,mp_age17,mp_age65,mp_crowd,mp_disabl,mp_groupq,mp_limeng,mp_minrty,mp_mobile,mp_munit,mp_nohsdp,mp_noveh,mp_pci,mp_pov,mp_sngpnt,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_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/fl_2018_svi_tract/{download,etl} && cd /data/fl_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 # download if update flag is set: if do_update == 1 then wget -O download/fl_2018_svi_tract.zip 'https://svi.cdc.gov/Documents/Data/2018/db/states/Florida.zip' # unzip to download directory if update flag is set if do_update == 1 then unzip -d download download/fl_2018_svi_tract.zip && rm download/fl_2018_svi_tract.zip # load into postGIS with: ogr2ogr -lco GEOMETRY_NAME=geom -f PostgreSQL PG:"" download/SVI2018_FLORIDA_tract.gdb -nlt multipolygon -nln fl_2018_svi_tract ######### # Step 2 - SQL script (pseudo code): #### # remove duplicate points and make geometries valid: UPDATE fl_2018_svi_tract SET geom=ST_MakeValid(ST_RemoveRepeatedPoints(geom));" # add local geometry column and reproject existing geometries into local EPSG: SELECT AddGeometryColumn ( 'fl_2018_svi_tract', 'geom_local',2236,'multipolygon',2 ); UPDATE fl_2018_svi_tract SET geom_local=ST_MakeValid(ST_RemoveRepeatedPoints(ST_Transform(ST_Multi(geom),2236))); CREATE INDEX fl_2018_svi_tract_geom_local_idx ON fl_2018_svi_tract USING GIST (geom_local); NOTIFY pgrst, 'reload schema';"