Details for: PGE Advice 4361-G_6053-E.pdf


Click on the image for full size preview

Document data

Erik Jacobson
Director
Regulatory Relations

Pacific Gas and Electric Company
77 Beale St., Mail Code B13U
P.O. Box 770000
San Francisco, CA 94177
Fax: 415-973-3582

January 12, 2021

Advice 4361-G/6053-E
(Pacific Gas and Electric Company ID U 39 M)

Public Utilities Commission of the State of California
Subject:

Quarterly Notice on the Energy Data Request and Release Process,
Per Decision 14-05-016

Purpose
In compliance with California Public Utilities Commission (Commission or CPUC)
Decision 14-05-016, Decision Adopting Rules to Provide Access to Energy Usage and
Usage-Related Data While Protecting Privacy of Personal Data (“the Decision”), Pacific
Gas and Electric Company (PG&E) submits this Tier 1 advice letter pursuant to Ordering
Paragraph 9 of the Decision to “publicly note the transfer of information, amend its tariffs,
and update the Data Catalog.”
Background
On May 5, 2014, the Commission issued the Decision, which adopted rules that provide
access to energy usage and usage-related data to local governments, academic
researchers, and state and federal agencies when such access is consistent with state
law and the CPUC’s Privacy Rules. To facilitate this data access, the Commission
adopted a Data Request and Release Process (DRRP) that PG&E must follow when
receiving and fulfilling requests for data covered by the Decision. On September 2, 2014,
the Commission approved PG&E’s compliance Advice Letter 3501-G/4468-E
implementing the DRRP, effective August 29, 2014.
On December 1, 2014, PG&E implemented its energy data request portal. The web portal
is referred to as the Energy Data Request Program (EDRP), which has three primary
functions: 1) publishing quarterly customer energy usage reports by ZIP code, 2)
enabling an online request intake process for qualified parties to request energy usage
data from PG&E, and 3) providing information regarding the Energy Data Access
Committee (EDAC) meetings.1

1

The EDAC was formed pursuant to D.14-05-016, OPs 10 and 11.





- Page 1 -

Advice 4361-G/6053-E -2- January 12, 2021 Quarterly Notice of Transfer of Information for Q1 2020 From October 1 through December 31, 2020, PG&E fulfilled 3 data requests, all from academic researchers. Requestor Name Energy Institute at Haas Requestor Type Academic Researcher Data Transferred Anonymized usage data for the PG&E service territory. Harvard University Dept. of Economics Academic Researcher Renewable & Appropriate Energy Laboratory Academic Researcher Monthly usage, for gas and electric, and usage related data for an anonymized, randomly selected set of PG&E customers across the service territory. Dos Palos census area usage and EE program data. Comments Data was on hold for an extended period pending CCA data approval. Data available for download as of 12/30/2020. Request completed on 12/1. Data downloaded on 11/27. Request Status Completed Date Closed 12/30/2020 Downloaded 12/1/2020 Downloaded 11/27/2020
- Page 2 -

Advice 4361-G/6053-E -3- January 12, 2021 Data Request Log Update PG&E’s updated Data Request Log2 is attached to this Advice Letter. This filing will not increase any current rate or charge, cause the withdrawal of service, or conflict with any rate schedule or rule. Protests ***Due to the COVID-19 pandemic and the shelter at home orders, PG&E is currently unable to receive protests or comments to this advice letter via U.S. mail or fax. Please submit protests or comments to this advice letter to EDTariffUnit@cpuc.ca.gov and PGETariffs@pge.com*** Anyone wishing to protest this filing may do so by letter sent via U.S. mail, facsimile or Email, no later than February 1, 2021, which is 20 days after the date of this filing. Protests must be submitted to: CPUC Energy Division ED Tariff Unit 505 Van Ness Avenue, 4th Floor San Francisco, California 94102 Facsimile: (415) 703-2200 E-mail: EDTariffUnit@cpuc.ca.gov Copies of protests should also be mailed to the attention of the Director, Energy Division, Room 4004, at the address shown above. The protest shall also be sent to PG&E either via E-mail or U.S. mail (and by facsimile, if possible) at the address shown below on the same date it is mailed or delivered to the CPUC: Erik Jacobson Director, Regulatory Relations c/o Megan Lawson Pacific Gas and Electric Company 77 Beale Street, Mail Code B13U P.O. Box 770000 San Francisco, California 94177 Facsimile: (415) 973-3582 E-mail: PGETariffs@pge.com 2 The Data Request Log is referred to in the Decision as the “Data Catalog.”
- Page 3 -

Advice 4361-G/6053-E -4- January 12, 2021 Any person (including individuals, groups, or organizations) may protest or respond to an advice letter (General Order 96-B, Section 7.4). The protest shall contain the following information: specification of the advice letter protested; grounds for the protest; supporting factual information or legal argument; name, telephone number, postal address, and (where appropriate) e-mail address of the protestant; and statement that the protest was sent to the utility no later than the day on which the protest was submitted to the reviewing Industry Division (General Order 96-B, Section 3.11). Effective Date PG&E requests that this Tier 1 advice filing become effective upon date of filing, which is January 12, 2021. Notice In accordance with General Order 96-B, Section IV, a copy of this advice letter is being sent electronically and via U.S. mail to parties shown on the attached list and the parties on the service list for R.08-12-009, Phase III. Address changes to the General Order 96B service list should be directed to PG&E at email address PGETariffs@pge.com. For changes to any other service list, please contact the Commission’s Process Office at (415) 703-2021 or at Process_Office@cpuc.ca.gov. Send all electronic approvals to PGETariffs@pge.com. Advice letter filings can also be accessed electronically at: http://www.pge.com/tariffs/. /S/ Erik Jacobson Director, Regulatory Relations Attachment Attachment 1 - PG&E Updated Energy Data Request Program Data Request Log cc: Service List R.08-12-009, Phase III
- Page 4 -

