Updating SVI data sources in the Community Risk Reduction Solution

[#1]

Version 1.0 of the Community Risk Reduction ArcGIS Solution uses an ArcGIS Living Atlas layer that has been deprecated. A new archived layer can be substituted to fix broken data source errors. This issue has been resolved in version 1.1 (March 2025).

To substitute the deprecated layer with the archived layer:

Community Risk Assessment Map

1. Open the Community Risk Assessment web map in Map Viewer.
2. Click Cancel on the sign-in prompt.
3. Expand the Risk and Vulnerability Indices group. Click the ellipse next to the SVI2020 US tract layer and click Remove.
4. Click Add, then My content, and choose Living Atlas.
5. Type CDC Social Vulnerability Index 2022 (Archive) in the search bar and click + Add.
6. Click the back arrow next to Add layer.
7. Expand the CDC Social Vulnerability Index 2022 (Archive) group.
8. Click and hold on the Move button next to the CDC SVI 2022 Tract layer and move it to the Risk and Vulnerability Indices group.
9. Remove the CDC Social Vulnerability Index 2022 (Archive) group by clicking the ellipse next to the group name and clicking remove.
10. Ensure the CDC SVI 2022 Tract is turned off by default by toggling off visibility.
11. Click the Save and Open button on the left navigation bar and choose Save.

The final layer list should look like this:

 Community Risk Reduction Activity Reporter Map

1. Open the Community Risk Reduction Activity Reporter web map in Map Viewer.
2. Click Cancel on the sign-in prompt.
3. Click the ellipse next to the SVI2020 US tract layer and click Remove.
4. Click Add, then My content, and choose Living Atlas.
5. Type CDC Social Vulnerability Index 2022 (Archive) in the search bar and click + Add.
6. Click the back arrow next to Add layer.
7. Expand the CDC Social Vulnerability Index 2022 (Archive) group.
8. Click and hold on the Move button next to the CDC SVI 2022 Tract layer to where it isn’t nested in the CDC Social Vulnerability Index 2022 (Archive) group.
9. Remove the CDC Social Vulnerability Index 2022 (Archive) group by clicking the ellipse next to the group name and clicking remove.
10. Click the CDC SVI 2022 Tract layer. In the right pane select Styles.
11. Under Choose attributes, click the X next to “Sum of flags for the four themes”.
12. Under Pick a style, select Location (Single symbol) and the Style options.
13. Click the pencil next to the symbol style.
14. For fill color, choose no color for both fill and border.
15. Click Done.
16. Click the Save and Open button on the left navigation bar and choose Save.

Community Risk Reduction Activity Reporter Form

1. Open the Community Risk Reduction Activity Reporter web map in Field Maps Form Designer
2. Click Forms on the left navigation bar.
3. Expand the Risk Reduction group and select Activities.
4. Scroll to the very bottom. Select the Effectiveness Score field.
5. Click the gear (configure) next to the Effectiveness Score calculated expression.
6. Click the ellipse next to Effectiveness Score and select Edit Arcade.
7. Replace the existing code with this:

//This script uses an intersect function to return the SVI's total vulnerability score (RPL_THEMES) for the census tract and activity falls in when it's placed on the map. 
//SVI is specific to the United States of America. If your jurisdiction is outside of the USA, you can substitute this layer with a regionally appropriate risk or vulnerability layer. 
//To substitute the layers, open the Community Risk Reduction Activity Reporter map. Remove the SVI layer and add your own. Save the map and return to this expression editor. 
//For the layer name variable, replace "SVI2020 US tract" with the plain-language title of your layer. 
//Replace the returned field (RPL_THEMES) with the risk/vulnerability score field you want to use to evaluate effectiveness. 

//Get current activity information.
var activity = $feature

//Get the CRR Area layer from the map. If the layer name changes, this must be updated to match.
var equityarea = FeatureSetByName($map, 'CDC SVI 2022 Tract', ['RPL_THEMES'])

//Identify any intersecting CRR areas to the activty.
var intersectArea = First(Intersects(activity, equityarea))

//Ensures there is an intersection and returns null if there isn't.
var effectiveness = IIF(IsEmpty(intersectArea), ' ', intersectArea['RPL_THEMES'])

//Return the RPL_Theme score.
return effectiveness;

8. Click Run. A decimal number should appear. Click Done.

9. At the top of the screen, click the Save button and select Save to layer.

Community Risk Reduction Outcomes Effectiveness Map

1. Open the Community Risk Reduction Outcomes Effectiveness web map in Map Viewer.
2. Click Cancel on the sign-in prompt.
3. Click the ellipse next to the CDC ATSDR Social Vulnerability Index 2020 USA group layer and click Remove.
4. Click Add.
5. Click My content and choose Living Atlas.
6. Type CDC Social Vulnerability Index 2022 (Archive) in the search bar and click + Add.
7. Click the back arrow next to Add layer.
8. Expand the CDC Social Vulnerability Index 2022 (Archive) group.
9. Click and hold on the Move button next to the CDC SVI 2022 Tract layer to where it isn’t nested in the CDC Social Vulnerability Index 2022 (Archive) group.
10. Remove the CDC Social Vulnerability Index 2022 (Archive) group by clicking the ellipse next to the group name and clicking remove.
11. Click the CDC SVI 2022 Tract layer. In the right pane select styles.
12. Under Choose attributes, click the X next to “Sum of flags for the four themes”.
13. Click + Field under Choose attributes and type RPL.
14. Select the Overall percentile ranking field and click Add.
15. Under Pick a style, select Style options under Counts and Amounts (color).
16. Scroll past the data range and toggle on Classify data.
17. For the method, choose manual breaks.
18. Select 4 classes
19. Manually set the thresholds to this:

Default colors are:

Low: #d7191c

Medium low: #fdae61

Medium high: #a6d96a

High: #1a9641

20. Click Done.

21. Click Properties on the right pane.

22. In the Appearance box, up the transparency from 0% to 50%.

23. Click the Save and Open button on the left navigation bar and choose Save.