United States Utility-Scale PV Supply Curves 2023
Department of Energy
@usgov.doe_gov_united_states_utility_scale_pv_supply_curves_2023
Department of Energy
@usgov.doe_gov_united_states_utility_scale_pv_supply_curves_2023
CREATE TABLE open_access_2030_moderate_supply_curve (
"area_sq_km" DOUBLE,
"capacity_mw_ac" DOUBLE,
"capacity_mw_dc" DOUBLE,
"country" VARCHAR,
"county" VARCHAR,
"dist_km" DOUBLE,
"elevation" DOUBLE,
"latitude" DOUBLE,
"lcot" DOUBLE,
"longitude" DOUBLE,
"mean_cf_ac" DOUBLE,
"mean_cf_dc" DOUBLE,
"mean_lcoe" DOUBLE,
"reg_mult" DOUBLE,
"reinforcement_cost_per_mw" DOUBLE,
"reinforcement_dist_km" DOUBLE,
"sc_point_gid" BIGINT,
"state" VARCHAR,
"timezone" BIGINT,
"total_lcoe" DOUBLE,
"trans_cap_cost_per_mw_ac" DOUBLE
);
CREATE TABLE reference_access_2030_moderate_supply_curve (
"area_sq_km" DOUBLE,
"capacity_mw_ac" DOUBLE,
"capacity_mw_dc" DOUBLE,
"cnty_fips" BIGINT,
"country" VARCHAR,
"county" VARCHAR,
"dist_km" DOUBLE,
"elevation" DOUBLE,
"latitude" DOUBLE,
"lcot" DOUBLE,
"longitude" DOUBLE,
"mean_cf_ac" DOUBLE,
"mean_cf_dc" DOUBLE,
"mean_lcoe" DOUBLE,
"mean_res" DOUBLE,
"reg_mult" DOUBLE,
"reinforcement_cost_per_mw_ac" DOUBLE,
"reinforcement_dist_km" DOUBLE,
"sc_point_gid" BIGINT,
"state" VARCHAR,
"timezone" BIGINT,
"total_lcoe" DOUBLE,
"trans_cap_cost_per_mw_ac" DOUBLE
);
CREATE TABLE solar_pv_rev_supply_curve_column_lookup (
"rev_column" VARCHAR,
"distribute_to_public" VARCHAR,
"units" VARCHAR,
"description" VARCHAR
);
Anyone who has the link will be able to view this.