ADVICE LETTER SUMMARY ENERGY UTILITY MUST BE COMPLETED BY UTILITY (Attach additional pages as needed) Company name/CPUC Utility No.: Pacific Gas and Electric Company (ID U 39 M) Utility type: ELC GAS PLC HEAT ELC = Electric PLC = Pipeline WATER Contact Person: Stuart Rubio Phone #: (415) 973-4587 E-mail: PGETariffs@pge.com E-mail Disposition Notice to: SHR8@pge.com EXPLANATION OF UTILITY TYPE GAS = Gas WATER = Water HEAT = Heat (Date Submitted / Received Stamp by CPUC) Tier Designation: 1 Advice Letter (AL) #: 4361-G/6053-E Subject of AL: Quarterly Notice on the Energy Data Request and Release Process, Per Decision 14-05-016 Keywords (choose from CPUC listing): Compliance AL Type: Monthly Quarterly Annual One-Time Other: If AL submitted in compliance with a Commission order, indicate relevant Decision/Resolution #: D.14-05-016 Does AL replace a withdrawn or rejected AL? If so, identify the prior AL: No Summarize differences between the AL and the prior withdrawn or rejected AL: N/A Confidential treatment requested? Yes No If yes, specification of confidential information: Confidential information will be made available to appropriate parties who execute a nondisclosure agreement. Name and contact information to request nondisclosure agreement/ access to confidential information: Resolution required? Yes No Requested effective date: 1/12/21 No. of tariff sheets: N/A Estimated system annual revenue effect (%): N/A Estimated system average rate effect (%): N/A When rates are affected by AL, include attachment in AL showing average rate effects on customer classes (residential, small commercial, large C/I, agricultural, lighting). Tariff schedules affected: N/A Service affected and changes proposed1: N/A Pending advice letters that revise the same tariff sheets: N/A 1 Discuss in AL if more space is needed. Clear Form
- Page 5 -

Protests and all other correspondence regarding this AL are due no later than 20 days after the date of this submittal, unless otherwise authorized by the Commission, and shall be sent to: CPUC, Energy Division Attention: Tariff Unit 505 Van Ness Avenue San Francisco, CA 94102 Email: EDTariffUnit@cpuc.ca.gov Name: Erik Jacobson, c/o Megan Lawson Title: Director, Regulatory Relations Utility Name: Pacific Gas and Electric Company Address: 77 Beale Street, Mail Code B13U City: San Francisco, CA 94177 Zip: 94177 State: California Telephone (xxx) xxx-xxxx: (415)973-2093 Facsimile (xxx) xxx-xxxx: (415)973-3582 Email: PGETariffs@pge.com Name: Title: Utility Name: Address: City: State: District of Columbia Telephone (xxx) xxx-xxxx: Facsimile (xxx) xxx-xxxx: Email: Zip: Clear Form
- Page 6 -

Advice 4361-G/6053-E January 12, 2021 Attachment 1 PG&E Updated Energy Data Request Program Data Request Log
- Page 7 -

PG&E ENERGY DATA REQUEST PROGRAM - DATA REQUEST LOG Q4 2020 UPDATE Request Number Organization Name rn2532371377 Michigan State University Status Description Date 12/30/2020 Anonymized interval usage and usage related data for Pay for Performance (P4P) program users and a random sample of non-P4P users. rn2201998501 Energy Institute at Haas Status Comments Requestor Type Academic Researcher Paused Follow up data request; paused while investigating whether the request will achieve the researcher's goals. 12/30/2020 Anonymized usage data for the PG&E service territory. Completed Data was on hold for an extended period pending CCA data approval. Data available for download as of 12/30/2020. Academic Researcher rn2004384350 City of Vacaville 12/29/2020 Data description is TBD In Review City of Vacaville has decided to go ahead with an EDRP request to supplement their Green Communities Report. Local Government rn3806961698 UC Davis ARE Department 12/28/2020 Anonymized residential customer usage and EE program data for Sonoma, Napa, Yolo, Solano, Contra Costa, Santa Clara, San Mateo, and Santa Cruz counties Paused Waiting for NDA signature Academic Researcher rn7630489143 Energy Institute at Haas 12/16/2020 Data on agricultural users' usage and Completed billing plus associated information to help identify and analyze pump usage/billing. Also pump test data, where available, from PG&E Agricultural Energy Efficiency programs. Data downloaded on 9/18 after some data transmission issues. Academic Researcher rn1621308987 The Regents of the University of Califor 12/10/2020 Detailed electric usage for Yuron, Delano, Downand Fresno. loaded File corruption issue necessitated re-uploading and re-downloading the files. This was completed on 9/4/2020. Academic Researcher rn4201540327 University of California, 12/4/2020 Sampled residential usage and usage Berkeley related data, including interval data. Approved - In Data due 1/1-15 subject to Academic Progress TSR completion. Researcher rn5615596345 Harvard University Dept. of Economics 12/1/2020 Monthly usage, for gas and electric, and Downusage related data for an anonymized, loaded randomly selected set of PG&E customers across the service territory. Request completed on 12/1 Academic Researcher rn1711985269 City of San Jose 11/27/2020 Aggregated gas and electric usage by month for the city. Paused Data is ready but is still Local waiting on San Jose signing Government the Terms of Service (TOS). rn1336412109 Renewable & Appropriate Energy Laborator 11/27/2020 Dos Palos census area usage and EE program data Downloaded Data downloaded on 11/27 Academic Researcher Page 1 of 15
- Page 8 -

