Option 2
CalEnviroScreen
Location Relative to
Project Site(s)
(1)
Census Tract
Number*
(2)
Census Tract
Population
(3)
Metric Score of
Census Tract
(using the chosen
option listed above)
(4)
SOD of Tract
(3) x (4)
(5)
Project Site A
Within a ½ mile radius of
the perimeter of the
project site.
304.00 6,741 68.45 461421.45
Within a ½ mile radius of
the perimeter of the
project site.
305.03 3,592 51.59 185311.28
Within a ½ mile radius of
the perimeter of the
project site.
465.00 9,412 44.96 423163.52
Within a ½ mile radius of
the perimeter of the
project site.
305.01 4,557 43.66 198958.62
Project Site B
Within a ½ mile radius of
the perimeter of the
project site.
422.09 5,439 67.33 366207.87
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Project Site C
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Project Site D
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
Within a ½ mile radius of
the perimeter of the
project site.
0.00 0 0.00 0
29,741 1635062.74
55 SOD of Community Surrounding the Project = Total of Column 5 Total of Column 3
Notes: *Communities with a population of less than 15,000 may use data at the Census Block Group level. Unincorporated communities may use data at the Census Place level.
Steps to Calculate your Minimum Local Match % Requirement (See Appendix A.1 in the Program Guidelines for Example Calculations and the Local Match Tutorials on the CCLGP website for more details)
Step 1 of 3: Choose a definition by which to define the community surrounding the project as underserved. See the section Underserved Communities of the program guidelines for more information. If the community surrounding the project is considered underserved based on multiple options, choose the option that best supports the community’s status as underserved. The same definition should be used throughout Table 1 below. Per Option 5, Tribal Communities require zero local match, and thus do not need to perform the first two tabs (but may need to complete the 3rd tab). Record your choice at the top of Table 1 in Row 9, below.
Step 2 of 3: Determine the SOD of the community surrounding the project. Perform this calculation using Table 1 below and the Local Match Tutorials on the CCLGP website. When calculating SOD, the same underserved community definition must be used throughout Table 1 . Also, if you have two project sites within the same census tract, do not list that census tract twice in the below table. If you need more rows to complete Table 1, you can add them in, however, be aware that the formulas for automatic calculations won't be applied to the new rows. For values to automatically calculate, you will need to apply the formulas to the new rows. After you are done completing Table 1, complete Step 3, the last step, in the next tab of this spreadsheet.
Table 1. SOD of Community Surrounding the Project Site(s) List the Option Used to Determine SOD:
(For information on the2 options, see the program guidelines section “Underserved Communities”.)
TOTALS
SOD
Criteria
50 37.5
25 12.5
0 0
Step 3 of 3: Use Table 2 below to determine the Required Local Match based off the SOD of Community Surrounding the Project and state your required local match % at the bottom of the table (the answer should be one of these values: 50, 37.5, 25, 12.5, or 0).
Table 2. Severity of Disadvantage and Corresponding Local Match Requirement Ranges for SOD of Community
Surrounding the Project
Required Local Match
%
Enter your Required Local Match here:
Option 2: CalEnviroScreen 4.0 Score (not percentile)
Data: CalEnviroScreen 4.0 Results
If the
CalEnvir
oScreen
4.0 SOD
of the
surround
< 40
Then local match is…
40 to 43
44 to 47
48 to 51
> 51
Local Match Requirement %
(From Step 3 in previous tab) 0.0Total Grant Amount Request (Enter manually and round dollar amount to the nearest thousandth. For example: requested grant amount $1,200,900.32 would round to $1,201,000.00.) 3,000,000.00$
Local Match Requirement in Dollars
(The two previous values multiplied together, and divided by 100) -$ Total Value of CASH Match Provided
(Enter manually) -$
(Enter name of good or service here, and retail value of that good or service to the right) -$
(Enter name of good or service here, and retail value of that good or service to the right) -$
(Enter name of good or service here, and retail value of that good or service to the right) -$
(Enter name of good or service here, and retail value of that good or service to the right) -$ In-Kind Contribution #5 (Enter name of good or service here, and retail value of that good or service to the right)
(If more rows are needed to list In-Kind Contributions, add them below, but be aware that formulas won't apply to them) -$
Total Value of IN-KIND Match Provided
(Sum of itemized in-kind contributions listed above) -$ Total Local Match Provided (Should equal or exceed the total required amount stated in Cell C7) -$
Table 3. Local Match Sources
Local Match Sources
Based on your Minimum Local Match Requirement % determined in the second tab, calculate in terms of dollars how much Local Match your project needs to provide, and how the project will meet this requirement (or exceed it) by providing cash, in-kind contributions, or a combination of these sources. See the section "Local Match Sources" in the Program Guidelines for more information.
Tribes automatically qualify for 0% local match and thus do not need to complete the Census Tract
Total
Populatio
n
California
County ZIP
Approxim
ate
Location
Longitude LatitudeCES 4.0
Score
CES 4.0
Percentile
CES 4.0
Percentile
Range
DAC category
6065030400 6741 Riverside 92507 Riverside -117.368 33.97117 68.45 98.7595-100% (highest scores)CalEnviroScreen 4.0 Top 25%
6065030503 3592 Riverside 92507 Riverside -117.353 33.9799 51.59 89.54 85-90%CalEnviroScreen 4.0 Top 25%
6065046500 9412 Riverside 92521 Riverside -117.333 33.97094 44.96 81.95 80-85%CalEnviroScreen 4.0 Top 25%
6065030501 4557 Riverside 92507 Riverside -117.355 33.96851 43.66 80.33 80-85%CalEnviroScreen 4.0 Top 25%
6065042209 5439 Riverside 92507 Riverside -117.342 33.99512 67.33 98.4995-100% (highest scores)CalEnviroScreen 4.0 Top 25%
Census Tract Ozone Ozone Pctl PM2.5 PM2.5
Pctl Diesel PMDiesel PM
Pctl
Drinking
Water
Drinking
Water
Pctl
Lead Lead Pctl
6065030400 0.067 97.0012.35265 90.18 0.537 91.09 693.83 77.37 84.21 92.79 6065030503 0.067 97.0012.28477 89.52 0.271 73.20 693.83 77.37 94.44 99.26 6065046500 0.069 97.6012.01961 79.44 0.477 88.94 693.83 77.37 44.12 43.10 6065030501 0.067 97.0012.27533 89.43 0.086 32.03 693.83 77.37 68.35 76.98 6065042209 0.069 97.6012.37481 90.35 0.565 91.90 693.83 77.37 47.41 47.89 Census Tract PesticidesPesticides
Pctl
Tox.
Release
Tox.
Release
Pctl
Traffic Traffic
Pctl
Cleanup
Sites
Cleanup
Sites Pctl
Groundw
ater
Threats
Groundwater Threats
Pctl
6065030400 0.00 0.00 599.675 55.051416.184 75.90 44.2 94.61 37.5 84.66 6065030503 0.00 0.00 568.0847 54.13730.0338 38.66 8.3 53.73 11.55 50.94 6065046500 0.00 0.00 584.349 54.691910.319 85.61 6.4 46.96 0 0.00 6065030501 0.00 0.00 609.5837 55.36833.7289 46.63 9.1 58.49 3.85 25.17 6065042209 0.16 29.24 804.473 60.501404.468 75.53 23 84.60 8.1 40.99 Census Tract Haz.
Waste
Haz. Waste
Pctl
Imp.
Water
Bodies
Imp.
Water
Bodies
Pctl
Solid
Waste
Solid
Waste
Pctl
Pollution
Burden
Pollution
Burden
Score
Pollution
Burden
Pctl
Asthma
6065030400 0.73 79.36 0 0.00 2 52.90 69.05 8.43 97.97 61 6065030503 0.695 78.05 0 0.00 0 0.00 56.28 6.87 84.92 61.6 6065046500 0.63 75.96 0 0.00 2 52.90 55.62 6.79 83.55 29.31 6065030501 0.42 63.07 0 0.00 1 35.72 51.73 6.32 74.88 57.35 6065042209 2.785 95.51 0 0.00 1 35.72 64.65 7.89 95.57 61.6 Census Tract Asthma
Pctl
Low Birth
Weight
Low Birth
Weight
Pctl
Cardiovas
cular
Disease
Cardiovas
cular
Disease
Pctl
EducationEducation
Pctl
Linguistic
Isolation
Linguistic
Isolation
Pctl
Poverty
6065030400 70.29 6.14 77.94 17.63 79.30 37.8 88.09 9.7 60.62 49.9 6065030503 70.79 3.08 10.06 17.81 79.97 38.3 88.57 24 91.39 72.4 6065046500 23.84 6.82 87.97 8.47 16.94 14.1 53.40 14.5 76.07 68.2 6065030501 66.04 4.59 40.94 16.54 74.04 24.9 73.07 13 71.39 49.7 6065042209 70.79 7.29 92.42 17.81 79.97 19.8 64.52 12.6 70.31 72.3 Census Tract Poverty
Pctl
Unemploy
ment
Unemploy
ment Pctl
Housing
Burden
Housing
Burden
Pctl
Pop. Char. Pop. Char.
Score
Pop. Char.
Pctl
6065030400 81.62 10.8 89.19 26.6 83.94 78.27 8.12 90.68 6065030503 98.23 11.2 90.33 28.2 87.25 72.38 7.51 83.26 6065046500 96.66 19.3 99.05 39.8 98.54 63.83 6.62 71.22 6065030501 81.36 6.9 66.61 22.5 72.17 66.63 6.91 75.33
6065042209 98.15 14.4 96.25 28.4 87.69 82.22 8.53 94.72 Census Tract
Total
Populatio
n
California
County ZIP
Approxim
ate
Location
Longitude LatitudeCES 4.0
Score
CES 4.0
Percentile
CES 4.0
Percentile
Range
DAC category
6065030400 6741 Riverside 92507 Riverside -117.368 33.97117 68.45 98.7595-100% (highest scores)CalEnviroScreen 4.0 Top 25%
6065030503 3592 Riverside 92507 Riverside -117.353 33.9799 51.59 89.54 85-90%CalEnviroScreen 4.0 Top 25%
6065046500 9412 Riverside 92521 Riverside -117.333 33.97094 44.96 81.95 80-85%CalEnviroScreen 4.0 Top 25%
6065030501 4557 Riverside 92507 Riverside -117.355 33.96851 43.66 80.33 80-85%CalEnviroScreen 4.0 Top 25%
6065042209 5439 Riverside 92507 Riverside -117.342 33.99512 67.33 98.4995-100% (highest scores)CalEnviroScreen 4.0 Top 25%