About this Dataset

Photovoltaic Data Acquisition (PVDAQ) Public Datasets

The NREL PVDAQ is a large-scale time-series database containing system metadata and performance data from a variety of experimental PV sites and commercial public PV sites. The datasets are used to perform on-going performance and degradation analysis. Some of the sets can exhibit common elements that effect PV performance (e.g. soiling). The dataset consists of a series of files devoted to each of the systems and an associated set of metadata information that explains details about the system hardware and the site geo-location. Some system datasets also include environmental sensors that cover irradiance, temperatures, wind speeds, and precipitation at the site.
Organization: Department of Energy
Last updated: 2025-07-31T17:39:21.813133
Tags: climate, data, degradation, duramat, energy, field-data, performance, power, pv, pv-fleets, pv-performance, pvdaq, solar, system-metadata, time-series

Tables

Available Systems Information

@usgov.doe_gov_photovoltaic_data_acquisition_pvdaq_public_datasets.available_systems_information

182 KB
1862 rows
31 columns


CREATE TABLE available_systems_information (
  "system_id" BIGINT,
  "system_public_name" VARCHAR,
  "site_location" VARCHAR,
  "timezone_or_utc_offset" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" DOUBLE,
  "dc_capacity_kw" DOUBLE,
  "kg_climate" VARCHAR,
  "pvcz_composite" BIGINT,
  "pvcz_t_rack" BIGINT,
  "pvcz_t_roof" BIGINT,
  "pvcz_humidity" BIGINT,
  "pvcz_wind" BIGINT,
  "tracking" VARCHAR,
  "type" VARCHAR,
  "azimuth" DOUBLE,
  "tilt" DOUBLE,
  "first_timestamp" TIMESTAMP,
  "last_timestamp" TIMESTAMP,
  "years" DOUBLE,
  "number_records" DOUBLE,
  "dataset_size_mb" DOUBLE,
  "available_sensor_channels" BIGINT,
  "qa_status" VARCHAR,
  "qa_issue" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR
);