Request Number Organization Name rn2777282957 Michigan State University Status Description Date 11/27/2020 Anonymized interval usage and usage related data for Pay for Performance (P4P) program users and a random sample of non-P4P users. Status Downloaded rn2361848691 University of California, 11/25/2020 Residential and Commercial customer Approved - In Davis CWEE data for a retrospective analysis on some Progress of the Department of Water Resources 2014 Water-Energy Grant programs Comments Requestor Type Data available for Academic download as of 5/22/2020 Researcher but there have been delays with MSU being ready/able to download the data and begin work. Data originally due NLT 12/31 but is on hold till successful completion of PG&E Third Party Security (TSR) process. Academic Researcher rn3196659745 Energy Institute at Haas 11/16/2020 Non-residential counterpart to rn1631519292 Approved - In Data originally due NLT Academic Progress 12/29 but was on hold for Researcher both CCA permissions and Third Party Security Review (TSR) completion; is now in queue for data delivery. rn1631519292 Energy Institute at Haas 10/23/2020 Residential usage, billing, and outage data. Approved - In Data originally due NLT Academic Progress 12/3 but was on hold for Researcher both CCA permissions and Third Party Security Review (TSR) completion; is now in queue for data delivery. rn3476045767 University of California, 8/18/2020 Interval and identifying information for all Completed Davis CWEE customers on agricultural rate schedules in zip codes specified by UCD. Also matching PG&E pump test data where available. Data downloaded on 5/22/2020. Academic Researcher rn5544655416 City of San Mateo Data sent via encrypted email on 7/2/2020. Local Government 7/8/2020 Aggregate energy savings data for the commercial sector for 2015-2019. Downloaded rn2770190546 University of California, 6/22/2020 Interval and identifying information for all DownDavis CWEE customers on agricultural rate schedules loaded in zip codes specified by UCD. Also matching PG&E pump test data where available. Initial file availability on Academic 5/20 with download on Researcher 5/22 but there were problems with two files that delayed final download till 6/22/2020. rn9657088736 Purdue University Data downloaded on 5/19 5/19/2020 Anonymized monthly usage and EE program participation data plus location data for all NEM and a sample of nonNEM customers in a list of zip codes provided by Purdue. Page 2 of 15 Downloaded Academic Researcher
- Page 9 -

Request Number Organization Name rn3089720420 City of West Sacramento Status Date 5/6/2020 Description Status Comments Requestor Type West Sacramento is using Local their Community Inventory Government instead of an EDRP report. NA Canceled / Withdrawn Average usage and billing amount per household, and total number of residential households, by county, for residential households in PG&E's service territory. Downloaded Data sent via encrypted email on 4/7/2020. Community Services & Development rn3246863720 Ca Dep. of Community Services & Dev. 4/8/2020 rn2249080588 City of Arcata 3/27/2020 Anonymized monthly residential gas usage Downloaded Data sent via encrypted email on 3/27 Local Government rn6686876109 City of Sunnyvale 3/5/2020 Total usage and number of billed days, split by commodity and residential vs. non-residential, for 2019. Downloaded Data sent on 3/5 via encrypted email. Local Government rn2499593312 City of Richmond 3/4/2020 Non-residential usage for 2014-18, by year. Canceled / Withdrawn Local Government rn1810768592 Town of Los Altos Hills 3/4/2020 NA Canceled / Withdrawn rn1063228690 Gazarian Real Estate Center, CSUF 3/2/2020 Installation date (where available) and Downaddress for all Solar installations in Fresno loaded County. Cancelled for no communication / reply from requestor. Cancelled for no communication / reply from requestor. Data delivered via encrypted email on 3/2/2020. rn1942168739 University of California Berkeley 2/20/2020 NA Canceled / Withdrawn Withdrawn by requester. Academic Researcher rn3320215259 County of Santa Barbara 2/12/2020 Aggregated energy usage data and customer counts, by sector, for City of Arcata in 2018 2/11/2020 NA Downloaded Data provided by secure email on 2/11/2020 Local Government Canceled / Withdrawn Requester is not eligible for Community the EDRP program. Services & Development rn2186072253 UCLA 1/16/2020 Anonymized monthly usage/billing and daily usage for customers with a disconnect and for a random sample of customers across 800 Zip codes. Downloaded Data provided on Academic 1/15/2020; downloaded on Researcher 1/16/2020. rn1743780563 EES Consulting, Inc. 1/14/2020 NA Canceled / Withdrawn Request is not an EDRP Local request; it is a CCA related Government request which goes through a separate team within PG&E. rn3147674377 City of San Luis Obispo 12/31/2019 NA Canceled / Withdrawn rn3124955535 County of Santa Barbara 12/31/2019 Data description never finalized. Canceled / Withdrawn Standard Community Inventory provided in lieu of EDRP request. Cancelled for inactivity; no contact in 4Q19 rn2566744986 Spring Creek Apartments Page 3 of 15 Local Government Academic Researcher Local Government Local Government
- Page 10 -

Request Number Organization Name rn2616585380 City of South San Francisco Status Description Date 10/8/2019 Aggregated monthly electric and gas consumption for 2006– 2018, split by residential vs. non-residential. Gas usage by sector by month for 201516 Status Comments Downloaded Data delivered via encrypted email on 10/8 Requestor Type Local Government Completed Data sent via encrypted email on 8/8. Local Government Local Government rn2903365842 City of Benicia 8/8/2019 rn1333815258 AMBAG Energy Watch 7/31/2019 NA Canceled / Withdrawn Request was not a valid EDRP request; directed requester to the PG&E Green Communities program, which should provide the desired data through a different route. rn7872919591 University of California, 7/31/2019 NA Santa Cruz Canceled / Withdrawn Request is not eligible for State or EDRP; directed requestor to Federal Agency the Building Benchmarking Program which would be the correct avenue for the data requested. rn4437534105 PESD; Stanford University 7/26/2019 Billing and interval data for residential Completed customers, plus street address, rate code, and CSI and EE program usage. Downloading has been Academic problematic due to size and Researcher number of files. rn1841522734 County of Marin 7/18/2019 Yearly gas and electric usage for all the cities in Marin County, split into residential and non-residential sectors. Completed Data sent by encrypted email on 7/1 Local Government rn1997400686 PESD; Stanford University 7/18/2019 Interval data from 1/1/2012 to 7/31/2018 for CSI customers and a randomly selected control group. 6/26/2019 Total usage, by month, for gas and electric, split into Res, Com, Ind, Ag sectors. 6/26/2019 Total usage and billed days, for gas and electric, split into Residential and NonResidential sectors. Canceled / Withdrawn Duplicate request. Academic Researcher Downloaded Data sent on 6/19 via encrypted email. Local Government Downloaded Data sent on 6/19 via encrypted email. Local Government rn2415181507 UCD Center for WaterEnergy Efficiency 6/24/2019 Interval and identifying information for all Downcustomers on agricultural rate schedules loaded in zip codes specified by UCD. Also matching PG&E pump test data where available. Data posted and downloaded on 6/24 Academic Researcher rn1574324146 City of Benicia 6/18/2019 Gas usage monthly, by sector. Canceled / Withdrawn rn1236401353 Duke University 4/5/2019 Downloaded Benicia is using the Local community inventory Government report in lieu of an EDRP request. Duplicate of rn2951341580 Academic Researcher rn1646873557 City of Tracy rn2495839004 City of Sunnyvale NA Page 4 of 15
- Page 11 -

