STATEWIDE ENVIRONMENTAL AND CLIMATE ACTION INDICATORS AND ANALYSIS
DATA OVERVIEW FOR STATEWIDE ENVIRONMENTAL AND CLIMATE ACTION INDICATORS
Purpose and Overview
The purpose of this data focus area is to identify to what extent each school district in California has taken environmental and climate action based on common indicators that demonstrate some level of investment and action (i.e. Green Ribbon, investment in environmental staff, district-wide environmental initiative, board policies, etc.).
Learn more about the indicators in this data focus area in the Glossary of Indicators.
Video Overview for data page
Key Questions
PRIMARY (CORE) QUESTIONS: To what extent has each school district in California advanced forward environmental and climate action within their schools and overall district? And what are the common indicators that demonstrate environmental and climate action within a school/district’s campus, curriculum, and community and culture?
Data Methodology
Resources and Data Collection:
Demographic and administrative information, educational metrics, student population characteristics, and financial and funding details were sourced from a number of websites including, but not limited to: California School Directory, CDE Cumulative Enrollment Data, SARC Data Files, CALPADS UPC Source File, EdData, CDE Title 1 Part A LEA Allocation Data, CDE Lead Regions, CA County Superintendent Regions, etc. Data initially collected manually from the these website was later streamlined through the efforts of UC Berkeley Data Discovery students who designed an automated web scraping tool. This tool leveraged Python libraries such as Selenium and Beautiful Soup, with Colab serving as the platform. The web scraping tool was designed to extract key information from the EdData website and present it in a structured table format consistent with the data search requirements.
Board commitments, District-wide Environmental Initiatives, and Staff Investments were more difficult to collect since there is no existing database or consistent location to find these data. While many of the board commitments could be found on CSBA Gamut or BoardDocs not all districts in the state use these services. To find the majority of these indicators, the UC Berkeley Data Discovery teams searched through district websites, local news articles, and other publicly available sources to identify evidence of each indicator. Since it is likely that not all investments are publicized, the data collected was also made available on the website and sent to each district's Superintendent and Chief Business Officer (CBO) for validation. Additional information given by district representatives through the validation form was added to the dataset as it was received. Our hope is that, through continued validation, we will be able to uncover more indicators than those that have been published on district websites, thus honing in on a more accurate depiction of the Environmental and Climate Action in California's schools. We also hope that the process of data validation will encourage districts to develop methods of communicating their commitment to environmental sustainability and literacy more clearly to their communities.
Data Cleaning: The data for this focus area underwent a cleaning process to enhance its quality and consistency. The cleaning efforts involved the removal of duplicate records, standardization of data formats, and the elimination of unnecessary characters and spaces. This was achieved through a combination of Excel processes, including the use of PIVOT tables and Text to Columns, as well as Python data cleaning tools such as Pandas and NumPy.
Data Team: Since August 2022, the data collection process has been a group effort conducted by Ten Strands staff and Climate Corps Fellow, an UndauntedK12 Climate Corps Fellow, and students from the UC Berkeley Data Science Discovery Program (five teams between Fall 2022 - Spring 2024).
CA Statewide TK-12 School District Environmental and Climate Action Scorecard
Learn more about the indicators included in this project in the Glossary of Indicators.
In order to more easily identify and communicate trends in the environmental sustainability and/or climate action investments made by the nearly 1,000 public (non-charter) school districts across the state of California, this data initiative developed a District Environmental and Climate Action Scorecard. The overall Environmental and Climate Action Score is based on a number of indicators that seek to demonstrate to what extent a school district has committed to environmental and climate action and begun to make progress on implementation across the campus facilities (buildings and grounds) and operations, curriculum, and community and culture.
Scorecard Overview Video
Scorecard Categories and Points: The score is the number of factors each district possesses out of twenty points. The factors fall into four main categories detailed below (more information about these factors can be found in the Glossary of Indicators)
Board Commitments: A local education agency’s board of trustees can demonstrate a commitment to environmental and climate action through board policy actions; such as: resolutions or declarations, board policies (BP), and administrative regulations (AR). These policies are often critical to setting a foundation for action in different subsystems - campus, curriculum, community and culture.
Green Ribbon Districts and Schools: The Green Ribbon Schools program (ED-GRS) is an award started in 2011 by the US Department of Education (and facilitated by individual states) to recognize schools that achieve excellence in environmental resource efficiency, health and wellness, and environmental sustainability education.
District-Wide Environmental Initiatives: A district-wide environmental initiative means that the district is prioritizing environmental and climate action efforts and building structures that institutionalize this prioritization through initiatives.
Staff Investments: Research shows that environmental and climate literacy and efforts to take action on green schools efforts (sustainable and climate-resilient action) are most effective when they are coordinated or directed by well-compensated, full-time employees.
![](https://www.google.com/images/icons/product/drive-32.png)
This video provides an overview of how to utilize the Tableau Interactive Map below to view the Environmental and Climate Action Score for each of the 938 public school districts. It includes how to use the filters and tools within the visualization to look for specific factors or trends across the state.
In the map below, the color scale represents the points awarded for the Environmental and Climate Action Score for each of the public (non-charter) school districts in the state. Districts in purple have made fewer investments towards sustainability at the time of this report, while districts in teal have taken more steps towards sustainability. The filters to the right of the map can be used to narrow down the data based on different Scale, Equity, and Sustainability Action variables.
*Note: The visualization and filters may have formatting issues when using smaller screens, such as cell phones.
Preliminary analysis of the Environmental and Climate Action Scorecard factors along with data for individual districts can be found in the next sections of this page.
CA Statewide School District Analysis by Individual Indicator
Learn more about the indicators included in this project in the Glossary of Indicators.
![](https://www.google.com/images/icons/product/drive-32.png)
This video provides an overview of how to utilize the Google Looker data tables below to view the specific data used to calculate the Environmental and Climate Action Score for each of the school districts. Each of the following sections has an associated data set showing the factors used to determine if the indicators of environmental sustainability and/or climate action were present.
If you notice a discrepancy in the data, please fill out this form.
Statewide Analysis of Green Ribbon Achievement for California's Public School Districts
KEY QUESTION FOR GREEN RIBBON: Which of the school districts in California have achieved California Green Ribbon Recognition? And which of the school districts in California have schools that have achieved California Green Ribbon Recognition?
DATA SET OVERVIEW AND COLLECTION METHODOLOGY: The visualizations below are focused on the Green Ribbon Schools program (ED-GRS), which can be a vehicle for action that helps to generate buy-in for environmental literacy and sustainability, serves as a baseline assessment of current efforts, and can be a platform for strategic planning and prioritizing environmental literacy and sustainability efforts. The data was collected from the California Department of Education's (CDE) program participation data (started in 2014) on the CDE California Green Ribbon Selectee page.
For more details about Green Ribbon Achievement, visit the Green Ribbon Analysis Page.
The pie chart (to the left) shows the District-Level Green Ribbon Achievement for all of the public school districts in the state. Districts who have not received any Green Ribbon award at the district level are shown in purple. Districts who have received a district-level award are shown in blue. Districts who contain at least one school with an individual school award are shown in yellow. Districts who have achieved both district and site level awards are show in green. When combined, the districts who have reached some level of Green Ribbon achievement make up approximately 9.3% of districts in the state.
SUMMARY OF FINDINGS: Across the state, 41 districts have only individual school achievement without district level achievement, 29 districts have only district level achievement without site level achievement, and 17 districts have both district and site level Green Ribbon achievement, showing that only about 9.3% of districts across the state have some level of Green Ribbon Achievement.
Green Ribbon and Enrollment: While only about 9.3% percent of California's school districts have participated in the CA Green Ribbon Schools (CA-GRS) program, it should be noted that their combined enrollment is 1,643,172 (2022-23 enrollment data), which is 30.3 percent of the total CA student enrollment. This indicates that while there is more work to be done in terms of scaling Green Ribbon participation to all districts, we have passed a tipping point in terms of student impact due to some of the larger districts in the state participating in the program.
Green Ribbon Levels: It should also be noted that 17 districts were able to reach Green Achiever level between 2014 and 2024, the highest achievement given to the ED-GRS nominees and 10 districts were able to reach the Gold level, an achievement of 75% or better. This shows that over 61% of the districts who participated in the CA Green Ribbon Schools (CA-GRS) program were reaching the higher levels of achievement.
Green Ribbon Individual District Data
Below, use the county and district filters to view the Green Ribbon achievement for each of Ca's school districts. If you notice a discrepancy in the data, please fill out this form.
We are currently going through a data update, so the following feature may unavailable at times. If so, please check back later.
*This is a large data set, so it may take a while to load. If after waiting you don't see any data above, try refreshing the page and/or using the side bar to scroll up.
If the problem persists, please contact swhiting@tenstrands.org.
Statewide Analysis of Environmental-Related Board Commitments at California's School Districts
KEY QUESTION FOR BOARD POLICY ACTION INDICATOR: Which school districts have passed environmental and climate themed board policy actions - resolutions (R), Board Policies (BP), and Administrative Regulations (AR)? What is the relationship between policy and action?
DATA OVERVIEW AND COLLECTION METHODOLOGY: This data set identifies which districts have passed templated environmental board policies (BP) from the California School Boards Association (CSBA), any related Administrative Regulations (AR), and Board Resolutions that address environmental/climate action or literacy. The methodology that analysts used for collecting this data was to search for the board of education’s policy page on each of the district websites.
These policies and administrative regulations collected as part of this initiative are:
BP: 3510 Green Schools Operations
BP: 3511 Energy And Water Management
BP and AR: 3511.1 Integrated Waste Management
BP and AR: 3514 Environmental Safety
BP and AR: 3514.1 Hazardous Substances
AR: 3514.2 Integrated Pest Management Regulation
BP: 6142.5 Environmental Education
BP and AR: 7110 Facilities Master Plan
BP and AR: 7111 Evaluating Existing Buildings
Additional board resolutions collected as part of this initiative are:
Climate Action Resolution OR Climate Emergency Declaration/Resolution
Environmental or Climate Literacy Resolution
Earth Day Resolution
Other Environmental or Climate Resolution
SUMMARY OF FINDINGS: This project has found that the state has passed a tipping point for districts passing board commitments with over half of the districts passing most of the board policies and administrative regulations that were tracked as part of this initiative (about 63% on average for board policies and about 62% on average for administrative regulations). This indicates a growing movement amongst school boards to incentivize environmental sustainability and/or climate action. However, far fewer districts are passing resolutions that are not based on the CSBA templates. More research is needed to explore the extent to which the passing of board policies is related to implementation of environmental and climate initiatives and if those districts who have passed resolutions are also investing more broadly in sustainability across their district.
Board Commitment District Data
Below, use the county and district filters to view the Board Commitments for each of Ca's 250 largest school districts. If you notice a discrepancy in the data, please fill out this form.
We are currently going through a data update, so the following feature may unavailable at times. If so, please check back later.
*This is a large data set, so it may take a while to load. If after waiting you don't see any data above, try refreshing the page and/or using the side bar to scroll up.
If the problem persists, please contact swhiting@tenstrands.org.
Statewide Analysis of District-Wide Sustainability Initiatives across Campus, Curriculum, Community, and Culture
DATA OVERVIEW AND COLLECTION METHODOLOGY: A district-wide initiative that focuses on environmental and/or climate literacy, and/or sustainability and/or climate resilience, means that the district is prioritizing these efforts and building structures that institutionalize this prioritization with staffing, committees, and dedicated time and resources. Sometimes an environmental-related initiative will take a whole systems approach, including efforts across different subsystems, such as campus facilities (buildings and grounds) and operations, curriculum, and community and culture. Other times these initiatives will just focus on one or more of these subsystems. The methodology that analysts used for collecting this data was to search on the district website (and associated school sites) and to do a broader internet search to find evidence of an ongoing initiative.
SUMMARY OF FINDINGS: Overall, we are finding a growing number of districts with some evidence of a district-wide environmental or climate initiative, reflecting the board commitments in the prior section. There is a large majority of districts showing at least one indicator of campus sustainability across the state. This may be in part to funding available through GO Bonds and Parcel Taxes ($145,073,958,930.00 awarded statewide between 2010-2023) which is subject to compliance on CALGreen sustainability construction and renovation codes. There are also a growing number of districts showing evidence of Climate/Environmental Literacy and Environmental Community and Culture, with the most prevalent indicators being Residential Outdoor Education programs (303 districts participating) and Safe Routes to School (417 districts participating).
However, evidence for these initiatives were very difficult to find due to the fact that most districts do not have a clear way of communicating publicly about their environmental and climate initiatives. Only 76 (~ 8%) of districts have a district environmental or climate action webpage, blog, or newsletter that we could locate. For the majority of districts, evidence of indicators were found buried in other documents, in school social media posts, or through local news articles. There is an opportunity for districts to more clearly communicate these initiatives in order to show the district's commitment to these efforts and help to gain community buy-in or support.
District-Wide Environmental Initiatives Data
Below, use the county and district filters to view the evidence of Environmental Initiatives for each of Ca's 250 largest school districts.
There are four main categories of initiative evidence:
Published district-wide initiatives
Evidence of campus sustainability
Evidence of environmental and/or climate literacy
Evidence of environmental community and culture.
You can toggle through the different categories using the number buttons on the left. If you notice a discrepancy in the data, please fill out this form.
We are currently going through a data update, so the following feature may unavailable at times. If so, please check back later.
*This is a large data set, so it may take a while to load. If after waiting you don't see any data above, try refreshing the page and/or using the side bar to scroll up.
If the problem persists, please contact swhiting@tenstrands.org.
Statewide Analysis of Investment in Staff for Campus, Curriculum, and Community and Culture
DATA OVERVIEW AND COLLECTION METHODOLOGY: Research shows that environmental and climate literacy and efforts to build sustainable and climate-resilient schools are most effective when they are coordinated or directed by a well-compensated, full-time employee. When done with a whole systems mindset, this staff will be responsible for supporting the development and implementation of district-wide, whole school integration of environmental sustainability and climate resiliency across the campus facilities (buildings and grounds) and operations, curriculum, and community and culture. However, districts may try different approaches to structuring the role, including part-time responsibilities, shared responsibilities across a team, job sharing between multiple agencies, and also roles that are more specific to one aspect of sustainability or environmental literacy (e.g., energy manager, zero waste specialist, environmental literacy specialist, garden coordinator, etc.). The methodology that analysts used for collecting this data was to search on the district website (and associated school sites) and to do a broader internet search to find evidence of sustainability-related positions. Examples include evidence on initiative pages, staff directory pages, job descriptions, or other articles or publication releases. The research required a thorough search of district job descriptions and district facilities/maintenance and operation pages, as well as curriculum, career and technical education programs, and school community cultural efforts.
SUMMARY OF FINDINGS:
While more districts are showing evidence of environmental and climate initiatives, as seen in the previous section, there are fewer districts with evidence of dedicated staff to lead the implementation of these initiatives. Across the state, 227 districts (~24%) have any kind of staff with environmental or climate related titles and only about 2% of districts have more than one of the categories of staff that were tracked by this initiative. This indicates that there may be a need for advocacy at the state level to identify a funding source for staff salaries focused on environmental and climate action.
While having dedicated staff focused on environmental sustainability efforts is incredibly important to the pace of change as well as the longevity of the projects, many districts struggle to find the funding or support for keeping on full time staff in these roles. As such, these duties are often split between multiple staff members who carry other roles, sometimes without being formally part of their job descriptions. The researchers in this project scraped the district websites for titles and job descriptions, but the data may underrepresent the numbers of staff members actually doing the work as part of "duties as necessary." Further research, in partnership with the districts, is needed to more accurately capture the reality of who is doing this work; however, based on the data that was collected it seems like more support could be needed around finding and funding district-wide and site-level staff to ensure the sustainability of these initiatives.
Environmental Staff District Data
Below, use the county and district filters to view the Environmental Staff Investments for each of Ca's 250 largest school districts. If you notice a discrepancy in the data, please fill out this form.
We are currently going through a data update, so the following feature may unavailable at times. If so, please check back later.
*This is a large data set, so it may take a while to load. If after waiting you don't see any data above, try refreshing the page and/or using the side bar to scroll up.
If the problem persists, please contact swhiting@tenstrands.org.
Statewide Analysis of Facilities Master Plans at California's School Districts
DATA OVERVIEW AND COLLECTION METHODOLOGY: A facilities master plan is a strategic document that provides a district with information on both existing facilities and the recommended renovations needed to support both the health and safety of their campuses. This data point is useful because CA schools are required to incorporate environmental sustainability and climate mitigation into construction and renovation. Research for facilities master plans was collected by visiting each individual district website.
The graphic below shows in which year CA's school districts adopted a facilities master plan, with each block representing a different school district. The district names are viewable by hovering over the blocks. For districts in the * category, we were able to find evidence of a plan, but were unable to identify the year that it was adopted. For districts in the N/A category, we were unable to find evidence for a published master plan at the time of data collection. More districts fall into the N/A category than can fit on the visualization.
*Note: Depending on the size of your window/screen, you may need to use the scroll bar to see all of the data in the graph below.
SUMMARY OF FINDINGS: 258 of the public school districts in California (around 27.5%) have a publicly searchable facilities master plan, with the oldest being in 2004 and the most recent being in 2023. Note that 2016 was a year when there was a State School Bond. The districts with facilities master plans served approximately 2,713,540 students in 2022-23, about 50% percent of total CA K-12 student population of the year. The average Expense of Education per ADA (2021-22) for the districts with and without facilities master plans were very similar with an average of $17,960.81 for districts without a facilities master plan and an average of $18,110.15 for those with a plan. The average percent of unduplicated students was also similar between both groups (62% for districts without a plan and 54.3% for districts with). However, there are some differences in the average amount of GO Bond Measure Funding (2010-2029) the two groups have obtained, with districts who have plans having about $209,059,999 more funds on average than those districts who do not have a facilities master plan. Also, the average overall Environmental and Climate Action Score for districts with a FMP is ~3 points higher than those without (a published facilities master plan only accounts for 0.5 points of that score).
Overall Summary of Statewide Analysis of Indicators
![](https://www.google.com/images/icons/product/drive-32.png)
This video provides a brief overview of the initial state-wide analysis of Environmental and Climate Action indicators. Visualizations of these results can be found below. Since these results are preliminary, we are unable to make any correlation claims at this time; however, there are some trends across the state that are important to point out. Deeper analysis is scheduled for Summer, 2024.
The graph above shows percent of CA's Public School Districts showing evidence for each of the categories of indicators (see scorecard at the top of the page for details). Each district is only counted once per category, regardless of the amount of evidence they have in each category, giving an unduplicated percentage.
Board Policy Action Findings (first three bars - show in tans and brown): From this graph, we can see that the majority of districts in the state are showing some evidence of board commitment to environmental and climate action. Over 60% of the districts in the state have passed a templated board policy or administrative regulation; however, far fewer districts (14.5%) are creating original resolutions.
Green Ribbon Findings (green bar): There are far fewer schools and districts achieving Green Ribbon Recognition in the state, with only 9.28% of districts having any kind of recognition (school or district level). However, the districts who do have some level of Green Ribbon Recognition serve about 30% of the students in the state.
District Initiatives Findings (blue bars): There is a growing number of districts with investments in campus sustainability, environmental or climate literacy curriculum, and environmental community and culture. There is an especially high percentage of school districts investing in some type of campus sustainability, with HVAC leading the way in terms of evidence of campus sustainability (potentially due to the COVID pandemic). However, there are far fewer districts with a clear way to communicate about their sustainability efforts.
Staffing Findings (purple bars): Staffing is lagging significantly behind some of the other indicators with less than 10% of districts employing each type of dedicated staff member.
When looking at the average Environmental and Climate Action Scores across the state (graph below), we can also see that while many districts are showing movement towards environmental sustainability and climate action, most districts only have evidence of initial investments, with few districts showing evidence of broad, system-wide investments. This initiative has plans to continue research into the correlation between broader context factors and the tends identified across the public school districts.
These results imply that there is growing interest across the public school districts in California to become more environmentally sustainable and are prepared to move towards climate action. However, it looks likely that more support is needed to scale up the implementation of these efforts, especially those that require more of a lift in terms of both facilities and curriculum (such as becoming a Green Ribbon School/District). In order to build momentum, districts striving to implement more climate actions have the opportunity to partner with student leaders, families, their community, and organizations such as Ten Strands and Undaunted K12 to collaboratively move some of these initiatives forward.