In [1]:
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline
Web Scraping and Examining Solar Energy Usage:¶
In this notebook we continue our analysis of Solar energy data collected here:
http://www.energy.ca.gov/almanac/renewables_data/solar/index.php
In the previous notebook we developed a few key functions to process the tables on the energy website. We will reuse those here:
In [2]:
def find_table(name, tables):
return {t.iloc[0,0]: t for t in tables}[name].copy()
In [3]:
def clean_solar_table(table):
table = table.copy()
# Extract and set the column names
table.columns = table.iloc[1,:].values
# drop headers and summary at end
table = table.iloc[2:-1]
# Change types
table = table.astype({"Year": "int", "Net MWh": "float", "Capacity (MW)": "float"})
return table.reset_index(drop=True)
In [4]:
def extract_and_combine_pv_and_thermal(tables):
thermal_table = clean_solar_table(find_table("Solar Thermal", tables))
pv_table = clean_solar_table(find_table("Solar PV", tables))
thermal_table["Kind"] = "Thermal"
pv_table["Kind"] = "PV"
return pd.concat([thermal_table, pv_table]).reset_index(drop=True)
Examining Sources Over Time¶
What if we wanted to examine these sources overtime? We can get more information from the website:
Try opening the page using developer tools in Chrome or Safari.
Notice that we can select a different year. To do this we would need to send some additional information to the web server. If you look at the HTML source on the right you see that the website requires POSTing additional values to access a particular year.
We can do this using the Python requests library:
In the following we make POST request with the body containing newYear=2012
In [5]:
import requests
resp = requests.post(
"http://www.energy.ca.gov/almanac/renewables_data/solar/index.php",
data = {'newYear':'2012'})
resp
Out[5]:
<Response [200]>
Examining the Request¶
In [6]:
resp.request.method
Out[6]:
'POST'
In [7]:
resp.request.path_url
Out[7]:
'/almanac/renewables_data/solar/index.php'
In [8]:
for k in resp.request.headers:
print(k, "=", resp.request.headers[k])
User-Agent = python-requests/2.18.4 Accept-Encoding = gzip, deflate Accept = */* Connection = keep-alive Content-Length = 12 Content-Type = application/x-www-form-urlencoded
In [9]:
resp.request.body
Out[9]:
'newYear=2012'
Examining the Response¶
In [10]:
resp.status_code
Out[10]:
200
In [11]:
for k in resp.headers:
print(k, ":", resp.headers[k])
Date : Tue, 13 Feb 2018 08:42:23 GMT Server : Apache/2.4.6 (Red Hat Enterprise Linux) PHP/5.4.16 X-Powered-By : PHP/5.4.16 Keep-Alive : timeout=5, max=100 Connection : Keep-Alive Transfer-Encoding : chunked Content-Type : text/html; charset=UTF-8
In [12]:
resp.content[0:500]
Out[12]:
b'<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd" >\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" >\r\n<head>\r\n\r\n<title>California Solar Energy Statistics & Data</title>\r\n\r\n<!-- META -->\r\n<meta http-equiv="content-type" content="text/html; charset=utf-8" />\r\n<meta http-equiv="Content-Style-Type" content="text/css" />\r\n<meta name="Author" content="California Energy Commission" />\r\n<meta name="Description" content="'
Notice that the content is currently encoded as raw bytes. If we wanted to work on the text version of the content we would need to decode it to the correct string encoding. This can be done using the decode function and the type defined in response header.
In [13]:
encoding = resp.headers['Content-Type'].split("=")[-1]
encoding
Out[13]:
'UTF-8'
In [14]:
resp.content.decode(encoding)[0:500]
Out[14]:
'<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd" >\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" >\r\n<head>\r\n\r\n<title>California Solar Energy Statistics & Data</title>\r\n\r\n<!-- META -->\r\n<meta http-equiv="content-type" content="text/html; charset=utf-8" />\r\n<meta http-equiv="Content-Style-Type" content="text/css" />\r\n<meta name="Author" content="California Energy Commission" />\r\n<meta name="Description" content="'
Loading the Response into Pandas¶
Alternatively, we can send the HTML to Pandas to decode into tables as before. Notice that we have now changed the year.
In [15]:
tables = pd.read_html(resp.content, encoding=encoding)
for t in tables:
display(t.head())
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
|---|---|---|---|---|---|---|---|---|
| 0 | Solar Thermal | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | Year | Company Name | EIA Plant ID | CEC Plant ID | Plant Name | State | Capacity (MW) | Net MWh |
| 2 | 2012 | Sunray Energy Inc | 10437 | S0069 | SEGS I - Retired 12/31/2015 | CA | 13.8 | 14709 |
| 3 | 2012 | Sunray Energy Inc | 10438 | S0070 | SEGS II - Retired 12/31/2015 | CA | 30.0 | 37205 |
| 4 | 2012 | Luz Solar Partners Ltd III | 10439 | S0071 | SEGS III | CA | 34.2 | 70934 |
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
|---|---|---|---|---|---|---|---|---|
| 0 | Solar PV | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | Year | Company Name | EIA Plant ID | CEC Plant ID | Plant Name | State | Capacity (MW) | Net MWh |
| 2 | 2012 | Los Angeles Department of Water & Power (LADWP) | 57305 | S0218 | Adelanto Solar Power Project | CA | 10.0 | 9883 |
| 3 | 2012 | Not Available | Missing | S9149 | Advanced Micro Decives | CA | 3.0 | 4865 |
| 4 | 2012 | Altus Power America Management | 57697 | S0116 | Aerojet I (3.6MW) Solar Plant | CA | 3.6 | 6749 |
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
|---|---|---|---|---|---|---|---|---|
| 0 | Year | Company Name | EIA Plant ID | CEC Plant ID | Plant Name | State | Capacity (MW) | Net MWh |
| 1 | 2012 | Agua Caliente Solar LLC | 57373 | S0242 | Agua Caliente Solar (AZ) | AZ | 243.0 | 378105 |
| 2 | 2012 | Copper Mountain Solar | 57205 | S0243 | Copper Mountain I (NV) | NV | 58.0 | 65958 |
| 3 | 2012 | Copper Mountain Solar | 58017 | S0244 | Copper Mountain II (NV) | NV | 94.5 | 73593 |
| 4 | NaN | Total | 395.5 | 517656 | NaN | NaN | NaN | NaN |
| 0 | 1 | 2 | |
|---|---|---|---|
| 0 | Year | Capacity (MW) | Net MWh |
| 1 | 2016 | 11500.1 | 23080144 |
| 2 | 2015 | 8500.9 | 18061557 |
| 3 | 2014 | 7053.4 | 12732661 |
| 4 | 2013 | 4424.4 | 5500727 |
| 0 | 1 | 2 | |
|---|---|---|---|
| 0 | County | Capacity (MW) | Net MWh |
| 1 | Alameda | 14.5 | 23542 |
| 2 | Butte | 5.2 | 7620 |
| 3 | Calaveras | 1.8 | 2838 |
| 4 | Clark | 152.5 | 139551 |
Downloading All Years¶
We would now like to programmatically extract the data for all the available years. We can break this into three steps:
- Get the list of possible years
- Download the data for each year
- Combine the data into a single DataFrame
Get the list of possible years¶
We would like to programatically extract the possible years we can submit to the form. To do this we will use the BeatifulSoup (version 4) Library. This is a fairly sophisticated library for reading and navigating HTML documents. We won't cover this library in detail in Data100 but it will be helpful for you to know about it:
In [16]:
from bs4 import BeautifulSoup
Beautiful Soup Makes HTML Readable¶
You can use Beautiful soup to parse an HTML document and reindent it:
In [17]:
dom = BeautifulSoup(resp.content.decode(encoding), "html.parser")
print(dom.prettify())
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd" >
<html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>
California Solar Energy Statistics & Data
</title>
<!-- META -->
<meta content="text/html; charset=utf-8" http-equiv="content-type"/>
<meta content="text/css" http-equiv="Content-Style-Type"/>
<meta content="California Energy Commission" name="Author"/>
<meta content="California Energy Commission" name="Description"/>
<meta content="California, state, government, energy" name="Keywords"/>
<meta content="English" name="language"/>
<!-- CSS -->
<link href="/css/main.css" media="screen, projection, print, tv" rel="stylesheet" type="text/css"/>
<link href="/css/minidropdown.css" media="screen, projection, print, tv" rel="stylesheet" type="text/css"/>
<link href="/css/energy.css" media="screen, projection, print, tv" rel="stylesheet" type="text/css"/>
<link href="/css/block.css" media="screen, projection, print, tv" rel="stylesheet" type="text/css"/>
<link href="/css/table.css" media="screen, projection, print, tv" rel="stylesheet" type="text/css"/>
<!--[if IE 6]>
<link rel="stylesheet" type="text/css" href="/css/ie6.css" />
<![endif]-->
<script type="text/javascript">
<!--
var defaultMainList = "Home";
// -->
</script>
<script src="/javascript/scripts.js" type="text/javascript">
</script>
<style>
td{
font-size:.85em;
}
th{
font-size:.85em;
background-color:#dddddd;
text-align:center;
}
.tot{
background-color:#dddddd;
font-weight:bold;
text-align:right;
}
.right{
text-align:right;
}
</style>
</head>
<body class="javascript_off one_column_page">
<!-- MEGA DROP-DOWN -->
<!-- call the script for the new google analytics -->
<script src="/javascript/gatag.js" type="text/javascript">
</script>
<!-- for fancyBox V2.1.5 -->
<script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript">
</script>
<link href="/fancybox/jquery.fancybox.css" media="screen" rel="stylesheet" type="text/css"/>
<script src="/fancybox/jquery.fancybox.pack.js" type="text/javascript">
</script>
<!--end fancy box-->
<div id="header">
<div id="skip_to_content">
<a href="#main_content">
Skip to Main Content
</a>
</div>
<div class="head_cagov_logo">
<a href="http://www.ca.gov/">
<img alt="CA.gov" src="/images/header_ca.gov.png"/>
</a>
</div>
<div class="head_organization_banner">
<a href="/">
<img alt="California Energy Commission" src="/images/header_organization.png"/>
</a>
</div>
<div id="head_links">
<a href="http://www.ca.gov/">
CA.gov
</a>
|
<a href="/contactus.html">
Contact
</a>
|
<a href="/newsroom/">
Newsroom
</a>
|
<a href="/newnav/quicklinks.html">
Quick Links
</a>
</div>
<!-- adds fancyBox V2.1.5 when the document is loaded-->
<!-- disable fancybox bottom title -->
<script type="text/javascript">
$(".fancybox2")
.attr('rel', 'gallery')
.fancybox({
openEffect : 'none',
helpers : {
title : null
}
});
</script>
<div id="inline1" style="width:500px;display: none; BACKGROUND-COLOR: #e6efcd; padding:6px; font-family:arial,sans-serif; font-size:1em;">
<h3 style="margin-top:-.5px;">
Google Translate™ Disclaimer
</h3>
<p>
This link to the Google Translate™ web application is provided for the convenience of our website visitors and is for informational purposes only.
</p>
<p>
The California Energy Commission does not guarantee the accuracy or timeliness of any translation produced by the Google Translate™ automated web application and is not liable for any inaccurate information resulting from the use of the Google Translate™.
</p>
<p>
The California Energy Commission does not endorse the use of Google Translate™; other translation services may be available to translate the information on our site. Please refer to the Energy Commission's website
<a href="/conditions.html">
Conditions of Use
</a>
.
</p>
<p>
For more information about Google Translate™, please visit:
<br/>
<a href="http://translate.google.com/about/intl/en_ALL/">
http://translate.google.com/about/intl/en_ALL/
</a>
.
</p>
<p>
Please consult a translator for accuracy if you are relying on the translation or are using this site for official business.
</p>
<p>
Select a language below:
</p>
<!--Google Translate -->
<div id="google_translate_element">
</div>
<script type="text/javascript">
function googleTranslateElementInit() {
new google.translate.TranslateElement({pageLanguage: 'en', layout: google.translate.TranslateElement.InlineLayout.SIMPLE, autoDisplay: false, gaTrack: true, gaId: 'UA-20973992-7'}, 'google_translate_element');
// begin accessibility compliance
$('img.goog-te-gadget-icon').attr('alt','Google Translate');
$('div#goog-gt-tt div.logo img').attr('alt','translate');
// end accessibility compliance
}
</script>
<script src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit" type="text/javascript">
</script>
<!-- end Google Translate-->
<p style="text-align:right;">
<a href="javascript:parent.jQuery.fancybox.close();">
Click to close this disclaimer and return to web page.
</a>
</p>
</div>
<!-- SEARCH -->
<!--#include virtual="/javascript/searchNew.js" -->
<div id="head_search">
<gcse:searchbox-only newwindow="true" resultsurl="/serp.html">
</gcse:searchbox-only>
</div>
<!--<script type="text/javascript" src="http://www.google.com/jsapi/"></script>
<script type="text/javascript" src="/javascript/search.js"></script>
<div id="head_search">
<form id="ca_form" class="hidden" method="get" action="http://www.google.com/cse/">
<div class="textfield_container">
<label for="search_ca_textfield" accesskey="s" class="hidden">Statewide search: </label>
<input type="text" name="q" id="search_ca_textfield" size="40" value="Search" onfocus="if(this.value=='Search')this.value=''" onblur="if(this.value=='')this.value='Search'" />
<input type="hidden" name="cx" value="001779225245372747843:mdsmtl_vi1a" />
<input type="hidden" name="cof" value="" />
<input type="hidden" name="ie" value="UTF-8" />
</div>
<div class="submit_container">
<input type="image" alt="Search" title="Search" name="submit" src="/images/search/header_search_submitbutton.png" />
</div>
</form>
<form id="local_form" method="get" action="http://www.google.com/cse/">
<div class="textfield_container">
<label for="search_local_textfield" accesskey="s" class="hidden">Search this site: </label>
<input type="text" name="q" id="search_local_textfield" size="40" value="Search" onfocus="if(this.value=='Search')this.value=''" onblur="if(this.value=='')this.value='Search'" />
<input type="hidden" name="cx" value="001779225245372747843:ctr4z8fr3aa" />-->
<!-- update this value with your search engine unique ID. Submit a request to the OTech Service Desk if you don't already know your unique search engine ID. -->
<!--<input type="hidden" name="cof" value="" />
<input type="hidden" name="ie" value="UTF-8" />
</div>
<div class="submit_container">
<input type="image" alt="Search" title="Search" name="submit" src="/images/search/header_search_submitbutton.png" />
</div>
</form>
<form id="control" action="/serp.html">
<div id="radio_container">
<input type="radio" name="which" id="head_srch_local" value="local" class="radiobutton" checked="checked" />
<label for="head_srch_local" accesskey="l" id="head_srch_l_lbl">This Site</label>
<input type="radio" name="which" id="head_srch_ca" value="ca" class="radiobutton" />
<label for="head_srch_ca" accesskey="c" id="head_srch_c_lbl">California</label>
</div>
</form>
</div>-->
<!-- DROP-DOWN NAVIGATION -->
<div id="navigation">
<ul id="nav_list">
<li class="nobackground">
<a class="nav_level1_link notranslate" href="/">
Home
</a>
</li>
<!--ABOUT US-->
<li>
<a class="nav_level1_link notranslate" href="/commission/">
About Us
</a>
<div class="nav_panel">
<ul>
<li>
<a class="nav_p_heading" href="/commission/">
About
</a>
</li>
<li>
<a class="nav_p_heading" href="/business_meetings/">
Business Meetings
</a>
</li>
<li>
<a class="nav_p_heading" href="/calendar/">
Calendar
</a>
</li>
<li>
<a class="nav_p_heading" href="/commissioners/">
Commissioners
</a>
</li>
<li>
<a class="nav_p_heading" href="/commission/diversity/">
Diversity Commitment
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/commission/executive/index.html">
Executive Leadership
</a>
</li>
<li>
<a class="nav_p_heading" href="/commission/fact_sheets/fact_sheets.html">
Fact Sheets
</a>
</li>
<li>
<a class="nav_p_heading" href="/commission/FPPC_form_801/">
Form 801
</a>
</li>
<li>
<a class="nav_p_heading" href="/careers/jobs.html">
Job Opportunities
</a>
</li>
<li>
<a class="nav_p_heading" href="/newsroom/">
Newsroom
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/commission/enforcement/">
Office of Compliance Assistance & Enforcement
</a>
</li>
<li>
<a class="nav_p_heading" href="/dockets/">
Proceedings
</a>
</li>
<li>
<a class="nav_p_heading" href="/public_adviser/">
Public Adviser's Office
</a>
</li>
</ul>
</div>
</li>
<!-- ELECTRICITY SUPPLY ANALYSIS -->
<li>
<a class="nav_level1_link notranslate" href="/assessments/">
Analysis & Stats
</a>
<div class="nav_panel">
<ul>
<li>
<a class="nav_p_heading" href="/almanac/">
Energy Almanac
</a>
</li>
<li>
<a class="nav_p_heading" href="/assessments/">
Energy Assessments Division
</a>
</li>
<li>
<a class="nav_p_heading" href="http://ecdms.energy.ca.gov/">
Energy Consumption Database
</a>
</li>
<li>
<a class="nav_p_heading" href="/almanac/electricity_data/">
Electricity Data, Facts, and Statistics
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/emergencies/">
Energy Emergency Planning
</a>
</li>
<li>
<a class="nav_p_heading" href="/almanac/petroleum_data/fuels_watch/">
Fuels Watch Report
</a>
</li>
<li>
<a class="nav_p_heading" href="/almanac/transportation_data/gasoline/">
Gasoline Statistics and Data
</a>
</li>
<li>
<a class="nav_p_heading" href="/energypolicy/">
Integrated Energy Policy Report (IEPR)
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/almanac/naturalgas_data/">
Natural Gas Statistics
</a>
</li>
<li>
<a class="nav_p_heading" href="/pou_reporting/">
Publicly Owned Utilities Reporting
</a>
</li>
<li>
<a class="nav_p_heading" href="http://californiasolarstatistics.ca.gov/">
Solar Statistics
</a>
</li>
</ul>
</div>
</li>
<!--EFFICIENCY-->
<li>
<a class="nav_level1_link notranslate" href="/efficiency/">
Efficiency
</a>
<div class="nav_panel">
<ul>
<li>
<a class="nav_p_heading" href="/title24/2013standards/">
2013 Building Energy Standards
</a>
</li>
<li>
<a class="nav_p_heading" href="/title24/2016standards/">
2016 Building Energy Standards
</a>
</li>
<li>
<a class="nav_p_heading" href="/title24/2019standards/">
2019 Building Energy Standards
</a>
</li>
<li>
<a class="nav_p_heading" href="/title24/attcp/">
Acceptance Test Technician
<br/>
Certification Provider Program
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/appliances/">
Appliance Efficiency Program - Title 20
</a>
</li>
<li>
<a class="nav_p_heading" href="/title24/">
Building Energy Efficiency - Title 24
</a>
</li>
<li>
<a class="nav_p_heading" href="/efficiency/proposition39/">
Clean Energy Jobs Act - Prop 39
</a>
</li>
<li>
<a class="nav_p_heading" href="/sb350/doubling_efficiency_savings/">
Doubling Energy Efficiency Savings
</a>
</li>
<!--<li><a href="/drought/rebate/" class="nav_p_heading">Drought Rebate Program</a></li>-->
<li>
<a class="nav_p_heading" href="/efficiency/listservers.html">
Energy Efficiency Email Subscriptions
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/ab758/">
Energy Efficiency in Existing Buildings
</a>
</li>
<li>
<a class="nav_p_heading" href="/efficiency/contacts.html">
Energy Efficiency Program Contacts
</a>
</li>
<li>
<a class="nav_p_heading" href="/efficiency/financing.html">
Financing Opportunities
</a>
</li>
<li>
<a class="nav_p_heading" href="/HERS/">
Home Energy Rating System (HERS)
</a>
</li>
<li>
<a class="nav_p_heading" href="/title24/orc/">
Online Resource Center - Title 24
</a>
</li>
</ul>
</div>
</li>
<!--FUNDING-->
<li>
<a class="nav_level1_link notranslate" href="/contracts/">
Funding
</a>
<div class="nav_panel">
<ul>
<li>
<a class="nav_p_heading" href="/efficiency/proposition39/">
Clean Energy Jobs Act - Prop 39
</a>
</li>
<li>
<a class="nav_p_heading" href="http://www.energyupgradeca.org/">
Consumer Rebates and Incentives
</a>
</li>
<li>
<a class="nav_p_heading" href="/efficiency/financing/">
Energy Efficiency Financing
</a>
</li>
<li>
<a class="nav_p_heading" href="/contracts/smallgrant/">
Energy Innovations Small Grant (EISG)
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/contracts/epic.html">
EPIC Funding Opportunities
</a>
</li>
<li>
<a class="nav_p_heading" href="/contracts/other_research.html">
More Research Solicitations
</a>
</li>
<li>
<a class="nav_p_heading" href="/contracts/pier.html">
Natural Gas Research Solicitations
</a>
</li>
<li>
<a class="nav_p_heading" href="/contracts/">
Proposals, Contracts, and Solicitations
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/contracts/small_business.html">
Small Business Information
</a>
</li>
<li>
<a class="nav_p_heading" href="http://www.gosolarcalifornia.org/">
Solar Electricity Rebates
</a>
</li>
<li>
<a class="nav_p_heading" href="/contracts/transportation.html">
Transportation Solicitations
</a>
</li>
<li>
<a class="nav_p_heading" href="/newnav/funding_links.html">
More Funding Information
</a>
</li>
</ul>
</div>
</li>
<!--POWER PLANTS-->
<li>
<a class="nav_level1_link notranslate" href="/sitingcases/alphabetical.html">
Power Plants
</a>
<div class="nav_panel">
<ul>
<li>
<a class="nav_p_heading" href="/maps/">
California Energy Maps
</a>
</li>
<li>
<a class="nav_p_heading" href="http://www.drecp.org/">
DRECP
</a>
</li>
<li>
<a class="nav_p_heading" href="/commission/chief_counsel/docket.html">
Dockets Unit
</a>
</li>
<li>
<a class="nav_p_heading" href="/e-filing/">
E-filing and Commenting
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/newnav/power_plant_links.html">
Power Plant Licensing Cases
</a>
</li>
<li>
<a class="nav_p_heading" href="/sitingcases/all_projects.html">
Power Plant Projects Status
</a>
</li>
<li>
<a class="nav_p_heading" href="/sitingcases/alphabetical.html">
Power Plants
</a>
</li>
<li>
<a class="nav_p_heading" href="/public_adviser/">
Public Adviser's Office
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/siting/">
Siting, Transmission, and Environmental Protection Division
</a>
</li>
<li>
<a class="nav_p_heading" href="/newnav/power_plant_additional_links.html">
More Power Plant Information
</a>
</li>
</ul>
</div>
</li>
<!--RENEWABLES-->
<li>
<a class="nav_level1_link notranslate" href="/renewables/renewable_links.html">
Renewables
</a>
<div class="nav_panel">
<ul>
<li>
<a class="nav_p_heading" href="/sb350/">
Clean Energy & Pollution Reduction
<br/>
Act (SB 350)
</a>
</li>
<li>
<a class="nav_p_heading" href="http://www.drecp.org/">
DRECP
</a>
</li>
<li>
<a class="nav_p_heading" href="/research/epic/">
Electric Program Investment Charge (EPIC)
</a>
</li>
<li>
<a class="nav_p_heading" href="http://www.gosolarcalifornia.ca.gov/">
Go Solar California
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="http://www.gosolarcalifornia.org/about/nshp.php">
New Solar Homes Partnership
</a>
</li>
<li>
<a class="nav_p_heading" href="/pcl/">
Power Source Disclosure
</a>
</li>
<li>
<a class="nav_p_heading" href="/portfolio/rps_pou_reports.html">
Publicly Owned Utilities Reports and Notices
</a>
</li>
<li>
<a class="nav_p_heading" href="/renewables/">
Renewable Energy Overview
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/renewables/renewable_links.html">
Renewable Energy Programs
</a>
</li>
<li>
<a class="nav_p_heading" href="/reti/">
Renewable Energy Transmission Initiative 2.0 (RETI)
</a>
</li>
<li>
<a class="nav_p_heading" href="/portfolio/">
Renewables Portfolio Standards (RPS)
</a>
</li>
<li>
<a class="nav_p_heading" href="/renewables/tracking_progress/">
Tracking Progress
</a>
</li>
</ul>
</div>
</li>
<!--RESEARCH-->
<li>
<a class="nav_level1_link notranslate" href="/research/">
Research
</a>
<div class="nav_panel">
<ul>
<li>
<a class="nav_p_heading" href="/research/buildings/">
Building Energy Efficiency Research
</a>
</li>
<li>
<a class="nav_p_heading" href="/tour/">
Clean Energy Tour
</a>
</li>
<li>
<a class="nav_p_heading" href="/research/epic/">
Electric Program Investment Charge (EPIC)
</a>
</li>
<li>
<a class="nav_p_heading" href="/research/energystorage/tour/">
Energy Storage Tour
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/research/environmental/">
Environmental Research
</a>
</li>
<li>
<a class="nav_p_heading" href="/contracts/epic.html">
EPIC Funding Opportunities
</a>
</li>
<li>
<a class="nav_p_heading" href="/research/iaw/">
Industrial, Agriculture, and Water Research
</a>
</li>
<li>
<a class="nav_p_heading" href="/contracts/other_research.html">
More Research Solicitations
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/contracts/pier.html">
Natural Gas Research Solicitations
</a>
</li>
<li>
<a class="nav_p_heading" href="/research/renewable/">
Renewable Energy Research
</a>
</li>
<li>
<a class="nav_p_heading" href="/research/">
Research and Development
</a>
</li>
<li>
<a class="nav_p_heading" href="/research/transportation/">
Transportation Energy Research
</a>
</li>
<!--<li><a href="/wet/" class="nav_p_heading">Water Energy Technology Program (WET)</a></li> -->
</ul>
</div>
</li>
<!--TRANSPORTATION-->
<li>
<a class="nav_level1_link notranslate" href="/transportation/">
Transportation
</a>
<div class="nav_panel">
<ul>
<li>
<a class="nav_p_heading" href="/altfuels/">
Alternative Fuels Program
</a>
</li>
<li>
<a class="nav_p_heading" href="/drive/">
DRIVE
</a>
</li>
<li>
<a class="nav_p_heading" href="/transportation/tour/">
Driving to Cleaner Transportation Tour
</a>
</li>
<li>
<a class="nav_p_heading" href="/emergencies/">
Energy Emergency Planning
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/transportation/">
Fuels and Transportation Division
</a>
</li>
<li>
<a class="nav_p_heading" href="/almanac/transportation_data/gasoline/">
Gasoline Statistics and Data
</a>
</li>
<li>
<a class="nav_p_heading" href="/emergencies/setaside.html">
Petroleum Fuels Set-Aside Program
</a>
</li>
<li>
<a class="nav_p_heading" href="/almanac/petroleum_data/">
Petroleum Industry and Information
</a>
</li>
</ul>
<ul>
<li>
<a class="nav_p_heading" href="/piira/">
Petroleum Industry Information Reporting Act (PIIRA)
</a>
</li>
<li>
<a class="nav_p_heading" href="/newnav/transportation_links.html">
More Transportation Information
</a>
</li>
</ul>
</div>
</li>
</ul>
</div>
<div id="img_ribbon">
</div>
</div>
<!-- GOOGLE ANALYTICS updated 1/7/15 - CG -->
<script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-20973992-7']); // you MUST replace this with your google analytics profile code, either from your own google account, or contact OTech to have one set up for you
_gaq.push(['_gat._anonymizeIp']);
_gaq.push(['_setDomainName', '.ca.gov']);
_gaq.push(['_trackPageview']);
_gaq.push(['b._setAccount', 'UA-3419582-2']); // statewide analytics - do not remove or change
_gaq.push(['b._setDomainName', '.ca.gov']);
_gaq.push(['b._trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>
<div id="page_container">
<div id="banner">
<img alt="Geometric pattern" height="225" src="/images/banners/almanac_renewable.jpg" width="936"/>
</div>
<div class="breadcrumbs">
<a href="/">
Home
</a>
<span class="crumb">
<a href="/almanac/">
almanac
</a>
</span>
<span class="crumb">
<a href="/almanac/renewables_data/">
renewables data
</a>
</span>
</div>
<div id="main_content">
<h1 style="font-size:1.8em;">
California Solar Energy Statistics & Data
</h1>
<div style="width:410px; float:right; height:350px;">
<img alt="Solar Energy Generating Station in Mojave Desert" height="317" src="../images/kramer-junction-400x317.jpg" style="margin-left:10px;" title="Solar Energy Generating Station in Mojave Desert" width="400"/>
<p style="float:right; padding-right:20px; font-size:.8em;">
Photo by Warren Gretz NREL 01225
</p>
</div>
<p>
Solar electricity production in California falls into two categories - solar thermal, using the concentrated heat of sunlight to heat a fluid to make steam to turn a traditional turbine and generator making electricity; and solar photovoltaic (PV), the direct conversion of sunlight into electricity.
Additionally, the heat from the sun is used in solar thermal systems for hot water in homes and businesses and in heating swimming pools.
Most electricity from PV is not counted into the total electricity production of the utility companies as the solar panels are mounted on individual homes or businesses.
</p>
<p>
Solar thermal facilities are concentrated in the desert areas of the state in the Mojave area.
In 2012, solar PV and solar thermal power plants produced 1,885 gigawatt-hours (GWh) of energy or 0.94 percent of the state's total electricity production. A total of 258 operating Solar power plants, with an installed capacity about 1,190 megawatts, are in California.
</p>
<p>
Prior to the Renewable Portfolio Standards in 2002, 13 solar thermal power projects were planned in California, with 11 of those filing applications with the Energy Commission.
<a href="/sitingcases/solar/.">
Nine projects (Solar Energy Generating Station - SEGS I to IX)
</a>
, totaling 354 MW, were built. SEGS III to IX are owned by FPL Energy, and SEGS I and II are owned by Sunray Energy Inc.
Approximately 4,500 MW of solar thermal is in the license review process or are planned to be built.
</p>
<p>
Solar PV surpassed solar thermal in installed capacity in 2008. The cumulative installed capacity reached 441 MW by the end of 2008, eclipsing the 354 MW of solar thermal.
Assuming each system installed kW produced 1,500 kWh, then California PV systems produced 661,500,000 kWh (661.5 GWh).
That's nearly as much as the 675 GWh of electricity by solar thermal in 2007.
</p>
<p>
One large photovoltaic (PV) array was built by the Sacramento Municipal Utility District near its Rancho Seco Nuclear Plant. It went on line in August 1984 and has an installed capacity of 3.19 MW.
However, utility-scale PV projects are being planned. There are two of them planned in San Luis Obispo County totaling 800 megawatts in installed capacity.
</p>
<br/>
<ul>
<!-- <li><a href="pv.html">Solar PV Electricity</a></li> -->
<li>
<a href="http://www.gosolarcalifornia.org" target="_new">
Rebates for Solar PV Systems
</a>
(Go Solar California website)
</li>
<!--<li><a href="http://www.energy.ca.gov/siting/solar/index.html#pv" target="_new">Utility-Scale Solar Photovoltaic Projects</a></li>-->
<li>
<a href="http://www.energy.ca.gov/sitingcases/solar/">
Solar Energy Projects in California
</a>
</li>
<!--<li>Solar Hot Water Systems (coming soon)</li>-->
</ul>
<p class="bold">
Contact: Michael Nyberg,
<a href="mailto:Michael.Nyberg@energy.ca.gov">
michael.nyberg@energy.ca.gov
</a>
</p>
<div class="cleaner">
</div>
<br/>
<div class="block_with_rounded_corners">
<h2>
Solar PV and Solar Thermal Electricity Production
</h2>
<br/>
<form action="index.php" method="post" style="margin-left:23px;">
<select id="goYear" name="newYear">
<option value="2016">
Go to a Different Year
</option>
<option value="2016">
2016
</option>
<option value="2015">
2015
</option>
<option value="2014">
2014
</option>
<option value="2013">
2013
</option>
<option value="2012">
2012
</option>
<option value="2011">
2011
</option>
<option value="2010">
2010
</option>
<option value="2009">
2009
</option>
<option value="2008">
2008
</option>
<option value="2007">
2007
</option>
<option value="2006">
2006
</option>
<option value="2005">
2005
</option>
<option value="2004">
2004
</option>
<option value="2003">
2003
</option>
<option value="2002">
2002
</option>
<option value="2001">
2001
</option>
</select>
<input type="submit" value="Go"/>
</form>
<br/>
<table style="width:97%;margin-top:5px;">
<tr>
<th colspan="8" style="font-size:1.3em;color:#ffffff;background-color:#5D7493;">
Solar Thermal
</th>
</tr>
<tr>
<th>
Year
</th>
<th>
Company Name
</th>
<th>
EIA
<br/>
Plant ID
</th>
<th>
CEC
<br/>
Plant ID
</th>
<th>
Plant Name
</th>
<th>
State
</th>
<th>
Capacity (MW)
</th>
<th>
Net MWh
</th>
</tr>
<tr>
<td>
2012
</td>
<td>
Sunray Energy Inc
</td>
<td>
10437
</td>
<td>
S0069
</td>
<td>
SEGS I - Retired 12/31/2015
</td>
<td>
CA
</td>
<td class="right">
13.8
</td>
<td class="right">
14,709
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Sunray Energy Inc
</td>
<td>
10438
</td>
<td>
S0070
</td>
<td>
SEGS II - Retired 12/31/2015
</td>
<td>
CA
</td>
<td class="right">
30.0
</td>
<td class="right">
37,205
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Luz Solar Partners Ltd III
</td>
<td>
10439
</td>
<td>
S0071
</td>
<td>
SEGS III
</td>
<td>
CA
</td>
<td class="right">
34.2
</td>
<td class="right">
70,934
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Luz Solar Partners Ltd IV
</td>
<td>
10440
</td>
<td>
S0072
</td>
<td>
SEGS IV
</td>
<td>
CA
</td>
<td class="right">
34.2
</td>
<td class="right">
78,718
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Luz Solar Partners Ltd IX
</td>
<td>
10446
</td>
<td>
S0073
</td>
<td>
SEGS IX
</td>
<td>
CA
</td>
<td class="right">
92.0
</td>
<td class="right">
224,457
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Luz Solar Partners Ltd V
</td>
<td>
10441
</td>
<td>
S0074
</td>
<td>
SEGS V
</td>
<td>
CA
</td>
<td class="right">
34.2
</td>
<td class="right">
81,382
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Luz Solar Partners Ltd VI
</td>
<td>
10442
</td>
<td>
S0075
</td>
<td>
SEGS VI
</td>
<td>
CA
</td>
<td class="right">
35.0
</td>
<td class="right">
78,628
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Luz Solar Partners Ltd VII
</td>
<td>
10443
</td>
<td>
S0076
</td>
<td>
SEGS VII
</td>
<td>
CA
</td>
<td class="right">
35.0
</td>
<td class="right">
77,982
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Luz Solar Partners Ltd VIII
</td>
<td>
10444
</td>
<td>
S0077
</td>
<td>
SEGS VIII
</td>
<td>
CA
</td>
<td class="right">
92.0
</td>
<td class="right">
202,146
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
eSolar Inc
</td>
<td>
57323
</td>
<td>
S0117
</td>
<td>
Sierra SunTower
</td>
<td>
CA
</td>
<td class="right">
7.5
</td>
<td class="right">
780
</td>
</tr>
<tr>
<td colspan="5">
</td>
<td class="tot">
Total
</td>
<td class="tot">
407.9
</td>
<td class="tot">
866,941
</td>
</tr>
</table>
<table style="width:97%;margin-top:5px;">
<tr>
<th colspan="8" style="font-size:1.3em;color:#ffffff;background-color:#5D7493;">
Solar PV
</th>
</tr>
<tr>
<th>
Year
</th>
<th>
Company Name
</th>
<th>
EIA
<br/>
Plant ID
</th>
<th>
CEC
<br/>
Plant ID
</th>
<th>
Plant Name
</th>
<th>
State
</th>
<th>
Capacity (MW)
</th>
<th>
Net MWh
</th>
</tr>
<tr>
<td>
2012
</td>
<td>
Los Angeles Department of Water & Power (LADWP)
</td>
<td>
57305
</td>
<td>
S0218
</td>
<td>
Adelanto Solar Power Project
</td>
<td>
CA
</td>
<td class="right">
10.0
</td>
<td class="right">
9,883
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9149
</td>
<td>
Advanced Micro Decives
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
4,865
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Altus Power America Management
</td>
<td>
57697
</td>
<td>
S0116
</td>
<td>
Aerojet I (3.6MW) Solar Plant
</td>
<td>
CA
</td>
<td class="right">
3.6
</td>
<td class="right">
6,749
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Altus Power America Management
</td>
<td>
57698
</td>
<td>
S0130
</td>
<td>
Aerojet II (2.4MW) Solar Plant
</td>
<td>
CA
</td>
<td class="right">
2.4
</td>
<td class="right">
4,497
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9047
</td>
<td>
Airport Division City of San Jose
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9121
</td>
<td>
Alameda Water District
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
2,027
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9046
</td>
<td>
Almond Process Parreira
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9006
</td>
<td>
Alza Corporation (700 Eubanks)
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9110
</td>
<td>
Amir Development Company
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,847
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9137
</td>
<td>
Angels PH Utica Power Authority
</td>
<td>
CA
</td>
<td class="right">
1.8
</td>
<td class="right">
2,838
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
57010
</td>
<td>
S9074
</td>
<td>
Anheuser Busch Fairfield PV Phase/Anheuser Busch
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9148
</td>
<td>
ANHEUSER BUSCH INC
</td>
<td>
CA
</td>
<td class="right">
2.5
</td>
<td class="right">
4,054
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9075
</td>
<td>
Applied Materials Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9073
</td>
<td>
AT&T; San Ramon (PV)/AT&T; Services Inc
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9142
</td>
<td>
AT&T; Services Inc.
</td>
<td>
CA
</td>
<td class="right">
2.1
</td>
<td class="right">
3,446
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9025
</td>
<td>
AT&T; Services Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Eurus Energy America Corporation
</td>
<td>
57359
</td>
<td>
S0126
</td>
<td>
Avenal Park Solar
</td>
<td>
CA
</td>
<td class="right">
6.0
</td>
<td class="right">
12,726
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9038
</td>
<td>
Beret & Kees Jan De Jong
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
NRG Solar Community 1 LLC
</td>
<td>
56939
</td>
<td>
S0111
</td>
<td>
Blythe 1 Solar
</td>
<td>
CA
</td>
<td class="right">
21.0
</td>
<td class="right">
47,879
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Sacramento PV Energy LLC
</td>
<td>
57670
</td>
<td>
S0157
</td>
<td>
Boessow (Van Connett Solar Farm)
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
6,033
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
SunEdison
</td>
<td>
56862
</td>
<td>
S0373
</td>
<td>
Bolthouse Farms - S&P;
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,752
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
SunEdison
</td>
<td>
Missing
</td>
<td>
S0372
</td>
<td>
Borrego Solar - Twin Oaks
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,752
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
SunEdison
</td>
<td>
Missing
</td>
<td>
S0356
</td>
<td>
CA State Prison LA County
</td>
<td>
CA
</td>
<td class="right">
2.0
</td>
<td class="right">
115
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
56813
</td>
<td>
S9026
</td>
<td>
CA State University Fresno
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9077
</td>
<td>
California National Guard
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9062
</td>
<td>
California Natural Products
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Meridian Energy USA Inc
</td>
<td>
56768
</td>
<td>
S0121
</td>
<td>
CalRENEW-1
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
10,478
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9139
</td>
<td>
Campbell Soup Supply Company LLC
</td>
<td>
CA
</td>
<td class="right">
2.0
</td>
<td class="right">
3,918
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Pacific Gas & Electric (PG&E;)
</td>
<td>
57522
</td>
<td>
S0176
</td>
<td>
Cantua Solar Station
</td>
<td>
CA
</td>
<td class="right">
20.0
</td>
<td class="right">
24,082
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9083
</td>
<td>
Carl Zeiss Meditec Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
EDF Renewable Energy Inc
</td>
<td>
57708
</td>
<td>
S0081
</td>
<td>
Catalina Solar Phase I and II
</td>
<td>
CA
</td>
<td class="right">
110.0
</td>
<td class="right">
200
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9082
</td>
<td>
Cemex Construction Materials Pacific LLC
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9130
</td>
<td>
Central Marin Sanitation Agency
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
2,432
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9123
</td>
<td>
Chabot - Las Positas Community College
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
2,076
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9146
</td>
<td>
Chabot Las Positas Community College District
</td>
<td>
CA
</td>
<td class="right">
2.3
</td>
<td class="right">
3,783
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9089
</td>
<td>
Charles R. Crain Jr.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9090
</td>
<td>
City of Atwater
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9021
</td>
<td>
City of Chico
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9060
</td>
<td>
City of Dinuba
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9145
</td>
<td>
City of Fresno - Fresno Yosemite Airport
</td>
<td>
CA
</td>
<td class="right">
2.3
</td>
<td class="right">
3,649
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9061
</td>
<td>
City of Hollister
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
57682
</td>
<td>
S9048
</td>
<td>
City of Madera
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9094
</td>
<td>
City of San Jose
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,638
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9095
</td>
<td>
City of Santa Clara
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,646
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9124
</td>
<td>
City of Santa Cruz Wastewater Treatment Plant
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
2,108
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9150
</td>
<td>
City of Stockton - Wastewater Control Facility
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
4,865
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9134
</td>
<td>
City of Sunnyvale Wastewater Treatment Plant
</td>
<td>
CA
</td>
<td class="right">
1.6
</td>
<td class="right">
2,595
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9099
</td>
<td>
City of Yuba
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,662
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9055
</td>
<td>
Clos Du Bois Wines Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
57006
</td>
<td>
S9010
</td>
<td>
Co. Inc. #21 Walgreens
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9024
</td>
<td>
Codding Enterprises
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9057
</td>
<td>
Codding Enterprises Ltd Partnership
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9016
</td>
<td>
College District Contra Costa Community 1
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9017
</td>
<td>
College District Contra Costa Community 2
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9045
</td>
<td>
College District Kern Community
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9039
</td>
<td>
Community College District Chabot Las Positas
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9052
</td>
<td>
Community College Mendocino
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9063
</td>
<td>
Community Hospital of Monterey Peninsula
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9117
</td>
<td>
Contra Costa Community College - DVC
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
1,987
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9118
</td>
<td>
Contra Costa Community College - Los Medanos
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
2,003
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9079
</td>
<td>
County of Kern
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9015
</td>
<td>
County of Lake
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9101
</td>
<td>
County of Santa Clara
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,687
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9103
</td>
<td>
County of Santa Clara
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,711
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9125
</td>
<td>
County of Sonoma
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
2,126
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9027
</td>
<td>
CSU Bakersfield
</td>
<td>
CA
</td>
<td class="right">
1.4
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9028
</td>
<td>
CSU Monterey Bay - PV
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Dependable Highway Express Inc
</td>
<td>
57871
</td>
<td>
S0184
</td>
<td>
Dependable Highway Express
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,533
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9116
</td>
<td>
Dependable Highway Express Inc
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
1,974
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9035
</td>
<td>
E & J Gallo Winery
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9056
</td>
<td>
E&J; Gallo Winery
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9131
</td>
<td>
Equity Office Property
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
2,432
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9097
</td>
<td>
FAA Norcal TRACON
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,652
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9004
</td>
<td>
Farm ACW
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,621
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Pacific Gas & Electric (PG&E;)
</td>
<td>
57498
</td>
<td>
S0140
</td>
<td>
Five Points Solar Station
</td>
<td>
CA
</td>
<td class="right">
15.0
</td>
<td class="right">
29,946
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9008
</td>
<td>
Foods Inc. United Natural
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9135
</td>
<td>
Foothill - De Anza Community College District
</td>
<td>
CA
</td>
<td class="right">
1.6
</td>
<td class="right">
2,604
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9136
</td>
<td>
Foothill College - Pv Capstone
</td>
<td>
CA
</td>
<td class="right">
1.7
</td>
<td class="right">
2,781
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9013
</td>
<td>
Fosters Wine Estates Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9085
</td>
<td>
Fowler Packing Company Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9086
</td>
<td>
Fowler Packing Company Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9001
</td>
<td>
FPUD - Sanitary
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,619
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9064
</td>
<td>
Fremont Group 50 Beale/DG Cogen Partners LLC
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9113
</td>
<td>
Fremont Group Inc. 50 Beale/DG Cogen Partners LLC
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
1,897
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9065
</td>
<td>
General Chemical Corp/Chevron Energy Solutions
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9076
</td>
<td>
George Jackson
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9066
</td>
<td>
Ghiradelli Chocolate
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Pacific Gas & Electric (PG&E;)
</td>
<td>
57521
</td>
<td>
S0178
</td>
<td>
Giffen Solar Station
</td>
<td>
CA
</td>
<td class="right">
10.0
</td>
<td class="right">
10,644
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Borrego Solar/Golden Springs Development Company LLC
</td>
<td>
57796
</td>
<td>
S0208
</td>
<td>
Golden Springs Building C1
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
1,739
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Borrego Solar/Golden Springs Development Company LLC
</td>
<td>
57797
</td>
<td>
S0209
</td>
<td>
Golden Springs Building D1
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
714
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9012
</td>
<td>
Golden State Vintners
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9005
</td>
<td>
Google Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9031
</td>
<td>
Google Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9102
</td>
<td>
Granite Construction Company
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,703
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
OL Elk Grove Trust a Delaware Statutory Trust
</td>
<td>
57849
</td>
<td>
S0204
</td>
<td>
Green Acres Solar Facility 1
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
1,742
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
OL Elk Grove Trust a Delaware Statutory Trust
</td>
<td>
57850
</td>
<td>
S0203
</td>
<td>
Green Acres Solar Facility 2
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
578
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9087
</td>
<td>
Grimmway Enterprises Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9088
</td>
<td>
Grimmway Enterprises Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9091
</td>
<td>
Grimmway Enterprises Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9014
</td>
<td>
Grundfos Pumps
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Sacramento PV Energy LLC
</td>
<td>
57669
</td>
<td>
S0156
</td>
<td>
Grundman-Wilkinson Solar Farm (Bruceville Road)
</td>
<td>
CA
</td>
<td class="right">
18.0
</td>
<td class="right">
35,489
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Los Angeles Community College District
</td>
<td>
57314
</td>
<td>
S0182
</td>
<td>
Harbor College LACCD
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,927
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9037
</td>
<td>
Health Plan Inc. Kaiser Foundation
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9049
</td>
<td>
Health Plan Inc. Kaiser Foundation
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Sacramento Municipal Utility District (SMUD)
</td>
<td>
7523
</td>
<td>
S0090
</td>
<td>
Hedge PV
</td>
<td>
CA
</td>
<td class="right">
0.2
</td>
<td class="right">
126
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9003
</td>
<td>
Hewlett Packard
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,620
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Pacific Gas & Electric (PG&E;)
</td>
<td>
57523
</td>
<td>
S0177
</td>
<td>
Huron Solar Station
</td>
<td>
CA
</td>
<td class="right">
20.0
</td>
<td class="right">
20,895
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9111
</td>
<td>
Indalex West Inc. ABANDONED
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
2,102
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9112
</td>
<td>
Independence HS
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
1,865
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Intertie
</td>
<td>
57860
</td>
<td>
S0221
</td>
<td>
Industry MetroLink PV 1
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
2,219
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9067
</td>
<td>
Inergy Propoane LLC
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9050
</td>
<td>
Ingomar Packing Co.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
58086
</td>
<td>
S9096
</td>
<td>
Intel Corporation
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,651
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9098
</td>
<td>
Intel Corporation
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,653
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
SunEdison
</td>
<td>
57007
</td>
<td>
S0357
</td>
<td>
Ironwood State Prison II
</td>
<td>
CA
</td>
<td class="right">
4.0
</td>
<td class="right">
3,504
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9122
</td>
<td>
Irrigation District South San Joaquin
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
2,027
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Imperial Valley Solar Company
</td>
<td>
58062
</td>
<td>
S0161
</td>
<td>
IVSC1 - (SunPeak 1) - 23MW PV
</td>
<td>
CA
</td>
<td class="right">
23.0
</td>
<td class="right">
28,822
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9033
</td>
<td>
Jackson Michael
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9104
</td>
<td>
JATCO
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,712
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9193
</td>
<td>
KDW Solar 1 LLC (KDW Solar 1 )
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
0
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9106
</td>
<td>
Kern County Water Agency
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,784
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9152
</td>
<td>
Kern County Water Agency
</td>
<td>
CA
</td>
<td class="right">
4.1
</td>
<td class="right">
6,689
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Konoike Pacific California Inc
</td>
<td>
57310
</td>
<td>
S0144
</td>
<td>
Konoike Pacific California Inc
</td>
<td>
CA
</td>
<td class="right">
1.4
</td>
<td class="right">
2,200
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Sacramento PV Energy LLC
</td>
<td>
57671
</td>
<td>
S0155
</td>
<td>
Kost (Fleshman Solar Farm)
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
5,868
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
L-8 Solar Project LLC
</td>
<td>
57836
</td>
<td>
S0226
</td>
<td>
L-8 Solar Project
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
129
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
LA County MTA/Metro
</td>
<td>
57313
</td>
<td>
S0183
</td>
<td>
LA County MTA/Metro
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,840
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Los Angeles Community College District
</td>
<td>
57314
</td>
<td>
S0152
</td>
<td>
LA Harbor College
</td>
<td>
CA
</td>
<td class="right">
1.8
</td>
<td class="right">
944
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Los Angeles Community College District
</td>
<td>
MISSING
</td>
<td>
S0219
</td>
<td>
LAPC Carport Shade Structures (Los Angeles Pierce College)
</td>
<td>
CA
</td>
<td class="right">
2.1
</td>
<td class="right">
944
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9153
</td>
<td>
Loma Linda VA Health Care System
</td>
<td>
CA
</td>
<td class="right">
2.8
</td>
<td class="right">
4,970
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9032
</td>
<td>
Lomo Cold Storage LLC
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9053
</td>
<td>
Los Gatos Tomato Products
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
58522
</td>
<td>
S9059
</td>
<td>
Madera Community Hospital
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
57005
</td>
<td>
S9009
</td>
<td>
Mariani Packing Co. Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9068
</td>
<td>
Market & Second Inc/Real Energy
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9034
</td>
<td>
Maxco Supply Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
K Road Modesto Solar LLC
</td>
<td>
58039
</td>
<td>
S0180
</td>
<td>
McHenry Solar Plant
</td>
<td>
CA
</td>
<td class="right">
25.5
</td>
<td class="right">
21,485
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9132
</td>
<td>
Mid Valley Dairy
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
2,432
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9114
</td>
<td>
MTA
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
1,907
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9023
</td>
<td>
Napa Valley College
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9128
</td>
<td>
Network Appliance
</td>
<td>
CA
</td>
<td class="right">
1.4
</td>
<td class="right">
2,277
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9069
</td>
<td>
Network Appliance/Chevron Energy Solutions
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9107
</td>
<td>
Nilsen Farms
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,796
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
SunEdison
</td>
<td>
Missing
</td>
<td>
S0359
</td>
<td>
North Kern State Prison II
</td>
<td>
CA
</td>
<td class="right">
4.0
</td>
<td class="right">
1,752
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9100
</td>
<td>
Norvartis Pharmaceuticals Corp
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,670
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9081
</td>
<td>
Ohlone Community College District
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9126
</td>
<td>
Olam West Coast
</td>
<td>
CA
</td>
<td class="right">
1.4
</td>
<td class="right">
2,192
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9133
</td>
<td>
Oro Loma Sanitary District
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
2,449
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9011
</td>
<td>
Paramount Farms Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
SunEdison
</td>
<td>
Missing
</td>
<td>
S0361
</td>
<td>
Patton State Hospital II
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
875
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9043
</td>
<td>
Peralta Community College Dist
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Los Angeles Community College District
</td>
<td>
58248
</td>
<td>
S0181
</td>
<td>
Pierce College LACCD
</td>
<td>
CA
</td>
<td class="right">
2.1
</td>
<td class="right">
3,679
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Sacramento PV Energy LLC
</td>
<td>
57753
</td>
<td>
S0154
</td>
<td>
Point Pleasant (Lawrence Solar Farm)
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
2,078
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9070
</td>
<td>
Pokka Bottling
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9042
</td>
<td>
Pollution Control Monterey Reg'l Water
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Port of Los Angeles
</td>
<td>
57309
</td>
<td>
S0142
</td>
<td>
Port of Los Angeles Berth 93
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,927
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9030
</td>
<td>
Port of Oakland
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9019
</td>
<td>
Power Agency Northern CA
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9051
</td>
<td>
Power Agency Northern California
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9044
</td>
<td>
Primex Farms LLC
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Sacramento Municipal Utility District (SMUD)
</td>
<td>
529
</td>
<td>
S0063
</td>
<td>
Rancho Seco Solar PV - Retired 3/31/2013
</td>
<td>
CA
</td>
<td class="right">
2.0
</td>
<td class="right">
150
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57783
</td>
<td>
S0284
</td>
<td>
RE Bruceville Solar 1
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
12,336
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57784
</td>
<td>
S0285
</td>
<td>
RE Bruceville Solar 2
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
11,424
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57785
</td>
<td>
S0286
</td>
<td>
RE Bruceville Solar 3
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
11,544
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57777
</td>
<td>
S0280
</td>
<td>
RE Dillard Road 1
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
7,185
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57779
</td>
<td>
S0281
</td>
<td>
RE Dillard Road 2
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
7,279
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57781
</td>
<td>
S0282
</td>
<td>
RE Dillard Road 3
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
7,198
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57806
</td>
<td>
S0283
</td>
<td>
RE Dillard Road 4
</td>
<td>
CA
</td>
<td class="right">
0.4
</td>
<td class="right">
868
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57778
</td>
<td>
S0205
</td>
<td>
RE Kammerer Road 1
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
12,288
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57780
</td>
<td>
S0206
</td>
<td>
RE Kammerer Road 2
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
11,268
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57782
</td>
<td>
S0207
</td>
<td>
RE Kammerer Road 3
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
11,292
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57816
</td>
<td>
S0211
</td>
<td>
RE McKenzie 1
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
855
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57817
</td>
<td>
S0212
</td>
<td>
RE McKenzie 2
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
878
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57818
</td>
<td>
S0213
</td>
<td>
RE McKenzie 3
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
910
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57819
</td>
<td>
S0214
</td>
<td>
RE McKenzie 4
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
904
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57820
</td>
<td>
S0215
</td>
<td>
RE McKenzie 5
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
848
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
X-Elio North America Inc.
</td>
<td>
57821
</td>
<td>
S0216
</td>
<td>
RE McKenzie 6
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
855
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Recurrent Energy LLC
</td>
<td>
Missing
</td>
<td>
S0220
</td>
<td>
RE Mohican
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,763
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Recurrent Energy LLC
</td>
<td>
55160
</td>
<td>
S0222
</td>
<td>
RE North Face
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
2,009
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
57276
</td>
<td>
S9007
</td>
<td>
Rice Mill Inc. Far West
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
South San Joaquin Irr District
</td>
<td>
57579
</td>
<td>
S0120
</td>
<td>
Robert O. Schulz Solar Farm #1 and #2
</td>
<td>
CA
</td>
<td class="right">
1.4
</td>
<td class="right">
2,293
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9120
</td>
<td>
Roplast Industries Inc.
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
2,019
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9000
</td>
<td>
Ruiz Foods
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,618
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9071
</td>
<td>
Salinas Valley Memorial Hospital
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9119
</td>
<td>
San Francisco State University
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
2,011
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9127
</td>
<td>
San Jose Evergreen Community College
</td>
<td>
CA
</td>
<td class="right">
1.4
</td>
<td class="right">
2,237
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9054
</td>
<td>
San Miguel Winery
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Eurus Energy America Corporation
</td>
<td>
57361
</td>
<td>
S0131
</td>
<td>
Sand Drag
</td>
<td>
CA
</td>
<td class="right">
19.0
</td>
<td class="right">
40,356
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9155
</td>
<td>
Sepulveda Ambulatory Care Center
</td>
<td>
CA
</td>
<td class="right">
4.0
</td>
<td class="right">
7,008
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
58028
</td>
<td>
S9036
</td>
<td>
Services Inc. #345 Ikea Distribution
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9002
</td>
<td>
Shasta College
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,620
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9092
</td>
<td>
Siemens Industry Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,624
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Sierra Nevada Brewing Company
</td>
<td>
58585
</td>
<td>
S0160
</td>
<td>
Sierra Nevada Brewing Solar
</td>
<td>
CA
</td>
<td class="right">
2.0
</td>
<td class="right">
2,357
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
SunEdison
</td>
<td>
57254
</td>
<td>
S0360
</td>
<td>
SolFocus - Victor Valley Community College
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
2,190
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9140
</td>
<td>
Southeast Wastwater Treatment Plant/CCSF
</td>
<td>
CA
</td>
<td class="right">
2.0
</td>
<td class="right">
3,243
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9151
</td>
<td>
Spansion LLC
</td>
<td>
CA
</td>
<td class="right">
3.0
</td>
<td class="right">
4,865
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
56976
</td>
<td>
S0119
</td>
<td>
SPVP001 Etiwanda Rooftop Solar (Merged with S0191)
</td>
<td>
CA
</td>
<td class="right">
2.4
</td>
<td class="right">
0
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
56996
</td>
<td>
S0118
</td>
<td>
SPVP002 Chino Rooftop Solar
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
919
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57217
</td>
<td>
S0128
</td>
<td>
SPVP003 Rialto
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
1,155
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57219
</td>
<td>
S0158
</td>
<td>
SPVP005 Redlands
</td>
<td>
CA
</td>
<td class="right">
3.4
</td>
<td class="right">
4,663
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57220
</td>
<td>
S0136
</td>
<td>
SPVP006 Ontario
</td>
<td>
CA
</td>
<td class="right">
2.5
</td>
<td class="right">
4,034
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57221
</td>
<td>
S0185
</td>
<td>
SPVP007 Redlands
</td>
<td>
CA
</td>
<td class="right">
3.2
</td>
<td class="right">
4,363
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57222
</td>
<td>
S0186
</td>
<td>
SPVP008 Ontario
</td>
<td>
CA
</td>
<td class="right">
2.8
</td>
<td class="right">
4,519
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57223
</td>
<td>
S0187
</td>
<td>
SPVP009 Ontario
</td>
<td>
CA
</td>
<td class="right">
1.4
</td>
<td class="right">
2,229
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57224
</td>
<td>
S0188
</td>
<td>
SPVP010 Fontana (Etiwanda)
</td>
<td>
CA
</td>
<td class="right">
2.3
</td>
<td class="right">
3,357
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57225
</td>
<td>
S0189
</td>
<td>
SPVP011 Redlands RDC 4
</td>
<td>
CA
</td>
<td class="right">
5.0
</td>
<td class="right">
7,106
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57227
</td>
<td>
S0190
</td>
<td>
SPVP013 Redlands
</td>
<td>
CA
</td>
<td class="right">
4.9
</td>
<td class="right">
5,826
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57229
</td>
<td>
S0191
</td>
<td>
SPVP015 Fontana (Etiwanda) includes SPVP001
</td>
<td>
CA
</td>
<td class="right">
4.7
</td>
<td class="right">
4,395
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57230
</td>
<td>
S0192
</td>
<td>
SPVP016 Redlands
</td>
<td>
CA
</td>
<td class="right">
1.8
</td>
<td class="right">
2,179
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57231
</td>
<td>
S0193
</td>
<td>
SPVP017 Fontana (Etiwanda)
</td>
<td>
CA
</td>
<td class="right">
4.5
</td>
<td class="right">
5,773
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57232
</td>
<td>
S0194
</td>
<td>
SPVP018 Fontana (Etiwanda)
</td>
<td>
CA
</td>
<td class="right">
1.9
</td>
<td class="right">
3,144
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57237
</td>
<td>
S0195
</td>
<td>
SPVP022 Redlands
</td>
<td>
CA
</td>
<td class="right">
3.1
</td>
<td class="right">
2,090
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57236
</td>
<td>
S0196
</td>
<td>
SPVP023 Fontana (Etiwanda)
</td>
<td>
CA
</td>
<td class="right">
3.9
</td>
<td class="right">
5,808
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57245
</td>
<td>
S0197
</td>
<td>
SPVP026 Rialto
</td>
<td>
CA
</td>
<td class="right">
8.6
</td>
<td class="right">
10,857
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57246
</td>
<td>
S0227
</td>
<td>
SPVP027 Rialto
</td>
<td>
CA
</td>
<td class="right">
2.6
</td>
<td class="right">
190
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57247
</td>
<td>
S0198
</td>
<td>
SPVP028 San Bernardino (Vista 28)
</td>
<td>
CA
</td>
<td class="right">
4.9
</td>
<td class="right">
6,730
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57534
</td>
<td>
S0199
</td>
<td>
SPVP032 Ontario - Kennedy 2
</td>
<td>
CA
</td>
<td class="right">
1.7
</td>
<td class="right">
2,323
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57535
</td>
<td>
S0200
</td>
<td>
SPVP033 Ontario - Kennedy 3
</td>
<td>
CA
</td>
<td class="right">
1.3
</td>
<td class="right">
1,882
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57441
</td>
<td>
S0201
</td>
<td>
SPVP042 Porterville (Vestal)
</td>
<td>
CA
</td>
<td class="right">
6.8
</td>
<td class="right">
10,962
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Southern California Edison (SCE)
</td>
<td>
57540
</td>
<td>
S0202
</td>
<td>
SPVP044 Perris (Valley)
</td>
<td>
CA
</td>
<td class="right">
10.2
</td>
<td class="right">
3,055
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
SunEdison
</td>
<td>
57904
</td>
<td>
S0210
</td>
<td>
SS San Antonio West LLC
</td>
<td>
CA
</td>
<td class="right">
1.9
</td>
<td class="right">
1,403
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9129
</td>
<td>
Stocker Resources/ Plains Exploration & Production Company
</td>
<td>
CA
</td>
<td class="right">
1.4
</td>
<td class="right">
2,311
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Pacific Gas & Electric (PG&E;)
</td>
<td>
57497
</td>
<td>
S0139
</td>
<td>
Stroud Solar Station
</td>
<td>
CA
</td>
<td class="right">
20.0
</td>
<td class="right">
43,066
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Eurus Energy America Corporation
</td>
<td>
57360
</td>
<td>
S0127
</td>
<td>
Sun City
</td>
<td>
CA
</td>
<td class="right">
20.0
</td>
<td class="right">
43,004
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Duke Energy Renewables
</td>
<td>
57559
</td>
<td>
S0123
</td>
<td>
Sunset Reservoir Solar
</td>
<td>
CA
</td>
<td class="right">
4.5
</td>
<td class="right">
6,827
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9108
</td>
<td>
Superior Packing Co.
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,802
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Temescal Canyon RV LLC
</td>
<td>
57656
</td>
<td>
S0133
</td>
<td>
Temescal Canyon RV LLC
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
2,609
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
56909
</td>
<td>
S9020
</td>
<td>
The Gap Inc
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9022
</td>
<td>
Tony's Fine Foods
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9109
</td>
<td>
U.S. Coast Guard
</td>
<td>
CA
</td>
<td class="right">
1.1
</td>
<td class="right">
1,841
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
58119
</td>
<td>
S9147
</td>
<td>
U.S. National Leasing LLC_(Depot Park)
</td>
<td>
CA
</td>
<td class="right">
2.5
</td>
<td class="right">
4,006
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9029
</td>
<td>
UC Merced
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
University of California San Diego
</td>
<td>
57856
</td>
<td>
S0129
</td>
<td>
UCSD Solar PV System
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
1,897
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9041
</td>
<td>
Unified School District Morgan Hill
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9138
</td>
<td>
University of San Francisco
</td>
<td>
CA
</td>
<td class="right">
2.0
</td>
<td class="right">
3,195
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
United States Marine Corps
</td>
<td>
MISSING
</td>
<td>
S0400
</td>
<td>
USMC Maintenance Officer
</td>
<td>
CA
</td>
<td class="right">
1.5
</td>
<td class="right">
1,120
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Pacific Gas & Electric (PG&E;)
</td>
<td>
57041
</td>
<td>
S0110
</td>
<td>
Vaca Dixon Solar Station
</td>
<td>
CA
</td>
<td class="right">
2.0
</td>
<td class="right">
4,211
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9115
</td>
<td>
Vallejo Sanitation and Flood Control District
</td>
<td>
CA
</td>
<td class="right">
1.2
</td>
<td class="right">
1,946
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9080
</td>
<td>
Vaquero Energy Inc.
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9084
</td>
<td>
Wal-Mart
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9018
</td>
<td>
Warmer Packing LLC
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9093
</td>
<td>
Wastewater District West County
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,635
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9143
</td>
<td>
Wawona Frozen Foods / Alluvial Project
</td>
<td>
CA
</td>
<td class="right">
2.2
</td>
<td class="right">
3,568
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9144
</td>
<td>
Wawona Frozen Foods / Cedar Project
</td>
<td>
CA
</td>
<td class="right">
2.2
</td>
<td class="right">
3,568
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
Missing
</td>
<td>
S9154
</td>
<td>
West Los Angeles VA Health Care System
</td>
<td>
CA
</td>
<td class="right">
9.0
</td>
<td class="right">
15,784
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
58244
</td>
<td>
S9058
</td>
<td>
West Valley Mission Community College
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Pacific Gas & Electric (PG&E;)
</td>
<td>
57499
</td>
<td>
S0138
</td>
<td>
Westside Solar Station
</td>
<td>
CA
</td>
<td class="right">
15.0
</td>
<td class="right">
32,302
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9040
</td>
<td>
Wines US Inc. Constellation
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Yolo County General Services
</td>
<td>
57422
</td>
<td>
S0115
</td>
<td>
Yolo County Solar Project
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
2,041
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Not Available
</td>
<td>
MISSING
</td>
<td>
S9078
</td>
<td>
Yuba College
</td>
<td>
CA
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td colspan="5">
</td>
<td class="tot">
Total
</td>
<td class="tot">
782.5
</td>
<td class="tot">
1,018,270
</td>
</tr>
</table>
<span class="bottom_right">
</span>
<span class="bottom_left">
</span>
<span class="top_right">
</span>
<span class="top_left">
</span>
<div class="cleaner">
</div>
</div>
<div class="cleaner">
</div>
<br/>
<div class="block_with_rounded_corners">
<h2>
Solar PV and Solar Thermal Electricity Production (Imported)
</h2>
<br/>
<table style="width:97%;margin-top:5px;">
<tr>
<th>
Year
</th>
<th>
Company Name
</th>
<th>
EIA
<br/>
Plant ID
</th>
<th>
CEC
<br/>
Plant ID
</th>
<th>
Plant Name
</th>
<th>
State
</th>
<th>
Capacity (MW)
</th>
<th>
Net MWh
</th>
</tr>
<tr>
<td>
2012
</td>
<td>
Agua Caliente Solar LLC
</td>
<td>
57373
</td>
<td>
S0242
</td>
<td>
Agua Caliente Solar (AZ)
</td>
<td>
AZ
</td>
<td class="right">
243.0
</td>
<td class="right">
378,105
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Copper Mountain Solar
</td>
<td>
57205
</td>
<td>
S0243
</td>
<td>
Copper Mountain I (NV)
</td>
<td>
NV
</td>
<td class="right">
58.0
</td>
<td class="right">
65,958
</td>
</tr>
<tr>
<td>
2012
</td>
<td>
Copper Mountain Solar
</td>
<td>
58017
</td>
<td>
S0244
</td>
<td>
Copper Mountain II (NV)
</td>
<td>
NV
</td>
<td class="right">
94.5
</td>
<td class="right">
73,593
</td>
</tr>
<tr>
<td colspan="5">
</td>
<td class="tot">
Total
</td>
<td class="tot">
395.5
</td>
<td class="tot">
517,656
</td>
</tr>
</table>
<span class="bottom_right">
</span>
<span class="bottom_left">
</span>
<span class="top_right">
</span>
<span class="top_left">
</span>
<div class="cleaner">
</div>
</div>
<div class="cleaner">
</div>
<br/>
<div class="block_with_rounded_corners" style="width:700px;">
<h2>
Solar PV and Solar Thermal Electricity Production
<br/>
<span style="font-size:.75em;">
(Annual Totals; Includes Imports)
</span>
</h2>
<br/>
<table style="width:97%;margin-top:5px;">
<tr>
<th>
Year
</th>
<th>
Capacity (MW)
</th>
<th>
Net MWh
</th>
</tr>
<tr>
<td>
2016
</td>
<td class="right">
11,500.1
</td>
<td class="right">
23,080,144
</td>
</tr>
<tr>
<td>
2015
</td>
<td class="right">
8,500.9
</td>
<td class="right">
18,061,557
</td>
</tr>
<tr>
<td>
2014
</td>
<td class="right">
7,053.4
</td>
<td class="right">
12,732,661
</td>
</tr>
<tr>
<td>
2013
</td>
<td class="right">
4,424.4
</td>
<td class="right">
5,500,727
</td>
</tr>
<tr>
<td style="background-color:#e8ee79">
2012
</td>
<td class="right" style="background-color:#e8ee79">
1,585.9
</td>
<td class="right" style="background-color:#e8ee79">
2,402,868
</td>
</tr>
<tr>
<td>
2011
</td>
<td class="right">
635.7
</td>
<td class="right">
1,114,650
</td>
</tr>
<tr>
<td>
2010
</td>
<td class="right">
524.9
</td>
<td class="right">
968,411
</td>
</tr>
<tr>
<td>
2009
</td>
<td class="right">
423.4
</td>
<td class="right">
857,078
</td>
</tr>
<tr>
<td>
2008
</td>
<td class="right">
407.2
</td>
<td class="right">
733,547
</td>
</tr>
<tr>
<td>
2007
</td>
<td class="right">
402.6
</td>
<td class="right">
667,958
</td>
</tr>
<tr>
<td>
2006
</td>
<td class="right">
402.6
</td>
<td class="right">
615,888
</td>
</tr>
<tr>
<td>
2005
</td>
<td class="right">
379.8
</td>
<td class="right">
660,322
</td>
</tr>
<tr>
<td>
2004
</td>
<td class="right">
379.8
</td>
<td class="right">
741,079
</td>
</tr>
<tr>
<td>
2003
</td>
<td class="right">
379.8
</td>
<td class="right">
758,520
</td>
</tr>
<tr>
<td>
2002
</td>
<td class="right">
380.0
</td>
<td class="right">
850,787
</td>
</tr>
<tr>
<td>
2001
</td>
<td class="right">
412.2
</td>
<td class="right">
836,284
</td>
</tr>
<tr>
<td>
2000
</td>
<td class="right">
N/A
</td>
<td class="right">
860,000
</td>
</tr>
<tr>
<td>
1999
</td>
<td class="right">
N/A
</td>
<td class="right">
838,000
</td>
</tr>
<tr>
<td>
1998
</td>
<td class="right">
N/A
</td>
<td class="right">
839,000
</td>
</tr>
<tr>
<td>
1997
</td>
<td class="right">
N/A
</td>
<td class="right">
810,000
</td>
</tr>
<tr>
<td>
1996
</td>
<td class="right">
N/A
</td>
<td class="right">
832,000
</td>
</tr>
<tr>
<td>
1995
</td>
<td class="right">
N/A
</td>
<td class="right">
793,000
</td>
</tr>
<tr>
<td>
1994
</td>
<td class="right">
N/A
</td>
<td class="right">
198,000
</td>
</tr>
<tr>
<td>
1993
</td>
<td class="right">
N/A
</td>
<td class="right">
857,000
</td>
</tr>
<tr>
<td>
1992
</td>
<td class="right">
N/A
</td>
<td class="right">
700,000
</td>
</tr>
<tr>
<td>
1991
</td>
<td class="right">
N/A
</td>
<td class="right">
719,000
</td>
</tr>
<tr>
<td>
1990
</td>
<td class="right">
N/A
</td>
<td class="right">
681,000
</td>
</tr>
<tr>
<td>
1989
</td>
<td class="right">
N/A
</td>
<td class="right">
471,000
</td>
</tr>
<tr>
<td>
1988
</td>
<td class="right">
N/A
</td>
<td class="right">
315,000
</td>
</tr>
<tr>
<td>
1987
</td>
<td class="right">
N/A
</td>
<td class="right">
188,000
</td>
</tr>
<tr>
<td>
1986
</td>
<td class="right">
N/A
</td>
<td class="right">
64,000
</td>
</tr>
<tr>
<td>
1985
</td>
<td class="right">
N/A
</td>
<td class="right">
33,000
</td>
</tr>
<tr>
<td>
1984
</td>
<td class="right">
N/A
</td>
<td class="right">
11,000
</td>
</tr>
<tr>
<td>
1983
</td>
<td class="right">
N/A
</td>
<td class="right">
2,000
</td>
</tr>
</table>
<span class="bottom_right">
</span>
<span class="bottom_left">
</span>
<span class="top_right">
</span>
<span class="top_left">
</span>
<div class="cleaner">
</div>
</div>
<br/>
<div class="block_with_rounded_corners" style="width:700px;">
<h2>
Solar PV and Solar Thermal Electricity Production by County
</h2>
<br/>
<table style="width:97%;margin-top:5px;">
<tr>
<th>
County
</th>
<th>
Capacity (MW)
</th>
<th>
Net MWh
</th>
</tr>
<tr>
<td>
Alameda
</td>
<td class="right">
14.5
</td>
<td class="right">
23,542
</td>
</tr>
<tr>
<td>
Butte
</td>
<td class="right">
5.2
</td>
<td class="right">
7,620
</td>
</tr>
<tr>
<td>
Calaveras
</td>
<td class="right">
1.8
</td>
<td class="right">
2,838
</td>
</tr>
<tr>
<td>
Clark
</td>
<td class="right">
152.5
</td>
<td class="right">
139,551
</td>
</tr>
<tr>
<td>
Contra Costa
</td>
<td class="right">
10.5
</td>
<td class="right">
17,181
</td>
</tr>
<tr>
<td>
Fresno
</td>
<td class="right">
124.1
</td>
<td class="right">
202,232
</td>
</tr>
<tr>
<td>
Imperial
</td>
<td class="right">
23.0
</td>
<td class="right">
28,822
</td>
</tr>
<tr>
<td>
Kern
</td>
<td class="right">
133.1
</td>
<td class="right">
30,019
</td>
</tr>
<tr>
<td>
Kings
</td>
<td class="right">
46.0
</td>
<td class="right">
97,708
</td>
</tr>
<tr>
<td>
Lake
</td>
<td class="right">
3.0
</td>
<td class="right">
4,866
</td>
</tr>
<tr>
<td>
Los Angeles
</td>
<td class="right">
42.2
</td>
<td class="right">
47,363
</td>
</tr>
<tr>
<td>
Madera
</td>
<td class="right">
2.0
</td>
<td class="right">
3,244
</td>
</tr>
<tr>
<td>
Marin
</td>
<td class="right">
1.5
</td>
<td class="right">
2,432
</td>
</tr>
<tr>
<td>
Mendocino
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
Merced
</td>
<td class="right">
5.0
</td>
<td class="right">
8,110
</td>
</tr>
<tr>
<td>
Monterey
</td>
<td class="right">
5.0
</td>
<td class="right">
8,110
</td>
</tr>
<tr>
<td>
Napa
</td>
<td class="right">
2.0
</td>
<td class="right">
3,244
</td>
</tr>
<tr>
<td>
Placer
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
Riverside
</td>
<td class="right">
38.6
</td>
<td class="right">
58,450
</td>
</tr>
<tr>
<td>
Sacramento
</td>
<td class="right">
117.3
</td>
<td class="right">
179,245
</td>
</tr>
<tr>
<td>
San Benito
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
San Bernardino
</td>
<td class="right">
484.8
</td>
<td class="right">
967,622
</td>
</tr>
<tr>
<td>
San Diego
</td>
<td class="right">
6.7
</td>
<td class="right">
9,629
</td>
</tr>
<tr>
<td>
San Francisco
</td>
<td class="right">
14.4
</td>
<td class="right">
22,849
</td>
</tr>
<tr>
<td>
San Joaquin
</td>
<td class="right">
4.0
</td>
<td class="right">
6,487
</td>
</tr>
<tr>
<td>
San Luis Obispo
</td>
<td class="right">
3.4
</td>
<td class="right">
5,555
</td>
</tr>
<tr>
<td>
Santa Clara
</td>
<td class="right">
27.0
</td>
<td class="right">
43,747
</td>
</tr>
<tr>
<td>
Santa Cruz
</td>
<td class="right">
2.5
</td>
<td class="right">
4,210
</td>
</tr>
<tr>
<td>
Shasta
</td>
<td class="right">
1.0
</td>
<td class="right">
1,620
</td>
</tr>
<tr>
<td>
Solano
</td>
<td class="right">
13.3
</td>
<td class="right">
22,603
</td>
</tr>
<tr>
<td>
Sonoma
</td>
<td class="right">
6.4
</td>
<td class="right">
10,455
</td>
</tr>
<tr>
<td>
Stanislaus
</td>
<td class="right">
28.2
</td>
<td class="right">
25,805
</td>
</tr>
<tr>
<td>
Sutter
</td>
<td class="right">
2.0
</td>
<td class="right">
3,284
</td>
</tr>
<tr>
<td>
Tehama
</td>
<td class="right">
2.0
</td>
<td class="right">
3,244
</td>
</tr>
<tr>
<td>
Tulare
</td>
<td class="right">
10.8
</td>
<td class="right">
17,833
</td>
</tr>
<tr>
<td>
Yolo
</td>
<td class="right">
5.1
</td>
<td class="right">
8,754
</td>
</tr>
<tr>
<td>
Yuba
</td>
<td class="right">
1.0
</td>
<td class="right">
1,622
</td>
</tr>
<tr>
<td>
Yuma
</td>
<td class="right">
243.0
</td>
<td class="right">
378,105
</td>
</tr>
</table>
<span class="bottom_right">
</span>
<span class="bottom_left">
</span>
<span class="top_right">
</span>
<span class="top_left">
</span>
<div class="cleaner">
</div>
</div>
<div class="cleaner">
</div>
</div>
</div>
<!-- FOOTER -->
<div id="footer">
<div>
<a href="/accessibility/">
Accessibility
</a>
|
<a href="/conditions.html">
Conditions of Use
</a>
|
<a href="/privacy.html">
Privacy Policy
</a>
|
<a href="http://m.energy.ca.gov/">
Mobile Site
</a>
|
<a class="fancybox2" href="#inline1" title="Translate this website with Google Translate">
Translate
</a>
</div>
<div>
<a href="/decisions_pending.html">
Decisions Pending and Opportunities for Public Participation
</a>
</div>
<div>
Copyright © 2018 State of California
</div>
</div>
</body>
</html>
Finding the list of years¶
If we return to the web page and explore the DOM we find that the form has an id.
Div ids are (should be) unique so we can look for this form in the DOM tree by searching for the id.
In [18]:
forms = dom.find_all(id="goYear")
forms
Out[18]:
[<select id="goYear" name="newYear"> <option value="2016">Go to a Different Year</option><option value="2016">2016</option><option value="2015">2015</option><option value="2014">2014</option><option value="2013">2013</option><option value="2012">2012</option><option value="2011">2011</option><option value="2010">2010</option><option value="2009">2009</option><option value="2008">2008</option><option value="2007">2007</option><option value="2006">2006</option><option value="2005">2005</option><option value="2004">2004</option><option value="2003">2003</option><option value="2002">2002</option><option value="2001">2001</option> </select>]
In [19]:
print(forms[0].prettify())
<select id="goYear" name="newYear"> <option value="2016"> Go to a Different Year </option> <option value="2016"> 2016 </option> <option value="2015"> 2015 </option> <option value="2014"> 2014 </option> <option value="2013"> 2013 </option> <option value="2012"> 2012 </option> <option value="2011"> 2011 </option> <option value="2010"> 2010 </option> <option value="2009"> 2009 </option> <option value="2008"> 2008 </option> <option value="2007"> 2007 </option> <option value="2006"> 2006 </option> <option value="2005"> 2005 </option> <option value="2004"> 2004 </option> <option value="2003"> 2003 </option> <option value="2002"> 2002 </option> <option value="2001"> 2001 </option> </select>
Notice that this form contains several option tags. We can find all the option tags in this form:
In [20]:
form = forms[0]
opt_tags = form.find_all("option")
opt_tags
Out[20]:
[<option value="2016">Go to a Different Year</option>, <option value="2016">2016</option>, <option value="2015">2015</option>, <option value="2014">2014</option>, <option value="2013">2013</option>, <option value="2012">2012</option>, <option value="2011">2011</option>, <option value="2010">2010</option>, <option value="2009">2009</option>, <option value="2008">2008</option>, <option value="2007">2007</option>, <option value="2006">2006</option>, <option value="2005">2005</option>, <option value="2004">2004</option>, <option value="2003">2003</option>, <option value="2002">2002</option>, <option value="2001">2001</option>]
This again returns a list of elements. Notice that each option has a value attribute that is posted in the form. Let's extract these attributes:
In [21]:
[o.attrs for o in opt_tags]
Out[21]:
[{'value': '2016'},
{'value': '2016'},
{'value': '2015'},
{'value': '2014'},
{'value': '2013'},
{'value': '2012'},
{'value': '2011'},
{'value': '2010'},
{'value': '2009'},
{'value': '2008'},
{'value': '2007'},
{'value': '2006'},
{'value': '2005'},
{'value': '2004'},
{'value': '2003'},
{'value': '2002'},
{'value': '2001'}]
The attributes are python dictionary objects so we can get the year by using the key "value"
In [22]:
years = set([o.attrs["value"] for o in opt_tags])
years
Out[22]:
{'2001',
'2002',
'2003',
'2004',
'2005',
'2006',
'2007',
'2008',
'2009',
'2010',
'2011',
'2012',
'2013',
'2014',
'2015',
'2016'}
Download All the Data¶
In the following block of code we use the years that we just collected to repeatedly query the website and download all the data for each year.
In [23]:
dfs = []
for y in years:
print("Downloading Year:", y)
# Get the data
r = requests.post("http://www.energy.ca.gov/almanac/renewables_data/solar/index.php",
data = {'newYear': y})
# Get all the tables
tables = pd.read_html(r.content)
# Get the two tables
df = extract_and_combine_pv_and_thermal(tables)
# Save the dataframe
dfs.append(df)
Downloading Year: 2008 Downloading Year: 2010 Downloading Year: 2013 Downloading Year: 2007 Downloading Year: 2002 Downloading Year: 2011 Downloading Year: 2014 Downloading Year: 2003 Downloading Year: 2005 Downloading Year: 2006 Downloading Year: 2001 Downloading Year: 2012 Downloading Year: 2004 Downloading Year: 2009 Downloading Year: 2016 Downloading Year: 2015
Combine All the Data into a single Dataframe¶
In [24]:
data = pd.concat(dfs).reset_index(drop=True)
In [25]:
data.head()
Out[25]:
| Year | Company Name | EIA Plant ID | CEC Plant ID | Plant Name | State | Capacity (MW) | Net MWh | Kind | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 2008 | Sunray Energy Inc | 10437 | S0069 | SEGS I - Retired 12/31/2015 | CA | 13.8 | 12666.0 | Thermal |
| 1 | 2008 | Sunray Energy Inc | 10438 | S0070 | SEGS II - Retired 12/31/2015 | CA | 30.0 | 30318.0 | Thermal |
| 2 | 2008 | Luz Solar Partners Ltd III | 10439 | S0071 | SEGS III | CA | 34.2 | 72360.0 | Thermal |
| 3 | 2008 | Luz Solar Partners Ltd IV | 10440 | S0072 | SEGS IV | CA | 34.2 | 72516.0 | Thermal |
| 4 | 2008 | Luz Solar Partners Ltd IX | 10446 | S0073 | SEGS IX | CA | 92.0 | 166154.0 | Thermal |
Save a Backup¶
In [26]:
data.to_csv("cal_energy_data_all_years.csv")
Finishing the Analysis¶
Let's examine the growth in the Thermal and PV energy production over the past decade.
- Construct a Pivot Table of year by kind with the entries containing the total Net MWh.
- Plot it!
In [27]:
data.pivot_table(values="Net MWh",
index="Year", columns="Kind", aggfunc="sum")
Out[27]:
| Kind | PV | Thermal |
|---|---|---|
| Year | ||
| 2001 | 2576.0 | 833708.0 |
| 2002 | 2462.0 | 848325.0 |
| 2003 | 1949.0 | 756571.0 |
| 2004 | 1956.0 | 739123.0 |
| 2005 | 1989.0 | 658333.0 |
| 2006 | 2297.0 | 613591.0 |
| 2007 | 2208.0 | 665750.0 |
| 2008 | 3395.0 | 730152.0 |
| 2009 | 16559.0 | 840520.0 |
| 2010 | 89577.0 | 878835.0 |
| 2011 | 225808.0 | 888843.0 |
| 2012 | 1018269.0 | 866941.0 |
| 2013 | 3775231.0 | 685849.0 |
| 2014 | 9100352.0 | 1623568.0 |
| 2015 | 13032887.0 | 2446285.0 |
| 2016 | 17234537.0 | 2548090.0 |
In [28]:
fig = (
data.pivot_table(values="Net MWh",
index="Year", columns="Kind", aggfunc="sum")
.plot(kind='line')
)
ax = fig.axes
plt.setp(ax.lines, marker="x")
ax.set_ylabel("Net MWh")
Out[28]:
Text(0,0.5,'Net MWh')
Interactive Plotly Visualization¶
In [29]:
import plotly.offline as py
py.init_notebook_mode(connected=False)
import plotly.graph_objs as go
import plotly.figure_factory as ff
import cufflinks as cf
cf.set_config_file(offline=False, world_readable=True, theme='ggplot')
In [30]:
(
data.pivot_table(values="Net MWh",
index="Year", columns="Kind", aggfunc="sum")
.iplot(kind='line', yTitle = "Net MWh")
)
Out[30]:
In [31]:
(
data.pivot_table(values="Capacity (MW)",
index="Year", columns="Kind", aggfunc="sum")
.iplot(kind='line', yTitle = "Total Capacity (MW)")
)
Out[31]:
Who are the big providers:
In [32]:
(
data.groupby("Plant Name")[["Capacity (MW)"]].sum()
.sort_values("Capacity (MW)")
.tail(30)
.iplot(kind='bar', yTitle = "Total Capacity (MW)")
)
Out[32]:
The big Producers:¶
- Topaz Solar (PV)
- Solar Energy Generating Systems (Thermal)
- Desert Sunlight (PV)