Community Resilience Estimates

The Community Resilience Estimates (CRE) dataset is compiled by the U.S. Census Bureau to evaluate the resilience of communities throughout the country. The CRE extracts ten risk factors from the American Community Survey (ACS) covering topics like low-income population, single/no caregiver households, health insurance coverage, and access to vehicles. The data are then summarized by recording the percent of the population in each Census geography with 0, 1-2, or 3+ risk factors termed low, medium, and high risk, respectively.

On MTCF users can access the percent of the population with 3+ risk factors (i.e., high risk) by Census tract for the state of Michigan, with 0 indicating communities of least concern and 100 indicating communities of most concern. As with other equity variables, a five-level categorical version of the variable is provided for tabling purposes with the levels being defined by quintiles of the observed data. The CRE values on MTCF are derived from the 2021 ACS.

The tract-level CRE equity variable is available on MTCF: Population with 3+ Risk Factors. More information on the CRE data can be found on the Census website: https://www.census.gov/programs-surveys/community-resilience-estimates.html.

Example Use Cases

The primary advantage of tract-level equity measures have over county-level measures is that tract-level measures allow us to examine inequities within much smaller geographic regions. For example, only tract-level measures permit us to compare specific locations within counties and to view the association between equity and crashes within a city.

In this section, we will demonstrate ways the Environmental Justice Indices can be used to answer questions about equity using the MTCF website by working through the following two research questions:

1. Check the value of equity metrics for the intersections that had the most bicycle-involved crashes in 2023

2. Examine the distribution pedestrian-involved crashes in the City of Kalamazoo across regions based on their equity scores

Note that both of these questions require the use of tract-level variables. The first asks about specific geographic locations and it is likely that several of the intersections are from the same counties (which makes county-level measures inappropriate). The second question aims to evaluate equity within the City of Kalamazoo which requires that the equity measure used demonstrate variability at that level.

1. Check the value of equity metrics for the intersections that had the most bicycle-involved crashes in 2023

Step 1: Identifying the Intersections

We start by locating the intersections that had the largest number of bicyclist-involved crashes in 2023.

From the MTCF Data Query Tool, click on “Time Frame” and select 2023. With 2023 selected, click on the “View Sorting” option.

Once on the “Geographic Location Sorting” subpage, we select the location type “Intersections” in the “Location” dropdown and “Top 10” in the “Select” dropdown. Then a display variable of “Crash: Bicyclist” so that our results will be sorted by bicyclist-involved crashes rather than overall crashes. This makes our final request to show the top 10 intersections with the highest count of bicyclist-involved crashes in 2023. Clicking “Sort” then produces the results shown in the screenshot below. According to these results, there was one intersection in 2023 that had four bicyclist-involved crashes and another that had three.

We will focus on the highest ranked intersection “Fort St & Grove St (Wayne County)” for the rest of this example. The map on the right side of the sorting interface can be zoomed to view that intersection by clicking on the name in the sorting table:

Step 2: Setting Up Crash Query

For this step, we recommend opening a second tab so that the table of intersections remains accessible.

Navigate back to the starting Data Query Tool interface and select “Filters”. We want apply two filters (see Filter Tutorial):

1. Crash: Bicyclist = “Bicyclist Involved”
2. Crash: Intersection = “Intersection Crash”

These will ensure that we’re only identifying bicyclist-involved crashes at intersections.

If configured correctly, at this stage the data query tool will show “945 Crashes” and list the current query as: “Crashes for the Year 2023 for the Entire State filtered by Crash: Bicyclist (Bicyclist Involved) and Crash: Intersection (Intersection Crash)”

After applying those filters, select the “Geographic Location” and then the “Intersection” option. Clicking the “Select Intersection” button will transition to the next step.

Step 3: Selecting Intersection

After clicking “Select Intersection” you will be redirected to a map of Michigan. From here, use this map to locate the “Fort St & Grove St (Wayne County)”. Once the map is zoomed in on a specific location, blue pins will appear identifying the available intersections. The map has a search box in the upper left that can automatically zoom to the correct location if you enter “Fort St & Grove St”.

