Published April 9, 2021 | Version v3
Software Open

Data and codes for the publication: Decay radius of climate decision for solar panels in the city of Fresno, USA

  • 1. Potsdam Institute for Climate Impact Research, Potsdam, Germany
  • 2. Potsdam Institute for Climate Impact Research, Potsdam, Germany; Mercator Research Institute on Global Commons and Climate Change, Berlin, Germany; Department of Agriculture and Resource Economics, University of California, Berkeley, USA
  • 3. Potsdam Institute for Climate Impact Research, Potsdam, Germany; Institute of Physics, Potsdam University, Potsdam, Germany; Columbia University, New York, NY, USA

Description

This repository contains core codes and data underlying the analyses and figures from: Barton-Henry, Wenz, and Levermann (2021).The following provides a brief description of the codes and data included.

Data:

fresno_merged_solarpanel_socioeconomic_dataset.csv - This file contains the core dataset used for the all results and figures. This dataset is a result of the aggregation of the following publicly available datasets:

  • Bradbury, K. et al. Full collection: Distributed solar photovoltaic array location and extent data set for remote sensing object identification. Sci. Data https://doi.org/10.6084/m9.figshare.c.3255643.v2 (2016).
  • The County of Fresno, California. GIS Shapefiles. Fresno County GIS Portal (2020) Retrieved from: https://www.co.fresno.ca.us/ departments/public-works-planning/divisions-of-public-works-and-planning/cds/gis-shapefiles, accessed January 2020.
  • Institute of Education Science National Center for Education Statistics Education Demographic and Geographic Estimates (EDGE). School District Boundaries (2020). Retrieved from: https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries, accessed March 2020.
  • U.S. Census Bureau. 2009–2013 5-Year American Community Survey Demographic and Housing Estimates (2014). Retrieved from https://data.census.gov/cedsci/table?q=acs&tid=ACSDP5Y2013.DP05&hidePreview=false, accessed November 2020.

variable_description.csv - This file includes a short description of each variable present in the main dataset, found in the fresno_merged_solarpanel_socioeconomic_dataset.csv file. 

 

Code included, in relevant order:

figure_1.py - This script produces Figure 1, a map showing the geographic area of analysis along with the geolocations of solar panels, addresses, as well as examples of several radii over which panel density is calculated.

figure_2.py - This script produces Figure 2, as well as outputs several dataframes with the normalized panel density variables used in the further analysis of the feature importances scores.  

figure_3.py - Figure 3 is produced, as well as several .csvs containing dataframes with varying panel density radii, constructed with the normalized panel density at one radius subtracted from that of the previous.

figure_4.py - Produces Figure 4, an analysis of the influence of household income. Figures S15 and S17 of the Supplementary Information section are also created. 

models.py - This script builds the three different models tested (Random Forest, AdaBoost, and XGBoost), and calculates the feature importances scores as well as performance metrics for each. 

confusion_matrices.py - This script creates figures of the confusion matrices created from the performance output for each of the tested models, as well as the model for which panel density is omitted. These are Figures S2, S4, S6, and S7. 

ols.py - This script produces the estimates contained in Tables S7, S8, and S9, which are the results of the OLS analysis.

tract_ave_plot.py - Figures S8 and S9 are produced, showing changes in the feature importances when panel density is averaged over census tract. 

households_all.py - Analysis of the influence of density based on the number of households in each tract, resulting in Figures S11 and S12. 

tract_area_all.py - Creates Figures S13 and S14, providing the analysis of the influence of density across census tracts of varying area sizes. 

hhval_all.py - The analysis of the influence of household value is conducted, and Figure S16 is produced. 

Files

final_merged.csv

Files (221.2 MB)

Name Size Download all
md5:7fd05005902a54d4ee66cc3cfa5f0bab
8.0 kB Download
md5:a39a726baea2c3781fa5e7b816c2a8c3
5.2 kB Download
md5:ecb60f8457bd8c91da8710556a0900d2
16.9 kB Download
md5:ec5d5b1991e016bd12c6da8d34c1d2e1
14.8 kB Download
md5:b5efb694cb8e6aef9a6c9f452c7fc852
22.1 kB Download
md5:18ee6956cb984df7fdeeb8055a5c7d7b
146.6 MB Preview Download
md5:be220123c5d3ca465f36c9e95a79c52d
74.4 MB Preview Download
md5:8eee5dab25354abae0939a6467fdc56a
21.2 kB Download
md5:7c0e915b7b950bdea89f57027a139842
24.2 kB Download
md5:66a688f61f1324d7f9b16b68121a9c89
8.3 kB Download
md5:c31271d7b2c0bf2e67e42697691d07d4
3.3 kB Download
md5:6d80185340b54128307aabbc05759737
24.8 kB Download
md5:6ed9ce963f6627c1ec72b136e8dac021
18.0 kB Download
md5:3bf5c607e3929d7fb9d6635007fee193
2.9 kB Preview Download