Request Number Organization Name rn1947796513 University of California, Los Angeles Status Date 4/5/2019 Description Status Rejected Comments Request does not fit the requirements of the EDRP program. Data downloaded by Duke on 4/5/2019 Requestor Type Academic Researcher rn2951341580 Duke University 3/27/2019 Anonymized, random sample, residential Completed usage, billing, and program information for PG&E's service territory. rn3238390862 Department of Community Services and Dev 3/26/2019 Average Cost and Average usage for Completed Electricity and Natural Gas for all residential PG&E customers by month, separated by county. 3/15/2019 Aggregated gas and electric usage for DownUnincorporated Merced County, loaded 1/1/2016 – 12/31/2017, for residential and non-residential customers Data sent via encrypted email on 3/26/2019. Community Services & Development Data sent via encrypted email on 3/15 Local Government rn1317094882 City of Berkeley 3/15/2019 Aggregated electric and gas usage for 2018, by month. Downloaded Data sent via encrypted email on 3/14 Local Government rn2155980333 City of San Jose 3/15/2019 Electric and Gas usage, by year, by zip code for 2012-2017. Downloaded Data sent by encrypted email on 3/12. Local Government rn3005655909 City of Fremont 2/25/2019 Annual electricity and natural gas use for Completed the calendar years 2016 and 2018, separated by residential and nonresidential uses Data sent via encrypted email on 2/25 Local Government rn2616856558 UC Davis Inst. of Transportation Studies 2/21/2019 Grid data. Canceled / Withdrawn Academic Researcher rn1520369940 Stanford University 1/24/2019 Daily or Monthly usage by zip code, preferably broken down by on and off peak. Canceled / Withdrawn Request is for data not covered under the EDRP program. Requester did not provide IRB; request is considered withdrawn. rn2335006014 County of Contra Costa 1/17/2019 Annual electricity and natural gas use within the unincorporated areas of the County of Contra Costa for the calendar year 2017, separated by residential and nonresidential uses Downloaded Data delivered on 1/10/2019 after signature of Terms of Service. Local Government rn1379639998 City of Dixon 12/31/2018 NA Canceled / Withdrawn As per Dixon on 12/19, they Local are going to use Green Com Government Report instead. rn2143016002 City of Fremont 12/31/2018 Annual electricity and natural gas use within the City of Fremont for the calendar year 2017, separated by residential and nonresidential uses. Downloaded Data originally sent on Local 12/18 via encrypted email Government but could not be accessed/processed till the data was re-sent on 1/9/2019. (tracking as 1Q19 fulfillment). rn1547103014 Merced CED Department Page 5 of 15 Academic Researcher Academic Researcher
- Page 12 -

Request Number Organization Name rn5583152240 City of Piedmont Status Description Status Date 12/31/2018 Annual electricity and natural gas use Downwithin the City/Town of Piedmont for the loaded calendar year 2017, separated by residential and nonresidential uses. Comments Data sent via encrypted email on 12/6. Requestor Type Local Government rn1325525451 Alameda County 12/10/2018 Annual electricity and natural gas use within unincorporated Alameda for the calendar year 2017, separated by residential and nonresidential uses. Downloaded Data sent by encrypted Local email on 11/19. data also Government sent directly to StopWaste as per Alameda's request. rn1910761716 Alameda County 12/10/2018 Annual electricity and natural gas use for DownALL of Alameda County (14 cities and loaded unincorporated areas aggregated) for the calendar year 2017, separated by residential and nonresidential uses Data sent by encrypted Local email on 11/19. data also Government sent directly to StopWaste as per Alameda's request. rn3028842065 City of Albany 12/7/2018 Annual electricity and natural gas use Downwithin the City of Albany for the calendar loaded year 2017, separated by residential and nonresidential uses. Data sent by encrypted email on 11/19. Local Government rn2948833230 Town of Moraga 12/7/2018 Annual electricity and natural gas use within the Town of Moraga for Calendar Year 2017, separated by residential and nonresidential uses. Downloaded Data sent by encrypted email on 11/19. Local Government rn3033798488 City of El Cerrito 12/7/2018 Annual electricity and natural gas use within the City of El Cerrito for the calendar year 2017, separated by residential and nonresidential uses. Downloaded Data sent by encrypted email on 11/19. Local Government rn1616501173 City of San Pablo 12/7/2018 Annual electricity and natural gas use within the City of San Pablo for the calendar year 2017, separated by residential and nonresidential use Downloaded Data sent by encrypted email on 11/19. Local Government rn1522571019 Yale University 12/7/2018 Usage, billing, program participation, and Downlocation data for customers in a series of loaded cities determined by Yale. Data downloaded on 11/9. Academic Researcher rn6966088796 Yale Department of Economics 12/7/2018 Anonymized monthly electrical usage for Downsolar customers and for a random sample loaded of non-solar users. rn2123703228 UC Berkeley 12/7/2018 Meter level gas and electric energy usage Downdata in daily intervals (gas) or in hourly loaded intervals (electric), Climate Zone, Census Block Group, and Energy Efficiency Program Data for matched residential addresses. Initial data delivery on 10/11, but, after discussions, provided revised data on 11/5 Data received on 10/26 Page 6 of 15 Academic Researcher Academic Researcher
- Page 13 -