Select the intersection of the correct roads and click it. This will trigger a pop-up box that lists the name of the intersection. In our case, it will read “Fort St & Grove St” as shown below:

Once you have the correct intersection selected, click “Use Selected Intersection” in the pop-up box. (NOTE: if you forgot to set the “Intersection Crash” filter in Step 2, MTCF will automatically add that filter at this time.)

After clicking “Use Selected Intersection” the data query tool should show “4 Crashes” and a current query of: “Crashes for the Year 2023 at intersection of Fort St & Grove St in Wayne County filtered by Crash: Bicyclist (Bicyclist Involved) and Crash: Intersection (Intersection Crash)”. This matches our expected count of crashes at this location from Step 1.

Step 4: Examining Equity for Selected Crashes

After confirming the intersection, select the “Results” button in the control panel at the bottom of the screen and click on “Table” to move to the table creation interface. Once there, click on the “Select Row(s)” dropdown menu and then select “Equity: Population with 3+ Risk Factors (2022+)” and click “Apply” to create the table. (NOTE: in the dropdown menu, the equity measures will be at the bottom and colored yellow.)

The table will now show the level of concern suggested for the crashes at this intersection according to the SVI methodology. Note that it is possible for crashes at a particular intersection to have different levels of concern because different sides of the intersection may be in different Census tracts, but this is not the case at Fort St & Grove St, so our table will only have a single row.

The table for Fort St & Grove St is shown below:

As you can see, according to the Census CRE methodology, the intersection at Fort St & Grove St does not appear to pose high equity concerns.

Step 5 (Optional): Repeat Steps 3 and 4 for other intersections

Interested users can repeat Steps 3 and 4 for other intersections identified in the original sorting, such as “26 Mile Rd & Mound Rd (Macomb County)” which had three bicyclist-involved crashes, to see if a similar pattern is present there.

2. Examine the distribution pedestrian-involved crashes in the City of Kalamazoo across regions based on their equity scores

Step 1: Setting Up Crash Query

Open a clean instance of the Data Query Tool interface and select a “Time Frame” of 2023. Then, under “Geographic Location”, click on “City or Township” and locate “Kalamazoo County: Kalamazoo” in the list of locations and select it.

Next we want one filter (see Filter Tutorial):

1. Crash: Pedestrian = “Pedestrian Involved”

These will ensure that we’re only identifying pedestrian-involved crashes.

If configured correctly, at this stage the data query tool will show “40 Crashes” and list the current query as: “Crashes for the Year 2023 for City or Township (Kalamazoo County: Kalamazoo) filtered by Crash: Pedestrian (Pedestrian Involved)”

Step 2: Tabling

Click “View Table” to be directed to the tabling interface and then select “Equity: Population with 3+ Risk Factors (2022+)” in the “Select Row(s)” dropdown menu. (NOTE: in the dropdown menu, the equity measures will be at the bottom and colored yellow.) After doing so, click “Apply” to generate the table shown below.

This table provides an overall summary of equity for bicyclist-involved crashes in Kalamazoo, which suggests that half of the pedestrian-involved crashes are located in regions that have substantial risks for community resilience. However, this does not include the geographic component, so it can be useful to look at these crashes on a map to evaluate that.

Step 3: Map Visualization

Select the “Results” button in the control panel at the bottom of the screen and click on “Crash Map” in the pop-up menu. This will redirect you to the map view which will show a map of Kalamazoo (with the city boundaries in purple) and the locations of the bicyclist-involved crashes (shown by the red pins).

Select the “Select (Optional) category variable” dropdown menu on the top left of the map and choose “Equity: Population with 3+ Risk Factors (2022+)” again. Each of the pins marking the crash is now colored according to its CRE value as shown by the legend on the left side of the map. Clicking on any of the pins will open a sidebar with details on that crash.