Request Number Organization Name Status Description Date rn3225848618 City of Fresno District 1 9/28/2018 Electricity usage for the Fresno Tower District. Status Canceled / Withdrawn Comments Requestor Type Could not agree on request Local within the bounds of the Government EDRP program. rn1508940737 City of Antioch 9/28/2018 Annual electricity and natural gas use Canceled / within the City of Antioch for the calendar Withdrawn year 2017, separated by residential and nonresidential uses The requester has asked that the data request be withdrawn Local Government rn7088501895 City of Richmond 9/28/2018 Annual electricity and natural gas use within Richmond for the calendar year 2017, separated by residential and nonresidential uses Canceled / Withdrawn Request withdrawn by the city. Local Government rn2861407492 City of San Leandro 9/28/2018 Annual electricity and natural gas use within the City of San Leandro for the calendar year 2017, separated by residential and non-residential uses. Canceled / Withdrawn Request withdrawn by the municipality. Local Government rn1187415478 City of Union City 9/28/2018 Annual electricity and natural gas use within the City/Town of [community name] for the calendar year 2017, separated by residential and nonresidential uses Canceled / Withdrawn Request withdrawn by the municipality. Local Government rn6599574183 City of Livermore 9/28/2018 Annual electricity and natural gas use within the City of Livermore for the calendar year 2017, separated by residential and nonresidential uses. Canceled / Withdrawn Request withdrawn by the city. Local Government rn2633350000 County of Santa Barbara 9/28/2018 Aggregated monthly electricity usage (kWh) and the total number of accounts for both residential and commercial (excluding industrial) users Downloaded Sent via encrypted email on Local 9/27 Government rn2492066026 County of San Luis Obispo 9/28/2018 Aggregated counts of residents on the CARE rate, by month and year for seven digit zip codes (list provided by the County). 9/26/2018 GHG reporting for the unincorporated county, not including Vandenberg AFB, for 2017 Downloaded Data due NET 9/6 and NLT 9/20. Local Government Canceled / Withdrawn EDRP is not the correct path for this data request due to data privacy issues. Local Government rn2499935458 County of Santa Barbara 9/26/2018 GHG reporting for the unincorporated county, not including Vandenberg AFB, for 2015 Canceled / Withdrawn EDRP is not the correct path for this data request due to data privacy issues. Local Government rn2603689691 County of Santa Barbara 9/26/2018 GHG reporting for the unincorporated county, not including Vandenberg AFB, for 2016 Canceled / Withdrawn EDRP is not the correct path for this data request due to data privacy issues. Local Government rn1145401281 County of Santa Barbara Page 7 of 15
- Page 14 -

Request Number Organization Name rn3004146998 University of Virginia Status Description Status Date 9/26/2018 2012-2017 Interval and billing data for Canceled / non-residential and multi-family buildings Withdrawn in Alameda, Contra Costa, San Francisco, Sacramento, San Joaquin, Santa Clara, Santa Barbara, San Mateo rn8953820705 Town of Colma 9/26/2018 Aggregated usage and emissions Canceled / information, by customer sector, by year. Withdrawn rn9909387956 Butte County 9/26/2018 Aggregated usage and emissions Canceled / information, by customer sector, by year. Withdrawn rn4049513961 City of Newark, CA 9/25/2018 Annual electricity and natural gas use within the City of Newark,CA for the calendar year 2017, separated by residential and nonresidential uses. rn1810833632 City of Walnut Creek Comments Could not resolve UVA issues with the standard NDA. Requestor Type Academic Researcher Data needs resolved with PG&E Green Communities reports. Resolved with PG&E Green Communities reports; not proceeding with request. Local Government Canceled / Withdrawn Cancelled as per Newark's request in 9/19 email. Local Government 9/25/2018 Annual electricity and natural gas use within the City of Walnut Creek for the calendar year 2017, separated by residential and nonresidential uses. Canceled / Withdrawn Cancelled as per Local municipality's request in Government Walnut Creek email of 9/19 rn5166499687 City of Pleasanton 9/25/2018 Annual electricity and natural gas use within the City of Pleasanton for the calendar year 2017, separated by residential and non-residential uses. Canceled / Withdrawn Cancelled as per municipality's request in Pleasanton email on 9/19. Local Government rn1585936019 City of Concord 9/25/2018 Annual electricity and natural gas use within the City of Concord for the calendar year 2017, separated by residential and nonresidential uses. Canceled / Withdrawn Cancelled as per municipality's request in Concord email on 9/19. Local Government rn1376754708 City of Emeryville 9/25/2018 Annual electricity and annual gas use within the City of Emeryville separated by RESIDENTIAL AND NONRESIDENTIAL USAGE. 9/25/2018 Annual electricity and natural gas use within the City of Hayward for the calendar year 2017, separated by residential and nonresidential uses. Canceled / Withdrawn Cancelled as per Local municipality's request in Government 9/19 email from Emeryville. Canceled / Withdrawn Cancelled as per municipality's request in Hayward 9/20 email. 9/19/2018 Annual electricity and natural gas use within the City of Dublin for the calendar year 2017, separated by residential and nonresidential uses. 9/19/2018 Annual electricity and natural gas use within the City of Lafayette for the calendar year 2017, separated by residential and nonresidential uses. Canceled / Withdrawn Cancelled by municipality Local on 9/17 after receipt of Government Green Communities Report. Canceled / Withdrawn Cancelled by Lafayette on Local 9/17 after receipt of Green Government Communities Report. rn3835033419 City of Hayward rn3057644206 City of Dublin rn1085457946 City of Lafayette Page 8 of 15 Local Government Local Government
- Page 15 -

Request Number Organization Name rn3244381982 County of San Luis Obispo Status Date 8/8/2018 Description Status Aggregated data on energy efficiency Downprogram and solar implementations for a loaded County specified set of seven-digit zip codes. Requestor Type Data delivered by secure Local email on 8/6 and 8/7 2018. Government rn8295270961 County of San Luis Obispo 8/8/2018 rn1883517888 UCD Center for WaterEnergy Efficiency 7/18/2018 Premise ID (anonymized), Service Agreement ID (anonymized), location information, electric rate schedule and consumption, and Energy Efficiency Program Data Downloaded CPUC notification letter sent on 5/17/2018. Data due NET 6/14 and NLT 6/28. Academic Researcher rn6806076159 Duke University 6/21/2018 2011 - 2017 annual household usage for residential customers by ZIP codes as provided by the requester, with flags for customers on Net Energy Metering rate. Downloaded Data downloaded on 6/14/2018 Academic Researcher rn2272871106 Yale University 5/30/2018 Canceled / Withdrawn 5/30/2018 Reliability study combining customer Downspecific outage data with other customer loaded characteristics for selected zip codes and a random, control sample. This is a duplicate of rn1522571019 Final data downloaded on 6/28/2018 Academic Researcher Academic Researcher 4/20/2018 Aggregate electric usage by zip code, by sector, by year. 4/12/2018 2014 - 2017 residential gas and electric usage Sent via secure email on 4/16 Delivered via secure email on 4/12. Local Government Local Government rn1535558943 Energy Institute at Haas rn7282166694 City of Arroyo Grande rn3144655839 San Francisco Dept. of Public Health Anonymized data on total monthly billed Downusage (kwh), heat type, and master meter loaded for a County specified set of seven-digit zip codes. Comments Downloaded Downloaded Data delivered by secure Local email on 8/6 and 8/7 2018. Government rn6623229345 University of California, 4/12/2018 - Residential solar customer information: DownIrvine street address or geographic coordinates. loaded Billing history, rate schedule, usage data. - Program participation: California Solar Initiative and other programs to promote sustainable energy use. Data was reformatted into Academic smaller files and resent. Researcher rn7405049065 Pacific Northwest National Laboratory Cancelled: PNNL did not meet the requirements to make a request. 4/10/2018 Electric usage and billing by census block, Canceled / plus meter type and multifamily Withdrawn information. Page 9 of 15 State or Federal Agency
- Page 16 -

Request Number Organization Name Status Description Status Date 4/10/2018 7 years historical gas billing and interval Downdata or monthly usage if interval data not loaded available, including premise addresses, for ZIP codes in Modesto: 95350, 95351, 95354, 95355, 95356, 95357, 95358, 95380, 95363, and 95368 Requestor Type Originally downloaded on Academic 3/16 and reported on 1Q18 Researcher Quarterly Notification Advice Letter. There have been two data iterations since then with the latest download on 5/25. rn1590558202 City of Hayward 3/29/2018 Customer Class, Number of Customers, DownCity, Zip Code, Commodity (Gas or loaded Electricity), Month Start Day, Month End Day, Monthly Billed Usage, Heat Type. Data is aggregated to Zip Code level. Data delivery is complete; Local was re-posted at Hayward's Government request. Reported on 1Q18 Quarterly Notification Advice Letter. rn1765829728 Energy Institute at Haas 3/21/2018 Agricultural water pumping study Downloaded Data has been reAcademic worked/expanded and was Researcher re-downloaded on 3/21. Reported on 1Q18 Quarterly Notification Advice Letter. rn2879148574 UCD Center for WaterEnergy Efficiency 2/26/2018 Canceled / Withdrawn Accidental duplicate Academic request due to Researcher misunderstanding: data is being delivered via another request rn2328740572 Purdue University 2/16/2018 Canceled / Solar PV related data including the Withdrawn precise address of each installed solar PV project in your database. rn1584608103 University of California Los Angeles rn3011011577 UCD Center for WaterEnergy Efficiency Comments Request is cancelled at Purdue's request. Academic Researcher 2/15/2018 Price of electricity (residential) for each Canceled / zip code. Description of different rate Withdrawn plans if they vary Net-metering rate by zip code Usage, location, net-metering application ID and amount of credited energy for each net-metering household Request cancelled/withdrawn by UCLA in 2/13/2018 email. Academic Researcher rn1853459519 Energy Institute at Haas 1/31/2018 DR Aggregator study: 2014 - 2017 Downresidential billing and and interval usage; loaded participation in Community Choice Aggregation, EE and DR SmartRate programs for random sample of residential customers, and total count of customers per ZIP code Was available for download Academic 11/20 and was reported Researcher 4Q17 notification letter, but system doesn't show download till Jan 2018. rn8700082351 City of Cupertino, Sustainability Div. 1/25/2018 Disaggregated, randomized, and anonymized meter level gas and electric energy usage data in monthly intervals, and data flags, grouped by census block group for specified block groups. Data delivery is complete. Reported on 1Q18 Quarterly Notification Advice Letter. Page 10 of 15 Downloaded Local Government
- Page 17 -

Request Number Organization Name rn2083094219 Tulare County Status Description Date 11/13/2017 2016 - 2017 Usage data from Tulare County's account for their government operations and aggregated community data for residential, commercial, and industrial customers in unincorporated Tulare County. Status Comments Canceled / Withdrawn Request for annual consumption for Climate Action Planning was referred to local manager to access PG&E's preformatted GHG Inventory Reports. Canceled / Withdrawn Requested data did not meet aggregation rules Requestor Type Local Government rn2286946843 Placer County CDRA 10/9/2017 Energy usage data for Unincorporated Placer County. rn2148812416 University of San Francisco 9/29/2017 All addresses in the county of San Canceled / Francisco that currently have installed Withdrawn solar PV systems connected to the PGE net metering system. What is the system capacity, date that the system was brought online and the vendor of that system. Canceled request due to no Academic response to PG&E request Researcher for additional information in May. rn2301115809 LBNL 8/21/2017 LBNL request for usage data for PACE participants Canceled / Withdrawn LBNL withdrew request. Academic Will be submitted by an Researcher eligible academic researcher and sponsoring staff professor rn2469342276 Town of Portola Valley 8/16/2017 2014 and 2015 energy usage data solar installations electric vehicles Canceled / Withdrawn Referred to PG&E's Local annually released GHG Government inventory reports on May 18 and June 28. Canceled EDRP request on August 16 due to no response. rn2351863545 City of Union City 8/16/2017 Total annual electricity and natural gas Canceled / usage data for Residential and Withdrawn Commercial/Industrial, and also for city facilities and Streetlight & Traffic Signals. Data requested for climate action or energy efficiency program planning Requester referred to PG&E's annually released GHG Inventory reports. rn3036595061 City of Oakland 8/3/2017 Canceled / Withdrawn Request was withdrawn by Local the requester. Industrial Government data did not meet 5/25 aggregation test. rn2605742428 City of Ceres 6/15/2017 2014 - 2016 annual gas consumption data Canceled / to be used for a greenhouse gas baseline Withdrawn inventory as part of the General Plan Update process. Requester was referred to Local PG&E's Green Communities Government for data already published for their GHG inventory reporting needs. 2015 community gas and electric energy use, under EDRP approved aggregation Page 11 of 15 Local Government Local Government
- Page 18 -

Request Number Organization Name rn6249204854 Carnegie Mellon University Status Description Date 5/15/2017 Sampling of 500,000 residential customers; interval usage, aggregated usage, billing data, low income program data Status Comments Canceled / Withdrawn Request withdrawn, as proposed research did not meet program requirements. CMU will work with PG&E on a different research focus and project proposal and submit a new request. Requestor Type Academic Researcher rn1190652421 City of Berkeley 4/28/2017 2013-2015 Monthly aggregated residential and non-residential electric and gas consumption by census block group or aggregated block group Downloaded Due to privacy safeguards Local pursuant to CPUC D.14-05- Government 016, some requested data was omitted. rn1978989367 University of San Francisco 4/21/2017 Data related to solar customers in San Francisco and installed PV systems Canceled / Withdrawn Additional information requested 2/13 and 4/6. Request was canceled on 4/21 due to lack of response. Academic Researcher rn2846378361 UCD Center for WaterEnergy Efficiency 4/19/2017 2005-16 monthly billing data, monthly Downand interval usage data, premise address loaded and lat/long, EE program participation, and billing start and stops dates for all agricultural customers in certain ZIP codes in Monterey, Tulare, Fresno, King counties. Data revised after UCB feedback and downloaded a second time. Academic Researcher rn9918187860 CA Dept. of Community Services and Devlo 4/14/2017 CSD submitted a "test" request Canceled / Withdrawn CSD request for customer authorized data will be fulfilled through the Low Income program and not through EDRP Community Services & Development rn1014166635 University of California, 4/11/2017 Five years monthly billing data, monthly Canceled / Davis CWEE and interval usage data, meter address Withdrawn and lat/long, and billing start and stops dates for all agricultural customers in certain ZIP codes in Monterey and Fresno counties. Canceled due to change in scope, and resubmitted. See rn2846378361 Academic Researcher rn2643721788 Duke University Energy Initiative 4/11/2017 Researcher requests monthly gas and electric billing data at the address level from 1950, 1960, 1970, 1980 and 1990. Proposal is to study current economic implications of historic housing discrimination ("redlining"). Rejected Request for data cannot be Academic granted. Stated purpose to Researcher research historic discrimination in housing does not meet D.14-05-016 program rules for customer data access. rn2395922707 City of Chico 3/24/2017 Downloaded No data was omitted 2010-2016 residential gas and electric data aggregated to census block group. Page 12 of 15 Local Government
- Page 19 -

Request Number Organization Name rn7216738438 Energy Council Status Date 2/2/2017 Description Status 2011-2016 Total aggregate gas and Canceled / electric usage for all Industrial customers Withdrawn customers, and total aggregate gas and electric usage for all Direct Access customers in Alameda County. Comments Requestor Type Energy Council DBA Local StopWaste requesting data Government for Alameda County. Advised county employee must sponsor the request through EDRP. Energy Council has withdrawn their request and seek data directly from the county. rn2152325681 City of Fremont 1/23/2017 2013/14 residential usage by ZIP, plus quarterly recurring for additional two years (electric & gas) through Q4 2016 Downloaded Q4 2016 update. Due to Local privacy safeguards pursuant Government to CPUC D.14-05-016, some requested data was omitted. rn2526685182 Town of Los Altos Hills 1/17/2017 Duplicate request. Requested data previously fulfilled. Canceled / Withdrawn DUPLICATE: Requested Local data duplicates a dataset Government already provided on 3/3/2016 (rn3604140591). Requester advised to submit a new request form if asking for new dataset rn1324270296 City of Los Altos 10/19/2016 2014 - 2015 aggregated Residential and Commercial consumption data for Climate Action Planning and public dashboard reporting. Canceled / Withdrawn Request was withdrawn by Local the requester, who was Government satisfied with the reports provided through PG&E's Green Communities Program (100% of data was available, using public aggregation standards). rn9671849224 California Energy Commission 10/12/2016 customer level, anonymous monthly Canceled / electricity and natural gas data organized Withdrawn by NAICS category and zip code within Sonoma County. State or Canceled due to no activity Federal Agency in over 12 months rn7517169316 UC Berkeley 10/12/2016 Number and electric and gas usage for residential customers at ZIP+4 in counties: Alameda Contra Costa Marin San Francisco San Mateo Santa Clara Napa Solano Sonoma Canceled due to no activity Academic in over 12 months Researcher Page 13 of 15 Canceled / Withdrawn
- Page 20 -

Request Number Organization Name rn2712145837 Menlo Spark Status Description Status Date 8/30/2016 2014-2015 annual electric and gas usage Canceled / and heat map for ZIP code 94025 Withdrawn Comments Third party not qualified under approved use cases to receive data through EDRP. Referred to public data sets for consumption by ZIP code. Requestor Type Community Services & Development rn1192746839 University of Illinois 7/11/2016 5.5 years gas and electric residential Downusage by ZIP+2, billing dates and loaded amounts, indicator for master meter, open/close account date, premise street address and lat/long, baseline territory, indicator for net metering (no usage data) Academic Researcher rn2216549945 San Francisco Planning Department 4/12/2016 2013-2014 monthly aggregated gas and Downelectric usage by U.S. Census Block Group loaded or tract level data for residential, commercial and industrial customers in the City and County of San Francisco. Local Government rn4975408526 Sonoma County Economic Development Board 4/8/2016 rn7209429924 United States Geological Survey 3/15/2016 All agricultural specific rate schedules in Rejected the Pajaro Valley (zip code 95076) including AG-1B, AG-RB and AG-RE, AGVB and AG-VE, AG-4B and AG-4E, AG-4C and AG-4F, AG-5B and AG-5E, and AG-5C and AG-5F. Requested data did not fall State or under aggregation rules. Federal Agency rn1688590292 City of Cupertino 3/7/2016 Requestor was referred to Local PG&E's Green Communities Government program. rn3604140591 Town of Los Altos Hills 3/3/2016 rn1915974747 Town of Los Altos Hills (via HEA) 2015 Renewables Capacity Canceled / Withdrawn Five years annual community electricity Canceled / and gas usage by ZIP plus 4; or if not Withdrawn possible, then ZIP plus 2, or just ZIP code. Census block data if possible. Residential aggregated interval and monthly billing gas usage for the Town of Los Altos Hills by TOT code for 2005, 2012 and 2015. 12/24/2015 Request withdrawn and resubmitted due to substantive changes in request Page 14 of 15 Downloaded Canceled / Withdrawn Canceled; referred to Local California Solar Statistics for Government public data and provided PG&E Green Communities Program contact for assistance. Local Government Withdrawn; third party Local consultant was ineligible to Government request data; request was resubmitted (rn3604140591)
- Page 21 -

Request Number Organization Name rn1940304525 Town of Los Altos Hills (via HEA) Status Description Date 12/24/2015 Request from consultant was cancelled/withdrawn; new request submitted from Los Altos Hills as the appropriate recipient. rn4108830455 City of San Jose 6/29/2015 Usage data by ZIP+4 for all SJ ZIP codes rn1972290390 County of Contra Costa 6/25/2015 Customer usage data, electric and gas, for Rejected the following NAICS codes: Warehousing (43-493000); Petroleum and coal manufacturing (32-324000); and Chemicals (32-325000), for the unincorporated area of Contra Costa County. Requested data did not fall Local under aggregation rules. Government rn2790968528 San Mateo County Energy Watch 6/24/2015 Usage data by ZIP+2 and ZIP+4, peak KW, Canceled / project costs, incentives, copay for all Withdrawn projects SMCEW has completed Requestor was referred to Local PG&E's Green Communities Government program. rn8515424281 City of Morgan Hill 6/24/2015 Energy usage (electricity and natural gas) Canceled / for City facilities, Residential, and Withdrawn Commercial/Industrial. Requestor was referred to Local PG&E's Green Communities Government program. rn1702060876 San Francisco Planning Department 6/18/2015 Monthly aggregated customer usage data Downfor specific set of ZIP codes in San loaded Francisco (electric & gas) rn3061260395 City of San Leandro 6/5/2015 Energy usage data (electricity and natural Canceled / gas) for City facilities, Residential, and Withdrawn Commercial/Industrial. Requestor was referred to Local PG&E's Green Communities Government program. rn2869404331 Santa Barbara County 6/3/2015 For 2014, my month, usage by ZIP+2 for Canceled / Non-Residential customers (by Industry Withdrawn segmentation) in the unincorporated area of County Requestor was referred to Local PG&E's Green Communities Government program. rn2093531064 County of Sonoma 4/6/2015 Usage data and GHG data Requestor was referred to Local PG&E's Green Communities Government program. rn7476807709 San Francisco Dept. of Public Health 4/3/2015 2013/14 San Francisco aggregated usage Downdata by ZIP code. loaded rn1835788791 City of Benicia 3/27/2015 Customer usage by ZIP Page 15 of 15 Status Canceled / Withdrawn Canceled / Withdrawn Canceled / Withdrawn Canceled / Withdrawn Comments Requestor Type Withdrawn; third party Local consultant was ineligible to Government request data; request was resubmitted (rn3604140591) Requestor was referred to Local PG&E's Green Communities Government program. Local Government Local Government Requestor was referred to Local PG&E's Green Communities Government program.
- Page 22 -

PG&E Gas and Electric Advice Submittal List General Order 96-B, Section IV AT&T Albion Power Company East Bay Community Energy Ellison Schneider & Harris LLP Energy Management Service Alta Power Group, LLC Anderson & Poole Engineers and Scientists of California Atlas ReFuel BART Barkovich & Yap, Inc. California Cotton Ginners & Growers Assn California Energy Commission California Hub for Energy Efficiency Financing California Alternative Energy and Advanced Transportation Financing Authority California Public Utilities Commission Calpine Cameron-Daniel, P.C. Casner, Steve Cenergy Power Center for Biological Diversity Chevron Pipeline and Power City of Palo Alto City of San Jose Clean Power Research Coast Economic Consulting Commercial Energy Crossborder Energy Crown Road Energy, LLC Davis Wright Tremaine LLP Day Carter Murphy Dept of General Services Don Pickett & Associates, Inc. Douglass & Liddell GenOn Energy, Inc. Goodin, MacBride, Squeri, Schlotz & Ritchie Green Power Institute Hanna & Morton ICF IGS Energy International Power Technology Intestate Gas Services, Inc. Kelly Group Ken Bohn Consulting Keyes & Fox LLP Leviton Manufacturing Co., Inc. Los Angeles County Integrated Waste Management Task Force MRW & Associates Manatt Phelps Phillips Marin Energy Authority McKenzie & Associates Modesto Irrigation District NLine Energy, Inc. NRG Solar Office of Ratepayer Advocates OnGrid Solar Pacific Gas and Electric Company Peninsula Clean Energy Pioneer Community Energy Redwood Coast Energy Authority Regulatory & Cogeneration Service, Inc. SCD Energy Solutions San Diego Gas & Electric Company SPURR San Francisco Water Power and Sewer Sempra Utilities Sierra Telephone Company, Inc. Southern California Edison Company Southern California Gas Company Spark Energy Sun Light & Power Sunshine Design Tecogen, Inc. TerraVerde Renewable Partners Tiger Natural Gas, Inc. TransCanada Utility Cost Management Utility Power Solutions Water and Energy Consulting Wellhead Electric Company Western Manufactured Housing Communities Association (WMA) Yep Energy
- Page 23 -